A visual object-relationship query language for user-database interaction

User–database interaction has a direct and immediate effect on the effectiveness and efficiency of database end users. Traditional query languages like SQL and QBE require end users to understand the underlying data structure in the database. This is a burden on end users, especially novice end user...

Full description

Saved in:
Bibliographic Details
Main Author: SIAU, Keng
Format: text
Language:English
Published: Institutional Knowledge at Singapore Management University 1998
Subjects:
Online Access:https://ink.library.smu.edu.sg/sis_research/9397
https://ink.library.smu.edu.sg/context/sis_research/article/10397/viewcontent/1_s2.0_S0736585398000070_main.pdf
Tags: Add Tag
No Tags, Be the first to tag this record!
Institution: Singapore Management University
Language: English
id sg-smu-ink.sis_research-10397
record_format dspace
spelling sg-smu-ink.sis_research-103972024-10-25T08:56:21Z A visual object-relationship query language for user-database interaction SIAU, Keng User–database interaction has a direct and immediate effect on the effectiveness and efficiency of database end users. Traditional query languages like SQL and QBE require end users to understand the underlying data structure in the database. This is a burden on end users, especially novice end users who have little technical knowledge or understanding of database. To alleviate the need for end users to know the logical database organization, this paper proposes the use of an object–relationship (OR) model and a formal high-level visual query language as the interface. Using this interface, end users communicate only domain knowledge with the system without the need to specify the storage structure or search strategies. The end users deal only with the conceptual model of the database and not the actual physical implementation of the database. To demonstrate the expressive power of the visual query language, this paper also provides a proof to show that it is relationally complete and hence is as powerful as traditional languages such as SQL. 1998-02-01T08:00:00Z text application/pdf https://ink.library.smu.edu.sg/sis_research/9397 info:doi/10.1016/S0736-5853(98)00007-0 https://ink.library.smu.edu.sg/context/sis_research/article/10397/viewcontent/1_s2.0_S0736585398000070_main.pdf http://creativecommons.org/licenses/by-nc-nd/4.0/ Research Collection School Of Computing and Information Systems eng Institutional Knowledge at Singapore Management University User-database interaction Iconic interface Visual query language Object-relationship model Databases and Information Systems Programming Languages and Compilers
institution Singapore Management University
building SMU Libraries
continent Asia
country Singapore
Singapore
content_provider SMU Libraries
collection InK@SMU
language English
topic User-database interaction
Iconic interface
Visual query language
Object-relationship model
Databases and Information Systems
Programming Languages and Compilers
spellingShingle User-database interaction
Iconic interface
Visual query language
Object-relationship model
Databases and Information Systems
Programming Languages and Compilers
SIAU, Keng
A visual object-relationship query language for user-database interaction
description User–database interaction has a direct and immediate effect on the effectiveness and efficiency of database end users. Traditional query languages like SQL and QBE require end users to understand the underlying data structure in the database. This is a burden on end users, especially novice end users who have little technical knowledge or understanding of database. To alleviate the need for end users to know the logical database organization, this paper proposes the use of an object–relationship (OR) model and a formal high-level visual query language as the interface. Using this interface, end users communicate only domain knowledge with the system without the need to specify the storage structure or search strategies. The end users deal only with the conceptual model of the database and not the actual physical implementation of the database. To demonstrate the expressive power of the visual query language, this paper also provides a proof to show that it is relationally complete and hence is as powerful as traditional languages such as SQL.
format text
author SIAU, Keng
author_facet SIAU, Keng
author_sort SIAU, Keng
title A visual object-relationship query language for user-database interaction
title_short A visual object-relationship query language for user-database interaction
title_full A visual object-relationship query language for user-database interaction
title_fullStr A visual object-relationship query language for user-database interaction
title_full_unstemmed A visual object-relationship query language for user-database interaction
title_sort visual object-relationship query language for user-database interaction
publisher Institutional Knowledge at Singapore Management University
publishDate 1998
url https://ink.library.smu.edu.sg/sis_research/9397
https://ink.library.smu.edu.sg/context/sis_research/article/10397/viewcontent/1_s2.0_S0736585398000070_main.pdf
_version_ 1814047954938363904