Defining ETL worfklows using BPMN and BPEL

International Conference on Information and Knowledge Management, Proceedings

Volumn , Issue , 2009, Pages 41-48

  El Akkaoui, Zineb ^a   Zimányi, Esteban ^a  

^a UNIVERSITÉ LIBRE DE BRUXELLES   (Belgium)

Author keywords

Conceptual modeling; Data warehouses; ETL; Logical modeling

Indexed keywords

BUSINESS PROCESS EXECUTION LANGUAGE; BUSINESS PROCESS MODEL; CONCEPTUAL MODEL; CONCEPTUAL MODELING; DECISIONAL SYSTEM; ENTERPRISE DATA; ESSENTIAL COMPONENT; ETL PROCESS; HETEROGENEOUS DATA; LOGICAL MODELING; TOOL USE;

KNOWLEDGE MANAGEMENT; LINGUISTICS; MANAGEMENT SCIENCE; WEB SERVICES;

DATA WAREHOUSES;

EID: 74549159615     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1651291.1651299     Document Type: Conference Paper

References (19)

1. A. Simitsis, P. Vassiliadis, and T. Sellis. Optimizing ETL processes in data warehouse environments. In Proc. of the 21st Int. Conf. on Data Engineering, ICDE'05, pages 564-575, 2005. IEEE Computer Society Press.
2. 2 (Yet Another Multidimensional Model): An extension of UML. Information Systems, 32(6):541-567, 2006.
3. M. Golfarelli and S. Rizzi. A methodological framework for data warehouse design. In Proc. of the 1st ACM Int. Workshop on Data Warehousing and OLAP, DOLAP'98, pages 3-9, 1998. ACM Press.
4. S. Luján-Mora, J. Trujillo, and I. Song. A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering, 59(3):725-769, 2006.
5. E. Malinowski and E. Zimányi. From Conventional to Spatial and Temporal Applications. Springer, 2008.
6. OASIS. Web Services Business Process Execution Language Version 2.0. http://docs.oasis-open.org/wsbpel/2.0/wsbpel-v2.0.pdf, 2007.
7. OMG. Business Process Modeling Notation (BPMN). http://www.omg.org/docs/ formal/09-01-03.pdf, 2009.
8. C. Phipps and K. Davis. Automating data warehouse conceptual schema design and evaluation. In Proc. of the 4th Int. Workshop on Design and Management of Data Warehouses, DMDW'02, pages 23-32, 2002.
9. O. Romero and A. Abelló. Automating multidimensional design from ontologies. In Song and Pedersen [15], pages 1-8.
10. C. Sapia, M. Blaschka, G. Höfling, and B. Dinter. Extending the E/R model for multidimensional paradigm. In Proc. of the 17th Int. Conf. on Conceptual Modeling, ER'98, LNCS 1507, pages 105-116, 1998. Springer.
11. A. Simitsis. Mapping conceptual to logical models for ETL processes. In Proc. of the 8th ACM Int. Workshop on Data Warehousing and OLAP, DOLAP'05, pages 67-76, 2005. ACM Press.
12. D. Skoutas and A. Simitsis. Designing ETL processes using semantic web technologies. In Proc. of the 9th ACM Int. Workshop on Data Warehousing and OLAP, DOLAP'06, pages 67-74, 2005. ACM Press.
13. D. Skoutas and A. Simitsis. Ontology-based conceptual design of ETL processes for both structured and semi-structured data. Int. Journal on Semantic Web and Inf. Sys., 3(4):1-24, 2007.
14. D. Skoutas, A. Simitsis, and T. Sellis. Ontology-driven conceptual design of ETL processes using graph transformations. In Journal on Data Semantics XIII, number 5530 in LNCS, pages 122-149. Springer, 2009.
15. I. Song and T. Pedersen, editors. Proc. of the 10th ACM Int. Workshop on Data Warehousing and OLAP, DOLAP'07, 2007. ACM Press.
16. R. Torlone. Conceptual multidimensional models. In M. Rafanelli, editor. Multidimensional Databases: Problems and Solutions, pages 69-90. Idea Group, 2003.
17. N. Tryfona, F. Busborg, and J. Borch. StarER: A conceptual model for data warehouse design. In Proc. of the 2nd ACM Int. Workshop on Data Warehousing and OLAP, DOLAP'99, pages 3-8, 1999. ACM Press.
18. V. Tziovara, P. Vassiliadis, and A. Simitsis. Deciding the physical implementation of ETL workflows. In Song and Pedersen [15], pages 49-56.
19. P. Vassiliadis, A. Simitsis, and S. Skiadopoulos. Conceptual modeling for ETL processes. In Proc. of the 5th ACM Int. Workshop on Data Warehousing and OLAP, DOLAP'02, pages 14-21, 2002. ACM Press.