Naval Ship Database: Database Design, Implementation, and Schema

Abstract

This Technical Note documents a database that was designed and implemented to manage a collection of historical data housed by the Maritime Operational Research Team (MORT), which is part of Defence Research and Development Canadas Center for Operational Research and Analysis (DRDC CORA). The goals of the project included: improving integrity; allowing scalability; simplifying queries across existing datasets; and providing schema flexibility for new incoming data. The solution allows database users to store and analyze data collected by navy ships in the Royal Canadian Navy (RCN). The data stored in the database includes but is not limited to ship identification, ship log records, daily scheduled activities, distance made good, designated homeport, geolocation, readiness status, time zone reference changes, and observed weather. Multiple database storage solutions were compared and SQL Server was selected to be the one most suitable for the Naval Ship Database project. Future projects should consider SQL Server as the primary data storage system.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Sep 01, 2013
Accession Number
AD1016891

Entities

People

  • Christopher C Y Woo

Organizations

  • Defence Research and Development Canada

Tags

Communities of Interest

  • Ground and Sea Platforms

DTIC Thesaurus Topics

  • Barometric Pressure
  • Classification
  • Computers
  • Data Analysis
  • Data Management
  • Data Storage Systems
  • Database Management Systems
  • Databases
  • Domain Specific Programming Languages
  • Engineering
  • Graphical User Interface
  • Machine Learning
  • Machines
  • Operations Research
  • Relational Database Management Systems
  • Security
  • Systems Science

Fields of Study

  • Computer science

Readers

  • Canadian European Scientific Immigration and Epilepsy Clearance Studies
  • Database Systems and Applications
  • Maritime and Naval Warfare Studies