How does Kylin achieve the construction and updating of Cubes?
The process of building and updating Cubes in Kylin is as follows:
- Cube construction:
- Submit requests for Cube building through Kylin Web UI or REST API.
- Kylin generates metadata information for the Cube based on the design information and data from the data source.
- Kylin aggregates data based on Cube metadata information, grouping it according to predefined dimensions and measures to generate the Cube’s data model.
- Kylin stores Cube’s data model in HBase or other supported storage engines.
- Cube update:
- When the data in the data source changes, users can submit cube update requests through Kylin Web UI or REST API.
- Kylin will recalculate the data model of the Cube based on the update request, and store the new data model in the storage engine.
- If incremental data updates are needed for the Cube, Kylin will update the data model of the Cube based on the incremental data rather than recalculating the entire Cube.
By following the above steps, Kylin can achieve Cube construction and updating, thereby providing users with real-time OLAP analysis capabilities.