A framework for checking integrity constraints in a distributed database

4964 palavras 20 páginas
Third 2008 International Conference on Convergence and Hybrid Information Technology

A Framework for Checking Integrity Constraints in a Distributed Database
Ali Amer Alwan1, Hamidah Ibrahim2, Nur Izura Udzir3 Department of Computer Science Faculty of Computer Science and Information Technology Universiti Putra Malaysia, 43400 Serdang, Malaysia 1 alialgobori@yahoo.com, 2hamidah@fsktm.upm.edu.my, 3izura@fsktm.upm.edu.my Abstract
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. integrity tests on the database which verify whether the database is satisfying its constraints or not. The growing complexity of modern database applications plus the need to support multiple users has further increased the need for a powerful

Relacionados

  • Autoself managment
    88442 palavras | 354 páginas
  • Banco de dados
    60359 palavras | 242 páginas
  • None
    14927 palavras | 60 páginas
  • Ms application architecture
    173875 palavras | 696 páginas
  • Teste um
    40208 palavras | 161 páginas
  • Sql transact
    155608 palavras | 623 páginas
  • Server 2008
    151183 palavras | 605 páginas
  • Pericia forence
    37058 palavras | 149 páginas
  • A time petri net-based methodology for embedded hard real-time software synthesis
    79672 palavras | 319 páginas
  • O processo de subjeção do homen
    131727 palavras | 527 páginas