A Comparative Study of Main Memory Databases and Disk-Resident Databases

Authors: F. Raja, M.Rahgozar, N. Razavi, M. Siadaty

Abstract:

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.

Keywords: Disk-Resident Database, FastDB, Main MemoryDatabase.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1061326

References:

[1] FastDB: a main-memory database object-relational database system, Available: http://www.garret.ru/~knizhnik/fastdb/FastDB.htm
[2] 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.
[3] 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.
[4] 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.
[5] Philip Bohannon, Peter McIlroy, Rajeev Rastogi," Main Memory Index Structures with FixedSize Partial Keys", In Proceedings of SIGMOD Conference, 2001.
[6] 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.
[7] 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.
[8] 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.
[9] 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.