Ranked Based Dynamic Query Forms for Database Queries

Authors

  • Gajanan Patle  PG Scholar, Department of Computer Science & Engineering, Abha-Gaikwad Patil College of Engineering, Nagpur, Maharashtra, India
  • Rohini Uikey  Assistant Professor, Department of Computer Science & Engineering, Abha-Gaikwad Patil College of Engineering, Nagpur, Maharashtra, India
  • Ektaa Meshram  PG Scholar, Department of Computer Science & Engineering, Abha-Gaikwad Patil College of Engineering, Nagpur, Maharashtra, India

Keywords:

Query Form, User Interaction, Query Form Generation, Ranking Models, Key Database

Abstract

Query anatomy is one of the lots of broadly acclimated user interfaces for querying databases. Traditional concern forms are advised and pre-defined by developers or DBA in assorted advice administration systems. By this accelerated development of web advice and accurate databases, avant-garde databases become actual ample and complex. Therefore, it is difficult to architecture a set of changeless concern forms to amuse assorted ad-hoc database queries on those circuitous databases. So we propose DQF with Keyword Search, an atypical database concern anatomy interface that is able to dynamically accomplish concern forms. Importance of DQF is to abduction a user’s alternative and rank concern anatomy components, gives advice for him/her to accomplish decisions. This bearing of a concern anatomy is an accepted action and is guided by the user. For every iteration, this arrangement automatically generates baronial lists of anatomy apparatus and the user again adds the adapted anatomy apparatus into the concern form. Baronial of anatomy apparatus is based on the captured user preference.

References

  1. Sphurti Koshti, Dr. A.K.Sen,Dr.Vaishali Jadhav, "Dynamic Query Forms (DQF) Using Ranking Models for Database Queries", IEEE International Conference on Intelligent Sustainable Systems (ICISS 2017).
  2. M. Jayapandian and H. V. Jagadish. Automated creation of a forms-based databasequery interface. In Proceedings of the VLDB Endowment, pages 695ˆa709, August 2008.
  3. M. Jayapandian and H. V. Jagadish. Automating the design and construction of query forms. IEEE TKDE, 21(10):1389ˆa 1402, 2009.
  4. A. Nandi and H. V. Jagadish. Assisted querying using instantresponse interfaces. In Proceedings of ACM SIGMOD, pages 1156ˆa1158, 2007.
  5. N. Khoussainova, Y. Kwon, M. Balazinska, and D. Suciu. Snipsuggest: Contextaware auto completion for sql. PVLDB, 4(1):22ˆa33, 2010.
  6. W. B. Frakes and R. A. Baeza-Yates. Information Retrieval: Data Structures and Algorithms. Prentice-Hall, 1992.
  7. S. B. Roy, H. Wang, U. Nambiar, G. Das, and M. K. Mohania. Dynacet: Building dynamic faceted search systems over databases. In Proceedings of ICDE, pages 1463ˆa1466, Shanghai, China, March 2009.
  8. C. Li, N. Yan, S. B. Roy, L. Lisham, and G. Das. Facetedpedia: dynamic generation of query-dependent faceted interfaces for wikipedia. In Proceedings of WWW, pages 651ˆa660, Raleigh, North Carolina, USA, April 2010.
  9. N. Khoussainova, M. Balazinska, W. Gatterbauer, Y. Kwon, and D. Suciu. A case for a collaborative query management system. In Proceedings of CIDR, Asilomar, CA, USA, January 2009.
  10. G. Chatzopoulou, M. Eirinaki, and N. Polyzotis. Query recommendations for interactive database exploration. In Proceedings of SSDBM, pages 3ˆa18, New Orleans, LA, USA, June 2009.
  11. K. Chen, H. Chen, N. Conway, J. M. Hellerstein, and T. S. Parikh. Usher: Improving data quality with dynamic forms. In Proceedings of ICDE conference, pages 321ˆa332, Long Beach, California, USA, March 2010.
  12. S. Zhu, T. Li, Z. Chen, D.Wang, and Y. Gong. Dynamic active probing of helpdesk databases. Proc. VLDB Endow., 1(1):748ˆa760, Aug. 2008.

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2019-04-30

Issue

Volume 5, Issue 2, March-April-2019

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
Gajanan Patle, Rohini Uikey, Ektaa Meshram, " Ranked Based Dynamic Query Forms for Database Queries, IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 5, Issue 2, pp.1209-1212, March-April-2019.