76,878 research outputs found
Object-oriented querying of existing relational databases
In this paper, we present algorithms which allow an object-oriented
querying of existing relational databases. Our goal is to provide an improved query
interface for relational systems with better query facilities than SQL. This
seems to be very important since, in real world applications, relational systems
are most commonly used and their dominance will remain in the near future. To
overcome the drawbacks of relational systems, especially the poor query facilities
of SQL, we propose a schema transformation and a query translation algorithm.
The schema transformation algorithm uses additional semantic information to enhance
the relational schema and transform it into a corresponding object-oriented
schema. If the additional semantic information can be deducted from an underlying
entity-relationship design schema, the schema transformation may be done
fully automatically. To query the created object-oriented schema, we use the
Structured Object Query Language (SOQL) which provides declarative query facilities
on objects. SOQL queries using the created object-oriented schema are
much shorter, easier to write and understand and more intuitive than corresponding
S Q L queries leading to an enhanced usability and an improved querying of
the database. The query translation algorithm automatically translates SOQL queries
into equivalent SQL queries for the original relational schema
Disambiguation of entity references using related entities
This disclosure describes techniques for disambiguation of entity references in natural language processing. The disambiguation of ambiguous entity references is performed by seeking user confirmation of the intended reference. With user permission, the confirmation query or prompt utilizes phrases that include the name of the ambiguous entity and name(s) of related entities. Entities are stored along with names of related entities and designation of the nature of the relationship. The nature of relationship between stored entities is used to construct appropriate conjunctions in disambiguation phrases. The described techniques can be used in any natural language interface, e.g., text or voice, and can be implemented as part of an operating system, a virtual assistant application, etc
An Experimental Investigation of Complexity in Database Query Formulation Tasks
Information Technology professionals and other knowledge workers rely on their ability to extract data from organizational databases to respond to business questions and support decision making. Structured query language (SQL) is the standard programming language for querying data in relational databases, and SQL skills are in high demand and are taught in most introductory database courses. We examined students’ performance on query formulation tasks, in an experimental setting which varied the complexity of the query and the ambiguity of the information request. Our results confirm the main effects of query complexity and request ambiguity found in prior studies (Borthick et al. 2001). In addition, we found an interaction effect between complexity and ambiguity, namely that low ambiguity is more important as tasks increase in complexity. We also found that students’ confidence with entity-relationship diagrams corresponds to reduced time spent on query formulation, and their ability to evaluate the accuracy of their queries reduces as query complexity increases. We discuss the implications of these findings with some suggestions for future research
Recommended from our members
Learning from AI : new trends in database technology
Recently some researchers in the areas of database data modelling and knowledge representations in artificial intelligence have recognized that they share many common goals. In this survey paper we show the relationship between database and artificial intelligence research. We show that there has been a tendency for data models to incorporate more modelling techniques developed for knowledge representations in artificial intelligence as the desire to incorporate more application oriented semantics, user friendliness, and flexibility has increased. Increasing the semantics of the representation is the key to capturing the "reality" of the database environment, increasing user friendliness, and facilitating the support of multiple, possibly conflicting, user views of the information contained in a database
- …