{"id":1948,"date":"2023-03-04T23:39:07","date_gmt":"2023-03-04T14:39:07","guid":{"rendered":"https:\/\/oboki.net\/workspace\/?p=1948"},"modified":"2025-11-18T23:45:34","modified_gmt":"2025-11-18T14:45:34","slug":"star-schema-vs-one-big-table-obt","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/data-modeling\/star-schema-vs-one-big-table-obt\/","title":{"rendered":"Star Schema vs. One Big Table (OBT)"},"content":{"rendered":"<p>DW \ub370\uc774\ud130 \ubaa8\ub378\ub85c \uc720\uc11c\uae4a\uc740(?) \ub450 \uac00\uc9c0\uc5d0 \uad00\ub828\ud55c \ub808\ub527 \uc2a4\ub808\ub4dc\uac00 \uc788\uc5b4\uc11c \uc2a4\ud06c\ub7a9<\/p>\n<blockquote>\n<p><a href=\"https:\/\/www.reddit.com\/r\/dataengineering\/comments\/11xjsyl\/how_would_you_choose_between_star_schema_vs_one\/\">How would you choose between star schema vs one big table (OBT) data models for big data reporting without explicit enterprise data warehouse requirements?<\/a><\/p>\n<\/blockquote>\n<p>\uc0c1\ud669\uc5d0 \ub530\ub77c, \uac1c\uc778\uc5d0 \ub530\ub77c \uc120\ud638\ub418\ub294 \ubc29\uc2dd\uc774 \uc788\ub294 \uac83 \uac19\uc740\ub370 \uae30\ud68c\uac00 \ub418\uba74 \uc815\ub9ac\ud574\ubd10\uc57c\uaca0\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DW \ub370\uc774\ud130 \ubaa8\ub378\ub85c \uc720\uc11c\uae4a\uc740(?) \ub450 \uac00\uc9c0\uc5d0 \uad00\ub828\ud55c \ub808\ub527 \uc2a4\ub808\ub4dc\uac00 \uc788\uc5b4\uc11c \uc2a4\ud06c\ub7a9 How would you choose between star schema vs one big table (OBT) data models for big data reporting without explicit enterprise data warehouse requirements? \uc0c1\ud669\uc5d0 \ub530\ub77c, \uac1c\uc778\uc5d0 \ub530\ub77c \uc120\ud638\ub418\ub294 \ubc29\uc2dd\uc774 \uc788\ub294 \uac83 \uac19\uc740\ub370 \uae30\ud68c\uac00 \ub418\uba74 \uc815\ub9ac\ud574\ubd10\uc57c\uaca0\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[220],"tags":[],"class_list":["post-1948","post","type-post","status-publish","format-standard","hentry","category-data-modeling"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1948","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1948"}],"version-history":[{"count":0,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1948\/revisions"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}