High Impact Factor : 4.396 icon | Submit Manuscript Online icon |

In Memory Database - Optimal Performance Solutions

Author(s):

Laxmi Ghate , Department of Computer Science & Engineering, Dr. Sau. Kamaltai Gawai Institute of Engineering & Technology, Darapur, affiliated to Sant Gadge Baba Amravati University, Amravati, Maharashtra, India ; Vaibhav Dhage, Department of Computer Science & Engineering, Dr. Sau. Kamaltai Gawai Institute of Engineering & Technology, Darapur, affiliated to Sant Gadge Baba Amravati University, Amravati, Maharashtra, India

Keywords:

In-memory; MMDB, IMDS, Times Ten, Data replication, Caching, Indexing, Buffer, NUMA; NVRM

Abstract

for several decades there have been two major trends that have had a critical impact on IT systems. The first is the ever increasing speed of CPU and second trend is the exponential growth of data size due to increased number of users, devices and IT applications in almost all areas of life. 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. Also users are now demanding more decision-enabling information on the tip of the finger. Hence, organizations are adapting to new data management solutions such as In Memory Database System (IMDS) or Main Memory Database systems (MMDB) which store their data in main physical memory and provide very high-speed access compared to traditional On Disk DBMS. This phase of the work provides overview of MMDB system, its characteristic, different available products and challenges associated with choosing and implementing MMDBs. Overview and features of Oracle Times Ten Database are mentioned as an example to explain the concept. In the next phase of the work, experimental study is proposed to arrive at optimal software, hardware and database configurations to ensure optimal performance for most widely used applications and user scenarios.

Other Details

Paper ID: IJSRDV4I20994
Published in: Volume : 4, Issue : 2
Publication Date: 01/05/2016
Page(s): 755-763

Article Preview

Download Article