DATABASE - simple time series db

I am looking for a simple time series database. The sort of database that could take raw stock tick data for example and for company X and company Y in a split second return end of day data, or data at 3pm, or similar types of query. I dont know what google uses for http://www.google.com/finance?q=INDEXDJX however that's the sort of data and speed I am looking for. Some of the high end time series dbs cost the earth and do far more than I need. Are there opensource or nearly-free dbs out there that would be appropriate for this?

This question and answers originated from www.stackoverflow.com
Question by (11/30/2010 1:26:57 AM)

Answer

What amount of data are we talking about here?

I use MySQL to all my projects, including one where I actually collected all the stocks on OMX and NASDAQ every evening for about 2 years. MySQL had no problems at all to search and sort on my local machine.

MySQL are available in a community version (FREE) and if you need you can scale up and buy a license.

MySQL was first developed by a Swedish team (MySQL AB) and then first bought by Sun and later by Oracle.

Download the free MySQL at http://mysql.com/products/community/ and read about it on the Wiki.

Update

I saw that MySQL are used by big sites like Flickr, Facebook, Wikipedia, Google, Nokia.com and YouTube. I think this speaks for itself when it comes to how competent MySQL are.

Answer by
Find More Answers
Related Topics  database  time-series
Related Questions

  • Time series database for java?

    I want to store millions of time series entries (long time, double value) with Java. (Our monitoring system is currently storing every entry in a large mysql table but performance is very bad.) A…

  • key-value store for time series data?

    I've been using SQL Server to store historical time series data for a couple hundred thousand objects, observed about 100 times per day. I'm finding that queries (give me all values for object XYZ b…

  • Database suggestions for time series of events

    For one of my projects, I have to enter a big-ish collection of events into a database for later processing and I am trying to decide which DBMS would be best for my purpose. I have: About 4…

  • R Time series - having trouble making bollinger lines - need simple example please

    Learning R language - I know how to do a moving average but I need to do more - but I am not a statistician - unfortunately all the docs seem to be written for statisticians. I do this in excel a…

  • Storing time-series data, relational or non?

    I am creating a system which polls devices for data on varying metrics such as CPU utilisation, disk utilisation, temperature etc. at (probably) 5 minute intervals using SNMP. The ultimate goal is t…

  • Time series in R

    I am tracking my body weight in a spread sheet but I want to improve the experience by using R. I was trying to find some information about time series analysis in R but I was not succesful. The …

  • Relative Time Series

    I am looking for a standardized method for arranging data in relative time. Applications include accounting data such as FY1,FY2,etc... and economic data such as the term structure of interest rates…

  • time series in R

    here is my question: i have these data summary(data) Date 1990/01: 1 1990/02: 1 1990/03: 1 1990/04: 1 1990/05: 1 1990/06: 1 (…

  • Time-Series Data manipulation

    Can anybody suggest resources for time-series data manipulation. I'm not looking for time-series statistical analysis (e.g. ARIMA,Forcasting, etc). Instead, I want to extract a portion of data based…

  • Time Series Analysis

    Which R package is most helpful for irregular chrono time series? I see Lubridate and xts used in Regular analysis over irregular time series I understand that this is an open ended question and …