You should store your values as whatever type they are (int, boolean, char) and your times as either date, or int containing the UNIX timestamp, whatever fits your application better.

• What is the best way to store a series of images in MySQL?

  I've been working on a SQL model for my website, and I'm really conflicted on how to store these images in my database for use around the site. First, each profile will contain a relevant 10 imag…

• What's a succinct, useful and efficient way to store large time-series in F#?

  I'm currently learning F# and I'm exploring using it to analyse financial time-series. Can anyone recommend a good data structure to store time-series data in? F# offers a rich selection of nativ…

• What is the best/correct/most efficient way to store a data series in XML

  I have an application which will store a series of (float) values in an XML file. There could be upwards of 100,000 values so I am interested in keeping the size down, but I also want files to be re…

• What is the best practice of handling time series in R?

  I am using R for some statistical analysis of time series. I have tried Googling around, but I can't seem to find any definitive answers. Can any one who knows more please point me in the right dire…

• What is the most efficient data structure to store time series of partially changing array?

  My problem is I have an array of objects of size N. after every time (t+1), some of the values of the array may or may not change. so lets say t+1 index 15 changes but everything else stays the same…

• What is the best way to store duration in MySQL

  I need to store duration (number of minutes and/or hours and/or days). I have looked at MySQL type, but DATE and TIME types seems to be used to store a specific date in time. Not a duration. I th…

• How to implement a time series sampler in MySQL system?

  I want to record the growth rate of values in columns of MySQL table. What is the quickest way to implement a sub-program that automatically writes the values to another table at given-time inter…

• combining 2 time series

  I am working with price data for futures contracts. I have data for Dec. 2010 and Mar. 2011, that I have loaded into the db. I want to generate a flat file with the time series that includes both co…

• Is it possibile to arrange a time series in the way that a specific autocorrleation is created?

  I have a file containing 2,500 random numbers. Is it possible to rearrange these saved numbers in the way that a specific autocorrelation is created? Lets say, autocorrelation to the lag 1 of 0.2, a…

• Which is the best datatype to store time in SQL?

  Here's my table right now (using mysql): SQL Table: koko_table name varchar(140) status varchar(140) time TIMESTAMP My issue basically is , I have a form (using php) which user uses to sto…