occurs. This star like structure is often called “star connection”. It focuses on how users can complete requirements analysis more quickly, and has better response performance for large-scale complex queries. Based on the star model, the snowflake model can be further derived in complex scenes.
3. Multidimensional model
Multidimensional model is another implementation of dimensional model. When data is loaded into OLAP multidimensional database, the stored index of these data adopts the format and technology involved for dimensional data. Performance aggregation or precomputation summary tables are usually established and managed by the multidimensional database engine. Due to precomputation, Indexing Strategy and other optimization methods, multidimensional database can realize high-performance query.
4、 Data modeling case
1. Smartbi big data mining platform has rich and scalable algorithms
The data mining platform supports a variety of efficient and practical machine learning algorithms, including classification, regression, clustering, prediction and association. It contains a variety of trainable models: logical regression, decision tree, random forest, naive Bayes, support vector machine, linear regression, K-means, DBSCAN and Gaussian mixture model. In addition to providing main algorithms and modeling functions, the data mining platform also provides essential data preprocessing functions, including field splitting, row filtering and mapping, column selection, random sampling, filtering null values, merging columns, merging rows, joining, row selection, removing duplicate values, sorting, adding serial numbers, adding calculation fields, etc.
2. Smartbi big data mining platform is fully functional and seamlessly integrated into enterprise Bi applications
1) Suitable for large enterprises
Distributed cloud computing, linear expansion, guaranteed performance, seamless integration with Bi platform, one click release of mining models, model base to improve knowledge reuse, reduce repeated investment, support cross database query, unified control of data access, training automation and model self-learning.
2) Suitable for ordinary users
Intuitive flow modeling, minimalist node configuration interface, support visual exploration, easy understanding of data quality and data parallel, online help of process nodes, and automatic adjustment of model super parameters.
3) Professional algorithm ability
Built in 5 categories of mature machine learning algorithms, support text analysis and processing, support the use of Python to expand mining algorithms, and support the use of SQL to expand data processing capabilities.
3、 Smartbi big data mining platform is easy to learn and use, and can complete data processing and modeling in one stop