Making database systems usable

Jagadish, H. V.; Chapman, Adriane; Elkiss, Aaron; Jayapandian, Magesh; Li, Yunyao; Nandi, Arnab; Yu, Cong

doi:10.1145/1247480.1247483

Cited by 205 publications

(148 citation statements)

References 82 publications

Supporting

Mentioning

147

Contrasting

Unclassified

Order By: Relevance

“…These also suffer from problems of linguistic variability and ambiguities. Similarly, the search engine can be used on the top of database approach, but these suffer from the lack of returning precise and accurate answers [19]. Thus, these approaches provide inadequate support to express a query.…”

Section: Related Work and Discussionmentioning

confidence: 99%

AQBE — QBE Style Queries for Archetyped Data

Sachdeva

Yaginuma

Chu

et al. 2012

IEICE Trans. Inf. & Syst.

View full text Add to dashboard Cite

SUMMARYLarge-scale adoption of electronic healthcare applications requires semantic interoperability. The new proposals propose an advanced (multi-level) DBMS architecture for repository services for health records of patients. These also require query interfaces at multiple levels and at the level of semi-skilled users. In this regard, a high-level user interface for querying the new form of standardized Electronic Health Records system has been examined in this study. It proposes a step-by-step graphical query interface to allow semi-skilled users to write queries. Its aim is to decrease user effort and communication ambiguities, and increase user friendliness.

show abstract

Section: Related Work and Discussionmentioning

confidence: 99%

AQBE — QBE Style Queries for Archetyped Data

Sachdeva

Yaginuma

Chu

et al. 2012

IEICE Trans. Inf. & Syst.

View full text Add to dashboard Cite

show abstract

“…Jagadish et al recently illustrated 5 painful issues in database usability [13]. Among them, the birthing pain is related to the difficulties of creating a database and putting information into 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

“…Similarly, schema visualization literature (see [32] for a survey) shows both (1) what parts of schemas are crucial to initial understanding and (2) what parts of schemas must then be revealed. Others have motivated that databases need to be more usable [33] in general, which shows that these types of problems are broadly felt throughout databases.…”

Section: Custom Domain-specific Solutionsmentioning

confidence: 99%

Improving the usability of standard schemas

Zhang¹,

Webster²,

Lawrence³

et al. 2011

Information Systems

View full text Add to dashboard Cite

Due to the development of XML and other data models such as OWL and RDF, sharing data is an increasingly common task since these data models allow simple syntactic translation of data between applications. However, in order for data to be shared semantically, there must be a way to ensure that concepts are the same. One approach is to employ commonly used schemas -called standard schemas -which help guarantee that syntactically identical objects have semantically similar meanings. As a result of the spread of data sharing, there has been widespread adoption of standard schemas in a broad range of disciplines and for a wide variety of applications within a very short period of time. However, standard schemas are still in their infancy and have not yet matured or been thoroughly evaluated. It is imperative that the data management research community takes a closer look at how well these standard schemas have fared in real-world applications to identify not only their advantages, but also the operational challenges that real users face.In this paper, we both examine the usability of standard schemas in a comparison that spans multiple disciplines, and describe our first step at resolving some of these issues in our Semantic Modeling System. We evaluate our Semantic Modeling System through a careful case study of the use of standard schemas in Architecture, Engineering, and Construction, which we conducted with domain experts. We discuss how our Semantic Modeling System can help the broader problem and also discuss a number of challenges that still remain.

show abstract

Making database systems usable

Cited by 205 publications

References 82 publications

AQBE — QBE Style Queries for Archetyped Data

AQBE — QBE Style Queries for Archetyped Data

Automatically Mapping and Integrating Multiple Data Entry Forms into a Database

Improving the usability of standard schemas

Contact Info

Product

Resources

About