Abstract
Traditional OLAP tools have proven to be successful in analyzing large sets of enterprise data. For today’s business dynamics, sometimes these highly curated data is not enough. External data (particularly web data), may be useful to enhance local analysis. In this paper we discuss the extraction of multidimensional data from web sources, and their representation in RDFS. We introduce Open Cubes, an RDFS vocabulary for the specification and publication of multidimensional cubes on the Semantic Web, and show how classical OLAP operations can be implemented over Open Cubes using SPARQL 1.1, without the need of mapping the multidimensional information to the local database (the usual approach to multidimensional analysis of Semantic Web data). We show that our approach is plausible for the data sizes that can usually be retrieved to enhance local data repositories.
Chapter PDF
Similar content being viewed by others
Keywords
- Resource Description Framework
- SPARQL Query
- Resource Description Framework Data
- Resource Description Framework Triple
- Open Cube
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Adida, B., Birbeck, M.: RDFa Primer, Bridging the Human and Data Webs (2008), http://www.w3.org/TR/xhtml-rdfa-primer/
Beckett, D., Berners-Lee, T.: Turtle - Terse RDF Triple Language (2011), http://www.w3.org/TeamSubmission/turtle/
Brickley, D., Guha, R., McBride, B.: RDF Vocabulary Description Language 1.0: RDF Schema (2004), http://www.w3.org/TR/rdf-schema/
Cyganiak, R., Field, S., Gregory, A., Halb, W., Tennison, J.: Semantic Statistics: Bringing Together SDMX and SCOVO. In: Proc. of the WWW2010 Workshop on Linked Data on the Web, pp. 2–6. CEUR-WS.org (2010)
Harris, S., Seaborne, A.: SPARQL 1.1 Query Language (2010), http://www.w3.org/TR/sparql11-query/
Hurtado, C.A., Mendelzon, A.O., Vaisman, A.A.: Maintaining Data Cubes under Dimension Updates. In: Proc. of the 15th International Conference on Data Engineering, ICDE 1999, pp. 346–355. IEEE Computer Society, Washington, DC (1999)
Hurtado, C.A., Gutiérrez, C., Mendelzon, A.O.: Capturing summarizability with integrity constraints in OLAP. ACM Transactions on Database Systems 30(3), 854–886 (2005)
Kämpgen, B., Harth, A.: Transforming statistical linked data for use in OLAP systems. In: Proc. of the 7th International Conference on Semantic Systems, I-Semantics 2011, New York, NY, USA, pp. 33–40 (2011)
Kimball, R.: The Data Warehouse Toolkit. J. Wiley and Sons (1996)
Klyne, G., Carroll, J.J., McBride, B.: Resource Description Framework (RDF): Concepts and Abstract Syntax (2004), http://www.w3.org/TR/rdf-concepts/
Löser, A., Hueske, F., Markl, V.: Situational Business Intelligence. In: Castellanos, M., Dayal, U., Sellis, T. (eds.) BIRTE 2008. LNBIP, vol. 27, pp. 1–11. Springer, Heidelberg (2009)
Löser, A., Nagel, C., Pieper, S.: Augmenting Tables by Self-supervised Web Search. In: Löser, A. (ed.) BIRTE 2010. LNBIP, vol. 84, pp. 84–99. Springer, Heidelberg (2011)
Nebot, V., Llavori, R.B.: Building data warehouses with semantic data. In: EDBT/ICDT Workshops. ACM International Conference Proceeding Series. ACM (2010)
Niemi, T., Niinimäki, M.: Ontologies and summarizability in OLAP. In: Proc. of the 2010 ACM Symposium on Applied Computing, SAC 2010, pp. 1349–1353. ACM, New York (2010)
Niinimäki, M., Niemi, T.: An ETL Process for OLAP Using RDF/OWL Ontologies. In: Spaccapietra, S., Zimányi, E., Song, I.-Y. (eds.) Journal on Data Semantics XIII. LNCS, vol. 5530, pp. 97–119. Springer, Heidelberg (2009)
Prud’hommeaux, E., Seaborne, A.: SPARQL Query Language for RDF (2008), http://www.w3.org/TR/rdf-sparql-query/
Sequeda, J., Hartig, O.: Towards a query language for the web of data (a vision paper). CoRR, abs/1110.3017 (2011)
Shoshani, A.: OLAP and statistical databases: similarities and differences. In: PODS 1997, pp. 185–196. ACM, New York (1997)
Vassiliadis, P.: Modeling multidimensional databases, cubes and cube operations. In: SSDBM, pp. 53–62. IEEE Computer Society (1998)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Etcheverry, L., Vaisman, A.A. (2012). Enhancing OLAP Analysis with Web Cubes. In: Simperl, E., Cimiano, P., Polleres, A., Corcho, O., Presutti, V. (eds) The Semantic Web: Research and Applications. ESWC 2012. Lecture Notes in Computer Science, vol 7295. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-30284-8_38
Download citation
DOI: https://doi.org/10.1007/978-3-642-30284-8_38
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-30283-1
Online ISBN: 978-3-642-30284-8
eBook Packages: Computer ScienceComputer Science (R0)