repAIrC: A Tool for Ensuring Data Consistency by Means of Active Integrity Constraints

Luis Cruz-Filipe, Michael Franz, Artavazd Hakhverdyan, Marta Ludovico, Isabel Nunes, Peter Schneider-Kamp

Research output: Chapter in Book/Report/Conference proceedingArticle in proceedingsResearchpeer-review

Abstract

Consistency of knowledge repositories is of prime importance in organization management. Integrity constraints are a well-known vehicle for specifying data consistency requirements in knowledge bases; in particular, active integrity constraints go one step further, allowing the specification of preferred ways to overcome inconsistent situations in the context of database management. This paper describes a tool to validate an SQL database with respect to a given set of active integrity constraints, proposing possible repairs in case the database is inconsistent. The tool is able to work with the different kinds of repairs proposed in the literature, namely simple, founded, well-founded and justified repairs. It also implements strategies for parallelizing the search for them, allowing the user both to compute partitions of independent or stratified active integrity constraints, and to apply these partitions to find repairs of inconsistent databases efficiently in parallel.
Original languageEnglish
Title of host publicationProceedings of the 7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management (IC3K2015)
EditorsAna Fred, Jan Dietz, David Aveiro, Kecheng Liu, Joaquim Filipe
Volume3
PublisherSCITEPRESS Digital Library
Publication date12. Nov 2015
Pages17-26
ISBN (Electronic)978-989-758-158-8
DOIs
Publication statusPublished - 12. Nov 2015
Event7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management - Lisbon, Portugal
Duration: 12. Nov 201514. Nov 2015

Conference

Conference7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management
CountryPortugal
CityLisbon
Period12/11/201514/11/2015

Fingerprint

Repair
Specifications

Cite this

Cruz-Filipe, L., Franz, M., Hakhverdyan, A., Ludovico, M., Nunes, I., & Schneider-Kamp, P. (2015). repAIrC: A Tool for Ensuring Data Consistency by Means of Active Integrity Constraints. In A. Fred, J. Dietz, D. Aveiro, K. Liu, & J. Filipe (Eds.), Proceedings of the 7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management (IC3K2015) (Vol. 3, pp. 17-26). SCITEPRESS Digital Library. https://doi.org/10.5220/0005586400170026
Cruz-Filipe, Luis ; Franz, Michael ; Hakhverdyan, Artavazd ; Ludovico, Marta ; Nunes, Isabel ; Schneider-Kamp, Peter. / repAIrC : A Tool for Ensuring Data Consistency by Means of Active Integrity Constraints. Proceedings of the 7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management (IC3K2015). editor / Ana Fred ; Jan Dietz ; David Aveiro ; Kecheng Liu ; Joaquim Filipe. Vol. 3 SCITEPRESS Digital Library, 2015. pp. 17-26
@inproceedings{3fdb78a05b3e4b16b81cace310226ee3,
title = "repAIrC: A Tool for Ensuring Data Consistency by Means of Active Integrity Constraints",
abstract = "Consistency of knowledge repositories is of prime importance in organization management. Integrity constraints are a well-known vehicle for specifying data consistency requirements in knowledge bases; in particular, active integrity constraints go one step further, allowing the specification of preferred ways to overcome inconsistent situations in the context of database management. This paper describes a tool to validate an SQL database with respect to a given set of active integrity constraints, proposing possible repairs in case the database is inconsistent. The tool is able to work with the different kinds of repairs proposed in the literature, namely simple, founded, well-founded and justified repairs. It also implements strategies for parallelizing the search for them, allowing the user both to compute partitions of independent or stratified active integrity constraints, and to apply these partitions to find repairs of inconsistent databases efficiently in parallel.",
author = "Luis Cruz-Filipe and Michael Franz and Artavazd Hakhverdyan and Marta Ludovico and Isabel Nunes and Peter Schneider-Kamp",
year = "2015",
month = "11",
day = "12",
doi = "10.5220/0005586400170026",
language = "English",
volume = "3",
pages = "17--26",
editor = "Ana Fred and Jan Dietz and David Aveiro and Kecheng Liu and Joaquim Filipe",
booktitle = "Proceedings of the 7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management (IC3K2015)",
publisher = "SCITEPRESS Digital Library",

}

