In-Memory Database Systems - A Paradigm Shift

  ijett-book-cover  International Journal of Engineering Trends and Technology (IJETT)          
© 2013 by IJETT Journal
Volume-6 Number-6
Year of Publication : 2013
Authors : Mohit Kumar Gupta , Vishal Verma , Megha Singh Verma


Mohit Kumar Gupta , Vishal Verma , Megha Singh Verma. "In-Memory Database Systems - A Paradigm Shift". International Journal of Engineering Trends and Technology (IJETT). V6(6):333-336 Dec 2013. ISSN:2231-5381. published by seventh sense research group


In today’s world, organizations like Google, Yahoo, Amazon, Facebook etc. are facing drastic increase in data. This leads to the problem of capturing, storing, managing and analyzing terabytes or petabytes of data, stored in multiple formats, from different internal and external sources. Moreover, new applications scenarios like weather forecasting, trading, artificial intelligence etc. need huge data processing in real time. These requirements exceed the processing capacity of traditional on-disk database management systems to manage this data and to give speedy real time results. Therefore, data management needs new solutions for coping with the challenges of data volumes and processing data in real-time. An in-memory database system (IMDS) is a latest breed of database management system which is becoming answer to above challenges with other supporting technologies. IMDS is capable to process massive data distinctly faster. This paper explores IMDS approach and its associated design issues and challenges. It also investigates some famous commercial and open-source IMDS solutions available in the market.


[1] IDC Digital Universe Study. (2012) The Digital Universe in 2020: Big Data, Bigger Digital Shadows, and Biggest Growth in the Far East. . [Online]. Available:
[2] Hector Garcia-Molina, and Kenneth Salem, “Main Memory Database Systems: An Overview”, IEEE Transactions on Knowledge And Data Engineering, Vol. 4, No. 6, pp. 509-516, Dec. 1992.
[3] Main Memory vs. RAM-Disk Databases, McObject LLC. (2003) [Online]. Available:
[4] Y. Huang, Y. Zhang, X. Ji, Z. Wang, and S. Wang, “A Data Distribution Strategy for Scalable Main-Memory Database”, Advances in Web and Network Technologies, and Information Management, Lecture Notes in Computer Science, Vol. 5731, pp. 13-24, 2009.
[5] A. Gorine, “Building durability into data management for real-time systems”, Boards & Solutions, Sep. 2004.
[6] Oracle TimesTen In-memory database. [Online]. Available:
[7] IBM SolidDB. [Online]. Available:
[8] McObject – extremeDB in-memory database systems. [Online]. Available:
[9] vFabric SQLFire [Online]. Available:
[10] SAP HANA [Online]. Available:
[11] SQLite. [Online]. Available:
[12] CSQL [Online]. Available:
[13] MonetDB [Online]. Available:

In-Memory Database System (IMDS), Design issues and challenges for IMDS, Commercial and open-source IMDS.