Automating the Design and Construction of Query Forms

Jayapandian, Magesh; Jagadish, H. V.

doi:10.1109/icde.2006.29

Cited by 25 publications

(18 citation statements)

References 23 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Unlike [5], who focus on providing complex query constructs like aggregates, group by, and so forth, we are focused only on answering those queries that KWS can answer. Jayapandian et al [13,14] described an approach that automatically generates forms for a database based on a sample query workload. Since their goal is to create a small set of forms, they do not consider the problem of choosing from a set of forms.…”

Section: Related Workmentioning

confidence: 99%

“…To copy otherwise, to republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Articles from this volume were presented at The 36th International Conference on Very Large Data Bases, September [13][14][15][16][17]2010, Singapore. ever, in our own effort, we have been struck by how quickly we were hit with the first roadblock: current KWS solutions have unpredictable performance issues.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Toward scalable keyword search over relational data

Baid

Rae

et al. 2010

Proc. VLDB Endow.

View full text Add to dashboard Cite

Keyword search (KWS) over relational databases has recently received significant attention. Many solutions and many prototypes have been developed. This task requires addressing many issues, including robustness, accuracy, reliability, and privacy. An emerging issue, however, appears to be performance related: current KWS systems have unpredictable running times. In particular, for certain queries it takes too long to produce answers, and for others the system may even fail to return (e.g., after exhausting memory). In this paper we argue that as today's users have been "spoiled" by the performance of Internet search engines, KWS systems should return whatever answers they can produce quickly and then provide users with options for exploring any portion of the answer space not covered by these answers. Our basic idea is to produce answers that can be generated quickly as in today's KWS systems, then to show users query forms that characterize the unexplored portion of the answer space. Combining KWS systems with forms allows us to bypass the performance problems inherent to KWS without compromising query coverage. We provide a proof of concept for this proposed approach, and discuss the challenges encountered in building this hybrid system. Finally, we present experiments over real-world datasets to demonstrate the feasibility of the proposed solution.

show abstract

Section: Related Workmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Toward scalable keyword search over relational data

Baid

Rae

et al. 2010

Proc. VLDB Endow.

View full text Add to dashboard Cite

show abstract

“…In [12] proposed a system which allows end-users to customize the existing query form at run time. Recently, [11], [5] proposed automatic approaches to generate the database query forms without user participation. In [3], [15], novel user interfaces have been developed to assist the user to type the database queries based on the query workload.…”

Section: Related Workmentioning

confidence: 99%

Creation of Dynamic Query Forms and Ranking of its Components based on User's Preference

adhakrishnan¹

2015

IJIRCCE

View full text Add to dashboard Cite

At present real world databases maintain large and heterogeneous data which contain thousands of attributes and relations. Accessing the information from this corpulent database is a nontrivial task. The current system uses a static approach to query these databases.These static query forms are created manually and can express only a very limited set of queries. It is very difficult to create and design a set of static question forms to answer various adhoc database queries on the modern complex databases. So there is need of such a system that dynamically generates a Query Forms according to the user's desire at run time. In this paper, we propose a mechanism to let a user modify the generated query form to express the interested query. The main idea is to get user preferences through user interactions. DQF aims to select appropriate query components. The system also adapts a question type iteratively. At each iteration DQF provides a ranked list of query form component to user. A user can fill the query form by selecting the desired form components and can submit it to view the query result.. User checks the result and if satisfied with the result then the system will give ranking of the query by providing some suggestions. The user can click the suggestion and obtains a ranked list of the components. For finding the goodness of the query form components, some probabilistic measures are used.

show abstract

“…User clicks on his interested cluster to view the detailed data instances. Jayapandian and Jagadish [9], proposed form-based query interface. When user fills relevant information and obtains desired result by submitting the form.…”

Section: Related Workmentioning

confidence: 99%

Comparison of Static and Dynamic Query Form for Database Queries

Shinde¹,

Patil²

2016

IJCA

View full text Add to dashboard Cite

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.

show abstract

Automating the Design and Construction of Query Forms

Abstract: One of the simplest ways to query a database is through a form, where a user can fill in relevant information

Cited by 25 publications

References 23 publications

Toward scalable keyword search over relational data

Toward scalable keyword search over relational data

Creation of Dynamic Query Forms and Ranking of its Components based on User's Preference

Comparison of Static and Dynamic Query Form for Database Queries

Contact Info

Product

Resources

About