A framework for checking and ranking integrity constraints in a distributed database
The essential aim of a database system is to guarantee database consistency, which means that the data contained in a database is both accurate and valid. Checking the consistency of a database state generally involves the execution of integrity tests (query that returns the value true or false) on...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Advanced Institute of Convergence Information Technology
2011
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/22473/1/A%20framework%20for%20checking%20and%20ranking%20integrity%20constraints%20in%20a%20distributed%20database.pdf |
| _version_ | 1796970167810392064 |
|---|---|
| author | Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura |
| author_facet | Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura |
| author_sort | Alwan, Ali Amer |
| collection | UPM |
| description | The essential aim of a database system is to guarantee database consistency, which means that the data contained in a database is both accurate and valid. Checking the consistency of a database state generally involves the execution of integrity tests (query that returns the value true or false) on the database, which verify whether the database is satisfying its constraints or not. The process of checking integrity constraints has proved to be extremely difficult to implement, particularly in distributed database. This paper proposed a framework for checking integrity constraints in a distributed database by utilizing as much as possible the local information stored at the target site. The proposed framework consists of two main processes, namely: (i) simplify the integrity constraints to produce support tests and integrate them with complete and sufficient tests and (ii) select the most suitable test from several alternative tests when an update operation is submitted to the system. Including these processes in the proposed framework has optimized the process of checking the consistency of the distributed database by reducing the amount of data transferred across the network, the amount of data accessed, the number of sites involved, and the number of integrity constraints to be evaluated. |
| first_indexed | 2024-03-06T07:54:03Z |
| format | Article |
| id | upm.eprints-22473 |
| institution | Universiti Putra Malaysia |
| language | English |
| last_indexed | 2024-03-06T07:54:03Z |
| publishDate | 2011 |
| publisher | Advanced Institute of Convergence Information Technology |
| record_format | dspace |
| spelling | upm.eprints-224732016-06-10T08:46:21Z http://psasir.upm.edu.my/id/eprint/22473/ A framework for checking and ranking integrity constraints in a distributed database Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura The essential aim of a database system is to guarantee database consistency, which means that the data contained in a database is both accurate and valid. Checking the consistency of a database state generally involves the execution of integrity tests (query that returns the value true or false) on the database, which verify whether the database is satisfying its constraints or not. The process of checking integrity constraints has proved to be extremely difficult to implement, particularly in distributed database. This paper proposed a framework for checking integrity constraints in a distributed database by utilizing as much as possible the local information stored at the target site. The proposed framework consists of two main processes, namely: (i) simplify the integrity constraints to produce support tests and integrate them with complete and sufficient tests and (ii) select the most suitable test from several alternative tests when an update operation is submitted to the system. Including these processes in the proposed framework has optimized the process of checking the consistency of the distributed database by reducing the amount of data transferred across the network, the amount of data accessed, the number of sites involved, and the number of integrity constraints to be evaluated. Advanced Institute of Convergence Information Technology 2011 Article PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/22473/1/A%20framework%20for%20checking%20and%20ranking%20integrity%20constraints%20in%20a%20distributed%20database.pdf Alwan, Ali Amer and Ibrahim, Hamidah and Udzir, Nur Izura (2011) A framework for checking and ranking integrity constraints in a distributed database. Journal of Next Generation Information Technology, 2 (1). pp. 37-48. ISSN 2092-8637; ESSN: 2233-9388 http://www.aicit.org/dl/citation.html?id=JNIT-40 10.4156/ jnit.vol2. issue1.5 |
| spellingShingle | Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura A framework for checking and ranking integrity constraints in a distributed database |
| title | A framework for checking and ranking integrity constraints in a distributed database |
| title_full | A framework for checking and ranking integrity constraints in a distributed database |
| title_fullStr | A framework for checking and ranking integrity constraints in a distributed database |
| title_full_unstemmed | A framework for checking and ranking integrity constraints in a distributed database |
| title_short | A framework for checking and ranking integrity constraints in a distributed database |
| title_sort | framework for checking and ranking integrity constraints in a distributed database |
| url | http://psasir.upm.edu.my/id/eprint/22473/1/A%20framework%20for%20checking%20and%20ranking%20integrity%20constraints%20in%20a%20distributed%20database.pdf |
| work_keys_str_mv | AT alwanaliamer aframeworkforcheckingandrankingintegrityconstraintsinadistributeddatabase AT ibrahimhamidah aframeworkforcheckingandrankingintegrityconstraintsinadistributeddatabase AT udzirnurizura aframeworkforcheckingandrankingintegrityconstraintsinadistributeddatabase AT alwanaliamer frameworkforcheckingandrankingintegrityconstraintsinadistributeddatabase AT ibrahimhamidah frameworkforcheckingandrankingintegrityconstraintsinadistributeddatabase AT udzirnurizura frameworkforcheckingandrankingintegrityconstraintsinadistributeddatabase |