Enhancing OLAP Analysis with Web Cubes

  • Lorena Etcheverry
  • Alejandro A. Vaisman
Part of the Lecture Notes in Computer Science book series (LNCS, volume 7295)

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.

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

  1. 1.
    Adida, B., Birbeck, M.: RDFa Primer, Bridging the Human and Data Webs (2008), http://www.w3.org/TR/xhtml-rdfa-primer/
  2. 2.
    Beckett, D., Berners-Lee, T.: Turtle - Terse RDF Triple Language (2011), http://www.w3.org/TeamSubmission/turtle/
  3. 3.
    Brickley, D., Guha, R., McBride, B.: RDF Vocabulary Description Language 1.0: RDF Schema (2004), http://www.w3.org/TR/rdf-schema/
  4. 4.
    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)Google Scholar
  5. 5.
    Harris, S., Seaborne, A.: SPARQL 1.1 Query Language (2010), http://www.w3.org/TR/sparql11-query/
  6. 6.
    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)Google Scholar
  7. 7.
    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)CrossRefGoogle Scholar
  8. 8.
    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)Google Scholar
  9. 9.
    Kimball, R.: The Data Warehouse Toolkit. J. Wiley and Sons (1996)Google Scholar
  10. 10.
    Klyne, G., Carroll, J.J., McBride, B.: Resource Description Framework (RDF): Concepts and Abstract Syntax (2004), http://www.w3.org/TR/rdf-concepts/
  11. 11.
    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)CrossRefGoogle Scholar
  12. 12.
    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)CrossRefGoogle Scholar
  13. 13.
    Nebot, V., Llavori, R.B.: Building data warehouses with semantic data. In: EDBT/ICDT Workshops. ACM International Conference Proceeding Series. ACM (2010)Google Scholar
  14. 14.
    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)CrossRefGoogle Scholar
  15. 15.
    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)CrossRefGoogle Scholar
  16. 16.
    Prud’hommeaux, E., Seaborne, A.: SPARQL Query Language for RDF (2008), http://www.w3.org/TR/rdf-sparql-query/
  17. 17.
    Sequeda, J., Hartig, O.: Towards a query language for the web of data (a vision paper). CoRR, abs/1110.3017 (2011)Google Scholar
  18. 18.
    Shoshani, A.: OLAP and statistical databases: similarities and differences. In: PODS 1997, pp. 185–196. ACM, New York (1997)CrossRefGoogle Scholar
  19. 19.
    Vassiliadis, P.: Modeling multidimensional databases, cubes and cube operations. In: SSDBM, pp. 53–62. IEEE Computer Society (1998)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2012

Authors and Affiliations

  • Lorena Etcheverry
    • 1
  • Alejandro A. Vaisman
    • 2
  1. 1.Instituto de ComputaciónUniversidad de la RepúblicaUruguay
  2. 2.Université Libre de BruxellesBelgium

Personalised recommendations