A Methodology for the Conceptual Modeling of ETL Processes.

Alkis Simitsis · Panos Vassiliadis

44 citations0/0 files stored

No readable copy stored yet — this record is metadata only.

No open-access location is known for this record yet.

Literature note Cite in a project Citation map

Big Data and Business Intelligence Advanced Database Systems and Queries Model-Driven Software Engineering Techniques

Abstract

Abstract. 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 this paper, we propose 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. 1

Paper brief

Loading…

Cite this work

Citation unavailable for this work.

BibTeX RIS CSL-JSON

No public copy is stored for this record, so only the metadata is cited.

Citations in this library

Citation map →

Stored only when both papers are in the corpus — 44 citations exist upstream.

References

2000Data Cleaning: Problems and Current Approaches.2001Potter's Wheel: An Interactive Data Cleaning System 1998THE DIMENSIONAL FACT MODEL: A CONCEPTUAL MODEL FOR DATA WAREHOUSES 2002Conceptual modeling for ETL processes 1998The Data Warehouse Lifecycle Toolkit : Expert Methods for Designing, Developing, and Deploying Data Warehouses 2000Automatically Extracting Structure from Free Text Addresses.2001Designing data warehouses with OO conceptual models 2000From enterprise models to dimensional models: a methodology for data warehouse and data mart design.

Cited by

2022Data Warehousing Process Modeling from Classical Approaches to New Trends: Main Features and Comparisons 2012BPMN Patterns for ETL Conceptual Modelling and Validation 2003Modeling and managing ETL processes.2011ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study 2015Integration Adapter Modeling

Explore the map →

Papers that cite the same references — the relational fallback while embeddings are still backfilling.

Imported from OpenAlex (CC0) — nothing here is generated.