ZQL: A Unified Middleware Bridging Both Relational and NoSQL Databases
| Autor: | Mengji Shi, Jie Xu, Zhen Zhang, Chaoyuan Chen, Jigao Fu, Chi Harold Liu |
|---|---|
| Rok vydání: | 2016 |
| Předmět: |
Database
business.industry Computer science Relational database Big data InformationSystems_DATABASEMANAGEMENT 020207 software engineering Unstructured data 02 engineering and technology computer.software_genre NoSQL Electronic mail Bridging (programming) World Wide Web XML database Relational database management system 0202 electrical engineering electronic engineering information engineering 020201 artificial intelligence & image processing business computer |
| Zdroj: | DASC/PiCom/DataCom/CyberSciTech |
| Popis: | 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. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|