• 
• Forum
• IT Service Management
• How to design ITIL-CMDB schema

Thread: How to design ITIL-CMDB schema

1. 03-21-2006 02:10 AM #1

   thirumaran

   • View Profile
   • View Forum Posts

   Registered User

   Join Date

   Mar 2006

   Posts

   4

   How to design ITIL-CMDB schema

   Tweet

   
   
   Hi all,
   
   I am New to ITIL - CMDB database . I had read some articles about CI's ,etcc..
   
   My question is how to design the schema for ITIL-CMDB DATABASE.
   
   Any sample CMDB schema will be much helpfull.
   
   Thanks
   Thirumaran

   Reply With Quote

   ---

2. 03-21-2006 05:58 AM #2

   gspaff

   • View Profile
   • View Forum Posts
   • Visit Homepage

   Registered User

   Join Date

   Dec 2004

   Location

   St. Joseph, MI

   Posts

   60

   Tweet

   
   
   There is a great bit of CI attribute guidance in the Service Support book under Annex 7c that may help give you some ideas.

   Reply With Quote

   ---

3. 04-03-2006 08:29 AM #3

   rjp

   • View Profile
   • View Forum Posts

   Registered User

   Join Date

   Feb 2006

   Location

   Melbourne, Australia

   Posts

   10

   Tweet

   
   
   I would suggest the following reading (all available on line)
   
   Demystifying The CMDB
   By Andrew Conry-Murray
   
   www.itarchitect.com/shared/ar...leId=166400731
   
   (A short clearly written summary of some of the challenges, and the (almost) current state of play. - Note Andrew's reference to the CIM standard 'Common Information Model' by the Data Management Task Force. If you are serious about designing a meta-data schema for a CMDB - don't! The CIM has every attribute and relationship you are likely to need for a long time already defined and documented. But not for the faint-hearted )
   
   The primary objective of your CMDB should be that it shows the dependencies of the components of your infrastructure. Relationship attributes are more important than descriptive ones. But not just any realtionships - the final result should show each CI as a production factor of the Services you provide.
   
   To this end the ITIL Service Level Management chapter recommends recording your Services in CIs in your CMDB. These should be the top level of the CMDB, and everything else mapped into them. To do this you will need to effectively define classify and model your services. To that end I recommend you look for a Pink Elephant whitepaper called:
   
   Defining, Modeling & Costing IT Services
   (Integrating Service Level, Configuration & Financial Management Processes)
   
   Which is a good run up to how the real value of the CMDB lies in cordinating it with a simple service definition and classification model. Which would provide the meta-data schema for classifying Service CI attributes.
   
   Which brings me to the final point. The CMDB is more than a collection of CIs with status attributes attached. It is a management tool and as such many of the structures that should be contained in it are actually 'arbitrary' collections of components that need to be controlled as 'systems' or 'applications' and etc. This means the CMDB has to be able to represent the infrastructure through more than one abstract model. (I recommend, component, system, and service layers). An upshot of this is that different 'kinds' of CI's will be necessary, (and not just to cover the differences between hardware, software and documentation), and with that different attributes. This means a normalised relational DB may not be the most effective representation. Expect a functioning CDMB to push RDBMS implementation to its limits.
   
   But not to ignore you post, and to get back to the point, try and find:
   
   Modeling the IT Enterprise Infrastructure
   An IT Service Management Approach
   by David Chui and D. L. Tsui
   
   (Sorry I couldn't remember a URL or site for this one, but I am sure the proverbial Google search will bring it up pretty quickly. It is an excellent discussion of how to structure the basic relationships of a CMDB.)
   
   Good luck

   Reply With Quote

   ---

4. 07-13-2006 05:58 AM #4

   thirumaran

   • View Profile
   • View Forum Posts

   Registered User

   Join Date

   Mar 2006

   Posts

   4

   CMDB metadata

   Tweet

   
   
   Hi all,
   
   Can you please explain what metadat is allabout with respect to CMDB .In what form will CMDB metadata be presented (like DB tables or XML or any other format)
   
   Appreciate if you can provide with a example
   
   Thanks
   Thirumaran