Database System Design and Implementation for Marine Air-Traffic-Controller Training

Abstract

This project focused on the design, development, and implementation of a centralized electronic database for air-traffic-controller (ATC) training within the Marine Corps. The Marine Corps currently has individual electronic training database-management systems at the unit level. The existing training database-management systems are client based, unstandardized, and have significant data-entry redundancy. We developed a centralized system that is scalable and capable of supporting detailed training statistics. We identified several critical features required for successful implementation and developed a system capable of importing and processing existing training data. We analyzed an existing training database-management system used at the unit level and developed methods for accurately exporting the existing system's stored generic data. We processed the raw data and properly migrated the data to a prototype database-management system, which involved processing for proper data integrity, database normalization, and enforcing unique record-identifier usage. We developed a front-end graphical user interface to interact with the developed system and the stored training data. Future system improvements include migration to a military network, adaptation by additional units, and full integration with the Navy's Visual Information Display System.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Jun 01, 2017
Accession Number
AD1046291

Entities

People

  • Anthony J. Ambriz

Organizations

  • Naval Postgraduate School

Tags

Communities of Interest

  • Biomedical
  • Cyber
  • Materials and Manufacturing Processes
  • Weapons Technologies

DTIC Thesaurus Topics

  • Air Traffic
  • Air Traffic Controllers
  • Basic Programming Language
  • Computer Programming
  • Computer Programs
  • Computer Science
  • Computers
  • Data Analysis
  • Data Displays
  • Database Management Systems
  • Databases
  • Display Systems
  • Graphical User Interface
  • Relational Database Management Systems
  • Training
  • Training Management
  • User Interface

Fields of Study

  • Computer science

Readers

  • Database Systems and Applications
  • Instructional Design and Training Evaluation.
  • Maritime Combat Support and Expeditionary Logistics.

Technology Areas

  • Microelectronics