Invention Grant
- Patent Title: Querying a cascading index that avoids disk accesses
- Patent Title (中): 查询避免磁盘访问的级联索引
-
Application No.: US12469637Application Date: 2009-05-20
-
Publication No.: US08595248B2Publication Date: 2013-11-26
- Inventor: Amit Ganesh , Juan R. Loaiza , Krishna Kunchithapadam
- Applicant: Amit Ganesh , Juan R. Loaiza , Krishna Kunchithapadam
- 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
- Agent Daniel D. Ledesma
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Techniques for maintaining a cascading index are provided. In one approach, one or more branch node compression techniques are applied to the main index of a cascading index. In an approach, a Bloom filter is generated and associated with, e.g., a branch node in the main index. The Bloom filter is used to determine whether, without accessing any leaf blocks, a particular key value exists, e.g., in leaf blocks associated with the branch node. In an approach, a new redo record is generated in response to a merge operation between two levels of the cascading index. The new redo record comprises (a) one or more addresses of blocks that are affected by the merge operation, (b) data is that being “pushed down” to a lower level of the cascading index, and (c) one or more addresses of blocks that are written to disk storage as a result of the merge operation.
Public/Granted literature
- US20090292947A1 CASCADING INDEX COMPRESSION Public/Granted day:2009-11-26
Information query