{"id":457,"date":"2015-09-07T03:56:30","date_gmt":"2015-09-07T03:56:30","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=457"},"modified":"2015-09-07T03:56:30","modified_gmt":"2015-09-07T03:56:30","slug":"data-modeling%ec%9d%98-%ea%b8%b0%ec%b4%88","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=457","title":{"rendered":"Data Modeling\uc758 \uae30\ucd08"},"content":{"rendered":"<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>Data Modeling<\/strong><\/p>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa8\ub378\ub9c1\uc740 \uba87 \uac00\uc9c0 \ub2e8\uacc4\ub97c \uac70\uccd0 \uc815\ud615\ud654\ub41c \ud14c\uc774\ube14\ub85c \uad6c\ud604\ub418\uace0, \uac01 \ud14c\uc774\ube14\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ub2e8\uacc4\uc5d0\uc11c \uacb0\uc815\ub41c \uad00\uacc4\ub97c \ud1b5\ud574\uc11c \uc11c\ub85c \uc5f0\uad00\uc131\uc744 \uac16\ub294\ub2e4. <br \/>\ub530\ub77c\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uacc4\ud55c\ub2e4\ub294 \uac83\uc740 \uc0ac\uc6a9\uc790\uc758 \uc694\uad6c\ub97c \ubd84\uc11d\ud558\uace0, \uc694\uad6c\uc5d0 \ub530\ub974\ub294 \uac1c\ub150\uc744 \uc815\ub9bd\ud55c \ud6c4 \ub17c\ub9ac\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc124\uacc4\uc5d0 \ub4e4\uc5b4\uac00\uba70, \uc774\ub97c \uad6c\uccb4\uc801\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubb3c\ub9ac\uc801\uc778 \uc124\uacc4 \ub2e8\uacc4\ub97c \uac70\uccd0 \uc644\uc131\ub41c\ub2e4. <br \/>\ub610\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc124\uacc4\ub294 \ud504\ub85c\uadf8\ub7a8\uc758 \uac1c\ubc1c\uacfc \ubc00\uc811\ud55c \uad00\ub828\uc744 \ub9fa\uc73c\uba70 \uc644\uc131\ub418\uc5b4 \uac00\uae30 \ub54c\ubb38\uc5d0 \uac01 \ub2e8\uacc4\uc5d0\uc11c \ud504\ub85c\uadf8\ub7a8\uacfc\uc758 \uc5f0\uad00\uc131\uc744 \ubc18\ub4dc\uc2dc \uace0\ub824\ud574\uc57c \ud55c\ub2e4. <br \/>\uc774\ub97c \ub3c4\uc2dd\uc801\uc73c\ub85c \ub098\ud0c0\ub0b4\uba74 \ub2e4\uc74c\uacfc \uac19\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile3.uf.2105D04155ED0AEC3133B8.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>\n&nbsp;<\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>1) \uc0ac\uc6a9\uc790\uc758 \uc694\uad6c \ubd84\uc11d ( 1\ub2e8\uacc4 )<\/strong><\/p>\n<p>\uc0ac\uc6a9\uc790\uc758 \uc694\uad6c\ub97c \uac1c\ub150\uc801\uc73c\ub85c \uc815\ub9bd\ud558\ub294 \ub2e8\uacc4\ub85c\uc11c \uc2e4\uc81c \uc5c5\ubb34\uc640 \uad00\ub828\ub41c \ud750\ub984\uc744 \ud30c\uc545\ud558\uace0, \uac01 \uc5c5\ubb34\uc758 \uc5f0\uad00\uc131\uc744 \uc815\ud655\ud788 \ud30c\uc545\ud574\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/p>\n<p>\n&nbsp;<\/p>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>2) \ub17c\ub9ac\uc801\uc778 \uc124\uacc4 ( 2\ub2e8\uacc4 ) &#8211; Conceptual Data Modeling<\/strong><\/p>\n<p>\ub17c\ub9ac\uc801\uc778 \uc124\uacc4 \ub610\ub294 \uac1c\ub150\uc801\uc778 \ub370\uc774\ud130 \ubaa8\ub378\ub9c1\uc774\ub77c\uace0 \ud558\uba70, \uc804\uc0b0\ud654\uc758 \ub300\uc0c1\uc778 \uc5c5\ubb34\uc5d0\uc11c \uc2e4\uc81c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud574\uc57c \ud560 \uc815\ubcf4\uac00 \ubb34\uc5c7\uc774\uc9c0 \ub3c4\uc2dd\ud654 \ud574\ub0b4\ub294 \uacfc\uc815\uc774\ub2e4.<br \/>\uc774 \uacfc\uc815\uc5d0\uc11c ER-Diagram\uc774 \uc0ac\uc6a9\ub41c\ub2e4.<br \/>\n<\/span><\/p>\n<ul>\n<li>\n<div><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">ER-Diagram ( Entity-Relationship ) <br \/>&#8211; \uad6c\uc131 \uc694\uc18c<br \/>\n<\/span><\/div>\n<ul>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Entity : \uc5c5\ubb34\uc758 \ub300\uc0c1\uc73c\ub85c \ubcf4\uad00\ud560 \ud544\uc694\uc131\uc774 \uc788\ub294 \uc815\ubcf4\ub97c \uc758\ubbf8\ud55c\ub2e4. \uc774\ub7ec\ud55c Entity\ub294 \ubcf4\ud1b5 \uba85\uc0ac\ud615\uc73c\ub85c \ub098\ud0c0\ub098\uace0 \uc0ac\ubb3c\uc758 \ubc94\uc8fc\ub098 \uc720\ud615\uc774 \ub420 \uc218 \uc788\ub2e4. Entity\ub294 \uc5ec\ub7ec \uac1c\uc758 instance\ub85c \uad6c\uc131\ub418\uba70, \uadf8 \uad6c\uccb4\uc801\uc778 \uc0ac\ud56d\ub4e4\uc740 Attribute\ub85c \ub098\ud0c0\ub09c\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Attribute : Entity\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uae30\uc220\ud558\ub294 \uac83\uc73c\ub85c Entity\ub97c \uc2dd\ubcc4, \ud655\uc778, \ubd84\ub958, \ud45c\ud604\ub41c \uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0bc \uc218 \uc788\ub294 \ubaa8\ub4e0 \ud56d\ubaa9\uc744 \uc758\ubbf8\ud55c\ub2e4. \uc774\ub7ec\ud55c attribute\uc5d0\ub294 \uc5c5\ubb34\uc5d0 \ud544\uc218\uc801\uc778 \ud56d\ubaa9 \ubfd0\ub9cc \uc544\ub2c8\ub77c \ud544\uc218\uc801\uc774\uc9c0 \uc54a\uc740 \ud56d\ubaa9\ub3c4 \ud3ec\ud568 \ub420 \uc218 \uc788\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Relationship : entity \uac04\uc758 \uad00\uacc4\ub97c \ub098\ud0c0\ub0b4\ub294 \uac83\uc73c\ub85c, \uc5c5\ubb34\uc758 \uc815\ubcf4 \uc694\uad6c \uc0ac\ud56d\uc744 \uc5f0\uacb0\ud558\ub294 \uc5c5\ubb34 \uaddc\uce59\uc744 \uc758\ubbf8\ud55c\ub2e4. \ub530\ub77c\uc11c \uc774\ub7ec\ud55c \uad00\uacc4\ub294 \ubc18\ub4dc\uc2dc entity \uac04\uc758 \uc591\ubc29\ud5a5\uc73c\ub85c \ub098\ud0c0\ub09c\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">&#8211; \uad00\uacc4\ub3c4 :<br \/>\n<\/span><\/p>\n<ul>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\ud558\ub098\uc758 Entity\ub294 \uc5ec\ub7ec \uac1c\uc758 instance\ub97c \uac00\uc9c0\uba70, \uac01\uac01\uc758 instances\ub294 \ud558\ub098\uc758 Entity\ub85c \ubcfc \uc218\ub3c4 \uc788\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Entity \uac04\uc758 \uad00\uacc4\ub97c Relationship \uc774\ub77c \ud55c\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">Entity\uc758 \uc18d\uc131\uc744 \uc815\uc758\ud558\uace0, \uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0b4\ub294 \uc5ed\ud560\uc744 \ub2f4\ub2f9\ud558\ub294 \uac83\uc744 Attribute\ub77c \ud55c\ub2e4.<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\n&nbsp;<\/p>\n<p style=\"text-align: center\"><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.24315D3C55ED0AED24C2E0.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>&#8211; \uad00\uacc4\uc758 \uc720\ud615 ( Relationship Type )<br \/>\n<\/span><\/p>\n<ul style=\"margin-left: 72pt\">\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\uc758\ubbf8 : Entity\uc758 instance\uac04\uc758 \uad00\uacc4\ub97c \uc758\ubbf8\ud55c\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\uc885\ub958 <br \/>M:1 \uc720\ud615 : Many-to-One (\uc608. \uace0\uac1d\uacfc \uc601\uc5c5\uc0ac\uc6d0, \ubd80\uc11c\uc640 \uc9c1\uc6d0)<br \/>M:M \uc720\ud615 : Many-to-Many (\uc608. \ud658\uc790\uc640 \uac04\ud638\uc0ac, \uc8fc\ubb38\uacfc \uc0c1\ud488)<br \/>1:1 \uc720\ud615 : One-to-One (\uc608. \ud720\uccb4\uc5b4\uc640 \uc7a5\uc560\uc778, \uc790\ub3d9\ucc28\uc640 \uc6b4\uc804\uc218)<br \/>\n<\/span><\/li>\n<li>\n<div><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\">\uc8fc\uc758 \uc0ac\ud56d : M:M\uc758 \uad00\uacc4\uc5d0\uc11c\ub294 \ub450 Entity\ub4e4\ub85c\ubd80\ud130 Attribute\uac00 \uc870\ud569\ub418\uc5b4 \ub098\ud0c0\ub098\ub294 \ub0b4\uc6a9(Relationship \uc790\uccb4\uc758 Attribute)\uc744 \uc5b4\ub290 Entity\uc5d0 \ub098\ud0c0\ub0b4\uc5b4\uc57c \ud558\ub294 \uc9c0\uac00 \ubaa8\ud638\ud558\ubbc0\ub85c Design \ub2e8\uacc4\uc5d0 \ub4e4\uc5b4\uac00\uc9c0 \uc804\uc5d0 \ub450 Entity \uc0ac\uc774\uc5d0 \ub610 \ud558\ub098\uc758 Entity\ub97c \ucd94\uac00\ud558\uc5ec \ub450 \uac1c\uc758 M:1 \uad00\uacc4\ub85c \ubc18\ub4dc\uc2dc \uc804\ud658\uc2dc\ucf1c \uc8fc\uc5b4\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/div>\n<p>\n&nbsp;<\/p>\n<\/li>\n<\/ul>\n<p><span style=\"color:#555555; font-family:\uad74\ub9bc\uccb4; font-size:9pt\"><strong>3) \ubb3c\ub9ac\uc801 \uc124\uacc4 ( 3\ub2e8\uacc4 ) &#8211; Database Design<\/strong><\/p>\n<p>\ubb3c\ub9ac\uc801 \uc124\uacc4 \ub610\ub294 Database Design \uc774\ub77c \ud558\uba70, \uc774 \ub2e8\uacc4\ub294 \ub3c4\uc2dd\ud654\ub41c \uc815\ubcf4\ub97c \uc2e4\uc81c \uc0ac\uc6a9\ud560 Table\ud615\uc2dd\uc73c\ub85c Mapping\ud558\ub294 \ub2e8\uacc4\ub85c\uc11c \uc55e\uc11c\uc758 Entity\ub294 Table\ub85c, Attribute\ub294 Column\uc73c\ub85c \ub098\ud0c0\ub09c\ub2e4. <br \/>\ub17c\ub9ac\uc801\uc778 \uc124\uacc4\uac00 \uccb4\uacc4\uc801\uc73c\ub85c \ub3c4\uc2dd\ud654 \ub418\uc5c8\ub2e4\uba74 \uc774 \ub2e8\uacc4\ub294 Table \uc0dd\uc131\uc2dc Data Type, Data\uc758 \uae38\uc774, PK, FK \ub4f1\uc744 \ub9cc\ub4e4\uc5b4 \uc8fc\uba74 \ub41c\ub2e4.<br \/>\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Modeling \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa8\ub378\ub9c1\uc740 \uba87 \uac00\uc9c0 \ub2e8\uacc4\ub97c \uac70\uccd0 \uc815\ud615\ud654\ub41c \ud14c\uc774\ube14\ub85c \uad6c\ud604\ub418\uace0, \uac01 \ud14c\uc774\ube14\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ub2e8\uacc4\uc5d0\uc11c \uacb0\uc815\ub41c \uad00\uacc4\ub97c \ud1b5\ud574\uc11c \uc11c\ub85c \uc5f0\uad00\uc131\uc744 \uac16\ub294\ub2e4. \ub530\ub77c\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc124\uacc4\ud55c\ub2e4\ub294 \uac83\uc740 \uc0ac\uc6a9\uc790\uc758 \uc694\uad6c\ub97c \ubd84\uc11d\ud558\uace0, \uc694\uad6c\uc5d0 \ub530\ub974\ub294 \uac1c\ub150\uc744 \uc815\ub9bd\ud55c \ud6c4 \ub17c\ub9ac\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc124\uacc4\uc5d0 \ub4e4\uc5b4\uac00\uba70, \uc774\ub97c \uad6c\uccb4\uc801\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubb3c\ub9ac\uc801\uc778 \uc124\uacc4 \ub2e8\uacc4\ub97c \uac70\uccd0 \uc644\uc131\ub41c\ub2e4. \ub610\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc124\uacc4\ub294 \ud504\ub85c\uadf8\ub7a8\uc758 \uac1c\ubc1c\uacfc \ubc00\uc811\ud55c \uad00\ub828\uc744 \ub9fa\uc73c\uba70 \uc644\uc131\ub418\uc5b4 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":458,"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":[219],"tags":[217,218],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile3.uf.2105D04155ED0AEC3133B8.png?fit=427%2C271","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/457"}],"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=457"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/457\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/458"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=457"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}