Method, computer program product, and system of optimized...

Details Method, computer program product, and system of optimized... Method, computer program product, and system of optimized...

2007-02-27

2007-02-27

LeRoux, Etienne P (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

10744424

ABSTRACT:
A tagging tree that defines a hierarchical output data structure and relational database query operations that retrieve the data to be included in each hierarchical section is accepted and processed. A query optimizer analyzes the tagging tree to determine database query operations that can be combined into a single query command. An outer-union query command is generated to allow efficient combination of multiple query commands, some of which are predicates to others. The tagging tree is modified to replace the database queries that were combined into the outer-union query to extract data from the results set produced by the outer-union query as opposed to submitting queries to the database manager. The optimized queries can be reused an arbitrary number of times to leverage the optimizing resources that were used in their creation.

REFERENCES:
patent: 6785673 (2004-08-01), Fernandez et al.
patent: 6889226 (2005-05-01), O'Neil et al.
patent: 2004/0199524 (2004-10-01), Rys et al.
Shanmugasundaram, Jayavel et al. “Querying XML Views of Relational Data”. IBM Almaden Research Center. Proceedings of the 27thVLDB Conference, Roma, Italy, 2001.
Shanmugasundaram, Jayavel et al. “Efficiently Publishing Relational Data as XML Documents”. IBM Almaden Research Center. Proceedings of the 26thInternational Conference on Very Large Databases, Cairo, Egypt, 2000.

Affiliated with

Also associated with

Rating

Method, computer program product, and system of optimized... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method, computer program product, and system of optimized..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, computer program product, and system of optimized... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3882471