Author

Franklin Sun

Date of Award

3-2023

Document Type

Thesis

Degree Name

Master of Science

Department

Department of Operational Sciences

First Advisor

Michael J. Garee, PhD

Abstract

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

AFIT-ENS-MS-23-M-155

Comments

A 12-month embargo was observed.

Approved for public release. Case number on file.

Share

COinS