This application is a continuation in part of pending U.S. patent application Ser. No. 09/553033, filed Apr. 20, 2000; “Index and Materialized View Selection for a Given Workload. This application is related to co-pending patents and applications which are commonly assigned: “Database System Index Selection Using Cost Evaluation of a Workload for Multiple Candidate Index Configurations”, U.S. Pat. No. 5,950,186; “Database System Index Selection Using Candidate Index Selection for a Workload”, U.S. Pat. No. 5,960,423; “Database System Multi-Column Index Selection for a Workload”, U.S. Pat. No. 5,913,206; “Database System Index Selection Using Index Configuration Enumeration for a Workload” U.S. Pat. No. 5,913,207; “Database System Index Selection Using Cost Evaluation of a Workload for Multiple Candidate Index Configurations” U.S. Pat. No. 5,926,813; “Index Merging for Database Systems” Ser. No. 09/087,617; “What-If Index Analysis Utility for Database Systems” Aug. 25, 1998, Ser. No. 09/139,843 now U.S. Pat. No. 6,223,171 which are hereby incorporated by reference.
Number | Name | Date | Kind |
---|---|---|---|
5897632 | Dar et al. | Apr 1999 | A |
5913206 | Chaudhuri et al. | Jun 1999 | A |
5913207 | Chaudhuri et al. | Jun 1999 | A |
5926813 | Chaudhuri et al. | Jul 1999 | A |
5950186 | Chaudhuri et al. | Sep 1999 | A |
5960423 | Chaudhuri et al. | Sep 1999 | A |
5991754 | Raitto et al. | Nov 1999 | A |
6026390 | Ross et al. | Feb 2000 | A |
6266658 | Adya et al. | Jun 2000 | B1 |
6134543 | Witkowski et al. | Nov 2000 | A |
6129983 | Chaudhuri et al. | Jan 2001 | A1 |
6223171 | Chaudhuri et al. | Apr 2001 | B1 |
Entry |
---|
IEEE publication, Improving OLAP performance by multidimentsional hierachical clustering by V. Markl et al, pp. 165-177 (Aug. 1999).* |
IEEE publication, Augmented inherited mult-index structure for maintenance of materialized path query views by Harmui Kuno et al. pp. 128-137 (Feb. 1996).* |
IEEE publication, Optimizing queriess with materialized views, by Surajit Chaudhuri et al., pp. 190-2000 (Mar. 1995).* |
Chang, et al. discloses an extended query reformulation technique using materialized views, (IEEE publication 1998), Dept of Computer Science, Seoul National University, Korea 151-742, pp. 1-6.* |
Samtani, et al. discloses self maintenance of multiple views in data warehousing, (IEEE publication, 1999), Dept of Computer Science, Western Michigan University, pp. 292-299.* |
Copending Patent Application Serial No.: 09/087,617, entitled “Index Merging for Database Systems”. |
“Copending Patent Application Serial No.: 09/139,843, entitled What-If Index Analysis Utility for Database Systems”. |
Chaudhuri, S., et al., “An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server”, Proceedings of the 23rd VLDB Conference, Athens Greece, 10 Pages, (1997). |
Chaudhuri, S. et al., “AutoAdmin “What-if” Index Analysis Utility”, Sigmod '98 Proceedings of ACM Sigmod International Conference on Management of Data, Vol. 27, Issue 2, 367-378, (Jun. 1998). |
Number | Date | Country | |
---|---|---|---|
Parent | 09/553033 | Apr 2000 | US |
Child | 09/629353 | US |