Designing Data Warehouses for Geographic OLAP Querying by Using MDA
Data aggregation in Geographic Information Systems (GIS) is a desirable feature, spatial data are integrated in OLAP engines for this purpose. However, the development and operation of those systems is still a complex task due to methodologies followed. There are some ad hoc solutions that deal only with isolated aspects and do not provide developer and analyst with an intuitive, integrated and standard framework for designing all relevant parts. To overcome these problems, we have defined a model driven approach to accomplish Geographic Data Warehouse (GDW) development. Then, we have defined a data model required to implement and query spatial data. Its modeling is defined and implemented by using an extension of UML metamodel and it is also formalized by using OCL language. In addition, the proposal has been verified against a example scenario with sample data sets. For this purpose, we have accomplished a developing tool based on Eclipse platform and MDA standard. The great advantage of this solution is that developers can directly include spatial data at conceptual level, while decision makers can also conceptually make geographic queries without being aware of logical details.
KeywordsSpatial data warehousing GIS-OLAP MDA
Unable to display preview. Download preview PDF.
- 1.Bimonte, S., Tchounikine, A., Bertolotto, M.: Integration of geographic information into multidimensional models. In: Gervasi, O., Murgante, B., Laganà, A., Taniar, D., Mun, Y., Gavrilova, M.L. (eds.) ICCSA 2008, Part I. LNCS, vol. 5072, pp. 316–329. Springer, Heidelberg (2008)CrossRefGoogle Scholar
- 2.Bimonte, S., Tchounikine, A., Miquel, M.: Towards a spatial multidimensional model. In: DOLAP 2005: Proceedings of the 8th ACM international workshop on Data warehousing and OLAP, pp. 39–46. ACM Press, New York (2005)Google Scholar
- 3.Bimonte, S., Wehrle, P., Tchounikine, A., Miquel, M.: Gewolap: A web based spatial olap proposal. In: OTM Workshops (2), pp. 1596–1605 (2006)Google Scholar
- 5.Glorio, O., Pardillo, J., Mazón, J.-N., Trujillo, J.: Dawara: An eclipse plugin for using i* on data warehouse requirement analysis. In: IEEE International Conference on Requirements Engineering, pp. 317–318 (2008)Google Scholar
- 7.Gomez, L., Haesevoets, S., Kuijpers, B., Vaisman, A.A.: Spatial aggregation: Data model and implementation. CoRR, abs/0707.4304 (2007)Google Scholar
- 8.Kimball, R., Ross, M.: The Data Warehouse Toolkit, 2nd edn. Wiley, Chichester (2002)Google Scholar
- 13.Malinowski, E., Zimányi, E.: Implementing spatial datawarehouse hierarchies in object-relational dbmss. In: ICEIS (1), pp. 186–191 (2007)Google Scholar
- 14.Pardillo, J., Mazón, J.-N., Trujillo, J.: Bridging the semantic gap in olap models: platform-independent queries. In: DOLAP, pp. 89–96 (2008)Google Scholar
- 18.Rivest, Y.B.S., Marchand, P.: Toward better support for spatial decision making: Defining the characteristics of spatial on-line analytical processing. Geomatica 55(4), 539–555 (2001)Google Scholar