US 11,940,979 B2
Data compartments for read/write activity in a standby database
Viren D. Parikh, Bangalore (IN); Ramesh C. Pathak, Bangalore (IN); and Suryanarayana K. Rao, Bangalore (IN)
Assigned to Kyndryl, Inc., New York, NY (US)
Filed by KYNDRYL, INC., New York, NY (US)
Filed on May 27, 2020, as Appl. No. 16/884,256.
Application 16/884,256 is a continuation of application No. 15/461,688, filed on Mar. 17, 2017, granted, now 10,698,882.
Prior Publication US 2020/0293512 A1, Sep. 17, 2020
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/23 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/2365 (2019.01) [G06F 16/27 (2019.01)] 13 Claims
OG exemplary drawing
 
1. A method for creating a standby database with read/write access capability while also maintaining a data consistency with a primary database, the method comprising:
syncing, by a processor of a computing system, the primary database with a physical standby mirror existing on the standby database, wherein a first data object and a second data object written to the primary database from a live application is synced in a read only access on the physical standby mirror;
creating, by the processor, a first data compartment and a second data compartment on the standby database, the first and second data compartments being standby database instances with direct read-write capability that are separate from the physical standby mirror and created by cloning a compartment of the physical standby mirror;
applying, by the processor, a change made to the first data object on the primary database to the corresponding first data object on the physical standby mirror; and
changing, by the processor, the corresponding first data object stored on the first data compartment in accordance with data merge rules associated with the first data compartment to keep the data stored on the first data compartment updated in real-time and in sync with the physical standby mirror,
wherein the data merge rules associated with the first data compartment and the second data compartment specify which objects, tablespaces, and the schemas stored on the first data compartment and the second data compartment, respectively, should be filtered or excluded from being synchronized with the physical standby mirror to create a redo stream associated with each data compartment, and
wherein the first data compartment and the second data compartment internally dequeues the redo stream in a sequential order and remaps object identifiers of the redo stream.