HVQS: The hierarchical visual query system for databases

Ping Kuen Chen, Gwo Dong Chen, Baw Jhiune Liu

Research output: Contribution to journalArticlepeer-review

7 Scopus citations

Abstract

This work describes the design and implementation of hierarchical visual query system (HVQS). It is a user interface for querying and browsing databases in a hierarchical database schema. HVQS enables users to use ahierarchical visual query, i.e. they can visually formulate a query and watch the query results on a few higher layers of database schema. This simplifies the query, reduces the failure rate, conserves query time, allows users to work on a database schema with wider scope, and helps users understand database content and focus on meaningful data using a top-down method. This work first gives an overview of the hierarchical visual query, and then describes the prototype of HVQS, defines a hierarchical graph for representing hierarchical database schema, and discusses the Query Manager and Visual Interface Manager of HVQS. Also described herein is the expressive power and semantics of HVQS query. Finally, a evaluation report of an experiment is given to demonstrate that HVQS improves the query success rate and facilitates users in query formulation.

Original languageEnglish
Pages (from-to)1-26
Number of pages26
JournalJournal of Visual Languages and Computing
Volume11
Issue number1
DOIs
StatePublished - 2000

Fingerprint

Dive into the research topics of 'HVQS: The hierarchical visual query system for databases'. Together they form a unique fingerprint.

Cite this