The American National Standards Institute (ANSI) National Committee on Information Technology Standards (NCITS) Technical Committee on Database, H2, was founded in 1978. This committee meets six times per year.
Information Technology Standards are successful only when three conditions exist:
- A significant market share vendor community
- Publicly developed, available, and evolving standards
- Enforced conformance tests
These conditions are described in the paper, The Essential Paradigm for Successful IT Standards
Starting in 1978, H2 considered hundreds of technical change proposals to the CODASYL 1978 JOD, and in August, 1984, finished work on the first American National Standard for database, NDL. This standard modeled after the CODASYL data model was released for public review in January, 1985. It was accepted as an American National Standard in 1986. The standard specifies the syntax and semantics for both schema and subschema of network structured databases, and specifies the semantics for a data manipulation language.
In late 1982, ANSI H2 began to standardize a version of the relational data model through the IBM donated language, SEQUEL. Renamed SQL by H2, basic SQL was completed and became an American National Standard in 1986. H2 has completed the 1989, 1992 and object oriented, non-relational SQL:1999, and 2003 standards, the SQL standard contains:
- Six interfaces to compiler based languages such as Ada, C, COBOL, and Fortran;
- Full referential Integrity
- Multiple-language support, transaction management, two-phase commit, etc.
- Abstract data types, nested data structures within columns, and a number of object oriented facilities
- SQL/MM for BLOBS, text processing, and libraries of scientific and geologic abstract data types
- Remote Data Access protocols for generic distributed processing and for SQL specializations
- SQL/PSM, the SQL programming language for persistent stored modules that are defined and controlled by SQL
- SQL/CLI, a common call level interfaces that standardizes the CALLs interface between products from multiple vendors in the SQL family.
For a comprehensive description of SQL:1999 download SQLBOM from the free downloads section of this website and also visit, www.jcc.com