Unified SQL Query Middleware for Heterogeneous Databases
Huiran Zhang, Cheng Zhang, Rui Qin Hu, Xi Liu, Dongbo Dai · Journal of Physics Conference Series · 2021
Abstract 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.