Wednesday, August 25, 2010

Analysis Database and Techniques Vs Traditional RDBMS

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 GridColumnar 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 ...

No comments:

Post a Comment