Selecting and materializing horizontally partitioned warehouse views

Data and Knowledge Engineering

Volumn 36, Issue 2, 2001, Pages 185-210

  Ezeife, C I ^a  

^a UNIVERSITY OF WINDSOR   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTATIONAL COMPLEXITY; CONSTRAINT THEORY; DATA STRUCTURES; QUERY LANGUAGES; TABLE LOOKUP;

DATA WAREHOUSE;

DATA MINING;

EID: 0035155609     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0169-023X(00)00044-6     Document Type: Article

References (26)

1. S. Agrawal, R. Agrawal, P.M. Deshpande, A. Gupta, J.F. Naughton, R. Ramkrishna, S. Sarawagi, On the computation of multidimensional aggregates, in: Proceedings of the 22nd International VLDB Conference, 1996.
2. J.A. Blakeley, P.A. Larson, F.W. Tompa, Efficiently updating materialized views, in: Proceedings of the ACM SIGMOD International Conference, May 1986, pp. 61-71.
3. Berson A., Smith S. Data Warehousing, Data Mining and OLAP. 1997;McGraw-Hill, New York.
4. S. Chaudhuri, U. Dayal, An overview of data warehousing and OLAP technology, in: Sigmod Record, vol. 26, 1, March 1997.
5. L.S. Colby, A. Kawaguchi, D.F. Lieuwen, I.S. Mumick, K.A. Ross, Algorithms for deferred view maintenance, in: Proceedings of the ACM SIGMOD International Conference, Montreal, Canada, June 1996, pp. 469-480.
6. L.S. Colby, A. Kawaguchi, D.F. Lieuwen, I.S. Mumick, K.A. Ross, Supporting multiple view maintenance policies, in: Proceedings of the ACM SIGMOD International Conference, Tucson, USA, May 1997, pp. 405-416.
7. Chakravarthy S., Muthuraj J., Varadarajan R., Navathe S.B. An objective function for vertically partitioning relations in distributed databases and its analysis. Distributed and Parallel Databases. 2(1):1993;183-207.
8. Ceri S., Navathe S., Wiederhold G. Distributed design of logical database schemas. IEEE Transactions on Software Engeneering. 9(4):1983.
9. C.I. Ezeife, S.R. Baksh, A partition-selection scheme for warehouse aggregate views, in: Proceeding of the Ninth International Conference on Computing and Information, Canada, July 1998.
10. C.I. Ezeife, K. Barker, Distributed object based design: vertical fragmentation of classes, Journal of Distributed and Parallel Database Systems, Kluwer academic Publishers, vol. 6, 4, 1998, pp. 327-360.
11. C.I. Ezeife, A uniform approach for selecting views and indexes in a data warehouse, in: Proceedings of the 1997 International Database Engineering and Applications Symposium, Montreal, Canada, IEEE publication, August 1997, pp. 151-160.
12. Ezeife C.I. Accommodating dimension hierarchies in a data warehouse view/indexes selection scheme. Wojtkowski W.G., Wojtkowski W., Wrycza S., Zupancic J. Systems Development Methods for the Next Century. 1997;195-211 Plenum Press, New York.
13. J. Gray, A. Bosworth, A. Layman, H. Pirahesh, Data cube: a relational aggregation operator generalizing group-by, cross-tab, and sub-totals, in: Proceedings of the 12th International Conference on Data Engineering, 1996, pp. 152-159.
14. H. Gupta, V. Harinarayan, A. Rajaraman, J. Ullman, Index Selection for OLAP, in: International Conference on Data Engineering, Burmingham, UK, 1997.
15. V. Harinarayan, A. Rajaraman, J. Ullman, Implementing data cubes efficiently, in: ACM SIGMOD International Conference on Management of Data, June 1996, pp. 205-216.
16. Inmon W.H. Building the Data Warehouse. second ed:1996;Wiley, New York.
17. Kimball R. The Data Warehousing Tool kit: Practical Techniques for Building Dimensional Data Warehouses. 1996;Wiley, New York.
18. Y. Kotidis, N. Roussopoulos, DynaMat: A dynamic view management system for data warehouses, in: ACM SIGMOD International Conference on Management of Data, Philadelphia, USA, June 1999, pp. 371-382.
19. Meredith M.E., Khader A. Divide and aggregate: designing large warehouses. Database Programming and Design. 9(6):1996.
20. Ozsu M.T., Valduriez P. Principles of Distributed Database Systems. second ed:1999;Prentice-Hall, Englewood Cliffs, NJ.
21. Ramakrishnan R. Database Management Systems. 1998;McGraw-Hill, New York.
22. S. Sarawagi, R. Agrawal, A. Gupta, On computing the data cube, in: Technical Report RJ 10026, IBM Almaden Research center, San Jose, California, 1996.
23. S. Tideman, R. Chu, Building efficient data warehouses: Understanding the issues of data summarization and partitioning, in: Proceedings of the 21st Annual SAS Users Group International Conference, SUGI 21, vol. 1, 1996, pp. 520-527.
24. J. Widom, Research problems in data warehousing, in: Proceedings of the 4th International Conference on Information and Knowledge Management (CIKM), November 1995.
25. M. Xu, C.I. Ezeife, Maintaining horizontally partitioned warehouse views, in: Proceedings of the 2nd International Conference on Data Warehousing and Knowledge Discovery (DaWaK), DEXA, September 2000, published in the Lecture Notes in Computer Science by Springer, Berlin.
26. M. Xu, Maintaining horizontally partitioned warehouse views, Masters Thesis, Computer Science department, University of Windsor, December 1999.