Deriving global and local integrity rules for a distributed database
An important aim of a database system is to guarantee database consistency, which means that the data contained in a database is both accurate and valid. Integrity constraints represent knowledge about data with which a database must be consistent. The process of checking constraints to ensure that...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Faculty of Computer Science and Information Technology, University of Malaya
2001
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/49474/ http://psasir.upm.edu.my/id/eprint/49474/1/Deriving%20global%20and%20local%20integrity%20rules%20for%20a%20distributed%20database.pdf |
| _version_ | 1848851278102265856 |
|---|---|
| author | Ibrahim, Hamidah |
| author_facet | Ibrahim, Hamidah |
| author_sort | Ibrahim, Hamidah |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | An important aim of a database system is to guarantee database consistency, which means that the data contained in a database is both accurate and valid. Integrity constraints represent knowledge about data with which a database must be consistent. The process of checking constraints to ensure that update operations or transactions which alter the database will preserve its consistency has proved to be extremely difficult to implement, particularly in a distributed database. In this paper, we describe an enforcement algorithm based on the rule mechanisms for a distributed database which aims at minimising the amount of data that has to be accessed or transferred across the underlying network by maintaining the consistency of the database at a single site, i.e. at the site where the update is to be performed. Our technique referred to as the integrity test generation, derives global and local integrity rules has effectively reduced the cost of constraint checking in a distributed environment. |
| first_indexed | 2025-11-15T10:19:38Z |
| format | Article |
| id | upm-49474 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T10:19:38Z |
| publishDate | 2001 |
| publisher | Faculty of Computer Science and Information Technology, University of Malaya |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-494742016-12-30T02:52:10Z http://psasir.upm.edu.my/id/eprint/49474/ Deriving global and local integrity rules for a distributed database Ibrahim, Hamidah An important aim of a database system is to guarantee database consistency, which means that the data contained in a database is both accurate and valid. Integrity constraints represent knowledge about data with which a database must be consistent. The process of checking constraints to ensure that update operations or transactions which alter the database will preserve its consistency has proved to be extremely difficult to implement, particularly in a distributed database. In this paper, we describe an enforcement algorithm based on the rule mechanisms for a distributed database which aims at minimising the amount of data that has to be accessed or transferred across the underlying network by maintaining the consistency of the database at a single site, i.e. at the site where the update is to be performed. Our technique referred to as the integrity test generation, derives global and local integrity rules has effectively reduced the cost of constraint checking in a distributed environment. Faculty of Computer Science and Information Technology, University of Malaya 2001 Article PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/49474/1/Deriving%20global%20and%20local%20integrity%20rules%20for%20a%20distributed%20database.pdf Ibrahim, Hamidah (2001) Deriving global and local integrity rules for a distributed database. Malaysian Journal of Computer Science, 14 (2). pp. 70-80. ISSN 0127-9084 http://e-journal.um.edu.my/publish/MJCS/140-155 |
| spellingShingle | Ibrahim, Hamidah Deriving global and local integrity rules for a distributed database |
| title | Deriving global and local integrity rules for a distributed database |
| title_full | Deriving global and local integrity rules for a distributed database |
| title_fullStr | Deriving global and local integrity rules for a distributed database |
| title_full_unstemmed | Deriving global and local integrity rules for a distributed database |
| title_short | Deriving global and local integrity rules for a distributed database |
| title_sort | deriving global and local integrity rules for a distributed database |
| url | http://psasir.upm.edu.my/id/eprint/49474/ http://psasir.upm.edu.my/id/eprint/49474/ http://psasir.upm.edu.my/id/eprint/49474/1/Deriving%20global%20and%20local%20integrity%20rules%20for%20a%20distributed%20database.pdf |