An extension of the database language SQL to capture more relational concepts

ABSTRACT

An extension of the database language SQL is described which introduces several new concepts into the language that are standard in the relational model, but surprisingly not present in available SQL-based systems such as SQL/DS and DB2.

REFERENCES

• 1: [1] American National Standards Institute. Draft Proposed American Standard Database Language SQL. Draft ISO/TC 97/SC 21/WG 5-15/N 90, New York 1985.
• 2: E. F. Codd, An Evaluation Scheme for Database Management Systems that are claimed to be Relational, Proceedings of the Second International Conference on Data Engineering, p.720-729, February 05-07, 1986
• 3: Chris Date, A Guide to DB2, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1984
• 4: C. J. Date, A critique of the SQL database language, ACM SIGMOD Record, v.14 n.3, p.8-54, November 1984 [doi>10.1145/984549.984551]
• 5: [5] IBM Corporation. SQL/Data System Terminal User's Reference. Publication No. SH24-5017-2, Release 2, Endicott, NY, 1983.
• 6: David Maier, Theory of Relational Databases, Computer Science Pr, 1983
• 7: Gottfried Vossen, Data models, database languages and database management systems, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1991
• 8: [8] J. Yacabucci. OurBase 5000 -- A Relational Database Management System. Internal Report, CSE Department, UCSD, August 1987.
• 9: Chao-Chih Yang, Relational databases, Prentice-Hall, Inc., Upper Saddle River, NJ, 1986

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages

          Nouns: SQL

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.0 General
          Subjects: Security, integrity, and protection**
      H.2.1 Logical Design
          Subjects: Data models; Schema and subschema
      H.2.4 Systems
          Subjects: Query processing

General Terms:
Algorithms, Design, Experimentation, Languages, Performance