Performance Evaluation of NoSQL and SQL Queries in Response Time for the E-government

Society demands accurate, right, quickly and easy access information. Therefore, governments are forced to implements or improve information systems with modern technologies. This research work is focused on the research of responses times on relational and non-relational data base models in an experimental data base system provided by the Función Judicial del Ecuador. The data is migrated for load in NoSQL allotment, and the performance tests is obtained a document-oriented data model. With these tests we could know the best database, focusing all on response time of data queries that have been used on performance tests. In addition, we evaluate the performance before and after the relational database administration system (RDBMS), obtaining as a result that the first test of the queries made to MongoDB substantially surpass the queries made to SQL Server, but in the subsequent tests the times they tend to be similar.

[1]  José Pereira,et al.  An Effective Scalable SQL Engine for NoSQL Databases , 2013, DAIS.

[2]  Hakan Hacigümüs,et al.  Partiqle: an elastic SQL engine over key-value stores , 2012, SIGMOD Conference.

[3]  Steven Skiena.  Big Data: Achieving Scale , 2017 .

[4]  Yunhao Liu,et al.  Big Data: A Survey , 2014, Mob. Networks Appl..

[5]  Ramon Lawrence.  Integration and Virtualization of Relational SQL and NoSQL Systems Including MySQL and MongoDB , 2014, 2014 International Conference on Computational Science and Computational Intelligence.

[6]  Syed Akhter Hossain,et al.  NoSQL Database: New Era of Databases for Big data Analytics - Classification, Characteristics and Comparison , 2013, ArXiv.

[7]  Stefan Jablonski,et al.  NoSQL evaluation: A use case oriented survey , 2011, 2011 International Conference on Cloud and Service Computing.

[8]  Sathiamoorthy Manoharan,et al.  A performance comparison of SQL and NoSQL databases , 2013, 2013 IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM).

[9]  Ronaldo dos Santos Mello,et al.  SimpleSQL: A Relational Layer for SimpleDB , 2012, ADBIS.

[10]  Paolo Atzeni,et al.  Uniform Access to Non-relational Database Systems: The SOS Platform , 2012, CAiSE.

[11]  Guan Le,et al.  Survey on NoSQL database , 2011, 2011 6th International Conference on Pervasive Computing and Applications.

[12]  G. R. Bamnote,et al.  Improving Query Processing Performance Using Optimization Techniques for Object-Oriented DBMS , 2016 .

[13]  Andreas Meier.  Unterschied zwischen SQL- und NoSQL-Datenbanken , 2018 .

[14]  Ki-Hoon Lee,et al.  Migration from RDBMS to Column-Oriented NoSQL: Lessons Learned and Open Problems , 2018 .