An evolutionary approach to schema partitioning selection in a data warehouse

Lecture Notes in Computer Science

Volumn 3589, Issue , 2005, Pages 115-125

  Bellatreche, Ladjel ^a   Boukhalfa, Kamel ^b  

^a UNIVERSITÉ DE POITIERS   (France)

^b UNIVERSITY OF LAGHOUAT   (Algeria)

Author keywords

[No Author keywords available]

Indexed keywords

DATA REDUCTION; GENETIC ALGORITHMS; QUERY LANGUAGES; RELATIONAL DATABASE SYSTEMS;

DIMENSION TABLES; OBJECT DATABASES; OPTIMAL FRAGMENTATION; SCHEMA PARTITIONING;

DATA WAREHOUSES;

EID: 26844550470     PISSN: 03029743     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1007/11546849_12     Document Type: Conference Paper

References (13)

1. T. Back. Evolutionnary algorithms in theory and practice. Oxford University Press, New York, 1995.
2. L. Bellatreche, K. Karlapalem, and M. Mohania. What can partitioning do for your data warehouses and data marts. Proceedings of the International Database Engineering and Application Symposium (IDEAS'2000), pages 437-445, September 2000.
3. L. Bellatreche, M. Schneider, H. Lorinquer, and M. Mohania. Bringing together partitioning, materialized views and indexes to optimize performance of relational data warehouses. Proceeding of the International Conference on Data Warehousing and Knowledge Discovery (DAWAK'2004), pages 15-25, September 2004.
4. K. P. Bennett, M. C. Ferris, and Y. E. Ioannidis. A genetic algorithm for database query optimization, in Proceedings of the 4th International Conference on Genetic Algorithms, pages 400-407, July 1991.
5. OLAP Council. Apb-1 olap benchmark, release ii. http://www.olapcouncil. org/research/bmarkly.htm, 1998.
6. O. Frieder and H.T. Siegelmann. Multiprocessor document allocation : A genetic algorithm approach. IEEE Transactions on Knowledge and Data Engineering, 9(4):640-642, July 1997.
7. J. H. Holland. Adaptation in Natural and Artificial Systems. University of Michigan Press, Ann Arbor, Michigan, 1975.
8. P. Kalnis and D. Papadias. Proxy-server architecture for olap. Proceedings of the ACM SIGMOD International Conference on Management of Data, 2001.
9. T. Loukopoulos and I. Ahmad. Static and adaptive distributed data replication using genetic algorithms, in Journal of Parallel and Distributed Computing, 64(11):1270-1285, November 2004.
10. M. T. Özsu and P. Valduriez. Principles of Distributed Database Systems : Second Edition. Prentice Hall, 1999.
11. A. Sanjay, V. R. Narasayya, and B. Yang. Integrating vertical and horizontal partitioning into automated physical database design. Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 359-370, June 2004.
12. A. Sanjay, C. Surajit, and V. R. Narasayya. Automated selection of materialized views and indexes in microsoft sql server. Proceedings of the International Conference on Very Large Databases, pages 496-505, September 2000.
13. T. Stöhr, H. Märtens, and E. Rahm. Multi-dimensional database allocation for parallel data warehouses. Proceedings of the International Conference on Very Large Databases, pages 273-284, 2000.