About | Contact Us | Register | Login
ProceedingsSeriesJournalsSearchEAI
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(Requires a free EAI acccount)
487 downloads
Cite
BibTeX Plain Text
  • @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.

Keywords
Heterogeneous distributed database Database transparency Location transparency Distributed transactions Heterogeneous gateway
Published
2018-02-01
Appears in
SpringerLink
http://dx.doi.org/10.1007/978-3-319-73712-6_16
Copyright © 2017–2025 EAI
EBSCOProQuestDBLPDOAJPortico
EAI Logo

About EAI

  • Who We Are
  • Leadership
  • Research Areas
  • Partners
  • Media Center

Community

  • Membership
  • Conference
  • Recognition
  • Sponsor Us

Publish with EAI

  • Publishing
  • Journals
  • Proceedings
  • Books
  • EUDL