Maintenance of Data Cubes and Summary Tables in a Warehouse

SIGMOD Record (ACM Special Interest Group on Management of Data)

Volumn 26, Issue 2, 1997, Pages 100-111

  Mumick, Inderpal Singh ^a   Quass, Dallan ^a   Mumick, Barinderpal Singh ^a  

^a NONE

Author keywords

[No Author keywords available]

Indexed keywords

DATA PROCESSING; DECISION SUPPORT SYSTEMS; INFORMATION MANAGEMENT; ONLINE SYSTEMS; STORAGE ALLOCATION (COMPUTER);

DATA WAREHOUSING; ONLINE ANALYTICAL PROCESSING (OLAP); SUMMARY DELTA TABLE METHOD;

DATABASE SYSTEMS;

EID: 0031169556     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/253262.253277     Document Type: Article

References (32)

1. S. Agarwal, R. Agrawal, P. Deshpande, A. Gupta, J. Naughton, R. Ramakrishnan, and S. Sarawagi. On the computation of multidimensional aggregates. In Vijayaraman et al. [TMB96], pages 506-521.
2. M. Adiba and B. Lindsay. Database snapshots. In Proceedings of the sixth International Conference on Very Large Databases, pages 86-91, Montreal, Canada, October 1980.
3. P. Buneman and E. Clemons. Efficiently monitoring relational databases. ACM Transactions on Database Systems, 4(3):368-382, September 1979.
4. J. Blakeley, P. Larson, and F. Tompa. Efficiently Updating Materialized Views. In Proceedings of ACM SIGMOD 1986 International Conference on Management of Data, pages 61-71, May 1986.
5. L. Colby, T. Griffin, L. Libkin, I. Mumick, and H. Trickey. Algorithms for deferred view maintenance. In Jagadish and Mumick [JM96].
6. th International Conference on Very Large Databases, pages 354-366. Chile, September 1994.
7. M. Carey and D. Schneider, editors. Proceedings of ACM SIGMOD 1995 International Conference on Management of Data, San Jose, CA, May 23-25 1995.
8. S. Ceri and J. Widom. Deriving production rules for incremental view maintenance. In Proceedings of the Seventeenth International Conference on Very Large Databases, pages 108-119, Spain, September 1991.
9. st International Conference on Very Large Databases, Zurich, Switzerland, September 11-15 1995.
10. J. Gray, A. Bosworth, A. Layman, and H. Pirahesh. Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-total. In Proceedings of the Twelfth IEEE International Conference on Data Engineering, pages 152-159, New Orleans, LA, February 26 - March 1 1996.
11. A. Gupta, V. Harinarayan, and D. Quass. Generalized projections: A powerful approach to aggregation. In Dayal et al. [DGN95].
12. A. Gupta, H. Jagadish, and I. Mumick. Data integration using self-maintainable views. In Proceedings of the Fifth International Conference on Extending Database Technology, Avignon, France, March 1996.
13. T. Griffin and L. Libkin. Incremental maintenance of view, with duplicates. In Carey and Schneider [CS95].
14. A. Gupta, I. Mumick, and V. Subrahmanian. Maintaining views incrementally. In Proceedings of ACM SIGMOD 1993 International Conference on Management of Data, Washington, DC, May 26-28 1993.
15. E. Hanson. A performance analysis of view materialization strategies. In Proceeding of ACM SIGMOD 1987 International Conference on Management of Data, pages 440-453, San Francisco, CA, May 1987.
16. V. Harinarayan, A. Rajaraman, and J. Ullman. Implementing data cubes efficiently. In Jagadish and Mumick [JM96], pages 205-216.
17. R. Hull and G. Zhou. A framework for supporting data integration using the materialized and virtual approaches. In Jagadish and Mumick [JM96].
18. H. Jagadish and I. Mumick, editors. Proceedings of ACM SIGMOD 1996 International Conference on Management of Data, Montreal, Canada, June 1996.
19. H. Jagadish, I. Mumick, and A. Silberschatz. View maintenance issues in the chronicle data model. In Proceedings of the Fourteenth Symposium on Principles of Database Systems (PODS), San Jose, CA. 1995.
20. J. Lu, G. Moerkotte, J. Schu, and V. Subrahmanian. Efficient maintenance of materialized mediated views. In Carey and Schneider [CS95].
21. J. Melton and A. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufmann, 1993.
22. D. Quass, A. Gupta, I. Mumick, and J. Widom. Making views self-maintainable for data warehousing. In Proceedings of the Fourth International Conference on Parallel and Distributed Information Systems (PDIS), Miami Beach, FL, December 1996.
23. D. Quass. Maintenance expressions for views with aggregation. Presented at the Workshop on Materialized Views, June 1996.
24. D. Quass. Materialized Views in Data Warehouses. PhD thesis, Stanford University, Department of Computer Science, 1997.
25. X. Qian and G. Wiederhold. Incremental recomputation of active relational expressions. IEEE Transactions on Knowledge and Data Engineering, 3(3):337-341, 1991.
26. N. Roussopoulos and H. Kang. Principles and techniques in the design of ADMS±. IEEE Computer, pages 19-25, December 1986.
27. S. Sarawagi, R. Agrawal, and A. Gupta. On computing the data cube. Research report rj 10026, IBM Almaden Research Center, San Jose, California, 1996.
28. O. Shmueli and A. Itai. Maintenance of Views. In Proceedings of ACM SIGMOD 1984 International Conference on Management of Data, pages 240-255, 1984.
29. A. Segev and J. Park. Updating distributed materialized views. IEEE Transactions on Knowledge and Data Engineering, 1(2):173-184, June 1989.
30. nd International Conference on Very Large Databases, Mumbai, India, September 3-6 1996.
31. W. Yan and P. Larson. Eager aggregation and lazy aggregation. In Dayal et al. [DGN95], pages 345-357.
32. Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom. View maintenance in a warehousing environment. In Carey and Schneider [CS95], pages 316-327.