SQL INTERFACE TO RETRIEVE DATA FROM RELATIONAL DATABASES AND DOCUMENT ORIENTED DATABASES
The need for retrieving data from multiple database sources of varying types is increasing as information technology advances. Therefore, a system is required that can fetch and integrate data from various sources, even if they use different types of databases. Putra (2021) has successfully imple...
Saved in:
| Main Author: | |
|---|---|
| Format: | Final Project |
| Language: | Indonesia |
| Online Access: | https://digilib.itb.ac.id/gdl/view/76856 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Institution: | Institut Teknologi Bandung |
| Language: | Indonesia |
| Summary: | The need for retrieving data from multiple database sources of varying types is
increasing as information technology advances. Therefore, a system is required that
can fetch and integrate data from various sources, even if they use different types
of databases. Putra (2021) has successfully implemented a system that retrieves
moving object data from various PostgreSQL databases. In this final project, an
SQL interface application is developed that is capable of fetching data, including
spatial data, from different sources, both PostgreSQL databases and document-
oriented ones.
The system utilizes metadata that stores information such as operable object tables,
the entire schema of database sources handled by the system, and mappings
between object attributes and their sources. SQL queries received by the system are
transformed into an abstract syntax tree, which is then processed to generate queries
for each respective source. The system leverages modules from the Adzkiya system
(2021) to retrieve data from MongoDB or CouchDB database sources. There are
two alternative methods for combining obtained data from all relevant sources. The
first alternative utilizes features of the JavaScript programming language to
horizontally merge separate data, while the second alternative uses SQL queries to
perform the entire data integration.
Testing of the system is conducted through several queries that vary in the desired
number of database sources, spatial operations, and other SQL query features.
Based on the evaluation results, it can be concluded that the system has successfully
retrieved data from various sources with satisfactory performance. |
|---|