Accessing Data From Multiple Heterogeneous Distributed Database Systems

Applying Integration Techniques and Methods in Distributed Systems and Technologies - Advances in Computer and Electrical Engineering ◽

10.4018/978-1-5225-8295-3.ch008 ◽

2019 ◽

pp. 192-219

Author(s):

Shefali Trushit Naik

Keyword(s):

System Parameter ◽

Database Systems ◽

Distributed Database ◽

Sql Server ◽

Distributed Database Systems ◽

Data Source ◽

Database Connectivity ◽

Relational Database Management ◽

Complete Process ◽

Relational Database Management Systems

This chapter describes the method to retrieve data from multiple heterogeneous distributed relational database management systems such as MySQL, PostgreSQL, MS SQL Server, MS Access, etc. into Oracle RDBMS using Oracle's Heterogeneous Gateway Services. The complete process starting from downloading and installation of required software, creation of data source names using open database connectivity, modification of system parameter files, checking connections, creation of synonyms for tables of remote databases into oracle, creation of database links and accessing data from non-oracle databases using database links is explained in great detail. Apart from this, data manipulation in remote databases from Oracle and execution of PL/SQL procedures to manipulate data residing on remote databases is discussed with examples. Troubleshooting common errors during this process is also discussed.

Download Full-text

Performance Evaluation of Distributed Database Systems

INTERNATIONAL JOURNAL OF COMPUTERS & TECHNOLOGY ◽

10.24297/ijct.v13i9.2383 ◽

2014 ◽

Vol 13 (9) ◽

pp. 4859-4867

Author(s):

Khaled Saleh Maabreh

Keyword(s):

Performance Evaluation ◽

System Performance ◽

Operation Mode ◽

Database Systems ◽

Distributed Database ◽

Evaluation Study ◽

Distributed Database Systems ◽

Different Types ◽

Distributed Database System ◽

Distributed Database Management

Distributed database management systems manage a huge amount of data as well as large and increasingly growing number of users through different types of queries. Therefore, efficient methods for accessing these data volumes will be required to provide a high and an acceptable level of system performance. Â Data in these systems are varying in terms of types from texts to images, audios and videos that must be available through an optimized level of replication. Distributed database systems have many parameters like data distribution degree, operation mode and the number of sites and replication. These parameters have played a major role in any performance evaluation study. This paper investigates the main parameters that may affect the system performance, which may help with configuring the distributed database system for enhancing the overall system performance.

Download Full-text