{"id":762,"date":"2022-05-15T14:22:01","date_gmt":"2022-05-15T14:22:01","guid":{"rendered":"http:\/\/happily70.dothome.co.kr\/?p=762"},"modified":"2022-05-15T14:22:01","modified_gmt":"2022-05-15T14:22:01","slug":"rdbms-vs-nosql","status":"publish","type":"post","link":"http:\/\/happily70.dothome.co.kr\/?p=762","title":{"rendered":"RDBMS vs NoSQL"},"content":{"rendered":"\n

RDBMS (\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c)<\/strong><\/h3>\n\n\n\n

– \ud14c\uc774\ube14 \ub9c8\ub2e4 \uc2a4\ud0a4\ub9c8\ub97c \uc815\uc758\ud574\uc57c \ud568.
– \ub370\uc774\ud130 \ud0c0\uc785\uacfc \uc81c\uc57d\uc744 \ud1b5\ud574\uc11c \ub370\uc774\ud130\uc758 \uc815\ud655\uc131\uc744 \ubcf4\uc7a5\ud568.
– \ub370\uc774\ud130\ub97c Column \uacfc Row \ud615\ud0dc\ub85c \uc800\uc7a5.
– SQL\uc774\ub77c\ub294 RDBMS\uc758 \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\uae30 \uc704\ud574 \uc124\uacc4\ub41c \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub97c \uc0ac\uc6a9\ud55c \uc9c8\uc758\ubb38\uc744 \ud1b5\ud574
\ub370\uc774\ud130\ub97c \ub2e4\ub8f0 \uc218 \uc788\uc74c.
– \ub370\uc774\ud130\uc758 update\uac00 \ube60\ub984.
– \ub370\uc774\ud130 \ucc98\ub9ac\uc5d0 \ub300\ud55c \ubd80\ud558 \ubc1c\uc0dd\uc2dc, \ucc98\ub9ac\uac00 \uc5b4\ub824\uc6c0.
– \uc131\ub2a5\uc744 \ub192\uc774\ub824\uba74 \ud558\ub4dc\uc6e8\uc5b4\ub97c \uace0\uc131\ub2a5\uc73c\ub85c \uad50\uccb4\ud574\uc57c \ud568.
(\uace0\uc131\ub2a5 \ud558\ub4dc\uc6e8\uc5b4\ub294 \uac00\uaca9\uc774 \ube44\uc2f8, RDBMS\uc758 \uc131\ub2a5\uc744 \ub192\uc774\uac70\ub098 \ud655\uc7a5\ud558\uae30 \uc5b4\ub824\uc6c0)
– \ud558\ub098\uc758 \uc815\ubcf4\ub97c \ub9cc\ub4e4\uae30 \uc704\ud574 \uc5ec\ub7ec \ud14c\uc774\ube14\ub85c \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uba70 \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0 \ud2b8\ub79c\uc7ad\uc158 \ucc98\ub9ac\ub97c \uc911\uc694\uc2dc \ud568.<\/p>\n\n\n\n

NoSQL<\/strong><\/h3>\n\n\n\n

– RDB\uc758 \ud655\uc7a5\uc131 \uc774\uc288\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub098\uc628 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub378\uc784.
– \ubd84\uc0b0 \ucef4\ud4e8\ud305 \ud65c\uc6a9\uc774 \ubaa9\uc801\uc73c\ub85c \ube44\uad50\uc801 \uc800\ub834\ud55c \uac00\uaca9\uc5d0 DB \uc131\ub2a5\uc744 \ub192\uc77c \uc218 \uc788\uc74c.
– \ub370\uc774\ud130\uac04\uc758 \uad00\uacc4\ub97c \uc815\uc758\ud558\uc9c0 \uc54a\uc73c\uba70, join\uc774 \ubd88\ud544\uc694.
– \ud14c\uc774\ube14\uc5d0 \uc2a4\ud0a4\ub9c8\uac00 \uc815\ud574\uc838 \uc788\uc9c0 \uc54a\uc544 \ub370\uc774\ud130 \uc800\uc7a5\uc774 \ube44\uad50\uc801 \uc790\uc720\ub85c\uc6b0\uba70
\ub370\uc774\ud130\uc758 \uad6c\uc870\uac00 \uac19\uc9c0 \uc54a\uc544\ub3c4 \uc601\ud5a5\uc744 \ubbf8\uce58\uc9c0 \uc54a\uc74c.
– key-value \ubc29\uc2dd\uc73c\ub85c \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\uba70, SQL\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc74c.
– \ub9ce\uc740 \uc591\uc758 \ub370\uc774\ud130\ub97c \uc800\uc7a5, \ucc98\ub9ac \ud560 \uc218 \uc788\uc74c.
– \uc2a4\ud0a4\ub9c8\uac00 \uc815\ud574\uc838 \uc788\uc9c0 \uc54a\uc544 \uad6c\uc870 \ubcc0\uacbd\uc774 \uc6a9\uc774\ud558\uace0 \ub370\uc774\ud130 \ud615\uc2dd\uc774 \ub2e4\uc591\ud558\uba70 \ubc14\uafb8\uae30 \uc26c\uc6cc
\uc815\ud655\uc131\ubcf4\ub2e4\ub294 \ub370\uc774\ud130 \uc591\uc774 \uc911\uc694\ud55c \ube45\ub370\uc774\ud130\uc5d0 \uc8fc\ub85c \uc0ac\uc6a9\ud568.
– \ub370\uc774\ud130\uc758 update\u001d\uac00 \ube44\uad50\uc801 \ub290\ub9bc.
– \ub370\uc774\ud130 \ubaa8\ub378\ub85c\ub294 \ub3c4\ud050\uba3c\ud2b8 \ubaa8\ub378, \uadf8\ub798\ud504 \ubaa8\ub378, \ud0a4\/\uac12 \ubaa8\ub378, \uc640\uc774\ub4dc \uceec\ub7fc \ubaa8\ub378\uc774 \uc788\uc74c.<\/p>\n\n\n\n

In-Memory DB<\/h4>\n\n\n\n

NoSQL \ubc29\uc2dd\uc5d0 \uc18d\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c key-value \ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\uc74c.<\/p>\n\n\n\n

– Memory\uc758 \uac00\uaca9\uc774 \uc6a9\ub7c9 \ub300\ube44, \ucda9\ubd84\ud788 \ub0ae\uc544\uc9c0\uba74\uc11c \ube60\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \uc704\ud574\uc11c \ub4f1\uc7a5\u001d\ud568.
– \ub514\uc2a4\ud2b8(Disk) \ub300\uc2e0 \uba54\ubaa8\ub9ac(Memory)\ub97c \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368, I\/O(input\/output)\uc758 \uc131\ub2a5\uc744 \ub192\uc5ec\uc90c.
– \ub300\ud45c\uc801\uc73c\ub85c Redis\u001d\uac00 \uc788\uc74c.<\/p>\n\n\n\n

RDB vs NoSQL<\/h3>\n\n\n\n

– RDB\ub294 \uad00\uacc4\ud615\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uc9c0\ub9cc, NoSQL\uc740 \uadf8\ub807\uc9c0 \uc54a\ub2e4.
– RDB\ub294 \uc2a4\ud0a4\ub9c8\uac00 \uc815\uc801\uc774\uc9c0\ub9cc, NoSQL\uc740 \uc720\uc5f0\ud55c \uc2a4\ud0a4\ub9c8 \uad6c\uc870\ub97c \uac16\ub294\ub2e4.
– RDB\ub294 \uc218\uc9c1 \ud655\uc7a5\uc774 \uc6a9\uc774\ud558\uace0, NoSQL\uc740 \uc218\ud3c9 \ud655\uc7a5\uc774 \uc6a9\uc774\ud558\ub2e4.
(\uc989, RDB\ub294 \uc11c\ubc84 \uc6a9\ub7c9\uc744 \ub298\ub9ac\ub294 \uac8c \uc27d\uace0, NoSQL\uc740 \uc11c\ubc84\ub97c \uc5ec\ub7ec \ub300 \ub298\ub9ac\ub294 \uac8c \uc27d\ub2e4)
– \uc704\uc640 \uad00\ub828\ud574\uc11c, RDB\ub294 \ud655\uc7a5 \uc2dc \ub2e4\uc6b4\ud0c0\uc784\uc774 \uc788\uc744 \uc218 \uc788\uc9c0\ub9cc, NoSQL\uc740 \uac70\uc758 \uc5c6\ub2e4.
– RDB\ub294 \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc640 Join \uc5f0\uc0b0\uc774 \uac00\ub2a5\ud558\ub2e4. NoSQL\uc740 \uad6c\uc870\ud654\ub41c \ucffc\ub9ac \uc5b8\uc5b4\uac00 \uc5c6\ub294 \uacbd\uc6b0\ub3c4 \ub9ce\uace0, \uc77c\ubc18\uc801\uc73c\ub85c Join\uc774 \uc5c6\ub2e4.
– RDB\ub294 OLTP\uc5d0 \uc801\ud569\ud558\uace0, NoSQL\uc740 OLAP\uc5d0 \uc801\ud569\ud558\ub2e4.
(\uc989, RDB\ub294 \ud2b8\ub79c\uc7ad\uc158 \ucc98\ub9ac\uc5d0 \uc6a9\uc774\ud558\uace0, NoSQL\uc740 \ubd84\uc11d \ucc98\ub9ac\uc5d0 \uc6a9\uc774\ud558\ub2e4)<\/p>\n\n\n\n

<\/p>\n\n\n\n

* OLTP
\uc9c1\uc5ed\ud558\uba74 \uc628\ub77c\uc778 \ud2b8\ub79c\uc7ad\uc158 \ucc98\ub9ac\ub97c \uc758\ubbf8.
\ubcf5\uc7a1\ud558\uac8c \ub9d0\ud558\uba74 \ubcf5\uc218\uc758 \uc0ac\uc6a9\uc790 PC\uc5d0\uc11c \ubc1c\uc0dd\ub418\ub294 \ud2b8\ub79c\uc7ad\uc158(Transaction)\uc744 DB\uc11c\ubc84\uac00 \ucc98\ub9ac\ud558\uace0, \uadf8 \uacb0\uacfc\ub97c \uc694\uccad\ud55c \uc0ac\uc6a9\uc790PC\uc5d0 \uacb0\uacfc\uac12\uc744 \ub418\ub3cc\ub824\uc8fc\ub294 \uacfc\uc815\uc744 \ub73b\ud568.<\/p>\n\n\n\n

\uc989, 1\uac1c\uc758 \ud2b8\ub79c\uc7ad\uc158\uc5d0\uc11c \ubc1c\uc0dd\ub418\ub294 INSERT, UPDATE, DELETE\uc758 \uacfc\uc815\uc744 \ubb34\uacb0\uc131\uc744 \ubcf4\uc7a5\ud558\uc5ec \ucc98\ub9ac\ud558\uace0 \uadf8 \uacb0\uacfc\ub97c SELECT \ud558\ub294 \uacfc\uc815\uc744 \ub9d0\ud568.<\/p>\n\n\n\n

* OLAP
\ub370\uc774\ud130\uc6e8\uc5b4\ud558\uc6b0\uc2a4(DW), \uc27d\uac8c \ub9d0\ud574 DB\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \ub370\uc774\ud130\ub97c \ubd84\uc11d\ud558\uace0, \ub370\uc774\ud130 \ubd84\uc11d\uc744 \ud1b5\ud574 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc720\uc758\ubbf8\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud574\uc8fc\ub294 \ucc98\ub9ac\ubc29\ubc95\uc744 \uc758\ubbf8.<\/p>\n\n\n\n

\uc989, \uae30\uc874\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\uc790\uc758 \uc694\uad6c\uc640 \ubaa9\uc801\uc5d0 \ub9de\uac8c \ubd84\uc11d\ud558\uc5ec \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\ub294 \uac1c\ub150\uc744 \uc758\ubbf8.<\/p>\n\n\n\n

* OLTP vs OLAP
OLTP\ub294 \ud604\uc7ac\uc758 \ub370\uc774\ud130 \ucc98\ub9ac\uac00 \uc5bc\ub9c8\ub098 \uc815\ud655\ud558\uace0, \ubb34\uacb0\ud55c\uc9c0\uac00 \uc911\uc694.
\uadf8\ub807\uae30 \ub54c\ubb38\uc5d0 \uc8fc\ub85c \ub370\uc774\ud130\uc758 \uc800\uc7a5, \uc0ad\uc81c, \uc218\uc815 \ub4f1\uc758 \uc2e4\uc9c8\uc801\uc778 \ub370\uc774\ud130\ub97c \uc218\uc815\ud558\ub294 \uc791\uc5c5\uc744 \uc758\ubbf8\ud558\ub294 \uc6a9\uc5b4.<\/p>\n\n\n\n

OLAP\ub294 \uc774\ubbf8 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \ubc14\ud0d5\uc73c\ub85c \uc5b4\ub5a4 \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\ub294\uc9c0\uac00 \uc911\uc694.
\ub530\ub77c\uc11c OLAP\ub294 \ub370\uc774\ud130\uac00 \ubb34\uacb0\ud558\uace0, \uc815\ud655\ud558\ub2e4\ub294 \uc804\uc7ac\ub97c \ubc14\ud0d5\uc73c\ub85c \uace0\uac1d \ub610\ub294 \uc0ac\uc6a9\uc790\uac00 \uc6d0\ud558\ub294 \uc815\ubcf4\ub97c \uc5b4\ub5a4\uc2dd\uc73c\ub85c \ud45c\ud604\ud558\uace0 \uc81c\uacf5\ud558\ub294\uc9c0\ub97c \uc758\ubbf8\ud558\ub294 \uc6a9\uc5b4.<\/p>\n","protected":false},"excerpt":{"rendered":"

RDBMS (\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c) – \ud14c\uc774\ube14 \ub9c8\ub2e4 \uc2a4\ud0a4\ub9c8\ub97c \uc815\uc758\ud574\uc57c \ud568. – \ub370\uc774\ud130 \ud0c0\uc785\uacfc \uc81c\uc57d\uc744 \ud1b5\ud574\uc11c \ub370\uc774\ud130\uc758 \uc815\ud655\uc131\uc744 \ubcf4\uc7a5\ud568. – \ub370\uc774\ud130\ub97c Column \uacfc Row \ud615\ud0dc\ub85c \uc800\uc7a5. – SQL\uc774\ub77c\ub294 RDBMS\uc758 \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\uae30 \uc704\ud574 \uc124\uacc4\ub41c \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub97c \uc0ac\uc6a9\ud55c \uc9c8\uc758\ubb38\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ub97c \ub2e4\ub8f0 \uc218 \uc788\uc74c. – \ub370\uc774\ud130\uc758 update\uac00 \ube60\ub984. – \ub370\uc774\ud130 \ucc98\ub9ac\uc5d0 \ub300\ud55c \ubd80\ud558 \ubc1c\uc0dd\uc2dc, \ucc98\ub9ac\uac00 \uc5b4\ub824\uc6c0. –<\/p>\n