Cruz-Filipe, L, Franz, M, Hakhverdyan, A, Ludovico, M, Nunes, I & Schneider-Kamp, P 2015, repAIrC: A Tool for Ensuring Data Consistency by Means of Active Integrity Constraints. in A Fred, J Dietz, D Aveiro, K Liu & J Filipe (eds), Proceedings of the 7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management (IC3K2015). vol. 3, SCITEPRESS Digital Library, pp. 17-26, 7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management, Lisbon, Portugal, 12/11/2015. https://doi.org/10.5220/0005586400170026

repAIrC : A Tool for Ensuring Data Consistency by Means of Active Integrity Constraints. / Cruz-Filipe, Luis; Franz, Michael; Hakhverdyan, Artavazd; Ludovico, Marta; Nunes, Isabel; Schneider-Kamp, Peter.

Proceedings of the 7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management (IC3K2015). ed. / Ana Fred; Jan Dietz; David Aveiro; Kecheng Liu; Joaquim Filipe. Vol. 3 SCITEPRESS Digital Library, 2015. p. 17-26.

Research output: Chapter in Book/Report/Conference proceedingArticle in proceedingsResearchpeer-review

TY - GEN

T1 - repAIrC

T2 - A Tool for Ensuring Data Consistency by Means of Active Integrity Constraints

AU - Cruz-Filipe, Luis

AU - Franz, Michael

AU - Hakhverdyan, Artavazd

AU - Ludovico, Marta

AU - Nunes, Isabel

AU - Schneider-Kamp, Peter

PY - 2015/11/12

Y1 - 2015/11/12

N2 - Consistency of knowledge repositories is of prime importance in organization management. Integrity constraints are a well-known vehicle for specifying data consistency requirements in knowledge bases; in particular, active integrity constraints go one step further, allowing the specification of preferred ways to overcome inconsistent situations in the context of database management. This paper describes a tool to validate an SQL database with respect to a given set of active integrity constraints, proposing possible repairs in case the database is inconsistent. The tool is able to work with the different kinds of repairs proposed in the literature, namely simple, founded, well-founded and justified repairs. It also implements strategies for parallelizing the search for them, allowing the user both to compute partitions of independent or stratified active integrity constraints, and to apply these partitions to find repairs of inconsistent databases efficiently in parallel.

AB - Consistency of knowledge repositories is of prime importance in organization management. Integrity constraints are a well-known vehicle for specifying data consistency requirements in knowledge bases; in particular, active integrity constraints go one step further, allowing the specification of preferred ways to overcome inconsistent situations in the context of database management. This paper describes a tool to validate an SQL database with respect to a given set of active integrity constraints, proposing possible repairs in case the database is inconsistent. The tool is able to work with the different kinds of repairs proposed in the literature, namely simple, founded, well-founded and justified repairs. It also implements strategies for parallelizing the search for them, allowing the user both to compute partitions of independent or stratified active integrity constraints, and to apply these partitions to find repairs of inconsistent databases efficiently in parallel.

U2 - 10.5220/0005586400170026

DO - 10.5220/0005586400170026

M3 - Article in proceedings

VL - 3

SP - 17

EP - 26

BT - Proceedings of the 7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management (IC3K2015)

A2 - Fred, Ana

A2 - Dietz, Jan

A2 - Aveiro, David

A2 - Liu, Kecheng

A2 - Filipe, Joaquim

PB - SCITEPRESS Digital Library

ER -

Cruz-Filipe L, Franz M, Hakhverdyan A, Ludovico M, Nunes I, Schneider-Kamp P. repAIrC: A Tool for Ensuring Data Consistency by Means of Active Integrity Constraints. In Fred A, Dietz J, Aveiro D, Liu K, Filipe J, editors, Proceedings of the 7th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management (IC3K2015). Vol. 3. SCITEPRESS Digital Library. 2015. p. 17-26 https://doi.org/10.5220/0005586400170026