International Journal of Computer Applications |
Foundation of Computer Science (FCS), NY, USA |
Volume 46 - Number 18 |
Year of Publication: 2012 |
Authors: Tanvi Jain, Rajasree S, Shivani Saluja |
10.5120/7042-9482 |
Tanvi Jain, Rajasree S, Shivani Saluja . Refreshing Datawarehouse in Near Real-Time. International Journal of Computer Applications. 46, 18 ( May 2012), 24-29. DOI=10.5120/7042-9482
Data warehousing technology has made a huge impact in the world of business; it helps to turn data into information that helps analysts to make strategic decisions. Currently most data warehouse approaches employ static refresh mechanisms. But for various business requirements this is not an appropriate solution. Some critical data need to be refreshed in real time. We propose an approach to identify critical data by considering two factors, namely: a) impact from one update, b) number of records affected. The identified critical data will be stored in the temporary tables, these temporary tables will be refreshed in real time and remaining data will be refreshed in conventional way