Towards materialized view selection for distributed databases

Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, EDBT'09

Volumn , Issue , 2009, Pages 1088-1099

  Chaves, Leonardo Weiss F ^a   Buchmann, Erik ^b   Hueske, Fabian ^a   Böhm, Klemens ^b  

^a SAP RESEARCH   (Germany)

^b UNIVERSITY OF KARLSRUHE   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMIC FRAMEWORK; BRUTE FORCE ALGORITHMS; COST MODELS; DISTRIBUTED DATABASE; EXHAUSTIVE SEARCH; HETEROGENEOUS NODES; INITIAL POPULATION; INPUT FACTORS; MATERIALIZED VIEW; MATERIALIZED VIEW SELECTION; NETWORK BANDWIDTH; NP-HARD; ORGANIC COMPUTING; PROCESSING TIME; QUERY PERFORMANCE; REAL-WORLD; REAL-WORLD SCENARIO; RELATIONAL DATABASE; RESOURCE CONSTRAINT; SELECTION FUNCTION; SOLUTION SPACE;

ALGORITHMS; COMPUTATIONAL COMPLEXITY; DATABASE SYSTEMS;

SET THEORY;

EID: 70349133843     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1516360.1516484     Document Type: Conference Paper

References (29)

1. S. Agrawal, S. Chaudhuri, L. Kollar, A. Marathe, V. Narasayya, and M. Syamala. Database Tuning Advisor for Microsoft SQL Server 2005. In Proceedings of VLDB'04, 2004.
2. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated Selection of Materialized Views and Indexes in SQL Databases. In Proceedings of VLDB'00, 2000.
3. E. Baralis, S. Paraboschi, and E. Teniente. Materialized views selection in a multidimensional database. In Proceedings of VLDB'97, 1997.
4. A. Bauer and W. Lehner. On solving the view selection problem in distributed data warehouse architectures. In Proceedings of SSDBM'2003, 2003.
5. D. Beasley, D. Bull, and R. Martin. An overview of genetic algorithms: Part 1, fundamentals. University Computing, 15(2):58-69, 1993.
6. L. Bellatreche, K. Karlapalem, and M. Schneider. On efficient storage space distribution among materialized views and indices in data warehousing environments. In Proceedings of CIKM'00, 2000.
7. R. G. Bello, K. Dias, A. Downing, J. James J. Feenan, J. L. Finnerty, W. D. Norcott, H. Sun, A. Witkowski, and M. Ziauddin. Materialized Views in Oracle. In Proceedings of VLDB'98, 1998.
8. S. Chaudhuri. An overview of query optimization in relational systems. In Proceedings of PODS'98, 1998.
9. A. E. Eiben, R. Hinterding, and Z. Michalewicz. Parameter control in evolutionary algorithms. IEEE Trans. on Evolutionary Computation, 1999.
10. H. Gupta. Selection of views to materialize in a data warehouse. In Proceedings of ICDT'97, 1997.
11. H. Gupta and I. S. Mumick. Selection of views to materialize under a maintenance cost constraint. Lecture Notes in Computer Science, 1999.
12. R. Hull and G. Zhou. Towards the study of performance trade-offs between materialized and virtual integrated views. In Proceedings of VIEWS'96, 1996.
13. H. Jiang, D. Gao, and W.-S. Li. Exploiting correlation and parallelism of materialized-view recommendation for distributed data warehouses. Proceedings of ICDE'07, 2007.
14. D. Kossmann and K. Stocker. Iterative dynamic programming: a new class of query optimization algorithms. A CM Trans. on Database Systems. 2000.
15. M. L. Lee, M. Kitsuregawa, B. C. Ooi, K.-L. Tan, and A. Mondal. Towards self-tuning data placement in parallel database systems. Proceedings of SIGMOD '00, 2000.
16. W.-S. Li, D. C. Zilio, V. S. Batra, C. Zuzarte, and I. Narang. Load balancing and data placement for multi-tiered database systems. Data Knowl. Eng., 62(3):523-546, 2007.
17. T. Liu. Cost-based query optimization in a heterogeneous distributed semi-structured environment. In The VLDB PhD workshop, Vienna, Austria, 2007.
18. * optimizer validation and performance evaluation for local queries. In Proceedings of SIGMOD'86, 1986.
19. H. Mistry, P. Roy, S. Sudarshan, and K. Ramamritham. Materialized view selection and maintenance using multi-query optimization. Proceedings of SIGMOD'01, 2001.
20. R. Pottinger and A. Y. Levy. A scalable algorithm for answering queries using views. In Proceedings of VLDB'00, 2000.
21. A. Shukla, P. Deshpande, and J. F. Naughton. Materialized view selection for multidimensional datasets. In Proceedings of VLDB'98, 1998.
22. H. Wang, M. Orlowska, and W. Liang. Efficient refreshment of materialized views with multiple sources. In Proceedings of CIKM'99, 1999.
23. L. Weiss Ferreira Chaves, E. Buchmann, and K. Böhm. Tagmark: Reliable estimations of RFID tags for business processes. Proceedings of KDD'08, 2008.
24. J. Yang, K. Karlapalem, and Q. Li. Algorithms for materialized view design in data warehousing environment. In Proceedings of VLDB'97, 1997.
25. W. Ye, N. Gu, G. Yang, and Z. Liu. Extended derivation cube based view materialization selection in distributed data warehouse. In Proceedings of WAIM'05, 2005.
26. C. Zhang and J. Yang. Genetic algorithm for materialized view selection in data warehouse environments. In Proceedings of DaWaK'99, 1999.
27. J. Zhou, P.-A. Larson, and H. G. Elmongui. Lazy maintenance of materialized views. In Proceedings of VLDB'07, 2007.
28. J. Zhou, P.-A. Larson, J. Goldstein, and L. Ding. Dynamic materialized views. Proceedings of ICDE'07, 2007.
29. D. C. Zilio, C. Zuzarte, G. M. Lohman, H. Pirahesh, J. Gryz, E. Alton, D. Liang, and G. Valentin. Recommending Materialized Views and Indexes with IBM DB2 Design Advisor. In Proceedings of ICAC'04, 2004.