The Query Translation from MySQL to MongoDB Taking into Account the Structure of the Database

This article discusses an approach to translate queries from MySQL to MongoDB taking into account the structure of the database which consists of four phases. In the first phase, the process of parsing the incoming queries MySQL are using building syntax grammar. In the second phase, a dictionary of query parts is created from the result of the first phase based on the aggregation structure MongoDB. In the next step, the structure of the database MongoDB is defined by converting collection data to structure tree and dictionary of query parts is updated for matching the structure of target database. In the last phase, the query of the database MongoDB is synthesized from building dictionary. In the end, this article shows the result of testing of the proposed approach with the different queries.