API
API
DimensionLink

DimensionLink

์Šคํƒ€ ์Šคํ‚ค๋งˆ์˜ Dimension ํ…Œ์ด๋ธ” ์—ฐ๊ฒฐ ์ •์˜.
Fact ํ…Œ์ด๋ธ” ๋˜๋Š” ๋‹ค๋ฅธ Dimension ํ…Œ์ด๋ธ”์—์„œ Dimension ํ…Œ์ด๋ธ”๋กœ์˜ ์—ฐ๊ฒฐ์„ ์ •์˜ํ•œ๋‹ค.
ํ…Œ์ด๋ธ”์€ DataSet์— ๋“ฑ๋ก๋œ ์ด๋ฆ„์œผ๋กœ ์ฐธ์กฐํ•œ๋‹ค.

NameTypeDescription
aliasstring (opens in a new tab)ํ…Œ์ด๋ธ” ๋ณ„์นญ (์„ ํƒ์‚ฌํ•ญ).
์Šคํ‚ค๋งˆ์—์„œ ์ปฌ๋Ÿผ ์ฐธ์กฐ ์‹œ ์‚ฌ์šฉ (์˜ˆ: 'product.name')
์ƒ๋žต ์‹œ table ์ด๋ฆ„์„ alias๋กœ ์‚ฌ์šฉ.
๊ฐ™์€ ํ…Œ์ด๋ธ”์„ ์—ฌ๋Ÿฌ ์—ญํ• (role-playing)๋กœ ์“ธ ๋•Œ๋Š” alias๊ฐ€ ๋ฐ˜๋“œ์‹œ ๋‹ฌ๋ผ์•ผ ํ•œ๋‹ค.
foreignKeystring (opens in a new tab)FK(Foreign Key) ์ปฌ๋Ÿผ๋ช….
from์ด ์ƒ๋žต๋˜๋ฉด Fact ํ…Œ์ด๋ธ”์˜ ์ปฌ๋Ÿผ, ์ง€์ •๋˜๋ฉด ํ•ด๋‹น alias ํ…Œ์ด๋ธ”์˜ ์ปฌ๋Ÿผ์ด๋‹ค.
fromstring (opens in a new tab)FK๊ฐ€ ์œ„์น˜ํ•œ ์†Œ์Šค ํ…Œ์ด๋ธ”์˜ alias.
  • ์ƒ๋žต: Fact ํ…Œ์ด๋ธ”์˜ FK (์ˆœ์ˆ˜ star)
  • ๋‹ค๋ฅธ dimension alias: snowflake chain (ํ•ด๋‹น dim์—์„œ ์ด์–ด์ง€๋Š” link)
์ˆœํ™˜ ์ฐธ์กฐ๋Š” ํ—ˆ์šฉ๋˜์ง€ ์•Š๋Š”๋‹ค (DAG).
primaryKeystring (opens in a new tab)Dimension ํ…Œ์ด๋ธ”์˜ PK(Primary Key) ์ปฌ๋Ÿผ๋ช….
์ƒ๋žต ์‹œ ์ฒซ ๋ฒˆ์งธ ์ปฌ๋Ÿผ์„ PK๋กœ ์‚ฌ์šฉ.
tablestring (opens in a new tab)DataSet์— ๋“ฑ๋ก๋œ Dimension ํ…Œ์ด๋ธ” ์ด๋ฆ„.