This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
An Entity-Relationship Programming Language
September 1989 (vol. 15 no. 9)
pp. 1120-1130

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] L. M. Burns, J. A. Archibald, and A. Malhotra, "A graphical entityrelationship browser," inProc. HICSS '88, vol. II, Jan. 1988, pp. 694-704.
[2] D. M. Campbell, D. W. Embley, and B. Czejdo, "A relationally complete query language for an entity-relationship model," inProc. 4th Int. Conf. Entity-Relationship Approach, Chicago, IL, 1985.
[3] P. P. Chen, "The Entity-Relationship Model -- Towards a Unified View of Data,"ACM Trans. Database Syst., Vol. 1, No. 1, Mar. 1976, pp. 9-36.
[4] R. Elmasri and J. A. Larson, "A graphical query facility for ER databases," inProc. 4th Int. Conf. Entity-Relationship Approach, Chicago, IL, 1985, pp. 236-245.
[5] R. Elmasri and G. Wiederhold, "GORDAS: A formal high-level query language for the entity-relationship model," inEntity-Relationship Approach to Software Engineering, C. G. Daviset al., Eds. Amsterdam, The Netherlands: North-Holland, 1983.
[6] IBM Corp., "SQL/data system concepts and facilities," Rep. GH24- 5013.
[7] S. Jajodia and P. A. Ng, "On representation of relational structures by entity-relationship diagrams," inEntity-Relationship Approach to Software Engineering, C. G. Daviset al., Eds. Amsterdam, The Netherlands: North Holland, 1983.
[8] M. Jarke and J. Schmidt, "Query processing strategies in the Pascal/ R relational database management system," inProc. ACM-SIGMOD Int. Conf. Management of Data, Orlando, FL, June 1982, pp. 215- 224.
[9] Y. A. Lien, "On the semantics of the entity-relationship model," inEntity-Relationship Approach to Systems Analysis and Design, P. Chen, Ed. Amsterdam, The Netherlands: North-Holland, 1980.
[10] S. B. Navathe and A. Cheng, "A methodology for database schema mapping from extended entity-relationship models into the hierarchical model," inEntity-Relationship Approach to Software Engineering, C. G. Davis, Eds. Amsterdam, The Netherlands: North-Holland, 1983.
[11] A. Malhotra, H. M. Markowitz, and D. P. Pazel, "EAS-E: An integrated approach to application development,"ACM Trans. Data-base Syst.
[12] A. Malhotra, Y. Tsalalikhin, H. M. Markowitz, D. P. Pazel, and L. M. Burns, "Implementing an entity-relationship language on a relational database," IBM Thomas J. Watson Research Center, Yorktown Heights, NY, Rep. RC 12134.
[13] A. Malhotra, D. P. Pazel, and L. M. Burns, "BROWSER: A visual, interactive database interface," IBM Thomas J. Watson Research Center, Yorktown Heights, NY, Rep. RC 10964, Jan. 1985.
[14] H. M. Markowitz, A. Malhotra, and D. P. Pazel, "The ER and EAS formalism for system modeling, and the EASE language," in P. P. Chen, Ed.,Entity Relationship Approach to Information Modeling and Analysis. ER Inst., 1981, pp. 29-47.
[15] H.M. Markowitz, A. Malhotra, and D.P. Pazel, "The EAS-E Application Development System: Principles and Language Summary,"Conm. ACM, Aug. 1984, pp. 785-799.
[16] V. M. Markowitz and Y. Raz, "ERROL: An entity-relationship, role oriented query language," inEntity-Relationship Approach to Software Engineering, C. G. Daviset al., Ed. Amsterdam, The Netherlands: North-Holland, 1983.
[17] W. Roesner, "DESPATH: An ER manipulation language," inProc. Entity Relationship Conf., 1985.
[18] T. R. Rogers and R. G. G. Cattell, "Entity-relationship database user interfaces," in S. March, Ed.,Proc. 6th Int. Conf. Entity-Relationship Approach, New York, NY, 1987, pp. 323-336.
[19] L. Rowe and K. A. Shones, "Data abstraction, views and updates in RIGEL," inProc. ACM SIGMOD Int. Conf. Management Data, 1979. pp. 71-81.
[20] J. W. Schmidt, "Some high level constructs for data of type relation,"Trans. Database Syst., vol. 2, no. 3, pp. 247-261, 1977.
[21] J. W. Shopiro, "Theseus--A programming language for relational databases,"ACM Trans. Database Syst., vol. 4, no. 4, pp. 493-517, Dec. 1979.
[22] G. H. Sockut and A. Malhotra, "A full-screen facility for defining relational and entity-relationship schemas,"IEEE Software, Nov. 1988.
[23] K. Subieta and M. Missala, "Data manipulation in NETUL," inProc. 6th Int. Conf. Entity-Relationship Approach, New York, Nov. 1987.
[24] R. P. van de Riet, A. I. Wasserman, M. L. Kersten, and W. De Jonge, "High-level programming features for improving the efficiency of a relational database system,"ACM Trans. Database Syst., vol. 6, no. 3, pp. 464-485, Sept. 1981.
[25] F. Velez, "LAMDA: An ER based query language for the retrieval of structured documents," inProc. Entity Relationship Conf., 1985.
[26] A. I. Wassermanet al., "The data management facilities of PLAIN,"ACM SIGPLAN Notices, vol. 16, no. 5, pp. 59-80, May 1981.
[27] C. Zaniolo, "The database language GEM," inProc. 1983 ACMSIGMOD Int. Conf. Management of Data, San Jose, CA, May 1983.
[28] Several papers inProc. Entity-Relationship Conferences: Entity-Relationship Approach to Systems Analysis and Design, P. Chen, Ed. Amsterdam, The Netherlands: North-Holland, 1980;Proc. 2nd Int. Conf. Entity-Relationship Approach, Washington, DC. 1981;Entity-Relationship Approach to Software Engineering, C. G. Daviset al., Eds. Amsterdam, The Netherlands: North-Holland, 1983;Proc. 4th Int. Conf. Entity-Relationship Approach., Chicago, IL, 1985;Proc. 6th Int. Conf. Entity-Relationship Approach, New York, 1987.

Index Terms:
entity-relationship programming language; syntax; integrated E-R programming language; query language; general-purpose programming language; entity sets; mutually disjoint; entity type; unique; multiattribute; key; binary relationships; high level languages
Citation:
A. Malhotra, H.M. Markowitz, Y. Tsalalikhin, D.P. Pazel, L.M. Burns, "An Entity-Relationship Programming Language," IEEE Transactions on Software Engineering, vol. 15, no. 9, pp. 1120-1130, Sept. 1989, doi:10.1109/32.31369
Usage of this product signifies your acceptance of the Terms of Use.