View source for Configuration management database

{{Short description|ITIL database used by an organization to store information about hardware and software assets}}
A '''[[Configuration management|configuration management]] database''' ('''CMDB''') is an [[ITIL]] term for a [[Database|database]] used by an organization to store information about hardware and software assets (commonly referred to as configuration items). It is useful to break down configuration items into logical layers.<ref>{{Cite web
| url=https://doc.objectgears.cz/vcd/en-US/a_models_it
| title=Configuration items layers}}</ref> This database acts as a [[Data warehouse|data warehouse]] for the organization and also stores information regarding the relationships among its assets.<ref>{{Cite web
| url=https://searchdatacenter.techtarget.com/definition/configuration-management-database
| title=What is CMDB (configuration management database)?
| date=July 2017
| publisher=TechTarget
| accessdate=2019-01-14}}</ref> The CMDB provides a means of understanding the organization's critical assets and their relationships, such as [[Information system|information system]]s, upstream sources or dependencies of assets, and the downstream targets of assets.<ref>{{Cite web
| url=https://info.axiossystems.com/cmdb-improvement-whitepaper
| title=IT: disconnected from the business?
| date=2015-11-10
| work=Axios Systems
| url-access=registration
| accessdate=2019-01-14
| archive-date=2019-12-06
| archive-url=https://web.archive.org/web/20191206124426/https://info.axiossystems.com/cmdb-improvement-whitepaper
| url-status=dead
}}</ref>

== Purpose and benefits ==
The CMDB is a fundamental component of [[ITIL]] framework's [[Configuration Management (ITSM)|Configuration Management]] process. CMDBs are used to keep track of the state of assets such as products, systems, software, facilities, people as they exist at specific points in time, and the relationship between all assets. A CMDB helps an organization understand the relationship between the components of a system and to track their configurations. The maintenance of this information allows for certain actions, such as the reconstruction of assets, to occur at any point in time. CMDBs can also be used for things like [[Philosophy:Impact evaluation|impact analysis]], root cause analysis, or [[Change management (ITSM)|change management]].

CMDB implementations often involve federation – the inclusion of data into the CMDB from other sources – such as asset management, in such a way that the source of the data retains control of the data. Federation is usually distinguished from ETL (extract, transform, load) solutions in which data is copied into the CMDB.

CMDBs can be used for many things, including but not limited to: business intelligence, software and hardware builds, inventory,<ref>{{cite web
| url=https://www.ansible.com/resources/whitepapers/ansible-in-depth
| title=Whitepaper: Ansible in Depth
| quote=There are many points of integration that can be used to extend Ansible, including: (...) inventory data retrieved from CMDB systems or cloud sources.
|url-access=registration 
| publisher=[[Software:Ansible|Ansible]]
| accessdate=2019-01-14}}</ref> impact analysis for change management,<ref>{{cite book
| last1=Sauvé
| first1=Jacques
| last2=Rebouças
| first2=Rodrigo
| last3=Moura
| first3=Antão
| last4=Bartolini
| first4=Claudio
| last5=Boulmakoul
| first5=Abdel
| last6=Trastour
| first6=David
| title=Business-Driven Decision Support for Change Management: Planning and Scheduling of Changes
| date=2006
| publisher=Springer Berlin Heidelberg
| pages=173–184
| isbn=978-3-540-47662-7| doi=10.1007/11907466_15
}}</ref> and [[Software:Incident management|incident management]].

In the context of [[ITIL]], the use of CMDBs is as part of infrastructure operations and support. The CMDB represents the authorized configuration of the significant components of the IT environment.

== Contents ==
The CMDB contains and records data that are also called configuration items (CI). It also provides details about the important attributes of CIs and the relationships between them.

=== CI attributes and data ===
Attributes captured by a CMDB vary based on CI category, and can number up to the hundreds. Some examples include:

