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

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.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Mar 01, 1988
Accession Number
ADA194517

Entities

People

  • Bill R. Brykczynski
  • Fred Friedman
  • Kerry Hilliard
  • Kevin Heatwole

Organizations

  • Institute for Defense Analyses

Tags

Communities of Interest

  • C4I

DTIC Thesaurus Topics

  • Application Software
  • Classification
  • Compilers
  • Computer Programming
  • Computers
  • Database Management Systems
  • Databases
  • Debugging
  • Domain Specific Programming Languages
  • High Level Languages
  • Language
  • Libraries
  • Programming Languages
  • Relational Database Management Systems
  • Software Development
  • Specifications
  • Standards

Fields of Study

  • Computer science
  • Engineering

Readers

  • Computer Science.
  • Database Systems and Applications