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:
Dec. 06, 2011
Filed:
Jul. 29, 2008
Sivasankaran Chandrasekar, Menlo Park, CA (US);
Balasubramanyam Sthanikam, Foster City, CA (US);
Sam Idicula, Santa Clara, CA (US);
Nipun Agarwal, Santa Clara, CA (US);
Sivasankaran Chandrasekar, Menlo Park, CA (US);
Balasubramanyam Sthanikam, Foster City, CA (US);
Sam Idicula, Santa Clara, CA (US);
Nipun Agarwal, Santa Clara, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A mechanism is provided for improving the performance of particular database queries operating on a view comprising binary-encoded XML. A determination is made about whether a XML index is available to improve the computation of XPath data before deriving an optimized execution plan for a particular query. When a XML index is not available to help expedite the computation of binary-encoded XML, then deferring the computation of the XPath data until after the view merge stage avoids unnecessary computation of XPaths that are part of the view but not needed for the particular query.