+ Reply to Thread
Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2006
    Posts
    4

    How to design ITIL-CMDB schema

    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

  2. #2
    Join Date
    Dec 2004
    Location
    St. Joseph, MI
    Posts
    60
    There is a great bit of CI attribute guidance in the Service Support book under Annex 7c that may help give you some ideas.

  3. #3
    Join Date
    Feb 2006
    Location
    Melbourne, Australia
    Posts
    10
    I would suggest the following reading (all available on line)

    Demystifying The CMDB
    By Andrew Conry-Murray

    http://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

  4. #4
    Join Date
    Mar 2006
    Posts
    4

    CMDB metadata

    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

  5. #5
    Join Date
    Jan 2007
    Posts
    1

    www.BPMspace.org

    Have a look at "BPMspace for ITIL" www.BPMspace.org. There is an open source CMDB included as well as an example schema

    rob

  6. #6
    Join Date
    Jun 2009
    Posts
    1

    CMDB Schema

    You can design your own schema or you can used a cmdb template with the schema built in so you can be running a cmdb in days.

    www.visualcmdb.ca

    There are template schemas on the CMDB template page for applications and data centers.

    Cheers.

  7. #7
    Join Date
    Mar 2010
    Posts
    1
    You should check out PMG they have a great case studies page that shows a lot of examples of their work

  8. #8
    Join Date
    Feb 2011
    Posts
    2
    Usually people are keeping some form of administration themselves. Start there. Standardize it (by definitions, units, notations), clean the data accordingly and you got your first CMDB. Software that (a) doesn't allow you to add attributes, CITypes and relations on the fly (b) doesn't work on the web (c) doesn't have a good report tool (with data export in popular formats) is no good. If it can do that, you can expand your CMDB as needed. DON'T never, ever start Config Management without some solid Change Management.

  9. #9
    Join Date
    Dec 2006
    Posts
    47

    Configuration Management Types and Configuration Item Types

    Hi,

    Before you design your CMDB, you may want to first:

    1) Understand all the different types of of Configuration Management. Reference: "Configuration Management Types", and

    2) Understand what all the correlating Configuration Item Types are that you'll have to handle in your CMDB. Reference: "Configuration Item Types"

    Using standard industry classifications will help you 1) Understand what you're up against, 2) avoid reinventing the wheel, 3) get you and your enterprise to a solution faster, 4) make your solution as complete as possible, and 5) help keep your costs of getting to your solution as low as possible.

    I hope this helps.

    My Best,

    FG

  10. #10
    Join Date
    Dec 2006
    Posts
    47

    Configuration Management

    Hi,

    I figured it would be useful to also add a reference to the IF4IT's "Configuration Management" discipline page. Both, the glossary and all reference material has been developing rapidly, thanks to its many users.

    This type of information often comes in handy when trying to understand, design, deploy, operate and support your CMDB.

    I hope you find it useful.

    My Best,

    Frank Guerino
    Chairman
    The International Foundation for Information Technology (IF4IT)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts



Latest Headlines from Datamation