* CI [[Unique identifier|Unique Identifier]] or Identification Code
* CI Name or Label (often, both long names and short names)
* CI Abbreviations or Acronyms
* CI Description
* CI Ownership (organizations and people)
* CI Importance

Because attributes are defined by metadata, CMDBs also contain metadata, and thus the concept overlaps with that of a [[Metadata|metadata]] repository, which is also used to more effectively run IT organizations. Configuration management addresses how the data is to be kept up to date. This has historically been a weakness of metadata repositories.

=== Relationships between CIs ===
At a minimum, relationships are often composed of a Source CI that is related to a Target CI. In the case of more advanced relationships, such as semantic relationships, it is desirable to have a descriptor between the Source CI and Target CI that helps provide context. For example, "database" is related as a "Component" of "Application Y". The descriptor is also known as a Predicate.

=== Configuration item types ===
A configuration item type (or CI type) is the [[Data type|data type]] of the element or configuration item an enterprise wishes to store within the CMDB. At a minimum, all software, hardware, network, and storage CI types are stored and tracked in a CMDB. As enterprises mature, they start to track business CI types in their CMDB, such as people, markets, products, and 3rd party entities such as vendors and partners. This allows the relationships between CIs to become more meaningful and the CMDB to become a stronger source for knowledge management.

CI types are:
*[[Engineering:Electronic hardware|Hardware]]
*[[Software]]
* Communications/Networks
* Location
* Documentation
* People (staff and contractors)

A key success factor in implementing a CMDB is the ability to automatically discover information about the CIs (auto-discovery) and track changes as they happen.

==Schematic representations==
CMDB schematic structures, also known as [[Database schema|database schema]]s, take on multiple forms. Two of the most common forms are those of a [[Relational model|relational data model]] and a [[Semantic data model|semantic data model]].

[[Relational model|Relational data models]] are based on first-order predicate logic and all data is represented in terms of tuples that are grouped into relations. In the relational model, related records are linked together with a "key", where the key is unique to an entry's data type definition.  Such relational models provide declarative methods for specifying data and queries.  In other words, users directly state what information the database contains and what information they want from it, and let the database system take care of describing data structures for storing the data and retrieval procedures for answering queries.

[[Semantic data model]]s typically rely on the resource description framework that maps the relation between a number of things through the use of relationship descriptors, giving context to how things are related to each other.

== Challenges ==
There are three specific core challenges to creating and maintaining a Configuration Management Database:

* '''Relevance''': Collecting data throughout each record's or CI's life cycle is necessary.  This means putting in processes and tools to collect the most recent changes to data as they occur.
* '''Maintenance''': Companies face constant change.  Data about CIs and the relationships between them are constantly changing.  This maintenance is a significant undertaking that is often not planned for or expected. Organisations often find this the greatest challenge.
* '''Usability''': Most CMDBs are just databases.  This means they have no traits, features, or benefits of more complex applications.  They lack tools to view data via complex visualizations or tools for advanced discovery. This means that most companies need to invest in an application layer that adds such constructs to their CMDB, which adds a layer of complexity and cost that most companies do not plan for or expect.  However, implementing features that ensure the database is up to date or allow it to interact with systems to run commands, apply updates, or deploy new applications extends the functionality and usefulness of the CMDB.

Because of the above reasons, companies usually choose to purchase their CMDBs, rather than designing, building, delivering, and supporting them themselves.

== See also ==

* [[Organization:Distributed Management Task Force|DMTF]] (CMDBf<ref>{{Cite web|title=CMDBf {{!}} DMTF|url=https://www.dmtf.org/standards/cmdbf|access-date=2021-04-21|website=www.dmtf.org}}</ref>)
* [[ITIL]]

== References ==
<references />

==External links==
* [https://tumblr.github.io/collins/ Collins: Infrastructure management for engineers]
* [https://www.objectgears.cz/files/guide-to-cmdb-solution-design Guide to CMDB solution design]

[[Category:Information technology management]]

{{Sourceattribution|Configuration management database}}