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) . Thanks, Lakshit Arora

Sorry for late reply, I was kind of busy. Yeah I have looked at it, following is my opinion 1) It considers tables as objects - true 2) We can go to any granularity of objects - somewhat true 3) We can do "operations" on the objects with chosen granularity - Maybe not , It supports only select operations, but, it seems to me it doesn't support operations like "union" , "intersect" , "compliment" or "relate" (maybe be any operations depending upon the objects). Correct me, if I am wrong. Thanks, Lakshit Arora On Wed, Jan 8, 2014 at 12:09 AM, Marc Delisle <marc(a)infomarc.info> wrote:

It simplifies the accessibility that's all. You dont't have to go into finer details of sql (by nonSQL, I meant those who don't know how to write complex queries, but yes they are familiar with operations). This is the reason why we have query by example, to simplify accessibility (correct me, if I am wrong). On 10 Jan 2014 04:36, "Marc Delisle" <marc(a)infomarc.info> wrote: wrote: builder" ? ------------------------------------------------------------------------------ your AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.cl… ------------------------------------------------------------------------------ http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.c… ------------------------------------------------------------------------------ http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.c…