No IFs, ANDs, or ORs: A study of database querying

Greene, Sharon L.; Devlin, Susan J.; Cannata, Philip; Gomez, Louis M.

doi:10.1016/s0020-7373(08)80005-3

Cited by 74 publications

(58 citation statements)

References 14 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…It has been studied that it is generally more adequate to provide customers with fairly simple and easy to use search interfaces [7], whereas experts and content managers, who are aware of many internal information details, can benefit from more complex and powerful search facilities. This is supported in our platform by creating different templates for different user profiles and usage modes, thus enabling the creation of as large and varied an array of power levels and modalities as needed (see [12] for an overview of user interface approaches for searching), in a highly modular way, very easy to extend.…”

Section: Information Searchmentioning

confidence: 99%

Semantic Web Technologies for Economic and Financial Information Management

Castells

Foncillas²,

Lara³

et al. 2004

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Esta es la versión de autor de la comunicación de congreso publicada en: This is an author produced version of a paper published in:The Abstract. The field of economy and finance is a conceptually rich domain where information is complex, huge in volume and a highly valuable business product by itself. Novel management techniques are required for economic and financial information in order to enable an efficient generation, management and consumption of complex and big information resources. Following this direction, we have developed and ontology-based platform that provides a) the integration of contents and semantics in a knowledge base that provides a conceptual view on low-level contents, b) an adaptive hypermedia-based knowledge visualization and navigation system and c) semantic search facilities. We have developed, as the basis of this platform, an ontology for the domain of economic and financial information.

show abstract

Section: Information Searchmentioning

confidence: 99%

Semantic Web Technologies for Economic and Financial Information Management

Castells

Foncillas²,

Lara³

et al. 2004

Lecture Notes in Computer Science

View full text Add to dashboard Cite

show abstract

“…In a review of previous experiments (for example, Greene et al [23] and Michard [37]), Young and Shneiderman [53] note that a common error in textual query languages is that of using the logical AND operator as opposed to the logical OR operator when translating from English sentences. They also note that users found it dif®cult to specify precedence in query expressions due to``parenthesis complexity'' [39].…”

Section: General Database Issuesmentioning

confidence: 99%

“…They also note that users found it dif®cult to specify precedence in query expressions due to``parenthesis complexity'' [39]. Syntactical errors are also a problem in query languages [23], [38], [44], [50], [53]. In their evaluations, Young and Shneiderman [53] chose not to rate queries with syntax errors as incorrect, and Reisner [44] categorized these types of errors as``minor'' and placed them under the banner`e ssentially correct'' queries.…”

Section: General Database Issuesmentioning

confidence: 99%

A Filter Flow Visual Querying Language and Interface for Spatial Databases

et al. 2004

View full text Add to dashboard Cite

In this paper a visual approach to querying in spatial databases is presented. A ®lter¯ow methodology is used to consistently express different types of queries in these systems. Filters are used to represent operations on the database and pictorial icons are used throughout the language for ®lters, operators and spatial relations. Different granularities of the relations are presented in a hierarchical fashion for spatial constraints. The language framework and functions are described and examples are used to demonstrate its capabilities in representing different levels of queries, including spatial joins and composite spatial joins. Here, the primary focus is on the query language itself but an overview of the implemented interface of the language is also provided.

show abstract

“…Prototype applications have been used in usability tests of database query languages [6]. However, these experiments were undertaken when the languages were already commercially available and, therefore, too late to influence SQL design materially.…”

Section: Previous Workmentioning

confidence: 99%

ProSQL: A Prototyping Tool for SQL Temporal Language Extensions

Green

Johnson

2003

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract. This paper describes ProSQL, a novel prototyping tool to support the development of extensions to SQL. ProSQL provides a simple way to prototype the features of a proposed extension and thus provide a proof of concept. Further, it provides proposers and reviewers of extensions with a clearer view of their positive and negative features. The approach adopted has been to build a wrapper around an existing database management system, in this case Microsoft Access, and to provide a collection of interfaces with which a designer can define extensions to the basic relational database.

show abstract

No IFs, ANDs, or ORs: A study of database querying

Cited by 74 publications

References 14 publications

Semantic Web Technologies for Economic and Financial Information Management

Semantic Web Technologies for Economic and Financial Information Management

A Filter Flow Visual Querying Language and Interface for Spatial Databases

ProSQL: A Prototyping Tool for SQL Temporal Language Extensions

Contact Info

Product

Resources

About