An auto-indexing technique for databases based on clustering

International Conference on Database and Expert Systems Applications - DEXA

Volumn 15, Issue , 2004, Pages 776-780

  Zaman, Mujiba ^a   Surabattula, Jyotsna ^a   Gruenwald, Le ^a  

^a University of Oklahoma   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COST ACCOUNTING; DATA MINING; DATA WAREHOUSES; INDEXING (OF INFORMATION); OPTIMIZATION; PARAMETER ESTIMATION; PROBLEM SOLVING;

AUTO-INDEXING; CLUSTERING; DATABASE ADMINISTRATOR (DBA); INDEX SELECTION TOOL (IST);

DATABASE SYSTEMS;

EID: 10044230733     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/dexa.2004.1333569     Document Type: Conference Paper

References (12)

1. K. Aouiche, J. Darmont and L. Gruenwald, "Frequent itemsets mining for database auto-administration", Seventh International Database Engineering and Applications Symposium (IDEAS'03), July 16-18, 2003.
2. S. Finkelstein, M. Schkolnick and P. Tiberio, "Physical Database Design for Relational Databases", ACM Transactions on Database Systems (TODS), Volume 13, issue 1 (March 1988), Pages 91-128, 1988
3. S. Chaudhari and V. Narasayya, "An efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server", Proceedings of the 23rd Very Large Data Base Conference, 1997.
4. R. Rankins, P. Bertucci and P. Jenson, "Microsoft SQL Server 2000", SAMS Publishing, Second Edition, UNLEASHED, Chapter 34.
5. M. Adenberg, "Cluster Analysis for Applications", Academic Press, New York, New York, 1973.
6. P. Jouve and N. Nicoloyannis, "KEROUAC: an Algorithm for Clustering Categorical Data Sets with Practical Advantages"
7. S. Chaudhari and V. Narasayya,"AutoAdmin 'What-if Index Analysis Utility", ACM SIGMOD Conf 1998, pp. 367-378.
8. A. Capara, M. Fischetti and D. Maio, "Exact and Approximate Algorithms for the Index Selection Problem in Physical Database Design", IEEE Transactions on Knowledge and Data Engineering, 7(6):955-967, December 1995
9. "TPC Benchmark R", (Decision Support) Standard Specification, Revision 2.1.0, Transactions Processing Performance Council (TPC), 1993-2002
10. N. Pasquier, Y.Bastide, R.Taouil, and L.Lakhal, "Efficient Mining of association Rules using closed itemset lattices." InformationSystems,24(1):25-46, 1999.
11. G. Valentin, M. Zuliani, D. Zilio and G. Lohman, "DB2 Advisor: An optimizer Smart Enough to Recommend its Own Indexes", Int. Conf. on Data Engineering, March 2002.
12. Mike Hordila,"Setting up an Automated Index Rebuilding System". http://www.oracle.com/oramag/webcolumns/2001/auto_index.html.