Back to results
US 10,650,021 B2Granted
Managing data operations in an integrated database system
AssigneeRed Hat, Inc.
InventorsFilip Elias, Filip Nguyen
Life of this patent
Estimating the term…
Abstract
A mechanism for managing data operations in an integrated database system. The method includes receiving a request to perform a data operation and retrieving a data set from a primary data source (PDS) in view of the request. The method also includes storing the data set in a temporary data store (TDS). The method further includes performing the data operation on the stored data set in the TDS.
Claims16
A method comprising:
- receiving a request to perform a database operation on a primary database, the request comprising a database query;
- selecting, by the processing device, a temporary database from a plurality of temporary relational databases in view of an availability of the temporary relational databases to execute transactions;
- locking, by a processing device, a data set of the primary database in view of the request, wherein the locking comprises a pessimistic lock mode or an optimistic lock mode;
- storing the data set in the selected temporary database, wherein the selected temporary database comprises a plurality of rows and columns;
- causing the database operation to execute on the selected temporary database to modify a portion of the data set in the selected temporary database;
- identifying, in view of a key of the database query, a row and a column of the selected temporary database that comprise the modified portion of the data set;
- replicating, by the processing device, the modified portion of the data set from the row and the column of the selected temporary database into the primary database;
- deleting the data set in the selected temporary database;
- and
- unlocking the data set in the primary database.
7 more elements
A system comprising:
- a memory;
- a processing device, operatively coupled to the memory, to:
- receive a request to perform a database operation on a primary database, the request comprising a database query;
- select a temporary database from a plurality of temporary relational databases in view of an availability of the temporary relational databases to execute transactions;
- lock a data set of the primary database in view of the request, wherein the lock comprises a pessimistic lock or an optimistic lock;
- store the data set in the selected temporary database, wherein the selected temporary database comprises a plurality of rows and columns;
- cause the database operation to execute on the selected temporary database to modify a portion of the data set in the selected temporary database;
- identify, in view of a key of the database query, a row and a column of the selected temporary database that comprise the modified portion of the data set;
- replicate the modified portion of the data set from the row and the column of the selected temporary database into the primary database;
- delete the data set in the selected temporary database;
- and
- unlock the data set in the primary database.
9 more elements
A non-transitory machine-readable storage medium comprising data, when accessed by a processing device, cause the processing device to:
- receive a request to perform a database operation on a primary database, the request comprising a database query;
- select a temporary database from a plurality of temporary relational databases in view of an availability of the plurality of temporary relational databases to execute transactions;
- lock a data set of the primary database in view of the request wherein the locking comprises a pessimistic lock or an optimistic lock;
- store the data set in the selected temporary database, wherein the selected temporary database comprises a plurality of rows and columns;
- cause the database operation to execute on the selected temporary database to modify a portion of the data set in the selected temporary database;
- identify, in view of a key of the database query, a row and a column of the selected temporary database that comprise the modified portion of the data set;
- replicate, by the processing device, the modified portion of the data set from the row and the column of the selected temporary database into the primary database;
- delete the data set in the selected temporary database;
- and
- unlocking the data set in the primary database.
7 more elements
Dependencies are inferred from the claim text.