Earticle

초록

영어

In this study, the efficiency by storage medium according to changes in the buffer size was compared and analyzed focusing on parameters setting the size of the buffer that most of DBMSs have in common in relation to storage media. efficiency was compared and analyzed by NBD(NHN Bulletin Board Application Database) according changes to the buffer size when single load which different work load from that of the TPC-H model. It was observed In QUIBRID that there is a difference due to the performance of the two storage media when TPS has been measured by giving single or multi-load through Level 2 of the NBD Benchmark but that there is no change in TPS according to the buffer size. It is because the small loads of Level 2 are processed within a range of not exceeding the buffer capacity. Thus it appears that for small loads for reading, printing out, or searching posts, there is no need to apply the large buffer to the two storage media all. D-SSD show no performance degradation due to excellent Read/Write functions. Thus, it is expected to achieve the desired performance without tuning works on the buffer size to process DB data.

목차

Abstract
 1. Introduction
 2. DBMS(Database Management System)
 3. NBD(NHN Bulletin Board Application Database) Benchmark
 4. Experimental Environment and Experimental Condition
 5. Storage Medium Efficiency According to Changes the Buffer Size of CUBRID
  5.1. Testing and Analysis According to Single Load
  5.2. Testing and Analysis according to Multi-Load
 6. 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 306-791, Korea ] Corresponding Author

참고문헌

발행기관

간행물

표지보기 관심저널 등록

• 간행물명

  International Journal of Software Engineering and Its Applications

• 간기

  월간

• pISSN

  1738-9984

• 수록기간

  2008~2016

• 등재여부

  SCOPUS

• 십진분류

  KDC 505 DDC 605