Database index validation mechanism

Details Database index validation mechanism Database index validation mechanism

2007-09-18

2007-09-18

Pham, Khanh B. (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

09703909

ABSTRACT:
A method evaluates a plurality of candidate index sets for a workload of database statements in a database system by first generating baseline statistics for each statement in the workload. An index superset is formed by combining an existing or current index set and a proposed index set. A candidate index set is derived from the index superset, the candidate index being one of the plurality of candidate index sets. Statistics for a statement are generated by first creating an execution plan which represents an efficient series of steps for executing the statement given the candidate index set. The execution plan is evaluated, and statistics based on the evaluation of the execution plan are generated and recorded. The cost of the execution plan is then determined and statistics are generated. Statistics for each candidate index set are rolled up and presented to a user or an index tuning mechanism.

REFERENCES:
patent: 5404510 (1995-04-01), Smith et al.
patent: 5915249 (1999-06-01), Spencer
patent: 5924088 (1999-07-01), Jakobsson et al.
patent: 5926813 (1999-07-01), Chaudhuri et al.
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6021405 (2000-02-01), Celis et al.
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 6266658 (2001-07-01), Adya et al.
patent: 6356891 (2002-03-01), Agrawal et al.
patent: 6363371 (2002-03-01), Chaudhuri et al.
patent: 6366903 (2002-04-01), Agrawal et al.
patent: 6370522 (2002-04-01), Agarwal et al.
Surajit Chaudhuri and Kyuseck Shim. “Optimization of Queries with User-Defined Predicates”. ACM Transactions on Database Systems vol. 24 No. 2. Jun. 1999. pp. 177-228.
Michael Siegel, Edward Sciore, and Sharon Salveter. “A Method for Automatic Rule Derivation to Support Semantic Query Optimization”. ACM Transactions on Database Systems. vol. 17 No. 4. Dec. 1992. pp. 563-600.
David Lomet, Roger Barga, Surajit Chaudhuri, and Paul Larson. “The Microsoft Database Research Group”. SIGMOD Record, vol. 27, No. 3. Sep. 1998, pp. 81-85.
Gurry et al. Oracle Performance Tuning. 1996. O'Reilly. Second Edition. pp. 98-104, 138-150, 183-190, 353-356.
Finkelstein et al., “Physical Database Design for Relational Database”, ACM transaction on Database System, vol. 13, No. 1, Mar. 1988, pp. 91-128.

Affiliated with

Also associated with

Rating

Database index validation mechanism does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database index validation mechanism, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database index validation mechanism will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3730731