Query from examples: An iterative, data-driven approach to query construction
In this paper, we propose a new approach, called Query from Examples (QFE), to help non-
expert database users construct SQL queries. Our approach, which is designed for users …
expert database users construct SQL queries. Our approach, which is designed for users …
A collaborative filtering approach for recommending OLAP sessions
While OLAP has a key role in supporting effective exploration of multidimensional cubes, the
huge number of aggregations and selections that can be operated on data may make the …
huge number of aggregations and selections that can be operated on data may make the …
Querie: Collaborative database exploration
M Eirinaki, S Abraham, N Polyzotis… - IEEE Transactions on …, 2013 - ieeexplore.ieee.org
Interactive database exploration is a key task in information mining. However, users who
lack SQL expertise or familiarity with the database schema face great difficulties in …
lack SQL expertise or familiarity with the database schema face great difficulties in …
Similarity metrics for SQL query clustering
Database access logs are the starting point for many forms of database administration, from
database performance tuning, to security auditing, to benchmark design, and many more …
database performance tuning, to security auditing, to benchmark design, and many more …
Ontology-based structured web data warehouses for sustainable interoperability: requirement modeling, design methodology and tool
K Selma, B Ilyès, B Ladjel, S Eric, J Stéphane… - Computers in …, 2012 - Elsevier
The spectacular growth of the Internet and its widespread adoption by worldwide
corporations lead to an enormous quantity of heterogeneous, distributed and autonomous …
corporations lead to an enormous quantity of heterogeneous, distributed and autonomous …
Beyond roll-up's and drill-down's: An intentional analytics model to reinvent OLAP
This paper structures a novel vision for OLAPby fundamentally redefining several of the
pillars on which OLAP has been based for the last 20 years. We redefine OLAP queries, in …
pillars on which OLAP has been based for the last 20 years. We redefine OLAP queries, in …
YmalDB: exploring relational databases via result-driven recommendations
The typical user interaction with a database system is through queries. However, many times
users do not have a clear understanding of their information needs or the exact content of …
users do not have a clear understanding of their information needs or the exact content of …
Multi-dimensional query expansion employing semantics and usage statistics
R Thollot, N Kuchmann-Beauger… - US Patent 8,762,324, 2014 - Google Patents
Embodiments relate to systems and methods employing personalized query expansion to
suggest measures and dimensions allowing iterative building of consistent queries over a …
suggest measures and dimensions allowing iterative building of consistent queries over a …
SQL QueRIE recommendations
J Akbarnejad, G Chatzopoulou, M Eirinaki… - Proceedings of the …, 2010 - dl.acm.org
This demonstration presents QueRIE, a recommender system that supports interactive
database exploration. This system aims at assisting non-expert users of scientific databases …
database exploration. This system aims at assisting non-expert users of scientific databases …
[HTML][HTML] OLAP Patterns: A pattern-based approach to multidimensional data analysis
Users of a business intelligence (BI) system employ an approach referred to as online
analytical processing (OLAP) to view multidimensional data from different perspectives …
analytical processing (OLAP) to view multidimensional data from different perspectives …