Home // DBKDA 2014, The Sixth International Conference on Advances in Databases, Knowledge, and Data Applications // View article

Toward a New Approach of Distributed Databases Design and Implementation

Authors:
Fadoua Hassen
Amel Grissa Touzi

Keywords: distributed databases; fragmentation; fragment allocation; replication

Abstract:
Nowadays, with the development of data and storage of large volumes of distributed and heterogeneous data, Distributed Database Management System (DDBMS) have become essential to most Information Systems (IS). Unfortunately, the designer of Distributed Databases (DDB) has been so far facing several problems, namely, 1) the DDB design is not a simple task and should take into account several constraints and choose accordingly best strategy of fragmentation, allocation and replication of data and 2) DDB implementation should allow the final user to work within a centralized DB, which is not provided directly by the existing DDBMS. To sort out this problem, we suggest in this paper a new approach to help in the DDB design and implementation, which focuses on setting up a layer in the existing DDBMS which will provide 1) Graphical interface to define different sites geographically distributed and 2) Creation of different types of fragmentation, allocation and duplication while validating each step of the process. The system will automatically generate SQL scripts of each site regarding its initial configuration. The so implemented approach reduces the designer's duty by taking in charge the complex distribution validation and heavy manual scripts writing.

Pages: 104 to 110

Copyright: Copyright (c) IARIA, 2014

Publication date: April 20, 2014

Published in: conference

ISSN: 2308-4332

ISBN: 978-1-61208-334-6

Location: Chamonix, France

Dates: from April 20, 2014 to April 24, 2014