Invention Grant
US08880506B2 Leveraging structured XML index data for evaluating database queries
有权
利用结构化XML索引数据来评估数据库查询
- Patent Title: Leveraging structured XML index data for evaluating database queries
- Patent Title (中): 利用结构化XML索引数据来评估数据库查询
-
Application No.: US12580923Application Date: 2009-10-16
-
Publication No.: US08880506B2Publication Date: 2014-11-04
- Inventor: Hui Joe Chang , Thomas Baby , Zhen Hua Liu
- Applicant: Hui Joe Chang , Thomas Baby , Zhen Hua Liu
- 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: G06F17/30
- IPC: G06F17/30 ; G06F15/16

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
- US20110093485A1 LEVERAGING STRUCTURED XML INDEX DATA FOR EVALUATING DATABASE QUERIES Public/Granted day:2011-04-21
Information query