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)