Spring Boot integrated starrocks quick start demo

1. What is StarRocks?

StarRocks isA next-generation ultra-fast all-scenario MPP (Massively Parallel Processing) database。 StarRocks’ vision is to enable users to:Data analysis has become simpler and more agile。 Users can use StarRocks to support ultra-fast analysis in a variety of data analysis scenarios without complex preprocessing. StarRocks The architecture is simple, with a comprehensive vectorization engine and a newly designed CBO (Cost Based Optimizer) optimizer.The query speed, especially multi-table association queries, far exceeds similar products。 StarRocks can well support real-time data analysis and realize efficient query of real-time updated data. StarRocks also supports modern materialized views to further accelerate queries. With StarRocks, users can flexibly build various models, including large and wide tables, star models, and snowflake models. StarRocks is compatible with the MySQL protocol, supports standard SQL syntax, is easy to interconnect and use, has no external dependencies on the whole system, is highly available, and is easy to operate and manage. StarRocks is also compatible with a wide range of popular BI products, including Tableau, Power BI, FineBI, and Smartbi. StarRocks is a Linux Foundation project under the Apache 2.0 license, which can be found in the StarRocks GitHub repository (see StarRocks License）。 StarRocks(i) links or calls functions from third-party software libraries, the license of which is available at licenses-binary folder; and (ii) contains third-party software code, the license of which is available at: licenses folder.

Applicable scenarios​

StarRocks can meet the various analysis needs of enterprise users, including OLAP (Online Analytical Processing) multi-dimensional analysis, customized reports, real-time data analysis, and ad-hoc data analysis.

OLAP multidimensional analysis​

Using StarRocks’ MPP framework and vectorization execution engine, users can flexibly choose from snowflake models, star models, wide table models, or pre-aggregation models. It is suitable for flexible configuration of multi-dimensional analysis reports, including business scenarios:

• User behavior analysis
• User portraits, tag analysis, tag tags
• High-dimensional business indicator reports
• Self-service reporting platform