{"id":453,"date":"2015-09-07T03:55:24","date_gmt":"2015-09-07T03:55:24","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=453"},"modified":"2015-09-07T03:55:24","modified_gmt":"2015-09-07T03:55:24","slug":"rdbms-relational-database-management-system","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=453","title":{"rendered":"RDBMS ( Relational DataBase Management System )"},"content":{"rendered":"<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>RDB\ub77c\uba74 \uc544\ub798\uc758 \uaddc\uce59\uc744 \ub530\ub974\uac8c \ub429\ub2c8\ub2e4. ORACLE,MS_SQL,SYBASE .. \ub4f1\ub4f1..<br \/>\n<\/strong><\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>1) RDBMS\uc758 \uad6c\uc131<\/strong><br \/>\n\t\t<\/span><\/p>\n<ul>\n<li>\n<div><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc73c\ub85c\uc11c \uc5f4\uacfc \ud589\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c4 2\ucc28\uc6d0\uc758 \ud14c\uc774\ube14\ub85c \uad6c\uc131\ub41c\ub2e4.<br \/>\n<\/span><\/div>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile30.uf.2554E14455ED0AA91C4FD9.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><br \/>\n\t\t\t\t<\/span><\/p>\n<p>\n&nbsp;<\/p>\n<\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\uc5f4(Column)\uacfc \ud589(Row)\uc758 \uc21c\uc11c\ub294 \ub17c\ub9ac\uc801\uc73c\ub85c \uc911\uc694\ud558\uc9c0 \uc54a\uc73c\uba70, \ubc30\uc5f4\uc758 \ud615\uc2dd\uc744 \uac00\uc9c0\uc9c0 \uc54a\ub294\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uac19\uc740 \uc758\ubbf8\ub97c \uac00\uc9c0\ub294 column value\uc758 \ub17c\ub9ac\uc801\uc778 \uc5f0\uacb0\uc744 \ud1b5\ud574 \uac00\ub2a5\ud558\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile29.uf.2608AF3E55ED0AA92FEE98.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><\/p>\n<p><strong>2) \uc6a9\uc5b4 \uc124\uba85<\/strong><br \/>\n\t\t<\/span><\/p>\n<ul>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Table : RDBMS\uc758 \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \uc800\uc7a5\uad6c\uc870\ub85c\uc11c \ud558\ub098 \uc774\uc0c1\uc758 column\uacfc 0\uac1c \uc774\uc0c1\uc758 row\ub85c \uad6c\uc131\ub41c\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Row : Table\ub0b4\uc758 column value\ub4e4\uc758 \uc870\ud569. Record<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Column : Table\ub0b4\uc758 \ud2b9\uc815 \ub370\uc774\ud130\ub97c \ub300\ud45c\ud558\uba70 \ud2b9\uc815 Type\uacfc \uae38\uc774\ub97c \uac00\uc9c4\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Primary Key : \ud14c\uc774\ube14\uc5d0\uc11c \uc644\uc804\ud788 \ub611\uac19\uc740 \ub0b4\uc6a9\uc758 row\ub294 \uc874\uc7ac\ud560 \uc218\ub3c4, \ud544\uc694\ub3c4 \uc5c6\ub2e4. \uadf8\ub798\uc11c \uac01 row\ub97c \uad6c\ubd84\ud560 \uc218 \uc788\ub294 column\uc774\ub098 column\uc758 \uc870\ud569\uc774 \ud544\uc694\ud55c\ub370 \uc774\uac83\uc744 Primary Key \ub77c\uace0 \ud55c\ub2e4. Primary Key \ub294 \ubc18\ub4dc\uc2dc \uc18d\ud55c \ud14c\uc774\ube14\uc5d0\uc11c \uc720\uc77c\ud55c \uac12\uc744 \uac00\uc838\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Foreign Key : \uc5ec\ub7ec \uac1c \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \uc885\ud569\ud55c \uacb0\uacfc\ub97c \uc6d0\ud560 \ub54c \uac19\uc740 \uc758\ubbf8\ub97c \uac00\uc9c0\ub294 column value \uc758 \uc5f0\uacb0\uc744 \ud1b5\ud558\uac8c \ub418\ub294\ub370 \uc774 \ub54c \ucc38\uc870\ud558\ub294 \ud14c\uc774\ube14\uc5d0\uc11c\uc758 column\uc744 Foreign Key \ub77c\uace0 \ud55c\ub2e4. \uc774\ub7ec\ud55c Foreign Key\uc758 value\ub294 \ucc38\uc870\ub418\ub294 \ud14c\uc774\ube14\uc5d0 \ubc18\ub4dc\uc2dc \uc874\uc7ac\ud558\ub294 primary key \uac12\uc774\uc5b4\uc57c \ud55c\ub2e4. \ud558\uc9c0\ub9cc Foreign Key\ub294 \uac12\uc744 \uac00\uc9c0\uc9c0 \uc54a\uc744 \uc218\ub3c4 \uc788\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile25.uf.2124323355ED0AAA2E3F5A.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><\/p>\n<p><strong>3) \uc790\ub8cc\uc758 \uc870\uc791<\/strong><br \/>\n\t\t<\/span><\/p>\n<ul>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">RESTRICT : table\uc758 \ud2b9\uc815 row\uc5d0 \ub300\ud574 \ubd80\ubd84\uc801\uc73c\ub85c \uc81c\ud55c\ub41c \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \uc218 \uc788\ub2e4. ( \uc218\ud3c9\uc801 \ubd80\ubd84 \uc9d1\ud569\uc744 \ub9cc\ub4ec )<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">PROJECT : table\uc758 \ud2b9\uc815 column\uc5d0 \ub300\ud574 \ubd80\ubd84\uc801\uc744 \uc81c\ud55c\ub41c \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \uc218 \uc788\ub2e4. ( \uc218\uc9c1\uc801 \ubd80\ubd84 \uc9d1\ud569\uc744 \ub9cc\ub4ec )<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">PRODUCT : \uc11c\ub85c \ub2e4\ub978 table \uac04\uc5d0 \uad00\uacc4\ub41c \ubaa8\ub4e0 \uc258\uc744 \uc0c1\ud638 \uc5f0\uad00\uc744 \ud1b5\ud558\uc5ec \uc5f0\uc18d\uc801\uc73c\ub85c \ucd94\ucd9c \ud560 \uc218 \uc788\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">JOIN : PRODUCT\uc640 RESTRICT\ub97c \ubcf5\ud569\uc801\uc73c\ub85c \uc801\uc6a9\ud55c \uac83\uc73c\ub85c\uc11c \uc5f0\uad00\ub41c \ubaa8\ub4e0 \ub370\uc774\ud130\uc5d0 \ub300\ud574\uc11c column\uacfc row\ub97c \ub3d9\uc2dc\uc5d0 \ucd94\ucd9c\ud560 \uc218 \uc788\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>RDB\ub77c\uba74 \uc544\ub798\uc758 \uaddc\uce59\uc744 \ub530\ub974\uac8c \ub429\ub2c8\ub2e4. ORACLE,MS_SQL,SYBASE .. \ub4f1\ub4f1.. &nbsp; 1) RDBMS\uc758 \uad6c\uc131 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc73c\ub85c\uc11c \uc5f4\uacfc \ud589\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c4 2\ucc28\uc6d0\uc758 \ud14c\uc774\ube14\ub85c \uad6c\uc131\ub41c\ub2e4. &nbsp; \uc5f4(Column)\uacfc \ud589(Row)\uc758 \uc21c\uc11c\ub294 \ub17c\ub9ac\uc801\uc73c\ub85c \uc911\uc694\ud558\uc9c0 \uc54a\uc73c\uba70, \ubc30\uc5f4\uc758 \ud615\uc2dd\uc744 \uac00\uc9c0\uc9c0 \uc54a\ub294\ub2e4. \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uac19\uc740 \uc758\ubbf8\ub97c \uac00\uc9c0\ub294 column value\uc758 \ub17c\ub9ac\uc801\uc778 \uc5f0\uacb0\uc744 \ud1b5\ud574 \uac00\ub2a5\ud558\ub2e4. 2) \uc6a9\uc5b4 \uc124\uba85 Table : RDBMS\uc758 \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \uc800\uc7a5\uad6c\uc870\ub85c\uc11c \ud558\ub098 \uc774\uc0c1\uc758 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":454,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[11],"tags":[214,215,216],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile25.uf.2124323355ED0AAA2E3F5A.png?fit=462%2C181","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/453"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=453"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/453\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/454"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=453"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}