Location of Repository

A consistency service for replicated heterogeneous databases in a Grid environment

By Laura Iannone


The present work, written during a period of scientific collaboration with INFN (National Institute of Nuclear Physics), proposes a mechanism for maintaining consistency among replicated heterogeneous databases. This mechanism is integrated in a Replica Consistency Service for Data Grid environments. Nowadays, an increasing number of applications, manage an enormous quantity of data distributed on a very large scale. In a Data Grid the data files are replicated to different sites. The replication of data among multiple databases is the only way to ensure that the data are available where and when they are needed. The catalogs, used for maintaining information about the state of file replicas in a Data Grid, use replication to improve availability, to reduce data access latency, and to improve the performances of distributed applications. Moreover it is useful for fault tolerance. A Data Grid may serve different user communities (Virtual Organizations), with different requirements. Therefore different types of data may be stored in different formats and in storage devices of different vendors. A mechanism is needed to maintain consistency among the replicas of a certain catalog that uses heterogeneous back-end databases. In a Data Grid, heterogeneous data storage involves the problem of a uniform interface to access heterogeneous information; this problem requires tools for data integration. Our goal for this work is to provide the ability to manage and to execute a replica synchronization; in particular we have a replica on an Oracle server and another replica on a MySQL server with the same logical schema. With the word "synchronization" we mean that an update of the target database will be done. Only the changes that happen on the source database will be propagated to the target database

Publisher: Pisa University
Year: 2005
OAI identifier: oai:etd.adm.unipi.it:etd-06212005-153510

Suggested articles



  1. (2003). Call Interface Programmer's Guide 10g Release 1 (10.1). Oracle Corporation,
  2. (2005). Constanza project web site: http://infnforge.cnaf.infn.it/projects/constanza/,
  3. (2004). Frohner: EDG-VOMS-ADMIN Developer's guide.
  4. (2003). Gridi Team: VOMS and LCMAPS on Global Permission and Local Credentials. WP4 meeting EDG,
  5. (2005). HIT Software web site: http://www.hitsw.com,
  6. (2005). INFNGrid project web site: http://grid.infn.it/,
  7. (2004). Kurt Stockinger: Replica consistency in a Data Grid. Nuclear Instruments and Methods in Physics Research Section A: Accelerators, Spectrometers, Detectors and Associated Equipment, doi
  8. (2005). LCG project web site: http://cern.ch/lcg/,
  9. (2005). Octopus project web site: http://octopus.objectweb.org/,
  10. (2005). site: http://www.mysql.org, doi
  11. (2005). UNIXODBC project web site: http://www.unixodbc.org,
  12. (2003). VOMS, an Authorization System for Virtual Organizations. DataGrid Project, doi

To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.