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
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
Cange, F., et al.: Bigtable: a distributed storage system for structured data. In: OSDI (2006)
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)
Richard, S.: The TSQL2 Temporal Query Language. Kluwer (1995)
Kimbal, R., Kastera, J.: The Data Wareshouse ETL Toolkit. Wiley Publishing (2004)
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)
Jensen, C., et al.: Using differential techniques to efficiently support transaction time. VLDB Journal, 75–116 (1993)
Gupta, A., et al.: Maintenance of Materialized Views: Problems, Techniques and Applications. IEEE Data Eng. Bull. (1995)
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)
Joerg, T., Dessloch, S.: View maintenance using partial deltas. In: BTW (2009)
Hu, Y.: Incrementally Maintaining Materialized Temporal Views in CoNoSQLDBs with Partial Deltas. Technical report, TU Kaiserslautern (2015)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)