The database language GEM

ABSTRACT

GEM (an acronym for General Entity Manipulator) is a general-purpose query and update language for the DSIS data model, which is a semantic data model of the Entity-Relationship type. GEM is designed as an easy-to-use extension of the relational language QUEL, providing support for the notions of entities with surrogates, aggregation, generalization, null values, and set-valued attributes.

REFERENCES

• 1: {Andr} Andrade J. M. "Genus: a programming language for the design of database applications," Internal Memorandum, Bell Laboratories, 1982.
• 2: {Brod} Brodie, M.L., "On Modelling Behavioural Semantics of Databases," 7th Int. Conf. Very Large Data Bases, pp. 32--42, 1981.
• 3: E. F. Codd, Relational database: a practical foundation for productivity, Communications of the ACM, v.25 n.2, p.109-117, Feb 1982 [doi>10.1145/358396.358400]
• 4: E. F. Codd, Extending the database relational model to capture more meaning, ACM Transactions on Database Systems (TODS), v.4 n.4, p.397-434, Dec. 1979 [doi>10.1145/320107.320109]
• 5: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 6: {DSIS} Lien, Y.E., J.E. Shopiro and S. Tsur. "DSIS --- A Database System with Interrelational Semantics," 7th Int. Conf. Very Large Data Bases, pp. 465--477, 1981.
• 7: {HeSW} Held, G.D, M.R. Stonebraker and E. Wong, "INGRES: a Relational Data Base System," AFIPS Nat. Computer Conf., Vol. 44, pp. 409--416, 1975.
• 8: {KiMc} King, R. and D. McLeod, "The Event Database Specification Model," 2nd Int. Conf. Databases --- Improving Usability and Responsiveness, Jerusalem, June 22--24, 1982.
• 9: {IDM} IDM 500 Software Reference Manual. Ver. 1.3, Sept 1981. Britton-Lee Inc., 90 Albright Way, Los Gatos, CA, 95030.
• 10: Michael Stonebraker , Gerald Held , Eugene Wong , Peter Kreps, The design and implementation of INGRES, ACM Transactions on Database Systems (TODS), v.1 n.3, p.189-222, Sept. 1976 [doi>10.1145/320473.320476]
• 11: {LaPi} Lacroix, M. and A. Pirotte, "Example queries in relational languages," MBLE Tech. note 107, 1976 (MBLE, Rue Des Deux Gares 80, 1070 Brussels).
• 12: {QUEL} Woodfill, J. et al., "INGRES Version 6.2 Reference Manual," Electronic Research Laboratory, Memo UCB/ERL-M78/43, 1979.
• 13: David W. Shipman, The functional data model and the data languages DAPLEX, ACM Transactions on Database Systems (TODS), v.6 n.1, p.140-173, March 1981 [doi>10.1145/319540.319561]
• 14: {SiKe} Sibley, E.H. and L. Kershberg, "Data Architecture and Data Model Considerations," AFIPS Nat. Computer Conf., pp. 85--96, 1977.
• 15: John Miles Smith , Diane C. P. Smith, Database abstractions: aggregation and generalization, ACM Transactions on Database Systems (TODS), v.2 n.2, p.105-133, June 1977 [doi>10.1145/320544.320546]
• 16: {Tsur} Tsur, S., "Mapping of GEM into IDL," internal memorandum, Bell Laboratories, 1982.
• 17: {TsZa} Tsur, S. and C. Zaniolo, "The Implementation of GEM --- Supporting a Semantic Data Model on a Relational Backend", submitted for publication.
• 18: Jeffrey D. Ullman, Principles of Database Systems, W. H. Freeman & Co., New York, NY, 1983
• 19: Carlo Zaniolo, Database relations with null values, Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systems, March 29-31, 1982, Los Angeles, California [doi>10.1145/588111.588117]
• 20: {Zani2} Zaniolo, C., "A Formal Treatment of Nonexistent Values in Database Relations," Internal Memorandum, Bell Laboratories, 1983.
• 21: {Zani3} Zaniolo, C., "The Database language GEM," Internal Memorandum, Bell Laboratories, 1982.