Published February 28, 2008
| Version 5588
Journal article
Open
A Comparative Study of Main Memory Databases and Disk-Resident Databases
Authors/Creators
Description
Main Memory Database systems (MMDB) store their
data in main physical memory and provide very high-speed access.
Conventional database systems are optimized for the particular
characteristics of disk storage mechanisms. Memory resident
systems, on the other hand, use different optimizations to structure
and organize data, as well as to make it reliable.
This paper provides a brief overview on MMDBs and one of the
memory resident systems named FastDB and compares the
processing time of this system with a typical disc resident database
based on the results of the implementation of TPC benchmarks
environment on both.
Files
5588.pdf
Additional details
References
- FastDB: a main-memory database object-relational database system, Available: http://www.garret.ru/~knizhnik/fastdb/FastDB.htm
- Inseon Lee, Heon Y.Yeon, Taesoon Park, "A New Approach for Distributed Main Memory Database Systems: A Causal Commit Protocol", IEICE Trans. Inf. & Syst., Vol.ES7, No.1 January 2004.
- Nicholas Carriero, Michael V. Osier, Kei-Hoi Cheung, Peter Masiar, Perry L. Miller, Kevin White, Martin Schultz, " Exploring the Use of Main Memory Database (MMDB) Technology for the Analysis of Gene Expression Microarray Data", Technical report, April 2004.
- Stefan Manegold, "Understanding, Modeling, and Improving Main- Memory Database Performance", November 2002, Available: www.cwi.nl/htbin/ins1/publications?request=pdf&key=Ma:DISS:02.
- Philip Bohannon, Peter McIlroy, Rajeev Rastogi," Main Memory Index Structures with FixedSize Partial Keys", In Proceedings of SIGMOD Conference, 2001.
- S. Manegold, P. A. Boncz, and M. L. Kersten. "Optimizing Main- Memory Join on Modern Hardware", IEEE Transactions on Knowledge and Data Engineering (TKDE), Vol.14, No.4, pp.709-730, July 2002.
- J. Rao and K. A. Ross. "Making B+-Trees Cache Conscious in Main Memory", Proc ACM SIGMOD International Conference on Management of Data (SIGMOD), pp. 475-486, Dallas, TX, USA, May 2000.
- Tobin J. Lehman, Michael J. Carey, "A Study of Index Structures for Main Memory Database Management Systems", Proc the Twelfth International Conference on Very Large Data Bases, Kyoto, August, 1986.
- Rajeev Rastogi, S. Seshadri, Philip Bohannon, Dennis Leinbaugh, "Logical and Physical Versioning in Main Memory Databases", Proc the 23rd VLDB Conference, Athens, Greece, 1997. [10] Hector Garcia-Molina, Kenneth Salem, "Main Memory Database Systems: An overview", IEEE Transactions on Knowledge and Data Engineering, 4(6):509--516, Dec. 1992. [11] Piyush Burte, Boanerges Aleman-Meza, D. Brent Weatherly, Rong Wu, "Transaction Management for a Main-Memory Database", Available: http://lsdis.cs.uga.edu/~aleman/mams/csci8370/paper/. [12] Tobin J. Lehman, Michael J. Carey, "Query Processing in Main Memory Database Management Systems", Proceedings of the ACM SIGMOD International Conference on the Management of Data, 1986, pp.239-250. [13] Margaret H. Eich, "Main Memory Database Recovery", Proceedings of 1986 ACM Fall joint computer conference, Pages: 1226 - 1232, 1986. [14] J. Baulier, P. Bohannon, S. Gogate, C. Gupta, S. Haldar, S. Joshi, A. Khivesera, H. F. Korth, P. McIlroy, J. Miller, P. P. S. Narayan, M. Nemeth, R. Rastogi, S. Seshadri, A. Silberschatz, S. Sudarshan, M. Wilder, and C. Wei. "DataBlitz Storage Manager: Main-Memory Database Performance for Critical applications", Proc ACM SIGMOD International Conference on Management of Data (SIGMOD), pp.519- 520, 1999. [15] M. Kauffman, "TPC BENCHMARK A Standard Specification", The Performance Handbook: for Database and Transaction Processing Systems, Transaction Processing Performance Council (TPC), 1991. [16] Fremont, "TPC Benchmark B Standard Specification ", Waterside Associates, Transaction Processing Performance Council, CA., August 1990.