Open AccessUnified SQL Query Middleware for Heterogeneous Databases
Author(s) -
Huiran Zhang,
Cheng Zhang,
Rui Hu,
Xi Liu,
Donghai Dai
Publication year - 2021
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1873/1/012065
Subject(s) - computer science , nosql , joins , sql , query by example , database , query language , query optimization , view , stored procedure , syntax , relational database , data definition language , sargable , middleware (distributed applications) , information retrieval , database design , programming language , web search query , scalability , search engine , artificial intelligence
With the development of modern computer technology, the data which needs to be stored and processed by modern application systems becomes more and more varied. While traditional relational databases still dominate, NoSQL databases are developing rapidly and occupy a place in the entire industry. Therefore, more and more applications need to connect to multiple database systems at the same time. However, the different characteristics supported by different database systems and the differences in query syntax rules make multi-database application development very complicated. This paper talks about a unified query middleware system that supports federated analytical queries with standard SQL syntax for various data sources and can perform joins, aggregates and filter on data from different data sources in a single query.