Publishing and Querying Government Multidimensional Data Using QB4OLAP

Author

Bouza, M. ; Elliot, B. ; Etcheverry, L. ; Vaisman, Alejandro A.

Author_Institution

Inst. de Comput., UdelaR Montevideo, Montevideo, Uruguay

fYear

2014

fDate

22-24 Oct. 2014

Firstpage

82

Lastpage

90

Abstract

The web is changing the way in which data warehouses are designed, used, and queried. With the advent of initiatives such as Open Data and Open Government, organizations want to share their multidimensional data cubes and make them available to be queried online. The RDF data cube vocabulary (QB), the W3C standard to publish statistical data in RDF, presents several limitations to fully support the multidimensional model. The QB4OLAP vocabulary extends QB to overcome these limitations, and provides the distinctive feature of being able to implement several OLAP operations, such as rollup, slice, and dice using standard SPARQL queries. In this paper we present QB4OLAP Engine, a tool that transforms multidimensional data stored in relational DWs into RDF using QB4OLAP, and apply the solution to a real-world case, based on the national survey of housing, health services, and income, carried out by the government of Uruguay.

Keywords

SQL; data mining; data warehouses; government data processing; publishing; query processing; relational databases; QB4OLAP; RDF data cube vocabulary; SPARQL queries; Uruguay government; W3C standard; data warehouses; dice operation; government multidimensional data publishing; government multidimensional data querying; health services; income; national housing survey; relational DW; rollup operation; slice operation; Aggregates; Data models; Engines; Government; Resource description framework; Standards; Vocabulary; Data warehouses; Semantic Web;

fLanguage

English

Publisher

ieee

Conference_Titel

Web Congress (LA-WEB), 2014 9th Latin American

Conference_Location

Ouro Preto

Print_ISBN

978-1-4799-6952-4

Type

conf

DOI

10.1109/LAWeb.2014.11

Filename

7000175