We could use scripting (probably Python) to either create CSV files, SQL instructions, or pushing data direct to the database.
The scripting would follow this model:
when fired, the script will create the indicated number of wargames
a wargame will last from 2 days to 20 days
a wargame will be broken down in to 2-10 phases
a phase will be broken down into 2-6 serial
a wargame will have 2-6 ships, and 0-3 submarines
there is a 60% chance that any platform will participate in a serial
there is a 25% chance that a ship will have a helicopter
ships will have 8 sensors, submarines and helicopters 4 sensors
we will create State observations 24 hours per day for ships & submarines, and a frequency from 1 second to 5 minutes. (See later note on producing track data)
we will create contact measurements for a period from 5 minutes to 6 hours. There is a 10% chance of a contact being made from each sensor at a random point during a day
Producing track data
For each required period of track data, perform the following:
if it's the first point recorded for this platform in this task, create a random point between 0n and 70N and 0W and 60W. Also choose a random course and a random speed (within the range described below)
if it's not the first point, retrieve the last measured state and apply the following:
there is a 5 % chance of a course change to a new course that is +/- 10 degrees of the current course
there is a 2 % chance of a course change to a completely new random course
there is a 1% chance of a speed change of 1 - 2 m/s, up or down, within the constraints
using this course and speed data, generate a new position value.
Once a working database is available, start to produce representative measurement data.
This may be through one or more of:
Using existing vehicle motion records
Ian has two Excel workbooks that contain real measured data. Each workbook contains the tracks for 3 platforms, with lots of sensor data.
We can create multiple version of these tracks using the following modifications
Note: the python function to calculate new points is described here: https://stackoverflow.com/questions/24427828/calculate-point-based-on-distance-and-direction
Or, there is a database of taxi journeys here: https://onedrive.live.com/?authkey=%21ADgmvTgfqs4hn4Q&id=CF159105855090C5%211438&cid=CF159105855090C5
Using scripting
We could use scripting (probably Python) to either create CSV files, SQL instructions, or pushing data direct to the database.
The scripting would follow this model:
Producing track data
For each required period of track data, perform the following:
Platform speeds