35、交通运输领域的数据维度与处理策略

交通运输领域的数据维度与处理策略

1. 乘客数据与航班信息维度

1.1 乘客信息

乘客信息表记录了每个乘客的相关属性，包括常客等级、家乡机场、俱乐部会员状态和终身飞行里程等。以下是部分乘客信息示例：
| Key | Tier | Home Airport | Club Membership | 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,000 - 2,999,999 miles |
| 2470