The Use of Web-based Semantic SQL Query Generator

by Hoyoung C
In this reading, the author talks about a way to make the SQL statement generation easier. The client-server communication is established through the hypertext transfer protocol. But the architecture of the hypertext transfer protocol makes the client-server communication costly because it a new database connection is required every time the user tries to access the database. The way that the database is accessed is through the application submitting a SQL request to the server. The application usually has to submit several requests to the server in order to help the user create the query. By reducing the data between the server and the clients, the client response time for the queries gets faster. The author sets a model with an algorithm to retrieve the database schema efficiently. The SQL queries are created with a tree-like structure and they are submitted to the SQL server only when they are complete and validated. With this model, the SQL statement generation would be simpler and more efficient.

I feel that this article is related to the class because it talks about ways to make the SQL statement generation easier and efficient. The author says that with this method, it reduces the amount of data that would be typically submitted to the server and it enhances the client response time. I thought that this was an interesting read because I did not know anything about how it works between the clients and the server, and the author explained what goes on between the server and clients.

Rishe, N.; Naboulsi, K.; Wolfson, O.; Ehlmann, B.; , “An efficient Web-based semantic SQL query generator,” Electronic Commerce and Web-based Applications/Middleware, 1999. Proceedings. 19th IEEE International Conference on Distributed Computing Systems Workshops on , vol., no., pp.23-30, 1999
doi: 10.1109/ECMDD.1999.776410

(11th blog post)