Skip to main content
SpringerLink
Log in

Managing Time Consistency for Active Data Warehouse Environments

  • Conference paper
  • First Online:
Data Warehousing and Knowledge Discovery (DaWaK 2001)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2114))

Included in the following conference series:

Abstract

Real-world changes are generally discovered delayed by computer systems. The typical update patterns for traditional data warehouses on an overnight or even weekly basis enlarge this propagation delay until the information is available to knowledge workers. Typically, traditional data warehouses focus on summarized data (at some level) rather than detail data. For active data warehouse environments, also detailed data about individual entities are required for checking the data conditions and triggering actions. Hence, keeping data current and consistent in that context is not an easy task. In this paper we present an approach for modeling conceptual time consistency problems and introduce a data model that deals with timely delays. It supports knowledge workers, to find out, why (or why not) an active system responded to a certain state of the data. Therefore the model enables analytical processing of detail data (enhanced by valid time) based on a knowledge state at a specified instant of time. All states that were not yet knowable to the system at that point in time are consistently ignored.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Ballou, D.P., Tayi, G.K.: Enhancing Data Quality in Data Warehouse Environments. Communications of the ACM, Vol. 42(1): pp. 73–78, 1999.

    Article  Google Scholar 

  2. Bliujute, R., Saltenis, S., Slivinskas, G., Jensen, C.S.: Systematic Change Management in Dimensional Data Warehousing. Technical Report TR-23, TIMECENTER, January 1998.

    Google Scholar 

  3. Böhlen, M.H., Busatto, R., Jensen, C.S.: Point-Versus Interval-Based Temporal Data Models. Proc. of 14th Intl. Conf. ICDE, IEEE Comp. Society Press, pp. 192–201, Orlando, USA, 1998.

    Google Scholar 

  4. Dittrich, K.R., Gatziu, St.: Aktive Datenbanksysteme. Dpunkt. Verlag, Heidelberg, 2000.

    MATH  Google Scholar 

  5. Dyreson, C.E., Evans, W.S., Hong, L., Snodgrass, R.T.: Efficiently Supporting Time Granularities. In IEEE Trans. on Knowledge and Data Engineer., Vol. 12(4): pp. 568–587, 2000.

    Article  Google Scholar 

  6. English, L.P.: Improving Data Warehouse and Business Information Quality. John Wiley and Sons, New York, 1999.

    Google Scholar 

  7. Inmon, W.H.: Building the Data Warehouse. John Wiley and Sons, New York, 1996.

    Google Scholar 

  8. Jensen, C.S., Dyreson, C.E., (eds): The Consensus Glossary of Temporal Database Concepts. In Temporal Databases: Research and Practice, Springer, LNCS 1399, pp. 367–405, 1998.

    Google Scholar 

  9. Jensen, C.S., Snodgrass, R.T.: Temporal Data Management. In IEEE Transactions on Knowledge and Data Engineering, Vol. 11(1): pp. 36–44, 1999.

    Article  Google Scholar 

  10. Roddick, J.F., Schrefl, M.: Towards an Accommodation of Delay in Temporal Active Databases. Proceedings of the 11th Australasien Database Conference (ADC2000), IEEE Computer Society, pp. 115–119, Canberra, Australia, 2000.

    Google Scholar 

  11. Rundensteiner, E.A., Koeller, A., Zhang, X.: Maintaining Data Warehouses over Changing Information Sources. Communications of the ACM, Vol. 43(6): pp. 57–62, 2000.

    Article  Google Scholar 

  12. Salzberg, B., Tsotras, V.J.: Comparison of access methods for time-evolving data. In ACM Computing Surveys, Vol. 31(2): pp. 158–221, 1999.

    Article  Google Scholar 

  13. Schrefl, M., Thalhammer, T.: On Making Data Warehouses Active. Proceedings of the 2nd International Conference DaWaK, Springer, LNCS 1874, pp. 34–46, London, UK, 2000.

    Google Scholar 

  14. Torp, K., Jensen, C.S., Snodgrass, R.T.: Effective Timestamping in Databases. The VLDB Journal, Vol. 8,Issue 3-4, pp. 267–288, 2000.

    Article  Google Scholar 

  15. Wang, R.Y.: Total Data Quality Management. Communications of the ACM, Vol. 41(2): pp. 58–65, 1998.

    Article  Google Scholar 

  16. Westerman, P.: Data Warehousing: Using the Wal-Mart Model. Morgan Kaufmann Publishers, San Francisco, 2001.

    Google Scholar 

  17. Yang, J., Widom, J.: Temporal View Self-Maintenance. Proceedings of the 8th Intl. Conf. EDBT2000, Springer, LNCS 1777, pp. 395–412, Konstanz, Germany, 2000.

    Google Scholar 

  18. Zaniolo, C., Ceri, S., Faloutsos, C., Snodgrass, R.T., Subrahmanian, V.S., Zicari, R.: Advanced Database Systems. Morgan Kaufmann Publishers, San Francisco, 1997.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institute of Software Technology, Vienna University of Technology, Favoritenstr. 9-11 /188, A, 1040, Vienna, Austria

    Robert M. Bruckner & A. M. Tjoa

Authors
  1. Robert M. Bruckner
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. A. M. Tjoa
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Kyoto University, Kyoto, 606-8501, Japan

    Yahiko Kambayashi

  2. EC3, Siebensterngasse 21/3, 1070, Wien

    Werner Winiwarter

  3. Center for Spatial Information Science (CSIS), University of Tokyo, 4-6-1, Komaba Meguro-ku, Tokyo, 153-8904, Japan

    Masatoshi Arikawa

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Bruckner, R.M., Tjoa, A.M. (2001). Managing Time Consistency for Active Data Warehouse Environments. In: Kambayashi, Y., Winiwarter, W., Arikawa, M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2001. Lecture Notes in Computer Science, vol 2114. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44801-2_25

Download citation

  • DOI: https://doi.org/10.1007/3-540-44801-2_25

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-42553-3

  • Online ISBN: 978-3-540-44801-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation