Title
Generating repair rules for database integrity maintenance
Abstract
Repair system has two essential components, which are much related to each other. When the update operation is executed, the first component is the detection of the erroneous state if any and the second component is to repair this state by finding the changes to the update operation that would repair it. Failing to have the second component, which is the repair action, will enforce the user to manually correcting and reentering an erroneous update operation. Our approach will take advantage of the integrity before the update operation, which will result on limiting the detection only to the database state after the update operation. Also the repair component will take advantage of the integrity before the update operation and integrity violation after the update operation but before the repair. The focus of this paper is to generate repairs for all first order constraints, and by using only substitution with no resolution search. Multiple constraints can be satisfied in parallel without a sequential process with no possibility of cyclic violation.
Year
DOI
Venue
2013
10.1007/978-3-319-00945-2_19
NEW RESULTS IN DEPENDABILITY AND COMPUTER SYSTEMS
Field
DocType
Volume
Relational database,Computer science,First order,Disjunctive normal form,Algorithm,Data integrity,Repair - action,Reliability engineering,Limiting
Conference
224
ISSN
Citations 
PageRank 
2194-5357
0
0.34
References 
Authors
7
2
Name
Order
Citations
PageRank
Feras Hanandeh1124.45
yaser quasmeh200.34