Friendly SQL Queries

by Claudia J
The peer review article that I read was called “Interactive SQL query suggestion: Making databases user-friendly” by Ju Fan talks about how SQL is a good tool for querying relational databases. The author mentions that it is hard for beginners with a lack of programming skills to make efficient SQL queries as they require being proficient in SQL syntax and having a good understanding of the underlying schema. The author proposes a SQLSUGG which is a user-friendly keyword-based method to help people create SQL queries. This method suggests SQL queries as users type the keyboard and also helps to save what the users type to avoid them having to type everything multiple times which avoids SQL debugging in a way.

I think this article ties into the class because we have a project where we have to develop some queries for our final project. It might be a tool that we can use to write more efficient queries for projects as beginners in SQL programming. The SQLSUGG provides SQL templates that are relevant to the query keywords inputted. It is important to keep a good structure in the query because it is very essential to an SQL query because it specifies which entities are involved in the query and how they are jonined together. As we all know, the SQL syntax includes the query structure in the FROM clause and JOIN condition in the WHERE clause.

I picked this article because it talks about how we can use resources already available to improve queries as we work with SQL. It might result in something hard for us now that we are beginning to learn how to use SQL programming for databases and I believe that by checking and following already templates helps us understand better the concept. We should check how this SQLSUGG method works and see how we can fix the suggested templates to fit our needs.

Ju, Fan. (2011). Interactive SQL query suggestion: Making databases user-friendly. IEEEXLORE, PP.351-362. Retrieved November 25, 2012. http://0-ieeexplore.ieee.org.opac.library.csupomona.edu/stamp/stamp.jsp?tp=&arnumber=5767843&tag=1

 

7 thoughts on “Friendly SQL Queries”

  1. I agree with the author it is hard for beginner to write efficiency SQL because they have to actually understand the underlying scheme even with the help of the syntax and SQLSUGG because every project is different, one example can’t really help explained. The only thing I think it would help is to practice a lot.

  2. Nice article! Database management is a complicated process, SQL provides help for users; it’s responsible for querying and editing information stored in a certain database management system. SQL offers great flexibility to users by supporting distributed databases, for example, databases that can be run on several computer networks at a time. Thanks for sharing~

  3. Good read, I really liked the peer review you did. Since we started learn queries, it is hard for us to write efficient SQL queries in the beginning. The more practice, the better you get. I used to practice inner joins, outer joins by myself using this website called configure-all.com. It helped me to get used to join quries. Here is the URL for the website: http://www.configure-all.com/learn_sql.php . We should practice before we start project3!

  4. Nice article! It is true if you do not have any previous programming experience it may be confusing on how to properly structure the query. SQLSUGG can help build queries by suggesting certain things which will help you learn however to really understand the concept you should practice the queries without any help as well. This article is relevant to our last few classes as well as the project and we all need to better understand how to write queries.

  5. It certainly is nice that there are tools available for beginners. Being a beginner myself, I find that tools like this can not only make my queries better and more efficient, but helps me understand how the whole system works. But it all really comes down to one thing; practice makes perfect.

  6. SQLSUGG is a helpful took that can help beginners with lack of experience to write queries. For beginners like myself, it may be difficult to get everything right at the first try. I agree with katheryn, practice makes perfect.

  7. Thanks for the article. I learned how to use SQL in this class, and i found that its user-friendly. Especially the coding part was not that difficult and it is understandable.

Comments are closed.