Scalable Database Design of End-Game Model with Decoupled Countermeasure and Threat Information
Technical Report,05 Jun 2017,11 Aug 2017
US Army Research Laboratory Adelphi United States
Pagination or Media Count:
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 plus plus 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.
- Information Science
- Military Operations, Strategy and Tactics