White Papers

Mapping Conceptual to Logical Models for ETL Processes

Overview Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In previous line of research, the paper has presented a conceptual and a logical model for ETL processes. This paper describes the mapping of the conceptual to the logical model. First, the paper identifies how a conceptual entity is mapped to a logical entity. Next, it determines the execution order in the logical workflow using information adapted from the conceptual model. Finally, the paper provides a methodology for the transition from the conceptual to the logical model.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: Association for Computing Machinery
File Format: PDF
Date Published: Oct 14, 2008
Format: White Papers
Topics: Data Acquisition - ETL, Business Intelligence - Data Warehousing

Similiar White Papers

American Airlines uses Sybase IQ to conduct fast ad hoc queries to uncover fraudulent ticketing.

American Airlines is the world?s largest carrier, serving more than 250 cities in 41 countries with 1,100 airplanes and

Publisher: Sybase | Tags: data

Managing ETL Processes

ETL tools allow the definition of sometimes complex processes to extract, transform, and load heterogeneous data into a

Publisher: Association for Computing Machinery | Tags: data, data integration, data warehouse, management

Understanding the System Architecture of SAS/ETL and SAS/EBI Server for Federal Enterprise Architecture Requirements

This paper describes some of the key points learned through: many conversations with SAS Institute, and persistence to u

Publisher: SAS Institute | Tags: infrastructure, software

Climbing to the OLAP Summit With Oracle Warehouse Builder 10gR2

The aim of this whitepaper is to review how Oracle Warehouse Builder 10gR2 can help companies successfully implement new

Publisher: Oracle | Tags: data, data warehouse, database, management, server, unified, warehouse

Bust a Move with Your SSIS - Passing Package Variables

Integration Services (SSIS), the next generation of the Extract, Transport, and Load (ETL) feature included with Microso

Publisher: Global Knowledge | Tags: data

Association for Computing Machinery White Papers

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »