arrow
Return

Uniform data access platform for SQL and NoSQL database systems

delete2017-09-01
delete38
PRE
AI
Á
Ágnes Vathy-Fogarassy *
T
Tamás Hugyák
DOI:10.1016/j.is.2017.04.002delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
Integration of data stored in heterogeneous database systems is a very challenging task and it may hide several difficulties. As NoSQL databases are growing in popularity, integration of different NoSQL systems and interoperability of NoSQL systems with SQL databases become an increasingly important issue. In this paper, we propose a novel data integration methodology to query data individually from different relational and NoSQL database systems. The suggested solution does not support joins and aggregates across data sources; it only collects data from different separated database management systems according to the filtering options and migrates them. The proposed method is based on a metamodel approach and it covers the structural, semantic and syntactic heterogeneities of source systems. To introduce the applicability of the proposed methodology, we developed a web-based application, which convincingly confirms the usefulness of the novel method. (C) 2017 Elsevier Ltd. All rights reserved.
Keywords:
Uniform data access
Relational database management systems
NoSQL database management systems
MongoDB
Data integration
JSON
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

Enterprise Information Systems cover
Enterprise Information Systems
IF:
3.9
Papers:
2.8K
Citations:
1.8K

Organization

U
University of Pannonia
Scholars:
1.7K
Papers: 1.5K
Citations: 1.4K