Best database for Time Series Data [slightly OT]

Scott, M Clay ScottMC at oge.com
Mon Sep 17 11:38:32 EDT 2001


While this is slightly off-topic in a general sense, it is on-topic from a
Python sense...

What is the best database to use for time-series data?  I work for an
electric utility in Load Research.  Load Research is the study of how
customers and groups of customers use energy.  It deals with large amounts
of time-series data (periodic meter readings on [typically] 15-minute
intervals).  The volume of data would be in the magnitude of 35,000 (for a
single meter) to 35,000,000 (for a group of 1,000 meters) data elements for
a single year.  Obviously, multiple years means more data.

I am looking to take advantage of Python for some of the data processing.
We currently use a package that utilizes Btreive which can be connected to
via ODBC.  However, I would like to know about other alternatives.

Is MySQL well-suited for this task?  What are other Python-able databases?
Which of these are good for time-series data?

Any direction provided will be greatly appreciated.

Thanks,

Clay Scott




More information about the Python-list mailing list