views:

17

answers:

0

Hi,

Can anyone advise on a database design/DBMS for storing 2D Time Series Matrix data. To allow for quick BACK END algebraic calculations: e.g:

Table A,B,C.. Col1: Date- Timestamp col2: Data- Array? (Matrix Data)

  • SQL Psuedo Code

INSERT INTO TABLE C SELECT Multiply A.Data A by B.Data Where Matrix A Start Date = Matrix B Start Date And Matrix A End Date = Matrix B End Date

Essentially set the co-ordinates for the calculation.