I am planing to dump the tick data from dukascopy into mssql database for offline statistical analysis.
I have heard people saying that relational database is not best suited for the time series data, but it is easy to do different query with some sql script, which save you time for writing code to analyze binary or csv data. So I decide to go the database way.
The data from dukascopy is:
time; bid; bid volume; ask; ask volume
so I am assuming naturally the sql table structure is:
time(datetime); double bid(decimal); bid volume(int); ask(decimal); ask volume(int)
for these who has done this, please advise.
I have heard people saying that relational database is not best suited for the time series data, but it is easy to do different query with some sql script, which save you time for writing code to analyze binary or csv data. So I decide to go the database way.
The data from dukascopy is:
time; bid; bid volume; ask; ask volume
so I am assuming naturally the sql table structure is:
time(datetime); double bid(decimal); bid volume(int); ask(decimal); ask volume(int)
for these who has done this, please advise.