一种基于ANTLR的MongoDB数据库SQL转化模型

A SQL Transformation Model of MongoDB Based on ANTLR

作为非关系型数据的典型存储和管理模型,NoSQL(not only structured query language)技术随着大数据发展浪潮已成为研究热点之一。通过对著名NoSQL数据库MongoDB特点的分析,针对其缺乏SQL(structured query language)访问接口的不足,提出了一种基于ANTLR的MongoDB数据库SQL转化模型,并重点研究了该模型的分层构成、SQL解析、语义转换以及运行机制。基于该模型,设计开发了原型系统,对该模型的效果进行了验证,达到了预期的目标。这一研究成果的突出贡献在于,它可以使得软件开发人员对MongoDB数据库的学习曲线变得平坦,减少了编制程序的工作量,提高了软件的开发效率。

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 trans-formation 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.