Abstract
Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from heterogeneous sources, their cleansing, customization and insertion into data warehouse. In fact, ETL are the key component of data warehousing process because incorrect or misleading data will produce wrong business decisions. Therefore, a correct design of the ETL process at early stages of data warehouse project is absolutely necessary to improve data quality. So, it is essential to overcome the ETL modeling phase with elegance in order to produce simple and understandable models. Many researches are dealt with the modeling of ETL process but today with the advent of trajectory data we need interactive modeling that manages the mobility aspect. In this paper, we extend existing model by incorporating a trajectory as a first class concept. So, we propose to model the ETL workflows as directed acyclic graphs that comprise three main components which are: the data sources, all the activities and the data stores.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Bala, M., Alimazighi, Z.: Modélisation de processus ETL dans un modèle MapReduce. In: Conférence Maghrébine sur les Avancées des Systèmes Décisionnels (ASD 2013), Marrakech, Maroc, pp. 1–12 (2013)
El Akkaoui, Z., Zemányi, E.: Defining ETLWorfklows using BPMN and BPEL. In: DOLAP 2009, Hong Kong, China, pp. 41–48 (2009)
El Akkaoui, Z., Zimányi, E., Mazón, J.N., Trujillo, J.: A model-driven framework for ETL process development. In: DOLAP 2011, Glasgow, Scotland, UK, pp. 45–52 (2011)
Krishna, R., Sreekanth: An object oriented modeling and implementation of web based ETL process. IJCSNS Int. J. Comput. Sci. Netw. Secur. 10(2), 192–196 (2010)
Lujan-Mora, S., Trujillo, J.: A UML based approach for modeling ETL processes in data warehouses. In: Song, I.-Y., Liddle, S.W., Ling, T.-W., Scheuermann, P. (eds.) Conceptual Modeling - ER 2003, vol. 2813, pp. 307–320. Springer, Heidelberg (2003)
Lujan-Mora, S., Vassiliadis, P., Trujillo, J.: Data mapping diagrams for data warehouse design with UML. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) Conceptual Modeling – ER 2004, vol. 3288, pp. 191–204. Springer, Heidelberg (2004)
Mrunalini, M., Suresh Kumar, T.V., Evangelin Geetha, D., Rajanikanth, K.: Modelling of data extraction in ETL processes using UML 2.0. DESIDOC Bull. Inf. Technol. 26, 3–9 (2006). DESIDOC
Marketos, G.: Datawarehousing and mining techniques for moving object databases. Thesis, Greece (2009)
Misra, S., Saha, S.K., Mazumdar, C.: Performance comparison of hadoop based tools with commercial ETL tools – a case study. In: Bhatnagar, V., Srinivasa, S. (eds.) Big Data Analytics (BDA 2013). LNCS, vol. 8302, pp. 176–184. Springer, Cham (2013)
Nabli, A., Bouaziz, S., Yangui, R., Gargouri, F.: Two-ETL phases for data warehouse creation: design and implementation. In: Morzy, T., Valduriez, P., Bellatreche, L. (eds.) Advances in Databases and Information Systems, vol. 9282, pp. 138–150. Springer, Cham (2015)
Simitsis, A.: Mapping conceptual to logical models for ETL processes. In: Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP, Germany, pp. 67–76 (2005)
Simitsis, A., Wilkinson, K., Dayal, U., Castellanos, M.: Leveraging business process models for ETL design. In: Proceedings of the 29th International Conference on Conceptual Modeling, Canada, pp. 15–30 (2010)
Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Conceptual modeling for ETL processes. In: Proceedings of the 5th ACM International Workshop on Data Warehousing and OLAP, USA, pp. 14–21 (2002)
Vučković, M., Petrović, M., Turajlić, N., Stanojević, M.: The specification of ETL transformation operations based on weaving models. Int. J. Comput. Commun. Control 7(5), 968–975 (2012)
Wagner, R., Macedo, J., Raffaeta, A., Renso, C., Roncato, A., Trasarti, R.: Mob-Warehouse: a semantic approach for mobility analysis with a trajectory data warehouse. In: Parsons, J., Chiu, D. (eds.) Advances in Conceptual Modeling. LNCS, vol. 8697, pp. 127–136. Springer, Cham (2014)
Zekri, A., Akaichi, J.: An ETL for integrating trajectory data: a medical delegate activities use case study. In: The International Conference on Automation, Control, Engineering and Computer Science (ACECS 2014), Monastir, Tunisia, pp. 138–147 (2014)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG
About this paper
Cite this paper
Zekri, A., Massaâbi, M., Layouni, O., Akaichi, J. (2018). Trajectory ETL Modeling. In: De Pietro, G., Gallo, L., Howlett, R., Jain, L. (eds) Intelligent Interactive Multimedia Systems and Services 2017. KES-IIMSS-18 2018. Smart Innovation, Systems and Technologies, vol 76. Springer, Cham. https://doi.org/10.1007/978-3-319-59480-4_38
Download citation
DOI: https://doi.org/10.1007/978-3-319-59480-4_38
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-59479-8
Online ISBN: 978-3-319-59480-4
eBook Packages: EngineeringEngineering (R0)