Override Traditional Decision Support Systems - How Trajectory ELT Processes Modeling Improves Decision Making?

Noura Azaiez, Jalel Akaichi

Abstract

Business Intelligence is often described as a set of techniques serving the transformation of raw data into meaningful information for business analysis purposes. Thanks to the technology development in the realm of Geographical Information Systems, the so-called trajectory data were appeared. Analysing these raw trajectory data coming from the movements of mobile objects requires their transformation into decisional data. Usually, the Extraction-Transformation-Loading (ETL) process ensures this task. However, it seems inadequate to support trajectory data. Integrating the trajectory aspects gives the birth of Trajectory ETL process (T-ETL). Unfortunately, this is not enough. In fact, the business analysis main purpose is to minimize costs and time consuming. Thus, we propose to swap the T-ETL tasks scheduling: instead of transforming the data before they are written, the Trajectory Extraction, Loading and Transformation (T-ELT) process leverages the target system to achieve the transformation task. In this paper, we rely on a set of powerful mechanisms to handle the complexity of each T-ELT task. Wherefore, an algorithm is dedicated to ensure the transformation of raw mobile object positions into trajectories and from there we highlight the power of the Model-driven Architecture approach to transform the resulting trajectories into analytical data in order to perform the Business Intelligence goal.

References

  1. ATLAS team, 2006. ATLAS Transformation Language (ATL) Home page. http://www.eclipse.org/gmt/atl/.
  2. Azaiez, N., Akaichi, J., 2015. How Trajectory Data Modeling Improves Decision Making? In proceedings of the 10th International Conference on Software Engineering and Applications. Colmar, Alsace, France, pp. 87-92.
  3. Azaiez, N., Akaichi, J., 2016. What is the Impact of Mobility Data Integration on Decision Support Systems' Modelling and Evolution? The International Journal of Information Systems in the Service Sector (IJISSS), 8(1), pp.1-12.
  4. Boussaid, O. Bentayeb. F., Darmont, J., 2003. An MASBased ETL Approach for Complex Data. In proceedings of the 10th ISPE International Conference on Concurrent Engineering: Research and Applications. Madeira, Portugal, pp. 49-52.
  5. Marketos, G., Frentzos, E., Ntoutsi, I., Pelekis, N., Raffaetà, A., & Theodoridis, Y., 2008. Building realworld trajectory warehouses. In Proceedings of the International ACM Workshop on Data Engineering for Wireless and Mobile Access. Vancouver, BC, Canada,pp. 8-15.
  6. OMG, 2004. Model Driven Architecture (MDA). http://www.omg.org/cgibin/doc?formal/03-06-01.
  7. OMG, 2006. Meta Object Facility (MOF) 2.0 Core Specification. OMG Document formal /2006-01-01.
  8. Rifaieh, R., Benharkat, N. A., 2002. Query-based data warehousing tool. In proceedings of the 5th ACM International workshop on Data Warehousing and OLAP, pp. 35 - 42.
  9. Simitsis. A., 2003. Modeling and Managing ETL Processes. VLDB Ph.D. Workshop.
  10. Taktak, S., Alshomrani, S., Feki, J., Zurfluh, G., 2015. An MDA Approach for the Evolution of Data Warehouses. The International Journal of Decision Support System technology (IJDSST); 7(3), pp. 65-89.
  11. Vassiliadis, P., Simitsis, A., Georgantas P., Terrovitis, M., 2003. A framework for the design of ETL scenarios. In the proceedings of the 15th CAiSE. Velden, Austria, pp 520-535.
  12. Zekri, A., Akaichi, J., 2014. An ETL for Integrating Trajectory Data A Medical Delegate Activities Use Case Study. In the proceedings of the International Conference on Automation, Control, Engineering and Computer Science, pp.138-147.
Download


Paper Citation


in Harvard Style

Azaiez N. and Akaichi J. (2017). Override Traditional Decision Support Systems - How Trajectory ELT Processes Modeling Improves Decision Making? . In Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD, ISBN 978-989-758-210-3, pages 550-555. DOI: 10.5220/0006269605500555


in Bibtex Style

@conference{modelsward17,
author={Noura Azaiez and Jalel Akaichi},
title={Override Traditional Decision Support Systems - How Trajectory ELT Processes Modeling Improves Decision Making?},
booktitle={Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,},
year={2017},
pages={550-555},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006269605500555},
isbn={978-989-758-210-3},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,
TI - Override Traditional Decision Support Systems - How Trajectory ELT Processes Modeling Improves Decision Making?
SN - 978-989-758-210-3
AU - Azaiez N.
AU - Akaichi J.
PY - 2017
SP - 550
EP - 555
DO - 10.5220/0006269605500555