Journal of Digital Contents Society (디지털콘텐츠학회 논문지)

Digital Contents Society (한국디지털콘텐츠학회)
권호 표지
DOI QR코드

DOI QR Code

Application Performance Evaluation in Main Memory Database System

메인메모리 데이터베이스시스템에서의 어플리케이션 성능 평가

  • Received : 2014.10.15
  • Accepted : 2014.10.31
  • Published : 2014.10.31
Download PDF
⟨ Previous Next ⟩

Abstract

The main memory DBMS is operated which the contents of the table that resides on a disk at the same time as the drive is in the memory. However, because the main memory DBMS stores the data and transaction log file using the disk file system, there are a limit to the speed at which the CPU accesses the memory. In this paper, I evaluated the performance through analysis of the application side difference the technology that has been implemented in Altibase system of main memory DBMS and Sybase of disk-based DBMS. When the application performance of main memory DBMS is in comparison with the disk-based DBMS, the performance of main memory DBMS was outperformed 1.24~3.36 times in the single soccer game, and was outperformed 1.29~7.9 times in the soccer game / special soccer. The result of sale transaction response time showed a fast response time of 1.78 ~ 6.09 times.

메인 메모리 DBMS는 구동과 동시에 디스크에 존재하는 테이블의 내용이 메모리로 모두 올라가는 구조로 운영된다. 그러나, 메인메모리 DMBS도 디스크 파일시스템을 사용하여 데이터를 저장하고 트랜잭션 로그파일을 파일 시스템에 유지하여야 하기 때문에 CPU가 메모리에 접근하여 처리하는 속도에는 한계가 있게 마련이다. 본 논문에서는 메인메모리 DBMS인 Altibase 시스템에서 구현된 기술들이 디스크기반 DBMS인 Sybase와 얼마나 차이가 있는지를 어플리케이션 측면에서 성능분석을 통하여 평가하였다. 메인메모리 DBMS의 어플리케이션 성능이 디스크기반 DBMS에서의 어플리케이션 성능과 비교하면, 메인 메모리 DBMS의 성능이 축구승무패 단일게임에서는 1.24배 ~ 3.36배, 축구승무패와 축구 스페셜 두 게임에 동시 발매시 1.29배 ~ 7.9배의 성능향상이 있었으며, 발매 트랜잭션의 응답시간 시험결과 1.78배 ~ 6.09배의 빠른 응답시간을 보였다.

Keywords

References

  1. S-H. Lim, "Utilization Plan of MMDBMS by Construction Example," on the Net, pp.168-172, July 2006.
  2. P. Bohannon, J. Parker, R. Rastogi, S. Seshadri, A. Sil-berschatz, and S. Sudarshan, "Distributed Multi -Level Recovery in Main-Memory Databases," Proc. of the International Conference on Parallel and Dis tributed Information Systems, 1996.
  3. H. Garcia-Molina and K. Salem, "main Memory Data base Systems : An Overview," IEEE Transactions on Knowledge and Data Engineering, Vol 4. No. 6, 1993.
  4. K. W. Lee, "Transaction performance evaluation of main memory DBMS," Journal of Korea Computer Industrial Education Society, Vol.6, No.2, pp.559-56 5, June 2005.
  5. http://brainwave.tistory.com
  6. http://www.dbguide.net
  7. Per-Ake Larson, Spyros Blanas, Cristian Diaconu, Craig Freedman, Jignesh M. Patel, and Mike Zwilling, ""High-performance concurrency control mechanisms for main-memory databases," Journal of the VLDB Endowment, Vol.5. No.4. pp.298-309, 2011 https://doi.org/10.14778/2095686.2095689
  8. D. Agrawal and V. Krishnaswamy, "Using Multivers ion Data for Non-Interfering Excution of Write-Only Transactions," Proc. of the ACM SIGMOD International Conference on Management of Data, 1991.
  9. P. M. Bober and M. J. Carey, "Multiversion Query Locking," Proc. of the 18th Conference on Very Large Database, 1992
  10. http://www.gurubee.net/lecture/2154
  11. http://database.sarang.net/?inc=read&aid=21&criteria=mmdbms&subcrit=&id=&limit=&keyword=&pa ge=
  12. http://database.sarang.net/?inc=read&aid=22&criteria=mmdbms&subcrit=&id=&limit=&keyword=&page
  13. Sports Toto Ltd., "STMMDB: SportsTOTO MMDB Construction Project - Application_Test_Report", Sports Toto Ltd, March 2007.