International Journal of Computer Applications (0975 – 8887) Volume 145 – No.12, July 2016 33 Comparison of Static and Dynamic Query Form for Database Queries Shinde M. M. PG Student MBESociety’s of college of engineering, Ambajogai Maharashtra, India Patil B. M. Professor MBESociety’s of college of engineering, Ambajogai Maharashtra, India ABSTRACT 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 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. Keywords DQF (Dynamic Query Form), CQF (Customized Query Form), SQF (Static Query Form). 1. INTRODUCTION The Traditional database is a static and designed by professionals to maintain information [1].Now a day’s DBPedia[2],Freebase [3]web databases become very complex which contains many relations and attribute and they may confuse to the user. Those complex databases are created to handle database with large size. It is very tedious task to design bunch of static query form to satisfy various database queries on those complicated databases. There are number of existing database development tools, such as Easy Query [4], Cold Fusion [5], SAP and Microsoft Access provide several ways to the users to create customized queries on that databases. If a user does not have knowledge of SQL database then thousands of records and attributes may confuse to user. Dynamic Query Form system which is query interface able to generate dynamically query forms for the user. The user will interact to the system iteratively until his/her satisfaction. Each iteration of user interaction has two types.  Query Form Enrichment: DQF (Dynamic Query Form) generates query form according to the user. Every iteration DQF generates ranking list of form so user can select the form according to his/her need.  Query Execution: The user fills and submits the query form then this dynamic query form executes the query and display the results.DQF shows the result and user gives the feedback about that query result. The major goal of the DQF is to work with large databases and user can get many results by executing one query even if the user is not familiar with the query syntax or SQL structure. It make user easy to access or modify data. In this paper dynamic query form generates the query form according to the user’s desire. Static query form generates the query form for only simple queries where as dynamic query form generates query form for more complex databases. At every execution time the user gets different updated results, where static query does not updated because these queries are constant. The remaining paper is organized as follows Section 2 describes the related work. Section 3 gives the system overview. Section 4 describes the algorithm. Section 5 gives the purpose of ranking metric. Section 6 describes the experimental results, and finally Section 7 ends with the concludes the paper. 2. RELATED WORK Nandi and Jagdish [6], Based on query workload a visual interface developed to guide the user to type the queries. This auto completion approach proposed for database queries. Jayapandian[7],proposed customize queries on database.Todays many development tools like SAP,Easy Query, Cold Fusion provide let user develop customized queries. The problem is that, customized queries based on user’s manual editing, if there are thousands of relations and attribute of data then it would may confuse the user, if they are not familiar with database. Another one problem is that, if database is complex and huge, it is hard for user to find specific database attribute. Jagdish [8], proposed workload driven method. To find the representative queries clustering algorithm applied on historical queries. Clustering is used to show high level view of the query result, because it outputs only compressed result table. User clicks on his interested cluster to view the detailed data instances. Jayapandian and Jagadish [9], proposed form-based query interface. When user fills relevant information and obtains desired result by submitting the form. They present framework for generating forms in an automatic way. Chu, et al. [10], proposed, to find relevant query user can input combination of many keywords. In advance, system generates many query form. This system allows keyword based search, optimization, and query processing of relational database of dynamically generated query forms.