Figure 7: TDSrc model. 
Since the TDSrc model is presented, it becomes 
ready to be processed according to the second 
transformation step T2 which goals at generating the 
target models (TDM) from the TDSrc model basing 
on the MDA approach.  Transforming models using 
MDA is related to the source model that must be 
conform to its meta-model and the target meta-
model, recently defined, and the transformation rules 
defined textually in (Azaiez and Akaichi, 2015) and 
translated using ATL (Figure 6). TDSrc is a 
relational model which consists of a set of tables and 
columns that have to be transformed into a set of 
multidimensional elements (facts, dimensions...). 
According to our case study, applying the ATL 
transformation rules leads to create a set of TDM 
models. For example, the table Trajectory in the 
TDSrc model feeds a trajectory fact table 
F_Trajectory in the multidimensional design since it 
satisfies conditions enumerated in the transformation 
rule that is destined to identify trajectory facts. The 
tables Patient, Move and Stop satisfy conditions 
enumerated in the transformation rule that is 
destined to identify dimensions. Therefore, they feed 
respectively, D_Patient, D_Move and D_Stop. The 
dimension D_Date is required in every 
multidimensional schema since it contains all the 
information we need about a certain date, and allows 
analysts to analyze data as accurately as possible.  
5 CONCLUSIONS 
In this paper, we presented an overview on solutions 
proposed by the research community to deal with the 
ETL modeling problem. We expected the absence of 
an ETL process that really leads to a better data 
analysis. Hence, we relied on the Trajectory ELT 
process to facilitate the propagation of the TD from 
Operational Trajectory sources towards Trajectory 
Warehouse area. Since the transformation task is the 
core of the Trajectory ELT process, we proposed a 
trajectory construction algorithm to transform raw 
positions into trajectories and, therefore, generate 
the TDSrc model. Then, we relied on the power of 
the MDA mechanism to transform the obtained 
source model into target models. We illustrated the 
efficiency of our approach using a medical use case. 
Currently, we are extending our framework to offer 
a system which handles easily the evolution of the 
whole warehousing chain while trajectory sources 
evolve; this ensures reaching the BI goals, especially 
extracting pertinent knowledge. 
REFERENCES 
ATLAS team, 2006. ATLAS Transformation Language 
(ATL) Home page. http://www.eclipse.org/gmt/atl/. 
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. 
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. 
Boussaid, O. Bentayeb. F., Darmont, J., 2003. An MAS-
Based ETL Approach for Complex Data. In 
proceedings of the 10th ISPE International 
Conference on Concurrent Engineering: Research and 
Applications. Madeira, Portugal, pp. 49-52. 
Marketos, G., Frentzos, E., Ntoutsi, I., Pelekis, N., 
Raffaetà, A., & Theodoridis, Y., 2008. Building real-
world trajectory warehouses. In Proceedings of the 
International ACM Workshop on Data Engineering 
for Wireless and Mobile Access. Vancouver, BC, 
Canada,pp. 8-15. 
OMG, 2004.  Model  Driven  Architecture  (MDA).  
http://www.omg.org/cgibin/doc?formal/03-06-01. 
OMG, 2006. Meta Object Facility (MOF) 2.0 Core 
Specification. OMG Document formal /2006-01-01. 
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. 
Simitsis. A., 2003. Modeling and Managing ETL 
Processes. VLDB Ph.D. Workshop. 
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. 
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. 
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. 
Patient (id_pat, first_name_pat, last_name_pat, id_Epilert#, id_disease#)
Docteur(id_doc, first_name_doc, last_name_doc, id_service#)
Epilert(id_Epilert, color, id_device#)
Service Medical device (id_device, marque)
Hospital service (id_sevice, designation)
Disease(id_disease, name_disease)
Trajectory (id_traj, #id_move, #id_stop, #id_pat)
Stop (id_stop, #id_begin, #id_end)
Move (id_move, #id_begin, #id_end)
Begin(id_begin, Begin_time)
End (id_end, End_time)