Dual access to concurrent data in a database management system
AssigneeSap SE
InventorsSang Yong Hwang, Ki Hong Kim, Sung Heun Wi, Sang Kyun Cha
Life of this patent
Estimating the term…
Abstract
Various embodiments include one or more of systems, methods, software, and data structures that allow dual access to concurrent data in a database management system including uncommitted updated data. Some embodiments include a dual snapshot of data in a multi-version concurrency control style database, but the embodiments described herein are equally applicable to virtually any other type of database and database management system.
Claims18
A method comprising:
- receiving a database query language statement to initiate a read-only transaction within a database management system and an indicator specifying that uncommitted data item values modified in other transactions are to be read within the read-only transaction;
- initiating the read-only transaction within the database management system;
- and
- taking a data snapshot of a most recently modified data item values of data items specified in the query language statement for use within the read-only transaction and holding the data snapshot in memory.
A non-transitory computer-readable medium with instructions thereon which when processed by a suitably configured computing device causes the computing device to:
- receive a database query language statement to initiate a read-only transaction within a database management system and an indicator specifying to use either committed or uncommitted data item values of data items specified in the query language statement;
- initiate the read-only transaction within the database management system;
- when the query language statement specifies that uncommitted data item values modified in other transactions are to be read within the read-only transaction, take a data snapshot of a most recently modified data item values specified in the query language statement for use within the read-only transaction and hold the data snapshot in memory;
- when the query language statement specifies that only committed data item values are to be read within the read-only transaction, take a data snapshot of committed values of data items specified in the query language statement for use within the read-only transaction and hold the data snapshot in memory.
A system comprising:
- one or more data storage devices;
- a database management system to manage data stored in at least one of the one or more data storage devices, the database management system operable to:
- receive a database query language statement to initiate a read-only transaction within the database management system and an indicator specifying that uncommitted data item values modified in other transactions are to be read within the read-only transaction;
- initiate the read-only transaction within the database management system;
- and
- take a data snapshot of a most recently modified data item values of data items specified in the query language statement for use within the read-only transaction and holding the data snapshot in memory.
Dependencies are inferred from the claim text.