International Journal of Engineering and Management Research (IJEMR)
  • Year: 2013
  • Volume: 3
  • Issue: 5

Removing Data Staleness in Data Warehouse Using Trigger Based Approach

  • Author:
  • Bikramjit Pal1, Mallika De2
  • Total Page Count: 3
  • Page Number: 89 to 91

1Assistant Professor and Head, Department of Computer Application, JIS College of Engineering, Kalyani, Nadia, West Bengal, India

2Department of Engineering and Technological Studies, University of Kalyani, Kalyani, Nadia, West Bengal, India

Online published on 21 November, 2017.

Abstract

For storing a huge amount of data, data warehouse is in high demand as it supports large memory. But due to growth of storing data and its complexity, it is necessary to keep data warehouse fresh in regular intervals. Staleness factor is one of the key to keep fresh data in data warehouse. In this paper we tried to find out the staleness factor by tracking the number of times a database has been accessed in a given time interval.

Keywords

Data warehouse, complexity, staleness factor, database