Optimization of ETL Work Flow in Data Warehouse
Journal Title: International Journal on Computer Science and Engineering - Year 2012, Vol 4, Issue 9
Abstract
ETL is responsible for extracting the information or data from different several Areas and applies some cleaning, customization, transformation function for data and finally loading into the data warehouse. This paper presents , to implement the one ETL scenario with the help of ARKTOS II. It is a stepwise process, firstly to design the conceptual model for the ETL scenario it contains the quick documentation which contains their relationships, attributes and transformation among them. Next one is a formal logical model for the ETL scenario, it contains the flow of data from the sources towards the data warehouse through the transformations and data stores. ETL processes handle the large volume of data, and managing the workload. It is a complex task and expensive operations in terms of time and system resources. Therefore to minimize the time required for completion of ETL workflow and resources needed for the ETL tasks. So that we implement the optimization for the ETL workflows, in the minimizing the total cost of the ETL scenario.
Authors and Affiliations
Kommineni Sivaganesh , P Srinivasu , Dr Suresh Chandra Satapathy
Keywords
Related Articles
- EP ID EP92787
- DOI -
- Views 133
- Downloads 0
A Parallel Access Method for Spatial Data Using GPU
Spatial access methods (SAMs) are used for information retrieval in large spatial databases. Many of the SAMs use sequential tree structures to search the result set of the spatial data which are contained in the given q...
Iris Recognition Based On Its Texture Patterns
A biometric system uniquely identifies and authenticates humans based on their physical or behavioural features. Iris recognition is one of the most reliable methods of biometric authentication that recognizes a person b...
Experimenting with Request Assignment Simulator (RAS)
There is no existence of dedicated simulators on the Internet that studies the impact of load balancing principles of the cloud architectures. Request Assignment Simulator (RAS) is a customizable, visual tool that helps...
A Novel Search Engine to trace Medical Information Needs using Medical Domain Ontology
Information retrieval in medical domain is now sharing major part of the web search. Now a day’s most of the people especially adults are browsing health care and medical information at their homes using internet. Medica...
Clustered Chain based Power Aware Routing (CCPAR) Scheme for Wireless Sensor Networks
Wireless sensor networks with thousands of tiny sensor nodes are becoming immensely popular due to their wide applicability in multitude of applications such as monitoring and collecting data from unattended hazardous en...