A strategy for semantic integrity checking in distributed databases
Integrity constraints represent knowledge about data with which a database must be consistent. The process of checking constraints to ensure that the update operations or transactions which alter the database will preserve its consistency has proved to be extremely difficult to implement efficiently...
| Main Author: | |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
IEEE
2002
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/47706/ http://psasir.upm.edu.my/id/eprint/47706/1/A%20strategy%20for%20semantic%20integrity%20checking%20in%20distributed%20databases.pdf |
| _version_ | 1848850884112416768 |
|---|---|
| author | Ibrahim, Hamidah |
| author_facet | Ibrahim, Hamidah |
| author_sort | Ibrahim, Hamidah |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | Integrity constraints represent knowledge about data with which a database must be consistent. The process of checking constraints to ensure that the update operations or transactions which alter the database will preserve its consistency has proved to be extremely difficult to implement efficiently, particularly in a distributed environment. In the literature, most of the approaches/methods proposed for finding/deriving a good set of integrity constraints concentrate on deriving simplified forms of the constraints by analyzing both the syntax of the constraints and their appropriate update operations. These methods are based on syntactic criteria and are limited to simple types of integrity constraints. Also, these methods are only able to produce one integrity test for each integrity constraint. In Ibrahim, Gray, and Fiddian (1997), we introduced an integrity constraint subsystem for a relational distributed database. The subsystem consists of several techniques necessary for efficient constraint checking, particularly in a distributed environment where data distribution is transparent to application domain. However, the technique proposed for generating integrity tests is limited to several types of integrity constraints, namely: domain, key, referential and simple general semantic constraint and only produced two integrity tests (global and local) for a given integrity constraint. In this paper, we present a technique for deriving several integrity tests for a given integrity constraint where the following types of integrity constraints are considered: static and transition constraints. |
| first_indexed | 2025-11-15T10:13:22Z |
| format | Conference or Workshop Item |
| id | upm-47706 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T10:13:22Z |
| publishDate | 2002 |
| publisher | IEEE |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-477062016-07-14T06:31:03Z http://psasir.upm.edu.my/id/eprint/47706/ A strategy for semantic integrity checking in distributed databases Ibrahim, Hamidah Integrity constraints represent knowledge about data with which a database must be consistent. The process of checking constraints to ensure that the update operations or transactions which alter the database will preserve its consistency has proved to be extremely difficult to implement efficiently, particularly in a distributed environment. In the literature, most of the approaches/methods proposed for finding/deriving a good set of integrity constraints concentrate on deriving simplified forms of the constraints by analyzing both the syntax of the constraints and their appropriate update operations. These methods are based on syntactic criteria and are limited to simple types of integrity constraints. Also, these methods are only able to produce one integrity test for each integrity constraint. In Ibrahim, Gray, and Fiddian (1997), we introduced an integrity constraint subsystem for a relational distributed database. The subsystem consists of several techniques necessary for efficient constraint checking, particularly in a distributed environment where data distribution is transparent to application domain. However, the technique proposed for generating integrity tests is limited to several types of integrity constraints, namely: domain, key, referential and simple general semantic constraint and only produced two integrity tests (global and local) for a given integrity constraint. In this paper, we present a technique for deriving several integrity tests for a given integrity constraint where the following types of integrity constraints are considered: static and transition constraints. IEEE 2002 Conference or Workshop Item PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/47706/1/A%20strategy%20for%20semantic%20integrity%20checking%20in%20distributed%20databases.pdf Ibrahim, Hamidah (2002) A strategy for semantic integrity checking in distributed databases. In: Ninth International Conference on Parallel and Distributed Systems (ICPADS 2002), 17-20 Dec. 2002, Taiwan. (pp. 139-144). 10.1109/ICPADS.2002.1183390 |
| spellingShingle | Ibrahim, Hamidah A strategy for semantic integrity checking in distributed databases |
| title | A strategy for semantic integrity checking in distributed databases |
| title_full | A strategy for semantic integrity checking in distributed databases |
| title_fullStr | A strategy for semantic integrity checking in distributed databases |
| title_full_unstemmed | A strategy for semantic integrity checking in distributed databases |
| title_short | A strategy for semantic integrity checking in distributed databases |
| title_sort | strategy for semantic integrity checking in distributed databases |
| url | http://psasir.upm.edu.my/id/eprint/47706/ http://psasir.upm.edu.my/id/eprint/47706/ http://psasir.upm.edu.my/id/eprint/47706/1/A%20strategy%20for%20semantic%20integrity%20checking%20in%20distributed%20databases.pdf |