Bi Cube's past life: why business Intelligence bi needs cube technology

There are often embarrassing scenes in an enterprise:

it it People need a lot of time to make reports. it The staff said finally can take a breath of time, the decision-makers have a new idea, come on, do the report again. To avoid this embarrassing situation, the multidimensional database ( cube

Cube, or multidimensional database, can be simply understood as: storing data in an N- dimensional array, rather than as a relational database in the form of records. A more typical example is the data cube, which allows users to explore and analyze datasets from multiple angles, typically taking three factors at a time (dimensions).

650) this.width=650; "Src=" http://dl2.iteye.com/upload/attachment/0117/0115/ Cb6ea6e2-1542-3194-852a-8e7b572a82be.png "style=" border:0px; "/>

If you keep the values of some axes of the cube unchanged and change one of the other axes, you can see how the data changes on different dimensions.

In the example above, if you keep the name and date of the product constant and move along the customer's city axis, you can get the full sales value of a product for a certain day in all customer cities. The general requirement for this analysis is the regional manager. Similarly, the data cube can be analyzed in different angles according to the different needs of the finance manager, product manager and general manager for the business analysis, such as:

650) this.width=650; "Src=" http://dl2.iteye.com/upload/attachment/0117/0117/ 353f227b-6bc3-39fa-8160-9abcbd2372b6.png "style=" border:0px; "/>

at the same time, we can perform further analysis-oriented operations on the cube. such as:

Prototype Cube:

650) this.width=650; "Src=" http://dl2.iteye.com/upload/attachment/0117/0119/ B4c251d5-6c5f-3082-a5e4-cb436ff6a1ef.png "style=" border:0px; "/>

650) this.width=650; "Src=" http://dl2.iteye.com/upload/attachment/0117/0121/ 947f03fe-b5ac-3bb4-b8a7-f84b5f716263.png "style=" border:0px; "/>

       

we drill through , roll up, slice, dice, and rotate data with cube technology to make data more analytical-oriented. These intuitive analyses help decision makers make the right decisions for the business.

Then when do we use cube sql go to the database to find, is very slow. How to do it in cube in advance, you need to aggregate the data you want, you don't have to run the database.

most new bi< on the market Span style= "Color:rgb (68,68,68); font-size:14px;" > is through sql this middle tier, although the number of hours has a certain advantage, but when the amount of data is larger, because the Sql finebi using the middle cube mode, The problem of big data is cleverly solved.

business intelligence Finebi using the cube technology, a combination of powerful data computing and convenience, enables multidimensional Analysis, interactive analysis, and drill-through analysis.

multidimensional database finecube using dynamic in-memory data cube technology, Advanced data processing mode for preprocessing and parallel computing, using nio memory mapped file storage mode, with efficient smart Bitmap index, and intelligent cache mechanism to avoid duplication, so that the front-end page to display data, fast and efficient speed, rapid, such as electricity. finecube Support the online Big Data volume analysis function, you can say finecube is Finebi The soul that deals with big data.

Multidimensional Analysis, interactive analysis, and drill-through analysis of big data will become the next generation of intelligent the theme of BI, and Cube Technology is the Soul note in this melody.

Bi Cube's past life: why business Intelligence bi needs cube technology