Clustering-based materialized view selection in data warehouses

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 4152 LNCS, Issue , 2006, Pages 81-95

  Aouiche, Kamel ^a   Jouve, Pierre Emmanuel ^a   Darmont, Jérôme ^a  

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

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; COMPUTATIONAL COMPLEXITY; DATA MINING; DECISION SUPPORT SYSTEMS; INFORMATION ANALYSIS; MATHEMATICAL MODELS; QUERY LANGUAGES;

CLUSTERING; DECISION-SUPPORT QUERIES; MATERIALIZED VIEW SELECTION;

DATA WAREHOUSES;

EID: 33750091622     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/11827252_9     Document Type: Conference Paper

References (23)

1. S. Agrawal, S. Chaudhuri, and V. 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.
2. E. Baralis, S. Paraboschi, and E. Teniente. Materialized views selection in a multi-dimensional database. In 23rd International Conference on Very Large Data Bases (VLDB 1997), Athens, Greece, pages 156-165, 1997.
3. X. Baril and Z. Bellahsene. Selection of materialized views: a cost-based approach. In 15th International Conference (CAiSE 2003), Klagenfurt, Austria, pages 665-680, 2003.
4. A. F. Cardenas. Analysis and performance of inverted data base structures. Communication in ACM, 18(5):253-263, 1975.
5. G. K. Y. Chan, Q. Li, and L. Feng. Design and selection of materialized views in a data warehousing environment: a case study. In 2nd ACM international workshop on Data warehousing and OLAP (DOLAP 1999), Kansas City, USA, pages 42-47, 1999.
6. J. Goldstein and P. Larson. Optimizing queries using materialized views: a practical, scalable solution. In ACM SIGMOD international conference on Management of data (SIGMOD 2001), Santa Barbara, USA, pages 331-342, 2001.
7. M. Golfarelli and S. Rizzi. A methodological framework for data warehouse design. In 1st ACM international workshop on Data warehousing and OLAP (DOLAP 1998), New York, USA, pages 3-9, 1998.
8. H. Gupta. Selection of views to materialize in a data warehouse. In 6th International Conference on Database Theory (ICDT 1997), Delphi, Greece, pages 98-112, 1997.
9. H. Gupta and I. S. Mumick. Selection of views to materialize in a data warehouse. IEEE Transactions on Knowledge and Data Engineering, 17(1):24-43, 2005.
10. V. Harinarayan, A. Rajaraman, and J. D. Ullman. Implementing data cubes efficiently. In ACM SIGMOD International Conference on Management of data (SIGMOD 1996), Montreal, Canada, pages 205-216, 1996.
11. P. Jouve and N. Nicoloyannis. KEROUAC: an algorithm for clustering categorical data sets with practical advantages. In International Workshop on Data Mining for Actionable Knowledge (DMAK'2003, in conjunction with PAKDD03), 2003.
12. P. Jouve and N. Nicoloyannis. A new method for combining partitions, applications for distributed clustering. In International Workshop on Paralell and Distributed Machine Learning and Data Mining (ECML/PKDD03), pages 35-46, 2003.
13. Y. Kotidis and N. Roussopoulos. DynaMat: A dynamic view management system for data warehouses. In ACM SIGMOD International Conference on Management of Data, (SIGMOD 1999), Philadelphia, USA, pages 371-382, 1999.
14. T. P. Nadeau and T. J. Teorey. Achieving scalability in OLAP materialized view selection. In 5th ACM International Workshop on Data Warehousing and OLAP (DOLAP 2002), McLean, USA.
15. S. Rizzi and E. Saltarelli. View materialization vs. indexing: Balancing space constraints in data warehouse design. In 15th International Conference (CAiSE 2003), Klagenfurt, Austria, pages 502-519, 2003.
16. A. Shukla, P. Deshpande, and J. F. Naughton. Materialized view selection for multi-cube data models. In 7th International Conference on Extending DataBase Technology (EDBT 2000), Konstanz, Germany, pages 269-284, 2000.
17. Y. Sismanis, A. Deligiannakis, N. Roussopoulos, and Y. Kotidis. Dwarf: shrinking the petacube. In ACM SIGMOD International Conference on Management of Data (SIGMOD 2002), Madison, USA, pages 464-475, 2002.
18. J. R. Smith, C.-S. Li, and A. Jhingran. A wavelet framework for adapting data cube views for OLAP. IEEE Transactions on Knowledge and Data Engineering, 16(5):552-565, 2004.
19. D. Theodoratos and W. Xu. Constructing search spaces for materialized view selection. In 7th ACM international workshop on Data warehousing and OLAP (DOLAP 2004), Washington, USA.
20. Transaction Processing Council. TPC Benchmark R Standard Specification, 1999.
21. H. Uchiyama, K. Runapongsa, and T. J. Teorey. A progressive view materialization algorithm. In end ACM International Workshop on Data warehousing and OLAP (DOLAP 1999), Kansas City, USA, pages 36-41, 1999.
22. S. R. Valluri, S. Vadapalli, and K. Karlapalem. View relevance driven materialized view selection in data warehousing environment. In 30th Australasian conference on Database technologies, Melbourne, Australia, pages 187-196, 2002.
23. S. B. Yao. Approximating block accesses in database organizations. Communication in ACM, 20(4):260-261, 1977.