Invention Grant
- Patent Title: Partial key indexes
- Patent Title (中): 部分关键指标
-
Application No.: US11956287Application Date: 2007-12-13
-
Publication No.: US08429133B2Publication Date: 2013-04-23
- Inventor: Tirthankar Lahiri , Dheeraj Pandey , Juan R. Loaiza , Michael Zoll , Kiran B. Goyal , Neil J. S. Macnaughton
- Applicant: Tirthankar Lahiri , Dheeraj Pandey , Juan R. Loaiza , Michael Zoll , Kiran B. Goyal , Neil J. S. Macnaughton
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong Becker Bingham Wong LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30

Abstract:
A partial reverse key index is described, which allows distributed contention as resources vie to insert data into an index as well as allows range scans to be performed on the index. To do so, before an index entry for a key value is inserted into an index, the key value is transformed using a transformation operation that affects a subset of the order of the key value. The index entry is then inserted based on the transformed key value. Because the transformation operation affects the order of the key value, the transformed values associated with two consecutive key values will not necessarily be consecutive. Therefore, the index entries associated with the consecutive key values may be inserted into unrelated portions of the index.
Public/Granted literature
- US20090157701A1 PARTIAL KEY INDEXES Public/Granted day:2009-06-18
Information query