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


General Information
Dataset collected for the experiments of a tool related to the maintenance of data integrity in column-oriented database applications. The excel file contains the following tabs: AllInformation (inputs and outputs of experiments to validate MDICA), CaseStudies (features of three case studies used for the experiments), TestCases (inputs obtained from the systematic testcases design), Valid&InvalidTestsInputs (output applying MDICA), TargetTables (output applying MDICA), CQLs (output applying MDICA).

Name of dataset: 
Dataset collected for the experiments of a tool related to the maintenance of data integrity in column-oriented database applications

Name of data files in data set:
FinalDataset.xlsx

Dataset language:
English

Date the data set was last modified:
23/01/2025

Funder:
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.

How to cite data:
DOI: 10.17811/ruo_datasets.76317

Methodology for data collection: 
The data collected in the excel file are collected from different case studies referenced in the corresponding article.

Data collector(s): 
María José Suárez-Cabal, Pablo Suarez-Otero González

Date of data collection: 
21/02/2022

Person to contact with questions: 
María José Suárez-Cabal (cabal@uniovi.es)

Data entry: 
23/01/2025

Software (including version #) used to prepare data set: 
MS Excel #365


Data processing that was performed: 
The data was grouped and treated as shown in the corresponding article.


Variables
TestCase: name of test case
InsertType: entity, relation and cardinality
Entity/Relation: name of the entity or the relation in the conceptual data model of the corresponding case study
AttributesType: code of operation (what it inserts in the test case)
Attributes: attributes impacted by the operation
Valid: indicates whether the operation is valid or not
#TargetTables: number of target tables impacted by the operation
TargetTable: names of the target tables impacted by the operation
CQLType: types of the CQL statements necessary to maintain the of the data integrity for the operation
CQLSatement: CQL statement
MessageType: type of error generated
MessageSubtype: subtype of the error generated
MessageDescription: description of the message generated


File Overview
FinalDataset.xlsx