International Business Machines Corporation

Kyndryl, Inc.

Viren D Parikh

Suryanarayana K Rao

Ramesh Chandra Pathak

Arunachalam Jayaraman

Ramesh Kumar Goel

A method for creating a standby database with read/write access capability while also maintaining a data consistency with a primary database, is provided. The method includes syncing the primary database with a physical standby mirror existing on the standby database, creating a first data compartment and a second data compartment on the standby database, separate from the physical standby mirror, applying a change made to the first data object on the primary database to the corresponding first data object on the physical standby mirror; and determining whether the change should be applied to the corresponding first data object stored on the first data compartment in accordance with data merge rules associated with the first data compartment and the second data compartment.

Data compartments for read/write activity in a standby database

A database is identified, wherein the database has two or more tablespaces. A local partition and a global partition for each tablespace of the two or more tablespaces is created, wherein the created two or more global partitions are included in a global storage pool. A request to move an object to a first local partition of a first tablespace of the two or more tablespaces is received. That an amount of used space of the first local partition is above a first threshold is determined. Responsive to determining that the amount of used space of the first local partition is above the first threshold, at least a portion of the object is stored in the global storage pool.

Optimizing space management of tablespaces in database systems

Systems and methods for dynamic incremental updating of online analytical processing (OLAP) data cubes are disclosed. In embodiments, a computer-implemented method, comprises: receiving real-time transactional event data including a plurality of data fields; identifying aggregate computing functions for each of a plurality of standard query language (SQL) queries of a target data cube to be updated, wherein the target data cube is in a multidimensional form for storing OLAP data in the form of numeric values organized in fields; incrementally calculating the aggregate computing functions based on a current aggregated value obtained from an updated aggregated field database, and a value of one of the plurality of data fields; repeating the incremental calculation for each of the plurality of SQL queries to obtain updated field data for the target data cube; and updating the updated aggregated field database with the updated field data.

Dynamic incremental updating of data cubes

A computer-implemented method, system, and/or computer program product optimizes storage space usage. One or more processor, which implement a Smart Volume Manager, receive an input/output (I/O) client process that requests an I/O action from a file system storage device. In response to determining that the file system storage device is operating at 100% capacity, the Smart Volume Manager generates a dynamic virtual buffer disk group from multiple donor disk groups, and then redirects the I/O client process to the dynamic virtual buffer disk group, which is appended to the file system storage device to create an extended filesystem volume.

Growing community of inventors

Bengaluru, India

Viren D Parikh