An efficient Web-based semantic SQL query generator

摘要

The Internet can provide transparent access to distributeddatabases via users' Web browsers. The client-server communication isaccomplished using the hypertext transfer protocol (HTTP). However, thestateless architecture of the HTTP causes the client-servercommunication to be costly. Such communication requires a new databaseconnection each time the user wishes to access the database.Applications typically access databases by submitting an SQL request tothe server. Prior to submitting the actual query, the applicationtypically submits a series of requests needed to help the user formulatethe query. Reducing the amount of data between the clients and theserver during query formulation enhances client response time andoffloads SQL application server and database engine from frequentrequests. We provide a model and an algorithm to efficiently retrievedatabase schema objects and offload the SQL application server bydistributing the application processing between the client and theserver. SQL queries may be constructed using a tree-like structure andare submitted to the SQL application server only when complete andvalidated syntactically as well as semantically. The model is unique interms of simplicity and ease of SQL statement generation