Approach for managing access to large objects in database systems using large object indexes
First Claim
1. A method for accessing a large object (LOB) that belongs to a cell in a table, the method comprising the steps of:
- building an index on a column in which the cell resides, wherein the index has a key that includes a LOB identifier;
receiving from a client a request to access the LOB;
using a LOB identifier value for said LOB to use said index to locate an index entry for said LOB;
following address information contained in said index entry to a storage containing at least a portion of said LOB; and
accessing said portion of said LOB as specified in said request.
2 Assignments
0 Petitions
Accused Products
Abstract
A method and system for accessing a large object (LOB) that belongs to a cell in a table are provided. An index is built on a column in which the cell resides. The index has a key that includes a LOB identifier. A database server receives from a client a request to access the LOB. The server uses a LOB identifier value for the LOB to traverse the index to locate an index entry for the LOB. The server then follows address information contained in the index entry to a storage containing at least a portion of the LOB and accesses the portion of the LOB as specified in the request. A method and system for tracking storage for data items are also disclosed. Within an index that is built to access the data items are stored both index entries for locating blocks that store current versions of the data items, and index entries for locating blocks that store non-current versions of the data items.
104 Citations
20 Claims
-
1. A method for accessing a large object (LOB) that belongs to a cell in a table, the method comprising the steps of:
-
building an index on a column in which the cell resides, wherein the index has a key that includes a LOB identifier; receiving from a client a request to access the LOB; using a LOB identifier value for said LOB to use said index to locate an index entry for said LOB; following address information contained in said index entry to a storage containing at least a portion of said LOB; and accessing said portion of said LOB as specified in said request. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer-readable medium carrying one or more sequences of one or more instructions for accessing a large object (LOB) that belongs to a cell in a table, the one or more sequences of one or more instructions including instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of:
-
building an index on a column in which the cell resides, wherein the index has a key that includes a LOB identifier; receiving from a client a request to access the LOB; using a LOB identifier value for said LOB to use said index to locate an index entry for said LOB; following address information contained in said index entry to a storage containing at least a portion of said LOB; and accessing said portion of said LOB as specified in said request. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
Specification