In this paper, we propose a visual interface for manipulating relational databases (RDBs). This interface, unlike structured query language (SQL), describes queries in a procedural language with graphs. This helps inexperienced users to interact with RDBs, and also helps experienced users to express nontrivial queries properly. It also supports SQL-DML (SELECT, INSERT, UPDATE, DELETE), ensuring there is no missing functionality in database manipulation. It also introduces the system architecture and algorithms for the inter-conversion between SQL and the Visual Query Interface. This architecture can support various RDBMSs.
IOS Press, Inc.
6751 Tepper Drive
Clifton, VA 20124
Tel.: +1 703 830 6300
Fax: +1 703 830 2300 firstname.lastname@example.org
(Corporate matters and books only) IOS Press c/o Accucoms US, Inc.
For North America Sales and Customer Service
West Point Commons
Lansdale PA 19446
Tel.: +1 866 855 8967
Fax: +1 215 660 5042 email@example.com