| Publisher | Association for Computing Machinery | ||
|---|---|---|---|
| Format | 270.0KB PDF | Date added | 30 Aug 2008 |
| Topics | Data Acquisition - ETL, Business Intelligence - Data Warehousing | ||
| Downloads | 20 | ||
ETL tools allow the definition of sometimes complex processes to extract, transform, and load heterogeneous data into a data warehouse or to perform other data migration tasks. In larger organizations many ETL processes of different data integration projects are accumulated. Such processes can encompass common sub-processes, shared data sources and targets, and same or similar operations. However, there is no common method or approach to systematically manage such ETL processes. The paper proposes the high-level management of such processes as a generic approach to enable their flexible re-use, optimization, and rapid development. To this end the paper introduces a set of basic operators on ETL processes, such as merge or invert, and motivate their use in several scenarios.
Did you find this white paper useful?
3 out of 8 users found this white paper useful
Related white papers
Customer Centricity, Master Data and the "360-Degree View"
When reviewing the popular literature on customer data integration and master data management, a frequently recurring business driver is the ability to establish a "360-degree view of the customer." This...
Gaining Perspective on Performance: Best Practices for an Effective 360-Degree Feedback Program
When planned in advance and run strategically, a 360-degree feedback program can offer serious business value. Feedback from multiple raters provides useful data on your employees, their performance, and their...
Predictive Analytics for the Claim Handling Process
Predictive Analytics for the Claim Handling Process: Understanding the Analytics Behind Predictive Claims This 12-page technical brief serves as a guide for understanding how Predictive Claims' predictive modeling capabilities can...
Wireless Clinical Trial of Data Capture Using a Personal Digital Assistant
Personal Digital Assistants (PDAs) have the potential to improve clinical trial data collection; however, most current PDA-based clinical data collection systems typically collect and store data in the offline mode,...
Premier Research Group Limited Supports Clinical Trials With Consolidated, Less Costly IT System
Premier Research Group Limited wanted to leverage technology to be more responsive to clients, ultimately helping clients improve their clinical trials and increasing client satisfaction and consolidate numerous geographically-dispersed clinical...
Windows 7 Adoption Survey: A Survey of Technology Professionals
This Dimensional Research report is based on a survey of 1,142 IT professionals. The goal of the survey was to gather data about current plans and attitudes within corporate IT...
Incorporating Site-Level Knowledge to Extract Structured Data From Web Forums
Web forums have become an important data resource for many web applications, but extracting structured data from unstructured web forum pages is still a challenging task due to both complex...
