Abstract
Database design has always been a challenging problem, more so if the performance of queries is the prime goal. Thus, data warehouse design driven by queries is lot more difficult because of the materialized view selection and maintenance problems. Since user queries change over time, data warehouse design becomes a dynamic problem, that has to contain frequent changes to data warehouse design. In this paper, we advocate the applicability of view normalization technique to facilitate robust data warehouse design and facilitate efficient maintenance of materialized views.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
J. Bailey, G. Dong, M. Mohania, and X. Sean Wang. Distributed view maintenance by incremental semijoin and tagging. Distributed and Parallel Databases, 6(3):287–309, 1998.
T. Griffin and L. Libkin. Incremental maintenance of views with duplicates. In Proc. ACM SIGMOD Int. Conf. on Management of Data, 1995.
A. Gupta and I. S. Mumick. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Warehousing, 18(2), 1995.
A. Gupta, I. S. Mumick, and V. S. Subrahmanian. Maintaining views incrementally. In Proc. ACM SIGMOD Int. Conf. on Management of Data, pages 157–166, 1993.
R. Hull and G. Zhou. A framework for supporting data integration using the materialized and virtual approaches. In Proc. ACM SIGMOD Conf. On Management of Data, pages 481–492, 1996.
Mohania M. K., Karlapalem Kamal, and Vincent Millist. Maintenance of data warehouse views using normalisation. In Proc. of 8th International Conference on Management of Data, Madras, India, pages 32–50, 1997.
Mukesh Mohania and Yahiko Kambayashi. Making aggregate views self-maintainable. Journal of Data and Knowledge Engineering, to appear.
Dallan Quass, Ashish Gupta, Inderpal Singh Mumick, and Jennifer Widom. Making views self-maintainable for data warehousing. In Proc. of International Conference on Parallel and Database Information Systems, 1996.
R. Ramakrishnan, K. A. Ross, D. Srivastava, and S. Sudarshan. Eficient incremental evaluation of queries with aggregation. In Int. Logic Programming Symp., 1994.
K.A. Ross, D. Srivastava, and Sudarshan S. Materialized view maintenance and integrity constraint checking: Trading space for time. In Proc. ACM SIGMOD International Conference on Management of Data, Montreal, Canada, 1996.
Jennifer Widom. Research problems in data warehousing. In Proc. Fourth Intl. Conference on Information and Knowledge Management, 1995.
J. Yang, K. Karlapalem, and Q. Li. Algorithms for materialized view design in data warehousing environment. In Proc. of International conference on Very Large Databases, 1997.
Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom. View maintenance in a warehousing environment. In Proc. ACM SIGMOD Int. Conf. on Management of Data, pages 316–327, 1995.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Mohania, M., Karlapalem, K., Kambayashi, Y. (1999). Invited Talk: Data Warehouse Design and Maintenance through View Normalizaiton. In: Bench-Capon, T.J., Soda, G., Tjoa, A.M. (eds) Database and Expert Systems Applications. DEXA 1999. Lecture Notes in Computer Science, vol 1677. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48309-8_69
Download citation
DOI: https://doi.org/10.1007/3-540-48309-8_69
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66448-2
Online ISBN: 978-3-540-48309-0
eBook Packages: Springer Book Archive