CMDB vs CMDB_CI

[Samantha Sam]

What is the difference between cmdb and cmdb_ci.

The definitions in docs dint help me to understand. Looking forward with examples.

Cheers

NK

[Kunal Varkhede]

Hi,

In Newyork version cmdb and cmdb_ci table shows parent child relationship.

Base Configuration item(cmdb) is parent of Configuration Item(cmdb_ci).

For more information just go through @Gowrisankar Sativada provided community link and knowledge Article it was helpful to you.

Thanks,

Kunal

[Samantha Sam]

In TPC (Table per Class) model, there was separate logical tables in the servicenow database. In jakarta they have incorporated table flatenning architechture. In TPP (Table Per Partition), all parent(cmdb) and children(cmdb_ci_hardware, cmdb_ci_computer etc.) are stored in a single logical table. New tables are getting created on demand basis which is known "partition". So if the single logical table is exceeding particular size limit a new partition will get created named as cmdb$par1, cmdb$par2 etc.

[Gowrisankar Sat]

Exactly, this came into place to fix the size limitation issues faced by TPC.

TPH(Hierarchy) - You can see on task table

TPP(Partition) - You can see on cmdb table

All other tables with considerate number of records follow TPC.

You can check the Model a follows from Extension Model field on sys_db_object table.