Leveraging Conceptual Data Models for Keeping Cassandra Database Integrity

Pablo Suárez-Otero, Maria José Suárez-Cabal, Javier Tuya

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.

Download


Paper Citation


in Harvard Style

Suárez-Otero P., Suárez-Cabal M. and Tuya J. (2018). Leveraging Conceptual Data Models for Keeping Cassandra Database Integrity.In Proceedings of the 14th International Conference on Web Information Systems and Technologies - Volume 1: APMDWE, ISBN 978-989-758-324-7, pages 398-403. DOI: 10.5220/0007236303980403


in Bibtex Style

@conference{apmdwe18,
author={Pablo Suárez-Otero and Maria José Suárez-Cabal and Javier Tuya},
title={Leveraging Conceptual Data Models for Keeping Cassandra Database Integrity},
booktitle={Proceedings of the 14th International Conference on Web Information Systems and Technologies - Volume 1: APMDWE,},
year={2018},
pages={398-403},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0007236303980403},
isbn={978-989-758-324-7},
}


in EndNote Style

TY - CONF

JO - Proceedings of the 14th International Conference on Web Information Systems and Technologies - Volume 1: APMDWE,
TI - Leveraging Conceptual Data Models for Keeping Cassandra Database Integrity
SN - 978-989-758-324-7
AU - Suárez-Otero P.
AU - Suárez-Cabal M.
AU - Tuya J.
PY - 2018
SP - 398
EP - 403
DO - 10.5220/0007236303980403