35、运输行业数据维度建模与日期时间处理

秃然暴富

于 2025-10-14 16:36:19 发布

阅读量22

点赞数

CC 4.0 BY-SA版权

分类专栏：维度建模的艺术与实践文章标签：运输行业数据维度建模日期时间处理

本文链接：https://blog.youkuaiyun.com/vscode6remote/article/details/154526056

维度建模的艺术与实践专栏收录该内容

59 篇文章 ¥499.90

订阅专栏¥69.90

会员秒杀 ¥9.9 重磅福利

超级会员免费看

运输行业数据维度建模与日期时间处理

在运输行业的数据管理和分析中，数据维度建模以及日期时间的处理是非常关键的环节。下面将详细探讨这些方面的相关内容。

1. 乘客数据维度

乘客数据维度包含了多个重要的信息，如下表所示：
| Key | Tier | Home Airport | Club Membership | Status | Lifetime Mileage |
| — | — | — | — | — | — |
| 1 | Basic | ATL | Non - Member | Under 100,000 miles | |
| 2 | Basic | ATL | Club Member | Under 100,000 miles | |
| 3 | Basic | BOS | Non - Member | Under 100,000 miles | |
| 789 | MidTier | ATL | Non - Member | 100,000 - 499,999 miles | |
| 790 | MidTier | ATL | Club Member | 100,000 - 499,999 miles | |
| 791 | MidTier | BOS | Non - Member | 100,000 - 499,999 miles | |
| 2468 | WarriorTier | ATL | Club Member | 1,000,000 - 1,999,999 miles | |
| 2469 | WarriorTier | ATL | Club Member | 2,000,0