Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    1

    Time series and events - best structure?

    I have a large amount of data from recordings (around 100Hz as well as 1Hz and less) and event data (time and event). I am wanting to know the best structure to use which will keep the size of the db down, enable easy searching of the data within the recordings (all records where the value is above X).

    At the moment I'm thinking of a simple relational design:
    Recording
    -RecordingID
    -Comments
    -EventID
    -SignalId

    Event
    -EventID
    -Time
    -Event
    -Comment

    Signal
    -SignalID
    -TimeSeriesID
    -SignalValuesID

    TimeSeries
    -TimeSeriesID
    -Values

    SignalValues
    -SignalValuesID
    -Values

    I'm not sure this is the best way - can anyone help please?

    Thanks,
    David

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    we're even less sure than you are, because you're familiar with what you're doing and we're not

    maybe if you gave several sample rows from each table so we could understand your data?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •