Franklin Sun

Date of Award


Document Type


Degree Name

Master of Science


Department of Operational Sciences

First Advisor

Michael J. Garee, PhD


agement, development, and growth of U.S Air Force assets demand extensive organizational communication and structuring. These interactions yield substantial amounts of contracting and administrative information. Over 4 million such contracts as a means towards obtaining valuable insights on Department of Defense resource usage. This set of contracting data is largely not optimized for backend service in an analytics environment. To this end, the following research evaluates the efficiency and performance of various data structuring methods. Evaluated designs include a baseline unstructured schema, a Data Mart schema, and a snowflake schema. Overall design success metrics include ease of use by end users, database maintainability, and overall computational performance. Ease of use and maintainability are determined by examining the structural complexity of each schema. The resource demands raised by a set of benchmark queries are used to compare computational performance across schema. Results aggregated from this process suggest that the Data Mart schema is the strongest and most balanced design for this application.

AFIT Designator



A 12-month embargo was observed.

Approved for public release. Case number on file.