Mostra el registre d'ítem simple

dc.contributor.authorRomero Moral, Óscar
dc.contributor.authorAbelló Gamazo, Alberto
dc.contributor.otherUniversitat Politècnica de Catalunya. Departament de Llenguatges i Sistemes Informàtics
dc.date.accessioned2016-04-25T14:30:52Z
dc.date.available2016-04-25T14:30:52Z
dc.date.issued2006-06
dc.identifier.citationRomero, O., Abelló, A. "On the mismatch between multidimensionality and SQL". 2006.
dc.identifier.urihttp://hdl.handle.net/2117/86161
dc.description.abstractROLAP tools are intended to ease information analysis and navigation through the whole Data Warehouse. These tools automatically generate a query according to the multidimensional operations performed by the end-user, using the relational database technology to implement multidimensionality and consequently, automatically translating multidimensional operations to SQL. In this paper, we consider this automatic translation process in detail and to do so, we present an exhaustive comparative (both theoretical and practical) between the multidimensional algebra and the relational one. Firstly, we discuss about the necessity of a multidimensional algebra with regard to the relational one and later, we thoroughly study those considerations to be made to guarantee the correctness of a cube-query (an SQL query making multidimensional sense). With this aim, we analyze the multidimensional algebra expressiveness with regard to SQL pointing out the features a query must satisfy to make multidimensional sense and we also focus on those problems that can arise in a cube-query due to SQL intrinsic restrictions. The SQL translation of an isolated operation does not represent a problem, but when mixing up the modifications brought about by a set of operations in a single cube-query, some conflicts derived from SQL could emerge depending on the operations involved. Therefore, if these problems are not detected and treated appropriately, the automatic translation can retrieve unexpected results.
dc.format.extent49 p.
dc.language.isoeng
dc.relation.ispartofseriesLSI-06-32-R
dc.subjectÀrees temàtiques de la UPC::Informàtica::Sistemes d'informació
dc.subject.otherData warehouse
dc.subject.otherMultidimensionality
dc.subject.otherOLAP
dc.titleOn the mismatch between multidimensionality and SQL
dc.typeExternal research report
dc.rights.accessOpen Access
local.identifier.drac532227
dc.description.versionPostprint (published version)
local.citation.authorRomero, O.; Abelló, A.


Fitxers d'aquest items

Thumbnail

Aquest ítem apareix a les col·leccions següents

Mostra el registre d'ítem simple