[Phpmyadmin-devel] Query by object interface in phpmyadmin

Lakshit Arora lakshitarora26 at gmail.com
Tue Jan 7 19:10:41 CET 2014

> Hi,
> please describe a "query by object"?

In this approach the user communicates with the database through a
high level interface. The initial intent of the user is captured via
selection of objects (here tables) using object menu. The user
navigates to select granularity of these objects and operators (like
union,join etc) to operate between selected objects. The user's
actions are kept tracked in the query bag, visible to the users at all
stages. Finally, a SQL equivalent query is formulated and is executed
on MySQL server.
Consider calculator, you don't know how calculator works but you know
the objects (here numbers) and operators and just use them to get your
intended work done.
For more info: http://link.springer.com/content/pdf/10.1007%2F978-3-642-35542-4_4.pdf
It's just a proposal for a feature, but this feature is good for
non-SQL users (i.e users who are unfamiliar with Mysql) .
Lakshit Arora

More information about the Developers mailing list