Preliminary Version: Ada (Trade Name)/SQL: A Standard, Portable Ada-DBMS Interface.

• Main Authors: Brykczynski,Bill R, Friedman,Fred
• Other Authors: INSTITUTE FOR DEFENSE ANALYSES ALEXANDRIA VA
• Format: Text
• Language: English
• Published: 1987
• Subjects: Computer Programming and Software; *COMPUTER PROGRAMMING; ARTIFICIAL INTELLIGENCE; HIGH LEVEL LANGUAGES; NETWORK ANALYSIS(MANAGEMENT); DATA BASES; DATA MANAGEMENT; LPN-IDA-T-W5-260; SBI1; FY87; WWMCCS(Worldwide Military Command and Control System); Ada Programming Language; DBMS(Database Management System); DDL(Data Definition Language); COTS(Commercial Off the Shelf); Data base management; Ida; DML
• Online Access: http://www.dtic.mil/docs/citations/ADA182885; http://oai.dtic.mil/oai/oai?&verb=getRecord&metadataPrefix=html&identifier=ADA182885

This IDA Paper describes the standards and software developed that have addressed the area of interfacing with the database management systems(DBMS). A standard DBMS interface has been developed, consisting of both a data definition language and a data manipulation language(DML). Use of this standard within application programs will permit them to operate transportably with any variety of commercial off the shelf (COTS) DBMSs. In addition, tools have been developed to assist in the implementation of the standard with a new COTS DBMS, and to automatically generate test data for use during the system checkout and tuning phases. Ada/SQL is a binding of the proposed ANSI standard database language SQL to the Ada programming language. This binding is currently being proposed as both an ANSI and ISO standard. Ada/SQL adheres to the current version of the proposed ANSI standard for SQL as much as possible. The underlying DBMS need not, however, conform to the SQL standard; the Ada/SQL environment translates between the standard Ada/SQL interface and that of the underlying DBMS.