{"id":2192,"date":"2021-06-04T14:30:49","date_gmt":"2021-06-04T06:30:49","guid":{"rendered":"https:\/\/eyebook.blog\/?p=2192"},"modified":"2021-08-05T15:45:37","modified_gmt":"2021-08-05T07:45:37","slug":"%e8%b3%87%e8%a8%8a%e8%99%95%e7%90%86%e8%b3%87%e6%96%99%e5%ba%ab%e6%87%89%e7%94%a8-%e9%ab%98%e6%99%ae%e8%80%83%e8%80%83%e5%89%8d%e8%a1%9d%e5%88%ba-%e9%80%99%e4%ba%9b%e8%a7%80%e5%bf%b5%e4%bd%a0%e7%a2%ba","status":"publish","type":"post","link":"https:\/\/eyebook.blog\/?p=2192","title":{"rendered":"\u8cc7\u6599\u5eab\u61c9\u7528-\u9069\u7528\u9ad8\u8003\u4e09\u7b49\u8cc7\u8a0a\u8655\u7406-\u9ad8\u666e\u8003\u8003\u524d\u885d\u523a-\u9019\u4e9b\u89c0\u5ff5\u4f60\u78ba\u5be6\u638c\u63e1\u4e86\u55ce\uff1f"},"content":{"rendered":"\r\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"640\" height=\"360\" class=\"wp-image-2193\" src=\"https:\/\/eyebook.blog\/wp-content\/uploads\/2021\/06\/108\u5e74\u9ad8\u666e\u8003-91\u5b98\u7db2-\u5716\u6587\u6a21\u7d44-banner-47.jpg\" alt=\"\" srcset=\"https:\/\/eyebook.blog\/wp-content\/uploads\/2021\/06\/108\u5e74\u9ad8\u666e\u8003-91\u5b98\u7db2-\u5716\u6587\u6a21\u7d44-banner-47.jpg 640w, https:\/\/eyebook.blog\/wp-content\/uploads\/2021\/06\/108\u5e74\u9ad8\u666e\u8003-91\u5b98\u7db2-\u5716\u6587\u6a21\u7d44-banner-47-300x169.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/figure>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p>\u81e8\u6642\u62b1\u4f5b\u8173\uff0c\u4e5f\u8981\u6709\u6280\u5de7\uff01\u8001\u5e2b\u90fd\u77e5\u9053\u540c\u5b78\u5011\u6700\u5bb9\u6613\u641e\u6df7\u7684\u89c0\u5ff5\u6709\u54ea\u4e9b\uff0c\u5ff5\u7684\u5fc3\u9a5a\u9a5a\u7684\u90e8\u5206\u5728\u54ea\u908a\uff0c\u6240\u4ee5\u5462~\u7279\u5730\u6e96\u5099\u4e86\u9019\u4efd\u300c108\u9ad8\u666e\u8003\u8003\u524d\u91cd\u9ede\u6574\u7406\u300d\u4f5b\u5fc3\u4f86\u8005\u5927\u88dc\u8cbc\uff0c\u8b93\u4f60\u4e0a\u8003\u5834\u524d\u5148\u8b80\u5148\u770b\uff0c\u628a\u5361\u4f4f\u7684\u96e3\u95dc\u5168\u7a81\u7834\uff01<\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<h1 class=\"wp-block-heading\">\u3010\u8cc7\u6599\u5eab\u61c9\u7528\u3011<\/h1>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2.91mai.com\/o2o\/image\/72bc3151-cc6c-43a8-b7ce-107c7039ddd6.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p>\u5404\u5c64\u610f\u7fa9\uff1a<br \/>\u5916\u90e8\u5c64\uff5c\u8996\u754c\u5c64\uff1a\u5916\u90e8\u7db1\u8981\uff0cAP\u89c0\u9ede\uff0c\u4ee5\u5be6\u4f5c\u8cc7\u6599\u6a21\u578b\u5448\u73fe\uff0c1\uff5e\u591a\u500b\uff0c\u7528VDL(View Definition Language)\u6216DDL(\u5be6\u52d9\u5e38\u7528)\u5b9a\u7fa9\u3002<br \/>\u6982\u5ff5\u5c64\uff5c\u908f\u8f2f\u5c64\uff1a\u6982\u5ff5\u7db1\u8981\uff0cDBA\u8207SA\u89c0\u9ede\uff0c\u4ee5\u5be6\u4f5c\u8cc7\u6599\u6a21\u578b\u5448\u73fe\uff0c\u53ea\u67091\u500b\uff0c\u7528DDL\u5b9a\u7fa9\uff0c\u6982\u5ff5\u6027\u63cf\u8ff0\uff0c\u8207\u5be6\u4f5c\u6280\u8853\u7121\u95dc\u3002<br \/>\u5167\u90e8\u5c64\uff5c\u5be6\u9ad4\u5c64\uff1a\u5167\u90e8\u7db1\u8981\uff0cDBA\u89c0\u9ede\uff0c\u4ee5\u5be6\u9ad4\u8cc7\u6599\u6a21\u578b\u5448\u73fe\uff0c\u53ea\u67091\u500b\uff0c\u7528SDL(Storage Definition Language)\u5b9a\u7fa9(\u5be6\u52d9\u4e0a\u900f\u904e\u5132\u5b58\u5a92\u9ad4\u5b58\u53d6\u51fd\u5f0f\u6307\u5b9a\uff0cDBA\u8ca0\u8cac\u8a2d\u5b9a\u7d22\u5f15\u53ca\u8cc7\u6599\u8207\u5132\u5b58\u5a92\u9ad4\u5c0d\u61c9\u95dc\u4fc2)\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u512a\u9ede\uff1a\u5be6\u73fe\u8cc7\u6599\u7368\u7acb(\u4fee\u6539\u67d0\u5c64\u7db1\u8981\u4e0d\u9700\u4fee\u6539\u4e0a\u5c64\u7db1\u8981\u7684\u80fd\u529b)\u3002<br \/>\u908f\u8f2f\u8cc7\u6599\u7368\u7acb\uff1a\u4fee\u6539\u6982\u5ff5\u7db1\u8981(\u5982\u589e\u52a0\u6b04\u4f4d)\uff0c\u4e0d\u7528\u4fee\u6539\u4e0a\u5c64\u7db1\u8981(\u5916\u90e8\u7db1\u8981\u548cAP)\u7684\u80fd\u529b\uff0c\u9700\u81ea\u884c\u64b0\u5beb\u8f49\u63db\u7a0b\u5f0f\uff0c\u8f03\u96e3\u9054\u6210\u3002<br \/>\u5be6\u9ad4\u8cc7\u6599\u7368\u7acb\uff1a\u4fee\u6539\u5167\u90e8\u7db1\u8981(\u5982\u589e\u52a0\u7d22\u5f15)\uff0c\u4e0d\u7528\u4fee\u6539\u4e0a\u5c64\u7db1\u8981(\u6982\u5ff5\u5916\u90e8\u548cAP)\u7684\u80fd\u529b\uff0c\u53ef\u7531DBMS\u81ea\u52d5\u8f49\u63db\uff0c\u5bb9\u6613\u9054\u6210\u3002<br \/>\u8cc7\u6599\u7368\u7acb\u95dc\u9375\u5728\u65bc\u4e0a\u4e0b\u76f8\u9130\u7db1\u8981\u7684\u6620\u5c04(Mapping)\u6a5f\u5236\uff1b\u53ea\u9700\u4fee\u6539\u7db1\u8981\u6620\u5c04\uff0c\u8abf\u6574\u8b8a\u52d5\u90e8\u4efd\uff0c\u5176\u9918\u7db1\u8981\u69cb\u4ef6\u4fdd\u6301\u4e0d\u8b8a\uff0c\u5373\u53ef\u9054\u5230\u8cc7\u6599\u7368\u7acb\u7684\u6548\u679c\uff0c\u53ef\u907f\u514d\u7db1\u8981\u6f14\u9032\u6642\uff0c\u9700\u5927\u5e45\u4fee\u6539\u7a0b\u5f0f\u78bc\u7684\u984d\u5916\u8ca0\u64d4\u3002<br \/>\u7f3a\u9ede\uff1a\u8cc7\u6599\u5c64\u5c64\u6620\u5c04(Mapping)\u6548\u7387\u5dee\uff0c\u5c11\u6578DBMS\u5be6\u4f5c\u5b8c\u6574\u4e09\u5c64\u5f0f\u3002<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2.91mai.com\/o2o\/image\/8b02c530-5323-49dc-880a-126d9ec8ee69.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p>\u5be6\u9ad4(Entity)\uff1a<\/p>\r\n\r\n\r\n\r\n<p>\u771f\u5be6\u4e16\u754c\u7269\u4ef6\u6216\u89c0\u5ff5\uff1b\u76f8\u540c\u6027\u8cea\u5be6\u9ad4\u6240\u6210\u7684\u96c6\u5408\uff0c\u7a31\u5be6\u9ad4\u985e\u578b(Entity Type)\uff0c\u4f9d\u6709\u7121\u9375\u503c(\u53ef\u5340\u5206\u5be6\u9ad4\u552f\u4e00\u6027)\u5206\u985e\u3002<br \/>\u6709\u9375\u503c\uff0c\u7a31\u5f37\u5be6\u9ad4\uff0c\u5982\u54e1\u5de5\u3001\u5c08\u6848\uff0c\u77e9\u5f62\u3002<br \/>\u7121\u9375\u503c\uff0c\u7a31\u5f31\u5be6\u9ad4\uff0c\u5982\u7737\u5c6c\uff0c\u8cc7\u6599\u53ef\u91cd\u8907\uff0c\u96d9\u7dda\u77e9\u5f62\uff1b\u53c8\u7a31\u5b50\u5be6\u9ad4\uff5c\u5f9e\u5c6c\u5be6\u9ad4(Child\uff5cSubordinate)\uff0c\u9700\u4f9d\u9644\u7236\u5be6\u9ad4\uff5c\u8b58\u5225\u5be6\u9ad4\uff5c\u652f\u914d\u5be6\u9ad4\uff5c\u64c1\u6709\u8005(Parent\uff5cIdentifying\uff5cDominant\uff5cOwner)\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u95dc\u4fc2(Relationship)\uff1a<br \/>\u5be6\u9ad4\u9593\u95dc\u806f\u6027\uff1b\u76f8\u540c\u6027\u8cea\u95dc\u4fc2\u6240\u6210\u7684\u96c6\u5408\uff0c\u7a31\u95dc\u4fc2\u985e\u578b(Relationship Type)\uff0c\u4f9d\u53c3\u8207\u8005\u5206\u985e\u3002<br \/>\u7686\u5f37\u5be6\u9ad4\uff0c\u7a31\u5f31\u95dc\u4fc2\uff0c\u5982\u54e1\u5de5\uff0d\u53c3\u8207\uff0d\u5c08\u6848\uff0c\u83f1\u5f62\u3002<br \/>\u6709\u5f31\u5be6\u9ad4\uff0c\u7a31\u5f37(\u8b58\u5225)\u95dc\u4fc2\uff0c\u5982\u54e1\u5de5\uff0d\u64c1\u6709\uff0d\u7737\u5c6c\uff0c\u96d9\u7dda\u83f1\u5f62\u3002<br \/>\u591a\u91cd(Multiple)\u95dc\u4fc2\uff1a2\u5be6\u9ad4\u9593\u6709\u591a\u500b\u95dc\u4fc2\uff0c\u5982\u54e1\u5de5\u8207\u5c08\u6848\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u5c6c\u6027(Attribute)\uff1a\u5be6\u9ad4\u985e\u578b\u6216\u95dc\u4fc2\u985e\u578b\u7684\u91cd\u8981\u7279\u6027\uff0c\u4ee5\u6a62\u5713\u8868\u793a\u3002<br \/>\u53ef\u4ee5\u5206\u5272\uff1a\u8907\u5408\u5c6c\u6027(Composite)\uff0c\u5982\u751f\u65e5\uff1d\u5e74\uff0b\u6708\uff0b\u65e5\u3002<br \/>\u4e0d\u53ef\u5206\u5272\uff1a\u7c21\u55ae\uff5c\u55ae\u5143\u5c6c\u6027(Simple\uff5cAtomic)\uff0c\u5982\u8077\u696d\uff1b\u7c21\u55ae\u5c6c\u6027\u53ef\u80fd\u503c\u6240\u6210\u96c6\u5408\uff0c\u7a31\u5c6c\u6027\u5b9a\u7fa9\u57df(Domain)\u3002<br \/>\u53ea\u5b58\u55ae\u4e00\u503c\uff1a\u55ae\u503c\u5c6c\u6027(Single-Valued)\uff0c\u5982\u59d3\u540d\u3002<br \/>\u53ef\u5b58\u591a\u500b\u503c\uff1a\u591a\u503c\u5c6c\u6027(Multi-valued)\uff0c\u5982\u96fb\u8a71\u865f\u78bc\uff0c\u96d9\u6a62\u5713\u3002<br \/>\u9700\u5be6\u969b\u5132\u5b58\uff1a\u5167\u5132\u5c6c\u6027(Stored)\uff0c\u5982\u751f\u65e5\u3002<br \/>\u53ef\u63a8\u7b97\u6c42\u5f97\uff1a\u884d\u751f\u5c6c\u6027(Derived)\uff0c\u5982\u5e74\u9f61\uff0c\u865b\u7dda\u6a62\u5713\u3002<br \/>\u9375\u503c\u5c6c\u6027(Key)\u8207\u90e8\u4efd\u9375(Partial Key)\uff1a<br \/>\u9375\u503c\u5c6c\u6027\uff1a\u5340\u5206\u5f37\u5be6\u9ad4\u552f\u4e00\u6027\uff0c\u5982\u54e1\u5de5\u7de8\u865f\uff0c\u52a0\u5e95\u7dda\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u90e8\u4efd\u9375\uff1a\u5340\u5206\u5f31\u5be6\u9ad4\u5c0d\u540c\u4e00\u5f37\u5be6\u9ad4\u552f\u4e00\u6027\uff0c\u5982\u7737\u5c6c\uff0d\u59d3\u540d\uff0c\u52a0\u865b\u7dda\u5e95\u7dda\uff1b\u5c6c\u6027\u503c\u53ef\u91cd\u8907(\u540c\u4e00\u54e1\u5de5\uff0c\u7737\u5c6c\u59d3\u540d\u5fc5\u76f8\u7570\uff1b\u4e0d\u540c\u54e1\u5de5\uff0c\u7737\u5c6c\u59d3\u540d\u53ef\u76f8\u540c)\uff0c\u5f31\u5be6\u9ad4\u9375\u503c\uff1d\u90e8\u4efd\u9375\uff0b\u64c1\u6709\u8005\u9375\u503c\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u95dc\u806f\u6a21\u578b\u7684\u9650\u5236(Constraint)<br \/>\u8cc7\u6599\u5b8c\u6574\u6027(Data Integrity)\uff1a\u70ba\u78ba\u4fdd\u8cc7\u6599\u5eab\u80fd\u6b63\u5e38\u904b\u4f5c\uff0c\u95dc\u806f\u5167\u6240\u6709\u503c\u7d44\u9700\u6eff\u8db3\u67d0\u4e9b\u9650\u5236\uff1b1\u8cc7\u6599\u5eab\u5167\u6240\u6709\u8cc7\u6599(\u6240\u6709\u95dc\u806f\u7684\u503c\u7d44)\u7686\u6eff\u8db3\u61c9\u6709\u9650\u5236\uff0c\u7a31\u4e00\u81f4(Consistent)\uff0c\u4ee5\u5b8c\u6574\u6027\u9650\u5236\u898f\u7bc4\u8cc7\u6599\u4fee\u6539\u52d5\u4f5c\u9054\u6210\u3002<br \/>\u5b9a\u7fa9\u57df(\u503c\u57df)\u9650\u5236(Domain Constraint)\uff1a\u6bcf\u500b\u5c6c\u6027\u503c\u5fc5\u9808\u662f\u8a72\u5c6c\u6027\u5b9a\u7fa9\u57df\u51671\u500b(\u975e\u591a\u503c)\u4e0d\u53ef\u5206\u5272\u55ae\u5143\u503c(\u4e0d\u8907\u5408)\uff1b\u5c07\u6b04\u4f4d\u503c\u9650\u5236\u5728\u67d0\u660e\u78ba\u5b9a\u7fa9\u7684\u7bc4\u570d\u5167\uff0c\u53ef\u907f\u514d\u56e0\u8f38\u5165\u932f\u8aa4\u8cc7\u6599\u5c0e\u81f4\u61c9\u7528\u7cfb\u7d71\u7121\u6cd5\u6b63\u5e38\u904b\u4f5c\uff0c\u9032\u800c\u63d0\u5347\u8cc7\u6599\u5eab\u8f38\u5165\u932f\u8aa4\u8cc7\u6599\u514d\u75ab\u529b(Input Error Immunity)\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u95dc\u806f\u9375\u9650\u5236(Key Constraint)\uff1a\u6240\u6709\u503c\u7d44\uff0c\u95dc\u806f\u9375\u503c\u4e0d\u91cd\u8907\u3002<br \/>\u53ef\u8b58\u5225\u503c\u7d44\u552f\u4e00\u6027\u7684\u5c6c\u6027\u96c6\u5408\uff0c\u7a31\u8d85\u7d1a\u9375(Super Key\uff0c\u6700\u5c0f\u5019\u9078\uff0c\u6700\u5927\u5168\u90e8)\uff1b\u6700\u7c21\u8d85\u7d1a\u9375(\u5b50\u96c6\u5408\u4e0d\u518d\u8d85\u7d1a\uff0c\u6700\u5c0f\u6027\uff0b\u552f\u4e00\u6027)\uff0c\u7a31\u95dc\u806f\u9375\uff0c\u7c21\u7a31\u9375\u503c(Key)\uff0c\u53ef\u591a\u500b\uff0c\u7686\u70ba\u4e3b\u9375\u5019\u9078\uff0c\u6545\u7a31\u5019\u9078\u9375(Candidate)\u3002<br \/>\u5019\u9078\u9375\u64c71(\u6700\u77ed\u6700\u5e38\u7528\u6709\u610f\u7fa9\uff0c\u55ae\u4e00\u512a\u65bc\u8907\u5408\uff0c\u4e0d\u53ef\u865b\u6700\u597d\u6c38\u4e0d\u8b8a)\u7576\u4e3b\u9375(Primary Key)\uff1b\u5176\u9918\u7a31\u5019\u88dc\u9375\/\u6b21\u8981\u9375(Alternate\/Secondary)\u3002<br \/>\u5be6\u9ad4\u5b8c\u6574\u6027\u9650\u5236(Entity Integrity Constraint)\uff1a<br \/>\u4e3b\u9375\u503c\u4e0d\u53ef\u865b(\u4e3b\u8981\u5b9a\u7fa9)\uff0b\u4e0d\u53ef\u91cd\u8907(\u9375\u503c\u7279\u6027)\u3002<br \/>\u865b\u503c(NULL)3\u6db5\u7fa9\uff1a\u672a\u77e5(Unknown\uff0c\u4e0d\u77e5\u662f\u5426\u6709\u503c)\uff5c\u907a\u5931(Missing\uff0c\u6709\u503c\u4f46\u672a\u586b)\uff5c\u4e0d\u9069\u7528(Not Applicable N\/A\uff0c\u4e00\u5b9a\u7121\u503c)\u3002<br \/>\u53c3\u8003\u5b8c\u6574\u6027\u9650\u5236(Referential Integrity Constraint)\uff1a<br \/>\u5916\u9375\u5b9a\u7fa9\uff1aA(\u5b50)\u95dc\u806f\u5c6c\u6027\u96c6\u5408FK\uff0c\u70baB(\u7236)\u95dc\u806f\u7684\u4e3b\u9375(\u5019\u9078\u9375)\uff0c\u7a31FK\u70baA\u53c3\u8003(Reference)B\u7684\u5916\u9375(Foreign Key)\u3002<br \/>\u5b50\u95dc\u806f\u5916\u9375\u8996\u60c5\u6cc1\u53ef\u70ba\u865b\u503c\uff0c\u82e5\u4e0d\u865b\uff0c\u7236\u95dc\u806f\u4e3b\u9375\u9700\u6709\u5c0d\u61c9\u503c\u3002<br \/>ERD\u8f49\u63db(\u95dc\u806f\u7db1\u8981)\u898f\u5247<br \/>\u8f49\u63db\u5be6\u9ad4\uff1a<br \/>\u5f37\u5be6\u9ad4\uff1a1\u5be6\u9ad41\u95dc\u806f\uff0c\u5019\u9078\u9375\u64c71\u7576\u4e3b\u9375\uff0c\u5c6c\u6027\u8655\u7406\u539f\u5247(\u7c21\u55ae\u76f4\u63a5\u53d6\uff1b\u591a\u503c\u4e0d\u8003\u616e\uff1b\u8907\u5408\u53d6\u6240\u6709\u5143\u7d20\uff1b\u884d\u751f\u4e0d\u7d0d\u5165)\u3002<br \/>\u5f31\u5be6\u9ad4\uff1a1\u5be6\u9ad41\u95dc\u806f\uff0c\u5c6c\u6027\u8655\u7406\u540c\u4e0a\uff1b\u5f31\u5be6\u9ad4\u4e3b\u9375\uff1d\u90e8\u4efd\u9375\uff0b\u64c1\u6709\u8005\u4e3b\u9375\uff0c\u4e14\u64c1\u6709\u8005\u4e3b\u9375\u70ba\u5916\u9375\uff0c\u6307\u5411\u64c1\u6709\u8005\u3002<br \/>\u591a\u503c\u5c6c\u6027\uff1a\u7368\u7acb\u6210\u65b0\u95dc\u806f\uff1b\u65b0\u95dc\u806f\u4e3b\u9375\uff1d\u591a\u503c\u5c6c\u6027\uff0b\u539f\u95dc\u806f\u4e3b\u9375\uff0c\u4e14\u539f\u95dc\u806f\u4e3b\u9375\u70ba\u5916\u9375\uff0c\u6307\u5411\u539f\u95dc\u806f\u3002<br \/>\u8f49\u63db\u95dc\u4fc2\uff1a<br \/>2\u5143\u591a\u5c0d\u591a\uff1a\u7368\u7acb\u6210\u65b0\u95dc\u806f(\u542b\u95dc\u4fc2\u5c6c\u6027)\uff0c\u53c8\u7a31\u5c0d\u7167\u8868(Lookup Table)\u4f5c\u6cd5\uff1b\u65b0\u95dc\u806f\u4e3b\u9375\uff1d\u5169\u7aef\u4e3b\u9375\u8907\u5408(\u6545\u7a31\u8907\u5408\u5be6\u9ad4\uff0c\u70ba\u5169\u591a\u7aef\u5be6\u9ad4\u7684Bridge)\uff0c\u4ea6\u70ba\u5916\u9375\uff0c\u5206\u5225\u6307\u5411\u539f\u95dc\u806f\u3002<br \/>2\u51431\u5c0d1\uff1a\u4e00\u822c\u4f5c\u6cd5\uff0c\u4efb\u53d61\u7aef\u4e3b\u9375(\u542b\u95dc\u4fc2\u5c6c\u6027)\u52a0\u5230\u53e61\u7aef\u505a\u5916\u9375\uff1b\u5916\u9375\u503c\u53ef\u80fd\u7a7a\uff0c\u4ee5\u4e0b\u5217\u65b9\u5f0f\u6539\u5584\u3002<br \/>\u82e51\u7aef\u5b8c\u5168\u53c3\u8207\uff0c\u53e61\u90e8\u4efd\u53c3\u8207\uff1a\u90e8\u4efd\u53c3\u8207\u7aef\u4e3b\u9375(\u542b\u95dc\u4fc2\u5c6c\u6027)\u52a0\u5230\u5b8c\u5168\u53c3\u8207\u7aef\u505a\u5916\u9375(\u907f\u514d\u5916\u9375NULL\u503c)\u3002\u00a0<\/p>\r\n\r\n\r\n\r\n<p>\u5c0d\u7167\u8868\u4f5c\u6cd5\uff1a\u7368\u7acb\u6210\u65b0\u95dc\u806f\uff0c\u5169\u7aef\u4e3b\u9375\u70ba\u5916\u9375\uff0c\u4efb\u90781\u70ba\u4e3b\u9375\u3002<br \/>\u512a\u9ede\uff1a\u9069\u5408\u53ea\u6709\u5c11\u6578\u95dc\u4fc2\u5be6\u4f8b\uff0c\u53ef\u907f\u514d\u5916\u9375NULL\u503c\u3002<br \/>\u7f3a\u9ede\uff1a\u984d\u5916\u95dc\u806f\u8868\uff0c\u4e14\u67e5\u8a62\u8a73\u7d30\u8cc7\u6599\u6642\uff0c\u9700\u505a\u5408\u4f75\u904b\u7b97\u3002<br \/>2\u51431\u5c0d\u591a\u95dc\u4fc2\uff1a2\u7a2e\u8f49\u63db\u65b9\u5f0f\u3002<br \/>\u5c071\u7aef\u4e3b\u9375(\u542b\u95dc\u4fc2\u5c6c\u6027)\u52a0\u5230\u591a\u7aef\u505a\u5916\u9375\u3002<br \/>\u5c0d\u7167\u8868\u4f5c\u6cd5\uff1a\u7368\u7acb\u6210\u65b0\u95dc\u806f\uff0c\u5169\u7aef\u4e3b\u9375\u70ba\u5916\u9375\uff0c\u591a\u7aef\u70ba\u4e3b\u9375\u3002<br \/>\u591a\u5143(2\u5143\u4ee5\u4e0a)\u95dc\u4fc2\uff1a\u7368\u7acb\u6210\u65b0\u95dc\u806f(\u542b\u95dc\u4fc2\u5c6c\u6027)\uff0c\u65b0\u95dc\u806f\u4e3b\u9375\uff1d\u6240\u6709\u591a\u7aef\u4e3b\u9375(1\u7aef\u4e3b\u9375\u4e0d\u7d0d\u5165)\uff0c\u4ea6\u70ba\u5916\u9375\uff0c\u5206\u5225\u6307\u5411\u539f\u95dc\u806f\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u4e0d\u53ef\u5316\u7c21\u96c6\u5408\u6c42\u6cd5\uff1a<br \/>\u53f3\u908a\u4e0d\u53ef\u5316\u7c21\uff1a\u5206\u89e3\u5f8b\uff0c\u53f3\u908a(\u8907\u5408\u5c6c\u6027)\u5316\u55ae\u4e00\u3002<br \/>\u5de6\u908a\u4e0d\u53ef\u5316\u7c21\uff1a\u5de6\u908a(\u8907\u5408\u5c6c\u6027)\u53bb\u591a\u9918(\u5c6c\u6027)\uff0c2\u65b9\u5411\u3002<br \/>\u80fd\u522a\u9664\u76f4\u63a5\u522a\uff1a\u53cd\u8eab\u6216\u53cd\u8eab\uff0b\u5df2\u77e5\uff0c\u914d\u5408\u905e\u79fb\uff0c\u522a\u9664\u591a\u9918FD\u3002<br \/>\u4e0d\u80fd\u522a\u53ef\u53d6\u4ee3\uff1a\u5df2\u77e5\uff0b\u64f4\u5145\uff0c\u914d\u5408\u905e\u79fb\uff0c\u55ae\u4e00(\u5c6c\u6027FD)\u53d6\u4ee3\u8907\u5408(\u5c6c\u6027FD)\u3002<br \/>FD\u4e0d\u53ef\u5316\u7c21\uff1a\u905e\u79fb\u5f8b\uff0c\u522a\u9664\u591a\u9918FD\u3002<br \/>\u6c42F\uff1d{A\u2192BC\uff0cA\u2192C\uff0cAB\u2192C\uff0cC\u2192B\uff0cBC\u2192D}\u6700\u7c21\u529f\u80fd\u76f8\u4f9d\u3002<br \/>\u53f3\u908a\u4e0d\u53ef\u5316\u7c21\uff1a\u5206\u89e3\u5f8b\uff0c\u53f3\u908a\u5316\u55ae\u4e00\u3002<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2.91mai.com\/o2o\/image\/85b6e748-829d-4a57-8d8d-67729c744d0a.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p>\u95dc\u806f\u5206\u5272(Decomposition)\u8207\u6b63\u898f\u5316<\/p>\r\n\r\n\r\n\r\n<p>\u95dc\u806f\u5206\u5272\uff1a\u7d66\u5b9a\u4e00\u5168\u57df\u95dc\u806f(Universal\uff0c\u6240\u6709\u5c6c\u6027\u7684\u96c6\u5408)R\uff0c\u7d66\u5b9aR\u4e0a\u4e00\u7d44\u529f\u80fd\u76f8\u4f9d\u96c6\u5408F\uff0c\u5229\u7528F\u5c07R\u5206\u5272\u6210\u4e00\u7d44\u95dc\u806f\u7db1\u8981\u7684\u96c6\u5408D\uff1d{R1\uff0cR2\uff0c\u2026\uff0cRm}\uff0c\u7a31\u95dc\u806f\u5206\u5272\uff0c\u53c8\u7a31\u95dc\u806f\u7db1\u8981\u8a2d\u8a08\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u6b63\u898f\u5316\uff1a\u5c07\u4e00\u500b\u95dc\u806f\u7db1\u8981\u5206\u5272\u6210\u591a\u500b\u7d50\u69cb\u826f\u597d\u95dc\u806f\u7db1\u8981\u7684\u904e\u7a0b\uff0c\u7a31\u6b63\u898f\u5316\uff0c\u9700\u6eff\u8db3\u5c6c\u6027\u4fdd\u7559\uff06\u7121\u5931\u5206\u52722\u689d\u4ef6\uff0c\u53ef\u964d\u4f4e(\u8cc7\u6599)\u91cd\u8986\u3001\u907f\u514d(\u66f4\u65b0\uff06\u589e\u522a)\u7570\u5e38(\u8003\u8a66\u91cd\u9ede\uff1d\u5b9a\u7fa9\uff0b\u5be6\u4f8b\uff0b\u5206\u5272\u65b9\u5f0f)\u3002<br \/>\u7b2c\u4e00\u6b63\u898f\u5316\u5f62\u5f0f(First Normal Form\uff0c1NF)\uff1a\u95dc\u806fR\u7b26\u5408\u5b9a\u7fa9\u57df\u9650\u5236\uff0c\u5373\u5c6c\u6027\u503c\u5fc5\u9808\u662f\u5b9a\u7fa9\u57df\u51671\u500b(\u975e\u591a\u503c)\u4e0d\u53ef\u5206\u5272\u55ae\u5143\u503c(\u4e0d\u8907\u5408)\u3002<br \/>\u7b2c\u4e8c\u6b63\u898f\u5316\u5f62\u5f0f(Second Normal Form\uff0c2NF)\uff1a\u95dc\u806fR\u7b26\u54081NF\uff0c\u4e14\u6240\u6709\u975e\u4e3b\u9375\u5c6c\u6027\u5b8c\u5168\u529f\u80fd\u76f8\u4f9d\u65bc\u4e3b\u9375(\u7121\u90e8\u4efd\u76f8\u4f9d)\u3002<br \/>\u7b2c\u4e09\u6b63\u898f\u5316\u5f62\u5f0f(Third Normal Form\uff0c3NF)\uff1a\u95dc\u806fR\u7b26\u54082NF\uff0c\u4e14\u6240\u6709\u975e\u4e3b\u9375\u5c6c\u6027\u975e\u905e\u79fb\u76f8\u4f9d\u65bc\u4e3b\u9375(\u7121\u905e\u79fb\u76f8\u4f9d)\u3002<br \/>Boyce-Codd\u6b63\u898f\u5316\u5f62\u5f0f(Boyce-Codd Normal Form\uff0cBCNF)\uff1a\u95dc\u806fR\u4e2d\u4efb\u4f55\u529f\u80fd\u76f8\u4f9dX\u2192A\uff0c\u6240\u6709\u6c7a\u5b9a\u56e0\u5b50(X)\u7686\u70ba\u8d85\u7d1a\u9375(\u5019\u9078\u9375)\uff0c\u7a31R\u7b26\u5408BCNF(\u6bd43NF\u5c111\u689d\u4ef6\uff0c\u66f4\u56b4\u8b39\uff1b\u76f4\u63a5\u5224\u5b9a\uff0c\u4e0d\u97001\/2\/3NF\u6e2c\u8a66)\u3002<br \/>\u591a\u91cd\u503c\u76f8\u4f9d\u8207\u7b2c\u56db\u6b63\u898f\u5316\uff1a\u5df2\u77e5R(X\uff0cY\uff0cZ)\u3002<br \/>\u6bcf\u500bX\u53ef\u6c7a\u5b9a\u591a\u500bY\u8207Z\u7121\u95dc\uff0c\u7a31X\u591a\u503c\u6c7a\u5b9aY\uff0c\u4ee5X\u2192\u2192Y\u8868\u793a\uff1b\u6bcf\u500bX\u53ef\u6c7a\u5b9a\u591a\u500bZ\u8207Y\u7121\u95dc\uff0c\u7a31X\u591a\u503c\u6c7a\u5b9aZ\uff0c\u4ee5X\u2192\u2192Z\u8868\u793a\uff1b\u95dc\u806fR\uff0c\u5c072\u500b\u7368\u7acb1\u5c0d\u591a\u95dc\u806f\u5408\u62101\u500b\u95dc\u806f\u6703\u6709\u8cc7\u6599\u91cd\u8986\u73fe\u8c61\uff0c\u7a31\u591a\u91cd\u503c\u76f8\u4f9d(Multi-Valued Dependency\uff0cMVD)\uff1aX\u2192\u2192Y\uff5cZ\u3002<br \/>\u5be6\u4f8b\u5982\u4e0b\uff1a\u591a\u91cd\u503c\u76f8\u4f9d\uff0c\u8cc7\u6599\u91cd\u8907\u5132\u5b58\uff0c\u53ef\u80fd\u5c0e\u81f4\u5404\u7a2e\u7570\u5e38\u3002<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2.91mai.com\/o2o\/image\/ab6c07df-da54-4347-8b9a-799adec36645.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2.91mai.com\/o2o\/image\/9c1d45a0-0392-4112-a6bd-f4d482eeaa4e.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2.91mai.com\/o2o\/image\/473818e7-a876-4f79-94b4-dc09ba4f022a.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2.91mai.com\/o2o\/image\/aaabecaa-f88a-49a2-90a4-35b034a12819.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2.91mai.com\/o2o\/image\/daa944e6-9847-4319-b611-a13a4208fad4.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2.91mai.com\/o2o\/image\/2a1389e8-5a08-4a9b-af96-7ca3b4f5a3be.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p>\u540c\u96c6\u4e2d\u5f0f\uff0c\u4f7f\u7528\u8005\u4e0d\u6703\u611f\u53d7\u5230DDB\u7684\u5b58\u5728\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u8cc7\u6599\u5206\u5272(Data Fragmentation)\uff1a\u5c07\u8cc7\u6599\u8868\u5206\u5272\u6210\u591a\u500b\u7247\u65b7(Fragment)\uff0c\u4ee5\u5206\u6563\u5132\u5b58\u65bc\u4e0d\u540c\u7ad9\u53f0\uff0c\u53ef\u63d0\u5347\u7cfb\u7d71\u5b58\u53d6\u6548\u80fd\uff0c\u6709<strong>\u6c34\u5e73\u5206\u5272<\/strong>(Horizontal Fragmentation)\u8207<strong>\u5782\u76f4\u5206\u5272<\/strong>(Vertical Fragmentation)\u5169\u7a2e\u985e\u578b\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u6c34\u5e73\u5206\u5272\uff1a\u4ee5\u503c\u7d44\u5217\u70ba\u55ae\u4f4d\uff0c\u4f9d\u5c6c\u6027\u689d\u4ef6\u503c\uff0c\u5206\u5272\u8cc7\u6599\u8868\uff0c\u53ef\u5206\u6563\u5132\u5b58\u5728\u4e0d\u540c\u7ad9\u53f0\uff1b\u56e0\u7236\u5b50\u95dc\u806f\u8868(\u4ee5\u5916\u9375\u5efa\u7acb\u53c3\u8003\u95dc\u4fc2)\u5e38\u9700\u57f7\u884c\u5408\u4f75\u904b\u7b97\uff0c\u6545\u5b50\u95dc\u806f\u8868\u503c\u7d44\uff0c\u53ef\u914d\u5408\u7236\u95dc\u806f\uff0c\u5206\u5272\u914d\u7f6e\u5230\u5c0d\u61c9\u7ad9\u53f0\uff0c\u4ee5\u63d0\u5347\u5408\u4f75\u904b\u7b97\u57f7\u884c\u6548\u80fd\uff0c\u7a31\u884d\u751f\u6c34\u5e73\u5206\u5272\uff1b\u5169\u7a2e\u6c34\u5e73\u5206\u5272\uff0c\u5be6\u4f8b\u5982\u4e0b\u5716(\u7236\u95dc\u806f\u4f9d\u300c\u5206\u516c\u53f8\u300d\u5206\u5272\uff0c\u5206\u6563\u5132\u5b58\u5f8c\uff0c\u8a72\u6b04\u9069\u60c5\u6cc1\u53ef\u7701\u7565\uff1b\u5b50\u95dc\u806f\u503c\u7d44\uff0c\u53ef\u4f34\u96a8\u7236\u95dc\u806f\uff0c\u5206\u5272\u914d\u7f6e\u5230\u5c0d\u61c9\u7684\u5340\u57df\u7ad9\u53f0)\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u5782\u76f4\u5206\u5272\uff1a\u4ee5\u5c6c\u6027\u6b04\u70ba\u55ae\u4f4d\uff0c\u4f9d\u5be6\u969b\u9700\u6c42\uff0c\u5206\u5272\u8cc7\u6599\u8868(\u5404\u8cc7\u6599\u8868\u9700\u4fdd\u7559\u539f\u6709\u4e3b\u9375\uff0c\u65b9\u53ef\u5408\u4f75\u6210\u539f\u6709\u8868\u683c)\uff0c\u53ef\u5206\u6563\u5132\u5b58\u5728\u4e0d\u540c\u7ad9\u53f0\uff0c\u5982\u4e0b\u5716(\u4f9d\u90e8\u9580\u9700\u6c42\u5206\u5272\uff0c\u5206\u6563\u5132\u5b58\u5f8c\uff0c\u6b04\u4f4d\u81ea\u52d5\u7701\u7565)\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u8cc7\u6599\u8907\u5beb(Data Replication)\uff1a\u5c07\u539f\u59cb\u4e3b\u8cc7\u6599\u5eab(Master)\u5167\u8cc7\u6599\uff0c\u5099\u4efd\u5230\u5176\u5b83\u7ad9\u53f0\u62f7\u8c9d\u8cc7\u6599\u5eab(Replica)\uff0c\u4ee5\u63d0\u5347DDB\u53ef\u9760\u6027(Reliability\uff1b\u8cc7\u6599\u6b63\u78ba\u7121\u8aa4)\u8207\u53ef\u7528\u6027(Availability\uff1b\u670d\u52d9\u53ef\u7528\u4e0d\u4e2d\u65b7)\uff1b\u53ef\u80fd\u7b56\u7565\u67093\uff0c\u8aaa\u660e\u5982\u4e0b\uff1b\u8cc7\u6599\u66f4\u65b0\u6642\uff0c\u9700\u540c\u6b65\u66f4\u65b0\u539f\u59cb\u8cc7\u6599\u7247\u65b7\u8207\u591a\u500b\u5099\u4efd\uff0c\u4ee5\u78ba\u4fdd\u8cc7\u6599\u9593\u7684\u4e00\u81f4\u6027\uff0c\u7a31\u66f4\u65b0\u50b3\u64ad\u554f\u984c(Update Propagation Problem)\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u6c92\u6709\u8907\u5beb(No Replication)\uff1a\u4e00\u500b\u8cc7\u6599\u7247\u65b7\u53ea\u5b58\u4e00\u500b\u7ad9\u53f0\uff0c\u4e0d\u8907\u5beb\uff0c\u53c8\u7a31\u7121\u91cd\u8907\u8cc7\u6599\u914d\u7f6e(Nonredundant Allocation)\uff1b\u512a\u9ede(\u7121\u66f4\u65b0\u50b3\u64ad\u554f\u984c)\uff1b\u7f3a\u9ede(\u8de8\u7ad9\u5b58\u53d6\u6548\u80fd\u5dee\uff0c\u4e14\u7cfb\u7d71\u53ef\u9760\u6027\uff06\u53ef\u7528\u6027\u4f4e)\uff1b\u5404\u7ad9\u8cc7\u6599\u5b58\u53d6\u5340\u57df\u6027\u5f37\u6642(\u8de8\u7ad9\u5b58\u53d6\u6b21\u6578\u5c11)\u9069\u7528\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u5b8c\u5168\u8907\u5beb(Complete Replication)\uff1a\u4e00\u500b\u8cc7\u6599\u5eab\uff0c\u5728\u6bcf\u500b\u7ad9\u53f0\uff0c\u7686\u6709\u5b8c\u6574\u5099\u4efd\uff0c\u53c8\u7a31\u5b8c\u5168\u8907\u5bebDDB(Fully Replicated DDB)\uff1b\u512a\u9ede(\u4e0d\u9700\u8de8\u7ad9\u5b58\u53d6\uff0c\u6548\u80fd\u4f73\uff0c\u7cfb\u7d71\u53ef\u9760\u6027\uff06\u53ef\u7528\u6027\u9ad8)\uff1b\u7f3a\u9ede(\u6709\u66f4\u65b0\u50b3\u64ad\u554f\u984c)\uff1b\u5404\u7ad9\u50c5\u6709\u5927\u91cf\u8cc7\u6599\u8b80\u53d6\uff0c\u5f88\u5c11\u5beb\u5165\u52d5\u4f5c(\u66f4\u65b0\u50b3\u64ad\u8ca0\u64d4\u8f15)\u6642\u9069\u7528\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u90e8\u4efd\u8907\u5beb(Partial Replication)\uff1a\u9069\u60c5\u6cc1\uff0c\u8907\u5beb\u90e8\u4efd\u8cc7\u6599\u7247\u65b7\uff0c\u53ef\u5728\u8de8\u7ad9\u5b58\u53d6\u6548\u80fd\u8207\u8cc7\u6599\u540c\u6b65\u6210\u672c\u9593\uff0c\u53d6\u5f97\u5e73\u8861\uff1b\u5404\u7ad9\u8cc7\u6599\u5b58\u53d6\u52d5\u4f5c\u5e73\u5747\u6642\u9069\u7528\uff1b\u4ee5\u8907\u5beb\u7db1\u8981(Replication Schema)\u63cf\u8ff0\u8cc7\u6599\u7247\u65b7\u8907\u5beb\u73fe\u6cc1\u3002<\/p>\r\n\r\n\r\n\r\n<p><strong>NoSQL(Not Only SQL)<\/strong><\/p>\r\n\r\n\r\n\r\n<p>NoSQL\u6e90\u8d77\uff1a\u50b3\u7d71\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\uff0c\u4ee5\u9ad8\u5ea6\u7d50\u69cb\u5316\u65b9\u5f0f(\u8cc7\u6599\u7db1\u8981\u5167\u9700\u660e\u78ba\u5b9a\u7fa9\u5be6\u9ad4\u9593\u7684\u95dc\u4fc2\u8207\u7d50\u69cb)\u5132\u5b58\u8cc7\u6599\uff0c\u5ef6\u5c55\u6027\uff06\u53ef\u7528\u6027\u5dee\uff0c\u4e0d\u5229\u65bc\u5de8\u91cf\u8cc7\u6599\u7684\u61c9\u7528\u74b0\u5883\uff1bNoSQL\u63a1\u5206\u6563\u5f0f\u7d50\u69cb\u6027\u8cc7\u6599\u5132\u5b58\u6280\u8853\uff0c\u4ee5CAP\u00a0\u5b9a\u7406\u70ba\u6838\u5fc3\uff0c\u5229\u7528BASE\u4ea4\u6613\u8655\u7406\u7279\u6027\uff0c\u63d0\u5347\u5de8\u91cf\u8cc7\u6599\u7684\u8655\u7406\u6548\u80fd\u3002<\/p>\r\n\r\n\r\n\r\n<p>NoSQL\u8cc7\u6599\u5eab\u00a04\u5927\u7279\u5fb5\uff1a<\/p>\r\n\r\n\r\n\r\n<p>\u7121\u7db1\u8981(Schema-Free)\uff1a\u7db2\u8def\u591a\u70ba\u534a\u7d50\u69cb\u6027(\u5982HTML\u6216XML\u6587\u4ef6)\u8207\u975e\u7d50\u69cb\u6027(\u5982\u5f71\u97f3\u6216\u5716\u7247)\u8cc7\u6599\uff0c\u901a\u5e38\u7121\u6cd5\u4e8b\u5148\u660e\u78ba\u5b9a\u7fa9\u5be6\u9ad4\u9593\u7684\u95dc\u4fc2\u8207\u7d50\u69cb\uff0c\u6545NoSQL\u8cc7\u6599\u5eab\u63a1\u53d6\u7121\u7db1\u8981\u7b56\u7565\uff0c\u5728\u8cc7\u6599\u5eab\u63d0\u4f9b\u7684\u8cc7\u6599\u7d50\u69cb\u57fa\u790e\u4e0a\uff0c\u5141\u8a31\u76f4\u63a5\u5132\u5b58\u4e26\u53d6\u7528\u8cc7\u6599\u5be6\u9ad4\uff0c\u7121\u9808\u4e8b\u5148\u5b9a\u7fa9\u7db1\u8981\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u9ad8\u5ef6\u5c55\u6027(High Scalability)\uff1a\u76f4\u63a5\u4ee5\u958b\u653e\u6a19\u6e96\u4e4b\u5927\u773e\u5316\u8edf\u786c\u9ad4\u8a2d\u5099(\u907f\u514dVendor Lock\u73fe\u8c61)\uff0c\u5feb\u901f\u4e14\u4f4e\u6210\u672c\u5730\u64f4\u5145\u5132\u5b58\u5bb9\u91cf\u8207\u8655\u7406\u80fd\u529b\uff0c\u7a31\u6c34\u5e73\u5f0f\u64f4\u5145\uff0c\u53ef\u6eff\u8db3\u96f2\u7aef\u8a08\u7b97\u7684\u9700\u6c42\uff0c\u6545NoSQL\u8cc7\u6599\u5eab\u5fc5\u9808\u5177\u5099\u81ea\u52d5\u8cc7\u6599\u8907\u88fd(Replication)\u3001\u5207\u5272\u8207\u8f49\u79fb\u7b49\u80fd\u529b\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u7c21\u55ae\u5b58\u53d6\u4ecb\u9762\uff1a\u70ba\u914d\u5408\u7121\u7db1\u8981\u7b56\u7565\uff0cNoSQL\u8cc7\u6599\u5eab\u4f9d\u5176\u63d0\u4f9b\u7684\u8cc7\u6599\u7d50\u69cb\u57fa\u790e\uff0c\u76f4\u63a5\u4ee5\u652f\u63f4\u958b\u767c\u8a9e\u8a00(\u5982Java\u6216C++)\u7684API\u53d6\u4ee3SQL\u505a\u70ba\u8cc7\u6599\u5b58\u53d6\u4ecb\u9762\uff0c\u6545SQL\u4e2d\u8907\u96dc\u529f\u80fd(\u5982JOIN)\uff0c\u901a\u5e38\u4e0d\u63d0\u4f9b\u3002<\/p>\r\n\r\n\r\n\r\n<p>\u6700\u7d42\u4e00\u81f4\u6027(Eventually Consistent)\uff1aNoSQL\u4ee5\u5206\u6563\u5f0f\u8cc7\u6599\u8907\u88fd\u6280\u8853(\u4e00\u4efd\u8cc7\u6599\u53ef\u8907\u88fd\u3001\u5b58\u653e\u5728\u591a\u500b\u4e0d\u540c\u5730\u7406\u4f4d\u7f6e\u7684\u8cc7\u6599\u4e2d\u5fc3)\uff0c\u4ee5\u63d0\u5347\u7cfb\u7d71\u7684\u53ef\u7528\u6027\uff1b\u591a\u500b\u8907\u672c\u4e4b\u9593\u5247\u63a1\u7528\u6700\u7d42\u4e00\u81f4\u6027\u7b56\u7565\uff0c\u5373\u8cc7\u6599\u66f4\u65b0\u6642\uff0c\u50c5\u4fdd\u8b49\u5728\u67d0\u6bb5\u5920\u9577\u6642\u9593\u5167\uff0c\u9010\u6b65\u66f4\u65b0\u5230\u6240\u6709\u8907\u672c\uff0c\u800c\u975e\u7acb\u5373\u540c\u6b65\u3002<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><strong>\u770b\u66f4\u591a\u9069\u5408\u9ad8\u666e\u8003\u8003\u8a66\u81ea\u5b78\u6e96\u5099\u7684\u6700\u65b0\u66f8\u7c4d\u3001\u7dda\u4e0a\u8ab2\u7a0b\u8cc7\u8a0a&gt;&gt;<a href=\"https:\/\/www.eyebook.com.tw\/page\/Public1?utm_source=wordpress&amp;utm_campaign=108%E9%AB%98%E6%99%AE%E8%80%83%E8%80%83%E5%89%8D%E9%87%8D%E9%BB%9E%E6%95%B4%E7%90%86&amp;utm_medium=post&amp;utm_content=_NA_NA_2192_lulu_NA\" data-type=\"URL\" data-id=\"https:\/\/www.eyebook.com.tw\/page\/Public1?utm_source=wordpress&amp;utm_campaign=108%E9%AB%98%E6%99%AE%E8%80%83%E8%80%83%E5%89%8D%E9%87%8D%E9%BB%9E%E6%95%B4%E7%90%86&amp;utm_medium=post&amp;utm_content=_NA_NA_2192_lulu_NA\" target=\"_blank\" rel=\"noopener\">\u9ede\u6211\u7acb\u5373\u524d\u5f80<\/a><\/strong><\/h3>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>\u81e8\u6642\u62b1\u4f5b\u8173\uff0c\u4e5f\u8981\u6709\u6280\u5de7\uff01\u8001\u5e2b\u90fd\u77e5\u9053\u540c\u5b78\u5011\u6700\u5bb9\u6613\u641e\u6df7\u7684\u89c0\u5ff5\u6709\u54ea\u4e9b\uff0c\u5ff5\u7684\u5fc3\u9a5a\u9a5a\u7684\u90e8\u5206\u5728\u54ea\u908a\uff0c\u6240\u4ee5\u5462~\u7279\u5730\u6e96\u5099\u4e86\u9019\u4efd [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[200,210],"tags":[202,201,176],"class_list":["post-2192","post","type-post","status-publish","format-standard","hentry","category-gaopu-exam-general-review","category-general-review","tag-202","tag-201","tag-176"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/eyebook.blog\/index.php?rest_route=\/wp\/v2\/posts\/2192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eyebook.blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eyebook.blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eyebook.blog\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/eyebook.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2192"}],"version-history":[{"count":4,"href":"https:\/\/eyebook.blog\/index.php?rest_route=\/wp\/v2\/posts\/2192\/revisions"}],"predecessor-version":[{"id":3143,"href":"https:\/\/eyebook.blog\/index.php?rest_route=\/wp\/v2\/posts\/2192\/revisions\/3143"}],"wp:attachment":[{"href":"https:\/\/eyebook.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eyebook.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eyebook.blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}