Chee Yong CHAN
Query Reverse Engineering
To improve database usability by helping users construct queries and understand their outcome.
We have met the objectives of this project through the development of Query by Output (QBO), an approach to reverse engineer queries given an input pair of database and query output. QBO has been applied to two scenarios. In the first scenario, QBO is used to help users better understand their query results by augmenting the result of a query with instance-equivalent queries that describe alternative characterisations of their query results that may provide additional insightful information about the result. In the second scenario, QBO is used to generate explanations for unexpected query results that have missing expected result tuples; such an explanation is be very useful to help users understand their query results.