The Utility of the Abstract Relational Model and Attribute Paths in SQL

It is well-known that querying information is difficult for domain experts, for they are not familiar with querying actual relational schemata due to the notions of primary and foreign keys and the various ways of representing and storing information in a relational database. To overcome these problems, the Abstract Relational Model and the query language, SQLP, have been proposed. They are the theoretical foundations and ensure that explicit primary and foreign keys are hidden from the user's view and that queries can be expressed more compactly. In this paper we evaluate these theoretical advantages with user studies that compare SQLP to plain SQL as the baseline. The experiments show significant statistical evidence that SQLP indeed requires less time for understanding and authoring queries, with no loss in accuracy. Considering the positive results, we develop a method to reverse engineer legacy relational schemata into abstract relational ones

Qualifying Ontology-Based Visual Query Formulation

Abstract. This paper elaborates on ontology-based end-user visual query formulation, particularly for users who otherwise cannot/do not desire to use formal textual query languages to retrieve data due to the lack of technical knowledge and skills. Then, it provides a set of quality attributes and features, primarily elicited via a series of industrial end-user workshops and user studies carried out in the course of an industrial EU project, to guide the design and development of successor visual query systems

A system for query comprehension

Information and Software Technology393141-148ISOT

A graphical knowledge level approach for user-database interaction

Proceedings - IEEE Computer Society's International Computer Software & Applications Conference453-458PSIC

Effects of query complexity and learning on novice user query performance with conceptual and logical database interfaces

10.1109/TSMCA.2003.820581IEEE Transactions on Systems, Man, and Cybernetics Part A:Systems and Humans.342276-281ITSH

High-Frequency Characteristics of InGaP/GaAs Double Heterojunction Bipolar Transistor Epitaxially Grown on 200 mm Ge/Si Wafers

10.1109/JEDS.2020.2967406IEEE Journal of the Electron Devices Society8122-12