Index selection in a database system

Details Index selection in a database system Index selection in a database system

2011-06-14

2011-06-14

Woo, Isaac M (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S601000, C707S602000, C707S608000, C707S802000, C707S828000

Reexamination Certificate

active

07962521

ABSTRACT:
An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.

REFERENCES:
patent: 5303383 (1994-04-01), Neches
patent: 5640584 (1997-06-01), Kandasamy
patent: 5864842 (1999-01-01), Pederson
patent: 5884299 (1999-03-01), Ramesh
patent: 5960423 (1999-09-01), Chaudhuri
patent: 6366903 (2002-04-01), Agrawal
patent: 6513029 (2003-01-01), Agrawal
patent: 6738756 (2004-05-01), Brown
patent: 6801903 (2004-10-01), Brown
patent: 7155428 (2006-12-01), Brown
patent: 2003/0088541 (2003-05-01), Zilio et al.
patent: 2003/0088546 (2003-05-01), Brown
Oracle Corporation, “SQL Language: Reference Manual, Version 6.0,” pp. 5-1 to 5-5, 5-96 to 5-97 (1990).
Douglas P. Brown et al., Teradata Solutions Group, “Real-Time Diagnostics Tools for Teradata's Parallel Query Optimizer, White-Paper,” pp. 1-20 (Aug. 2000).
Eugene Wong et al., ACM Transactions on Database Systems, vol. 1, No. 3, “Decomposition-A Strategy for Query Processing,” pp. 223-241 (Sep. 1976).
P. Griffiths Selinger et al., ACM, “Access Path Selection in a Relational Database Management System,” pp. 23-34 (1979).
Masaru Kitsuregawa et al., Institute of Industrial Science, University of Tokyo, “Query Execution for Large Relations on Functional Disk System,” pp. 159-167 (1989).
D.D. Chamberlin et al., “Views, Authorization, and Locking in a Relational Data Base System,” National Computer Conference, pp. 425-430 (1975).
D.D. Chamberlin et al., “Sequel 2: A Unified Approach to Data Definition, Manipulation, and Control,” IBM Journal of Research and Development, vol. 20, pp. 560-575 (Nov. 1976).
M.W. Blasgen et al., “On the Evaluation of Queries in a Relational Data Base System,” IBM Research Report RJ 1745, pp. 1-44 (Apr. 1976).
M.W. Blasgen et al., “Storage and Access in Relational Data Bases,” IBM Systems Journal, No. 4, pp. 363-377 (1977).

Affiliated with

Also associated with

Rating

Index selection in a database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Index selection in a database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Index selection in a database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2702071