Automated creation of a forms-based database query interface

Jayapandian, Magesh; Jagadish, H. V.

doi:10.14778/1453856.1453932

Cited by 56 publications

(42 citation statements)

References 20 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…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%

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: 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

“…We develop a solution for automatically generating databases from data-entry forms. In terms of form creation, our problem is an inverse process of that studied in [14], where query forms are automatically generated from databases. For our problem, we show that with the fully automatic solution, users do not need a clear knowledge of the final structure of a database.…”

Section: Discussionmentioning

confidence: 99%

Automatically Mapping and Integrating Multiple Data Entry Forms into a Database

An¹,

Khare²,

Song³

et al. 2011

Conceptual Modeling – ER 2011

View full text Add to dashboard Cite

Abstract. Forms are a standard way of gathering data into a database. Many applications need to support multiple users with evolving data gathering requirements. It is desirable to automatically link dynamic forms to the back-end database. We have developed the FormMapper system, a fully automatic solution that accepts user-created data entry forms, and maps and integrates them into an existing database in the same domain. The solution comprises of two components: tree extraction and form integration. The tree extraction component leverages a probabilistic process, Hidden Markov Model (HMM), for automatically extracting a semantic tree structure of a form. In the form integration component, we develop a merging procedure that maps and integrates a tree into an existing database and extends the database with desired properties. We conducted experiments evaluating the performance of the system on several large databases designed from a number of complex forms. Our experimental results show that the FormMapper system is promising: It generated databases that are highly similar (87% overlapped) to those generated by the human experts, given the same set of forms.

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%

“…They provide visual interfaces for developers to create or customize query forms. The problem of those tools is that, they are provided for the professional developers who are familiar with their databases, not for end-users [11]. [12] Proposed a system which allows end-users to customize the existing query form at run time.…”

Section: Related Workmentioning

confidence: 99%

See 1 more Smart Citation

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

Automated creation of a forms-based database query interface

Cited by 56 publications

References 20 publications

Toward scalable keyword search over relational data

Toward scalable keyword search over relational data

Automatically Mapping and Integrating Multiple Data Entry Forms into a Database

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

Contact Info

Product

Resources

About