US 2009/0157623 A1Published application

Pipelining operations involving dml and query

AssigneeOracle International Corporation

InventorsHarmeek Singh Bedi, Richard Yu Gu

Life of this patent

Estimating the term…

Loading patent…

Abstract

Techniques are described herein for supporting pipelining operations involving DML (Data manipulation Language) and query. In an embodiment, a DML operation is performed for the purpose of changing data in a database system from a first state to a second state. Before the data in the database system is changed by the DML operation, the DML operation has an in-memory representation of such data. In an embodiment, a subsequent query operation that logically depends on the data in the database system in the second state is granted access to the in-memory representation of such data in the second state before the data in the database system is changed by the DML operation to the second state. As a result, operations may be executed in a pipelined fashion with minimum blocking.

Claims20

Dependent claims

A computer-implemented method of pipelining operations involving one or more data manipulation operations, the method comprising:

performing a first operation that is to change data in one or more database structures in a database system from a first state to a second state, wherein the first operation is a data manipulation operation in a series of operations;
and
granting a second operation access to an in-memory representation of the data in the one or more database structures in the database system in the second state prior to a first time when the data in the one or more database structures in the database system is changed by the first operation to the second state, wherein the second operation is a query operation in the series of operations and wherein the second operation logically depends on the data in the one or more database structures in the database system in the second state;
wherein each of the data structures in the database system is a relational data structure;
wherein each operation in the series of operations has a one-to-one correspondence with each relational database statement in a series of relational database statements;
and
wherein results of the series of operations can be alternatively obtained by executing the series of relational database statements.

4 more elements

A computer readable storage medium for storing one or more sequences of instructions, when executed by one or more processors, cause:

performing a first operation that is to change data in one or more database structures in a database system from a first state to a second state, wherein the first operation is a data manipulation operation in a series of operations;
and
granting a second operation access to an in-memory representation of the data in the one or more database structures in the database system in the second state prior to a first time when the data in the one or more database structures in the database system is changed by the first operation to the second state, wherein the second operation is a query operation in the series of operations and wherein the second operation logically depends on the data in the one or more database structures in the database system in the second state;
wherein each of the data structures in the database system is a relational data structure;
wherein each operation in the series of operations has a one-to-one correspondence with each relational database statement in a series of relational database statements;
and
wherein results of the series of operations can be alternatively obtained by executing the series of relational database statements.

4 more elements

Dependencies are inferred from the claim text.