Issue

Fernando ALONSO} : 0.8598169600854507
Charles LECLERC} : 0.8589560985565247
Lewis HAMILTON} : 0.8579143031682334
Oscar PIASTRI} : 0.8529107570648254
Esteban OCON} : 0.8471368257039713
  • DB์— 2026๋…„ Driver ๋ฐ์ดํ„ฐ๋ฐ–์— ์—†๋Š” ์ƒํ™ฉ์—์„œ, โ€œFerrari์— ์†ํ•ด์žˆ๋Š” Driver๋ฅผ ์•Œ๋ ค์ค˜โ€๋ผ๋Š” ์ฟผ๋ฆฌ์— ๋Œ€ํ•œ ๊ฒฐ๊ณผ
  • ์ƒ์œ„ 2๊ฐœ์˜ ๊ฒฐ๊ณผ๋ฅผ ๋ฝ‘๋Š” ํ…Œ์ŠคํŠธ์—์„œ, Fernando Alonso๊ฐ€ ํฌํ•จ๋˜๋Š” ์ด์Šˆ ๋ฐœ์ƒ

Cause

  • Driver ๋ฐ์ดํ„ฐ๋ฅผ ์ž„๋ฒ ๋”ฉํ•˜์—ฌ ์ €์žฅํ•˜๋Š” ๋กœ์ง์—์„œ ์‚ฌ์šฉํ•˜๋Š” ์ž„๋ฒ ๋”ฉ ๋ชจ๋ธ์ด ์ด๋ฏธ ํ•™์Šตํ•œ ์‚ฌ์ „ ์ง€์‹์— ๋”ฐ๋ผ, Fernando Alonso๊ฐ€ ์ด์ „์— Ferrari ์†Œ์†์ด์—ˆ๋‹ค๋Š” ์‚ฌ์‹ค์ด ์œ ์‚ฌ๋„ ์ ์ˆ˜๋ฅผ ๋†’๊ฒŒ ์‚ฐ์ถœํ–ˆ์Œ

Solution Candidates

  1. DB ๋ฐ์ดํ„ฐ๋งŒ ํ™œ์šฉํ•˜์—ฌ ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•˜๋Š” ๋ฐฉ์‹
    • Pros: ๊ตฌํ˜„ ๋‚œ์ด๋„๊ฐ€ ๋‚ฎ์Œ
    • Cons: ๊ฒ€์ƒ‰ ์ž์ฒด๊ฐ€ ์‹คํŒจํ•˜๋ฉด ํ‹€๋ฆฐ ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•˜๊ฒŒ ๋จ
  2. DB ๊ฒ€์ƒ‰ ๊ฒฐ๊ณผ๊ฐ€ ๋‚ฎ์œผ๋ฉด ๋ชจ๋ธ ์ง€์‹์„ ์‚ฌ์šฉํ•˜๋Š” ๋ฐฉ์‹
    • Pros: DB์— ์กด์žฌํ•˜์ง€ ์•Š๋Š” ์ผ๋ฐ˜ ์ƒ์‹ ๋‹ต๋ณ€ ๊ฐ€๋Šฅ
    • Cons: โ€œ์• ๋งคํ•˜๊ฒŒ ๋†’์€ ์ ์ˆ˜โ€์— ๋Œ€ํ•œ ์ฒ˜๋ฆฌ๊ฐ€ ๊ณค๋ž€ํ•จ, ์ฆ‰ ๊ธฐ์ค€์„ ์„ธ์šฐ๊ธฐ ์–ด๋ ค์›€
  3. ๋ฐ์ดํ„ฐ/์ฟผ๋ฆฌ์— ์ถ”๊ฐ€์ ์ธ ๋งฅ๋ฝ ์ถ”๊ฐ€
    • Pros: DB์— ์กด์žฌํ•˜์ง€ ์•Š๋Š” ์ผ๋ฐ˜ ์ƒ์‹ ๋‹ต๋ณ€ ๊ฐ€๋Šฅ
    • Cons: โ€œ์• ๋งคํ•˜๊ฒŒ ๋†’์€ ์ ์ˆ˜โ€์— ๋Œ€ํ•œ ์ฒ˜๋ฆฌ๊ฐ€ ๊ณค๋ž€ํ•จ, ์ฆ‰ ๊ธฐ์ค€์„ ์„ธ์šฐ๊ธฐ ์–ด๋ ค์›€

Solution: Text Enrichment & Context Injection

  • (์™„์„ฑ๋„) ํ˜„์žฌ์˜ ๋ฌธ์ œ์˜ ์›์ธ์€ ์˜๋ฏธ์  ๋ชจํ˜ธ์„ฑ์ด๊ธฐ ๋•Œ๋ฌธ์—, ๋ฐ์ดํ„ฐ์— ์‹œ๊ฐ„์  ์‚ฌ์‹ค์„ ๊ณ ์ •์‹œํ‚ค๋ฉด ๊ณผ๊ฑฐ์˜ Driver ๋ฐ์ดํ„ฐ์™€ ํ˜„์žฌ์˜ ๋ฐ์ดํ„ฐ๋ฅผ ๊ตฌ๋ถ„ ๊ฐ€๋Šฅ
  • (์œ ์ง€๋ณด์ˆ˜) ๋งŒ์•ฝ ์„œ๋น„์Šค๊ฐ€ ์˜๋„ํ•˜๋Š” ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•˜๊ธฐ ์œ„ํ•˜์—ฌ ๋ณ„๋„์˜ Fallback์„ ๊ตฌ์ถ•ํ•˜์ง€ ์•Š์•„๋„ ๋จ
  • Driver ๋ฐ์ดํ„ฐ์— Year ์ •๋ณด๋ฅผ ์ถ”๊ฐ€
  • drivers.description column์—๋„ ์—ฐ๋„ ์ •๋ณด๋ฅผ ์ถ”๊ฐ€ (Season ์ถ”๊ฐ€)
  • DriverMapper์— Season ๊ด€๋ จ ๋กœ์ง ์ถ”๊ฐ€
  • DriverPersistenceAdapter.saveDrivers()์—์„œ ์ค‘๋ณต ์ฒ˜๋ฆฌ ๋ฐ Season ๊ด€๋ จ ๋กœ์ง ์ถ”๊ฐ€
    • F1์—์„œ๋Š” ์‹œ์ฆŒ ์ค‘ ์ •๋ณด ๋ณ€๊ฒฝ์ด ๋งค์šฐ ๊ทนํžˆ ๋“œ๋ฌผ๊ฒŒ ์ผ์–ด๋‚˜๋ฏ€๋กœ Upsert(Update + Insert) ๋ฐฉ์‹ ์‚ฌ์šฉ