IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

Improving Constraints Checking in Distributed Databases with Complete, Sufficient, and Support Tests

Improving Constraints Checking in Distributed Databases with Complete, Sufficient, and Support Tests
View Sample PDF
Author(s): Ali Amer Alwan (Universiti Putra Malaysia, Malaysia), Hamidah Ibrahim (Universiti Putra Malaysia, Malaysia)and Nur Izura Udzir (Universiti Putra Malaysia, Malaysia)
Copyright: 2009
Pages: 13
Source title: Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends
Source Author(s)/Editor(s): Viviana E. Ferraggine (UNICEN, Argentina), Jorge Horacio Doorn (UNICEN, Argentina)and Laura C. Rivero (UNICEN, Argentina)
DOI: 10.4018/978-1-60566-242-8.ch037

Purchase

View Improving Constraints Checking in Distributed Databases with Complete, Sufficient, and Support Tests on the publisher's website for pricing and purchasing information.

Abstract

A database state is said to be consistent if and only if it satisfies the set of integrity constraints. A database state may change into a new state when it is updated either by a single update operation (insert, delete, or modify) or by a sequence of updates (transaction). If a constraint is false in the new state, the new state is inconsistent, therefore the enforcement mechanism can either perform compensatory actions to produce a new consistent state, or restore the initial state by undoing the update operation. The steps generate integrity tests that are queries composed from the integrity constraints and the update operations, and run these queries against the database, which check whether all the integrity constraints of the database are satisfied; are referred to as integrity checking (Alwan, Ibrahim, & Udzir, 2007; Ibrahim, 2006; Ibrahim, Gray & Fiddian, 2001), is the main focus of this chapter.

Related Content

Renjith V. Ravi, Mangesh M. Ghonge, P. Febina Beevi, Rafael Kunst. © 2022. 24 pages.
Manimaran A., Chandramohan Dhasarathan, Arulkumar N., Naveen Kumar N.. © 2022. 20 pages.
Ram Singh, Rohit Bansal, Sachin Chauhan. © 2022. 19 pages.
Subhodeep Mukherjee, Manish Mohan Baral, Venkataiah Chittipaka. © 2022. 17 pages.
Vladimir Nikolaevich Kustov, Ekaterina Sergeevna Selanteva. © 2022. 23 pages.
Krati Reja, Gaurav Choudhary, Shishir Kumar Shandilya, Durgesh M. Sharma, Ashish K. Sharma. © 2022. 18 pages.
Nwosu Anthony Ugochukwu, S. B. Goyal. © 2022. 23 pages.
Body Bottom