A graphical query language for entity-relationship databases
Proc. of the third international conference on Entity-relationship approach to software engineering
Graphical query formulation for an entity-relationship model
Data & Knowledge Engineering
Fundamentals of database systems
Fundamentals of database systems
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Graphical Specification of Recursive Queries
ICCI '91 Proceedings of the International Conference on Computing and Information: Advances in Computing and Information
A Graphical Query Facility for ER Databases
Proceedings of the Fourth International Conference on Entity-Relationship Approach
An Approach to Computation Specification for an Entity-Relationship Query Language
Proceedings of the Sixth International Conference on Entity-Relationship Approach
Hi-index | 0.00 |
Several query languages have been proposed in which users graphically manipulate Entity-Relationship (ER) diagrams to formulate queries. In this paper we present a method of implementing an ER query and update language as an interface for a relational Database Management System. The approach is based on interactive manipulation of ER database schemas and generation of SQL expressions for an underlying relational database. The graphical query and update formulation process is formally defined. We assume that the information reflecting the current state of the query and update formulation process is maintained in a formal model. The model described in other publications is significantly modified and extended. The information included in the extended model allows an ER diagram corresponding to the current state of the query to be displayed on the terminal screen. It is also used to generate an equivalent SQL expression for a relational database. The integrity constraints for the formal model are specified.