System and method for managed database query pre-optimization

Details System and method for managed database query pre-optimization System and method for managed database query pre-optimization

2006-11-28

2006-11-28

Lee, Thomas (Department: 2115)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07143078

ABSTRACT:
A system and method that manages and pre-optimizes incoming database queries by decomposing queries into component parts, and executing corresponding pre-compiled procedures. A requestor specifies search arguments and/or query options. Middle tier code cooperates with database code by decomposing the query operations into stages, one stage for each specified search argument. To improve performance, the stages are ordered such that the most selective searches are executed first, and if after any stage it is recognized that no results are possible, the search terminates without attempting further stages. As each stage is executed, a list of matching keys is maintained in the database. After completing the stages, the list is sorted as specified and returned to the middle tier, which then retrieves the details for each entity represented in the key list, and formats and returns the results to the client. Relatively complex queries may be submitted without executing ad-hoc queries.

REFERENCES:
patent: 6151602 (2000-11-01), Hejlsberg et al.
patent: 6314430 (2001-11-01), Chang
patent: 6820082 (2004-11-01), Cook et al.
patent: 6950848 (2005-09-01), Yousefi'zadeh
patent: 6961725 (2005-11-01), Yuan et al.
patent: 2003/0187841 (2003-10-01), Zhang et al.
patent: 2004/0064554 (2004-04-01), Kuno et al.

Affiliated with

Also associated with

Rating

System and method for managed database query pre-optimization does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for managed database query pre-optimization, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for managed database query pre-optimization will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3673115