Archive for the ‘Data Warehousing’ tag
Infobright – Open source data warehousing
Keep your eyes on Infobright. They are doing some amazing things with redefining the Data Warehousing physical architecture. This is is the kind of thinking that needs to happen if Data Warehousing is ever going to be made available to the long-tail.
What Infobright is doing is creating a new MySQL database engine that you would use as opposed to MyISAM or InnoDB. This kind of low level optimization using column-based tables rather than row-based allows them to store terabytes of data at very high compression with very fast query times. This removes the need to perform common DW optimizations such as Materialized Views and Table Partitioning.
This product is still really young and has a ways to go before it’s ready for mainstream but it is definitely something to keep your eyes on.