White Papers
A Methodology for the Conceptual Modeling of ETL Processes
Category: Data Management
Tags: data warehouse, software, data
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. This paper proposes a methodology for the earliest stages of the data warehouse design, with the goal of tracing the analysis of the structure and content of the existing data sources and their intentional mapping to the common conceptual data warehouse model. The methodology comprises a set of steps that can be summarized as follows: (a) identification of the proper data stores; (b) candidates and active candidates for the involved data stores; (c) attribute mapping between the providers and the consumers, and (d) annotation of the diagram with runtime constraints.
- Publisher
- University of Ioannina
- File Format
- 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
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
University of Ioannina White Papers
Deep Belief Networks for Spam Filtering
This paper proposes a novel approach for spam filtering based on the use of Deep Belief Networks (DBNs). In contrast to
Publisher: University of Ioannina | Tags: spam
Featured white papers
-
The Value of Location Intelligence in the Communications Industry
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...
-
Best Practices for Translating Customer Satisfaction into Revenue
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...
-
HP print solutions and 3M
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...
-
Check out these top business apps for your iPhone
-
Inside a Microsoft datacentre
-
Green IT without losing your edge
-
Peter Cochrane's latest video blog
-
What you need to know about Windows 7