![](bg8.png)
2013), we investigated the problem of DW evolution
only in the case of tables and columns addition.
Besides, we chose the schema evolution approach as
the base of the work.
The comparative study express that the current
proposed approach offers coherent analysis results
unlike results given in (Azaiez et al., 2013). In fact,
in this latter, queries are unable to return data which
are the results of an evolution phenomenon contin-
ued in several time intervals, since the schema evo-
lution approach is based on the hypothesis that the
DW schema has only one version; it’s the current
one.
The following table compares of our proposed
approach versus the previous one:
Table 4: Comparative study.
(Azaiez et
al., 2013)
Our
approach
Evolution
approach
Schema Evolution
Schema Versioning
Evolution
operations
Addition
tables/columns
Deletion
tables/columns
7 CONCLUSION AND
PERSPECTIVE
In this paper, we presented an overview on the DW
evolution problems. Indeed, we exposed some solu-
tions proposed by different authors in recent years.
To overcome the problem related of the DW schema
changes and their impacts on DMs, we proposed an
approach which deals with the propagation problem
of DW changes on its DMs; this approach is based
on "if-then" type rules. However, this is not enough
to ensure the analysis results coherence and con-
sistency. Therefore, we relied on the schema ver-
sioning approach to keep trace of evolutions affect-
ing DW model and their impacts on related DMs.
This paper is limited at studying the evolution
modeling of classic DWs that includes data which
concerned only fixed objects, and neglected moving
objects activities that generate a new data type so
called “trajectory data”; those latter are stored in a
mobile data central repository that called Trajectory
Data Warehouse (TDW). As perspective, we pro-
pose to deal with the TDW evolution problems tak-
ing into account its new data type and structure
changes.
REFERENCES
Akaichi, J., Oueslati, W., 2008. MAVIE: A Mobile Agents
View synchronization system. In first international
conference on the applications of digital information
and web technology (pp. 145-150).Ostravem.
Azaiez, N., Taktak, S., Feki, J., 2013. DWEV : Un proto-
type pour l'évolution partielle du schéma multidimen-
sionnel. In 7éme édition de la Conférence Maghrébine
sur les Avancées des systèmes décisionnels (ASD),
Marrakech, Maroc.
Bellahsene, Z., 2002. Schema Evolution in Data Ware-
houses. Journal of Knowledge and Information Sys-
tems, 4 (3) (pp. 283-304).
Body, M., Miquel M., Bédard, Y., Tchounikine, A., 2003.
Handling Evolutions in Multidimensional Structures.
In IEEE 19
th
International Conference on Data Engi-
neering (ICDE) (pp. 581-591). Bangalore, India.
Body, M., Miquel, M., Bédard, Y., Tchounikine, A., 2002.
A multidimensional and multiversion structure for
OLAP applications. In Proceedings of the 5
th
ACM In-
ternational Workshop on Data Warehousing and
OLAP (pp. 1-6). McLean, Virginia, USA.
Eder, J., Koncilia, C., 2001. Changes of Dimension Data
in Temporal Data Warehouses. In Proceedings of the
DaWaK’01 Conference, (pp. 284-293). Munich, Ger-
many.
Gupta, A., Mumick, I., Ross, K., 1995. Adapting Material-
ized Views after redefinitions. SIGMOD 95, (pp. 211-
222).
Hurtado, C. A., Mendelzon, A. O., Vaisman, A. A., 1999.
Maintaining Data Cubes under Dimension Updates. In
XVth International Conference on Data Engineering
(ICDE 1999), IEEE Computer Society, (pp.346–
355).Sydney.
Papastefanatos, G., Vassiliadis, PP., Simitsis, A., Sellis,
T., Vassiliou, Y., 2009. Rulebased Management of
Schema Changes at ETL Sources. In The International
Workshop on Managing Evolution of Data Ware-
houses (MEDWa), Riga, Latvia.
Quix, C., 2004. Repository Support for Data Warehouse
Evolution. In Proceedings of the International Work-
shop DMDW, Heidelberg, Germany.
Taktak, S., Feki, J., 2012. Toward Propagating the Evolu-
tion of Data Warehouse on Data Marts. In: MEDI
2012. Lecture Notes in Computer Science, Vol. 7602,
Springer Verlag, Berlin Heidelberg (pp. 178–185).
Poitiers, France.
Zouari, I., Ghozzi, F., Bouaziz, R., 2008. Impact de
l’évolution de nomenclature sur le versionnement des
entrepôts de données. Ingénierie des Systèmes
d'Information, volume 13, (pp. 85-114).
Oueslati, W., Akaichi, J., 2011. A Multiversion Trajectory
Data Warehouse to Handle Structure Changes, Inter-
national Journal of Database Theory and Application,
Vol. 4, No. 2. (pp. 35-50).
HowtoGuaranteeAnalysisResultsCoherenceafterDataWarehouseSchemaChangesPropagationtowardsDataMarts?
435