Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2008-07-29
2011-12-06
Vo, Tim T (Department: 2168)
Data processing: database and file management or data structures
Database and file access
Query optimization
Reexamination Certificate
active
08073843
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.
REFERENCES:
patent: 6285997 (2001-09-01), Carey et al.
patent: 7596559 (2009-09-01), Popa et al.
patent: 2003/0140308 (2003-07-01), Murthy et al.
patent: 2004/0064466 (2004-04-01), Manikutty et al.
patent: 2004/0128296 (2004-07-01), Krishnamurthy et al.
patent: 2005/0005261 (2005-01-01), Severin
patent: 2005/0055355 (2005-03-01), Murthy et al.
patent: 2005/0228792 (2005-10-01), Chandrasekaran et al.
patent: 2005/0228828 (2005-10-01), Chandrasekar et al.
patent: 2005/0229158 (2005-10-01), Thusoo et al.
patent: 2006/0041537 (2006-02-01), Ahmed
patent: 2006/0101073 (2006-05-01), Popa et al.
patent: 2006/0143557 (2006-06-01), Chan et al.
patent: 2006/0179068 (2006-08-01), Warner et al.
patent: 2006/0212420 (2006-09-01), Murthy
patent: 2006/0224564 (2006-10-01), Yu et al.
patent: 2006/0235840 (2006-10-01), Manikutty et al.
patent: 2007/0011167 (2007-01-01), Krishnaprasad et al.
patent: 2007/0016605 (2007-01-01), Murthy et al.
patent: 2007/0112813 (2007-05-01), Beyer et al.
patent: 2007/0112851 (2007-05-01), Tomic et al.
patent: 2007/0239681 (2007-10-01), Krishnaprasad et al.
patent: 2010/0030727 (2010-02-01), Chandrasekar et al.
patent: 2010/0036825 (2010-02-01), Chandrasekar
Krishnaprasad et al., “Query Rewrite for XML in Oracle XML DB,” Proceedings of the 30th VLDB Conference, 2004.
Krishnaprasad et al., “Query Rewrite for XML in Oracle XML DB,” Proceedings of the 30th VLDB Conference, 2004.
Alin Deutsch et al., “Reformulation of XML Queries and Constraints”, ICDT 2003, pp. 225-241.
Hong Su et al., “Semantic Query Optimization for XQuery over XML Streams”, Proceedings of the 31stVLDB Conference, Trondheim, Norway, 2005, pp. 277-288.
Attila Barta et al., “Benefits of Path Summaries in an XML Query Optimizer Supporting Multiple Access Methods”, Proceedings of the 31stVLDB Conference, Trondheim, Norway, pp. 133-144, 2005.
Agarwal Nipun
Chandrasekar Sivasankaran
Idicula Sam
Sthanikam Balasubramanyam
Hickman Palermo & Truong & Becker LLP
Oracle International Corporation
Sanders Aaron
Vo Tim T
LandOfFree
Mechanism for deferred rewrite of multiple XPath evaluations... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Mechanism for deferred rewrite of multiple XPath evaluations..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Mechanism for deferred rewrite of multiple XPath evaluations... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4263618