A conceptual database design and performance analysis of the MILSATCOM requirements database

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.

Department dc:contributor.department

Command, Control and Communications Academic Group

Grantor dc:publisher

Monterey, California. Naval Postgraduate School

Year dc:date.issued

1993

Author dc:creator

• Kearns, Ronald G.

Advisors dc:contributor.advisor

• Dolk, Daniel R.
• Kamel, Magdi N.

Statement dc:rights

• This publication is a work of the U.S. Government as defined in Title 17, United States Code, Section 101. Copyright protection is not available for this work in the United States.

Language dc:language.iso

en_US

Handle dc:identifier.uri

https://hdl.handle.net/10945/39799

OAI identifier oai:identifier

oai:calhoun.nps.edu:10945/39799