A Comparative Study of Main Memory Databases and Disk-Resident Databases
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.
[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.
[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.
@article{"International Journal of Information, Control and Computer Sciences:54678", author = "F. Raja and M.Rahgozar and N. Razavi and M. Siadaty", title = "A Comparative Study of Main Memory Databases and Disk-Resident Databases", 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.", volume = "2", number = "2", pages = "385-4", }
