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

Flores, Ana; Ramirez, Stalin; Toasa, Renato; Vargas, Javier; Urvina-Barrionuevo, Renato; Jose M. Lavin

http://hdl.handle.net/10400.8/13186

Use this identifier to reference this record.

Name:	Description:	Size:	Format:
Performance_Evaluation_of_NoSQL_and_SQL_Queries_in_Response_Time_for_the_E-government.pdf		889.79 KB	Adobe PDF	Download

Send Feedback

Authors

Urvina-Barrionuevo, Renato

Jose M. Lavin

Abstract(s)

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.

Keywords

SQL NoSQL database test queries response time Document-Oriented Data Model

URI

http://hdl.handle.net/10400.8/13186

Citation

A. Flores, S. Ramírez, R. Toasa, J. Vargas, R. U. . -. Barrionuevo and J. M. Lavin, "Performance Evaluation of NoSQL and SQL Queries in Response Time for the E-government," 2018 International Conference on eDemocracy & eGovernment (ICEDEG), Ambato, Ecuador, 2018, pp. 257-262, doi: 10.1109/ICEDEG.2018.8372362.