Some issues in design of data warehousing systems

Ladjel Bellatreche Kamalakar Karlapalem Department of Computer Science University of Science & Technology Clear Water Bay Kowloon Hong Kong fladjel, kamalg@cs.ust.hk Mukesh Mohania Department of Computer Science Western Michigan University Kalamazoo, MI 49008-5021 U.S.A. mohania@cs.wmich.edu

[1]  Divesh Srivastava,et al.  Answering Queries with Aggregation Using Views , 1996, VLDB.

[2]  Patrick E. O'Neil,et al.  Improved query performance with variant indexes , 1997, SIGMOD '97.

[3]  Ken Barker,et al.  A horizontal fragmentation algorithm for the fact relation in a distributed data warehouse , 1999, CIKM '99.

[4]  Jennifer Widom,et al.  Making views self-maintainable for data warehousing , 1996, Fourth International Conference on Parallel and Distributed Information Systems.

[5]  Wolfgang Lehner,et al.  The Cube-Query-Languages (CQL) for Multidimensional Statistical and Scientific Database Systems , 1997, DASFAA.

[6]  Mukesh K. Mohania,et al.  What can partitioning do for your data warehouses and data marts? , 2000, Proceedings 2000 International Database Engineering and Applications Symposium (Cat. No.PR00789).

[7]  Shamkant B. Navathe,et al.  Vertical partitioning for database design: a graphical algorithm , 1989, SIGMOD '89.

[8]  Patrick Valduriez,et al.  Principles of Distributed Database Systems , 1990 .

[9]  Ray Jain,et al.  The art of computer systems performance analysis - techniques for experimental design, measurement, simulation, and modeling , 1991, Wiley professional computing.

[10]  Jennifer Widom,et al.  View maintenance in a warehousing environment , 1995, SIGMOD '95.

[11]  Jian Yang,et al.  Algorithms for Materialized View Design in Data Warehousing Environment , 1997, VLDB.

[12]  Arie Segev,et al.  A Framework for Join Pattern Indexing in Intelligent Database Systems , 1995, IEEE Trans. Knowl. Data Eng..

[13]  Shamkant B. Navathe,et al.  Vertical partitioning algorithms for database design , 1984, TODS.

[14]  Yue Zhuge,et al.  The Strobe algorithms for multi-source warehouse consistency , 1996, Fourth International Conference on Parallel and Distributed Information Systems.

[15]  Surajit Chaudhuri,et al.  An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server , 1997, VLDB.

[16]  Wilburt Labio,et al.  Physical database design for data warehouses , 1997, Proceedings 13th International Conference on Data Engineering.

[17]  Nam Huyn,et al.  Multiple-View Self-Maintenance in Data Warehousing Environments , 1997, VLDB.

[18]  John F. Roddick,et al.  Advances and Research Directions in Data-Warehousing Technology , 1999, Australas. J. Inf. Syst..

[19]  Alan R. Hevner,et al.  Distributed Data Allocation Strategies , 1988, Adv. Comput..

[20]  Kenneth A. Ross,et al.  Faster Joins, Self-Joins and Multi-Way Joins Using Join Indices , 1997, Data Knowl. Eng..

[21]  Nick Roussopoulos,et al.  DynaMat: a dynamic view management system for data warehouses , 1999, SIGMOD '99.

[22]  Kamalakar Karlapalem,et al.  On efficient storage space distribution among materialized views and indices in data warehousing environments , 2000, CIKM '00.

[23]  Inderpal Singh Mumick,et al.  The Stanford Data Warehousing Project , 1995 .

[24]  Surajit Chaudhuri,et al.  AutoAdmin “what-if” index analysis utility , 1998, SIGMOD '98.

[25]  Stefano Ceri,et al.  Distributed Databases: Principles and Systems , 1984 .

[26]  Elena Baralis,et al.  Materialized Views Selection in a Multidimensional Database , 1997, VLDB.

[27]  Krithi Ramamritham,et al.  Curio: A Novel Solution for Efficient Storage and Indexing in Data Warehouses , 1999, VLDB.

[28]  Jeffrey D. Ullman,et al.  Selection and maintenance of views in a data warehouse , 1999 .

[29]  Jennifer Widom,et al.  On-Line Warehouse View Maintenance for Batch Updates , 1996, SIGMOD 1996.

[30]  Surajit Chaudhuri,et al.  Automated Selection of Materialized Views and Indexes in SQL Databases , 2000, VLDB.

[31]  Surajit Chaudhuri,et al.  Index merging , 1999, Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337).

[32]  Qing Li,et al.  Evaluation of Materialized View Indexing in Data Warehousing Environments , 2000, DaWaK.

[33]  Qing Li,et al.  Derived Horizontal Class Partitioning in OODBs: Design Strategies, Analytical Model and Evaluation , 1998, ER.

[34]  Gang Zhou,et al.  A framework for supporting data integration using the materialized and virtual approaches , 1996, SIGMOD '96.

[35]  Mukesh K. Mohania,et al.  Making Aggregate Views Self-maintainable , 2000, Data Knowl. Eng..

[36]  Timos K. Sellis,et al.  A survey of logical models for OLAP databases , 1999, SGMD.

[37]  Jennifer Widom,et al.  Research problems in data warehousing , 1995, CIKM '95.

[38]  Alberto O. Mendelzon,et al.  Maintaining data cubes under dimension updates , 1999, Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337).

[39]  Alejandro P. Buchmann,et al.  Research Issues in Data Warehousing , 1997, BTW.

[40]  David J. DeWitt,et al.  GAMMA - A High Performance Dataflow Database Machine , 1986, VLDB.

[41]  Chang Li,et al.  A data model for supporting on-line analytical processing , 1996, CIKM '96.

[42]  Stephen Morse,et al.  Parallel Systems in the Data Warehouse , 1997 .

[43]  Jennifer Widom,et al.  On-line warehouse view maintenance , 1997, SIGMOD '97.

[44]  Wolfgang Lehner,et al.  CROSS-DB: a feature-extended multidimensional data model for statistical and scientific databases , 1996, CIKM '96.

[45]  Qing Li,et al.  Efficient query processing with associated horizontal class partitioning in an object relational data warehousing environment , 2000, DMDW.

[46]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[47]  V. S. Subrahmanian,et al.  Maintaining views incrementally , 1993, SIGMOD Conference.

[48]  Patrick Valduriez,et al.  Join indices , 1987, TODS.

[49]  Stefano Ceri,et al.  Horizontal data partitioning in database design , 1982, SIGMOD '82.

[50]  Qing Li,et al.  Efficient query processing with structural join indexing in an object relational data warehousing environment , 2000, IRMA Conference.

[51]  Elena Baralis,et al.  Conservative Timestamp Revisited for Materialized View Maintenance in a Data Warehouse , 1996, VIEWS.

[52]  Ana Simonet,et al.  Horizontal Class Partitioning in Object-Oriented Databases , 1997, DEXA.

[53]  Jeffrey D. Ullman,et al.  Index selection for OLAP , 1997, Proceedings 13th International Conference on Data Engineering.

[54]  Kamalakar Karlapalem,et al.  Query-Driven Horizontal Class Partitioning for Object-Oriented Databases , 1998, DEXA.

[55]  Sunita Sarawagi,et al.  Modeling multidimensional databases , 1997, Proceedings 13th International Conference on Data Engineering.

[56]  Qing Li,et al.  Star/Snow-Flake Schema Driven Object-Relational Data Warehouse - Design and Query Processing Strategies , 1999, DaWaK.