ABSTRACT
With the popularity of smart mobile devices and the development of big data, NoSQL databases came into being. Compared to the traditional relational databases, NoSQL databases have the advantages of unstructured storage, high availability and high scalability. So NoSQL databases are better able to handle the sheer volume of unstructured data generated by large Web applications and mobile applications. But since there are so many NoSQL databases today, each NoSQL database provides its own set of APIs, lacking a uniform standard. As a result, NoSQL databases have not been well received, though they perform better. This paper presents a unified architecture that allows NoSQL databases to support standard SQL (Structured Query Language) operations. In accordance with this architecture, we implement a middleware called NoMiddleware, which preserves the benefits of SQL in NoSQL systems. And in order to better evaluate the standard SQL query performance of NoSQL databases, we propose a set of micro-bench called Nomicrobench. The experimental results show that NoMiddleware provides the most complete SQL standard with the least overhead and benefits both in functionality and performance.
- Melnik, S., Gubarev, A., and Long, J. J., et al. 2010. Dremel: interactive analysis of web-scale datasets. Proceedings of the VLDB Endowment, 3(1-2), 330--339. Google ScholarDigital Library
- Cattell, and Rick. 2011. Scalable sql and nosql data stores. Acm Sigmod Record, 39(4), 12--27. Google ScholarDigital Library
- Liu, Z. H., Hammerschmidt, B., and Mcmahon, D., et al. 2016. Closing the functional and Performance Gap between SQL and NoSQL. International Conference on Management of Data (pp. 227--238). Google ScholarDigital Library
- Corbellini, A., Mateos, C., and Zunino, A., et al. 2017. Persisting big-data: the nosql landscape. Information Systems, 63, 1--23.Google ScholarCross Ref
- Thusoo, A., Sarma, J. S., and Jain, N., et al. 2009. Hive: a warehousing solution over a map-reduce framework. Proceedings of the VLDB Endowment, 2(2), 1626--1629. Google ScholarDigital Library
- Olston, C., Reed, B., and Srivastava, U., et al. 2008. Pig latin:a not-so-foreign language for data processing. ACM SIGMOD International Conference on Management of Data (pp. 1099--1110). Google ScholarDigital Library
- Chattopadhyay, B., Lin, L., and Liu, W., et al. 2011. Tenzing a sql implementation on the mapreduce framework. Proceedings of the VLDB Endowment, 4, 1318--1327.Google ScholarDigital Library
- Melton, J. 1996. Sql language summary. Acm Computing Surveys (CSUR), 28(1), 141--143 Google ScholarDigital Library
- Roijackers, J., and Fletcher, G. H. L. 2013. On Bridging Relational and Document-Centric Data Stores. Big Data. Springer Berlin Heidelberg. Google ScholarDigital Library
- Buneman, P., Fernandez, M., and Suciu, D. 2000. UnQL: a query language and algebra for semistructured data based on structural recursion. The VLDB Journal, 9(1), 76--110. Google ScholarDigital Library
- Calil, A., and Mello, R. D. S. 2012. SimpleSQL: A Relational Layer for SimpleDB. East European Conference on Advances in Databases and Information Systems (Vol. 7503, pp. 99--110). Google ScholarDigital Library
- Lawrence, R. (2014). Integration and Virtualization of Relational SQL and NoSQL Systems Including MySQL and MongoDB. International Conference on Computational Science and Computational Intelligence (Vol.1, pp. 285--290). Google ScholarDigital Library
- Parr, T., and Fisher, K. 2011. LL (*): the foundation of the ANTLR parser generator. ACM Sigplan Notices, 46(6), 425--436. Google ScholarDigital Library
- Bille, P. (2005). A survey on tree edit distance and related problems. Theoretical computer science, 337(1), 217--239. Google ScholarDigital Library
- Chasseur, C., Li, Y., and Patel, J. M. 2013. Enabling JSON Document Stores in Relational Systems. In WebDB (Vol. 13, pp. 14--15).Google Scholar
- Cooper, B. F., Silberstein, A., and Tam, E., et al. 2010. Benchmarking cloud serving systems with YCSB. ACM Symposium on Cloud Computing (pp. 143--154). Google ScholarDigital Library
- https://github.com/erh/mongo-jdbcGoogle Scholar
Index Terms
- A Unified SQL Middleware for NoSQL Databases
Recommendations
A Framework to Convert NoSQL to Relational Model
ACIT '18: Proceedings of the 6th ACM/ACIS International Conference on Applied Computing and Information TechnologyDue to the exponential growth of NoSQL databases and in addition the circumstance of perusing humongous volumes of information, maximum applications switch RDBMS to NoSQL and pick it as information stockpiling framework. But we all know that RDBMS have ...
Comparing NoSQL MongoDB to an SQL DB
ACMSE '13: Proceedings of the 51st ACM Southeast ConferenceNoSQL database solutions are becoming more and more prevalent in a world currently dominated by SQL relational databases. NoSQL databases were designed to provide database solutions for large volumes of data that is not structured. However, the ...
Incorporating NoSQL into a database course
This article introduces the concepts of Big Data and NoSQL and describes a semester long web-based project that uses both a relational database (Oracle 11g) and a NoSQL (MongoDB) database for an undergraduate database course. The relational database ...
Comments