1. Exploring databases via reverse engineering ranking queries with PALEO
- Author
-
Sebastian Michel, Evica Milchevski, Kiril Panev, and Koninika Pal
- Subjects
Reverse engineering ,SQL ,Information retrieval ,Database ,Computer science ,General Engineering ,InformationSystems_DATABASEMANAGEMENT ,02 engineering and technology ,computer.software_genre ,Ranking ,020204 information systems ,0202 electrical engineering, electronic engineering, information engineering ,020201 artificial intelligence & image processing ,computer ,Categorical variable ,computer.programming_language - Abstract
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.
- Published
- 2016
- Full Text
- View/download PDF