DOI QR코드

DOI QR Code

Experiments of Search Query Performance for SQL-Based Open Source Databases

  • Min, Meekyung (Dept. of Computer Science, Seokyeong University)
  • Received : 2018.03.02
  • Accepted : 2018.03.20
  • Published : 2018.05.31

Abstract

As the use of open source databases grows, so does need to evaluate, the performance of search queries for these databases. This paper compares the search query performance of SQL-based open source databases with commercial databases through experiments. The targets are MySql, MariaDB, and MS-SQL Server. In this study, the execution time of various types of search queries are measured. Also, search query performance was experimented according to change of index and number of tuples. Experimental results show that SQL-based open source databases have the potential to replace commercial databases when indexes are used and the number of tuples is not very large.

Keywords

References

  1. S. Androutsellis-Theotokis, D. Spinellis, M. Kechagia, and G. Gousios, Open Source Software: A Survey from 10,000 Feet, Foundations and Trends in Technology Information and Operations Management and Publish, 2011.
  2. R. Elmasri, and S. B. Navathe, Fundamentals of Database Systems, 7th Edition, Pearson, 2016.
  3. ISO/IEC, System and software engineering - Systems and software Quality Requirements and Evaluation, ISO/IEC TR-25010, 2011.
  4. N. Kim, “Experimental Evaluation Method for Performance Analysis in Web Application Services,” The Journal of the Institute of Internet, Broadcasting and Communication, Vol. 16, No. 1, pp. 69-75, 2016. DOI: http://dx.doi.org/10.7236/JIIBC.2016.16.1.69
  5. M. Min, “Evaluating the Performance Quality of Open Source Database Management Systems,” Journal of the Korean Society for Quality Management, Vol. 45, No. 4, pp. 933-942, 2017. DOI: https://doi.org/10.7469/JKSQM.2017.45.4.933
  6. I. Samoladas, G. Gousios, D. Spinellis, and I. Stamelos, "The SQO-OSS quality model: measurement-based open source software evaluation," Open source development, communities and quality, pp. 237-248, 2008.
  7. D. Spinellis, Code Quality: The Open Source Perspective, Addison Wesley Professional, 2006.
  8. D. Spinellis, G. Gousios, V. Karakoidas, P. Louridas, and P. Adams, "Evaluation the Quality of Open Source Software," Electronic Notes in Theoretical Computer Science, Vol. 233, pp. 5-28, 2009. https://doi.org/10.1016/j.entcs.2009.02.058