An Ada/SQL (Structured Query Language) Application Scanner.

This IDA Memorandum Report identifies and describes a version of software delivery, the Ada/SQL Application Scanner. The purpose of this software system is to provide a tool which will aid in the generation of subprograms necessary for a Level 1 Ada/SQL implementation. Ada/SQL is an interface betwee...

Full description

Bibliographic Details
Main Authors: Brykczynski, Bill R, Friedman, Fred, Heatwole, Kevin, Hilliard, Kerry
Other Authors: INSTITUTE FOR DEFENSE ANALYSES ALEXANDRIA VA
Format: Text
Language:English
Published: 1988
Subjects:
Ida
DML
Online Access:http://www.dtic.mil/docs/citations/ADA194517
http://oai.dtic.mil/oai/oai?&verb=getRecord&metadataPrefix=html&identifier=ADA194517
Description
Summary:This IDA Memorandum Report identifies and describes a version of software delivery, the Ada/SQL Application Scanner. The purpose of this software system is to provide a tool which will aid in the generation of subprograms necessary for a Level 1 Ada/SQL implementation. Ada/SQL is an interface between the Ada programming language and the database programming language SQL. Ada/SQL, like SQL, comprises two main components: a Data Definition Language (DDL) and a Data Manipulation Language (DML). Both the DDL and the DML are coded using pure Ada syntax and semantics. The DDL resides in a package specification and is used to define the data types, variable definitions, and table and column definitions. The DML is expressed as syntax very similar to the syntax of SQL DML. This expression is allowed due to a set of underlying operators and subprograms which must be 'with'ed by the application. However, many of these subprograms are application dependent and are tedious to code. To alleviate the coding of these subprograms, a tool, the Application Scanner, has been developed. The Application Scanner reads the Ada/SQL data definition package, the Ada/SQL data manipulation package, and various other packages to determine exactly the necessary functions and procedures required for completion. If errors are found in any of these files, a listing will be generated showing the text of the package, and pointer to the appropriate line number and column position where the error occurred.