Invention Grant
- Patent Title: Index structure for a relational database table
-
Application No.: US14316911Application Date: 2014-06-27
-
Publication No.: US09600507B2Publication Date: 2017-03-21
- Inventor: Lei Li , Peng Li , Xi Ning Wang , Ya Xin Wu , Ying Hua Zhou
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Cantor Colburn LLP
- Agent Dan Simek
- Priority: CN201310306279 20130719
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
Embodiments are directed to building an index structure for a relational database (RDB) table and for querying the RDB table. An aspect includes obtaining JSON documents from a RDB table, identifying JSON objects in the JSON documents and assigning identifiers for them, and building an index structure according to values in the JSON objects such that the index structure includes at least one node that records values in a JSON object and includes the identifier of the specific JSON object. Querying the RDB table includes receiving a query request including an indicator which indicates that the query is to be performed on JSON objects, and searching the index structure based on query conditions in the query request so as to determine a target JSON object that meets the query conditions.
Public/Granted literature
- US20150026189A1 INDEX STRUCTURE FOR A RELATIONAL DATABASE TABLE Public/Granted day:2015-01-22
Information query