Publication Type
Conference Proceeding Article
Version
publishedVersion
Publication Date
9-1991
Abstract
Relational query languages like SQL and QUEL require the users to understand the complex database structure. This is a burden on end users, especially novice end users who access the database on a casual and infrequent basis. To alleviate the need to know the logical database organization, this paper proposes the use of a semantic data model, known as the Enhanced Entity-Relationship (EER) model, as a front-end to the relational systems. A formal, high-level Visual Knowledge Query Language (VKQL) has also been designed for this interface. This language provides for knowledge abstraction as the user communicates only domain knowledge with the system without any implication on the storage structure or search strategies. A translation algorithm is also described in this paper to translate VKQL queries to Standard SQL equivalents.
Keywords
Database structures, Entity-relationship, Knowledge abstraction, Relational query languages, Relational systems, Semantic data model, Storage structures, Translation algorithms
Discipline
Databases and Information Systems | Theory and Algorithms
Research Areas
Data Science and Engineering; Information Systems and Management
Publication
Proceedings of the 15th Annual International Computer Software and Applications Conference, Tokyo, Japan, 1991 September 11-13
First Page
373
Last Page
378
ISBN
0818621524
Identifier
10.1109/CMPSAC.1991.170205
Publisher
IEEE
City or Country
New Jersey
Citation
SIAU, Keng; TAN, Kok Phuang; and CHAN, Hock Chuan.
Visual knowledge query language as a front-end to relational systems. (1991). Proceedings of the 15th Annual International Computer Software and Applications Conference, Tokyo, Japan, 1991 September 11-13. 373-378.
Available at: https://ink.library.smu.edu.sg/sis_research/9595
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.
Additional URL
https://doi.org/10.1109/CMPSAC.1991.170205