Exploring databases via reverse engineering ranking queries with PALEO
Kiril Panev, Sebastian Michel, Evica Milchevski, Koninika Pal · Proceedings of the VLDB Endowment · 2016
A novel approach to explore databases using ranked lists is demonstrated. Working with ranked lists, capturing the relative performance of entities, is a very intuitive and widely applicable concept. Users can post lists of entities for which explanatory SQL queries and full result lists are returned. By refining the input, the results, or the queries, user can interactively explore the database content. The demonstrated system is centered around our PALEO framework for reverse engineering OLAP-style database queries and novel work on mining interesting categorical attributes.