Welkom...

~ * ~

 

home

database administration
en performance tuning

checklist SQL Server
performance tuning

datawarehousing
en reporting

ontwerp en
ontwikkeling

training en
opleiding

curriculum vitae

website gebouwd door Paul van Oordt Laatst gewijzigd:
3 sep 2010

 drs Paul van Oordt MCITP-dba MCT

Freelance SQL Server specialist gevestigd te Utrecht
info@vanoordt.nl
06 27 400 408

Van Oordt IT - vrij naar Picasso


ADATP-3


Project description

ADatP-3 is the NATO standard for formatted messages and can be seen as the military version of Electronic Data Interchange, EDI. The standard consists of an 'abstract' and a 'specific' part. The specific part is a complex system of formatting rules, and is periodically delivered by NATO in a database. The abstract part describes the form these formatting rules can take.

From 1998 untill 2000 I have, together with a number of other people, developed a completely generic tool set for ADatP-3 formatted messages, based on an Oracle database. The tool set includes an interactive editor and related applications such as a writer and a reader (or loader). The tool set being generic means that any set of formatting rules that complies to the abstract ADatP-3 standard is supported. The tools that are developed read in these specific rules and allow the end user work to comply with the rules. Thus the end user will for instance be able to create valid messages. All of them. And no others.


My role

My role in this project has been:

  • team leader

  • doing the analysis of the ADatP-3 standard and writing all functional specifications

  • design of the database that contains the messages (rather than the formatting rules)

  • design and programming of dataconversion and integrity checking routines for the NATO delivered database in PL/SQL

  • design and realisation of a PL/SQL code generator (actually a sort of compiler) for the 'structural relations' in Prolog

  • writing a significant part of the SQL*Forms code for the message editor

  • programming a message loader and explanation routine in Prolog after a previously built PL/SQL version proved to perform unsatisfactory

  • implementing various other performance related measures

I have worked on this project for extensive periods from early 1998 through the end of 2000. (It was a pleasure.)

The project was commisioned by the Netherlands Royal Navy.