An application of flexible query interface to relational databases (original) (raw)

Improving the Query Mode and its Interface for Relational Database Applications

2000

The paper presents an enhanced generic query mode and its interface for any database application. It is intelligent in the sense that it answers most of the possible queries or questions that may arise in the user's mind without the need or support of the application developer. This is not the case in all previous traditional query modes; all of

A Flexible Querying Framework (FQF): Some Implementation Issues

Lecture Notes in Computer Science, 2003

Fuzzy data are a common concept in today's information society. Some data can be unknown, other data may be inaccurate or uncertain. Still, this fuzzy data must be accounted for in modern businesses and therefore must be stored. Fuzzy relational databases have been studied extensively over time, which resulted in numerous models and representation techniques, some of which have been implemented as software layers on top of database systems. Different query languages and end-user interfaces have been extended to perform flexible queries on both regular and fuzzy databases. In this paper, a framework is presented that not only enables flexible querying on the relational model, but on other database models as well, of which the most important are object-oriented database models. This framework, called FQF or Flexible Querying Framework, is built on the recently developed Java Data Objects (JDO) standard.

A Multi-Paradigm Query Interface To An Object-Oriented Database

Interacting with Computers, 1994

The object-oriented paradigm has a number of widely recognised strengths when applied to data management, but the increased complexity of actual systems compared with their relational predecessors often means that such databases are less readily accessible to nonprogrammers than relational systems. A number of proposals have been made for textual, form-based and graph-based query interfaces to object-oriented databases, but it is clear that a single approach cannot be considered to be the best, given the wide range of potential user groups, application domains and tasks. The paper presents a query interface to an object-oriented database which supports alternative user-level query paradigms in a fully integrated environment, thereby enabling different categories of user to select a preferred interface paradigm from a list of options. Furthermore, the interface enables users to examine queries written in one query interface using any of the other interface paradigms, which is useful for sharing queries in the multi-paradigm context, and for helping users familiar with one approach to learn another. The system has been prototyped using the ADAM object-oriented database system, and an experimental comparison of different interaction modes has been conducted.

Flexible Query Languages for Relational Databases: An Overview

2020

We present an overview of the most important proposals for human-oriented query languages for relational databases, based on fuzzy sets theory. To highlight important issues concerning communication with databases, we propose two taxonomies: the first taxonomy deals with flexible query languages in crisp relational databases and the second deals with flexible query languages in fuzzy relational databases. They can help database designers and users understand and select the best approaches to solve their problems.

Semantic Access: Semantic Interface for Querying Databases

Very Large Data Bases, 2000

Semantic Binary Object-oriented Data Model (Sem-ODM) provides an expressive data model (similar to Object-oriented Data Models) with a well-known declarative query facility - SQL (similar to relational databases). Advantages of using Sem-ODM include (i.) friendlier and more intelligent generic user interfaces; (ii.) comprehensive enforcement of integrity constraints; (iii.) greater flexibility; (iv.) substantially shorter application programs; and (v.) easier query facility.

Multi-Paradigm Query Interface to an Object-Oriented Database

Interacting with Computers, 1995

The object-oriented paradigm has a number of widely recognised strengths when applied to data management, but the increased complexity of actual systems compared with their relational predecessors often means that such databases are less readily accessible to nonprogrammers than relational systems. A number of proposals have been made for textual, form-based and graph-based query interfaces to object-oriented databases, but it is clear that a single approach cannot be considered to be the best, given the wide range of potential user groups, application domains and tasks. The paper presents a query interface to an object-oriented database which supports alternative user-level query paradigms in a fully integrated environment, thereby enabling different categories of user to select a preferred interface paradigm from a list of options. Furthermore, the interface enables users to examine queries written in one query interface using any of the other interface paradigms, which is useful for sharing queries in the multi-paradigm context, and for helping users familiar with one approach to learn another. The system has been prototyped using the ADAM object-oriented database system, and an experimental comparison of different interaction modes has been conducted.

A System to Support Teaching and Learning Relational Database Query Languages and Query Processing

The importance of relational algebra in a database course is widely recognized to facilitate teaching and learning of SQL. From our experience we have also found it very useful for the students to understand the basics of query processing in terms of execution plans. However currently there are no specific tools to make the process of learning relational algebra and execution plans an interesting and stimulating activity. The features of the JRS (Java Relational System) graphical editors of query plans are presented. The graphical editors are used to define and execute queries on a database represented by two kinds of trees: A logical plan of relational algebra, and a physical plan that describes an algorithm to execute a query using the physical operators of the relational DBMS developed in Java as a teaching tool.

A Query Interface for Ubiquitous Access to Database Resources

Most information systems depend on a Database Management System (DBMS) to organize information. Access to such an information system is based on use of a database query language on the part of the user. This poses user skills (or skill levels), as problem. For example, for medical staff at a hospital, users can not spare time to learn a database query language. As a result medical staff tend to depend on specialists, and programmers for access to information. To eliminate the complexities of a query language and to make a ubiquitous access a web based information access system has been proposed for the end users. In many cases, the proposed system allows semi-skilled personnel pose queries at the same level as a trained database query language programmer.

Design and Implementation of Graphical User Interface for Relational Database Management System

This paper will explain the concept of creating a Graphical User Interface for three Relational Database Management Systems. This is a general-level GUI, which can be connected to any database residing on the system such as Oracle, MS SQL Server, and MS Access. As a result, any database manipulation can be performed using single interface. Moreover, the queries can be executed very easily, since the user needs not to type any queries, but can simply select the appropriate options according to their requirements. Thus, this software can be used by a person with no knowledge of SQL. This software is developed using Java as front end and Oracle, MS SQL Server and MS Access as backend.