Survey Paper on Creation of Dynamic Query Form for Mining Highly Optimized Transactional Databases

In Scientific databases and web databases maintain large and heterogeneous data. The databases contain over hundreds or thousands of relations and attributes of data. Previously defined old query forms are not able to satisfy various ad-hoc queries from users on those databases. Dynamic query form, a new approach for generating database query form interface is used to dynamically generate query forms. The use of DQF is to capture a user's interests, preferences and rank query form components, assisting user to make decisions without actually typing queries. The dynamic query form is an iterative process and is guided by the user. The system automatically generates dynamic ranking lists of form components and the user then adds the desired form components into the query form. Ranking of form components can be done based on the captured user interests. User can also modify previously generated query forms and by fill the query form and submit queries to see the query result. A query form could be dynamically refined until the user satisfies with the query results.