Comparison of Static and Dynamic Query Form for Database Queries

Shinde M., Patil B.
2016 International Journal of Computer Applications  
Implementing static query form based on user's requirement is very difficult task. Because these static queries are predefined and shows only constant results so user cannot get satisfactory result. Here, static versus dynamic query forms are compared where static query form is constant and dynamic query form is changed according to the user need. Searching and retrieving database from the heterogeneous data is very critical task. The traditional databases do not satisfy the user desired
more » ... user desired instances. These databases contain constant fields and may not change according to the user's requirement. To get the user satisfactory result, dynamic database proposed which create dynamic query forms. In dynamic database generating fields are specified by the user which is iterative process, at every iteration system generates ranked list for the fields and then user automatically add these fields to the query form. The ranking of fields is based on user's preference. To view the result user fills out the query forms at each iteration and submit the results.
doi:10.5120/ijca2016910779 fatcat:t6mgiy7xbncbdls3kqo3ymh53i