Leveraging Conceptual Data Models for Keeping Cassandra Database Integrity

Suárez-Otero, Pablo; Suárez-Cabal, María José; Tuya, Javier

doi:10.5220/0007236303980403

Cited by 2 publications

(1 citation statement)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…In this work we introduce an approach for the maintenance of the data integrity when there are modifications of data. This article is an extension of earlier work [14] incorporating more detail of the top-down use case, a new casuistic for this case where it is necessary to extract values from the database and a detailed description of the experimentation carried out. The contributions of this paper are the following:…”

Section: Introductionmentioning

confidence: 99%

Leveraging Conceptual Data Modelsto Ensure the Integrity of CassandraDatabases

Surez-Otero

Surez-Cabal

Tuya

2019

JWE

Self Cite

View full text Add to dashboard Cite

The use of NoSQL databases for cloud environments has been increasing due to their performance advantages when working with big data. One of the most popular NoSQL databases used for cloud services is Cassandra, in which each table is created to satisfy one query. This means that as the same data could be retrieved by several queries, these data may be repeated in several different tables. The integrity of these data must be maintained in the application that works with the database, instead of in the database itself as in relational databases. In this paper, we propose a method to ensure the data integrity when there is a modification of data by using a conceptual model that is directly connected to the logical model that represents the Cassandra tables. This method identifies which tables are affected by the modification of the data and also proposes how the data integrity of the database may be ensured. We detail the process of this method along with two examples where we apply it in two insertions of tuples in a conceptual model. We also apply this method to a case study where we insert 258 P. Suárez-Otero et al. several tuples in the conceptual model, and then we discuss the results. We have observed how in most cases several insertions are needed to ensure the data integrity as well as needing to look for values in the database in order to do it.

show abstract

Section: Introductionmentioning

confidence: 99%