Traditional RDBMS such as Mysql (MyISAM/InnoDB),PostgreSQL, MsSQL,Oracle, Ingres ,... is not suitable for storing huge amount of data that use mostly for aggregation and Analysis. New competition has started between Analysis DB to use new technologies in storing and data processing such as column-oriented (C-store) , MPP.
Curently, I tried and death compare two OpenSource one, Infobright (Knowledge Grid, Columnar Stores)and Ingres VectorWise (modern CPU-tuned vectorized query execution and C-Store) beside MySQL(MyISAM) and PostgreSQL.
I will publish this result in near future.
To be continue ...