Invention Grant
- Patent Title: Techniques for managing index structures for database tables
-
Application No.: US16147128Application Date: 2018-09-28
-
Publication No.: US10860558B2Publication Date: 2020-12-08
- Inventor: Murali Vemulapati
- Applicant: Apple Inc.
- Applicant Address: US CA Cupertino
- Assignee: Apple Inc.
- Current Assignee: Apple Inc.
- Current Assignee Address: US CA Cupertino
- Agency: Dickinson Wright RLLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/22 ; G06F16/245

Abstract:
Representative embodiments enable the management of index structures for data tables within a database. The techniques can include (1) receiving a request to perform an operation (e.g., read, write, etc.) on a row identifier (ID) associated with an index structure, (2) identifying a plurality of segments that corresponds to the index structure, where each segment stores a respective bitmap, (3) identifying, based on the row ID, a logical block ID of a logical block that encompasses the row ID, (4) utilizing the logical block ID to identify, among the plurality of segments, a subset of segments encompassed by the logical block, and (5) parsing each segment of the subset of segments to identify a respective bitmap that encompasses the row ID, and (6) in response to identifying the respective bitmap: performing an operation on a bitmap value that corresponds to the row ID.
Public/Granted literature
- US20200104388A1 TECHNIQUES FOR MANAGING INDEX STRUCTURES FOR DATABASE TABLES Public/Granted day:2020-04-02
Information query