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.