Vernay Laboratories--Tooling database

The tooling database was critical to this manufacturing company.  This design consolidated many diverse, older systems, and allowed different types of information to be stored flexibly for different tool types.  It performed reliably for 13 years. Jim Bailey  can provide a reference for this work.  This is one of the database layout pages.

 next     up
 

The tool editing and reporting system comprised about 75 pages of code, and provided flexible query capabilities not generally found in database applications of the early '80s.  It was written in DEC's Basic plus 2 language, which was only semi-structured.  It lacked an "endif" statement, for example, so that nested "if" statements had to be terminated with a line number, as you may note in the code below.  I managed to impose as much structure as possible under the circumstances....
 

next     up