- Star/Snowflake Schema: Organizes data into fact and dimension tables for intuitive querying.
- Business-Oriented: Designed for ease of understanding by business users and analysts.
- Denormalized Structure: Optimized for performance in OLAP systems.
- Slowly Changing Dimensions (SCD): Handles historical changes in dimension data.
- Query Performance: Highly efficient for aggregations and slicing/dicing.
leorick.lin leoricklin
leoricklin
/ red_modeling_comparison.md
Last active
July 16, 2026 18:13
leoricklin
/ res_nifi.md
Last active
January 24, 2021 04:29
leoricklin
/ res_azure.md
Last active
August 26, 2022 10:32
- How does Microsoft Azure work, https://youtu.be/KXkBZCe699A
- Browse Architectures, https://docs.microsoft.com/en-us/azure/architecture/browse/
leoricklin
/ res_python.md
Last active
June 23, 2025 07:39
- 20180326 Overview of Pandas Data Types, https://pbpython.com/pandas_dtypes.html
leoricklin
/ res_docker.md
Last active
June 12, 2025 03:06
% sudo apt install docker.io
% sudo systemctl enable --now docker
% sudo docker --version
% service docker status
% sudo docker run hello-world
leoricklin
/ res_aliyun.md
Last active
June 28, 2021 02:21
leoricklin
/ PySpark DataFrame from many small pandas DataFrames.ipynb
Created
September 30, 2020 07:26
— forked from linar-jether/PySpark DataFrame from many small pandas DataFrames.ipynb
Convert a RDD of pandas DataFrames to a single Spark DataFrame using Arrow and without collecting all data in the driver.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
leoricklin
/ Learning Resources.md
Last active
January 26, 2026 09:29
- Application Architecture
- DDD
leoricklin
/ gist:44054f8c232e5b3f7123
Created
February 22, 2016 04:23
— forked from galleon/gist:5d48e8cec78582b01c0e
WordCloud
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import wordcloud.PolarWordCloud | |
| import wordcloud.CollisionMode | |
| import wordcloud.PolarBlendMode | |
| import wordcloud.bg.CircleBackground | |
| import wordcloud.bg.PixelBoundryBackground | |
| import wordcloud.bg.RectangleBackground | |
| import wordcloud.font.CloudFont | |
| import wordcloud.font.FontWeight | |
| import wordcloud.font.scale.LinearFontScalar | |
| import wordcloud.font.scale.SqrtFontScalar |
NewerOlder