The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 06, 2016
Filed:
Nov. 17, 2006
Zhen Hua Liu, San Mateo, CA (US);
Muralidhar Krishnaprasad, Fremont, CA (US);
Hui Joe Chang, Fremont, CA (US);
Vikas Arora, San Francisco, CA (US);
Zhen Hua Liu, San Mateo, CA (US);
Muralidhar Krishnaprasad, Fremont, CA (US);
Hui Joe Chang, Fremont, CA (US);
Vikas Arora, San Francisco, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A mechanism is provided for accessing XML data in a database system using a combination of a XML Table Index table and a XML Path Index table. By using a combination of a XML Table Index and a XML Path Index, both selection access and navigational access involved in a query can be optimized. For example, the XML Table Index gives the database system an ability to readily evaluate the predicate expression, thereby improving the selection access. Moreover, in some embodiments, the selection access can be further improved by using secondary indexes on columns contained in the XML Table Index table. In a complementary manner, the XML Path Index table gives the database system an ability to navigate to a specific location given a path expression, thereby improving the navigational access. Thus, by combining both tables, both selection and navigational accesses are improved.