Authors:
Pablo Suárez-Otero
;
Maria José Suárez-Cabal
and
Javier Tuya
Affiliation:
Computer Science Department, University of Oviedo, Campus de Viesques, Gijón and Spain
Keyword(s):
NoSQL, Conceptual Model, Logical Model, Cassandra, Logical Integrity.
Abstract:
The use of NoSQL databases has recently been increasing, being Cassandra one of the most popular ones. In Cassandra, each table is created to satisfy one query, so, as the same information could be retrieved by several queries, this information may be found in several distinct tables. However, the lack of mechanisms to ensure the integrity of the data means that the integrity could be broken after a modification of data. In this paper, we propose a method for keeping the integrity of the data by using a conceptual model that is directly connected to the logical model that represents the Cassandra tables. Our proposal aims to keep the data integrity automatically by providing a process that will undertake such maintenance when there is a modification of the data in the database. The conceptual model will be used to identify the tables that could have inconsistencies and also assist in resolving them. We also apply this approach to a case study where, given several insertions of tuples
in the conceptual model, we determine what is needed to keep the logical integrity.
(More)