Frequent itemsets mining for database auto-administration

Proceedings of the International Database Engineering and Applications Symposium, IDEAS

Volumn , Issue , 2003, Pages 98-103

  Aouiche, Kamel ^a   Darmont, Jérôme ^a   Gruenwald, Le ^b  

^a UNIVERSITÉ LUMIÈRE LYON 2   (France)

^b University of Oklahoma   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

AUTO-ADMINISTRATION; DATA ACCESS TIME; DATABASE ADMINISTRATORS; FREQUENT ITEMSETS MININGS; INDEXING TECHNIQUES; ITEM SETS; PERFORMANCE GAIN; PERFORMANCE OPTIMIZATIONS;

DATA WAREHOUSES; OPTIMIZATION;

DATA MINING;

EID: 19944365776     PISSN: 10988068     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/IDEAS.2003.1214915     Document Type: Conference Paper

References (22)

1. R. Agrawal, T. Imielinski, and A. N. Swami. Mining association rules between sets of items in large databases. SIG-MOD Record, 22(2):207-216, 1993.
2. R. Agrawal and R. Srikant. Fast algorithms for mining as sociation rules. In 20th International Conference on Very Large Data Bases (VLDB 1994), Santiago, Chile, pages 487-499, 1994.
3. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated selection of materialized views and indexes in SQL databases. In 26th International Conference on Very Large Data Bases (VLDB 2000), Cairo, Egypt, pages 496-505, 2000.
4. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Materialized view and index selection tool for Microsoft SQL Server 2000. 2001 ACM SIGMOD International Conference on Management of Data, Santa Barbara, USA, 2001.
5. K. Aouiche. Accidentology datamart schema and workload. http://bdd.univ-lyon2.fr/download/charge-accidentologie.pdf, 2002.
6. S. Chaudhuri. Data mining and database systems: Where is the intersection? Data Engineering Bulletin, 21(1):4-8, 1998.
7. S. Chaudhuri and V. R. Narasayya. An efficient cost-driven index selection tool for Microsoft SQL Server. In 23rd International Conference on Very Large Data Bases (VLDB 1997), Athens, Greece, pages 146-155, 1997.
8. S. Chaudhuri and V. R. Narasayya. Autoadmin ' what-if index analysis utility. In 1998 ACM SIGMOD International Conference on Management of Data, Seattle, USA, pages 367-378, 1998.
9. F. De Marchi, S. Lopes, and J.-M. Petit. Efficient algorithms for mining inclusion dependencies. In 8th International Conference on Extending Database Technology (EDBT 2002), Prague, Czech Republic, volume 2287 of LNCS, pages 464-476, 2002.
10. S. J. Finkelstein, M. Schkolnick, and P. Tiberio. Physical database design for relational databases. TODS, 13(1):91-128, 1988.
11. M. R. Frank, E. Omiecinski, and S. B. Navathe. Adaptive and automated index selection in RDBMS. In 3rd International Conference on Extending Database Technology (EDBT 1992), Vienna, Austria, volume 580 of LNCS, pages 277-292, 1992.
12. H. Gupta. Selection and maintenance of views in a data warehouse. PhD thesis, Stanford University, 1999.
13. S. Lopes, J.-M. Petit, and L. Lakhal. Efficient discovery of functional dependencies and Armstrong relations. In 7th International Conference on Extending Database Technology (EDBT 2000), Konstanz, Germany, volume 1777 of LNCS, pages 350-364, 2000.
14. Lumigent Technologies. Log Explorer for SQL Server. http://www.lumigent. com/products/le-sql/le-sql.htm, 2002.
15. P. O'Neil and G. Graefe. Multi-table joins through bitmapped join indices. SIGMOD Record, 24(3):8-11, 1995.
16. P. O'Neil and D. Quass. Improved query performance with variant indexes. SIGMOD Record, 26(2):38-49, 1997.
17. N. Pasquier, Y. Bastide, R. Taouil, and L. Lakhal. Discovering frequent closed itemsets for association rules. In 7th International Conference on Database Theory (ICDT1999), Jerusalem, Israel, volume 1540 of LNCS, pages 398-416, 1999.
18. N. Pasquier, Y. Bastide, R. Taouil, and L. Lakhal. Efficient mining of association rules using closed itemset lattices. Information Systems, 24(1):25-46, 1999.
19. M. Poess, B. Smith, L. Kollar, and P.-A. Larson. TPC-DS: Taking decision support benchmarking to the next level. In 2002 ACM SIGMOD International Conference on Management of Data, Madison, USA, 2002.
20. Transaction Processing Council. TPC Benchmark R Standard Specification, 1999.
21. S. Vanichayobon and L. Gruenwald. Indexing techniques for data warehouses' queries. Technical report, University of Oklahoma, School of Computer Science, 1999.
22. G. Weikum, A. Monkeberg, C. Hasse, and P. Zabback. Self-tuning database technology and information services: from wishful thinking to viable engineering. In 28th International Conference on Very Large Data Bases (VLDB 2002), Hong Kong, China, 2002.