Loading...
Please wait, while we are loading the content...
Similar Documents
Active Datawarehouse Loading by GUI Based ETL Procedure
| Content Provider | NIT Rourkela |
|---|---|
| Author | Reddy, V. M. Jena, S. K. Rao, M. N. |
| Description | Proceedings of the International Conference on Computational Intelligence Applications, ICCIA2010, 03-05 March 2010, Nashik, India, P 27-32 |
| 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 necessary to act upon the results of Business Intelligence analyses. In this paper we present a methodology on how to adapt data warehouse schemas and loading the fresh data with the help of the GUI based ETL [12][13] (Extraction, Transformation and Loading) procedure for Active Data Warehouse. To accomplish this, we use techniques such as table structure replication and query predicate restrictions for selecting data, to enable continuously loading data in the data warehouse with minimum impact in query execution time. |
| File Size | 227596 |
| File Format | |
| Language | English |
| Publisher | ICCIA-2010 |
| Access Restriction | Open |
| Subject Keyword | Real-time and active data warehousing Continuous data integration for data warehousing Data Warehouse Refreshment Loading Process GUI based ETL |
| Content Type | Text |
| Resource Type | Article |
