Open Access Open Access  Restricted Access Subscription or Fee Access

Construction of Customized Query Forms for Efficient Retrieval from Database

K. Veningston, Deepa Kanmani, T.M. Nitha

Abstract


Using form based interface, user can easily extract data from database without the knowledge of the formal query language and the underlying database schema. Form should be simple and easy to understand and it should support as many queries as possible. In this paper a framework is studied for generating the forms automatically according to the user needs. This automated technique does not require interface developers or end users to manually build forms. This paper also provides a mechanism for extending the forms to support future similar queries for which the clustering approach identified. It is to adjust forms to reflect the most current querying needs without creating new query form.

Keywords


Query Form, Database Schema, Query Language, Clustering, Query Evaluation.

Full Text:

PDF

References


Z. Qin, B.B. Yao, Y. Liu, and M. McCool, “A Graphical XQuery Language Using Nested Windows,” Proc. Int’l Conf. Web Information Systems Eng. (WISE) Conf., 2004.

E. Augurusa, D. Braga, A. Campi, and S. Ceri, “Design and Implementation of a Graphical Interface to XQuery,” Proc. 2003 ACM Symp. Applied Computing, 2003.

Y. Papakonstantinou, M. Petropoulos, and V. Vassalos, “QURSED: Querying and Reporting Semistructured Data,” Proc. ACM SIGMOD Int’l Conf. Management of Data (SIGMOD), 2002.

R. Abraham, “FoxQ-XQuery by Forms,” Proc. 2003 IEEE Symp. Human Centric Computing Languages and Environments, 2003.

M. Jayapandian and H.V. Jagadish, “Expressive Query Specification through Form Customization,” Proc. Int’l Conf. Extending Database Technology (EDBT), 2008.

Daniele Braga, alessandro Campi, Stefano Ceri, “ XQBE (XQuery By Example): A Visual Interface to the Standard XML Query Language”, ACM Transactions on Database Systems, Vol. 30, No. 2, June 2005.

W. Ni and T.W. Ling, “GLASS: A Graphical Query Language for Semi-Structured Data,” Proc. Int’l Conf. Database Systems for Advanced Applications (DASFAA), 2003.

S. Paparizos, Y. Wu, L.V.S. Lakshmanan, and H.V. Jagadish, “Tree Logical Classes for Efficient Evaluation of XQuery,” Proc. ACM SIGMOD Int’l Conf. Management of Data (SIGMOD), 2004.

J. Choobineh, M.V. Mannino, and V.P. Tseng, “A Form-Based Approach for Database Analysis and Design,” Comm. ACM, vol. 35, no. 2, pp. 108-120, 1992.

M. Petropoulos, A. Deutsch, and Y. Papakonstantinou, “Query Set Specification Language,” Proc. Int’l Workshop Web and Databases (WebDB), 2003.

Magesh Jayapandian and H.V. Jagadish, “Automating the Design and Construction of Query Forms,” IEEE Transaction Knowledge and Data Engineering,vol.21 NO.10, October 2009.

A.R. Schmidt, F. Waas, M.L. Kersten, D. Florescu, I. Manolescu, M.J. Carey, and R. Busse, “The XML Benchmark Project,” Techn ical Report INS-R0103, CWI, 2001.

M. Erwig, “A Visual Language for XML,” Proc. IEEE Symp. Visual Languages, 2000.


Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.