Dynamic Materialized View Selection in Data Warehouse Environment

Informatica (Ljubljana)

Volumn 27, Issue 4, 2003, Pages 451-460

  Zhang, Chuan ^a   Yang, Jian ^b   Karlapalem, Kamalakar ^c  

^a TransACT Communications   (Australia)

^b TILBURG UNIVERSITY   (Netherlands)

^c INTERNATIONAL INSTITUTE OF INFORMATION TECHNOLOGY   (India)

Author keywords

Data warehousing; Dynamic view selection; Materialized views

Indexed keywords

ALGORITHMS; COMPUTATIONAL METHODS; COSTS; DATABASE SYSTEMS; MAINTENANCE; MATHEMATICAL MODELS; OPTIMIZATION; PROBLEM SOLVING; QUERY LANGUAGES;

COST MODEL; DYNAMIC VIEW SELECTION; MATERALIZED VIEWS;

DATA WAREHOUSES;

EID: 1242285453     PISSN: 03505596     EISSN: None     Source Type: Journal    
DOI: None     Document Type: Conference Paper

References (15)

1. D.E. Goldberg. Genetic algorithms in search, optimization and machine learning. Addison Wesley, Reading(MA), 1989.
2. Ashid Gupta, Inderpal Singh Mumick, and Kenneth A. Ross. Adapting materialized views after redefinitions: Techniques and a performance study. Proc. of the ACM SIGMOD international Conference of Management of Data, pages 211-222, 1995.
3. Yannis Kotidis and Nick Roussopoulos. Dynamat: A dynamic view management system for data ware-houses. Proc. of the ACM SIGMOD international Conference of Management of Data, pages 371-382, 1999.
4. M. K. Mohania. Avoiding re-computation: View adaptation in data warehouses. 8th International Database Workshop, Hong Kong, Springer-Verlag, pages 151-165, 1997.
5. Mukesh K. Mohania and Guozhu Dong. Algorithms for adapting materialized views in data warehouses. International Symposium on Cooperative Database Systems for Advanced Applications, Kyoto, Japan, pages 62-69, 1996.
6. Mukesh K. Mohania and Guozhu Dong. Materialized view adaption in distributed databases. Asian Computing Science Conference (ASIAN), pages 353-354, 1996.
7. Massachusetts Institute of Technology. MIT. Galib: A c++ genetic algorithms library. http://lancet.mit.edU/galib-2.4/GAlib.html, v2.4, 1998.
8. Robert E Smith, David E. Goldberg, and Jeff A. Earickson. SGA-C: A C-language implementation of simple genetic algorithm. TCGA Report No. 91002, March, 1994.
9. Michael Steinbrunn, Guido Moerkotte, and Alfons Kemper. Heuristic and randomized optimization for the join ordering problem. VLDB Journal, 6(3):191-208, 1997.
10. Dimitri Theodorators and Timos K. Sellis. Dynamic data warehouse design. DaWak'99, pages 126-135, 1999.
11. Jennifer Widom. Research problems in data ware-house. Proceedings of 4th International Conference on Information and Knowledge Management, pages 25-30, 1995.
12. Jian Yang, Kamalakar Karlapalem, and Qing Li. Algorithm for materialized view design in data ware-housing environment. Proceedings of 23th International Conference on Very Large Data Bases (VLDB), pages 136-145, 1997.
13. Chuan Zhang and Jian Yang. Genetic algorithm for materialized view selection in data warehouse environments. 1st International Conference on Data Warehousing and Knowledge Discovery(DaWak'99), Lecture Notes in Computer Science, Italy, 1999.
14. Chuan Zhang and Jian Yang. Materialized view evolution support in data warehouse environment. Database Systems for Advanced Applications (DAS-FAA), Taiwan:247-254, 1999.
15. Chuan Zhang, Xin Yao, and Jian Yang. An evolutionary approach to materialized views selection in a data warehouse environment. IEEE Trans on Systems, Man, and Cybernetics (Part C), 31(3):P295303, 2001.