MySQL DW solution (MySQL + Infobright)

With the increasing importance of BI (DW) in various enterprises, various database manufacturers hope to get on this bus. This is not the case. MySQL also launched an open-source data warehouse solution together with Infobright, which is also open-source. The various DW functions implemented by this function are not mentioned much, but Infobright has some attractive technical characteristics.

With the increasing importance of BI (DW) in various enterprises, various database manufacturers hope to get on this bus. This is not the case. MySQL also launched an open-source data warehouse solution together with Infobright, which is also open-source. The various DW functions implemented by this function are not mentioned much, but Infobright has some attractive technical characteristics.

With the increasing importance of BI (DW) in various enterprises, various database manufacturers hope to get on this bus. This is not the case. MySQL also launched an open-source data warehouse solution together with Infobright, which is also open-source.

The various DW functions implemented by this function are not mentioned much, but Infobright has a very attractive technical feature that cannot be mentioned, that is, column-oriented architecture design.

The column-oriented architecture design is very suitable for DW application scenarios. For most DW analysis scenarios, the actual data is usually only one or a few columns of data. Therefore, in a column-oriented design, most analysis queries only need to read several columns of one (or several) table, instead of scanning the entire table data like a traditional behavior-oriented database (or storage engine), the IO volume gap between the two is very large. In addition to column-Oriented Architecture Design, Infobright also compresses data like many other DW solutions, and because of its column-oriented storage method, in many cases, the compression ratio is more effective than the behavior-oriented storage method. Some tests show that the compression ratio of common behavior-oriented storage data is about, but Infobright can easily achieve a compression ratio.

In addition to the technical features (or advantages) described above, MySQL and Infobright have many other amazing features, for example, the "Knowledge Grid" self-management function does not require indexing or partitioning, And the magic self-query optimizer.

Here is an official Infobright architecture diagram:

Infobright architecture

Interested friends can read their technical whitepaper to learn more.

Original article address: MySQL DW solution (MySQL + Infobright), thanks to the original author for sharing.