A model for ranking and selecting integrity tests in a distributed database

Alwan, Ali A. and Ibrahim, Hamidah and Udzir, Nur Izura (2010) A model for ranking and selecting integrity tests in a distributed database. International Journal of Information Technology and Web Engineering, 5 (3). pp. 65-84. ISSN 1554-1045

Full text not available from this repository.

Abstract

Checking the consistency of a database state generally involves the execution of integrity tests on the database, which verify whether the database is satisfying its constraints or not. This paper presents the various types of integrity tests as reported in previous works and discusses how these tests can significantly improve the performance of the constraint checking mechanisms without limiting to a certain type of test. Having these test alternatives and selecting the most suitable test is an issue that needs to be tackled. In this regard, the authors propose a model to rank and select the suitable test to be evaluated given several alternative tests. The model uses the amount of data transferred across the network, the number of sites involved, and the amount of data accessed as the parameters in deciding the suitable test. Several analyses have been performed to evaluate the proposed model, and results show that the model achieves a higher percentage of local processing as compared to the previous selected strategies.

Item Type:Article
Keyword:Distributed Database, Integrity Constraints, Integrity Constraints Checking, Integrity Tests, Performance
Subject:Distributed databases.
Subject:Electronic data processing - Distributed processing.
Faculty or Institute:Faculty of Computer Science and Information Technology
Publisher:IGI Global
DOI Number:10.4018/jitwe.2010070104
Altmetrics:http://www.altmetric.com/details.php?domain=psasir.upm.edu.my&doi=10.4018/jitwe.2010070104
ID Code:12724
Deposited By: Umikalthom Abdullah
Deposited On:17 Jan 2012 00:55
Last Modified:17 Jan 2012 00:55

Repository Staff Only: item control page

Document Download Statistics

This item has been downloaded for since 17 Jan 2012 00:55.

View statistics for "A model for ranking and selecting integrity tests in a distributed database"


Universiti Putra Malaysia Institutional Repository

Universiti Putra Malaysia Institutional Repository is an on-line digital archive that serves as a central collection and storage of scientific information and research at the Universiti Putra Malaysia.

Currently, the collections deposited in the IR consists of Master and PhD theses, Master and PhD Project Report, Journal Articles, Journal Bulletins, Conference Papers, UPM News, Newspaper Cuttings, Patents and Inaugural Lectures.

As the policy of the university does not permit users to view thesis in full text, access is only given to the first 24 pages only.