SQL, Easier in the Future {Comments Off on SQL, Easier in the Future}

by Shigom H
Depending on the task, writing SQL queries can get complicated, in the article “Interactive SQL Query Suggestion: Making Databases User-Friendly”  Ju Fan proposes a neat tool for making SQL easier. By simply inserting keywords the tool will generate the corresponding SQL statements. This is similar to Microsoft excel, those who are unfamiliar with excel can type in keywords and excel will find the corresponding formula. SQLSUGG  is a program that suggest queries while the user types. Many databases already offer this type of  functionality but SQLSUGG differentiates itself by its ability to suggest advance queries. Unfortunately most database systems that offer this keyword functionality generate SQL queries from simple keywords that are only beneficial to “casual users”  but deemed useless to database administrators and SQL programmers. read more...

SQL Simplified {4}

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. read more...