US 2014/0280249 A1Published application

Predicate offload of large objects

AssigneeOracle International Corporation

InventorsVineet Marwah, Amit Ganesh, Teck Hua Lee, Hui Joe Chang

Life of this patent

Estimating the term…

Loading patent…

Abstract

In an approach, the database server generates a request for data representing rows of a table, the request identifying one or more data blocks stored on a storage system. The database server then generates metadata describing one or more filtering conditions to be applied to the rows and sends the metadata along with the request to the storage system. The storage system, when applying filtering conditions to a column containing a LOB, determines whether the LOB is stored in-line or out-of-line. If the column contains an out-of-line LOB, the storage system skips the filtering conditions on the column. If the column contains an in-line LOB, the storage system applies the filtering conditions to the column. Upon obtaining the filtered data from the storage system, the database server retrieves the data blocks for out-of-line LOBs and applies the skipped filtering conditions to create a final result set.

Claims30

Dependent claims

A method comprising:

a database server generating a request for data, the request identifying one or more data units stored in a data storage subsystem, the one or more data units representing one or more rows of a table;
the database server generating metadata describing one or more filtering conditions to be applied to the one or more rows, the one or more filtering conditions including at least a particular filtering condition requiring evaluation of column data of a particular column of the table, wherein one or more data units representing the particular column store either (a) the column data or (b) one or more references to one or more other data units that store the column data, for each row of the one or more rows;
the database server sending the request and the metadata to the data storage subsystem, wherein the metadata, when interpreted by the data storage subsystem, causes the data storage subsystem to generate filtered data based on the one or more filtering conditions and the one or more data units by, for each particular row of the one or more rows, at least:
determining for the particular row, whether the one or more data units representing the particular column stores the column data or the one or more references, and applying the particular filtering condition to the particular row only when the particular column stores the column data;
the database server receiving the filtered data from the data storage system;
wherein the method is performed by one or more computing devices.

3 more elements

A non-transitory computer-readable medium storing one or more instructions which when executed by one or more processors, cause the one or more processors to perform steps comprising:

a database server generating a request for data, the request identifying one or more data units stored in a data storage subsystem, the one or more data units representing one or more rows of a table;
the database server generating metadata describing one or more filtering conditions to be applied to the one or more rows, the one or more filtering conditions including at least a particular filtering condition requiring evaluation of column data of a particular column of the table, wherein one or more data units representing the particular column store either (a) the column data or (b) one or more references to one or more other data units that store the column data, for each row of the one or more rows;
the database server sending the request and the metadata to the data storage subsystem, wherein the metadata, when interpreted by the data storage subsystem, causes the data storage subsystem to generate filtered data based on the one or more filtering conditions and the one or more data units by, for each particular row of the one or more rows, at least:
determining for the particular row, whether the one or more data units representing the particular column stores the column data or the one or more references, and applying the particular filtering condition to the particular row only when the particular column stores the column data;
the database server receiving the filtered data from the data storage system.

2 more elements

A non-transitory computer-readable medium storing one or more instructions which when executed by one or more processors, cause the one or more processors to perform steps comprising:

a data storage subsystem receiving a request from a database server, the request identifying one or more data units stored in the data storage subsystem, the one or more data units representing one or more rows of a table;
the data storage subsystem receiving metadata from the database server describing one or more filtering conditions to be applied to the one or more rows, at least a particular filtering condition requiring evaluation of column data of a particular column of the table, wherein one or more data units representing the particular column store either (a) the column data or (b) one or more references to one or more other data units that store the column data, for each of the one or more rows;
the data storage subsystem generating filtered data by, for each particular row of the one or more rows, determining for the particular row whether the one or more data units representing the particular column stores the column data or the one or more references, and applying the particular filtering condition to the particular row only when the particular column stores the column data;
the data storage subsystem returning the filtered data to the database server.

1 more element

Dependencies are inferred from the claim text.