오픈소스 DBMS의 성능 품질 평가
Evaluating the Performance Quality of Open Source Database Management Systems
0
조회
0
다운로드
3
인용
0
참고문헌
키워드
초록
Purpose: The purpose of this paper is to evaluate the performance quality of the open source DBMSs. Performance quality is defined as processing time for Join queries. Query processing time is measured and compared in the most widely used open source DBMSs and commercial DBMS. Methods: By varying the number of tuples of two relations to be joined, the average processing time(seconds) of a Join query in each DBMS was obtained experimentally. ANOVA and Tukey HSD test were used in order to compare the performance quality of DBMSs. Results: There was a significant difference between the performance qualities of the three DBMSs at all experimental levels where the number of tuples was 100, 1,000, 2,000, 10,000, and 50,000. As a result of the Tukey HSD test, two open source DBMSs (MariaDB, MySQL) were classified in the same group only at the tuple level of 100. The commercial DBMS (MS-SQL Server) belonged to another group. At level of more than 1,000 tuples, all three DBMSs belonged to different groups. Conclusion: Within the open source DBMS group, MariaDB showed the better performance quality except for a small number of tuples. Thus the results show that MariaDB can be the alternative to MySQL which is currently most widely used. Between open source DBMS and commercial DBMS groups, MS-SQL Server always shows the best performance quality, but the less number of tuples, the less the difference.
Abstract
Purpose: The purpose of this paper is to evaluate the performance quality of the open source DBMSs. Performance quality is defined as processing time for Join queries. Query processing time is measured and compared in the most widely used open source DBMSs and commercial DBMS. Methods: By varying the number of tuples of two relations to be joined, the average processing time(seconds) of a Join query in each DBMS was obtained experimentally. ANOVA and Tukey HSD test were used in order to compare the performance quality of DBMSs. Results: There was a significant difference between the performance qualities of the three DBMSs at all experimental levels where the number of tuples was 100, 1,000, 2,000, 10,000, and 50,000. As a result of the Tukey HSD test, two open source DBMSs (MariaDB, MySQL) were classified in the same group only at the tuple level of 100. The commercial DBMS (MS-SQL Server) belonged to another group. At level of more than 1,000 tuples, all three DBMSs belonged to different groups. Conclusion: Within the open source DBMS group, MariaDB showed the better performance quality except for a small number of tuples. Thus the results show that MariaDB can be the alternative to MySQL which is currently most widely used. Between open source DBMS and commercial DBMS groups, MS-SQL Server always shows the best performance quality, but the less number of tuples, the less the difference.
참고문헌 (14)
- Open Source Software: A Survey from 10,000 Feet, "Androutsellis-Theotokis, S.", Foundations and Trends in Technology Information and Operations Management and Publish, ~ (2011)
- 최승준, "빅데이터 분산처리시스템의 품질평가모델", 디지털콘텐츠학회논문지, 15(4), pp.533~545 (2014), 한국디지털콘텐츠학회[DOI]
- 정수민, "IoT 기반 SW 품질평가 모델", 한국정보통신학회논문지, 20(7), pp.1342~1354 (2016), 한국정보통신학회[DOI]
- Date, C. J., "An Introduction to Database Systems" (2004), Pearson
- "Software Engineering-Product Quality-Part 1: Quality Model", ISO, 2001
- "Software Engineering‐Product Quality‐part2: Internal Metrics", ISO, 2003
- "System and software engineering-Systems and software Quality Requirements and Evaluation", ISO, 2011
- 이정현, "모바일 클라우드소프트웨어의 실용적 품질평가모델", 한국정보기술학회논문지, 13(3), pp.95~110 (2015), 한국정보기술학회[DOI]
- 임광현, "소프트웨어 신뢰도 품질측정 방안에 관한 연구", 한국컴퓨터정보학회논문지, 17(12), pp.187~198 (2012), 한국컴퓨터정보학회
- 이상복, "다구찌 기법과 요인실험의 실험 데이터의 산포 크기에 따라 결과 변화 고찰", 품질경영학회지, 41(1), pp.119~134 (2013), 한국품질경영학회[DOI]
- 류귀열, "확률분포를 이용한 포털들의 응답시간 품질에 관한 연구", 품질경영학회지, 42(1), pp.33~42 (2014), 한국품질경영학회[DOI]
- Samoladas, I., "The SQO-OSS quality model : measurement-based open source software evaluation. Open source development", communities and quality, pp.237~248 (2008)
- Spinellis, D., "Code Quality: The Open Source Perspective" (2006), Addison Wesley Professional
- Spinellis, D., "Evaluating the Quality of Open Source Software", Electronic Notes in Theoretical Computer Science, 233, pp.5~28 (2009)