Abstract: A method for a database instance associated with a database management system includes receiving a command to perform a copy or a move on a first tenant partition from a first database instance to a second database instance destination partition. The method shuts down the first tenant partition, packs tenant-dependent data into tenant-dependent tables, acquires a data definition lock that prevents changes to metadata describing the first tenant partition, obtains tenant-specific metadata of a catalog of the first database instance, packs the first database instance catalog tenant-specific metadata into the first tenant partition, locks write transactions on tenant-specific data in the first tenant partition, creates a tenant-specific snapshot of the first tenant partition, stores the tenant-specific snapshot in a storage device external to the first database instance, performs the received command, and releases both the write transaction lock and the data definition lock.

Abstract: A system includes a database instance having a data storage system with a data store area storing first and second data partitions, where the respective data partitions each include a plurality of database pages storing respective tenant-independent/-specific data and respective first/second converters associated with the respective partitions. A database management system (DBMS) to receive a request for a database object and determine whether the database object is associated with tenant-independent data or with tenant-specific data. If the database object is associated with tenant-independent data, the DBMS determines a location of first database pages associated with the database object within the first plurality of database pages based on the first converter. Or if associated with tenant-specific data, the DBMS determines a location of second database pages associated with the database object within the second plurality of database pages based on the second converter. A method is also disclosed.

Abstract: A system includes a database instance, a data storage system, and a database management system. The data storage system stores a first data partition and a second data partition. The first data partition includes a first plurality of database pages storing tenant-independent data and a first converter associated with the first partition. The second data partition includes a second plurality of database pages storing tenant-independent data and a second converter associated with the second partition.

Abstract: A system may include reading a provider database mapping of file identifiers to page numbers of the provider database, determining one or more shared database objects of the provider database based on the provider database mapping, and registering the one or more shared database objects in a local namespace of a reader database.

Abstract: A system may include a provider database, a reader database, and a database management system. The provider database may include a provider data area having a plurality of provider block addresses, and the reader database may include a reader data area having a plurality of reader block addresses, and a mapping of provider-specific identifiers to block addresses of the plurality of provider data pages and of reader-specific identifiers to block addresses of the plurality of reader data pages. The database management system may modify a database object of the reader database, the object being is associated with a provider-specific identifier; and modify the mapping to map the provider-specific identifier to a first block address of one of the plurality of reader data pages.

Abstract: A system may include a provider database, a reader database, and a database management system. The provider database may include a provider data area having a plurality of provider block addresses, and the reader database may include a reader data area having a plurality of reader block addresses, and a mapping of provider-specific identifiers to block addresses of the plurality of provider data pages and of reader-specific identifiers to block addresses of the plurality of reader data pages. The database management system may modify a database object of the reader database, the object being is associated with a provider-specific identifier; and modify the mapping to map the provider-specific identifier to a first block address of one of the plurality of reader data pages.

Abstract: A system, method, apparatus, means and computer program code for processing a request to create a snapshot version of a database are provided which include identifying a current state of a converter table, the converter table including information identifying a plurality of page identifiers and a physical location of each of the page identifiers in a data area, saving the current state of the converter table, and marking each of the plurality of page identifiers to prevent overwriting.

Abstract: A system may include reading a provider database mapping of file identifiers to page numbers of the provider database, determining one or more shared database objects of the provider database based on the provider database mapping, and registering the one or more shared database objects in a local namespace of a reader database.