Basic HTML version of Foils prepared 7 October 97

Foil 35 Overview of Structure Query Language (SQL)

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng Marek Podgorny Chao-Wei Ou


a database language specifies the semantics of various components of a DBMS: structures and operation of a data model, data definition, data access, security, programming language interface, and data administration
Industry accepted Standard, first introduced by ANSI in 1986, current SQL92 by ANSI and ISO, new standard SQL3 with enhancements in object-oriented data management is undergoing. Portable to all RDBMS systems.
built on relational model, simple and powerful
non-procedural 4GL language, only specify "what-to-do", not "how-to-do" , extended to object-oriented programming interface
  • this extended model competes with fledging object-oriented database in industry



© on Mon Oct 13 1997