Scalable Database Design of End-Game Model with Decoupled Countermeasure and Threat Information

Report No. ARL-TR-8216
Authors: Decetria Akole and Michael Chen
Date/Pages: November 2017; 64 pages
Abstract: An input file to End-Game Model (EGM) in active protection system simulations contains coupled countermeasure (CM) and threat information, the data structure of which possesses significant shortcomings in scalability given rapidly growing threats. For instance, accounting for 3 CMs and 50 threats requires 150 separate input files, which is hardly manageable. This report describes a systematic study of a relational database development, an approach that can consolidate all threat information into one individual table. This investigation began with analyzing existing Excel files, organizing component structures, distinguishing multivalued attributes, and identifying data dependency. A number of individual entity-relationship diagrams were iteratively developed followed by implementation of the corresponding relational schemas and table designs. Microsoft Access was adopted to construct the EGM database, where referential relationships can be enforced to ensure data integrity. After migration of the EGM data into the Access tables, C++ code employing an object linking and embedding database connection along with a series of standardized query language statements was created for data retrieval. Scalability was demonstrated that the required number of tables is linearly proportional to the number of CMs. Best of all, information of an emerging threat for EGM analysis can be accommodated with only one additional record in the threat table.
Distribution: Approved for public release
  Download Report ( 0.000 MBytes )
If you are visually impaired or need a physical copy of this report, please visit and contact DTIC.

Last Update / Reviewed: November 1, 2017