Please use this identifier to cite or link to this item:
http://hdl.handle.net/2080/1274
Title: | Active Datawarehouse Loading by Tool Based ETL Procedure |
Authors: | Reddy, V M Jena, S K |
Keywords: | Active DataWarehouse Real-Time DataWarehouse Data Acquisition code based ETL Tool based ETL |
Issue Date: | Jul-2010 |
Publisher: | WORLDCOMP’10 |
Citation: | International Conference on Information and Knowledge Engineering, 2010 (IKE'10), P 196-201 |
Abstract: | Over the years, DataWarehousing has gone through a number of evolutions from a relatively simple reporting database to sophisticated analytical applications such as analyzing customer lifetime values, market basket analyses, potentially defecting customers, fraud patterns, inventory churns, and so on. In all, though, these static sets of data could not give us the most current and recent changes of data necessary to act upon the results of Business Intelligence analyses. So, the traditional DataWarehouses are Static in nature. They are not showing any dynamics in their structure and content. In this paper we present a methodology on how to adapt data warehouse schemas and loading the fresh data with the help of the Tool based [12][13] Extraction, Transformation and Loading (ETL) procedure for Active Data Warehouse. To achieve the dynamic nature for the DataWarehouse, we are using Ricardo-Jorge [1] techniques such as table structure replication and query predicate restrictions for selecting data, to enable continuously loading data in the DataWarehouse with minimum impact in query execution time. |
Description: | Copyright belongs to the Proceedings Publisher WORLDCOMP’10. |
URI: | http://hdl.handle.net/2080/1274 |
ISBN: | 1-60132-131-7 |
Appears in Collections: | Conference Papers |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
IKE4501.pdf | 552.61 kB | Adobe PDF | View/Open |
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.