LITERATURE SURVEY- REFERENCE PAPER -3

 3).Automating the design and construction of query form,M.Jayapandian,H.V.Jagadish

               - Proposed an automatic approach.

               - Work-load driven method.

               - Applies CLUSTERING ALGORITHM on historical queries.

               - Generate query form based on representative queries.

      DISADVANTAGES

               

         - If db schema is large and complex, user queries quit diverse.

   

         - If we generate lots of query form in advance, there are still user queries

           that is not satisfied by one of the query form.

  Here develop a mechanism to overcome the challenge to limit the usefulness of form.

  

  Here introduce a form generation algorithm, generate form automatically in expected 

  query work load .

  To control a form's readability, introduce a FORM COMPLEXITY THRESHOLD.

  FCT is satisfied by splitting query cluster covered by complex form to 

  smaller cluster covered by simpler form.

  To measure how useful a form, here define expressivity.

  http://www.eecs.umich.edu/db/files/icde06form.pdf