Automatic Conversion of SQL statements into NoSQL queries

Abstract

　For storing and managing enormous data, NoSQL databases have been employed recently on behalf of RDB since NoSQL is high-performance and scalable. However the differences of the data structures and the manipulation languages give the developers pause in making the shift to the systems using NoSQL. In this paper, we report a converter which takes an SQL statement as input to generate an equivalent code of target language of NoSQL. MongoDB and HBase were selected as the target languages while we attempted to implement an SQL analyzer and coordinate the code segments of the programming languages. As the result of the evaluation experiment, 13 MongoDB queries and 9 HBase ones were derived from 32 example SQL statements.