Accession Number : ADA194517

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

Descriptive Note : Final rept.,

Corporate Author : INSTITUTE FOR DEFENSE ANALYSES ALEXANDRIA VA

Personal Author(s) : Brykczynski, Bill R ; Friedman, Fred ; Heatwole, Kevin ; Hilliard, Kerry

PDF Url : ADA194517

Report Date : Mar 1988

Pagination or Media Count : 570

Abstract : 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.

Descriptors :   *HIGH LEVEL LANGUAGES, COMPUTER PROGRAMMING, PROGRAMMING LANGUAGES, DEPARTMENT OF DEFENSE, SCANNERS, DATA BASES, MANAGEMENT, SYSTEMS ENGINEERING, COMPILERS

Subject Categories : Computer Programming and Software

Distribution Statement : APPROVED FOR PUBLIC RELEASE