Abstract
The Semantic Web (SW) has drawn the attention of data enthusiasts, and also inspired the exploitation and design of multidimensional data warehouses, in an unconventional way. Traditional data warehouses (DW) operate over static data. However multidimensional (MD) data modeling approach can be dynamically extended by defining both the schema and instances of MD data as RDF graphs. The importance and applicability of MD data warehouses over RDF is widely studied yet none of the works support a spatially enhanced MD model on the SW. Spatial support in DWs is a desirable feature for enhanced analysis, since adding encoded spatial information of the data allows to query with spatial functions. In this paper we propose to empower the spatial dimension of data warehouses by adding spatial data types and topological relationships to the existing QB4OLAP vocabulary, which already supports the representation of the constructs of the MD models in RDF. With QB4SOLAP, spatial constructs of the MD models can be also published in RDF, which allows to implement spatial and metric analysis on spatial members along with OLAP operations. In our contribution, we describe a set of spatial OLAP (SOLAP) operations, demonstrate a spatially extended metamodel as, QB4SOLAP, and apply it on a use case scenario. Finally, we show how these SOLAP queries can be expressed in SPARQL.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
- 2.
RCC8 – Region Connection Calculus describes regions in Euclidean space, or in a topological space by their possible relations to each other.
- 3.
DE-9DIM – Dimensionally Extended Nine-Intersection Model is a topological model that describes spatial relations of two geometries in two-dimensions.
- 4.
RDF Schema http://www.w3.org/TR/rdf-schema/.
- 5.
XML Schema http://www.w3.org/TR/xmlschema11-1/.
- 6.
- 7.
OGC Schemas http://schemas.opengis.net/.
- 8.
The Well Known Text (WKT) serialization aligns the geometry types with ISO 19125 Simple Features [ISO 19125-1], and the GML serialization aligns the geometry types with [ISO 19107] Spatial Schema.
- 9.
- 10.
- 11.
For our tests we used Virtuoso Universal Server and virtrdf:Geometry is a special RDF typed literal which is used for geometry objects in Virtuoso. Normally, WGS84 (EPSG:4326) is the SRID of any such geometry.
- 12.
SPARQL endpoint is available at: http://extbi.ulb.ac.be:8890/sparql.
References
Abelló, A., Romero, O., Pedersen, T.B., Berlanga Llavori, R., Nebot, V., Aramburu, M., Simitsis, A.: Using semantic web technologies for exploratory OLAP: a survey. TKDE 99, 571–588 (2014)
Andersen, A.B., Gür, N., Hose, K., Jakobsen, K.A., Pedersen, T.B.: Publishing danish agricultural government data as semantic web data. In: Supnithi, T., Yamaguchi, T., Pan, J.Z., Wuwongse, V., Buranarach, M. (eds.) JIST 2014. LNCS, vol. 8943, pp. 178–186. Springer, Heidelberg (2015)
Battle, R., Kolas, D.: GeoSPARQL: enabling a geospatial SW. Seman. Web 3(4), 355–370 (2012)
Bimonte, S., Johany, F., Lardon, S.: A first framework for mutually enhancing chorem and spatial OLAP systems. In: DATA (2015)
Ciferri, C., Gómez, L., Schneider, M., Vaisman, A.A., Zimányi, E.: Cube algebra: a generic user-centric model and query language for OLAP cubes. IJDWM 9(2), 39–65 (2013)
Cyganiak, R., Reynolds, D., Tennison, J.: The RDF Data Cube Vocabulary. W3C (2014)
Deb Nath, R.P., Hose, K., Pedersen, T.B.: Towards a programmable semantic extract-transform-load framework for semantic data warehouses. In: DOLAP (2015)
Diamantini, C., Potena, D.: Semantic enrichment of strategic datacubes. In: DOLAP (2008)
Etcheverry, L., Vaisman, A., Zimányi, E.: Modeling and querying data warehouses on the semantic web using QB4OLAP. In: Bellatreche, L., Mohania, M.K. (eds.) DaWaK 2014. LNCS, vol. 8646, pp. 45–56. Springer, Heidelberg (2014)
Gómez, L.I., Gómez, S.A., Vaisman, A.A.: A generic data model and query language for spatiotemporal OLAP cube analysis. In: EDBT (2012)
Han, J., Stefanovic, N., Koperski, K.: Selective materialization: an efficient method for spatial data cube construction. In: Wu, X., Kotagiri, R., Korb, K.B. (eds.) PAKDD 1998. LNCS, vol. 1394, pp. 144–158. Springer, Heidelberg (1998)
Kämpgen, B., O’Riain, S., Harth, A.: Interacting with statistical linked data via OLAP operations. In: Simperl, E., Norton, B., Mladenic, D., Valle, E.D., Fundulaki, I., Passant, A., Troncy, R. (eds.) ESWC 2012. LNCS, vol. 7540, pp. 87–101. Springer, Heidelberg (2012)
Koubarakis, M., Karpathiotakis, M., Kyzirakos, K., Nikolaou, C., Sioutis, M.: Data models and query languages for linked geospatial data. In: Eiter, T., Krennwallner, T. (eds.) Reasoning Web 2012. LNCS, vol. 7487, pp. 290–328. Springer, Heidelberg (2012)
Kyzirakos, K., Karpathiotakis, M., Koubarakis, M.: Strabon: a semantic geospatial DBMS. In: Cudré-Mauroux, P., et al. (eds.) ISWC 2012, Part I. LNCS, vol. 7649, pp. 295–311. Springer, Heidelberg (2012)
Le Grange, J.J., Lehmann, J., Athanasiou, S., Rojas, A.G., et al.: The GeoKnow generator: managing geospatial data in the linked data web. In: Linking Geospatial Data (2014)
Malinowski, E., Zimányi, E.: Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications. Springer, Heidelberg (2008)
Nebot, V., Berlanga, R., Pérez, J.M., Aramburu, M.J., Pedersen, T.B.: Multidimensional integrated ontologies: a framework for designing semantic data warehouses. In: Spaccapietra, S., Zimányi, E., Song, I.-Y. (eds.) Journal on Data Semantics XIII. LNCS, vol. 5530, pp. 1–36. Springer, Heidelberg (2009)
Revesz, P.: Introduction to Databases: From Biological to Spatio-Temporal. Springer, Heidelberg (2010)
Stadler, C., Lehmann, J., Hffner, K., Auer, S.: Linkedgeodata: a core for a web of spatial open data. Semant. Web 3(4), 333–354 (2012)
Vaisman, A.A., Zimányi, E.: A multidimensional model representing continuous fields in spatial data warehouses. In: ACM SIGSPATIAL (2009)
Acknowledgment
This research was partially funded by The Erasmus Mundus Joint Doctorate in “Information Technologies for Business Intelligence – Doctoral College (IT4BI-DC)”.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2016 Springer International Publishing Switzerland
About this paper
Cite this paper
Gür, N., Hose, K., Pedersen, T.B., Zimányi, E. (2016). Modeling and Querying Spatial Data Warehouses on the Semantic Web. In: Qi, G., Kozaki, K., Pan, J., Yu, S. (eds) Semantic Technology. JIST 2015. Lecture Notes in Computer Science(), vol 9544. Springer, Cham. https://doi.org/10.1007/978-3-319-31676-5_1
Download citation
DOI: https://doi.org/10.1007/978-3-319-31676-5_1
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-31675-8
Online ISBN: 978-3-319-31676-5
eBook Packages: Computer ScienceComputer Science (R0)