Browse > Article
http://dx.doi.org/10.9728/dcs.2014.15.5.631

Application Performance Evaluation in Main Memory Database System  

Kim, Hee-Wan (삼육대학교 컴퓨터학부)
Ahn, Yeon S. (가천대학교 경영학부)
Publication Information
Journal of Digital Contents Society / v.15, no.5, 2014 , pp. 631-642 More about this Journal
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.
Keywords
Main Memory DBMS; Disk-driven DBMS; Transaction; Performance; Response Time;
Citations & Related Records
연도 인용수 순위
  • Reference
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   DOI
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.