APPLICATION OF IN-MEMORY DATABASE IN REPORTING OF THE BANKING INFORMATION SYSTEM

Abstract

In-Memory Database is a database located in computer’s main memory. Given that access to and processing of data from main memory much faster than when the data on the disk, the main advantage of using a memory database is remarkable efficiency from the point of data access speed and execution of transactions in real time. This paper presents the concept of memory database and examine its capabilities in order to improve performance for information system of specific business system - the banking information system. In the banking system, the most important functionalities are in connection with financial transactions, so that for the safety and integrity of the data, the classic database is very important for the banking system. Also, reporting is the relevant functionality, which is very important to the clients of bank. The idea of this work is to achieve performance improvements in the area of reporting system, making use of the memory database possibilities. The paper analyzes the speed of execution of queries over the data from the basic tables of the core banking system used in the most important reporting. Options of inclusion the database objects in the In-Memory Column Store are considered for the In-Memory ORACLE Database 12c. The execution times are compared for the same queries over same database tables with and without inclusion in the Memory Column In-Store.