Maintaining temporal views over non-temporal information sources for data warehousing
An important use of data warehousing is to provide temporal views over the history of source data that may itself be non-temporal. While recent work in view maintenance is applicable to data warehousing, only non-temporal views have been considered. In this paper, we introduce a framework for maintaining temporal views over non-temporal information sources in a data warehousing environment. We describe an architecture for the temporal data warehouse that automatically maintains temporal views over non-temporal source relations, and allows users to ask temporal queries using these views. Because of the dimension of time, a materialized temporal view may need to be updated not only when source relations change, but also as time advances. We present incremental techniques to maintain temporal views for both cases.
KeywordsTemporal Relation Data Warehousing Base Relation Time Advance Temporal Database
Unable to display preview. Download preview PDF.
- 3.M. H. Böhlen, C. S. Jensen, and R. T. Snodgrass. Evaluating the completeness of TSQL2. In Proc. of the Intl. Workshop on Temporal Databases, pages 153–174, 1995.Google Scholar
- 6.T. Griffin and L. Libkin. Incremental maintenance of views with duplicates. In Proc. of the 1995 ACM SIGMOD Intl. Conf. on Management of Data, pages 328–339, 1995.Google Scholar
- 7.A. Gupta and I. S. Mumick. Maintenance of materialized views: Problems, techniques, and applications. IEEE Data Eng., 18(2):3–18, 1995.Google Scholar
- 8.H. V. Jagadish, I. S. Mumick, and A. Silberschatz. View maintenance issues for the chronicle data model. In Proc. of the 1995 ACM Symp. on Principles of Database Systems, pages 113–124, 1995.Google Scholar
- 9.C. S. Jensen and L. Mark. Differential query processing in transaction-time databases. In Temporal Databases: Theory, Design, and Implementation, chapter 19, pages 457–491. Benjamin/Cummings, 1993.Google Scholar
- 11.W. Labio and H. Garcia-Molina. Expiring data from the warehouse. Technical report, Computer Science Dept., Stanford Univ., 1997. http://www-db.stanford.edu/pub/papers/expire.ps.Google Scholar
- 14.D. Plexousakis. Integrity constraint and rule maintenance in temporal deductive knowledge bases. In Proc. of the 1993 Intl. Conf. on Very Large Data Bases, pages 146–157, 1993.Google Scholar
- 16.D. Quass. Maintenance expressions for views with aggregation. In Proc. of the ACM Workshop on Materialized Views: Techniques & Applications, pages 110–118, 1996.Google Scholar
- 17.D. Quass, A. Gupta, I. S. Mumick, and J. Widom. Making views self-maintainable for data warehousing. In Proc. of the 1996 Intl. Conf. on Parallel & Distributed Information Systems, 1996.Google Scholar
- 20.J. Widom. Research problems in data warehousing. In Proc. of the 1995 Intl. Conf. on Information & Knowledge Management, pages 25–30, 1995.Google Scholar
- 21.J. L. Wiener, H. Gupta, W. J. Labio, Y. Zhuge, H. Garcia-Molina, and J. Widom. A system prototype for warehouse view maintenance. In Proc. of the ACM Workshop on Materialized Views: Techniques & Applications, pages 26–33, 1996.Google Scholar
- 22.J. Yang and J. Widom. Maintaining temporal views over non-temporal information sources for data warehousing. Technical report, Computer Science Dept., Stanford Univ., 1998. http://www-db.stanford.edu/pub/papers/yw-tempview.ps.Google Scholar