The week's pick
Random Articles
Reseach Article
Comparison of Static and Dynamic Query Form for Database Queries
| International Journal of Computer Applications |
| Foundation of Computer Science (FCS), NY, USA |
| Volume 145 - Number 12 |
| Year of Publication: 2016 |
| Authors: Shinde M. M., Patil B. M. |
10.5120/ijca2016910779
|
Shinde M. M., Patil B. M. . Comparison of Static and Dynamic Query Form for Database Queries. International Journal of Computer Applications. 145, 12 ( Jul 2016), 33-38. DOI=10.5120/ijca2016910779
Abstract
Implementing static query form based on user’s requirement is very difficult task. Because these static queries are predefined and shows only constant results so user cannot get satisfactory result. Here, static versus dynamic query forms are compared where static query form is constant and dynamic query form is changed according to the user need. Searching and retrieving database from the heterogeneous data is very critical task. The traditional databases do not satisfy the user desired instances. These databases contain constant fields and may not change according to the user’s requirement. To get the user satisfactory result, dynamic database proposed which create dynamic query forms. In dynamic database generating fields are specified by the user which is iterative process, at every iteration system generates ranked list for the fields and then user automatically add these fields to the query form. The ranking of fields is based on user’s preference. To view the result user fills out the query forms at each iteration and submit the results.
References
- Liang Tang, Tao Li, Yexi Jiang, and Zhiyuan Chen.” Dynamic Query Forms for Database Queries”. IEEE transactions on knowledge and data engineering vol: pp no: 99 year 2013.
- DBPedia. http://DBPedia.org
- Freebase. http://www.freebase.com.
- EasyQuery. http://devtools.korzh.com/eq/dotnet/.
- ColdFusion http://www.adobe.com/products/coldfusion/.
- A.Nandi and H.V. Jagdish. Assisted querying using instant response interfaces. In proceedings of ACMSIGMOD, pages 1156-1158, 2007.
- M. Jayapandian and H. V. Jagadish. Automated creation of a forms-based database query interface. In proceedings of the VLDB Endowment, pages 695-709, August 2008.
- M. Jayapandian and H. V. Jagadish. Expressive query specification through form customization. In proceedings of International Conference on Extending Database Technology (EDBT), pages 416-427, Nantes, France, March 2008.
- M. Jayapandian and H. V. Jagadish. Automating the design and construction of query forms. IEEE TKDE, 21(10): 1389- 1402, 2009.
- E.Chu, A. Baid, X. Chai, A. Doan and J. F. Naughton. Combining keyword search and form for ad hoc querying of databases. In proceedings of ACM SIGMOD Conference, pages 349-360, providence, Rhode Island, USA, and June 2009.
- G. Chatzopoulou, M. Eirinaki and N. Polyzotis. Query recommendations for interactive database exploration. In proceedings of SSDBM, pages 3-18, New Orleans, LA, USA, June 2009.
- S. B. Roy, H. Wang, U. Nambiar, G. Das and M. K. Mohsnia. Dynacet: Building faceted search systems over databases. In proceedings of ICDE Conference, pages 1463-1466, Shanghai, China, March 2009.
- 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-332, Long Beach, California, USA, March 2010.
Index Terms
Keywords