Mapping conceptual to logical models for ETL processes

Alkis Simitsis

68 citations0/0 files storedACM International Workshop on Data Warehousing and OLAP (DOLAP)

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 Model-Driven Software Engineering Techniques Data Quality and Management

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 previous line of research, we have presented a conceptual and a logical model for ETL processes. In this paper, we describe the mapping of the conceptual to the logical model. First, we identify how a conceptual entity is mapped to a logical entity. Next, we determine the execution order in the logical workflow using information adapted from the conceptual model. Finally, we provide a methodology for the transition from the conceptual to the logical model.

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 — 68 citations exist upstream.

References

2002Conceptual modeling for ETL processes 1998The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom 2000From enterprise models to dimensional models: a methodology for data warehouse and data mart design.2003A UML Based Approach for Modeling ETL Processes in Data Warehouses 1998A methodological framework for data warehouse design 2002Automating data warehouse conceptual schema design and evaluation.1999Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems 1999Data Modeling Techniques for Data Warehousing

Cited by

2010Near Real-Time Data Warehousing Using State-of-the-Art ETL Tools 2008Data Warehousing and Mining: Concepts, Methodologies, Tools, and Applications

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.