Best database for Time Series Data [slightly OT]

Ignacio Vazquez-Abrams ignacio at openservices.net
Mon Sep 17 17:43:45 CEST 2001


On Mon, 17 Sep 2001, Scott, M Clay wrote:

> 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?

This is a cakewalk for MySQL. Other companies are using MySQL for comparable
amounts of data:

  http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_customer_usage.html

-- 
Ignacio Vazquez-Abrams  <ignacio at openservices.net>





More information about the Python-list mailing list