Naval ship database : database design, implementation, and schema / by Christopher Woo. : D68-5/157-2013E-PDF
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 Canada’s 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, timezone 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.
Lien permanent pour cette publication :
publications.gc.ca/pub?id=9.821204&sl=1
| Ministère/Organisme | Canada. Defence R&D Canada. |
|---|---|
| Titre | Naval ship database : database design, implementation, and schema / by Christopher Woo. |
| Titre de la série | Technical Note ; 2013-157 |
| Type de publication | Série - Voir l'enregistrement principal |
| Langue | [Anglais] |
| Format | Électronique |
| Document électronique | |
| Note(s) | "September 2013." Includes bibliographical references. |
| Information sur la publication | [Ottawa] : Defence Research and Development Canada, c2013. |
| Auteur / Contributeur | Woo, Christopher. |
| Description | x, 46 p. : figures, tables, graphs. |
| Numéro de catalogue |
|
| Descripteurs | Technical reports Dataset |
Demander des formats alternatifs
Pour demander une publication dans un format alternatif, remplissez le formulaire électronique des publications du gouvernement du Canada. Utilisez le champ du formulaire «question ou commentaire» pour spécifier la publication demandée.- Date de modification :