Invention Grant
- Patent Title: Leveraging structured XML index data for evaluating database queries
-
Application No.: US14513176Application Date: 2014-10-13
-
Publication No.: US10262076B2Publication Date: 2019-04-16
- Inventor: Hui Joe Chang , Thomas Baby , Zhen Hua Liu
- Applicant: Oracle International Corporation
- 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 Becker Bingham LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A query may be rewritten to leverage information stored in a structured XML index. An operator in the query may be analyzed to determine an input source database object for the operator by traversing an operator tree rooted at the operator. The path expressions associated with the operator tree may be fused together to form an effective path expression for the operator. If the effective path expression directly matches a path expression derived from the index, the query may be rewritten using references to the index. Operators in a query that have effective paths that refer to data in the same index table may be grouped together. A single subquery may be written for a group of operators. Also, a structured XML index may be used as an implied schema for indexed XML data. This implied schema may be used to optimize queries that refer to the indexed XML data.
Public/Granted literature
- US20150039642A1 Leveraging Structured XML Index Data For Evaluating Database Queries Public/Granted day:2015-02-05
Information query