: This IDA Memorandum Report identifies and describes a version of software delivery, the Ada/SQL... more : 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...
: IDA Memorandum Report M-361 contains the source code for the demonstration software which imple... more : IDA Memorandum Report M-361 contains the source code for the demonstration software which implements the specification found in IDA memorandum Report M-360, Level 1 Ada/SQL Database Language Interface User's Guide. M-361 will be used to provide the actual means of accessing the relational database UNIFY with the Ada language. This software demonstrates an interface between Ada and the database language SQL as implemented by the UNIFY database package. An interface between Ada application programs and the UNIFY database was identified as a necessary capability which must be demonstrated to show that Ada applications can be integrated with the DLA operational environment. This interface implements a subset of the ANSI SQL standard which reflects the current implementation of SQL by the UNIFY. However, this software can be easily upgraded to support an ANSI implementation of SQL when it is acquired by the DLA.
The purpose of IDA Memorandum Report 459 is to identify and describe a version of a software deli... more The purpose of IDA Memorandum Report 459 is to identify and describe a version of a software delivery, "An Oracle-Ada/SQL Implementation," to the WIS Joint Program Management Office. The term version is applied to the initial release as well as to all interim changes. This report was written to describe the software developed to satisfy deliverable 5.a under task order T-W5-206, entitled WIS Application Software Study. The purpose of this software system is to provide a Level I Ada/SQL implementation which interacts with the Oracle® database management system. This software provides the ability to define Ada/SQL Data Definition Language (DDL) and Ada/SQL Data Manipulation Language (DML) which will be converted into the appropriate SQL calls required by the Oracle DBMS. 9 ORACLE is a registered trademark of Oracle Corporation.
Abstract : The purpose of this IDA Memorandum Report is to present a binding specification betwee... more Abstract : The purpose of this IDA Memorandum Report is to present a binding specification between the programming language Ada and the database language SQL(Structured Query Language). This document will be used to provide a capability for accessing a relational database from the Ada language and will provide a cross reference between the Ada/SQL language and the SQL language. As a user's guide, M-360 addresses the functionality of the ANSI SQL standard and identifies a subset implementation of it as Level 1. A Level 1 implementation was delivered to the DLA for use with a database package that is intended for regional administrative systems. An Ada application prototype will be implemented to demonstrate software engineering using Ada in the environmental provided for these regional administrative systems. In addition, an IDA Memorandum Report M-361 has been published as a companion document which provides the source listings for the demonstration software that implements this Level 1 version of Ada/SQL.
IDA publishes the following docuinet to riWs tUN resutS O ts l work. Reports Reput wem toe most a... more IDA publishes the following docuinet to riWs tUN resutS O ts l work. Reports Reput wem toe most amoultativa Wad momsFt ca IVll c mal o d "ad IDA publihs. TGmayusaly 11mbo uutatmajerprajeo otswi(al hwaa dirctbearle g dlae a~oo4n MOWm prOgaM, aW (b) ad*=n faulen of siguflial cmmca ta the Exacaiv Urauch, the Caurs I udir the pubis, ar (cl addre intentm Mad have sigicast acaig-is Implications. IDA Ragit ame ra0owe by Outside PaNel of o"gut to aura thiri h" qualKt &nd ratoauc to td oblm atM Udlo. and they are relased by Ona Presideut of IDA. Papers Papes s adraess relatively retrcta techicial or policy isues. maey communicate Mie resut 0s spec0al amalYsM. Inrm-pet itpms ar MUo a task. ad hoc or quick rste work. Pavers Wreviasewed to own. that they modt standardles allar to dMs expected of etie pagans in pruMeI ona jouals. Documents IDA Docasits ia used taier cnomea the ofIN p ona r Meto analyss to. reat subst-tiv wesk don In quick reacies stdies and major laftarclv teclical &u"port 8dvll o aNOW available preihlalluary and 1mi-ativ results at analse or of woring group and pail aclivtos; to forardi Infaate d Is essentially unnalyzed and unevasated: at to make a isooI at cantream mealigs, at briefings, or of data deveoped In toe course ofat-nvemtilgstioe. Review of Deomeate Is suited to their content: and Intended maheaut at IDA werk are aso cow"ye by briefings and inon..a memoranda to spanmors aid aimrsdsgaa by the aponsars, when appropiate. mae work ripostd In tis document was conducted under contract MDA 903894 C 0031 tf 1 tihe Department of Doenma. mae publicatio atils IDA document does not Indicate endorsmoet by tMe Departmnent of 0e.ens, nor shosuld tihe contents be costrued as reffecting the official pesiten of toad agenc.j [This IDA Docmen Is published In order to make available tho material it contains for die use aid-anveeonce at inatao parties. The material has not acmmrily been completly evalaed and analyzed, nat mubjected to IDA review. DISCILAINM OF WARRANTY AND UABUTY This Is experimental prototype sotware. It Is provided "as is" without warranty or representatimonfa any kind. The Institute tor Detense Analyses (IDA) diem nat warrant. guarantee, or make any rePOrMaoN regarding this 9o1iware with respec to correctnes, accuracy. reliability, merchantability, ftness tar a particular purpome. or odierwise. Users assume all risks in using thim software. Neliter IDA nor anyone els involved in the creation, proucin. ar dimtributian at thts software shall be liable tar any damage. injury, Of less resuling trom its use. whether such damage, injury, or loss is characterizeod as direct, Indirect. consequential. Incidental, special, or otherwise.
IDA publishes te tollowing documents to report the results ol Its work. Reports Reperhs are Owe m... more IDA publishes te tollowing documents to report the results ol Its work. Reports Reperhs are Owe meet autberttatve and most carefully considered products IDA publisbes. They ,ermaly Iuedy results ef majer prejects whis) hue a direct bearing on decisions aflecting major pregrams, er (b) address sam of W sant concer to the Executv Breach, the Coenes lam&e lon pulic, or (C) address Isues OWa have sighificaut econoemic 6 Implicatious. IDA Reporte awe reviewed by eutd panels of experts to ensere their high quality and relevace to te preblems studied, ad OhM Wre released by the President of IDA. Papers Pepsi ers mall fde! mi#stuhvl vntlc pcnt a"I ~ttt fs=e. Thai coinuw" the reus at special anayses, Interims repelts or phases at a task, ad hoc or quIck reacton work. Pper are reviwd to eur thaot they meet standards similar to those expected of refereed papers In professional joureale. Memorandum Reports IDA Memorandum Reports wre and let tire convenienceoa thes sposors or the anlst to record wsustv work don In qu"c reaction studies and major lint.ctve technilcal support aclvifow to mke available preliminary and tentativ results of analses or of working gra" and pael actiites to loawerd 1nt0matoo tha is oanfially uanalyzed and unevalvated; or to make a record of conference,. meetings, or briefings, oraof dat developed In thew c ofrs a Invesiation. Review of Memorandum Reports Is salted to their conen and Intended as. The results of IDA work are alas conveyed by briefingis and Informal memoranda to sponsore and ote~ deslinated by the sponsors, wher ppptae [The work repine In Nsi document was conducted under contract MDA 003 84 C 0031 tar1 the Department al Defense. The publication of this IDA document does not Indicate endorsmedt by thre Depotmnt of Deteons, nor should the contants he costud as reflectng the official posiion of that agenc.J I S MeOrendun Rueat Is Published In order to wake ailable the materiel It contains for the am and convenience d Interested parties. The materiel has not necessarily bean compiletly evaluated and analze, or subjected to IDIA rev.
: This IDA Memorandum Report identifies and describes a version of software delivery, the Ada/SQL... more : 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...
: IDA Memorandum Report M-361 contains the source code for the demonstration software which imple... more : IDA Memorandum Report M-361 contains the source code for the demonstration software which implements the specification found in IDA memorandum Report M-360, Level 1 Ada/SQL Database Language Interface User's Guide. M-361 will be used to provide the actual means of accessing the relational database UNIFY with the Ada language. This software demonstrates an interface between Ada and the database language SQL as implemented by the UNIFY database package. An interface between Ada application programs and the UNIFY database was identified as a necessary capability which must be demonstrated to show that Ada applications can be integrated with the DLA operational environment. This interface implements a subset of the ANSI SQL standard which reflects the current implementation of SQL by the UNIFY. However, this software can be easily upgraded to support an ANSI implementation of SQL when it is acquired by the DLA.
The purpose of IDA Memorandum Report 459 is to identify and describe a version of a software deli... more The purpose of IDA Memorandum Report 459 is to identify and describe a version of a software delivery, "An Oracle-Ada/SQL Implementation," to the WIS Joint Program Management Office. The term version is applied to the initial release as well as to all interim changes. This report was written to describe the software developed to satisfy deliverable 5.a under task order T-W5-206, entitled WIS Application Software Study. The purpose of this software system is to provide a Level I Ada/SQL implementation which interacts with the Oracle® database management system. This software provides the ability to define Ada/SQL Data Definition Language (DDL) and Ada/SQL Data Manipulation Language (DML) which will be converted into the appropriate SQL calls required by the Oracle DBMS. 9 ORACLE is a registered trademark of Oracle Corporation.
Abstract : The purpose of this IDA Memorandum Report is to present a binding specification betwee... more Abstract : The purpose of this IDA Memorandum Report is to present a binding specification between the programming language Ada and the database language SQL(Structured Query Language). This document will be used to provide a capability for accessing a relational database from the Ada language and will provide a cross reference between the Ada/SQL language and the SQL language. As a user's guide, M-360 addresses the functionality of the ANSI SQL standard and identifies a subset implementation of it as Level 1. A Level 1 implementation was delivered to the DLA for use with a database package that is intended for regional administrative systems. An Ada application prototype will be implemented to demonstrate software engineering using Ada in the environmental provided for these regional administrative systems. In addition, an IDA Memorandum Report M-361 has been published as a companion document which provides the source listings for the demonstration software that implements this Level 1 version of Ada/SQL.
IDA publishes the following docuinet to riWs tUN resutS O ts l work. Reports Reput wem toe most a... more IDA publishes the following docuinet to riWs tUN resutS O ts l work. Reports Reput wem toe most amoultativa Wad momsFt ca IVll c mal o d "ad IDA publihs. TGmayusaly 11mbo uutatmajerprajeo otswi(al hwaa dirctbearle g dlae a~oo4n MOWm prOgaM, aW (b) ad*=n faulen of siguflial cmmca ta the Exacaiv Urauch, the Caurs I udir the pubis, ar (cl addre intentm Mad have sigicast acaig-is Implications. IDA Ragit ame ra0owe by Outside PaNel of o"gut to aura thiri h" qualKt &nd ratoauc to td oblm atM Udlo. and they are relased by Ona Presideut of IDA. Papers Papes s adraess relatively retrcta techicial or policy isues. maey communicate Mie resut 0s spec0al amalYsM. Inrm-pet itpms ar MUo a task. ad hoc or quick rste work. Pavers Wreviasewed to own. that they modt standardles allar to dMs expected of etie pagans in pruMeI ona jouals. Documents IDA Docasits ia used taier cnomea the ofIN p ona r Meto analyss to. reat subst-tiv wesk don In quick reacies stdies and major laftarclv teclical &u"port 8dvll o aNOW available preihlalluary and 1mi-ativ results at analse or of woring group and pail aclivtos; to forardi Infaate d Is essentially unnalyzed and unevasated: at to make a isooI at cantream mealigs, at briefings, or of data deveoped In toe course ofat-nvemtilgstioe. Review of Deomeate Is suited to their content: and Intended maheaut at IDA werk are aso cow"ye by briefings and inon..a memoranda to spanmors aid aimrsdsgaa by the aponsars, when appropiate. mae work ripostd In tis document was conducted under contract MDA 903894 C 0031 tf 1 tihe Department of Doenma. mae publicatio atils IDA document does not Indicate endorsmoet by tMe Departmnent of 0e.ens, nor shosuld tihe contents be costrued as reffecting the official pesiten of toad agenc.j [This IDA Docmen Is published In order to make available tho material it contains for die use aid-anveeonce at inatao parties. The material has not acmmrily been completly evalaed and analyzed, nat mubjected to IDA review. DISCILAINM OF WARRANTY AND UABUTY This Is experimental prototype sotware. It Is provided "as is" without warranty or representatimonfa any kind. The Institute tor Detense Analyses (IDA) diem nat warrant. guarantee, or make any rePOrMaoN regarding this 9o1iware with respec to correctnes, accuracy. reliability, merchantability, ftness tar a particular purpome. or odierwise. Users assume all risks in using thim software. Neliter IDA nor anyone els involved in the creation, proucin. ar dimtributian at thts software shall be liable tar any damage. injury, Of less resuling trom its use. whether such damage, injury, or loss is characterizeod as direct, Indirect. consequential. Incidental, special, or otherwise.
IDA publishes te tollowing documents to report the results ol Its work. Reports Reperhs are Owe m... more IDA publishes te tollowing documents to report the results ol Its work. Reports Reperhs are Owe meet autberttatve and most carefully considered products IDA publisbes. They ,ermaly Iuedy results ef majer prejects whis) hue a direct bearing on decisions aflecting major pregrams, er (b) address sam of W sant concer to the Executv Breach, the Coenes lam&e lon pulic, or (C) address Isues OWa have sighificaut econoemic 6 Implicatious. IDA Reporte awe reviewed by eutd panels of experts to ensere their high quality and relevace to te preblems studied, ad OhM Wre released by the President of IDA. Papers Pepsi ers mall fde! mi#stuhvl vntlc pcnt a"I ~ttt fs=e. Thai coinuw" the reus at special anayses, Interims repelts or phases at a task, ad hoc or quIck reacton work. Pper are reviwd to eur thaot they meet standards similar to those expected of refereed papers In professional joureale. Memorandum Reports IDA Memorandum Reports wre and let tire convenienceoa thes sposors or the anlst to record wsustv work don In qu"c reaction studies and major lint.ctve technilcal support aclvifow to mke available preliminary and tentativ results of analses or of working gra" and pael actiites to loawerd 1nt0matoo tha is oanfially uanalyzed and unevalvated; or to make a record of conference,. meetings, or briefings, oraof dat developed In thew c ofrs a Invesiation. Review of Memorandum Reports Is salted to their conen and Intended as. The results of IDA work are alas conveyed by briefingis and Informal memoranda to sponsore and ote~ deslinated by the sponsors, wher ppptae [The work repine In Nsi document was conducted under contract MDA 003 84 C 0031 tar1 the Department al Defense. The publication of this IDA document does not Indicate endorsmedt by thre Depotmnt of Deteons, nor should the contants he costud as reflectng the official posiion of that agenc.J I S MeOrendun Rueat Is Published In order to wake ailable the materiel It contains for the am and convenience d Interested parties. The materiel has not necessarily bean compiletly evaluated and analze, or subjected to IDIA rev.
Uploads
Papers by Kerry Hilliard