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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Ferrier, A., Stangret, C.: Heterogeneity in the distributed database management system SIRIUS-DELTA. In: VLDB (1982)
Naik, S.: Concepts of Database Management System. Dorling Kindersley, New Delhi (2014)
Özsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Springer, New York (2011). https://doi.org/10.1007/978-1-4419-8834-8
Adiba, M.E., et al.: Issues in distributed data base management systems: a technical overview. In: Proceedings of the Fourth International Conference On Very Large Data Bases, vol. 4. VLDB Endowment (1978)
Shefali, N., Samrat, K.: Revisited performance issues in concurrent transaction execution in distributed database management system. Int. J. Curr. Eng. Sci. Res. 2(4), 23–26 (2015). ISSN (Print): 2393-8374, (Online): 2394-0697
Oracle Database Heterogeneous Connectivity User’s Guide. https://docs.oracle.com/cd/E11882_01/server.112/e11050.pdf
https://www.tutorialspoint.com/distributed_dbms/distributed_dbms_database_environments.htm
http://www.techrepublic.com/article/distributed-transactions-span-sql-server-and-oracle/
Wang, C.-Y., Spooner, D.L.: Access control in a heterogeneous distributed database management system. In: SRDS (1987)
https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts004.htm#ADMIN12128
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 ICST Institute for Computer Sciences, Social Informatics and Telecommunications Engineering
About this paper
Cite this paper
Naik, S. (2018). Ensuring Database and Location Transparency in Multiple Heterogeneous Distributed Databases. In: Patel, Z., Gupta, S. (eds) Future Internet Technologies and Trends. ICFITT 2017. Lecture Notes of the Institute for Computer Sciences, Social Informatics and Telecommunications Engineering, vol 220. Springer, Cham. https://doi.org/10.1007/978-3-319-73712-6_16
Download citation
DOI: https://doi.org/10.1007/978-3-319-73712-6_16
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-73711-9
Online ISBN: 978-3-319-73712-6
eBook Packages: Computer ScienceComputer Science (R0)