SQL Simplified

by Andrew M
The article I read was entitled “Interactive SQL Query Suggest: Making Databases User-Friendly” by Ju Fan. This article talks about the difficulty of SQL and how it is very daunting to many people who are new to it. Many users do not use SQL because it is too hard for them to learn the language and to use the queries correctly. Ju Fan says that some of the current solutions are to use keywords to help in creating SQL queries. While this is efficient enough for new users it does not work well enough for more advanced users. The author proposes using something known as SQLSugg or SQL Suggestions. This takes the idea of using keywords and then advances it by using pre-made templates. In effect, the user types in a keyword and SQLSugg produces templates of pre-made queries which might meet the user’s needs. SQLSugg allows advanced users to use these templates and makes the creation of queries much easier.

I feel this article is very relevant to what we are learning in class. Right now we are learning how to write and create queries for SQL. This tool could come in handy when we are trying to query data in the future. The fact is that most people will not be able to retain all the syntax of creating a SQL query and SQLSugg would be a very useful tool in helping with this.

I personally liked this article very much. I found it very easy to read and it had a lot of data to back up his points. I also liked his solution to this problem. Creating templates with pre-made queries would help immensely when try to find specific data. This allows user to modify what exactly they are looking for and get the desired data.

Ju Fan; Guoliang Li; Lizhu Zhou; , “Interactive SQL query suggestion: Making databases user-friendly,” Data Engineering (ICDE), 2011 IEEE 27th International Conference on , vol., no., pp.351-362, 11-16 April 2011

URL: http://0-ieeexplore.ieee.org.opac.library.csupomona.edu/stamp/stamp.jsp?tp=&arnumber=5767843&isnumber=5767827

4 thoughts on “SQL Simplified

  • November 11, 2012 at 9:08 pm
    Permalink

    Thanks for the article. I too actually enjoyed it, however, I don’t really agree with the author’s point of view. SQL is not really that hard, especially when compared to actual programming languages. Personally, I think the syntax is very human readable and very little can be done to make it more.

  • November 11, 2012 at 9:24 pm
    Permalink

    Interesting articles. SQL can get complicated sometime when we work with multiple tables. It is a good idea to have a pre-made template for new user so that they are not frustrated to learn SQL. It would be nice if it comes as a function instead of default, so that advanced user can disable it – save some lookup time.

  • November 11, 2012 at 10:44 pm
    Permalink

    I think this article was good and I do agree with Hieu that SQL is hard but not as hard as other programming language. SQL its very readable and we can follow up what the query is easily. However, it does take time to learn how to write it efficiently and develop the skills as any other subject.

  • November 12, 2012 at 12:28 am
    Permalink

    I just came across a website that has a handful of different exercises that test your SQL ability. Some of the exercises involve finding simple but important information through the use of complex SQL Statements. I never knew that managing information could be so difficult and I agree that they should implement some tool to simplify it.

Comments are closed.