Comparison between form based and syntax based query building
Many friends of mine have questions and doubts regarding the “Specialized Syntax based Query Building” system. They would, however, prefer the “Form-based Query Building”. Why do we need such a system, when the conventional system is working fine ? Why does the user have to type a “Specialized Syntax”, can’t he just use SQL ? and many more questions arise. Lets consider the following scenario :
Specialized Syntax for Quick SQL Query Building
Originally, I used to call it “Natural Language to SQL Translator”, but I guess what I intend to do at this point of time is not Natural Language, it is rather a specialized syntax, which I guess can be further extended to natural language. Let me make a thing clear, about the system :
- It is something which the user sees, and types a query in, it has nothing to do with the data-related operations in a database.
- The only time it deals with data, is when the result-set is generated and given back to the system, so that it can be post-processed into a better manner.
Hence, its sole purpose is, to help user (end-user/client/power user/reporters) query the database and to give the user a better presentation of the result-set.
Dhruv Baldawa
Mumbai, India
