A Conceptual Database Design and Performance Analysis of the MILSATCOM Requirements Database
Abstract
The Military Satellite Communications Decision Support System (MDSS) project for U.S. Space Command (USSPACECOM) is intended to provide decision makers an integrated information tool to effectively manage military satellite communication (MILSATCOM) resources while satisfying communications requirements. An important aspect of MDSS is the information provided by the MILSATCOM Requirements Database (MRDB). The objective of this thesis is twofold. First, it develops a new conceptual schema for the MRDB using the Entity Relationship Model and transforms it into a relational schema for implementation. Second, it conducts a comparative performance analysis to examine the tradeoffs between normalization and performance. This thesis concludes that a structured approach to designing the MRDB results in a normalized structure that is simple, easy to implement, and provides acceptable performance. A fully normalized database structure does not seem to have a significant impact on over-all MRDB retrieval performance.
Document Details
- Document Type
- Technical Report
- Publication Date
- Jun 01, 1993
- Accession Number
- ADA272672
Entities
People
- Ronald G. Kearns
Organizations
- Naval Postgraduate School