Database system with methodology for automated determination...

Details Database system with methodology for automated determination... Database system with methodology for automated determination...

2008-07-29

2008-07-29

Vo, Tim (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07406477

ABSTRACT:
A database system with methodology for automated determination and selection of optimal indexes is described. In one embodiment, for example, in a database system, a method of the present invention is described for recommending database indexes to be created for optimizing system performance, the method comprises steps of: capturing a workload representative of database queries employed during system use; creating virtual indexes for optimizing system performance during execution of the database queries captured in the workload; computing cost benefits for different combinations of the virtual indexes; and recommending physical indexes to be created based on virtual indexes that have favorable cost benefits for the captured workload.

REFERENCES:
patent: 5404510 (1995-04-01), Smith et al.
patent: 5495608 (1996-02-01), Antoshenkov
patent: 5615367 (1997-03-01), Bennett et al.
patent: 5742806 (1998-04-01), Reiner et al.
patent: 5758146 (1998-05-01), Schiefer et al.
patent: 5778354 (1998-07-01), Leslie et al.
patent: 5822749 (1998-10-01), Agarwal
patent: 5893088 (1999-04-01), Hendricks et al.
patent: 5913206 (1999-06-01), Chaudhuri et al.
patent: 5913207 (1999-06-01), Chaudhuri et al.
patent: 5918225 (1999-06-01), White et al.
patent: 5926813 (1999-07-01), Chaudhuri et al.
patent: 5930785 (1999-07-01), Lohman et al.
patent: 5950186 (1999-09-01), Chaudhuri et al.
patent: 5960423 (1999-09-01), Chaudhuri et al.
patent: 6009425 (1999-12-01), Mohan
patent: 6182079 (2001-01-01), Lenzie
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 6263334 (2001-07-01), Fayyad et al.
patent: 6266658 (2001-07-01), Adya et al.
patent: 6285996 (2001-09-01), Jou et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6338056 (2002-01-01), Dessloch et al.
patent: 6353820 (2002-03-01), Edwards et al.
patent: 6356891 (2002-03-01), Agrawal et al.
patent: 6366903 (2002-04-01), Agrawal et al.
patent: 6405187 (2002-06-01), Egan et al.
patent: 6421662 (2002-07-01), Karten
patent: 6470330 (2002-10-01), Das et al.
patent: 6546394 (2003-04-01), Chong et al.
patent: 6549895 (2003-04-01), Lai
patent: 6591269 (2003-07-01), Ponnekanti
patent: 6615206 (2003-09-01), Jakobsson et al.
patent: 6631366 (2003-10-01), Nagavamsi et al.
patent: 6643636 (2003-11-01), Au et al.
patent: 6654039 (2003-11-01), Hollines, III et al.
patent: 6678686 (2004-01-01), Patel et al.
patent: 6691101 (2004-02-01), MacNicol et al.
patent: 6694323 (2004-02-01), Bumbulis
patent: 6694325 (2004-02-01), Jas
patent: 6728720 (2004-04-01), Lenzie
patent: 6732096 (2004-05-01), Au
patent: 6778977 (2004-08-01), Avadhanam et al.
patent: 6785684 (2004-08-01), Adbo
patent: 6816854 (2004-11-01), Reiner et al.
patent: 6934701 (2005-08-01), Hall, Jr.
patent: 7007006 (2006-02-01), Zilio et al.
patent: 7047231 (2006-05-01), Grasshoff et al.
patent: 2003/0093408 (2003-05-01), Brown et al.
patent: 2004/0260684 (2004-12-01), Agrawal et al.
Valentin, Gary et al., DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes, Jul. 2001.
Chaudhuri, Surajit et al., An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server, Proceedings of the 23rd VLDB Conference, Athens, Greece, 1997.

Affiliated with

Also associated with

Rating

Database system with methodology for automated determination... 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 system with methodology for automated determination..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database system with methodology for automated determination... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2767017