Mapping conceptual to logical models for ETL processes

DOLAP 2005 - Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP, co-located with CIKM 2005

Volumn , Issue , 2005, Pages 67-76

  Simitsis, Alkis ^a  

^a NATIONAL TECHNICAL UNIVERSITY OF ATHENS   (Greece)

Author keywords

Conceptual modeling; Data warehousing; ETL; Logical modeling

Indexed keywords

EXTRACTION; MAPPING; METADATA;

CONCEPTUAL MODEL; ETL PROCESS; EXTRACTION-TRANSFORMATION-LOADING TOOLS; LOGICAL MODELING; LOGICAL MODELS;

DATA WAREHOUSES;

EID: 84958742563     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1097002.1097014     Document Type: Conference Paper

References (16)

1. Ballard, C. Data Modeling Techniques for Data Warehousing. SG24-2238-00, IBM Red Book, ISBN 0738402451, 1998.
2. Boehnlein, M., Ulbrich-vom Ende, A. Deriving the Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems. DOLAP, 1999.
3. Golfarelli, M., Rizzi, S. Methodological Framework for Data Warehouse Design. DOLAP, 1998.
4. Hahn, K., Sapia, C., Blaschka, M. Automatically Generating OLAP Schemata from Conceptual Graphical Models. DOLAP, 2000.
5. Kimball, R., et al. The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, 1998.
6. Luján-Mora, S., Vassiliadis, P., Trujillo, J. Data Mapping Diagrams for Data Warehouse Design with UML. ER, 2004.
7. Moody, D.L., Kortink, M.A.R. From Enterprise Models to Dimensional Models: a Methodology for Data Warehouse and Data Mart Design. DMDW, 2000.
8. Peralta, V. Data Warehouse Logical Design from Multidimensional Conceptual Schemas. CLEI, 2003.
9. Phipps, C., Davis, K. Automating Data Warehouse Conceptual Schema Design and Evaluation. DMDW, 2002.
10. Simitsis, A. Mapping Conceptual to Logical Models for ETL Processes. Extended version. Available at: www.dbnet.ece.ntua.gr\~asimi\publications\Simi05-TR.pdf
11. Simitsis, A., Vassiliadis, P. A Methodology for the Conceptual Modeling of ETL Processes. DSE, 2003.
12. Simitsis, A., Vassiliadis, P., Sellis, T. Optimizing ETL Processes in Data Warehouse Environments. ICDE, 2005.
13. Trujillo J., Lujan-Mora, S. A UML Based Approach for Modeling ETL Processes in Data Warehouses. ER, 2003.
14. Vassiliadis, P., Simitsis, A., Georgantas, P., Terrovitis, M., Skiadopoulos, S. A Generic and Customizable Framework for the Design of ETL Scenarios. Information Systems Journal, 30(7), 2005.
15. Vassiliadis, P., Simitsis, A., Skiadopoulos, S. Conceptual Modeling for ETL Processes. DOLAP, 2002.
16. Zaniolo, C. LDL++ Tutorial. UCLA. Available at: http://pike.cs.ucla.edu/ldl/, December 1998.