Enforcing integrity constraints to preserve data accuracy in business applications

Authors:
Constantin Lupsoiu;Cristea Boboila
Affiliations:
University of Craiova, Faculty of Mathematics and Computer Science, Craiova, Romania;University of Craiova, Faculty of Mathematics and Computer Science, Craiova, Romania
Venue:
MCBE'08 Proceedings of the 9th WSEAS International Conference on Mathematics & Computers In Business and Economics
Year:
2008

Citing 6
Cited 0

Foundations of computer science

Foundations of computer science
Consistent query answers in inconsistent databases

PODS '99 Proceedings of the eighteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
ConQuer: efficient management of inconsistent databases

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
View updating through active integrity constraints

ICLP'07 Proceedings of the 23rd international conference on Logic programming
CHASE2: rule based chase algorithm for information systems of type λ

AM'03 Proceedings of the Second international conference on Active Mining
On the computational complexity of minimal-change integrity maintenance in relational databases

Inconsistency Tolerance

Quantified Score

Hi-index	0.00

Visualization

Abstract

Integrity constraints represent a method of ensuring that database updates do not result in data inconsistencies. For business applications in particular, the accuracy of the data is important. Therefore, we need strong guarantees that the information stored in the database system is not tempered with. This paper presents some algorithms for testing the integrity constraints given by the functional, join and multivalued dependencies. Since the update operations are costly, the algorithms described take into consideration efficiency requirements.