Storage architecture of NCOS

Support for Native Cloud Object Storage (NCOS) introduces a new multi-tiered storage architecture for table spaces that allows the native storage of data pages for data base objects (such as column-organized tables) in cloud object storage.

There are multiple components that are part of the storage architecture of a typical Db2® Warehouse deployment model. The following diagram shows that there are two compute nodes and four database partitions on each: the first compute node runs database partitions 0, 1, 2 and 3, and the second compute node runs database partitions 4, 5, 6, and 7.

There are three levels of storage of this architecture that support cloud object storage:
  • Reliable durable file storage is associated with each of the Db2 Database Partitions. This is an existing element in the Db2 Warehouse architecture that is maintained in the current generation to enable a simple path towards adoption of the object storage medium for existing databases.
  • A new layer of local storage in fast SSD and NVMe disks that are only associated with the attached compute node. This layer of storage shows a local cache for the objects in object store. There are multiple local disks, one per Db2 Database Partition. These discs show that each Db2 Database Partitions manages its own portion of the local cache independently from the others.
  • In the object storage layer, there are objects within this layer that are associated with each database partition.