To access the full text documents, please follow this link: http://hdl.handle.net/2117/86161

On the mismatch between multidimensionality and SQL
Romero Moral, Óscar; Abelló Gamazo, Alberto
Universitat Politècnica de Catalunya. Departament de Llenguatges i Sistemes Informàtics
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.
Àrees temàtiques de la UPC::Informàtica::Sistemes d'informació
Data warehouse
Multidimensionality
OLAP
info:eu-repo/semantics/publishedVersion
Report
         

Show full item record

Related documents

Other documents of the same author

Jovanovic, Petar; Romero Moral, Óscar; Simitsis, Alkis; Abelló Gamazo, Alberto; Candón Arenas, Héctor; Nadal Francesch, Sergi
Martín Escofet, Carme; Urpí Tubella, Antoni; Burgués Illa, Xavier; Romero Moral, Óscar; Abelló Gamazo, Alberto; Casany Guerrero, María José; Quer Bosor, Maria Carme; Rodríguez González, M. Elena
Berlanga, Rafael; Romero Moral, Óscar; Simitsis, Alkis; Nebot, Victoria; Pedersen, Torben Bach; Abelló Gamazo, Alberto; Aramburu, María José
Abelló Gamazo, Alberto; Romero Moral, Óscar; Jovanovic, Petar; Nadal Francesch, Sergi; Bilalli, Besim; Candón Arenas, Héctor; Mayorova, Daria; Thavornun, Varunya; Gil González, Daniel
Romero Moral, Óscar; Simitsis, Alkis; Abelló Gamazo, Alberto
 

Coordination

 

Supporters