Bringing together partitioning, materialized views and indexes to optimize performance of relational data warehouses

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

Volumn 3181, Issue , 2004, Pages 15-25

  Bellatreche, Ladjel ^a   Schneider, Michel ^b   Lorinquer, Hervé ^b   Mohania, Mukesh ^c  

^a ENSMA   (France)

^b UNIVERSITÉ CLERMONT AUVERGNE   (France)

^c IBM RESEARCH INDIA   (India)

Author keywords

[No Author keywords available]

Indexed keywords

DATA WAREHOUSES;

BITMAP INDEXES; DATA PARTITIONING; MAINTENANCE OVERHEAD; MATERIALIZED VIEW; RELATIONAL DATA; RESEARCH PROTOTYPE; SYSTEMATIC EXPERIMENT; TUNING PARAMETER;

DATA HANDLING;

EID: 35048874772     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/978-3-540-30076-2_2     Document Type: Article

References (16)

1. S. Agrawal, S. Chaudhuri, V.R. Narasayya, "Automated selection of materialized views and indexes in SQL databases", in Proc. 26th Int. Conf. on Very Large Data Bases (VLDB), pp. 496-505, 2000.
2. E. Baralis, S. Paraboschi, and E. Teniente, "Materialized view selection in a multidimensional database," in Proc. 23rd Int. Conf. on Very Large Data Base (VLDB), pp. 156-165, 1997.
3. L. Bellatreche, K. Karlapalem, and Q. Li, "Evaluation of indexing materialized views in data warehousing environments", in Proc. Int. Conf. on Data Warehousing and Knowledge Discovery (DAWAK), pp. 57-66, 2000.
4. L. Bellatreche, K. Karlapalem, M. Schneider and M. Mohania, "What can partitioning do for your data warehouses and data marts", in Proc. Int. Database Engineering and Application Symposium (IDEAS), pp. 437-445, 2000.
5. L. Bellatreche, M. Schneider, M. Mohania, and B. Bhargava, "Partjoin : an efficient storage and query execution design strategy for data warehousing", Proc. Int. Conf. on Data Warehousing and Knowledge Discovery (DAWAK), pp. 296-306, 2002.
6. L. Bellatreche, M. Schneider, Lorinquer, H. and M. Mohania, "Bringing Together Partitioning, Materialized Views and Indexes to Optimize Performance of Relational Data Warehouses," extented version available at http://www.lisi.ensma.fr/publications.php
7. S. Chaudhuri and V. Narasayya., "An efficient cost-driven index selection tool for microsoft ql server", in Proc. Int. Conf. on Very Large Databases (VLDB), 1997, pp. 146-155.
8. C. Chee-Yong, "Indexing techniques in decision support Systems", Ph.D. Thesis, University of Wisconsin, Madison, 1999.
9. H. Gupta et al., "Index selection for olap," in Proc. Int. Conf. on Data Engineering (ICDE), pp. 208-219, 1997.
10. H. Gupta and I. S. Mumick, "Selection of views to materialize under a maintenance cost constraint," in Proc. 8th Int. Conf. on Database Theory (ICDT), pp. 453-470, 1999.
11. Informix Corporation, "Informix-online extended parallel server and informix-universal server: A new generation of decision-support indexing for enterprise data warehouses", White Paper, 1997.
12. Nicola, M. "Storage Layout and I/O Performance Tuning for IBM Red Brick Data Warehouse", IBM DB2 Developer Domain, Informix Zone, October 2002.
13. OLAP Council, "APB-1 olap benchmark, release II", http://www.olapcouncil.org/research/bmarkly.htm.
14. P. O'Neil and D. Quass., "Improved query performance with variant indexes", in Proc. ACM SIGMOD Int. Conf. on Management of Data, pp. 38-49, 1997.
15. Red Brick Systems, "Star schema processing for complex queries", White Paper, July 1997.
16. A. Sanjay, G. Surajit, and V. R. Narasayya, "Automated selection of materialized views and indexes in microsoft sql server", in Proc. Int. Conf. on Very Large Databases (VLDB), pp. 496-505, 2000.