{"id":10577,"date":"2021-02-16T09:00:15","date_gmt":"2021-02-16T17:00:15","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=10577"},"modified":"2021-02-10T06:05:47","modified_gmt":"2021-02-10T14:05:47","slug":"hands-on-migration-from-relational-to-collections","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/hands-on-migration-from-relational-to-collections\/","title":{"rendered":"\uad00\uacc4\ud615\uc5d0\uc11c \uceec\ub809\uc158\uc73c\ub85c\uc758 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc2e4\uc2b5"},"content":{"rendered":"<p>\uc774 \ube14\ub85c\uadf8\uc758 \ud575\uc2ec\uc740 \uad00\uacc4\ud615 \ub370\uc774\ud130\ub97c Couchbase\ub85c \uc27d\uac8c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\uc5ec TCO\ub97c \ub0ae\ucd94\uace0 \ub370\uc774\ud130 \ud50c\ub7ab\ud3fc\uc774 \ube60\ub978 \uc18d\ub3c4\ub85c \uc9c4\ud589\ub418\ub294 \ub9b4\ub9ac\uc988 \uc8fc\uae30\uc5d0 \ub300\uc751\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \ubc29\ubc95\uc744 \uc54c\ub824\ub4dc\ub9ac\ub294 \uac83\uc785\ub2c8\ub2e4! \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 \ub3d9\uc548 \ubc94\uc704\uc640 \uceec\ub809\uc158\uc744 \uc0ac\uc6a9\ud574 \uc774\ubbf8 \uad6c\uc131\ud55c \uac1c\ubcc4 \uc774\ub984\/\ud0a4\uc2a4\ud398\uc774\uc2a4\ub97c \uadf8\ub300\ub85c \uc720\uc9c0\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ube14\ub85c\uadf8\ub294 \ub2e4\ub978 \ube14\ub85c\uadf8\uc5d0\uc11c \uc124\uba85\ud55c \uc0c8\ub85c \ucd9c\uc2dc\ub41c \uae30\ub2a5\uacfc \ucd5c\uadfc \uc5c5\ub370\uc774\ud2b8 \ub0b4\uc6a9\uc744 \ub2e4\uc18c \ud1b5\ud569\ud55c \uac83\uc774\uc9c0\ub9cc, \ub2e4\ub978 \ube14\ub85c\uadf8\uc640 \ub2ec\ub9ac \uad00\uacc4\ud615 \ub370\uc774\ud130\ub97c Couchbase\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 \ubc29\ubc95\uc744 \uba87 \uac00\uc9c0 \uc608\uc2dc\ub97c \ub4e4\uc5b4 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n<p>Couchbase\uc758 \ud6cc\ub96d\ud55c \uc810 \uc911 \ud558\ub098\ub294 \ucee4\ubba4\ub2c8\ud2f0\uc758 \uc694\uad6c\uc5d0 \uc9c4\uc815\uc73c\ub85c \uadc0\ub97c \uae30\uc6b8\uc774\uace0 \uace0\uac1d\uc5d0\uac8c \ucd5c\uc0c1\uc758 \uacbd\ud5d8\uc744 \uc81c\uacf5\ud558\uae30 \uc704\ud574 \uc81c\ud488\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \uac1c\ubc1c\ud55c\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4. \uc774 \ube14\ub85c\uadf8\ub294 \ub530\ub77c \ud574\ubcf4\uace0 \uc2f6\uc73c\uc2e0 \ubd84\ub4e4\uc744 \uc704\ud574 '\uc2e4\uc2b5'\uc73c\ub85c \uc791\uc131\ud588\uc9c0\ub9cc, \ucd94\ucd9c \ub2e8\uacc4\ub97c \uac74\ub108\ub6f0\uace0 \uc81c\uac00 \uc81c\uacf5\ud55c TSV\ub85c \uc791\uc5c5\ud558\uc2e4 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4!<\/p>\n<p>\uc774 \uacfc\uc815\uc744 \ub530\ub77c\uac00\ub824\uba74 \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud560 RDBMS, \ud30c\uc774\uc36c \uc778\ud130\ud504\ub9ac\ud130, Couchbase \uc11c\ubc84(Docker, VM, \ubb3c\ub9ac\uc801 \ub4f1)\uac00 \uc804\uc81c \uc870\uac74\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub370\ubaa8 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc628\ub77c\uc778 \uc608\uc81c\ub97c \uc0ac\uc6a9\ud558\uaca0\uc2b5\ub2c8\ub2e4. Linked<a href=\"https:\/\/www.w3resource.com\/sql\/sql-table.php\"> \uc5ec\uae30<\/a> \ub294 \uace0\uac1d, \uc0c1\ub2f4\uc6d0, \uc8fc\ubb38\uc774\ub77c\ub294 \uc138 \uac1c\uc758 \ud14c\uc774\ube14\uc774 \uc788\ub294 \uc0d8\ud50c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc0c8\ub85c\uc6b4 \ubc94\uc704 \ubc0f \uceec\ub809\uc158 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc774\ube14 \uad6c\uc870\ub97c \ubaa8\ubc29\ud558\uc5ec \ub370\uc774\ud130\ub97c Couchbase\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 \uac83\uc740 \uc815\ub9d0 \uc27d\uc2b5\ub2c8\ub2e4. \uba3c\uc800 \ub17c\ub9ac\uc801 \uc800\uc7a5 \uacf5\uac04\uc774 \ud544\uc694\ud55c\ub370, \uc774 \uc608\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub2f9 \ud558\ub098\uc758 \ubc84\ud0b7\uc744 \uc0ac\uc6a9\ud558\ubbc0\ub85c \ubc84\ud0b7\uc744 \ud558\ub098\ub9cc \ub9cc\ub4e4\uba74 \ub429\ub2c8\ub2e4. \uc2a4\ud0a4\ub9c8\ub294 \uc2a4\ucf54\ud504\uc5d0 \ub9e4\ud551\ub418\ubbc0\ub85c \ud558\ub098\uc758 \uc2a4\ucf54\ud504\ub9cc \ub9cc\ub4e4\uba74 \ub429\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ud14c\uc774\ube14\uc740 \uac01\uac01 \uac19\uc740 \uc774\ub984\uc758 \uceec\ub809\uc158\uc5d0 \ub9e4\ud551\ub418\ubbc0\ub85c \ucd1d 3\uac1c\uc758 \uceec\ub809\uc158\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10578 size-full\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/02\/model.png\" alt=\"\" width=\"768\" height=\"378\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/model.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/model-300x148.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/model-20x10.png 20w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/p>\n<p><b>\ubc84\ud0b7, \ubc94\uc704 \ubc0f \uceec\ub809\uc158 \ub9cc\ub4e4\uae30:<\/b><\/p>\n<p>\uc5ec\uae30\uc5d0\ub294 \ub2e4\uc591\ud55c \uc635\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4. SDK, REST API, Couchbase CLI(Couchbase \uc178\ub3c4 \uc78a\uc9c0 \ub9c8\uc138\uc694), \uc6f9 GUI\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc800\ub294 REST API\ub97c \uc0ac\uc6a9\ud558\ub824\uace0 \ud558\ub294\ub370, \uba85\ub839\uc904\uc5d0\uc11c \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uace0 \uc544\ubb34\uac83\ub3c4 \uc124\uce58\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4\ub294 \uac83\uc774 \uc7a5\uc810\uc785\ub2c8\ub2e4! REST \uc778\ud130\ud398\uc774\uc2a4\uc5d0 \uc775\uc219\ud558\uc9c0 \uc54a\uc740 \ubd84\ub4e4\uc744 \uc704\ud574 \ubb38\uc11c <a href=\"https:\/\/docs.couchbase.com\/server\/7.0\/manage\/manage-scopes-and-collections\/manage-scopes-and-collections.html\">\uc5ec\uae30<\/a> \uc5d0\uc11c \ub2e4\ub978 \ub300\uccb4 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc544\ub798 \ub2e8\uacc4\uc5d0\uc11c\ub294 \ubc84\ud0b7, \ubc94\uc704 \ubc0f \uceec\ub809\uc158\uc744 \uc124\uc815\ud558\ub294 \ub370 \ud544\uc694\ud55c \uba85\ub839\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4:<\/p>\n<p>\ub2e4\uc74c \ub450 \uba85\ub839\uc744 \uc2e4\ud589\ud558\uc5ec \ub370\uc774\ud130 \ubc84\ud0b7\uacfc \ubc94\uc704\ub97c \ub9cc\ub4dc\uc138\uc694:<\/p>\n<pre class=\"lang:sh decode:true\">curl -X POST -u Administrator:password https:\/\/127.0.0.1:8091\/pools\/default\/buckets -d name=migration -d bucketType=couchbase -d ramQuotaMB=100\r\ncurl -X POST -u Administrator:password <a href=\"https:\/\/127.0.0.1:8091\/pools\/default\/buckets\/migration\/collections\">https:\/\/127.0.0.1:8091\/pools\/default\/buckets\/migration\/collections<\/a> -d name=reference<\/pre>\n<p>\uc774\uc81c \ud14c\uc774\ube14 \ub370\uc774\ud130\ub97c \ub9e4\ud551\ud560 \uc138 \uac1c\uc758 \uceec\ub809\uc158\uc744 \ub9cc\ub4ed\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:sh decode:true\">curl -u Administrator:password -X POST https:\/\/localhost:8091\/pools\/default\/buckets\/migration\/collections\/reference -d name=$TABLE_NAME<\/pre>\n<p>\ud544\uc694\uc5d0 \ub530\ub77c $TABLE_NAME \ubcc0\uc218\ub97c \ubcc0\uacbd\ud558\uc5ec \uc0c1\ub2f4\uc6d0, \uc8fc\ubb38 \ubc0f \uace0\uac1d \uceec\ub809\uc158\uc744 \uac01\uac01 \uc0dd\uc131\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<p>(\ubd80\ub85d\uc5d0 \uc774\ub7ec\ud55c API\uc5d0 \ub300\ud55c \ubb38\uc11c \ud398\uc774\uc9c0 \ub9c1\ud06c\uac00 \uc788\uc2b5\ub2c8\ub2e4).<\/p>\n<p>\ubaa8\ub4e0 \uac83\uc774 \uc0dd\uc131\ub418\uba74 \ubc84\ud0b7 \uc139\uc158\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec \uc0dd\uc131\ud55c \ubc84\ud0b7\uc758 \uc774\ub984 \uc606\uc5d0 \uc788\ub294 \"\ubc94\uc704 \ubc0f \uceec\ub809\uc158\" \ub9c1\ud06c\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4(\uc81c \ubc84\ud0b7\uc758 \uc774\ub984\uc740 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc785\ub2c8\ub2e4). \uadf8\ub7f0 \ub2e4\uc74c \uc0dd\uc131\ud55c \ubc94\uc704\ub97c \ud655\uc7a5\ud558\uba74 \uc0dd\uc131\ud55c \uc138 \uac1c\uc758 \uceec\ub809\uc158\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10579 size-full\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/02\/scopes-collections-view.png\" alt=\"\" width=\"916\" height=\"504\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/scopes-collections-view.png 916w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/scopes-collections-view-300x165.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/scopes-collections-view-768x423.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/scopes-collections-view-20x11.png 20w\" sizes=\"auto, (max-width: 916px) 100vw, 916px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>RDBMS\uc5d0\uc11c \ub370\uc774\ud130 \ucd94\ucd9c<\/strong><\/p>\n<p>\uc774\uc81c \ubc84\ud0b7, \ubc94\uc704 \ubc0f \uceec\ub809\uc158\uc774 \uc900\ube44\ub418\uc5c8\uc73c\ubbc0\ub85c \uad00\uacc4\ud615 \ub370\uc774\ud130\ub97c \ub0b4\ubcf4\ub0bc \uc900\ube44\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc800\ub294 <a href=\"https:\/\/github.com\/tallbigsam\/mysql_tsv_export\">\uc9e7\uc740 \uc2a4\ud06c\ub9bd\ud2b8<\/a> \ub97c \uc2e4\ud589\ud558\uc5ec \uc0d8\ud50c MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \ub3c4\uad6c\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 TSV\ub85c \ucd94\ucd9c\ud558\uac70\ub098 \uc9c1\uc811 \ub370\uc774\ud130\ub97c \ub0b4\ubcf4\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815\uc774 \uc644\ub8cc\ub418\uba74 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\uace0 \uad6c\uc131\ud55c \uc0ac\uc6a9\uc790 \uc544\uc774\ub514\uc640 \ube44\ubc00\ubc88\ud638\ub97c \uc0ac\uc6a9\ud558\ub3c4\ub85d \ubcc0\uc218\ub97c \ubcc0\uacbd\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4. \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\uba74 \uc0d8\ud50c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uac01 \ud14c\uc774\ube14\uc5d0 \uc788\ub294 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c 3\uac1c\uc758 .tsv \ud30c\uc77c\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n<pre class=\"lang:python decode:true\">#!\/usr\/bin\/python3\r\n\r\nimport subprocess\r\nimport json\r\nimport re\r\n\r\nsql_commands='{ \"commands\": { \"agents\": \"SELECT * FROM agents;\", \"customer\": \"SELECT * FROM customer\", \"orders\": \"SELECT * FROM orders;\" } }'\r\ndb_name = \"sample\"\r\nusername = \"root\"\r\npassword = \"rootroot\"\r\n\r\nsql_commands = json.loads(sql_commands)\r\nfor command_name in sql_commands[\"commands\"]:\r\n    print(\"Running command: \" + command_name)\r\n    \r\n    sql_statement = \"--execute={0}\".format(sql_commands[\"commands\"][command_name])\r\n    command = subprocess.run([\"\/usr\/local\/mysql\/bin\/mysql\", db_name, \"--user={0}\".format(username), \"--password={0}\".format(password), sql_statement], capture_output=True)\r\n    with open(command_name+\"_out.tsv\", 'w') as command_output_file:\r\n        command_without_trailing_white_space = re.sub(b\" +\\\\t\", b'\\\\t', command.stdout)\r\n        command_output_file.write(command_without_trailing_white_space.decode('ascii'))<\/pre>\n<p>\uac00\uc838\uc624\uae30 \ubd80\ubd84\ub9cc \uc791\uc5c5\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \uc774 \uc608\uc81c\ub97c \uc0ac\uc6a9\ud558\uc138\uc694:<\/p>\n<pre class=\"lang:sh decode:true\">AGENT_CODE AGENT_NAME WORKING_AREA COMMISSION PHONE_NO COUNTRY\r\nA007 Ramasundar Bangalore 0.15 077-25814763\r\nA003 Alex London 0.13 075-12458969\r\nA008 Alford New York 0.12 044-25874365\r\nA011 Ravi Kumar Bangalore 0.15 077-45625874\r\nA010 Santakumar Chennai 0.14 007-22388644\r\nA012 Lucida San Jose 0.12 044-52981425\r\nA005 Anderson Brisban 0.13 045-21447739\r\nA001 Subbarao Bangalore 0.14 077-12346674\r\nA002 Mukesh Mumbai 0.11 029-12358964\r\nA006 McDen London 0.15 078-22255588\r\nA004 Ivan Torento 0.15 008-22544166\r\nA009 Benjamin Hampshair 0.11 008-22536178<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>Couchbase\ub85c \ub370\uc774\ud130 \uac00\uc838\uc624\uae30<\/strong><\/p>\n<p>\ub2e4\uc591\ud55c \uae30\ub2a5\uc744 \uac16\ucd98 \uac00\uc838\uc624\uae30 \ub3c4\uad6c\uc778 cbimport\ub97c \uc0ac\uc6a9\ud558\uba74 \ub2e4\uc591\ud55c \ud615\uc2dd\uc758 \ub370\uc774\ud130\ub97c \uc815\ub9d0 \uc27d\uac8c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd5c\uadfc\uc5d0\ub294 \uc77c\ubd80 \uac00\uc838\uc624\uae30 \uae30\ub2a5\uc744 \uc6f9 GUI\uc5d0 \uad6c\ud604\ud558\uc5ec \ud504\ub85c\uc138\uc2a4\uc5d0 \ub354\uc6b1 \uc27d\uac8c \uc811\uadfc\ud560 \uc218 \uc788\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4. \uc544\ub798\ub294 \uc6f9 \uac00\uc774\ub4dc \uac00\uc838\uc624\uae30 \ub3c4\uad6c\uc758 \uc2a4\ud06c\ub9b0\uc0f7\uc785\ub2c8\ub2e4. \uc5ec\uae30\ub85c \uc774\ub3d9\ud558\ub824\uba74 Couchbase \uc6f9 GUI\uc5d0 \ub85c\uadf8\uc778\ud55c \ub2e4\uc74c \"\ubb38\uc11c\" -&gt; \"\uac00\uc838\uc624\uae30\"\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10580 size-full\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2021\/02\/cbimport.png\" alt=\"\" width=\"954\" height=\"614\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/cbimport.png 954w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/cbimport-300x193.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/cbimport-768x494.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/02\/cbimport-20x13.png 20w\" sizes=\"auto, (max-width: 954px) 100vw, 954px\" \/><\/p>\n<p>\uc5ec\uae30\uc11c\ub294 '\uac00\uc838\uc62c \ud30c\uc77c \uc120\ud0dd' \ubc84\ud2bc\uc744 \uc0ac\uc6a9\ud558\uc5ec TSV\ub97c \uac00\uc838\uc624\ub824\uace0 \ud558\ub294\ub370, \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud560 \ub54c \uc2e4\uc81c\ub85c \ub9ce\uc740 \ud544\ub4dc\uac00 \uc790\ub3d9\uc73c\ub85c \ucc44\uc6cc\uc9c0\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac00\uc838\uc628 \ub370\uc774\ud130\ub97c \uc0b4\ud3b4\ubcf4\uace0 \uc774\uc804 \uad00\uacc4\ud615 \uad6c\uc870\ub97c \uace0\ub824\ud558\uc5ec \uc608\uc0c1\ud55c \uac83\uacfc \uc77c\uce58\ud558\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud574 \uc644\ub8cc\ud574\uc57c \ud560 \uba87 \uac00\uc9c0 \uac04\ub2e8\ud55c \ub2e8\uacc4\ub9cc \ub0a8\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uba3c\uc800, \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \uceec\ub809\uc158\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4(\uc608: agents_out.tsv\ub294 'agents' \uceec\ub809\uc158\uc5d0 \ub9e4\ud551). \ub610\ud55c \uc774\uc804 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uac1c\ubcc4 \ud589\uc744 Couchbase\uc758 \ubb38\uc11c ID\uc5d0 \ub300\uc751\uc2dc\ud0ac \uac83\uc785\ub2c8\ub2e4. \uc774 \uc791\uc5c5\uc740 '\ubb38\uc11c ID\ub85c \uac00\uc838\uc624\uae30' \uc139\uc158\uc744 \uc0ac\uc6a9\ud558\uc5ec \uac00\uc838\uc624\uae30 \ub3c4\uad6c\ub85c \uc27d\uac8c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc800\ub294 \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \ub54c\ub9c8\ub2e4 \uad00\uacc4\ud615 \ub370\uc774\ud130\uc758 \uae30\ubcf8 \ud0a4\ub97c Couchbase\uc758 \ubb38\uc11c ID\ub85c \uc0ac\uc6a9\ud588\ub294\ub370, \uc774\ub294 \uceec\ub809\uc158\uc758 \uac01 \ud0a4\uac00 \uace0\uc720\ud574\uc57c \ud558\ubbc0\ub85c \ub9e4\uc6b0 \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc5d0\uc774\uc804\ud2b8_out.tsv\uc5d0\uc11c\ub294 \uae30\ubcf8 \ud0a4 \"AGENT_CODE\"\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. \uc0c1\ub2f4\uc6d0, \uc8fc\ubb38, \uace0\uac1d \ub4f1 \uac01 .tsv\uc5d0 \ub300\ud574 \uc774 \ub2e8\uacc4\ub97c \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\uc694\uc57d\ud558\uc790\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc791\uc5c5\uc744 \uc218\ud589\ud588\uc2b5\ub2c8\ub2e4:<\/p>\n<ol>\n<li>\ub808\uac70\uc2dc \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c TSV\ub85c \ub370\uc774\ud130 \ub0b4\ubcf4\ub0b4\uae30<\/li>\n<li>\uac00\uc838\uc624\ub824\ub294 \ud14c\uc774\ube14\uc744 \uae30\ubc18\uc73c\ub85c \ubc94\uc704 \ubc0f \uceec\ub809\uc158\uc744 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubc94\uc704 \ub0b4\uc5d0\uc11c \ud2b9\uc815 \uceec\ub809\uc158\uc73c\ub85c \ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\uc774\uc81c Couchbase\uc5d0 \ub370\uc774\ud130\ub97c \uac00\uc838\uc654\uc73c\ub2c8 \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\ub294 \uc0c8\ub85c\uc6b4 \ubc29\ubc95\uc744 \ubc30\uc6cc\uc57c \ud558\ub098\uc694? \uadf8\uc640\ub294 \uc815\ubc18\ub300\ub85c, Couchbase \uc6f9 GUI\ub85c \uc774\ub3d9\ud558\uc5ec \uc0c8\ub85c \uac00\uc838\uc628 \ub370\uc774\ud130 \uc911 \uc77c\ubd80\ub97c N1QL\uc744 \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac\ud574 \ubcf4\ub294 \uac83\uc740 \uc5b4\ub5a8\uae4c\uc694? <a href=\"https:\/\/query-tutorial.couchbase.com\/tutorial\/#1\">SQL++\uc640 \ud638\ud658\ub418\uba70 \uc774\uc804\uc5d0 SQL \ucffc\ub9ac\ub97c \uc791\uc131\ud574 \ubcf8 \uc801\uc774 \uc788\ub294 \uc0ac\uc6a9\uc790\ub77c\uba74 \ub204\uad6c\ub098 \uc27d\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/a>\ubb38\uc774 \uc5f4\ub838\uc73c\ub2c8 \ub4e4\uc5b4\uc624\uc138\uc694! \ucffc\ub9ac\ub97c \uc27d\uac8c \uc791\uc131\ud560 \uc218 \uc788\ub3c4\ub85d \ub3c4\uc640\ub4dc\ub9b4 \ubfd0\ub9cc \uc544\ub2c8\ub77c, \uc800\ud76c\uc758 <a href=\"https:\/\/index-advisor.couchbase.com\/indexadvisor\/#1\">\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800 \uc11c\ube44\uc2a4<\/a>\ub97c \ud074\ub9ad\ud558\uace0 \uc218\ud589\ud558\ub824\ub294 \ucffc\ub9ac\ub97c \uc785\ub825\ud558\uae30\ub9cc \ud558\uba74 \uc5b4\ub4dc\ubc14\uc774\uc800\uac00 \uc778\ub371\uc2a4\ub97c \uc81c\uc548\ud569\ub2c8\ub2e4. JOIN\ub3c4 \uc9c0\uc6d0\ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:tsql decode:true\">SELECT orders.AGENT_CODE, orders.ORD_AMOUNT, agents.AGENT_NAME\r\nFROM `bigdata`.reference.orders as orders\r\nJOIN `bigdata`.reference.agents as agents\r\nON orders.AGENT_CODE = meta(agents).id;<\/pre>\n<p>Couchbase\ub97c \ucd5c\ub300\ud55c \ud65c\uc6a9\ud558\uae30 \uc704\ud574 \ub370\uc774\ud130\ub97c \ubaa8\ub378\ub9c1\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \uad00\uacc4\ud615\uc5d0\uc11c NoSQL\ub85c \uc804\ud658\ud558\ub294 \uc62c\ubc14\ub978 \ubc29\ud5a5\uc73c\ub85c \ub098\uc544\uac00\ub294 \uc88b\uc740 \ucd9c\ubc1c\uc810\uc774 \ub420 \uac83\uc785\ub2c8\ub2e4, <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/a-json-data-modeling-guide\/\">\ub370\uc774\ud130 \ubaa8\ub378\ub9c1 \uac00\uc774\ub4dc \ud655\uc778<\/a>.<\/p>\n<p>\ubc94\uc704\uc640 \uceec\ub809\uc158\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uace0 \uc2f6\uc73c\uc2e0\uac00\uc694?<a href=\"https:\/\/www.couchbase.com\/blog\/ko\/scopes-and-collections-for-modern-multi-tenant-applications-couchbase-7-0\/\"> Shivani\uc758 \ube14\ub85c\uadf8\ub97c \ucd94\ucc9c\ud569\ub2c8\ub2e4.<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><b>\ubd80\ub85d:<\/b><\/p>\n<ul>\n<li aria-level=\"1\"><a href=\"https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-import-and-export-databases-in-mysql-or-mariadb\">\ub2e4\uc74c \ub9c1\ud06c\ub294 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc0d8\ud50c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc744 \uc815\ud655\ud558\uac8c \uc54c\ub824\uc90d\ub2c8\ub2e4.<\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\/\/hub.docker.com\/_\/couchbase\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ub3c4\ucee4 \ucee8\ud14c\uc774\ub108<\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\/\/docs.couchbase.com\/server\/7.0\/rest-api\/creating-a-scope.html\">7.0 REST API - \ubc94\uc704 \uc0dd\uc131 \ubb38\uc11c<\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\/\/docs.couchbase.com\/server\/7.0\/rest-api\/rest-bucket-create.html\">7.0 REST API \ubc84\ud0b7 \ubb38\uc11c \ub9cc\ub4e4\uae30<\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\/\/docs.couchbase.com\/server\/7.0\/rest-api\/creating-a-collection.html\">7.0 REST API - \uceec\ub809\uc158 \uc0dd\uc131 \ubb38\uc11c<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>The key outcome of this blog is to teach you how you can easily migrate your relational data over to Couchbase, lowering your TCO and empowering your data platform to respond to the fast paced release cycles we know and [&hellip;]<\/p>","protected":false},"author":76077,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1815,1819],"tags":[],"ppma_author":[9168],"class_list":["post-10577","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices-and-tutorials","category-data-modeling"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.7.1 (Yoast SEO v25.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hands-on Migration From Relational to Collections - The Couchbase Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/hands-on-migration-from-relational-to-collections\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hands-on Migration From Relational to Collections\" \/>\n<meta property=\"og:description\" content=\"The key outcome of this blog is to teach you how you can easily migrate your relational data over to Couchbase, lowering your TCO and empowering your data platform to respond to the fast paced release cycles we know and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/hands-on-migration-from-relational-to-collections\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-16T17:00:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2022\/11\/couchbase-nosql-dbaas.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sam Redman, Solutions Engineer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sam Redman, Solutions Engineer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/\"},\"author\":{\"name\":\"Sam Redman\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/512e4ed8ed1188a93cb7c3aee277f408\"},\"headline\":\"Hands-on Migration From Relational to Collections\",\"datePublished\":\"2021-02-16T17:00:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/\"},\"wordCount\":1121,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"Best Practices and Tutorials\",\"Data Modeling\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/\",\"name\":\"Hands-on Migration From Relational to Collections - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2021-02-16T17:00:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hands-on Migration From Relational to Collections\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/512e4ed8ed1188a93cb7c3aee277f408\",\"name\":\"Sam Redman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/69dc9b1e46ceb237d29e1e4b626c6bcc\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ee34f7b9f2c46328736cdab03babdfd5ddc97cdd4a12ddd4b1b2d0f455eba51d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ee34f7b9f2c46328736cdab03babdfd5ddc97cdd4a12ddd4b1b2d0f455eba51d?s=96&d=mm&r=g\",\"caption\":\"Sam Redman\"},\"description\":\"Solutions Engineer at Couchbase. Sam has previously as a developer and an SRE before joining Couchbase.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/sam-redman\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Hands-on Migration From Relational to Collections - The Couchbase Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/hands-on-migration-from-relational-to-collections\/","og_locale":"ko_KR","og_type":"article","og_title":"Hands-on Migration From Relational to Collections","og_description":"The key outcome of this blog is to teach you how you can easily migrate your relational data over to Couchbase, lowering your TCO and empowering your data platform to respond to the fast paced release cycles we know and [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/hands-on-migration-from-relational-to-collections\/","og_site_name":"The Couchbase Blog","article_published_time":"2021-02-16T17:00:15+00:00","og_image":[{"width":1800,"height":630,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2022\/11\/couchbase-nosql-dbaas.png","type":"image\/png"}],"author":"Sam Redman, Solutions Engineer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sam Redman, Solutions Engineer","Est. reading time":"7\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/"},"author":{"name":"Sam Redman","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/512e4ed8ed1188a93cb7c3aee277f408"},"headline":"Hands-on Migration From Relational to Collections","datePublished":"2021-02-16T17:00:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/"},"wordCount":1121,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["Best Practices and Tutorials","Data Modeling"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/","url":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/","name":"Hands-on Migration From Relational to Collections - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2021-02-16T17:00:15+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/hands-on-migration-from-relational-to-collections\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Hands-on Migration From Relational to Collections"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/512e4ed8ed1188a93cb7c3aee277f408","name":"\uc0d8 \ub808\ub4dc\uba3c","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/69dc9b1e46ceb237d29e1e4b626c6bcc","url":"https:\/\/secure.gravatar.com\/avatar\/ee34f7b9f2c46328736cdab03babdfd5ddc97cdd4a12ddd4b1b2d0f455eba51d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ee34f7b9f2c46328736cdab03babdfd5ddc97cdd4a12ddd4b1b2d0f455eba51d?s=96&d=mm&r=g","caption":"Sam Redman"},"description":"Solutions Engineer at Couchbase. Sam has previously as a developer and an SRE before joining Couchbase.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/sam-redman\/"}]}},"authors":[{"term_id":9168,"user_id":76077,"is_guest":0,"slug":"sam-redman","display_name":"Sam Redman, Solutions Engineer","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/ee34f7b9f2c46328736cdab03babdfd5ddc97cdd4a12ddd4b1b2d0f455eba51d?s=96&d=mm&r=g","first_name":"Sam","last_name":"Redman","user_url":"","author_category":"","description":"\uc0d8 \ub808\ub4dc\uba3c\uc740 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uc194\ub8e8\uc158 \uc5d4\uc9c0\ub2c8\uc5b4\uc785\ub2c8\ub2e4. Sam\uc740 Couchbase\uc5d0 \uc785\uc0ac\ud558\uae30 \uc804\uc5d0\ub294 \uac1c\ubc1c \ubc0f SRE \ud658\uacbd\uc5d0\uc11c \uadfc\ubb34\ud588\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/10577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/76077"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=10577"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/10577\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=10577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=10577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=10577"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=10577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}