ZQL: A Unified Middleware Bridging Both Relational and NoSQL Databases

Jie Xu, Mengjie Shi, Chaoyuan Chen, Zhen Zhang, Jigao Fu, Chi Harold Liu*

*Corresponding author for this work

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

14 Citations (Scopus)

Abstract

A large amount of unstructured data are being continuously generated by mobile applications, e.g., Facebook, Twitter and Foursquare, due to the popularity of smart devices, e.g., iPad, iWatch and smartphone. These data are undoubtedly of great value but need to be first well stored and then analyzed. Nevertheless, traditional relational database management system (RDBMS) is not well qualified for this job. As a result, NoSQL databases are proposed and become very popular. Judging from the present situations, RDMBSs play a better role in managing relational data, and thus application developers have to face the situation of co-existence of both RDBMS and NoSQL databases, and knowing the details of the underlying data distributions and structures of different databases. To this end, in this paper, we aim to propose a unified, transparent query engine, as a middleware, called "ZQL", by using MySQL and Hive as underlying two exemplary databases, however its usage goes far beyond these two databases. ZQL aims to support application development by hiding the specific details of both NoSQL databases and RDBMS. Finally, extensive experimental results show the effectiveness and functionalities of the proposed and implemented ZQL middleware.

Original languageEnglish
Title of host publicationProceedings - 2016 IEEE 14th International Conference on Dependable, Autonomic and Secure Computing, DASC 2016, 2016 IEEE 14th International Conference on Pervasive Intelligence and Computing, PICom 2016, 2016 IEEE 2nd International Conference on Big Data Intelligence and Computing, DataCom 2016 and 2016 IEEE Cyber Science and Technology Congress, CyberSciTech 2016, DASC-PICom-DataCom-CyberSciTech 2016
EditorsKevin I-Kai Wang, Qun Jin, Md Zakirul Alam Bhuiyan, Qingchen Zhang, Ching-Hsien Hsu
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages730-737
Number of pages8
ISBN (Electronic)9781509040650
DOIs
Publication statusPublished - 11 Oct 2016
Event14th IEEE International Conference on Dependable, Autonomic and Secure Computing, DASC 2016, 14th IEEE International Conference on Pervasive Intelligence and Computing, PICom 2016, 2nd IEEE International Conference on Big Data Intelligence and Computing, DataCom 2016 and 2016 IEEE Cyber Science and Technology Congress, CyberSciTech 2016, DASC-PICom-DataCom-CyberSciTech 2016 - Auckland, New Zealand
Duration: 8 Aug 201610 Aug 2016

Publication series

NameProceedings - 2016 IEEE 14th International Conference on Dependable, Autonomic and Secure Computing, DASC 2016, 2016 IEEE 14th International Conference on Pervasive Intelligence and Computing, PICom 2016, 2016 IEEE 2nd International Conference on Big Data Intelligence and Computing, DataCom 2016 and 2016 IEEE Cyber Science and Technology Congress, CyberSciTech 2016, DASC-PICom-DataCom-CyberSciTech 2016

Conference

Conference14th IEEE International Conference on Dependable, Autonomic and Secure Computing, DASC 2016, 14th IEEE International Conference on Pervasive Intelligence and Computing, PICom 2016, 2nd IEEE International Conference on Big Data Intelligence and Computing, DataCom 2016 and 2016 IEEE Cyber Science and Technology Congress, CyberSciTech 2016, DASC-PICom-DataCom-CyberSciTech 2016
Country/TerritoryNew Zealand
CityAuckland
Period8/08/1610/08/16

Keywords

  • NoSQL database
  • middleware

Fingerprint

Dive into the research topics of 'ZQL: A Unified Middleware Bridging Both Relational and NoSQL Databases'. Together they form a unique fingerprint.

Cite this