Abstract
In the recent years, the database community has witnessed the emergence of a new technology, namely data warehousing. A data warehouse is a global repository that stores pre-processed queries on data which resides in multiple, possibly heterogeneous, operational or legacy sources. The information stored in the data warehouse can be easily and efficiently accessed for making effective decisions. The On-Line Analytical Processing (OLAP) tools access data from the data warehouse for complex data analysis, such as multidimensional data analysis, and decision support activities. Current research has lead to new developments in all aspects of data warehousing, however, there are still a number of problems that need to be solved for making data warehousing effective. In this paper, we discuss recent developments in data warehouse modelling, view maintenance, and parallel query processing. A number of technical issues for exploratory research are presented and possible solutions are discussed.
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.
References
S. Chaudhuri and U. Dayal. An overview of data warehousing and OLAP technology. In ACM SIGMOD Record, volume 26, pages 65–74. 1997.
A. Datta, B. Moon, and H. Thomas. A case for parallelism in data warehousing and olap. Technical report, Dept. of MIS, University of Arizona, Tucson, AZ URL: http://loochi.bpa.arizona.edu, 1998.
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 K.A. Ross. Adapting materialized views after redefinitions. In Proc. ACM SIGMOD International Conference on Management of Data, San Jose, USA, 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.
N. Huyn. Multiple view self-maintenance in data warehousing environ-ments. In To Appear in Proc. Intl Conf. on Very Large Databases, 1997.
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.
V. Küchenhoff. On the efficient computation of the difference between consecutive database states. In C. Delobel, M. Kifer, and Y. Masunaga, editors, Proc. Second Int. Conf. on Deductive Object-Oriented Databases, volume 566 of Lecture Notes in Computer Science, Springer-Verlag, pages 478–502. Springer-Verlag, 1991.
M. Mohania and G. Dong. Algorithms for adapting materialized views in data warehouses. In Proc. of International Symposium on Cooperative Database Systems for Advanced Applications, Kyoto, Japan, pages 62–69, 1996.
M. Mohania, S. Konomi, and Y. Kambayashi. Incremental maintenance of materialized views. In Proc. of 8th International Conference on Database and Expert Systems Applications (DEXA ‘87). Springer-Verlag, 1997.
M. Mohania. Avoiding re-computation: View adaptation in data warehouses. In Proc. of 13th International Database Workshop, Hong Kong, pages 151–165, 1997.
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.
D. Quass and J. Widom. On-line warehouse view maintenance for batch updates. In Proc. ACM SIGMOD Int. Conf. on Management of Data, 1997.
K.A. Ross, D. Srivastava, and Sudarshan S. Materialized view mainte-nance 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.
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
Samtani, S., Mohania, M., Kumar, V., Kambayashi, Y. (1999). Recent Advances and Research Problems in Data Warehousing. In: Kambayashi, Y., Lee, D.L., Lim, EP., Mohania, M.K., Masunaga, Y. (eds) Advances in Database Technologies. ER 1998. Lecture Notes in Computer Science, vol 1552. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-49121-7_7
Download citation
DOI: https://doi.org/10.1007/978-3-540-49121-7_7
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-65690-6
Online ISBN: 978-3-540-49121-7
eBook Packages: Springer Book Archive