Earticle

초록

영어

Most of the present DMBSs have parameters to set the size of data buffer caching in a memory, and disc I/O can be reduced, as the buffer size is greatly reduced, because data pages caching in a buffer increase. Whereas greatly setting this parameter value makes a memory occupy a system excessively, and the buffer pool may be swapped by system's operating system.This article compared and analyzed efficiency of each storage medium, by changing the size of data buffer caching in a memory, after connecting DBMS with a storage medium. According to the result of the test, both performances of storage media increased, as the buffer size was greatly reduced. Seeing that D-SSD's performance and HDD's performance changed from above 1GB and 2GB, respectively, it is supposed that there is no need to cut down the buffer size infinitely, because performance doesn't change from a certain section, although it improves, as the buffer size highly decreases. It isn't necessary to expand the buffer size greatly under the small load, since there was no change of performance, even when the buffer size was greatly increased under the small load. While D-SSD also can maintain its performance without any big change, if it exceeds the scope of capacity that the buffer can process, HDD shows a considerable reduction of performance. Therefore, it is likely that unlike HDD, for D-SSD, tuning the buffer size isn't needed. However, there is a need of conducting a test in an actual service environment in future, because these results came from the test in a single server.

목차

Abstract
 1. Introduction
 2. DBMS(Database Management System)
 3. TPC(Transaction Processing Performance Council)
 4. Experimental Environment and Experimental Condition
 5. Efficiency by Storage Media according to Changes in the Buffer Size
 6. Testing and Analysis according to Single Load Load by NBD benchmark
 7. Conclusion
 References

키워드

저자

• Jae-Hwan Lee [ Dept. of Electronic Eng., Hannam University, Ojeong -dong, Daedeok-gu, Daejon 306-791, Korea ]
• Young-Hun Lee [ Dept. of Electronic Eng., Hannam University, Ojeong -dong, Daedeok-gu, Daejon ] Corresponding Author

참고문헌

발행기관

간행물

표지보기 관심저널 등록

• 간행물명

  International Journal of Software Engineering and Its Applications

• 간기

  월간

• pISSN

  1738-9984

• 수록기간

  2008~2016

• 등재여부

  SCOPUS

• 십진분류

  KDC 505 DDC 605