{"id":1954,"date":"2024-04-27T21:18:58","date_gmt":"2024-04-27T12:18:58","guid":{"rendered":"https:\/\/oboki.net\/workspace\/?p=1954"},"modified":"2025-11-25T22:21:18","modified_gmt":"2025-11-25T13:21:18","slug":"one-big-table-vs-kimball-vs-relational","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/data-modeling\/one-big-table-vs-kimball-vs-relational\/","title":{"rendered":"One Big Table vs. Kimball vs. Relational"},"content":{"rendered":"<p>\uc2a4\ud0c0 \uc2a4\ud0a4\ub9c8\uc640 One Big Table \uc0ac\ub840 \ucc3e\uc544\uc11c \uacf5\ubd80\ud574\ubcf4\ub824\uace0 <a href=\"https:\/\/oboki.net\/workspace\/data-engineering\/data-modeling\/star-schema-vs-one-big-table-obt\/\">\uc2a4\ud06c\ub7a9<\/a>\ub9cc \ud574\ub450\uace0 \ud55c\ucc38 \ubbf8\ub904\ub480\uc5c8\ub294\ub370 \ub9c8\uce68 \uc88b\uc740 \uc601\uc0c1\uc774 \uc720\ud22c\ube0c \uc54c\uace0\ub9ac\uc998\uc73c\ub85c \ucc3e\uc544\uc654\ub2e4.<\/p>\n<blockquote>\n<p><a href=\"https:\/\/youtu.be\/ltQgbSs99WU\">https:\/\/youtu.be\/ltQgbSs99WU<\/a><\/p>\n<\/blockquote>\n<p><strong>Data with Zach<\/strong> \ub77c\ub294 \ucc98\uc74c \ubcf4\ub294 \ucc44\ub110\uc778\ub370 \ud55c\ub54c Airbnb, Facebook\uc5d0\uc11c \uc77c\ud588\uace0 \uc9c0\uae08\uc740 <a href=\"https:\/\/www.dataexpert.io\">dataexpert.io<\/a> \ub77c\ub294 \uc628\ub77c\uc778 \ucf54\uc2a4 \uc6b4\uc601\uc790\uc778 \ub124\uc784\ub4dc \ub370\uc774\ud130 \uc5d4\uc9c0\ub2c8\uc5b4\uc778 \ub4ef\ud558\ub2e4.<\/p>\n<blockquote>\n<p><a href=\"https:\/\/github.com\/eczachly\">https:\/\/github.com\/eczachly<\/a><\/p>\n<\/blockquote>\n<h3>General Enterprise Data System Architecture<\/h3>\n<p>\uc544\ubb34\ud2bc \uc774 \uc601\uc0c1\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ub370\uc774\ud130 \ub808\uc774\ud06c \uae30\ubc18 \ub370\uc774\ud130 \uc2dc\uc2a4\ud15c \uc544\ud0a4\ud14d\ucc98\uc5d0\uc11c production -&gt; dimensional -&gt; obt \ud750\ub984\uc73c\ub85c \ud544\uc694\uc5d0 \ub530\ub77c \ucd94\uac00\ub85c \ub3c4\uc785\ud574\ub098\uac04\ub2e4. count the number of deleted posts that contain &quot;SQL sucks&quot; \uc640 \uac19\uc740 \uc694\uac74\uc744 \uac01 \ub370\uc774\ud130 \ubaa8\ub378\uc5d0\uc11c \uad6c\ud604\ud574\ubcf4\uace0 \ud55c\uacc4\uc810\uc744 \ub9c8\uc8fc\ud558\uba74\uc11c \uadf8 \ub2e4\uc74c \ub370\uc774\ud130 \ubaa8\ub378\ub85c \uc804\uac1c\ud574\ub098\uac00\ub294 \ud750\ub984\uc774\uc5b4\uc11c \uac01 \ub370\uc774\ud130 \ubaa8\ub378\uc758 \ud55c\uacc4\uc640 \ub2e4\ub978 \ub370\uc774\ud130 \ubaa8\ub378\uc758 \ud544\uc694\uc131\uc5d0 \ub300\ud574 \uc27d\uac8c \uc774\ud574\ud560 \uc218 \uc788\uc5c8\ub358 \uac83 \uac19\ub2e4.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/oboki.net\/workspace\/wp-content\/uploads\/2025\/11\/image-1764074403751.png\" alt=\"file\" \/><\/p>\n<h3>Relational Data Modeling<\/h3>\n<h4>Pros<\/h4>\n<ul>\n<li>Great for single entity access<\/li>\n<li>Great for adding small amounts of data via transactions<\/li>\n<li>Minimizes data duplicatoin<\/li>\n<\/ul>\n<h4>Cons<\/h4>\n<ul>\n<li>Analytical questions need many joins to solve<\/li>\n<li>You only have the latest state of the data<\/li>\n<\/ul>\n<h3>Kimball \/ Demensional Data Modeling<\/h3>\n<h4>Pros<\/h4>\n<ul>\n<li>Great for analytical access, especially converting into OLAP<\/li>\n<li>Great for analysis of large amounts of data and historycal data<\/li>\n<\/ul>\n<h4>Cons<\/h4>\n<ul>\n<li>Transactions should be modeled relationally<\/li>\n<li>Updating individual records is laughable<\/li>\n<\/ul>\n<h3>One Big Table Data Modeling<\/h3>\n<h4>Pros<\/h4>\n<ul>\n<li>Can answer questions minimizing JOINs and shuffle<\/li>\n<li>Great for long-term analysis or replicating common big JOINs<\/li>\n<\/ul>\n<h4>Cons<\/h4>\n<ul>\n<li>Uses complex data types, hard to query<\/li>\n<li>Replicates and denormalizes data further, more data duplication<\/li>\n<\/ul>\n<p><\/p>\n<p>OBT\ub97c \uc124\uba85\ud560\ub54c\ub294 <code>Cumulative Table Design<\/code> \uc774\ub77c\ub294 \uac83\ub3c4 \uc18c\uac1c\ud574\uc8fc\ub294\ub370<\/p>\n<blockquote>\n<p><a href=\"https:\/\/github.com\/DataExpert-io\/cumulative-table-design\">https:\/\/github.com\/DataExpert-io\/cumulative-table-design<\/a><\/p>\n<\/blockquote>\n<p>\uc0ac\uc2e4 \uc6b0\ub9ac \ud68c\uc0ac\uc5d0\uc11c\ub294 \ub2e4\ucc28\uc6d0 \ubaa8\ub378\uc740 \uc0dd\ub7b5(?)\ud558\uace0 \ud504\ub85c\ub355\uc158 \ubaa8\ub378\uc5d0\uc11c \uace7\ubc14\ub85c OBT \ubaa8\ub378\uc744 \uc774\ub7f0 \ud615\ud0dc\ub85c \uad00\ub9ac\ud558\uace0 \uc788\uc5b4\uc11c \uc775\uc219\ud55c \ubc29\uc2dd\uc774\uc5c8\ub294\ub370 \uc774\ub807\uac8c \ubd88\ub9ac\ub294 \uc904\uc740 \ubab0\ub790\ub2e4. \uc77c\ub9c8\uac10 \ub370\uc774\ud130, \uc99d\ubd84 \ubc29\uc2dd \uc815\ub3c4\ub85c \uc18c\ud1b5\ud588\uc5c8\ub294\ub370 Cumulative Table Design \uc774 \uc77c\ubc18\uc801\uc778 \ud45c\ud604\uc778\uc9c0 \uc880 \ub354 \uc54c\uc544\ubcf4\uace0 \uc774\uac8c \ub354 \ub9de\ub294 \ud45c\ud604\uc774\ub77c\uba74 \uc774\ub807\uac8c \uc4f0\ub3c4\ub85d \ud574\uc57c\uaca0\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc2a4\ud0c0 \uc2a4\ud0a4\ub9c8\uc640 One Big Table \uc0ac\ub840 \ucc3e\uc544\uc11c \uacf5\ubd80\ud574\ubcf4\ub824\uace0 \uc2a4\ud06c\ub7a9\ub9cc \ud574\ub450\uace0 \ud55c\ucc38 \ubbf8\ub904\ub480\uc5c8\ub294\ub370 \ub9c8\uce68 \uc88b\uc740 \uc601\uc0c1\uc774 \uc720\ud22c\ube0c \uc54c\uace0\ub9ac\uc998\uc73c\ub85c \ucc3e\uc544\uc654\ub2e4. https:\/\/youtu.be\/ltQgbSs99WU Data with Zach \ub77c\ub294 \ucc98\uc74c \ubcf4\ub294 \ucc44\ub110\uc778\ub370 \ud55c\ub54c Airbnb, Facebook\uc5d0\uc11c \uc77c\ud588\uace0 \uc9c0\uae08\uc740 dataexpert.io \ub77c\ub294 \uc628\ub77c\uc778 \ucf54\uc2a4 \uc6b4\uc601\uc790\uc778 \ub124\uc784\ub4dc \ub370\uc774\ud130 \uc5d4\uc9c0\ub2c8\uc5b4\uc778 \ub4ef\ud558\ub2e4. https:\/\/github.com\/eczachly General Enterprise Data System Architecture \uc544\ubb34\ud2bc \uc774 \uc601\uc0c1\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ub370\uc774\ud130 \ub808\uc774\ud06c \uae30\ubc18 \ub370\uc774\ud130 [&hellip;]<\/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-1954","post","type-post","status-publish","format-standard","hentry","category-data-modeling"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1954","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=1954"}],"version-history":[{"count":0,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1954\/revisions"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}