000	02100nam  2200289za 4500
001	9.821204
003	CaOODSP
005	20240219183438
007	cr |||||||||||
008	160718s2013    onc|||||o    f000 0 eng d
040	|aCaOODSP|beng
041	|aeng|bfre
043	|an-cn---
086	1 |aD68-5/157-2013E-PDF
100	1 |aWoo, Christopher.
245	10|aNaval ship database |h[electronic resource] : |bdatabase design, implementation, and schema / |cby Christopher Woo.
260	|a[Ottawa] : |bDefence Research and Development Canada, |cc2013.
300	|ax, 46 p. : |bfigures, tables, graphs.
490	1 |aTechnical Note ; |v2013-157
500	|a"September 2013."
504	|aIncludes bibliographical references.
520	|aThis 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.
692	07|2gccst|aTechnical reports
693	4|aDataset
710	2 |aDefence R&D Canada.
830	#0|aTechnical note (Defence R&D Canada)|v2013-157|w(CaOODSP)9.820563
856	40|qPDF|s1.04 MB|uhttps://publications.gc.ca/collections/collection_2016/rddc-drdc/D68-5-157-2013-eng.pdf