发明名称 |
Index with entries that store the key of a row and all non-key values of the row |
摘要 |
A method and apparatus for efficiently storing and retrieving data in a database using index-only tables is disclosed. Storing a row of data in a database using index-only tables involves storing in a leaf node an index entry that includes a key value along with all other values in the row of data. If the row of data exceeds a predetermined size, then a portion of the row of data is stored in a user specified overflow area. Retrieving a row of data from an index-only table for a user-supplied key involves identifying a leaf node for the key, and reading a row of data from the index entry and any remaining portion from the overflow area when the row exceeds the predetermined size.
|
申请公布号 |
US6128610(A) |
申请公布日期 |
2000.10.03 |
申请号 |
US19980139526 |
申请日期 |
1998.08.25 |
申请人 |
ORACLE CORPORATION |
发明人 |
SRINIVASAN, JAGANNATHAN;FAZIO, SAMUEL DE;NORI, ANIL;DAS, SOURIPRIYA;FREIWALD, CHUCK;BANERJEE, JAYANTA |
分类号 |
G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|