Systems and methods of optimizing database queries for...

Details Systems and methods of optimizing database queries for... Systems and methods of optimizing database queries for...

2007-06-19

2007-06-19

Wong, Leslie (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

10137235

ABSTRACT:
Queries are optimized according to a first optimization mode by generating execution plans and selecting the lowest cost plan. Inputs optimized according to the first optimization mode, to database operations with input parameters that are inconsistent with the first optimization mode, are replaced with equivalent inputs optimized according to a second optimization mode, the second optimization mode being consistent with the input parameter. Blocking operations are eliminated from queries using a cost-based approach.

REFERENCES:
patent: 6330552 (2001-12-01), Farrar et al.
patent: 6341281 (2002-01-01), MacNicol et al.
patent: 6615203 (2003-09-01), Lin et al.
patent: 6754652 (2004-06-01), Bestgen et al.
patent: 2002/0198867 (2002-12-01), Lohman et al.
patent: 2003/0120682 (2003-06-01), Bestgen et al.
Carey, Michael J., et al., “Processing Top N and Bottom N Queries,” Bulletin of the Technical Committee on Data Engineering (Sep. 1997), vol. 20, No. 3, pp. 12-19.
Carey, Michael J., et al., “Reducing the Braking Distance of an SQL Query Engine,” Proceedings of the 24th VLDB Conference (Sep. 1998), pp. 158-169.
Donjerkovic, Donko et al., “Probabilistic Optimization of Top N Queries,” Proceedings of the 25th VLDB Conference (Sep. 1999), pp. 411-422.

Affiliated with

Also associated with

Rating

Systems and methods of optimizing database queries for... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Systems and methods of optimizing database queries for..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems and methods of optimizing database queries for... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3852301