OLAP-based solutions for RDBMS

How BI projects are developed:

Learn how OLAP is analyzed:

Multidimensional modeling analysis of data, that is, the design of their own data, then the program automatically generate the data of the square body

Data side body:

1. Automatic table structure, only the columns you need

2. Generate an SQL statement (with query criteria)

3. Cache sql, through your pre-defined multidimensional analysis, establish the relationship between the fact table and the dimension table, generate SQL is the cache SQL, and generate create Tabke statements

We are developing BI based on an RDBMS.

The next is the indicator for analysis:

Generate a report of the analysis results.

OLAP-based solutions for RDBMS