Website/src/ideas/2014-10-20-what-is-the-diff...

1.1 KiB

title
What is the difference between two queries?

LOGOS provides a way to textually describe a query.  NLyze does something similar as part of its feedback mechanism.  NLyze presents an interesting challenge: It shows the users multiple queries (along with their English representation).  Users have to pick the one that best represents their desires.  For me, there's an interesting UI thought question here:  I don't want to have to sift through a bunch of prose to figure out whether the system is trying to figure out whether I'm referring to the "column total" or the "row total".

Is there a way to represent (in human-readable form) the difference between two queries?

Applications: Education (Teaching SQL, and other languages), Learning errors, etc...

Scope: The first steps towards this project (Literature Survey, a model for query deltas) are at least a 1+ year MS or PhD project.  A full solution would be at least one full PhD project.