dc.contributor.author | Suárez Cabal, María José | |
dc.contributor.author | Suárez-Otero González, Pablo | |
dc.contributor.author | Riva Álvarez, Claudio A. de la | |
dc.contributor.author | Tuya González, Pablo Javier | |
dc.date.accessioned | 2022-04-18T06:49:29Z | |
dc.date.available | 2022-04-18T06:49:29Z | |
dc.date.issued | 2023-01 | |
dc.identifier.citation | Computer Standards & Interfaces, 83 (2023); doi:10.1016/j.csi.2022.103642 | |
dc.identifier.issn | 0920-5489 | |
dc.identifier.uri | http://hdl.handle.net/10651/62698 | |
dc.description.abstract | Current 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.sponsorship | This 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.iso | eng | spa |
dc.relation.ispartof | Computer Standards & Interfaces, 83 | spa |
dc.rights | Attribution-NonCommercial-NoDerivatives 4.0 Internacional | * |
dc.rights | © 2022 The Authors. Published by Elsevier B.V. | |
dc.rights.uri | http://creativecommons.org/licenses/by-nc-nd/4.0/ | * |
dc.subject | NoSQL; Column-oriented database; Cassandra; Database application; Data integrity | spa |
dc.title | MDICA: Maintenance of Data Integrity in Column-oriented database Applications | spa |
dc.type | journal article | spa |
dc.identifier.doi | 10.1016/j.csi.2022.103642 | |
dc.local.notes | OA ATUO22 | |
dc.relation.projectID | TIN2016–76956-C3–1-R | spa |
dc.relation.projectID | info:eu-repo/grantAgreement/AEI/Plan Estatal de Investigación Científica y Técnica y de Innovación 2017-2020/PID2019-105455GB-C32/ES/PRUEBAS DE SOFTWARE MAS ALLA DE LAS UNITARIAS Y DE SQL/ | spa |
dc.relation.publisherversion | https://doi.org/10.1016/j.csi.2022.103642 | |
dc.rights.accessRights | open access | spa |
dc.type.hasVersion | VoR | |