Basic HTML version of Foils prepared 7 October 97

Foil 10 Structure Query Language (SQL) - I

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox


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-procedure language, only specify "what-to-do", not "how-to-do" (4GL)
Extended to object-oriented programming interface
  • This extended model competes with fledging object-oriented database in industry



© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998