Mostra el registre d'ítem simple
On the mismatch between multidimensionality and SQL
dc.contributor.author | Romero Moral, Óscar |
dc.contributor.author | Abelló Gamazo, Alberto |
dc.contributor.other | Universitat Politècnica de Catalunya. Departament de Llenguatges i Sistemes Informàtics |
dc.date.accessioned | 2016-04-25T14:30:52Z |
dc.date.available | 2016-04-25T14:30:52Z |
dc.date.issued | 2006-06 |
dc.identifier.citation | Romero, O., Abelló, A. "On the mismatch between multidimensionality and SQL". 2006. |
dc.identifier.uri | http://hdl.handle.net/2117/86161 |
dc.description.abstract | ROLAP 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.extent | 49 p. |
dc.language.iso | eng |
dc.relation.ispartofseries | LSI-06-32-R |
dc.subject | Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació |
dc.subject.other | Data warehouse |
dc.subject.other | Multidimensionality |
dc.subject.other | OLAP |
dc.title | On the mismatch between multidimensionality and SQL |
dc.type | External research report |
dc.rights.access | Open Access |
local.identifier.drac | 532227 |
dc.description.version | Postprint (published version) |
local.citation.author | Romero, O.; Abelló, A. |
Fitxers d'aquest items
Aquest ítem apareix a les col·leccions següents
-
Reports de recerca [1.107]