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

Next Level Data Warehouse with OLAP And OLTP

Author(s):

kunal kumar , SRM university NCR campus

Keywords:

In-memory analysis, row store database, Column store database, Database management.

Abstract

In the data warehouse we are using two important process that is OLTP(Online Transaction Processing) and OLAP(Online Analytical Processing) ,with the help of OLTP in the data warehouse we take data from different type of sources and store in row view in database and after some interval like three or six month that data update in data warehouse because in data warehouse regular updation is difficult because data warehouse contain large amount of data .OLAP is perform analysis data that is present is data warehouse. OLAP help to show our business performance means it show that our business is goes profit or loss or any kind of analysis .But the problem is OLA P take data from data warehouse and in the data warehouse contain historical data because not regular updation.so the problem is analysis report is based on old or historical data and we know business means change every day and result is not in real time. The problem is OLTP and OLAP we work on different type of database .So in this paper we try to solve this problem with the help combining OLTP and OLAP and then get real time result for better business analysis. So because of changing business trend we try to resolve the problem of historical analysis process proposed new techniques that help to analysis historical as well as current data.

Other Details

Paper ID: IJSRDV2I2078
Published in: Volume : 2, Issue : 2
Publication Date: 01/05/2014
Page(s): 203-206

Article Preview

Download Article