An Entity Relationship Programming Language

The syntax for an integrated E-R programming language is presented. The problems that arise when a query language is embedded in a general-purpose programming language are discussed. Other E-R languages are also discussed. The requirements for the language and a syntax for an E-R model in which entity sets are mutually disjoint and each entity type has a unique, perhaps multiattribute, key are presented. The syntax for a more limited model restricted to binary relationships between entity types and without attributes is presented. Some implementation considerations are discussed. >

[1]  Ramez Elmasri,et al.  GORDAS: A Formal High-Level Query Language for the Entity-Relationship Model , 1981, ER.

[2]  R. G. G. Cattell,et al.  Entity-Relationship Database User Interfaces , 1987, ER.

[3]  Anthony I. Wasserman.  The data management facilities of PLAIN , 1979, SIGMOD '79.

[4]  Kazimierz Subieta,et al.  Data Manipulation in NETUL , 1987, ER.

[5]  L.M. Burns,et al.  A graphical entity-relationship database browser , 1988, [1988] Proceedings of the Twenty-First Annual Hawaii International Conference on System Sciences. Volume II: Software track.

[6]  James A. Larson,et al.  A Graphical Query Facility for ER Databases , 1985, ER.

[7]  Eero Saarinen.  IBM Thomas J. Watson Research Center , 1961 .

[8]  Joachim W. Schmidt,et al.  Some high level language constructs for data of type relation , 1977, TODS.

[9]  Harry M. Markowitz,et al.  The EAS-E application development system: principles and language summary , 1984, CACM.

[10]  David W. Embley,et al.  A Relationally Complete Query Language for an Entity-Relationship Model , 1985, ER.

[11]  Carlo Zaniolo,et al.  The database language GEM , 1983, SIGMOD '83.

[12]  Y. Edmund Lien,et al.  On the Semantics of the Entity-Relationship Data Model , 1979, ER.

[13]  Martin L. Kersten,et al.  High-level programming features for improving the efficiency of a relational database system , 1981, TODS.

[14]  Victor M. Markowitz,et al.  ERROL: An Entity-Relationship, Role Oriented, Query Language , 1983, ER.

[15]  Peter P. Chen.  The Entity-Relationship Model: Towards a unified view of Data , 1976 .

[16]  Jonathan E. Shopiro.  Theseus—a programming language for relational databeses , 1979, ACM Trans. Database Syst..

[17]  Harry M. Markowitz,et al.  EAS-E: an integrated approach to application development , 1983, TODS.

[18]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[19]  Lawrence A. Rowe,et al.  Data abstraction, views and updates in RIGEL , 1979, SIGMOD '79.

[20]  Fernando Vélez.  Lambda: An Entity-Relationship Based Query Language for the Retrieval of Structured Documents , 1985, ER.

[21]  Wolfgang Roesner,et al.  SESPATH: An ER Manipulation Language , 1985, ER.

[22]  Shamkant B. Navathe,et al.  A Methodology for Database Schema Mapping from Extended Entity-Relationship Models into the Hierarchical Model , 1983, International Conference on Conceptual Modeling.

[23]  Harry M. Markowitz,et al.  The ER and EAS Formalisms for System Modelling, and the EAS-E Language , 1981, ER.

[24]  Gary H. Sockut,et al.  A full-screen facility for defining relational and entity-relationship database schemas , 1988, IEEE Software.

[25]  Matthias Jarke,et al.  Query processing strategies in the PASCAL/R relational database management system , 1982, SIGMOD '82.