A Survey on Dynamic Query Forms for Database Queries

Authors

  • Alisha Neware  BE Scholar, Department of Computer Science and Engineering, Shrimati Rajshree Mulak College of Engineering, Nagpur, Maharashtra, India
  • Aarti Shukla  BE Scholar, Department of Computer Science and Engineering, Shrimati Rajshree Mulak College of Engineering, Nagpur, Maharashtra, India
  • Prajakta Kawale  BE Scholar, Department of Computer Science and Engineering, Shrimati Rajshree Mulak College of Engineering, Nagpur, Maharashtra, India
  • Roshani Wanjari   BE Scholar, Department of Computer Science and Engineering, Shrimati Rajshree Mulak College of Engineering, Nagpur, Maharashtra, India

Keywords:

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

Abstract

With the rapid advancement of logical databases and web information databases are winding up exceptionally immense in size and complex in nature. These databases keep up huge and heterogeneous information, with an expansive number of relations and properties. So it is exceptionally hard to plan a lot of static inquiry forms to answer different specially appointed database questions on these cutting-edge databases. In this manner, there is a need of such framework which produces Query Forms dynamically as indicated by the user's need at runtime. The proposed framework Dynamic Query Form i.e. DQF framework going to give an answer by the query interface in vast and complex databases. In the proposed framework, the central idea is to catch user interests all through user interactions and to adjust the inquiry type iteratively. Each cycle comprises of 2 sorts of user interactions: Query Form Enrichment and Query Execution. In Query Form Enrichment DQF would prescribe a positioned rundown of query form segment to the user so he/she can choose wanted form segments into current query form. In Query Execution user fills current query form and submit the query, DQF going to demonstrate result and take criticism from the user on given query results. A user would have an office to fill the query form and submit questions to see the query result at every cycle. So a query form could be dynamically refined till the user fulfils with the query results.

References

  1. J. C. Kissinger, B. P. Brunk, J. Crabtree, M. J. Fraunholz, B. Gajria, A. J. Milgram, D. S. Pearson, J. Schug, A. Bahl, S. J. Diskin, H. Ginsburg, G. R. Grant, D. Gupta, P. Labo, L. Li, M. D. Mailman, S. K. McWeeney, P. Whetzel, C. J. Stoeckert, J. . D. S. Roos, “The plasmodium genome database: Designing
  2. and mining a eukaryotic genomics resource”, Nature, 2002.
  3. S. Cohen-Boulakia, O. Biton, S. Davidson, and C. Froidevaux, “Bioguidesrs: querying multiple sources with a user-centric perspective”, Bioinformatics, 2007.
  4. Liang Tang, Tao Li, Yexi Jiang, and Zhiyuan Chen, “Dynamic Query Forms for Database Queries”, IEEE Trans. on Knowledge and Data Engg. Vol:PP No:9 sept. 2014.
  5. C. Li, N. Yan, S. B. Roy, L. Lisham, and G. Das, “Facetedpedia: Dynamic generation of query-dependent faceted interfaces for wikipedia,” in Proc. WWW, Raleigh, NC, USA, Apr. 2010, pp. 651660.
  6. M. Jayapandian and H. V. Jagadish, “Automated creation of a forms-based database query interface”, In Proceedings of the VLDB Endowment, 2008.
  7. S. Agrawal, S. Chaudhuri, G. Das, and A. Gionis, “Automated ranking of database query results”, In CIDR, 2003.
  8. G. Salton and M. McGill, “Introduction to Modern Information Retrieval”, McGraw-Hill, 1984.
  9. L. Tang, T. Li, Y. Jiang, Z. Chen, “Dynamic Query Forms for Database Queries”, IEEE transactions on knowledge and data engineering, 2013.
  10. E. Chu, A. Baid, X. Chai, A. Doan, and J. F. Naughton, “Combining keyword search and forms for ad hoc querying of databases”, In Proceedings of ACM
  11. SIGMOD Conference, 2009.
  12. S. Chaudhuri, G. Das, V. Hristidis, and G. Weikum, “Probabilistic information retrieval approach for ranking of database query results”, ACM Trans. Database Syst. (TODS), 2006.
  13. B. Liu and H. V. Jagadish, “Using trees to depict a forest”, PVLDB, 2009.
  14. C. C. Aggarwal, J. Han, J. Wang, and P. S. Yu, “A framework for clustering evolving data streams”, In Proceedings of VLDB, 2003.
  15. T. Zhang, R. Ramakrishnan, and M. Livny, “Birch: An efficient data clustering method for very large databases”, In Proceedings of SIGMOD, 1996.
  16. R. Agrawal, S. Gollapudi, A. Halverson, and S. Ieong, “Diversifying search results”, In Proceedings of WSDM, 2009.
  17. D. Rafiei, K. Bharat, and A. Shukla, “Diversifying web searchresults”, In Proceedings of WWW, 2010.
  18. M. Jayapandian and H. V. Jagadish, “Automating the design and construction of query forms,” IEEE Trans. Knowl. Data Eng., vol. 21, no. 10, pp. 13891402, Oct. 2009.
  19. E. Chu, A. Baid, X. Chai, A. Doan, and J. F. Naughton, “Combining keyword search and forms for ad hoc querying of databases,” in Proc. ACM SIGMOD, Providence, RI, USA, Jun. 2009, pp. 349360.
  20. G. Chatzopoulou, M. Eirinaki, and N. Polyzotis, “Query recommendations for interactive database exploration,” in Proc. SSDBM, New Orleans, LA, USA, Jun. 2009, pp. 318.
  21. H Ma, D Zhou, C Liu, MR Lyu, I King. “Recommender Systems with Social Regularization”. Fourth ACM international conference on Web search and data mining, 2011.
  22. J. Lin, K. Sugiyama, M.-Y. Kan, and T.-S. Chua. Addressing cold-start in app recommendation: Latent user models constructed from twitter followers. In SIGIR’13, pages 283–293, 2013
  23. M. Jiang, P. Cui, R. Liu, Q. Yang, F. Wang, W. -W. Zhu and S. -Q. Yang. “Social contextual recommendation”. CIKM’12, pp. 45-54,2012
  24. S.-T. Park and W. Chu. Pairwise preference regression for cold-start recommendation. In RecSys’09, pages 21–28,2009
  25. L Sharma, A Gera “A Survey of Recommendation System: Research Challenges” International Journal of Engineering Trends and Technology, 2013
  26. R. Salakhutdinov and A. Mnih. “Probabilistic matrix factorization”. In NIPS 2008, 2008
  27. M. Jamali and M. Ester. “A matrix factorization technique with trust propagation for recommendation in social networks”. In Proc.ACM conference on Recommender systems (RecSys), 2010.
  28. H. Ma, H. Yang, M.R. Lyu, and I. King. “Sorec: Social recommendation using probabilistic matrix factorization”.CIKM’08, 2008.

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

Downloads

Published

2019-02-28

Issue

Volume 5, Issue 1, January-February-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]
Alisha Neware, Aarti Shukla, Prajakta Kawale, Roshani Wanjari , " A Survey on 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 1, pp.561-567, January-February-2019.