{"id":244302,"date":"2022-06-18T09:01:20","date_gmt":"2022-06-18T01:01:20","guid":{"rendered":"https:\/\/lrxjmw.cn\/?p=244302"},"modified":"2022-06-04T02:02:24","modified_gmt":"2022-06-03T18:02:24","slug":"what-is-nosql-this","status":"publish","type":"post","link":"https:\/\/lrxjmw.cn\/what-is-nosql-this.html","title":{"rendered":"\u4ec0\u4e48\u662fNoSQL?\u8fd9\u91cc\u7ed9\u4f60\u6574\u660e\u767d"},"content":{"rendered":"<table>\n<tbody>\n<tr>\n<td style=\"padding: 5px 12px; width: 25px; font-size: 22px; text-align: center; background: #E8E8E8; line-height: 30px; color: #999;\">\u5bfc\u8bfb<\/td>\n<td style=\"padding: 10px 10px 12px; line-height: 20px;\"><strong>NoSQL\u662f\u4e00\u7c7b\u975e SQL\uff08\u5173\u7cfb\uff09\u6570\u636e\u5e93\uff0c\u4f7f\u7528\u9884\u5b9a\u4e49\u8868\u548c\u5217\u4e4b\u5916\u7684\u5176\u4ed6\u6570\u636e\u6a21\u578b\u3002\u6b64\u7c7b\u5305\u542b\u8bb8\u591a\u4e0d\u540c\u7c7b\u578b\u7684\u6570\u636e\u5e93\u4ee5\u53ca\u6570\u636e\u5b58\u50a8\u548c\u64cd\u4f5c\u7684\u65b9\u6cd5\u3002<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10.png\" alt=\"\" width=\"570\" height=\"319\" class=\"alignnone size-full wp-image-244303\" srcset=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10.png 570w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-300x168.png 300w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<div   id="j6sjwn9j3u"    style=\"font-size: 14pt; color: white; background-color: black; border-left: red 10px solid; padding-left: 14px; margin-bottom: 20px; margin-top: 20px;\"><strong>\u4e00\u3001\u4ec0\u4e48\u662f NoSQL<\/strong><\/div>\n<p>NoSQL\u662f\u4e00\u7c7b\u975e SQL\uff08\u5173\u7cfb\uff09\u6570\u636e\u5e93\uff0c\u4f7f\u7528\u9884\u5b9a\u4e49\u8868\u548c\u5217\u4e4b\u5916\u7684\u5176\u4ed6\u6570\u636e\u6a21\u578b\u3002\u6b64\u7c7b\u5305\u542b\u8bb8\u591a\u4e0d\u540c\u7c7b\u578b\u7684\u6570\u636e\u5e93\u4ee5\u53ca\u6570\u636e\u5b58\u50a8\u548c\u64cd\u4f5c\u7684\u65b9\u6cd5\u3002<\/p>\n<div   id="j6sjwn9j3u"    style=\"font-size: 14pt; color: white; background-color: black; border-left: red 10px solid; padding-left: 14px; margin-bottom: 20px; margin-top: 20px;\"><strong>\u4e8c\u3001\u4ec0\u4e48\u662f SQL<\/strong><\/div>\n<p>NoSQL\u4e0e\u51e0\u5341\u5e74\u6765\u4e8b\u5b9e\u4e0a\u7684\u6807\u51c6\u5173\u7cfb (SQL) \u6570\u636e\u5e93\u76f8\u5bf9\u7acb\u3002SQL \u6570\u636e\u5e93\u5c06\u6570\u636e\u5b58\u50a8\u5728\u7531\u5177\u6709\u4e25\u683c\u6570\u636e\u7c7b\u578b\u7684\u5217\u7ec4\u6210\u7684\u9884\u5b9a\u4e49\u8868\u4e2d\u3002\u8868\u53ef\u4ee5\u5177\u6709\u552f\u4e00\u6027\uff08\u8868\u4e2d\u884c\u4e4b\u95f4\u7684\u5173\u7cfb\uff09\u3001\u68c0\u67e5\u7ea6\u675f\uff08\u9a8c\u8bc1\u4e00\u884c\u4e2d\u7684\u6570\u636e\uff09\u6216\u5916\u952e\u7ea6\u675f\uff08\u4e0d\u540c\u8868\u4e2d\u6570\u636e\u4e4b\u95f4\u7684\u5173\u7cfb\uff09\u3002<\/p>\n<p>\u793a\u4f8b\u5173\u7cfb\u6570\u636e\u6a21\u578b\uff1a<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-1-1024x272.jpg\" alt=\"\" width=\"1024\" height=\"272\" class=\"alignnone size-large wp-image-244304\" srcset=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-1-1024x272.jpg 1024w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-1-300x80.jpg 300w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-1-768x204.jpg 768w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-1.jpg 1214w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>SQL\u662f\u4e00\u79cd\u6807\u51c6\u67e5\u8be2\u8bed\u8a00\uff0c\u7528\u4e8e\u5b9a\u4e49\u3001\u64cd\u4f5c\u548c\u641c\u7d22\u5173\u7cfb\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e\u3002<\/p>\n<p>\u57fa\u672c SQL \u67e5\u8be2\uff1a<\/p>\n<pre>\r\nselect customer_no, first_name, last_name, last_purchase\r\nfrom customers\r\nwhere address_state = 'CA'\r\n<\/pre>\n<div   id="j6sjwn9j3u"    style=\"margin-top:2em;margin-bottom:1em\"><span style=\"color:#1E1E1E;letter-spacing: 2px;border-left:#FF3030 3px solid;border-right:#FF3030 3px solid;padding-left: 8px;padding-right:8px;font-size: 12pt\"><strong>\u4e3a\u4ec0\u4e48\u5173\u7cfb\u6570\u636e\u5e93\u8fd8\u4e0d\u591f\uff1f<\/strong><\/span><\/div>\n<p>\u6a21\u5f0f\u7684\u7075\u6d3b\u6027\u2014\u2014\u5173\u7cfb\u6570\u636e\u5e93\u5177\u6709\u56fa\u5b9a\u7684\u6a21\u5f0f\uff0c\u8fd9\u610f\u5473\u7740\u5b83\u4eec\u53ea\u80fd\u4fdd\u5b58\u7531\u6570\u636e\u5e93\u7ba1\u7406\u5458\u9884\u5b9a\u4e49\u7684\u5bf9\u8c61\uff08\u5728\u8868\u4e2d\uff09\u548c\u5c5e\u6027\uff08\u5728\u5217\u4e2d\uff09\uff08\u5199\u5165\u6a21\u5f0f\uff09\u3002<br \/>\n\u5f00\u53d1\u4e2d\u7684\u654f\u6377\u6027\u2014\u2014\u5fc5\u987b\u5728\u5199\u5165\u6570\u636e\u4e4b\u524d\u5b9a\u4e49\u6a21\u5f0f\u4f7f\u5f97\u5f00\u53d1\u6570\u636e\u5e93\u7684\u901f\u5ea6\u8981\u6162\u5f97\u591a\u3002\u5728 NoSQL \u6570\u636e\u5e93\u4e2d\uff0c\u60a8\u53ef\u4ee5\u53ea\u7f16\u5199\u6570\u636e\u5e76\u5728\u9700\u8981\u8bfb\u53d6\u6570\u636e\u65f6\u62c5\u5fc3\u5b83\u4eec\u7684\u6570\u636e\u683c\u5f0f\uff08\u8bfb\u53d6\u6a21\u5f0f\uff09\uff0c\u8fd9\u4f7f\u5f00\u53d1\u66f4\u52a0\u654f\u6377\u3002<br \/>\n\u6570\u636e\u5927\u5c0f\u2014\u2014\u8bb8\u591a NoSQL \u6570\u636e\u5e93\u5728\u6784\u5efa\u65f6\u90fd\u8003\u8651\u5230\u4e86\u5927\u89c4\u6a21\u6570\u636e\uff0c\u5e76\u4e14\u80fd\u591f\u5b58\u50a8\u5927\u91cf\u884c\u6216\u5bf9\u8c61\uff0c\u4ece\u800c\u727a\u7272\u4e86\u5bf9\u5176\u5b8c\u6574\u6027\u7684\u7ba1\u7406\u3002<\/p>\n<div   id="j6sjwn9j3u"    style=\"font-size: 14pt; color: white; background-color: black; border-left: red 10px solid; padding-left: 14px; margin-bottom: 20px; margin-top: 20px;\"><strong>\u4e09\u3001NoSQL \u6570\u636e\u5e93\u7684\u7c7b\u578b<\/strong><\/div>\n<div   id="j6sjwn9j3u"    style=\"margin-top:2em;margin-bottom:1em\"><span style=\"color:#1E1E1E;letter-spacing: 2px;border-left:#FF3030 3px solid;border-right:#FF3030 3px solid;padding-left: 8px;padding-right:8px;font-size: 12pt\"><strong>1\u3001\u6587\u6863\u6570\u636e\u5e93<\/strong><\/span><\/div>\n<p>\u6587\u6863\u6570\u636e\u5e93\u5c06\u6570\u636e\u5b58\u50a8\u5728 JSON \u6587\u6863\u4e2d\uff0c\u8fd9\u4e9b\u6587\u6863\u662f\u952e\u503c\u5bf9\u7684\u5206\u5c42\u96c6\u5408\u3002\u6587\u6863\u53ef\u80fd\u5f88\u590d\u6742\uff0c\u5e76\u4e14\u5305\u542b\u5b50\u6587\u6863\u548c\u5217\u8868\u3002<\/p>\n<p>\u8fd9\u662f\u4ee3\u8868\u5ba2\u6237\u7684\u793a\u4f8b\u6587\u6863\uff1a<\/p>\n<pre>\r\n{\r\n  \"id\": \"1\",\r\n  \"name\":{\r\n    \"firstName\":\"John\",\r\n    \"lastName\": \"Doe\"\r\n  },\r\n  \"address\":{\r\n    \"street\":\"Lombard street\",\r\n    \"city\": \"San Francisco\",\r\n    \"state\": \"CA\",\r\n    \"country\": \"US\",\r\n  }\r\n}\r\n<\/pre>\n<p>\u6d41\u884c\u7684\u6587\u6863\u6570\u636e\u5e93\uff1a<\/p>\n<li>MongoDB<\/li>\n<li>DynamoDB<\/li>\n<li>Couchbase<\/li>\n<li>CouchDB<\/li>\n<div   id="j6sjwn9j3u"    style=\"margin-top:2em;margin-bottom:1em\"><span style=\"color:#1E1E1E;letter-spacing: 2px;border-left:#FF3030 3px solid;border-right:#FF3030 3px solid;padding-left: 8px;padding-right:8px;font-size: 12pt\"><strong>2\u3001\u952e\u503c\u5b58\u50a8<\/strong><\/span><\/div>\n<p>\u952e\u503c\u5b58\u50a8\u662f\u6700\u57fa\u672c\u7684 NoSQL \u6570\u636e\u5e93\uff0c\u5c06\u6570\u636e\u5b58\u50a8\u5728\u7b80\u5355\u7684\u952e\u503c\u5bf9\u4e2d\uff08\u5728\u6700\u7b80\u5355\u7684\u60c5\u51b5\u4e0b\uff0c\u4e24\u8005\u90fd\u662f\u7eaf\u5b57\u7b26\u4e32\uff09\uff0c\u8fd9\u610f\u5473\u7740\u60a8\u53ef\u4ee5\u5728\u7279\u5b9a\u6807\u7b7e\u4e0b\u5b58\u50a8\u4e00\u4e9b\u503c\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-2.jpg\" alt=\"\" width=\"554\" height=\"262\" class=\"alignnone size-full wp-image-244305\" srcset=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-2.jpg 554w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-2-300x142.jpg 300w\" sizes=\"auto, (max-width: 554px) 100vw, 554px\" \/><\/p>\n<p>Redis\u7684\u4e00\u4e2a\u4f8b\u5b50\uff1a<\/p>\n<pre>\r\n> set customer1 JohnDoe\r\n<\/pre>\n<p>\u6d41\u884c\u7684\u952e\u503c\u5b58\u50a8\uff1a<\/p>\n<li>Redis<\/li>\n<li>Berkley DB<\/li>\n<div   id="j6sjwn9j3u"    style=\"margin-top:2em;margin-bottom:1em\"><span style=\"color:#1E1E1E;letter-spacing: 2px;border-left:#FF3030 3px solid;border-right:#FF3030 3px solid;padding-left: 8px;padding-right:8px;font-size: 12pt\"><strong>3\u3001\u56fe\u6570\u636e\u5e93<\/strong><\/span><\/div>\n<p>\u56fe\u6570\u636e\u5e93\u5c06\u6570\u636e\u8868\u793a\u4e3a\u7531\u8282\u70b9\u548c\u5173\u7cfb\u6784\u5efa\u7684\u7f51\u7edc\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-3.jpg\" alt=\"\" width=\"706\" height=\"674\" class=\"alignnone size-full wp-image-244306\" srcset=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-3.jpg 706w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-3-300x286.jpg 300w\" sizes=\"auto, (max-width: 706px) 100vw, 706px\" \/><\/p>\n<p>\u6d41\u884c\u7684\u56fe\u6570\u636e\u5e93\uff1a<\/p>\n<li>Neo4J<\/li>\n<li>Giraph<\/li>\n<div   id="j6sjwn9j3u"    style=\"margin-top:2em;margin-bottom:1em\"><span style=\"color:#1E1E1E;letter-spacing: 2px;border-left:#FF3030 3px solid;border-right:#FF3030 3px solid;padding-left: 8px;padding-right:8px;font-size: 12pt\"><strong>4\u3001\u5bbd\u5217\u5b58\u50a8<\/strong><\/span><\/div>\n<p>\u5bbd\u5217\u5b58\u50a8\u5b58\u50a8\u7c7b\u4f3c\u4e8e\u5173\u7cfb\u6570\u636e\u5e93\uff0c\u5b83\u4eec\u5c06\u6570\u636e\u5b58\u50a8\u5728\u8868\u4e2d\uff0c\u4f46\u6570\u636e\u662f\u6309\u5217\u7269\u7406\u7ec4\u7ec7\u7684\u3002\u5bbd\u5217\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e\u662f\u7a00\u758f\u7684\uff0c\u8fd9\u610f\u5473\u7740\u7a7a\u5217\u4e0d\u5360\u7528\u7a7a\u95f4\uff0c\u5e76\u4e14\u5141\u8bb8\u5728\u8868\u4e2d\u521b\u5efa\u6570\u767e\u3001\u6570\u5343\u751a\u81f3\u6570\u767e\u4e07\u5217\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-4.png\" alt=\"\" width=\"852\" height=\"131\" class=\"alignnone size-full wp-image-244307\" srcset=\"https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-4.png 852w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-4-300x46.png 300w, https:\/\/lrxjmw.cn\/wp-content\/uploads\/2022\/06\/10-4-768x118.png 768w\" sizes=\"auto, (max-width: 852px) 100vw, 852px\" \/><br \/>\n\u6d41\u884c\u7684\u5bbd\u5217\u6570\u636e\u5e93\uff1a<\/p>\n<li>Apache Cassandra\u3002<\/li>\n<li>Apache HBase\u3002<\/li>\n<li>Google Bigtable\u3002<\/li>\n","protected":false},"excerpt":{"rendered":"<p>NoSQL\u662f\u4e00\u7c7b\u975e SQL\uff08\u5173\u7cfb\uff09\u6570\u636e\u5e93\uff0c\u4f7f\u7528\u9884\u5b9a\u4e49\u8868\u548c\u5217\u4e4b\u5916\u7684\u5176\u4ed6\u6570\u636e\u6a21\u578b\u3002\u6b64\u7c7b\u5305\u542b\u8bb8\u591a\u4e0d\u540c\u7c7b\u578b\u7684\u6570\u636e\u5e93\u4ee5\u53ca [&hellip;]<\/p>\n","protected":false},"author":1898,"featured_media":244310,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[55],"tags":[869],"class_list":["post-244302","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thread","tag-nosql"],"acf":[],"_links":{"self":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/244302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/users\/1898"}],"replies":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/comments?post=244302"}],"version-history":[{"count":3,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/244302\/revisions"}],"predecessor-version":[{"id":244311,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/244302\/revisions\/244311"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media\/244310"}],"wp:attachment":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media?parent=244302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/categories?post=244302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/tags?post=244302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}