CREATION OF DYNAMIC QUERY FOR MINING HIGHLY OPTIMIZED TRANSACTIONAL DATABASES

In New scientific databases and web databases maintain huge and heterogeneous data. These concrete world databases include over so many relations and attributes. Historic predefined query forms are not able to answer different ad - hoc queries from users on those databases. This paper proposes Dynamic Query form, a curious database query form interface, which is able to dynamically create query forms. The significance of DQF is to capture a user's choice and classify query form components, support him/her to make conclusion. The creation of query form is a repetitive process and is conducted by the users. In each repetition, the system automatically creates classification lists of form components and the user then adds the desired form components into the query form. The classification of form components is based on the captured user choice. A user may al so fill up the query form and deliver queries to view the query output at each step. Thus, a query form could be dynamically refined till the user answer with the query output. A probabilistic model is developed for estimating the excellence of a query form in DQF. I have studied evaluation and user study certify the effectiveness and efficiency of the system.