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
1 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
2 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.
3 built on relational model, simple and powerful
4 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
in Table To:

© on Mon Oct 13 1997