NEO νλ‘μ νΈ λλ―Έ λ°μ΄ν° μμ½
λλ€ μλ: 42 (μ¬ν κ°λ₯)
μμ±λ νμΌ λͺ©λ‘:
- fan_users.csv β ν¬ μ¬μ©μ λ°μ΄ν° (2,000,000건)
- star_info.csv β μ€ν μ 보 λ°μ΄ν° (10,000건)
- star_users.csv β μ€ν μ¬μ©μ λ°μ΄ν° (10,000건)
- star_types.csv β μ€ν μ ν λ°μ΄ν° (μ½ 15,000~30,000건)
- follow_relationships.csv β νλ‘μ° κ΄κ³ λ°μ΄ν° (μ½ 600,000,000건)
λ°μ΄ν° νΉμ§:
- ν¬ κ³μ : 200λ§ κ° (role_type='F')
- μ€ν κ³μ : 1λ§ κ° (role_type='S')
- μ€ν μ ν: YOUTUBER, SINGER, ACTOR, SNS_INFLUENCER
- μμ 50% μ€ν: 8~12λ§ νλ‘μ 보μ
- νμ 50% μ€ν: 1μ²~5λ§ νλ‘μ 보μ
- κ° μ€νλ 1~3κ°μ μ ν 보μ
- μ€ν κ° νλ‘μ° κ΄κ³ μ‘΄μ¬ (κ° μ€νλΉ 10~50λͺ
)
- λμΌν μλ(42) μ¬μ© μ λμΌν λ°μ΄ν° μμ±λ¨
MySQL LOAD DATA μμ:
LOAD DATA INFILE 'fan_users.csv'
INTO TABLE user
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
μ€ν-ν¬ κ΄κ³ 6μ΅κ±΄ μ±λ₯ ν₯μλ²