APPLICATION OF ETL PROCESS IN THE TRANSFORMATION PROCEDURE OF A RELATIONAL DATABASE INTO GRAPH-ORIENTED DATABASE
DOI:
https://doi.org/10.24867/17BE19DjurdjevicKeywords:
Relational database, Graph-Oriented database, ETL process, transformation, modelingAbstract
This paper will present the use of the ETL (Extract Transform Load) process, used in order to acquire data for the application of the music encyclopedia that can be searched by querying in natural language. These processes represent an improvement on a system that used a web crawler for data acquiring in its first version. To provide an answer to the question, the system uses sequence to sequence machine learning techniques, in order to translate the question from natural to query language of the graph database and answer provisioning. Two ETL processes were used to implement database translation from relational to graph model. The first is mapping from a relational to a relational database and is implemented in the ODI (Oracle Data Integrator) tool. While the second ETL is a mapping process that maps a relational to a graph-oriented database, using the Neo4j ETL tool.
References
[2] Simitsis, A. Vassiliadis, P. & Sellis, T., 2005. Extraction-Transformation-Loading Processes. [Online] Research Gate Available at: https://www.researchgate.net/publication/239638567_Extraction-Transformation-Loading_Processes [Accessed 29 September 2021].
[3] Oracle, 2021. Oracle Data Integrator 12.2.1.4.0. [Online] Oracle Available at: https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.4/ [Accessed 9 August 2021].
[4] Galici, R. Ordile, L. Marchesi, M. Pinna, A. & Tonelli, R., 2020. Applying the ETL Process to Blockchain Data. Prospect and Findings. [Online] MDPI Available at: https://doi.org/10.3390/info11040204 [Accessed 10 August 2021].
[5] Santos, R. & Bernardino, J., 2008. Real-time data warehouse loading methodology. [Online] Research Gate Available at: https://www.researchgate.net/publication/221524861_Real-time_data_warehouse_loading_methodology [Accessed 20 August 2021].
[6] Wikipedia, 2021. Extract, transform, load. [Online] Available at: https://en.wikipedia.org/wiki/Extract,_transform,_load [Accessed 21 August 2021].
[7] Neo4j, 2021. Model: Relational to Graph [Online] Available at: https://neo4j.com/developer/relational-to-graph-modeling/ [Accessed 23 August 2021].
