Incremental design of a data warehouse

Journal of Intelligent Information Systems

Volumn 15, Issue 1, 2000, Pages 7-27

  Theodoratos, Dimitri ^a   Sellis, Timos ^a  

^a NATIONAL TECHNICAL UNIVERSITY OF ATHENS   (Greece)

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; COMPUTER SIMULATION; DECISION SUPPORT SYSTEMS; INFORMATION RETRIEVAL SYSTEMS; QUERY LANGUAGES; STORAGE ALLOCATION (COMPUTER);

DATA WAREHOUSE; MATERIALIZED VIEWS; VIEW MAINTENANCE; VIEW SELECTION; VIEW USABILITY;

DATABASE SYSTEMS;

EID: 0034225142     PISSN: 09259902     EISSN: None     Source Type: Journal    
DOI: 10.1023/A:1008773527263     Document Type: Article

References (34)

1. Baralis, E., Paraboshi, S., and Teniente, E. (1997). Materialized View Selection in a Multidimensional Database. In Proc. of the 23rd Intl. Conf. on Very Large Data Bases (pp. 156-165).
2. Blakeley, J.A., Coburn, N., and Larson, P.A. (1989). Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates. ACM Transactions on Database Systems, 14(3), 369-400.
3. Blakeley, J.A., Larson, P., and Tompa, F.W. (1986). Efficiently Updating Materialized Views. In Proc. of the ACM SIGMOD Intl. Conf. on Management of Data (pp. 61-71).
4. Ceri, S. and Widom, J. (1991). Deriving Production Rules for Incremental View Maintenance. In Proc. of the Intl. Conf. on Very Large Data Bases (pp. 577-589).
5. Chaudhuri, S. and Dayal, U. (1997). An Overview of Data Warehousing and OLAP Technology. SIGMOD Record, 26(1), 65-74.
6. Elmasri, R. and Navathe, B. (1994). Fundamentals of Database Systems, 2nd edition. Addison-Wesley Publishing Company.
7. Graefe, G. and McKenna, W.J. (1993). The Volcano Optimizer Generator: Extensibility and Efficient Search. In Proc. of the 9th Intl. Conf. on Data Engineering (pp. 209-217).
8. Griffin, T. and Libkin, L. (1995). Incremental Maintenance of Views with Duplicates. In Proc. of the ACM SIGMOD Intl. Conf. on Management of Data (pp. 328-339).
9. Gupta, H. (1997). Selection of Views to Materialize in a Data Warehouse. In Proc. of the 6th Intl. Conf. on Database Theory (pp. 98-112).
10. Gupta, H., Harinarayan, V., Rajaraman, A., and Ullman, J.D. (1997). Index Selection for OLAP. In Proc. of the 13th Intl. Conf. on Data Engineering (pp. 208-219).
11. Gupta, A., Jagadish, H., and Mumick, I.S. (1996). Data Integration using Self-Maintainable Views. In Proc. of the 5th Intl. Conf. on Extending Database Technology Conf. (pp. 140-144).
12. Gupta, A. and Mumick, I.S. (1995). Maintenance of Materialized Views: Problems, Techniques and Applications. Data Engineering, 18(2): 3-18.
13. Gupta, H. and Mumick, I.S. (1999). Selection of Views to Materialize Under a Maintenance Cost Constraint. In Proc. of the 7th Intl. Conf. on Database Theory (pp. 453-470).
14. Harinarayan, V., Rajaraman, A., and Ullman, J.D. (1996). Implementing Data Cubes Efficiently. In Proc. of the ACM SIGMOD Intl. Conf. on Management of Data.
15. Labio, W., Quass, D., and Adelberg, B. (1997). Physical Database Design for Data Warehousing. In Proc. of the 13th Intl. Conf. on Data Engineering.
16. Levy, A., Mendelson, A.O., Sagiv, Y., and Srivastava, D. (1995). Answering Queries using Views. In Proc. of the ACM Symp. on Principles of Database Systems (pp. 95-104).
17. McKenna, W.J. (1993). Efficient Search in Extensible Database Query Optimization: The Volcano Optimizer Generator. Ph.D. Thesis, University of Colorado.
18. Mohania, M. and Kambayashi, Y. (2000). Making Aggregate Views Self-Maintainable. Knowledge and Data Engineering, 32(1), 87-109.
19. Qian, X. and Wiederhold, G. (1991). Incremental Recomputation of Active Relational Expressions. IEEE Transactions on Knowledge and Data Engineering, 3(3), 439-450.
20. Quass, D., Gupta, A., Mumick, I.S., and Widom, J. (1996). Making Views Self Maintainable for Data Warehousing. In Proc. of the 4th Intl. Conf. on Parallel and Distributed Information Systems (pp. 158-169).
21. Ross, K.A., Srivastava, D., and Sudarshan, S. (1996). Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time. In Proc. of the ACM SIGMOD Intl. Conf. on Management of Data (pp. 447-458).
22. Roussopoulos, N. (1982a). The Logical Access Path Schema of a Database. IEEE Transactions on Software Engineering, 8(2), 563-573.
23. Roussopoulos, N. (1982b). View Indexing in Relational Databases. ACM Transactions on Database Systems, 7(2), 258-290.
24. Roussopoulos, N. (1991). The Incremental Access Method of View Cache: Concepts Algorithms and Cost Analysis. ACM Transactions on Database Systems, 16(3), 535-563.
25. Segev, A. and Fang, W. (1990). Currency-Based Updates to Distributed Materialized Views. In Proc. of the 6th Intl. Conf. on Data Engineering (pp. 512-520).
26. Segev, A. and Park, J. (1989). Updating Distributed Materialized Views. IEEE Transactions on Knowledge and Data Engineering, 1(2), 173-184.
27. Sellis, T.K. (1988). Multiple Query Optimization. ACM Transactions on Database Systems, 13(1), 23-52.
28. Shim, K., Sellis, T.K., and Nau, D. (1994). Improvements on a Heuristic Algorithm for Multiple-Query Optimization. Data & Knowledge Engineering, 12, 197-222.
29. Theodoratos, D., Ligoudistianos, S., and Sellis, T. (1999). Designing the Global Data Warehouse with SPJ Views. In Proc. of the 11th Intl. Conf. on Advanced Information Systems Engineering, Springer-Verlag, LNCS No. 1626 (pp. 180-194).
30. Theodoratos, D. and Sellis, T. (1997). Data Warehouse Configuration. In Proc. of the 23rd Intl. Conf. on Very Large Data Bases (pp. 126-135).
31. Theodoratos, D. and Sellis, T. (1999). Designing Data Warehouses. Data and Knowledge Engineering, 31(3), 279-301.
32. Widom, J. (1995). Research Problems in Data Warehousing. In Proc. of the 4th Intl. Conf. on Information and Knowledge Management (pp. 25-30).
33. Yan, W. and Larson, P.-Å. (1994). Performing Group-By before Join. In Proc. of the 10th Intl. Conf. on Data Engineering (pp. 89-100).
34. Yang, J., Karlapalem, K., and Li, Q. (1997). Algorithms for Materialized View Design in Data Warehousing Environment. In Proc. of the 23rd Intl. Conf. on Very Large Data Bases (pp. 136-145).