University of OklahomaUniversity of OklahomaAerospace and Mechanical EngineeringAerospace and Mechanical Engineering

Demilitarization Knowledge Management Application for Transitioning the

Ammunition Stockpile

Tyrone Nordquist and Timothy IsenbergDefense Ammunition Center

Kurt Gramoll, Chris Dilorenzo

University of Oklahoma

In coordination with:

University of OklahomaCollege of Engineering

Center for EngineeringLogistics and Distribution

OU03-DAC1

University of OklahomaUniversity of OklahomaAerospace and Mechanical EngineeringAerospace and Mechanical Engineering

Goal:Develop a prototype Ammunition Knowledge Management system to automate the construction, maintenance and data retrieval for Ammunition Technology Trees used in the current MIDAS information system.

Current Situation:Technology Trees used to document demilitarization methods of ammunition is paper-based. Currently, there are 2,000-plus documents that need updating and distribution. Each document is a detailed flowchart graphic for possible demilitarization of that piece of ammunition.

Demilitarization Knowledge Management Application for Transitioning the

Ammunition Stockpile

University of OklahomaUniversity of OklahomaAerospace and Mechanical EngineeringAerospace and Mechanical Engineering

Demilitarization Knowledge Management Application for Transitioning the

Ammunition Stockpile

Technology Trees:To illustrate possible demilitarization of each piece of ammunition, a graphical flowchart is used by DoD.

University of OklahomaUniversity of OklahomaAerospace and Mechanical EngineeringAerospace and Mechanical Engineering

Demilitarization Knowledge Management Application for Transitioning the

Ammunition Stockpile

Problems with current Technology Tree system:1. Hard to distribute copies to the field

2. Difficult to update complex flowchart

3. Complex flowcharts requires trained personnel to update

4. Requires knowledge of Visio and PowerPoint to update

5. Can only be maintained by person that has source files

6. Cannot be automatically updated

University of OklahomaUniversity of OklahomaAerospace and Mechanical EngineeringAerospace and Mechanical Engineering

Demilitarization Knowledge Management Application for Transitioning the

Ammunition Stockpile

Proposed new Technology Tree system:1. Technology Tree Flowchart created automatically from

database2. All demilitarization information in database3. Internet-based Flash template used to create Flowchart in real-

time4. Flowcharts are accessed through a web browser 5. Data for new Technology Trees are added to database through

web interface6. Access to data is through secure MIDAS system (currently

used at DAC)7. Updates, changes, and additions to ammunition

demilitarization process done over the Internet.

University of OklahomaUniversity of OklahomaAerospace and Mechanical EngineeringAerospace and Mechanical Engineering

Demilitarization Knowledge Management Application for Transitioning the

Ammunition Stockpile

Benefits with new Technology Tree system:1. Real-time access to information through any web browser

2. Reduced time updating paper-based Flowcharts

3. Any authorized person can maintain system over the Internet

4. Consistent look and feel for all Technology Tree Flowcharts

5. Additional features can be added without having to redo all legacy paper-copy Flowcharts

University of OklahomaUniversity of OklahomaAerospace and Mechanical EngineeringAerospace and Mechanical Engineering

Demilitarization Knowledge Management Application for Transitioning the

Ammunition Stockpile

Internet Technology to be used:1. Flash Shockwave for Flowchart Template

2. Access Database (currently used at DAC) to store data

3. Web-server ASP scripts to access database through SQL commands and then send data to Flash Template

Technology Tree SystemWeb Page

Flash Object onWeb page

Broswer

ASPProgram

SQLCommands

AcessDatabase