
11 Jun
2009
11 Jun
'09
2:57 p.m.
Dear Community, I plan to bulid a database of stock market data. The database structure is very simple, there will be a main table with columns like timestamp, stockID, price, volume. The size of the database is about 4 TB. I would like to use the database to search certain patterns, like "5% stock price change in 5 minutes", so all my queries will likely touch all the data in the database. Is MonetDB for me? Is it considerably faster than an OLTP database (Mysql, Oracle)? Another question: would you use cheap SATA hard drives for this, or is it worth to invest in 15k SAS drives? Is HDD an important performance factor? Thanks in advance for all your answers, Andras Bohak