Future Internet Technologies and Trends. First International Conference, ICFITT 2017, Surat, India, August 31 - September 2, 2017, Proceedings

Research Article

Ensuring Database and Location Transparency in Multiple Heterogeneous Distributed Databases

Download
331 downloads
  • @INPROCEEDINGS{10.1007/978-3-319-73712-6_16,
        author={Shefali Naik},
        title={Ensuring Database and Location Transparency in Multiple Heterogeneous Distributed Databases},
        proceedings={Future Internet Technologies and Trends. First International Conference, ICFITT 2017, Surat, India, August 31 - September 2, 2017, Proceedings},
        proceedings_a={ICFITT},
        year={2018},
        month={2},
        keywords={Heterogeneous distributed database Database transparency Location transparency Distributed transactions Heterogeneous gateway},
        doi={10.1007/978-3-319-73712-6_16}
    }
    
  • Shefali Naik
    Year: 2018
    Ensuring Database and Location Transparency in Multiple Heterogeneous Distributed Databases
    ICFITT
    Springer
    DOI: 10.1007/978-3-319-73712-6_16
Shefali Naik1,*
  • 1: Ahmedabad University
*Contact email: shefali.naik@ahduni.edu.in

Abstract

Challenges and issues of distributed database are well known. One of the challenges is obtaining database transparency. In distributed database, the physical database is distributed across heterogeneous database systems. There are several methods of data access from distributed database, still it involves complicated implementation of these methods. Oracle DBMS provides heterogeneous gateway service to connect oracle and non-oracle databases. The data access and distributed transaction execution is made very easy through this gateway. In this paper, the procedure to connect four heterogeneous databases namely PostgreSQL, MySQL, Oracle and MS Access is described. The successful implementation of data access from multiple heterogeneous databases provides very easy and efficient access of data in Oracle using its native language/commands. Oracle user will neither have to bother about architecture nor commands of the remote databases from where data is accessed. Even user need not have to worry about the location of database. Once all the databases are connected through heterogeneous gateway, user will be able to access data and process distributed transactions efficiently from Oracle. The paper covers the whole process.