Show simple item record

MDICA: Maintenance of Data Integrity in Column-oriented database Applications

dc.contributor.authorSuárez Cabal, María José 
dc.contributor.authorSuárez-Otero González, Pablo 
dc.contributor.authorRiva Álvarez, Claudio A. de la 
dc.contributor.authorTuya González, Pablo Javier
dc.identifier.citationComputer Standards & Interfaces, 83 (2023); doi:10.1016/j.csi.2022.103642
dc.description.abstractCurrent information technologies generate large amounts of data for management or further analysis, storing it in NoSQL databases which provide horizontal scaling and high performance, supporting many read/write operations per second. NoSQL column-oriented databases, such as Cassandra and HBase, are usually modelled following a query-driven approach, resulting in denormalized databases where the same data can be repeated in several tables. Therefore, maintaining data integrity relies on client applications to ensure that, for data changes that occur, the affected tables will be appropriately updated. We devise a method called MDICA that, given a data insertion at a conceptual level, determines the required actions to maintain database integrity in column-oriented databases. This method is implemented for Cassandra database applications. MDICA is based on the definition of (1) rules to determine the tables that will be impacted by the insertion, (2) procedures to generate the statements to ensure data integrity and (3) messages to warn the user about errors or potential problems. This method helps developers in two ways: generating the statements needed to maintain data integrity and producing messages to avoid problems such as loss of information, redundant repeated data or gaps of information in
dc.description.sponsorshipThis work was supported in part by projects TIN2016–76956-C3–1-R funded by the Spanish Ministry of Economy and Competitiveness and PID2019–105455GB-C32 funded by MCIN/ AEI/10.13039/
dc.relation.ispartofComputer Standards & Interfaces, 83spa
dc.rightsAttribution-NonCommercial-NoDerivatives 4.0 Internacional*
dc.rights© 2022 The Authors. Published by Elsevier B.V.
dc.subjectNoSQL; Column-oriented database; Cassandra; Database application; Data integrityspa
dc.titleMDICA: Maintenance of Data Integrity in Column-oriented database Applicationsspa

Files in this item


This item appears in the following Collection(s)

Show simple item record

Attribution-NonCommercial-NoDerivatives 4.0 Internacional
This item is protected with a Creative Commons License