![](bg6.png)
formula, which are stored in the OLAP Server and
then visualized in the SOLAP client. These
formulas, when executed, inform user about the
quality of query results. For each Query IC type we
have defined an MDX template. The templates are
fulfilled using a Java method (UML2MDX) that
parses the XMI files associated to the Query IC.
Different visual policies are associated with different
combinations of members from these sets to be
displayed in the SOLAP client tier: green colour for
valid cells, yellow colour for aggregated cells that
include valid and invalid cells and red colour for
invalid cells. Figure 8 shows an example of OLAP
query where these visual policies are applied
according the MDX formula implementing the
Query IC of Figure 6: valid cells such as those
combining USSR with dates before 1991-12-26 (e.g.
1991-12-01) are displayed with green colour; invalid
cells that involve for example USSR and dates after
1991-12-26 (e.g. 1991-12-27, 2010-1, 2010) are
displayed with red colour, other cells are displayed
with yellow colour, such as 1991-12 with USSR
because it is the aggregation of valid (e.g. 1991-12-
01 with USSR) and invalid cells (e.g. 1991-12-27
with USSR).
Figure 8: Query IC visualization of Example 4.
5 CONCLUSIONS
In this paper, we first show that the SOLAP analysis
goodness depends on 3 quality types: data,
aggregation and query qualities. Thus, we (i) extend
the concept of integrity constraints to consider all
these quality types; (ii) propose a framework based
on a UML profile and Spatial OCL to express these
SOLAP IC at the conceptual level; and (iii) show
their automated implementations in a typical
ROLAP architecture. Our current work is on
improving the UML2MDX tool by integrating
Spatial MDX expressions and defining cartographic-
related visualization policies in order to implement
spatial query IC.
As in our current automatic implementation only
considers the snowflake schema SDW
implementations, we are working on the
consideration of the star-schema implementations.
Finally, we will work on the formal validation of the
completeness of our classification, and the
expressiveness of our conceptual framework.
REFERENCES
Boulil, K., Bimonte, S., Pinet, F. (2011). Un modèle UML
et des contraintes OCL pour les entrepôts de données
spatiales : De la représentation conceptuelle à
l'implémentation. Ingénierie des Systèmes
d'Information, 16(6) 11-39
Ghozzi, F., Ravat, F., Teste, O., Zurfluh, G. (2003).
Constraints and Multidimensional Databases. In 5th
International Conference on Enterprise Information
Systems, 104-111
Glorio, O. and Trujillo, J. 2008. An MDA Approach for
the Development of Spatial Data Warehouses. In 10th
International Conference on Data Warehousing and
Knowledge Discovery, Berlin-Heidelberg: Springer,
23-32
Lenz, H.-J. and Shoshani, A. 1997. Summarizability in
OLAP and statistical data bases. In International
Conference on Scientific and Statistical Database
Management, IEEE, 132-143
Levesque, M.-A., Y. Bédard, M. Gervais, R. Devillers,
(2007). Towards managing the risks of data misuse for
spatial datacubes. In 5th International Symposium on
Spatial Data Quality, June 13-15, Enschede,
Netherlands
Malinowski, E. and Zimányi, E. (2008). Advanced Data
Warehouse Design: From Conventional to Spatial and
Temporal Applications. Berlin: Springer-Verlag.
Mazón, J.-N., J. Lechtenbörger, et al. (2009). A survey on
summarizability issues in multidimensional modeling.
Dataand Knowledge Engineering 68(12): 1452-1469.
Pinet, F., Duboisset, M. and Soulignac, V. (2007). Using
UML and OCL to maintain the consistency of spatial
data in environmental information systems.
Environmental modellingand software, 22(8) 1217-
1220
Pinet, F., Schneider, M. (2009) A Unified Object
Constraint Model for Designing and Implementing
Multidimensional Systems. Journal of Data Semantics
13, 37-71
Ribeiro, L., Goldschmidt, R., Cavalcanti, M. 2011.
Complementing Data in the ETL Process. In 13th
International Conference Data Warehousing and
Knowledge Discovery, Berlin-Heidelberg: Springer,
112-123
Salehi, M. (2009). Developing a Model and a Language to
Identify and Specify the Integrity Constraints in
Spatial Datacubes. Doctoral thesis. Faculté des études
supérieures de l’Université Laval, Canada.
ICEIS2012-14thInternationalConferenceonEnterpriseInformationSystems
104