The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Performing Group-By before Join
Proceedings of the Tenth International Conference on Data Engineering
Summarizability in OLAP and Statistical Data Bases
SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
An Object-Centered Multi-Dimensional Data Model With Hierarchically Structured Dimensions
KDEX '97 Proceedings of the 1997 IEEE Knowledge and Data Engineering Exchange Workshop
YAM2: a multidimensional conceptual model extending UML
Information Systems
Database Systems: The Complete Book
Database Systems: The Complete Book
Query Recommendations for Interactive Database Exploration
SSDBM 2009 Proceedings of the 21st International Conference on Scientific and Statistical Database Management
Data Warehouse Design: Modern Principles and Methodologies
Data Warehouse Design: Modern Principles and Methodologies
Recommending Multidimensional Queries
DaWaK '09 Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery
Query recommendations for OLAP discovery driven analysis
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Automatic validation of requirements to support multidimensional design
Data & Knowledge Engineering
SnipSuggest: context-aware autocompletion for SQL
Proceedings of the VLDB Endowment
Proceedings of the VLDB Endowment
On the need of a reference algebra for OLAP
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
Multi-dimensional navigation modeling using BI analysis graphs
ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
Hi-index | 0.00 |
Recent efforts to support analytical tasks over relational sources have pointed out the necessity to come up with flexible, powerful means for analyzing the issued queries and exploit them in decisionoriented processes (such as query recommendation or physical tuning). 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. In this paper we discuss how an 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.