A method for the mapping of conceptual designs to logical blueprints for ETL processes

Decision Support Systems

Volumn 45, Issue 1, 2008, Pages 22-40

  Simitsis, Alkis ^a   Vassiliadis, Panos ^b  

^a NATIONAL TECHNICAL UNIVERSITY OF ATHENS   (Greece)

^b UNIVERSITY OF IOANNINA   (Greece)

Author keywords

Conceptual modeling; Data warehouses; ETL; Logical modeling

Indexed keywords

BLUEPRINTS; CONCEPTUAL DESIGN; DATA WAREHOUSES; PROJECT MANAGEMENT;

CONCEPTUAL MODEL; LOGICAL MODELING;

COMPUTER AIDED SOFTWARE ENGINEERING;

EID: 41149095656     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.dss.2006.12.002     Document Type: Article

References (20)

1. Ballard C. Data Modeling Techniques for Data Warehousing. SG24-2238-00, IBM Red Book (1998). 0738402451
2. Bekaert P., Van Nuffelen B., Bruynooghe M., Gilis D., and Denecker M. On the Transformation of Object-Oriented Conceptual Models to Logical Theories, in ER (2002)
3. Boehnlein M., and Ulbrich-vom Ende A. Deriving the Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems, in DOLAP (1999)
4. Golfarelli M., and Rizzi S. Methodological Framework for Data Warehouse Design, in DOLAP (1998)
5. Hahn K., Sapia C., and Blaschka M. Automatically Generating OLAP Schemata from Conceptual Graphical Models, in DOLAP (2000)
6. Kimball R., et al. The Data Warehouse Lifecycle Toolkit (1998), John Wiley & Sons
7. Luján-Mora S., Vassiliadis P., and Trujillo J. Data Mapping Diagrams for Data Warehouse Design with UML, in ER (2004)
8. Moody D.L., and Kortink M.A.R. From Enterprise Models to Dimensional Models: a Methodology for Data Warehouse and Data Mart Design, in DMDW (2000)
9. Naqvi S., and Tsur S. A Logical Language for Data and Knowledge Bases (1989), Computer Science Press
10. Peralta V. Data Warehouse Logical Design from Multi-dimensional Conceptual Schemas, in CLEI (2003)
11. C. Phipps, Migrating an Operational Database Schema to a Data Warehouse Schema, PhD thesis (University of Cincinnati, USA, 2001).
12. Phipps C., and Davis K. Automating Data Warehouse Conceptual Schema Design and Evaluation, in DMDW (2002)
13. Simitsis A., and Vassiliadis P. A Methodology for the Conceptual Modeling of ETL Processes, in DSE (2003)
14. Simitsis A., Vassiliadis P., and Sellis T. Optimizing ETL Processes in Data Warehouse Environments, in ICDE (2005)
15. Trujillo J., and Lujan-Mora S. A UML Based Approach for Modeling ETL Processes in Data Warehouses, in ER (2003)
16. Vassiliadis P., Simitsis A., and Skiadopoulos S. Modeling ETL Activities as Graphs, in DMDW (2002)
17. Vassiliadis P., Simitsis A., and Skiadopoulos S. Conceptual Modeling for ETL Processes, in DOLAP (2002)
18. Vassiliadis P., Simitsis A., Georgantas P., and Terrovitis M. A Framework for the Design of ETL Scenarios, in CAiSE (2003)
19. Vassiliadis P., Simitsis A., Georgantas P., Terrovitis M., and Skiadopoulos S. A generic and customizable framework for the design of ETL scenarios. Information Systems Journal 30 7 (2005)
20. Zaniolo C. LDL++ Tutorial (Dec. 1998), UCLA. http://pike.cs.ucla.edu/ldl/ Available at: http://pike.cs.ucla.edu/ldl/