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.date.accessioned2022-04-18T06:49:29Z
dc.date.available2022-04-18T06:49:29Z
dc.date.issued2023-01
dc.identifier.citationComputer Standards & Interfaces, 83 (2023); doi:10.1016/j.csi.2022.103642
dc.identifier.issn0920-5489
dc.identifier.urihttp://hdl.handle.net/10651/62698
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 tables.spa
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/501100011033.spa
dc.language.isoengspa
dc.relation.ispartofComputer Standards & Interfaces, 83spa
dc.rightsAttribution-NonCommercial-NoDerivatives 4.0 Internacional*
dc.rights© 2022 The Authors. Published by Elsevier B.V.
dc.rights.urihttp://creativecommons.org/licenses/by-nc-nd/4.0/*
dc.subjectNoSQL; Column-oriented database; Cassandra; Database application; Data integrityspa
dc.titleMDICA: Maintenance of Data Integrity in Column-oriented database Applicationsspa
dc.typeinfo:eu-repo/semantics/articlespa
dc.identifier.doi10.1016/j.csi.2022.103642
dc.type.dcmitextspa
dc.relation.projectIDTIN2016–76956-C3–1-Rspa
dc.relation.projectIDPID2019–105455GB-C32spa
dc.relation.publisherversionhttps://doi.org/10.1016/j.csi.2022.103642
dc.rights.accessRightsinfo:eu-repo/semantics/openAccessspa


Files in this item

untranslated

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