Querying through a user interface

James F. Terwilliger, Lois M L Delcambre, Judith (Judy) Logan

Research output: Contribution to journalArticle

13 Citations (Scopus)

Abstract

In contrast to a traditional setting where users express queries against the database schema, we assert that the semantics of data can often be understood by viewing the data in the context of the user interface (UI) of the software tool used to enter the data. That is, we believe that users will understand the data in a database by seeing the labels, drop-down menus, tool tips, or other help text that are built into the user interface. Our goal is to allow domain experts with little technical skill to understand and query data. In this paper, we present our GUi As View (Guava) framework and describe how we use forms-based UIs to generate a conceptual model that represents the information in the user interface. We then describe how we generate a query interface from the conceptual model. We characterize the resulting query language using a subset of the relational algebra. Since most application developers want to craft a physical database to meet desired performance needs, we present here a transformation channel that can be configured by instantiating one or more of our transformation operators. The channel, once configured, automatically transforms queries from our query interface into queries that address the underlying physical database and delivers query results that conform to our query interface. In this paper, we define and formalize our database transformation operators. The contributions of this paper are that first, we demonstrate the feasibility of creating a query interface based directly on the user interface and second, we introduce a general purpose database transformation channel that will likely shorten the application development process and increase the quality of the software by automatically generating software artifacts that are often made manually and are prone to errors.

Original languageEnglish (US)
Pages (from-to)748-768
Number of pages21
JournalData and Knowledge Engineering
Volume63
Issue number3
DOIs
StatePublished - Dec 2007

Fingerprint

User interfaces
Query languages
Set theory
Algebra
Interfaces (computer)
Query
User interface
Labels
Semantics
Data base

Keywords

  • Query interface
  • Schematic heterogeneity
  • User interface
  • View updates

ASJC Scopus subject areas

  • Artificial Intelligence

Cite this

Querying through a user interface. / Terwilliger, James F.; Delcambre, Lois M L; Logan, Judith (Judy).

In: Data and Knowledge Engineering, Vol. 63, No. 3, 12.2007, p. 748-768.

Research output: Contribution to journalArticle

Terwilliger, James F. ; Delcambre, Lois M L ; Logan, Judith (Judy). / Querying through a user interface. In: Data and Knowledge Engineering. 2007 ; Vol. 63, No. 3. pp. 748-768.
@article{a85d470b07c1458b8d020bf5b74e50d3,
title = "Querying through a user interface",
abstract = "In contrast to a traditional setting where users express queries against the database schema, we assert that the semantics of data can often be understood by viewing the data in the context of the user interface (UI) of the software tool used to enter the data. That is, we believe that users will understand the data in a database by seeing the labels, drop-down menus, tool tips, or other help text that are built into the user interface. Our goal is to allow domain experts with little technical skill to understand and query data. In this paper, we present our GUi As View (Guava) framework and describe how we use forms-based UIs to generate a conceptual model that represents the information in the user interface. We then describe how we generate a query interface from the conceptual model. We characterize the resulting query language using a subset of the relational algebra. Since most application developers want to craft a physical database to meet desired performance needs, we present here a transformation channel that can be configured by instantiating one or more of our transformation operators. The channel, once configured, automatically transforms queries from our query interface into queries that address the underlying physical database and delivers query results that conform to our query interface. In this paper, we define and formalize our database transformation operators. The contributions of this paper are that first, we demonstrate the feasibility of creating a query interface based directly on the user interface and second, we introduce a general purpose database transformation channel that will likely shorten the application development process and increase the quality of the software by automatically generating software artifacts that are often made manually and are prone to errors.",
keywords = "Query interface, Schematic heterogeneity, User interface, View updates",
author = "Terwilliger, {James F.} and Delcambre, {Lois M L} and Logan, {Judith (Judy)}",
year = "2007",
month = "12",
doi = "10.1016/j.datak.2007.04.007",
language = "English (US)",
volume = "63",
pages = "748--768",
journal = "Data and Knowledge Engineering",
issn = "0169-023X",
publisher = "Elsevier",
number = "3",

}

TY - JOUR

T1 - Querying through a user interface

AU - Terwilliger, James F.

AU - Delcambre, Lois M L

AU - Logan, Judith (Judy)

PY - 2007/12

Y1 - 2007/12

N2 - In contrast to a traditional setting where users express queries against the database schema, we assert that the semantics of data can often be understood by viewing the data in the context of the user interface (UI) of the software tool used to enter the data. That is, we believe that users will understand the data in a database by seeing the labels, drop-down menus, tool tips, or other help text that are built into the user interface. Our goal is to allow domain experts with little technical skill to understand and query data. In this paper, we present our GUi As View (Guava) framework and describe how we use forms-based UIs to generate a conceptual model that represents the information in the user interface. We then describe how we generate a query interface from the conceptual model. We characterize the resulting query language using a subset of the relational algebra. Since most application developers want to craft a physical database to meet desired performance needs, we present here a transformation channel that can be configured by instantiating one or more of our transformation operators. The channel, once configured, automatically transforms queries from our query interface into queries that address the underlying physical database and delivers query results that conform to our query interface. In this paper, we define and formalize our database transformation operators. The contributions of this paper are that first, we demonstrate the feasibility of creating a query interface based directly on the user interface and second, we introduce a general purpose database transformation channel that will likely shorten the application development process and increase the quality of the software by automatically generating software artifacts that are often made manually and are prone to errors.

AB - In contrast to a traditional setting where users express queries against the database schema, we assert that the semantics of data can often be understood by viewing the data in the context of the user interface (UI) of the software tool used to enter the data. That is, we believe that users will understand the data in a database by seeing the labels, drop-down menus, tool tips, or other help text that are built into the user interface. Our goal is to allow domain experts with little technical skill to understand and query data. In this paper, we present our GUi As View (Guava) framework and describe how we use forms-based UIs to generate a conceptual model that represents the information in the user interface. We then describe how we generate a query interface from the conceptual model. We characterize the resulting query language using a subset of the relational algebra. Since most application developers want to craft a physical database to meet desired performance needs, we present here a transformation channel that can be configured by instantiating one or more of our transformation operators. The channel, once configured, automatically transforms queries from our query interface into queries that address the underlying physical database and delivers query results that conform to our query interface. In this paper, we define and formalize our database transformation operators. The contributions of this paper are that first, we demonstrate the feasibility of creating a query interface based directly on the user interface and second, we introduce a general purpose database transformation channel that will likely shorten the application development process and increase the quality of the software by automatically generating software artifacts that are often made manually and are prone to errors.

KW - Query interface

KW - Schematic heterogeneity

KW - User interface

KW - View updates

UR - http://www.scopus.com/inward/record.url?scp=34548676382&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=34548676382&partnerID=8YFLogxK

U2 - 10.1016/j.datak.2007.04.007

DO - 10.1016/j.datak.2007.04.007

M3 - Article

AN - SCOPUS:34548676382

VL - 63

SP - 748

EP - 768

JO - Data and Knowledge Engineering

JF - Data and Knowledge Engineering

SN - 0169-023X

IS - 3

ER -