Hello, I was just thinking of feature for phpmyadmin, Query by object interface in phpmyadmin. Phpmyadmin currently supports query by example interface, but we can also implement Query by object interface so that even non-SQL users can access the data inside the relational tables.
Thanks, Lakshit Arora
Lakshit Arora a écrit :
Hello, I was just thinking of feature for phpmyadmin, Query by object interface in phpmyadmin. Phpmyadmin currently supports query by example interface, but we can also implement Query by object interface so that even non-SQL users can access the data inside the relational tables.
Hi, please describe a "query by object"?
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) . Thanks, Lakshit Arora
Lakshit Arora a écrit :
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.
Have you tried opening a database, clicking on Query then "visual builder" ?
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@infomarc.info wrote:
Lakshit Arora a écrit :
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.
Have you tried opening a database, clicking on Query then "visual builder" ?
-- Marc Delisle http://infomarc.info | http://phpmyadmin.net
Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clk... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Le 2014-01-08 21:53, Lakshit Arora a écrit :
Sorry for late reply, I was kind of busy. Yeah I have looked at it, following is my opinion
- It considers tables as objects - true
- We can go to any granularity of objects - somewhat true
- 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).
And you think that these operations are useful for "non-SQL users" ? Maybe you could describe what is a non-SQL user.
Correct me, if I am wrong. Thanks, Lakshit Arora
On Wed, Jan 8, 2014 at 12:09 AM, Marc Delisle marc@infomarc.info wrote:
Lakshit Arora a écrit :
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.
Have you tried opening a database, clicking on Query then "visual builder" ?
-- Marc Delisle http://infomarc.info | http://phpmyadmin.net
Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clk... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.cl... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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@infomarc.info wrote:
Le 2014-01-08 21:53, Lakshit Arora a écrit :
Sorry for late reply, I was kind of busy. Yeah I have looked at it, following is my opinion
- It considers tables as objects - true
- We can go to any granularity of objects - somewhat true
- 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).
And you think that these operations are useful for "non-SQL users" ? Maybe you could describe what is a non-SQL user.
Correct me, if I am wrong. Thanks, Lakshit Arora
On Wed, Jan 8, 2014 at 12:09 AM, Marc Delisle marc@infomarc.info
wrote:
Lakshit Arora a écrit :
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.
Have you tried opening a database, clicking on Query then "visual
builder" ?
-- Marc Delisle http://infomarc.info | http://phpmyadmin.net
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into
your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clk...
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.cl...
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Marc Delisle http://infomarc.info | http://phpmyadmin.net
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.cl...
Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Lakshit Arora a écrit :
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.
(...)
Hi, did you have a look at the visual builder (available from Database Query).
-
Lakshit Arora -
Marc Delisle