Satic detection of sources of dynamic anomalies in a network of referential integrity restrictions
Material type:
ArticleDescription: 1 archivo (727,4 KB)Subject(s): Online resources: Summary: 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 analyzed, and the mtomalies are 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.
| Item type | Home library | Collection | Call number | URL | Status | Date due |
|---|---|---|---|---|---|---|
Capítulo de libro
|
Biblioteca de la Facultad de Informática | Biblioteca digital | A0395 (Browse shelf(Opens below)) | Link to resource | Recurso en Línea |
Formato de archivo: PDF. -- Este documento es producción intelectual de la Facultad de Informática - UNLP (Colección BIPA/Biblioteca)
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 analyzed, and the mtomalies are 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.
2000 ACM Symposium on Applied Computing (2000 mar. 19-21 : Villa Olmo, Italia). Nueva York : ACM, 2000, vol. 1, pp. 333-339