Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
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.
Bingham & McCutchen LLP
Oracle International Corporation
Wong Leslie
LandOfFree
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.
Profile ID: LFUS-PAI-O-3852301