Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2009-01-07
2011-10-11
Lewis, Cheryl (Department: 2155)
Data processing: database and file management or data structures
Database and file access
Query optimization
C707S705000, C707S753000
Reexamination Certificate
active
08037057
ABSTRACT:
In an example embodiment, a method is illustrated to determine multi-column indexes, the method including receiving one or more structured query language (SQL) queries, the one or more SQL queries defining a workload. A database index analysis tool may be used to determine a plurality of index configurations for executing the workload. Further, leading index configurations may be determined, leading index configurations including a subset of the plurality of index configurations. Also, a statistics database may be updated with complete statistics for the leading index configurations.
REFERENCES:
patent: 5913206 (1999-06-01), Chaudhuri et al.
patent: 5950186 (1999-09-01), Chaudhuri et al.
patent: 5960423 (1999-09-01), Chaudhuri et al.
patent: 6169983 (2001-01-01), Chaudhuri et al.
patent: 6965894 (2005-11-01), Leung et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2003/0182272 (2003-09-01), Leung et al.
Chandhuri, S., et al., “An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server”,Proceedings of the 23rd International Conference on Very Large Data Bases, (1997), 146-155.
Dageville, B., et al., “Automatic SQL Tuning in Oracle 10g”,Proceedings of the Thirtieth International Conference on Very Large Data Bases, (2004), 1098-1109.
Deb, K, “Genetic algorithm in search and optimization: the technique and applications”,in: Proceedings of International Workshop on Soft Computing and Intelligent Systems, Calcutta, India, (1998), 58-87.
Valentin, G, et al., “A. DB2 Advisor: An Optimizer Smart Enough to Recommend its Own Indexes”,16th International Conference on Data Engineering, 2000. Proceedings., (2000), 101-110.
Lewis Cheryl
Schwegman Lundberg & Woessner
Teradata , US Inc.
LandOfFree
Multi-column statistics usage within index selection tools does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Multi-column statistics usage within index selection tools, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Multi-column statistics usage within index selection tools will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4269962