Skip to main content
SpringerLink
Log in
SpringerLink
Log in

Incrementally Maintaining Materialized Temporal Views in Column-Oriented NoSQL Databases with Partial Deltas

  • Conference paper
  • First Online:
New Trends in Databases and Information Systems (ADBIS 2015)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 539))

Included in the following conference series:

  • East European Conference on Advances in Databases and Information Systems

Abstract

Different from the relational database systems, each column in a column-oriented NoSQL database (CoNoSQLDB) maintains multiple data versions in which each data version is attached with an explicit timestamp (TS). In this paper, we study how to maintain the materialized temporal views (MTVs) in CoNoSQLDBs with partial temporal data-changes (deltas). We first review our previous work and indicate that not all change-data capture (CDC) approaches are able to provide complete deltas. Then, we propose approaches for maintaining MTVs with partial deltas.

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. Cange, F., et al.: Bigtable: a distributed storage system for structured data. In: OSDI (2006)

    Google Scholar 

  2. Hu, Y., Dessloch, S.: Defining temporal operators for column oriented NoSQL databases. In: Manolopoulos, Y., Trajcevski, G., Kon-Popovska, M. (eds.) ADBIS 2014. LNCS, vol. 8716, pp. 39–55. Springer, Heidelberg (2014)

    Google Scholar 

  3. Richard, S.: The TSQL2 Temporal Query Language. Kluwer (1995)

    Google Scholar 

  4. Kimbal, R., Kastera, J.: The Data Wareshouse ETL Toolkit. Wiley Publishing (2004)

    Google Scholar 

  5. Yang, J., Widom, J.: Maintaining temporal views over non-temporal information sources for data warehousing. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, p. 389. Springer, Heidelberg (1998)

    Google Scholar 

  6. Jensen, C., et al.: Using differential techniques to efficiently support transaction time. VLDB Journal, 75–116 (1993)

    Google Scholar 

  7. Gupta, A., et al.: Maintenance of Materialized Views: Problems, Techniques and Applications. IEEE Data Eng. Bull. (1995)

    Google Scholar 

  8. Hu, Y., Dessloch, S.: Extracting deltas from column oriented NoSQL databases for different incremental applications and diverse data targets. In: Catania, B., Guerrini, G., Pokorný, J. (eds.) ADBIS 2013. LNCS, vol. 8133, pp. 372–387. Springer, Heidelberg (2013)

    Google Scholar 

  9. Joerg, T., Dessloch, S.: View maintenance using partial deltas. In: BTW (2009)

    Google Scholar 

  10. Hu, Y.: Incrementally Maintaining Materialized Temporal Views in CoNoSQLDBs with Partial Deltas. Technical report, TU Kaiserslautern (2015)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University of Kaiserslautern, Kaiserslautern, Germany

    Yong Hu & Stefan Dessloch

Authors
  1. Yong Hu
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Stefan Dessloch
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Yong Hu .

Editor information

Editors and Affiliations

  1. Poznan University of Technology, Poznan, Poland

    Tadeusz Morzy

  2. INRIA, Montpellier, France

    Patrick Valduriez

  3. National Engineering School for Mechanics and Aerotechnics, Poitiers, France

    Ladjel Bellatreche

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Hu, Y., Dessloch, S. (2015). Incrementally Maintaining Materialized Temporal Views in Column-Oriented NoSQL Databases with Partial Deltas. In: Morzy, T., Valduriez, P., Bellatreche, L. (eds) New Trends in Databases and Information Systems. ADBIS 2015. Communications in Computer and Information Science, vol 539. Springer, Cham. https://doi.org/10.1007/978-3-319-23201-0_11

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-23201-0_11

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-23200-3

  • Online ISBN: 978-3-319-23201-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation