Paper Info
Title
Static detection of sources of dynamic anomalies in a network of referential integrity restrictions
Abstract
Under certain circumstances, basic operations over tables in a relational database, where integrity reslxictions such as referential and null restrictions have been specified, may produce unpredictable results, not detectable by means of a static analysis of the schema. When the design includes redundancies or when the set of restrictions is contradictory it is easy to detect and prevent future exrors, but there are situations that require a dynamic analysis. In this paper, the properties of networks of referencial integrity reslfictions that contain irregularities are analyzed, and the mtomalies that may appear when data act~mlization in such environment is done are studied in order to define criteria and develop an algorithm to generate rules for proper handling of inconsistencies.
Year
DOI
Venue
2000
10.1145/335603.335785
SAC (1)
Keywords
Field
DocType
referential integrity,dynamic anomaly,integrity restrictions,static detection,anomalous updates,database updates,referential integrity restriction,dynamic analysis,relational database,static analysis
Data mining,Information retrieval,Computer science,Referential integrity
Conference
ISBN
Citations 
PageRank 
1-58113-240-9
0
0.34
References 
Authors
5
3
Name
Order
Citations
PageRank
Laura C. Rivero192.34
Jorge H. Doorn200.68
Daniel Loureiro314.07