loading
Documents

Research.Publish.Connect.

Paper

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

ISBN: 978-989-758-324-7

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)

PDF ImageFull Text

Download
Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 54.227.157.163

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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

@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},
}

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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.