The System Center Platform in Service Manager Part 2: The Model-Based Database

The System Center Platform in Service Manager Part 2: The Model-Based Database

  • Comments 4
  • Likes

This post is a continuation of the series started with The System Center Platform in Service Manager.

At the heart of the System Center common platform is the “model-based” database.  By “model” here I am talking about the kind of model used for classification not the kind of model you take pictures of.  A model in System Center is a way to describe what you are managing.  For example you could have a classification model that looks like this (click to view full size):

Model

The boxes each represent a class of things that you know about.  As you go farther down the model the classes get more specific.  For example (looking from the bottom going up) – Computer is a kind of Device which is a kind of Logical Hardware which is a kind of Logical Entity which is a kind of Configuration Item.  Each of the black lines represents “inheritance” of properties and relationships from a parent class to a child class.  The blue lines represent relationships between classes.  By creating a model like this, you can describe anything you might want to manage in your IT organization – coffee machines, overhead projectors, typewriters (what? you don’t have any of those anymore?), etc.  In fact, this modeling concept is so flexible you could use it to describe anything – football leagues/teams/players or even classify the different kinds of web sites on the Internet.

For those of you that are familiar with database design, this may seem kind of like an Entity Relationship Diagram (ERD) in some ways.  In a way, these models are the ERD for a model-based database in System Center.  These classes, properties, and relationships can all be declared in management packs like this (click to see full size):

Work Item Class

Work Item to Work Item Relationship Type 

When a management pack containing class, property, and relationship elements is imported into a model-based database in a System Center product, the database schema itself is extended.  A new table is added for each class and each property becomes a column in that table.  Now data about those classes, properties, and relationships can be stored in the model-based database.  For example, if you had 3,000 computers in your organization you could store them on the System.Computer table in the model-based database.

This model-based database technology is very powerful because it allows Microsoft, partners, and customers to easily extend the database behind System Center products to add new classes (tables), properties (columns), and relationships.   You can extend classes that Microsoft provides by adding new properties or relationships or make entirely new ones by creating a management pack and importing it.  If you decide that you no longer want to keep track of that kind of data you can uninstall the management pack which will cleanly remove the database schema extensions created by that management pack.

This model-based database is used in several System Center products.  The OperationsManager database used in System Center Operations Manager and System Center Essentials is an example of this model-based database.  System Center Service Manager uses this model-based database in two places – the ServiceManager (note: in Beta 1 this database is called SMDB) database and the DWStagingAndConfig (note: in Beta1 this database is called DWSMDB) database mentioned in Chad’s Data Warehouse and Reporting post recently.  The ServiceManager database is sometimes referred to as the “CMDB”.  It is the central store of all configuration items and work items managed by Service Manager.  It also stores all the customizations and configuration for the Service Manager product itself.  DWStagingAndConfig stores the configuration for the data warehouse and is used as a temporary place to stage the data as it moves from the ServiceManager database into the other parts of the data warehouse (DWRepository and DWDataMart).

So – here are the first two pieces of the Service Manager architecture puzzle at full scale – the model-based databases ‘ServiceManager’ and ‘DWStagingAndConfig’.

ServiceManager Database   DWStagingAndConfig Database

Try it out using the information in this blog post

Come back for the next piece of the puzzle next week – the “SDK Service”.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • There is a great post by Travis Wright on the Service Manager model-based database on the SM team blog:

  • This is a continuation of the ‘The System Center Platform in Service Manager’ series. Previous posts:

  • The System Center Platform in Service Manager Part 3: The System Center Data Access Service This is a

  • Hi I am Ketan Ghelani, Program Manager on the Service Manager Team responsible for Incident and Problem