DSpace DSpace UPC
  Pàgina principal | Llistar continguts | Cerca avançada | Com participar-hi Català   Castellano   English  


Títol: Multidimensional query recommendation
Autor: Varga, Jovan
Altres autors/autores: Marcel, Patrick; Abelló Gamazo, Alberto
Editorial: Universitat Politècnica de Catalunya
Matèries: Àrees temàtiques de la UPC::Informàtica::Intel·ligència artificial::Agents intel·ligents
Àrees temàtiques de la UPC::Informàtica::Programació
Decision support systems
Multidimensional algebraic characterization
SQL
Sistemes d'ajuda a la decisió
Tipus de document: Master thesis
Descripció: In this master thesis we will first summarize the recent efforts to support analytical tasks over relational sources. These efforts have pointed out the necessity to come up with flexible, powerful means for analyzing the issued queries and exploit them in decision oriented processes (such as query recommendation or similar). Issued queries should be decomposed, stored and manipulated in a dedicated subsystem. With this aim, we present a novel approach for representing SQL analytical queries in terms of a multidimensional algebra, which better characterizes the analytical efforts of the user. This thesis discusses how a SQL query can be formulated as a multidimensional algebraic characterization. Then, we discuss how to normalize them in order to bridge (i.e. collapse) several SQL queries into a single characterization (representing the analytical session), according to their logical connections. Afterwards, we talk about how this characterization can be exploited in a wide range of decisional tasks such as query recommendation and others. Finally, we present an implementation example of this approach with limiting it with normalization phase because it surprisingly turned out that it is hard enough to achieve with regards to time available. This implementation may later be upgraded to demonstrate the full potential of this novel approach. 1.3 Scope
Altres identificadors i accés: http://hdl.handle.net/2099.1/12691
Disponible al dipòsit:Treballs acadèmics UPC
Comparteix:


SFX Query

Tots els ítems dipositats a UPCommons estan protegits per drets d'autor.

 

Valid XHTML 1.0! Programari DSpace Copyright © 2002-2004 MIT and Hewlett-Packard Comentaris
Universitat Politècnica de Catalunya. Servei de Biblioteques, Publicacions i Arxius