The use of MySQL's Archive table type in DW fact table

Watching Nicholas's blog today, I was encouraged to see an article that uses Mysql as a fact table in a data warehouse. Mysql is enough to build a large data warehouse. In this article, Nicholas gives an example of one of his clients. The customer uses Mysql as a data warehouse, which adds 200 million pieces of data every day, which can be said to be a huge amount of data. Due to the limited budget of the customer, Nicholas is expected to help solve the problem of excessive data storage space.

Nicholas proposes a solution using MySQL's Archive table type through a comparison case.

Original blog link to Nicholas: http://www.nicholasgoodman.com/bt/blog/2007/04/18/mysql-archive-tablespace-for-facts/

Download the case-related Kettle conversion file and mysql script:

Http://qinhui99.itpub.net/resource/2570/23302

Http://qinhui99.itpub.net/resource/2570/23303

You can do a test yourself, compare it, and see the power of the Archive table type.

[@ more@]