|
|
论文:2017,Vol:35,Issue(1):143-147 |
|
|
引用本文： |
|
|
李常青, 谷建华. 一种基于ANTLR的MongoDB数据库SQL转化模型[J]. 西北工业大学学报 |
|
|
Li Changqing, Gu Jianhua. A SQL Transformation Model of MongoDB Based on ANTLR[J]. Northwestern polytechnical university |
|
|
|
|
|
|
|
| 一种基于ANTLR的MongoDB数据库SQL转化模型 |
|
| 李常青, 谷建华 |
|
| 西北工业大学 计算机学院, 陕西 西安 710072 |
| 摘要: |
| 作为非关系型数据的典型存储和管理模型，NoSQL（not only structured query language）技术随着大数据发展浪潮已成为研究热点之一。通过对著名NoSQL数据库MongoDB特点的分析，针对其缺乏SQL（structured query language）访问接口的不足，提出了一种基于ANTLR的MongoDB数据库SQL转化模型，并重点研究了该模型的分层构成、SQL解析、语义转换以及运行机制。基于该模型，设计开发了原型系统，对该模型的效果进行了验证，达到了预期的目标。这一研究成果的突出贡献在于，它可以使得软件开发人员对MongoDB数据库的学习曲线变得平坦，减少了编制程序的工作量，提高了软件的开发效率。 |
| 关键词:
SQL
NoSQL
MongoDB
大数据
转化模型
ANTLR
|
|
| A SQL Transformation Model of MongoDB Based on ANTLR |
|
| Li Changqing, Gu Jianhua |
|
| School of Computer Science, Northwestern Polytechnical University, Xi'an 710072, China |
| Abstract: |
| As a typical storage and management model of non relational data, NoSQL(not only structured query language) technology has become one of the hot research topics in recent years, with the development of big data tides. Through the analysis of the characteristics of MongoDB, which is a well-known NoSQL database, in order to solve the problem of the lack of SQL(structured query language) access interface, this paper presents a SQL transformation model of MongoDB based on ANTLR, and focuses on its hierarchical structure, SQL parser, semantic conversion and the operation mechanism. A prototype system is designed and developed. The effect of this model is verified, and the expected targets are achieved. The outstanding contribution of this research is that it can reduce the learning cost of software developers, and improve the efficiency of development. |
| Key words:
SQL
NoSQL
MongoDB
big data
transformation model
ANTLR
time delay
application programming interfaces(API)
|
|
| 收稿日期: 2016-04-21
修回日期:
|
| DOI: |
| 通讯作者:
Email： |
| 作者简介: 李常青(1969-),西北工业大学博士研究生,主要从事分布式与可信计算研究。
|
|
|
|
|
|
|
|
参考文献: |
|
|
[1] 李莉莎. 关于NOSQL的思考[J]. 中国传媒科技, 2010(4):40-41 Li Lisha. Thinking about NOSQL[J]. Science & Technology for China's Mass Media, 2010(4):40-41(in Chinese)
[2] 申德荣, 于戈,王习特,等. 支持大数据管理的NoSQL系统研究综述[J]. 软件学报, 2013,24(8):1786-1803 Shen Derong, Yu Ge, Wang Xite, et al. Survey on NoSQL for Management of Big Data[J]. Journal of Software, 2013,24(8):1786-1803(in Chinese)
[3] Pokorny J. NoSQL Databases:a Step to Database Scalability in Web Environment[J]. International Journal of Web Information Systems, 2013, 9(1):69-82
[4] Chodorow K, Dirolf M. MongoDB:The Definitive Guide[M]. 2nd Ed. O'Reilly Media Inc, USA, 2013
[5] Terence Parr. The Definitive ANTLR 4 Reference[M]. The Pragmatic Programmers, USA, 2012
[6] 刘冠. 标准SQL语句与MongoDB数据转换技术研究[D]. 成都:四川师范大学, 2013 Liu Guan. Research on Data Conversion Technology from Standard SQL to MongoDB[D]. Chengdu, Sichuan Normal University, 2013(in Chinese)
[7] 郑小裕. SQL与NoSQL数据库的统一查询模型的研究与实现[D]. 长沙:湖南大学,2014 Zheng Xiaoyu. Research and Implementation of Unified Query Model about Relation Database and Non-Relation Database[D]. Changsha, Hunan University, 2014(in Chinese)
[8] 10gen Inc. mongo-jdbc[EB/OL]. (2010-02-09)[2016-04-20]. https://github.com/erh/mongo-jdbc
[9] Khan S, Mane P V. SQL Support over MongoDB Using Metadata[J]. International Journal of Scientific and Research Publications, 2013, 3(10):1-5
[10] Lawrence R. Integration and Virtualization of Relational SQL and NoSQL Systems Including MySQL and MongoDB[C]//International Conference on Computational Science and Computational Intelligence, 2014:285-290
[11] Ong K W, Papakonstantinou Y, Vernoux R. The SQL++Unifying Semi-Structured Query Language, and an Expressiveness Benchmark of SQL-on-Hadoop, NoSQL and NewSQL Databases[EB/OL]. (2014-05-14)[2016-04-20]. http://arxiv.org/pdf/1405.3631v8.pdf |
|
|
|
|
|
|
|
