Research On SQL And MongoDB Data Conversion Technology

The rapid development of Internet has brought vitality to the application of WEB2.0and SNS. How to meet customers’ needs become a key topic on cloud computing research.There are more than20kinds of NoSQL databases in the market and each database has itsown unique interface and drivers. Without the uniform standard, lots of inconvenienceshave bothered developers and users. How to operate the new database with SQL language isan important research project.Using the data of Sichuan Normal University Online Office System as the studymodule, this paper made the research in the standard SQL language and MongoDBmanipulation API, finally proposed a method of conversion. This method proved that usingSQL to operate MongoDB database was feasible in the absence ofuniform standards.First,by studying the MongoDB driver interface and comparingwith the standard SQLlanguage, I proposed a method that allowedusers to manipulate MongoDB through SQL.This system was developed by ASP.NET. usersjust need to enter the SQL in particulardialog box, then the system would process and return the resultsautomatically.Second,this system implemented a graphical user interface to meet the needs of generaldatabase management. The system had the complete function to add,delete and modify thedata of its accounts, which would made the user to handle this database intuitively andconvenientlyThird,compared with other software, this system can improve the efficiency and utilityof managing MongoDB database because of the web and SQL conversion characteristics.