 Identifying, processing and caching object fragments in a web environment |
| FIG. 1 depicts an example of an Internet environment adaptable to the present invention. As ... |
|
| In-memory database system |
| The above-mentioned shortcomings, disadvantages and problems are addressed by the present invention,... |
|
| Internet database system |
| The present invention addresses the foregoing desires by providing an incrementally-scalable ... |
|
| System for using a dialog session context to process electronic forms data on the world wide web |
| The present invention is a processing system and method for electronic fill-out forms, wherein ... |
|
| Document management system |
| The present invention is a document management system that provides secure document collaboration, ... |
|
| Probabilistic record linkage model derived from training data |
| Computers keep and store information about each of us in databases. For example, a computer may ... |
|
| Systems and methods for the automatic segmentation and clustering of ordered information |
| The systems and methods according to this invention provide for automatic segmentation and ... |
|
| Method for boosting the performance of machine-learning classifiers |
| OF THE PREFERRED EMBODIMENTS In the following description of the preferred embodiments of the ... |
|
|
Approach for accessing large objects
| Details |
Inventors: Klein, Jonathan; Himatsingka, Bhaskar;
Assignee: Oracle International Corporation (Redwood Shores, CA)
Primary Examiner: Metjahic; Safet
Assistant Examiner: Alaubaidi; Haythim J.
Attorney, Agent or Firm: Hickman Palermo Truong & Becker LLP, Becker; Edward A.
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. |
|
DETAILED DESCRIPTION According to one aspect of the invention, a method is provided for accessing data that belongs to a particular snapshot.
According to the method, an index is used to locate an index entry associated with the data.
One or more undo records are applied to the index entry to reconstruct a non-current version of the index entry.
Location information is read from the non-current version of the index entry.
Finally, a non-current version of the data stored at a location identified by the location information is accessed, wherein both the non-current version of the index entry and the non-current version of the data belong to the particular snapshot.
According to another aspect of the invention, a method is provided for accessing large objects (LOBs) that belong to a column of a table.
According to the method, an index is built on the column, the index including index entries that contain pointers to blocks containing LOB data associated with the LOBs.
If a first parameter is set to a first value, then a locator is stored for each LOB in the table, wherein each locator includes a LOB identifier and a version number for a corresponding LOB, and LOB data is stored for each LOB out of the table.
If the first parameter is set to a second value, then a locator is stored for each LOB in the table.
Finally, LOB data is stored in the table for at least a subset of the LOBs that belong to the column.
According to another aspect of the invention, a method is provided for accessing large objects (LOBs) that belong to a column of a table.
The method includes building an index on the column, wherein the index includes index entries that contain pointers to blocks containing LOB data associated with the LOBs.
Then, a locator is stored for each LOB in the table, wherein each locator includes a LOB identifier and a version number for a corresponding LOB.
Finally, a plurality of pointers is stored within at least one cell in the column, where each pointer of the plurality of pointers points to a LOB chunk of a LOB that belongs to the cell
|
|
Databases 
