{"id":15586,"date":"2023-08-18T00:13:08","date_gmt":"2023-08-18T08:13:08","guid":{"rendered":"https:\/\/www.horace.org\/blog\/?p=15586"},"modified":"2023-08-18T00:13:16","modified_gmt":"2023-08-18T08:13:16","slug":"database-design-for-mere-mortals-michael-j-hernandez","status":"publish","type":"post","link":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/","title":{"rendered":"Database Design for Mere Mortals &#8211; Michael J. Hernandez"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"405\" height=\"500\" data-attachment-id=\"15587\" data-permalink=\"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/51rnxaeryql-_sx403_bo1204203200_\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&amp;ssl=1\" data-orig-size=\"405,500\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"51rnXAEryqL._SX403_BO1204203200_\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?resize=405%2C500&#038;ssl=1\" alt=\"\" class=\"wp-image-15587\" srcset=\"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?w=405&amp;ssl=1 405w, https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?resize=243%2C300&amp;ssl=1 243w\" sizes=\"auto, (max-width: 405px) 100vw, 405px\" \/><\/figure>\n\n\n\n<p>\u6211\u5b78\u61c2\u5bebSQL\u5df2\u7d93\u5f88\u591a\u5e74\uff0c\u4f46\u6211\u5f9e\u4f86\u6c92\u6709\u6b63\u5f0f\u5730\u5b78\u7fd2\u5982\u4f55\u8a2d\u8a08\u4e00\u500bdatabase\uff0c\u5927\u591a\u6578\u53ea\u662f\u96a8\u4fbf\u5730\u4e0a\u7db2\u627e\u4e9bSQL\u4f8b\u5b50\u73fe\u7092\u73fe\u8ce3\u3002\u9019\u672c\u8ab2\u672c\u662fdatabase\u8a2d\u8a08\u7684\u5929\u66f8\uff0c\u5df2\u7d93\u6709\u4e8c\u5341\u4e94\u5e74\u6b77\u53f2\u51fa\u7248\u81f3\u7b2c\u56db\u7248\u3002\u6574\u672c\u66f8\u5167\u6c92\u6709\u6559\u4e00\u53e5SQL\u8a9e\u6cd5\uff0c\u82e5\u679c\u9023SQL\u9084\u672a\u61c2\u7684\u8a71\uff0c\u6050\u6015\u9019\u672c\u66f8\u592a\u904e\u8271\u6df1\u4e86\u3002<\/p>\n\n\n\n<p>\u6709\u4e09\u5206\u4e00\u672c\u66f8\u7684\u7bc7\u5e45\uff0c\u8ac7\u8ad6\u61c9\u8a72\u5982\u4f55\u8a2a\u554fdatabase\u7684\u7528\u5bb6\uff0c\u5728\u958b\u59cb\u8a2d\u8a08database\u4e4b\u524d\uff0c\u5148\u627e\u51fadatabase\u9700\u8981\u5132\u5b58\u7684\u8cc7\u6599\u548c\u8981\u505a\u4ec0\u9ebc\u985e\u578b\u7684query\u3002\u73fe\u5728\u770b\u5b8c\u66f8\u5f8c\u56de\u9867\u91cd\u6eab\uff0c\u89ba\u5f97\u9019\u90e8\u4efd\u6709\u9ede\u662f\u60f3\u7576\u7136\u723e\u7684\u5e38\u8b58\uff0c\u4f46\u6211\u521d\u6b21\u95b1\u8b80\u90a3\u4e9b\u7ae0\u7bc0\u6642\uff0c\u5f88\u6709\u589e\u5ee3\u898b\u805e\u7684\u65b0\u9bae\u611f\u3002\u6211\u5de5\u4f5c\u4e0a\u5beb\u4e86\u7a0b\u5f0f\u5e7e\u5341\u5e74\uff0c\u90a3\u4e9b\u7cfb\u7d71\u9700\u6c42\u7684\u898f\u683c\uff0c\u81ea\u554f\u898b\u904e\u4e0d\u5c11\u4ea6\u505a\u904e\u4e0d\u5c11\uff0c\u4f46\u6211\u59cb\u7d42\u662f\u908a\u505a\u908a\u5b78\u7d05\u8932\u5b50\u51fa\u8eab\uff0c\u7b2c\u4e00\u6b21\u63a5\u89f8\u5982\u6b64\u6709\u7cfb\u7d71\u5beb\u7cfb\u7d71\u9700\u6c42\u7684\u65b9\u6cd5\u3002<\/p>\n\n\n\n<p>Relational database\u662f\u4ec0\u9ebc\uff0c\u8aaa\u5230\u5e95\u5c31\u662f\u4e00\u500b\u500btable\uff0c\u5beb\u8457\u4e00\u884c\u884c\u7684\u8cc7\u6599\uff0c\u6bcf\u7b46\u8cc7\u6599\u6709\u5f88\u591afield\u8f09\u8457data\uff0c\u800c\u6bcf\u500btable\u4e4b\u9593\u7528key\u53bb\u4e92\u76f8\u9023\u7cfb\u3002\u5728\u770b\u9019\u672c\u66f8\u524d\uff0c\u6211\u9023\u4ec0\u9ebc\u662fnormal form\u4e5f\u4e0d\u77e5\u9053\uff0c\u4e0d\u904e\u770b\u5b8c\u66f8\uff0c\u5176\u5be6\u6211\u9084\u662f\u4e00\u77e5\u534a\u89e3\uff0c\u56e0\u70banormal form\u5be6\u5728\u592a\u6df1\u4e86\u3002\u4f5c\u8005\u6559\u7528\u53e6\u4e00\u500b\u8a2d\u8a08\u65b9\u6cd5\uff0c\u4e00\u6b65\u6b65\u628a\u8cc7\u6599\u7684fields\u7d44\u5408\u70ba\u4e0d\u540c\u7684tables\u3002\u7531\u7d30\u5230\u5927\u4e00\u5c64\u5c64\u5efa\u7bc9\u4e0a\u53bb\uff0c\u6bd4\u8d77\u5f9e\u4e00\u500b\u5927table\u958b\u59cb\uff0c\u7136\u5f8c\u7528normal form\u53bb\u5206\u62c6\u6210\u4e0d\u540c\u7684tables\uff0c\u96d6\u7136\u5de5\u5e8f\u66f4\u591a\u6b65\u9a5f\u66f4\u8cbb\u795e\uff0c\u4f46\u521d\u5b78\u8005\u6bd4\u8f03\u5bb9\u6613\u660e\u767d\u3002<\/p>\n\n\n\n<p>Database\u8a2d\u8a08\u6700\u91cd\u8981\u662f\u8cc7\u6599\u7684\u53ef\u9760\u6027\uff0c\u300c\u552f\u4e00\u300d\u5c31\u662f\u8a2d\u8a08\u7684\u95dc\u9375\uff0c\u6bcf\u4e00\u9805\u8cc7\u6599\u53ea\u5b58\u5728\u4e00\u500b\u5730\u65b9\uff0c\u6bcf\u4e00\u500b\u5730\u65b9\u53ea\u5132\u5b58\u4e00\u9805\u8cc7\u6599\u3002\u53ef\u4ee5\u8a08\u7b97\u51fa\u4f86\u7684\u8cc7\u6599\uff0c\u5c31\u4e0d\u8981\u6d6a\u8cbb\u5730\u65b9\u53bb\u5b58\u653e\uff0c\u6709\u9700\u8981\u52a0\u901f\u5c31\u5efa\u7acbview\u4f86\u66ab\u5b58\u3002\u807d\u8d77\u4f86\u597d\u50cf\u5f88\u5bb9\u6613\uff0c\u5be6\u969b\u8a2d\u8a08database\u6642\uff0c\u8981\u5f88\u6709\u8010\u5fc3\u53bb\u9010\u9805\u9010\u9805\u6821\u5c0d\uff0c\u624d\u4e0d\u6703\u4e0d\u5c0f\u5fc3\u7522\u751f\u8a2d\u8a08\u4e0a\u7684\u7f3a\u9677\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9019\u4e0d\u662f\u4e00\u672c\u6559\u5982\u4f55\u4f7f\u7528SQL\u7684\u66f8\uff0c\u53cd\u800c\u82b1\u4e86\u5f88\u9577\u7bc7\u5e45\u8aaa\u5982\u4f55\u8a2a\u554fdatabase\u7684\u7528\u5bb6\u3002<\/p>\n","protected":false},"author":2,"featured_media":15587,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"lc_iscn_info":[],"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[8,44],"tags":[1198],"class_list":["post-15586","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-_books","category-_hardware_software","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Database Design for Mere Mortals - Michael J. Hernandez - \u54f2\u5b50\u6232 Philosophist\u2019s Camp<\/title>\n<meta name=\"description\" content=\"\u9019\u4e0d\u662f\u4e00\u672c\u6559\u5982\u4f55\u4f7f\u7528SQL\u7684\u66f8\uff0c\u53cd\u800c\u82b1\u4e86\u5f88\u9577\u7bc7\u5e45\u8aaa\u5982\u4f55\u8a2a\u554fdatabase\u7684\u7528\u5bb6\u3002\" \/>\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.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Design for Mere Mortals - Michael J. Hernandez - \u54f2\u5b50\u6232 Philosophist\u2019s Camp\" \/>\n<meta property=\"og:description\" content=\"\u9019\u4e0d\u662f\u4e00\u672c\u6559\u5982\u4f55\u4f7f\u7528SQL\u7684\u66f8\uff0c\u53cd\u800c\u82b1\u4e86\u5f88\u9577\u7bc7\u5e45\u8aaa\u5982\u4f55\u8a2a\u554fdatabase\u7684\u7528\u5bb6\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/\" \/>\n<meta property=\"og:site_name\" content=\"\u54f2\u5b50\u6232 Philosophist\u2019s Camp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/horace.org\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/horace.org\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-18T08:13:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-18T08:13:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"405\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"hevangel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@horaceorg\" \/>\n<meta name=\"twitter:site\" content=\"@horaceorg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hevangel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/\"},\"author\":{\"name\":\"hevangel\",\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/#\\\/schema\\\/person\\\/c8d9e8e7a71d343b4b2c4ef4365cdb4c\"},\"headline\":\"Database Design for Mere Mortals &#8211; Michael J. Hernandez\",\"datePublished\":\"2023-08-18T08:13:08+00:00\",\"dateModified\":\"2023-08-18T08:13:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/\"},\"wordCount\":39,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/#\\\/schema\\\/person\\\/c8d9e8e7a71d343b4b2c4ef4365cdb4c\"},\"image\":{\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.horace.org\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&ssl=1\",\"keywords\":[\"SQL\"],\"articleSection\":[\"\u66f8\u8a55\",\"\u96fb\u8166\"],\"inLanguage\":\"en-CA\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/\",\"url\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/\",\"name\":\"Database Design for Mere Mortals - Michael J. Hernandez - \u54f2\u5b50\u6232 Philosophist\u2019s Camp\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.horace.org\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&ssl=1\",\"datePublished\":\"2023-08-18T08:13:08+00:00\",\"dateModified\":\"2023-08-18T08:13:16+00:00\",\"description\":\"\u9019\u4e0d\u662f\u4e00\u672c\u6559\u5982\u4f55\u4f7f\u7528SQL\u7684\u66f8\uff0c\u53cd\u800c\u82b1\u4e86\u5f88\u9577\u7bc7\u5e45\u8aaa\u5982\u4f55\u8a2a\u554fdatabase\u7684\u7528\u5bb6\u3002\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/#breadcrumb\"},\"inLanguage\":\"en-CA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.horace.org\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.horace.org\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&ssl=1\",\"width\":405,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/2023\\\/08\\\/18\\\/database-design-for-mere-mortals-michael-j-hernandez\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Design for Mere Mortals &#8211; Michael J. Hernandez\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/\",\"name\":\"\u54f2\u5b50\u6232 Philosophist\u2019s Camp\",\"description\":\"\u860b\u679c\u65e5\u5831\u4f5c\u8005 - \u9673\u99ac\uff1a\u66f8\u8a55\uff0c\u5f71\u8a55\uff0c\u52d5\u6f2b\uff0c\u65c5\u884c\uff0c\u54f2\u5b78\u7b46\u8a18\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/#\\\/schema\\\/person\\\/c8d9e8e7a71d343b4b2c4ef4365cdb4c\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-CA\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/#\\\/schema\\\/person\\\/c8d9e8e7a71d343b4b2c4ef4365cdb4c\",\"name\":\"hevangel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-CA\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.horace.org\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/spocky.jpg?fit=1313%2C1259&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.horace.org\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/spocky.jpg?fit=1313%2C1259&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.horace.org\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/spocky.jpg?fit=1313%2C1259&ssl=1\",\"width\":1313,\"height\":1259,\"caption\":\"hevangel\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.horace.org\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/spocky.jpg?fit=1313%2C1259&ssl=1\"},\"sameAs\":[\"http:\\\/\\\/www.horace.org\",\"https:\\\/\\\/www.facebook.com\\\/horace.org\"],\"url\":\"https:\\\/\\\/www.horace.org\\\/blog\\\/author\\\/hevangel-2\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Design for Mere Mortals - Michael J. Hernandez - \u54f2\u5b50\u6232 Philosophist\u2019s Camp","description":"\u9019\u4e0d\u662f\u4e00\u672c\u6559\u5982\u4f55\u4f7f\u7528SQL\u7684\u66f8\uff0c\u53cd\u800c\u82b1\u4e86\u5f88\u9577\u7bc7\u5e45\u8aaa\u5982\u4f55\u8a2a\u554fdatabase\u7684\u7528\u5bb6\u3002","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.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/","og_locale":"en_US","og_type":"article","og_title":"Database Design for Mere Mortals - Michael J. Hernandez - \u54f2\u5b50\u6232 Philosophist\u2019s Camp","og_description":"\u9019\u4e0d\u662f\u4e00\u672c\u6559\u5982\u4f55\u4f7f\u7528SQL\u7684\u66f8\uff0c\u53cd\u800c\u82b1\u4e86\u5f88\u9577\u7bc7\u5e45\u8aaa\u5982\u4f55\u8a2a\u554fdatabase\u7684\u7528\u5bb6\u3002","og_url":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/","og_site_name":"\u54f2\u5b50\u6232 Philosophist\u2019s Camp","article_publisher":"https:\/\/www.facebook.com\/horace.org","article_author":"https:\/\/www.facebook.com\/horace.org","article_published_time":"2023-08-18T08:13:08+00:00","article_modified_time":"2023-08-18T08:13:16+00:00","og_image":[{"width":405,"height":500,"url":"https:\/\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg","type":"image\/jpeg"}],"author":"hevangel","twitter_card":"summary_large_image","twitter_creator":"@horaceorg","twitter_site":"@horaceorg","twitter_misc":{"Written by":"hevangel","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/#article","isPartOf":{"@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/"},"author":{"name":"hevangel","@id":"https:\/\/www.horace.org\/blog\/#\/schema\/person\/c8d9e8e7a71d343b4b2c4ef4365cdb4c"},"headline":"Database Design for Mere Mortals &#8211; Michael J. Hernandez","datePublished":"2023-08-18T08:13:08+00:00","dateModified":"2023-08-18T08:13:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/"},"wordCount":39,"commentCount":0,"publisher":{"@id":"https:\/\/www.horace.org\/blog\/#\/schema\/person\/c8d9e8e7a71d343b4b2c4ef4365cdb4c"},"image":{"@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&ssl=1","keywords":["SQL"],"articleSection":["\u66f8\u8a55","\u96fb\u8166"],"inLanguage":"en-CA","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/","url":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/","name":"Database Design for Mere Mortals - Michael J. Hernandez - \u54f2\u5b50\u6232 Philosophist\u2019s Camp","isPartOf":{"@id":"https:\/\/www.horace.org\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/#primaryimage"},"image":{"@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&ssl=1","datePublished":"2023-08-18T08:13:08+00:00","dateModified":"2023-08-18T08:13:16+00:00","description":"\u9019\u4e0d\u662f\u4e00\u672c\u6559\u5982\u4f55\u4f7f\u7528SQL\u7684\u66f8\uff0c\u53cd\u800c\u82b1\u4e86\u5f88\u9577\u7bc7\u5e45\u8aaa\u5982\u4f55\u8a2a\u554fdatabase\u7684\u7528\u5bb6\u3002","breadcrumb":{"@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/#breadcrumb"},"inLanguage":"en-CA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/"]}]},{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/#primaryimage","url":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&ssl=1","width":405,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/www.horace.org\/blog\/2023\/08\/18\/database-design-for-mere-mortals-michael-j-hernandez\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.horace.org\/blog\/"},{"@type":"ListItem","position":2,"name":"Database Design for Mere Mortals &#8211; Michael J. Hernandez"}]},{"@type":"WebSite","@id":"https:\/\/www.horace.org\/blog\/#website","url":"https:\/\/www.horace.org\/blog\/","name":"\u54f2\u5b50\u6232 Philosophist\u2019s Camp","description":"\u860b\u679c\u65e5\u5831\u4f5c\u8005 - \u9673\u99ac\uff1a\u66f8\u8a55\uff0c\u5f71\u8a55\uff0c\u52d5\u6f2b\uff0c\u65c5\u884c\uff0c\u54f2\u5b78\u7b46\u8a18","publisher":{"@id":"https:\/\/www.horace.org\/blog\/#\/schema\/person\/c8d9e8e7a71d343b4b2c4ef4365cdb4c"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.horace.org\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-CA"},{"@type":["Person","Organization"],"@id":"https:\/\/www.horace.org\/blog\/#\/schema\/person\/c8d9e8e7a71d343b4b2c4ef4365cdb4c","name":"hevangel","image":{"@type":"ImageObject","inLanguage":"en-CA","@id":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2021\/11\/spocky.jpg?fit=1313%2C1259&ssl=1","url":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2021\/11\/spocky.jpg?fit=1313%2C1259&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2021\/11\/spocky.jpg?fit=1313%2C1259&ssl=1","width":1313,"height":1259,"caption":"hevangel"},"logo":{"@id":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2021\/11\/spocky.jpg?fit=1313%2C1259&ssl=1"},"sameAs":["http:\/\/www.horace.org","https:\/\/www.facebook.com\/horace.org"],"url":"https:\/\/www.horace.org\/blog\/author\/hevangel-2\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2023\/08\/51rnXAEryqL._SX403_BO1204203200_.jpg?fit=405%2C500&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pwn21-43o","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":11720,"url":"https:\/\/www.horace.org\/blog\/2016\/09\/10\/sql-clearly-explained-3rd-edition-jan-l-harrington\/","url_meta":{"origin":15586,"position":0},"title":"SQL Clearly Explained 3rd Edition &#8211; Jan L. Harrington","author":"hevangel","date":"September 10, 2016","format":false,"excerpt":"\u5b78\u7fd2\u67b6\u8a2d\u7db2\u7ad9\uff0c\u8981\u4e00\u6b65\u6b65\u6162\u5b78\uff0c\u4e0d\u8981\u5984\u60f3\u4e00\u6b65\u767b\u5929\u3002\u539f\u672c\u5b78\u5b8cRuby\u5f8c\uff0c\u6253\u7b97\u76f4\u63a5\u5b78\u5bebRAILS\uff0c\u7136\u5f8c\u767c\u73fe\u81ea\u5df2\u4e0d\u61c2SQL\u3002\u6c92\u6709SQL\u7684\u57fa\u672c\u529f\u592b\uff0c\u4e0d\u80fd\u6709\u6548\u5730\u67b6\u8a2d\u7db2\u7ad9\uff0c\u4efb\u4f55\u7db2\u7ad9\u90fd\u8981\u7528database\u4f86\u5132\u5b58\u8cc7\u6599\u554a\u3002\u8aaa\u8d77database\u7a0b\u5f0f\uff0c\u5f88\u591a\u5e74\u524d\u6211\u5b78\u904edBase III\uff0c\u5728\u4e2d\u5b78\u96fb\u8166\u79d1\u88ab\u8feb\u5b78\u4e86\u4e00\u500b\u5b78\u671f\u3002\u7576\u5e74\u89ba\u5f97\u5b78\u4e00\u500b\u904e\u6642\u7684\u8edf\u4ef6\u5f88\u6d6a\u8cbb\u6642\u9593\uff0c\u60f3\u4e0d\u5230database\u7a0b\u5f0f\u8a2d\u8a08\u7684\u6700\u57fa\u672c\u6168\u5ff5\uff0c\u5eff\u5e7e\u5e74\u5f8c\u6703\u5f9e\u5c01\u5875\u7684\u8a18\u61b6\u4e2d\u627e\u51fa\u4f86\u6709\u7528\u3002 \u6211\u6311\u9078\u4e86\u597d\u5e7e\u672c\u5b78\u7fd2SQL\u7684\u66f8\uff0c\u601d\u524d\u60f3\u5f8c\u5230\u5e95\u7528\u90a3\u4e00\u672c\u597d\uff0c\u6700\u5f8c\u6c7a\u5b9a\u7528\u9019\u672cSQL Clearly Explained\u70ba\u4e3b\u5e79\uff0c\u518d\u7528\u5169\u672cO'Reilly\u7684\u66f8\u70ba\u8f14\u52a9\u53c3\u8003\u3002\u5f88\u591aSQL\u7684\u66f8\u53ea\u6703\u6559\u67d0\u4e00\u500bSQL server\u7684\u61c9\u7528\uff0c\u5f88\u5bb9\u6613\u898b\u6a39\u4e0d\u898b\u6797\uff0c\u5206\u4e0d\u6e05\u5230\u5e95\u90a3\u4e9b\u662fSQL\u8a9e\u8a00\u672c\u8eab\uff0c\u90a3\u4e9b\u662f\u67d0\u4e00\u500bserver\u7684syntax\u3002\u9019\u672c\u66f8\u5f9eSQL\u6a19\u6e96\u5165\u624b\uff0c\u7b2c\u4e00\u7ae0\u4e0d\u662f\u6559\u4f60\u5b89\u88dd\u8edf\u4ef6\uff0c\u800c\u662f\u5f88\u6709\u7cfb\u7d71\u5730\u8b1b\u89e3relational database\u7684\u7406\u8ad6\u3002\u53ea\u8981\u57fa\u672c\u77e5\u8b58\u6e05\u695a\u660e\u767d\uff0c\u5b78syntax\u5f88\u7c21\u55ae\uff0c\u53ef\u4ee5\u908a\u7528\u908a\u5b78\uff0c\u67e5document\u6478\u6478\u4e0b\u5c31\u4e0a\u624b\u3002\u90a3\u5169\u672cO'Reilly\u7684\u66f8\uff0c\u4e00\u672c\u6559SQLite\uff0c\u53e6\u4e00\u672c\u6559MySQL\uff0c\u5169\u5927\u5e38\u7528\u7684database\u3002\u90a3\u5169\u672c\u66f8\u4e0d\u662f\u597d\u7684\u5165\u9580\u66f8\uff0c\u5167\u5bb9\u592a\u8457\u91cd\u8b1bsyntax\uff0c\u4e0d\u904e\u537b\u662f\u5341\u5206\u6709\u7528\u7684reference\u66f8\u3002 Relational database\u7684\u7406\u8ad6\uff0c\u8aaa\u96e3\u4e0d\u96e3\uff0c\u8aaa\u6613\u4e0d\u6613\uff0c\u9818\u609f\u5230\u5c31\u4e00\u7406\u901a\u767e\u7406\u660e\u3002Database\u662f\u4ec0\u9ebc\uff0c\u4e0d\u5916\u4e4e\u4e00\u5806table\u3002Table\u5c31\u597d\u4f3cExcel\u7684spreadsheet\u5481\uff0c\u6253\u6a6b\u6253\u76f4\u4e00\u884c\u884c\uff0c\u6bcf\u683c\u5c31\u662f\u4e00\u9805\u8cc7\u6599\u3002\u6bcf\u4e00\u884c\u6709\u4e00\u683c\u4fc2primary key\uff0c\u7528\u4f86look up\u90a3\u4e00\u884c\u3002\u4e00\u884c\u4e4b\u53c8\u53ef\u4ee5\u6709foriegn key\uff0c\u9023\u7d50\u53e6\u5916\u4e00\u500btable\u7684primary key\uff0c\u8868\u660etable\u8207table\u4e4b\u9593\u884c\u8207\u884c\u7684\u95dc\u4fc2\uff0c\u8b02\u4e4brelation\u662f\u4e5f\u3002\u6aa2\u67e5\u641c\u5c0bdatabase\u53ea\u67096\u500b\u57fa\u672c\u64cd\u4f5c\uff0c\u6240\u6709\u90fd\u53ea\u662f\u842c\u8b8a\u4e0d\u96e2\u5176\u4e2d\u30026\u500b\u64cd\u4f5c\u5305\u62ec\uff0cfilter\u884c(WHERE)\u6216filter\u5217(SELECT)\uff0c\u628a\u5169\u7d44\u884c\u7684\u884c\u52a0\u8d77\u4f86(UNION)\uff0c\u627e\u51fa\u76f8\u540c\u7684\u884c(INTERSECT)\uff0c\u627e\u51fa\u4e0d\u540c\u7684\u884c(EXCEPT)\uff0c\u800c\u6700\u91cd\u8981\u7684\u64cd\u4f5c\u662fJOIN\uff0c\u5373\u4fc2\u9023\u7d50\u8d77primary key\u540cforeign key\u65e2relation\u3002 \u6b64\u66f8\u7684\u7b2c\u4e8c\u90e8\u4efd\u6559SQL Syntax\uff0c\u5be6\u7fd2\u7b2c\u4e00\u90e8\u4efd\u7684SQL\u7406\u8ad6\u3002\u9019\u672c\u66f8\u7684\u53e6\u4e00\u500b\u512a\u9ede\uff0c\u662f\u66f8\u4e2d\u9644\u5e36\u73fe\u6210\u7684database\uff0c\u4e00\u9593\u4e8c\u624b\u66f8\u5e97\u7684\u5b58\u8ca8\u8cb7\u8ce3\u8cc7\u6599\uff0c\u4e0d\u4f3c\u5176\u4ed6\u66f8\u53ea\u8b1b\u7a7a\u8ac7syntax\u3002\u6211\u628a\u66f8\u4e2d\u7684\u4f8b\u5b50\u8f38\u5165\u4e86SQLite\u6a94\u6848\uff0c\u4e26\u9644\u4e0a\u5404table\u7684csv\u6a94\u6848\uff0c\u6709\u8208\u8da3\u7684\u670b\u53cb\u53ef\u4ee5\u5728\u6b64\u4e0b\u8f09SQL\u3000Clearly Explained Sample Database\u3002\u5b78\u7fd2SQL\u7684\u6b21\u5e8f\uff0c\u6700\u5148\u5b78\u641c\u67e5\uff0c\u5982\u4f55\u5728database\u4e2d\u627e\u51fa\u4f60\u60f3\u8981\u7684\u8cc7\u6599\uff0c\u5176\u6b21\u5b78\u5982\u4f55\u66f4\u65b0\u8cc7\u6599\uff0c\u6700\u5f8c\u624d\u5b78\u5982\u4f55\u5efa\u7acb\u8a2d\u8a08database\u7684table\u3002\u6240\u4ee5\u6709\u4e00\u500b\u73fe\u6210\u7684database\uff0c\u518d\u8ddf\u8457\u66f8\u4e2d\u7684\u4e0d\u540c\u61c9\u7528\u4f8b\u5b50\uff0c\u5b78\u641c\u67e5\u5f88\u65b9\u4fbf\uff0c\u4e8b\u534a\u529f\u90e8\u3002\u66f4\u65b0\u8cc7\u6599\u7684syntax\u5f88\u7c21\u55ae\uff0c\u6709\u5f88\u8f14\u52a9function\u8b93\u4f60\u53ef\u4ee5\u5beb\u5c11\u5e7e\u884ccode\uff0c\u6700\u91cd\u8981\u7684\u6168\u5ff5\u662fACID transaction\uff0c\u8aaa\u7a7f\u4e86\u5c31\u662fmulti-threads\u7684synchronization problem\uff0c\u53ea\u662f\u6539\u4e86\u500b\u597d\u807d\u7684acronym\u3002\u8a2d\u8a08table\u90a3\u4e00\u7ae0\u6559CREATE\u7684syntax\uff0c\u4e0d\u904e\u6211\u60f3\u6c92\u6709\u4eba\u6703\u7528SQL\u53bb\u76f4\u63a5\u8d77table\uff0c\u4e0d\u662f\u6709\u5176\u4ed6GUI\u5de5\u5177\u66f4\u597d\u7528\u55ce\u3002\u8d77\u4e00\u500b\u6709\u6548\u7387\u7684table\u662f\u9580\u5f88\u9ad8\u6df1\u7684\u5b78\u554f\uff0c\u5165\u9580\u66f8\u6559syntax\u53ea\u662f\u6559\u4e86table design\u7684\u76ae\u6bdb\u3002 \u9918\u4e0b\u7684\u7b2c\u4e09\u90e8\u4efd\u548c\u7b2c\u56db\u90e8\u4efd\uff0c\u6211\u53ea\u662f\u5feb\u901f\u7565\u8b80\u3002SQL\u672c\u8eab\u662f\u4e00\u500bturing-complete\u7684\u7a0b\u5f0f\u8a9e\u8a00\uff0c\u7b2c\u4e09\u90e8\u4efd\u6559SQL\u5beb\u4e00\u822c\u7a0b\u5f0f\u7684syntax\uff0c\u53ea\u662f\u6211\u4e0d\u660e\u767d\u6709\u4ec0\u9ebc\u4eba\u6703\u7528\uff0cSQL\u7684PROCEDURE\u548cTRIGGER\u53ea\u662fsearch filter\u7684\u8f14\u52a9\u5de5\u5177\uff0c\u771f\u6b63\u8981\u505aheavy lifting\u8cc7\u6599\u904b\u7b97\uff0c\u70ba\u4ec0\u9ebc\u4e0d\u628a\u8cc7\u6599\u8b80\u51fa\u4f86\u5f8c\uff0c\u7528host\u529f\u80fd\u66f4\u5f37\u5927\u7684programming langauge\u53bbprocess\u3002\u7b2c\u56db\u90e8\u4efd\u6559SQL\u4e2dXML\u7684\u529f\u80fd\u548cObject Relational Data Model\uff0c\u4e0d\u904e\u9664\u4e86Oracle\u6216Microsft\u90a3\u4e9b\u5546\u7528\u7d1a\u7684server\uff0cSQLite\u548cMySQL\u90fd\u4e0d\u652f\u63f4\u9019\u4e9b\u529f\u80fd\uff0c\u4e0d\u904e\u8981\u641c\u67e5\u66f4\u65b0XML\uff0c\u7528DOM\u4e0d\u662f\u66f4\u65b9\u4fbf\u55ce\uff1f\u6211\u60f3\u4e0d\u5230\u6709\u4ec0\u9ebc\u7406\u7531\uff0c\u8981\u628aXML\u76f4\u63a5\u7576\u6578\u64da\u5132\u5b58\u5728database\u4e2d\uff0c\u70ba\u4ec0\u9ebc\u4e0d\u5148\u89e3\u8b80\u4e86XML\u4e2d\u7684\u8cc7\u6599\uff0c\u518d\u6709\u7cfb\u7d71\u5730\u5132\u653e\u5165table\u4e2d\u5462\uff1fOpen Source\u7684server\u4e2d\uff0c\u53ea\u6709PostgreSQL\u652f\u63f4Object Relational Data Model\uff0c\u7c21\u55ae\u4f86\u8aaa\u5c31\u662f\u628aOOP\u4e2d\u7684object\u5132\u5b58\u5728database\u4e2d\uff0c\u61c2OOP\u7684\u4eba\u5b78Object Model\u5f88\u7c21\u55ae\u3002Object Relation\u5c31\u5728table\u7684\u4e00\u683c\u5167\uff0c\u53ef\u4ee5\u5132\u5b58\u4e00\u500bobject\uff0c\u6216array\uff0cset\u7b49\u7b49\uff0c\u539f\u672ctable\u7684\u4e00\u683c\u53ea\u53ef\u4ee5\u5132\u5b58\u4e00\u500b\u6578\u503c\u3002\u53e6\u5916\u4e00\u884c\u53ef\u4ee5\u7528pointer\u76f4\u63a5link\u53bb\u53e6\u4e00\u884c\u5ea6\uff0c\u6bd4\u7528foreign key\u66f4\u6709\u6548\u7387\uff0c\u56e0\u70ba\u4e0d\u7528\u505asearch\u3002 \u5b78\u5b8cSQL\uff0c\u5ffd\u7136\u5f15\u8d77\u6211\u5c0ddatabase\u7684\u8208\u8da3\uff0c\u66ab\u6642\u653e\u4e0bRAILS\uff0c(\u53cd\u6b63\u8981\u7b49RAILS-5\u7684\u65b0\u66f8\u51fa\u7248\uff0c\u6c92\u6709\u7406\u7531\u8d70\u53bb\u5b78RAILS-4\uff09\uff0c\u6c7a\u5b9a\u5148\u5b78\u5176\u4ed6No-SQL database\uff0c\u770b\u770b\u9084\u6709\u4ec0\u9ebc\u5176\u4ed6\u5132\u5b58\u8cc7\u6599\u7684\u5176\u4ed6\u65b9\u6cd5\uff0c\u624d\u6c7a\u5b9a\u7db2\u7ad9\u8a72\u63a1\u7528\u90a3\u7a2edatabase\u6700\u597d\u3002","rel":"","context":"In &quot;\u66f8\u8a55&quot;","block_context":{"text":"\u66f8\u8a55","link":"https:\/\/www.horace.org\/blog\/category\/_books\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2016\/09\/sqlclearlyexplained.jpg?fit=677%2C821&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2016\/09\/sqlclearlyexplained.jpg?fit=677%2C821&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2016\/09\/sqlclearlyexplained.jpg?fit=677%2C821&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":14748,"url":"https:\/\/www.horace.org\/blog\/2021\/04\/25\/seven-databases-in-seven-weeks-2nd-edition-luc-perkins\/","url_meta":{"origin":15586,"position":1},"title":"Seven Databases in Seven Weeks 2nd Edition &#8211; Luc Perkins","author":"hevangel","date":"April 25, 2021","format":false,"excerpt":"\u5f88\u591a\u5e74\u4f86\u6211\u4e00\u76f4\u53ea\u61c2SQL\uff0c\u6c92\u6709\u5b78\u7fd2\u5176\u4ed6database\uff0c\u65e9\u5341\u5e74NoSQL\u9084\u662f\u525b\u5192\u8d77\uff0c\u6211\u9084\u6709\u9ede\u770b\u8f15\u5b83\uff0c\u89ba\u5f97\u5b83\u5187\u7528\u3002\u4fd7\u8a9e\u6709\u4e91\uff0c\u7576\u4f60\u624b\u62ff\u8457\u939a\u5b50\uff0c\u6240\u6709\u7684\u554f\u984c\u90fd\u8b8a\u6210\u91d8\u5b50\u3002\u53ea\u61c2SQL\uff0c\u5f88\u81ea\u7136\u7fd2\u6163\u628a\u6240\u6709\u554f\u984c\u90fd\u7528Relational Database\u53bb\u89e3\u6c7a\uff0c\u5118\u7ba1\u8981\u82b1\u66f4\u52a0\u591a\u7684\u6c23\u529b\uff0c\u6709\u6642\u6bba\u96de\u4ea6\u8981\u7528\u725b\u5200\uff0c\u56e0\u70ba\u53ea\u5f97\u4e00\u628a\u5200\u3002 \u9019\u672c\u66f82018\u5e74\u51fa\u7248\uff0c\u5df2\u7d93\u662f\u7b2c\u4e8c\u7248\uff0c\u5f88\u591a\u5e74\u524d\u7b2c\u4e00\u7248\u6642\u5df2\u7d93\u60f3\u770b\u3002\u53ea\u4e0d\u904e\u662f\u77ed\u77ed\u4e09\u5e74\uff0c\u66f8\u4e2d\u6709\u4e9bcode\u5df2\u7d93\u904e\u6642\u4e86\uff0c\u65b0\u7248\u672cdatabase\u7684syntax\u6709\u9ede\u4e0d\u4e00\u6a23\uff0c\u4e0d\u904e\u57fa\u790e\u7406\u8ad6\u6c92\u6709\u6539\u8b8a\uff0c\u4ecd\u7136\u5408\u7528\u3002NoSQL\u6709\u592a\u591a\u9078\u64c7\uff0c\u60f3\u5b78\u7fd2\u4e5f\u8001\u9f20\u62c9\u9f9c\u7121\u5f9e\u5165\u624b\u3002\u9019\u672c\u66f8\u4ecb\u7d39\u6700\u71b1\u9580\u7684\u4e03\u500bdatabase\uff0c\u5f9e\u50b3\u7d71SQL\u7684Postgres\u70ba\u8d77\u9ede\u958b\u59cb\uff0c\u7136\u5f8c\u9010\u4e00\u8b1b\u89e3\u5176\u4ed6NoSQL DB\u7684\u512a\u52a3trade-off\uff0c\u4ec0\u9ebc\u60c5\u6cc1\u9069\u5408\u61c9\u7528\u3002\u6bd4\u8d77\u6bcf\u6b21\u53ea\u6559\u4e00\u7a2edatabase\u7684\u66f8\uff0c\u8b93\u8b80\u8005\u6709\u5b8f\u89c0\u7684\u8996\u91ce\u3002 \u56e0\u70ba\u4e00\u672c\u66f8\u8981\u6559\u4e03\u500bDB\u7684\u95dc\u4fc2\uff0c\u9019\u672c\u66f8\u7684\u5167\u5bb9\u975e\u5e38\u58d3\u7e2e\uff0c\u7c21\u55ae\u7684\u57fa\u672c\u64cd\u4f5c\u751a\u81f3\u7565\u904e\u4e0d\u8ac7\uff0c\u76f4\u63a5\u53eb\u8b80\u8005\u53bb\u770b\u5b98\u65b9document\u3002\u6bcf\u500bDB\u7684\u6559\u7a0b\u5206\u70ba\u4e09\u90e8\u4efd\uff0c\u8b93\u8b80\u8005\u53ef\u4ee5\u9023\u7e8c\u4e03\u500b\u661f\u671f\uff0c\u6bcf\u500b\u9031\u7528\u4e09\u65e5\u5b78\u5b8c\u3002\u6211\u4e00\u53e3\u6c23\u4e00\u6b21\u904e\u770b\u5b8c\uff0c\u4e00\u7ae0\u5927\u7d04\u8981\u7528\u56db\u500b\u5c0f\u6642\uff0c\u4e0d\u904e\u6211\u53ea\u662f\u8ddf\u8457example\u6253code\u73a9\u4e0b\u500bDB\uff0c\u6c92\u6709\u500b\u6bcf\u65e5\u7684\u529f\u8ab2\uff0c\u82e5\u679c\u505a\u57cb\u529f\u8ab2\uff0c\u5927\u7d04\u8981\u5169\u500d\u6642\u9593\u3002 \u7b2c\u4e00\u7ae0Postgres\u662f\u6eab\u7fd2SQL\uff0c\u6211\u4ee5\u524d\u7528\u958bMySQL\u540cSQLite\uff0c\u4e5f\u7b97\u662f\u5b78\u65b0\u91ce\u3002\u7b2c\u4e8c\u7ae0\u6559HBase\u662fcolumnar database\uff0c\u6c92\u6709\u96a8\u610fsearch\u7684\u529f\u80fd\uff0c\u8981\u9760index\u53bb\u8b80data\uff0c\u4f46\u662f\u975e\u5e38scalable\uff0c\u662fGoogle Cloud Bigtable\u7684\u958b\u6e90\u7248\u3002\u7b2c\u4e09\u7ae0\u6559MongoDB\u662fdocument DB\uff0csearch JSON\u7684\u529f\u80fd\u5f88\u5f37\u5927\uff0c\u4e0d\u7528\u5bebschema\u5f88\u65b9\u4fbf\u3002\u7b2c\u4e94\u7ae0\u6559couchdb\uff0c\u8207MongoDB\u4e00\u6a23\u90fd\u662f\u5bebJSON object\uff0c\u4f46couchdb\u7684read\u8981\u4e8b\u5148\u5efa\u7acbviews\uff0c\u53e6\u5916\u76e3\u8996change\u7684\u529f\u80fd\u4e5f\u5f88\u597d\u7528\u3002 \u7b2c\u516d\u7ae0\u6559\u662f\u6211\u6700\u6709\u8208\u8da3\u7684Neo4J\uff0c\u4f46\u66f8\u4e2d\u6559\u4e86graph DB\u7684\u5f88\u76ae\u6bdb\uff0c\u9023Cypher\u8a9e\u6cd5\u5982\u4f55\u95b1\u8b80\u4e5f\u6c92\u6709\u6559\uff0c\u6211\u8981\u4e0a\u7db2\u518d\u627e\u8cc7\u6599\u81ea\u5b78\u3002Graph DB\u540cSQL\u5f88\u5927\u5206\u5225\uff0c\u5b8c\u5168\u662f\u53e6\u4e00\u500b\u985e\u578b\u7684\u61c9\u7528\uff0c\u5b78\u4e86\u5927\u958b\u773c\u754c\u3002\u7b2c\u4e03\u7ae0\u6559AWS DynamoDB\uff0c\u500bdatabase\u672c\u8eab\u5f88\u5e73\u5e73\u7121\u5947\uff0c\u5f37\u5927\u662fAWS\u5f8c\u53f0\u7684\u652f\u63f4\uff0c\u9023\u8457AWS\u5176\u4ed6\u529f\u5177\u4e00\u8d77\u6559\uff0c\u5b78\u7fd2\u5bebdata pipeline\uff0c\u63d0\u5347\u7528DB\u7684\u53e6\u4e00\u500b\u5c64\u6b21\uff0c\u771f\u6b63\u7684big data\u3002\u6700\u5f8c\u4e00\u7ae0\u6559redis\uff0c\u7c21\u55ae\u6613\u7528\u5920\u65b9\u4fbf\uff0c\u6211\u8a8d\u70baredis\u61c9\u8a72\u65e9\u4e9b\u6559\uff0cin memory key-value store\u90fd\u5571\u505a\u4e00\u4e9bquick and dirty job\u3002 \u9019\u662f\u4e00\u672c\u4e0d\u9069\u5408\u65b0\u624b\u7684\u5165\u9580\u66f8\uff0c\u6559\u7684\u6771\u897f\u5f88\u5ee3\u95ca\u4f46\u5f88\u819a\u6dfa\uff0c\u4e3b\u8981\u662f\u7d66\u8b80\u8005\u4e00\u500bperspective\uff0c\u4e4b\u5f8c\u8b80\u8005\u5c31\u8981\u9760\u81ea\u5df1\u53bb\u770bdocument\u4e86\u3002\u82e5\u679c\u8981\u770b\u5b8c\u4e00\u672c\u66f8\u5c31\u80fd\u7acb\u5373\u4e0a\u624b\u63fcproject\uff0c\u62d6\u8457\u4e00\u6b65\u6b65\u6559\u5c0e\u5982\u4f55\u5efa\u7ad9\uff0c\u9019\u672c\u66f8\u4e26\u4e0d\u9069\u5408\u4f60\u3002\u53cd\u800c\u9019\u672c\u66f8\u66f4\u50cf\u662fsampler\uff0c\u6dfa\u5690\u6bcf\u7a2eDB\u7684\u5473\u9053\uff0c\u4e26\u4f8b\u4e00\u8d77\u89c0\u5bdf\u5b83\u5011\u7684\u7570\u540c\uff0c\u7136\u5f8c\u89ba\u5f97\u90a3\u500bDB\u6709\u7528\uff0c\u5c31\u518d\u4e0a\u7db2\u53bb\u627e\u8cc7\u8a0a\u6df1\u9020\u3002\u8b80\u9019\u672c\u66f8\u6709\u4e00\u500b\u597d\u8655\uff0c\u8b80\u5b8c\u5f8c\u57fa\u790e\u7406\u8ad6\u6253\u4e86\u5e95\uff0c\u8b80official document\u5feb\u5f88\u591a\uff0c\u53ef\u4ee5\u76f4\u63a5\u8df3\u904e\u4e0d\u7528\u770b\u5176\u4ed6\u66f8\uff0c\u53cd\u6b63\u53bb\u5230\u6700\u5f8c\u90fd\u4fc2\u8981\u7ffb\u67e5\u53c3\u8003official document\u3002","rel":"","context":"In &quot;\u66f8\u8a55&quot;","block_context":{"text":"\u66f8\u8a55","link":"https:\/\/www.horace.org\/blog\/category\/_books\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2021\/04\/pwrdata-scaled.jpg?fit=1000%2C1200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2021\/04\/pwrdata-scaled.jpg?fit=1000%2C1200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2021\/04\/pwrdata-scaled.jpg?fit=1000%2C1200&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2021\/04\/pwrdata-scaled.jpg?fit=1000%2C1200&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":6311,"url":"https:\/\/www.horace.org\/blog\/2012\/03\/30\/%e8%a9%a9%e8%a9%9e%e6%8c%88%e9%a0%98\/","url_meta":{"origin":15586,"position":2},"title":"\u8a69\u8a5e\u6308\u9818","author":"hevangel","date":"March 30, 2012","format":false,"excerpt":"\u4ee5\u524d\u8b80\u66f8\u6642\u559c\u6b61\u770b\u6b66\u4fe0\u5c0f\u8aaa\uff0c\u770b\u898b\u90a3\u4e9b\u53e4\u4eba\u51fa\u53e3\u6210\u8a69\u597d\u4e0d\u7fa8\u6155\uff0c\u89ba\u5f97\u6587\u7e10\u7e10\u7684\u5341\u5206\u6709\u6587\u5316\u5f88\u5e2b\u3002\u53ef\u60dc\u6211\u4e2d\u6587\u5e95\u5b50\u5dee\uff0c\u4e0d\u8981\u8aaa\u5beb\u8a69\uff0c\u9023\u770b\u8a69\u4e5f\u4e0d\u61c2\u3002\u9023\u8a08\u4ee5\u524d\u5b78\u6821\u8ab2\u672c\u6559\u7684\uff0c\u5927\u6168\u6211\u61c2\u80cc\u5f97\u51fa\u7684\u8a69\uff0c\u5341\u96bb\u624b\u6307\u53ef\u4ee5\u6578\u5b8c\u3002\u4eba\u5bb6\u8aaa\u300c\u8b80\u719f\u5510\u8a69\u4e09\u767e\u9996\uff0c\u4e0d\u6703\u541f\u8a69\u4e5f\u6703\u5077\u300d\uff0c\u597d\u5e7e\u6b21\u62ff\u8d77\u672c\u5510\u8a69\u4e09\u767e\u9996\u4f86\u770b\uff0c\u8b80\u4e0d\u4e86\u5e7e\u9996\u4fbf\u56e0\u70ba\u592a\u60b6\u653e\u68c4\u4e86\u3002\u5e02\u9762\u4e0a\u8f2f\u9304\u53e4\u8a69\u52a0\u4ee5\u6ce8\u91cb\u7684\u66f8\u5f88\u591a\uff0c\u82e5\u679c\u9023\u8a69\u7684\u6700\u57fa\u672c\u4e5f\u4e0d\u61c2\uff0c\u4e0d\u77e5\u8a72\u5982\u4f55\u53bb\u7406\u89e3\u4e00\u53e5\u8a69\u53e5\uff0c\u770b\u90a3\u4e9b\u6ce8\u91cb\u66f8\u6703\u5341\u5206\u5403\u529b\u3002 \u67d0\u6b21\u56de\u9999\u6e2f\u901b\u66f8\u5e97\u6642\uff0c\u770b\u898b\u9019\u672c\u300c\u8a69\u8a5e\u6308\u9818\u300d\uff0c\u7531\u6dfa\u5165\u6df1\u6559\u8b80\u8a69\u5beb\u8a69\uff0c\u4fbf\u8cb7\u7acb\u5373\u4e0b\u4f86\u3002\u4e0d\u904e\u8cb7\u4e86\u56de\u4f86\u5728\u66f8\u67b6\u4e0a\u5c01\u5875\u5f88\u591a\u5e74\uff0c\u76f4\u5230\u6700\u8fd1\u8981\u5e6b\u5c0f\u5bf6\u5bf6\u6539\u4e2d\u6587\u540d\uff0c\u627e\u500b\u6709\u9ede\u6587\u91c7\u597d\u807d\u7684\u540d\u5b57\uff0c\u60f3\u8d77\u9019\u672c\u66f8\u5f9e\u8a69\u4e2d\u627e\u9748\u611f\u3002\u4f5c\u8005\u58eb\u6703\u53ea\u662f\u500b\u7b46\u540d\uff0c\u4e0a\u7db2\u4e5f\u627e\u4e0d\u5230\u4ed6\u7684\u8cc7\u6599\uff0c\u4e0d\u904e\u4ed6\u96a8\u4e86\u5beb\u95dc\u65bc\u8a69\u7684\u66f8\u5916\uff0c\u9084\u6709\u5beb\u6559\u96fb\u8166\u7a0b\u5f0f\u7684\u66f8\uff0c\u60f3\u5fc5\u662f\u611b\u597d\u8b80\u8a69\u7684\u500b\u96fb\u8166\u4eba\u3002\u4ee5\u524d\u4e2d\u570b\u6587\u5b78\u8001\u5e2b\u6559\u8a69\uff0c\u8b1b\u6b23\u8cde\u4ec0\u9ebc\u7f8e\u4ec0\u9ebc\u610f\u5883\uff0c\u5f88\u7121\u804a\u5168\u5b8c\u807d\u4e0d\u660e\u767d\u3002\u9019\u672c\u66f8\u4e0d\u8ac7\u90a3\u4e9b\u4e3b\u89c0\u7684\u611f\u89ba\uff0c\u5f88\u5be6\u5728\u7684\u8b1b\u89e3\u5206\u6790\u5beb\u8a69\u7684\u898f\u5247\u683c\u5f0f\uff0c\u751a\u81f3\u9084\u7528\u96fb\u8166\u6578\u64da\u4f8b\u51fa\u5716\u8868\u5206\u6790\u8a69\u53e5\u7684\u898f\u5f8b\u3002\u96d6\u7136\u8a69\u7684\u898f\u5247\u6709\u5f88\u591a\uff0c\u4e5f\u6709\u4e0d\u5c11\u7279\u6b8a\u7684\u4f8b\u5916\uff0c\u4f46\u6211\u662f\u96fb\u8166\u4eba\u7fd2\u6163\u770b\u8907\u96dc\u7684\u7cfb\u7d71\uff0c\u5225\u4eba\u4e5f\u8a31\u6703\u89ba\u5f97\u9019\u672c\u66f8\u60b6\uff0c\u4f46\u6211\u537b\u5982\u9b5a\u5f97\u6c34\u4e00\u770b\u4fbf\u61c2\u3002\u8b80\u5b8c\u9019\u672c\u66f8\u5f8c\u518d\u770b\u5510\u8a69\u4e09\u767e\u9996\uff0c\u679c\u7136\u4ee5\u524d\u6709\u6ce8\u91cb\u4e5f\u770b\u4e0d\u660e\u767d\u7684\u8a69\uff0c\u73fe\u5728\u4e00\u770b\u4fbf\u61c2\u5982\u4f55\u89e3\u78bc\u5957\u5165\u8a69\u7cfb\u7d71\u4e2d\u3002\u770b\u660e\u4e86\u5167\u5bb9\u624d\u61c2\u6b23\u8cde\u8a69\u7684\u610f\u5883\uff0c\u770b\u6e05\u7528\u5b57\u7684\u5de5\u6574\u5de7\u5999\uff0c\u624d\u61c2\u6b23\u8cde\u8a69\u7684\u7f8e\u3002 \u8fd1\u9ad4\u8a69\u6700\u8b1b\u7a76\u5e73\u4ec4\uff0c\u6211\u4ee5\u524d\u5b78\u6975\u4e5f\u5b78\u4e0d\u61c2\u5e73\u4ec4\u3002\u6240\u4ee5\u6211\u6700\u618e\u90a3\u4e9b\u61f6\u9192\u7684\u4eba\uff0c\u8aaa\u5e73\u4ec4\u5f88\u6613\u5b78\uff0c\u4e94\u5206\u9418\u5c31\u5b78\u61c2\u3002\u9019\u672c\u66f8\u5f9e\u6700\u57fa\u672c\u7684\u5e73\u4e0a\u53bb\u5165\u56db\u8072\u958b\u59cb\u6559\u8d77\uff0c\u5c0d\u7167\u53e4\u97f3\u548c\u73fe\u4ee3\u666e\u901a\u8a71\u8207\u7cb5\u8a9e\u3002\u6700\u91cd\u8981\u662f\u9644\u9304\u7684\u5e73\u6c34\u8af3\uff0c\u5c31\u7b97\u4e0d\u77e5\u9053\u67d0\u4e00\u500b\u5b57\u7684\u5e73\u4ec4\uff0c\u4e5f\u5927\u7d04\u660e\u767d\u4e86\u5e73\u4ec4\u7684\u7279\u6027\u3002\u4f5c\u8005\u5f9e\u4e94\u8a00\u8a69\u958b\u59cb\uff0c\u5148\u628a\u5e73\u4ec4\u683c\u5f0f\u5206\u70ba\u56db\u5927\u985e\uff0c\u5f9e\u8072\u5b78\u89d2\u5ea6\u89e3\u91cb\u5e73\u4ec4\uff0c\u5c0d\u8214\uff0c\u6551\u62d7\u7b49\uff0c\u518d\u7531\u57fa\u672c\u53e5\u5f0f\u6f14\u8b8a\u51fa\u5176\u4ed6\u53e5\u5f0f\uff0c\u4e94\u8a00\u53e5\u52a0\u5169\u5b57\u6f14\u8b8a\u51fa\u4e03\u8a00\u53e5\u3002\u53e4\u8a69\u548c\u8fd1\u9ad4\u8a69\u7684\u6700\u5927\u5206\u5225\uff0c\u4fbf\u662f\u5510\u4ee3\u4ee5\u524d\u53e4\u4eba\u9084\u5b8c\u5168\u638c\u63e1\u5e73\u4ec4\u898f\u5f8b\uff0c\u6240\u4ee5\u53e4\u8a69\u5e73\u4ec4\u548c\u7528\u97fb\u6bd4\u8f03\u5bec\u9b06\u3002 \u8981\u770b\u61c2\u4e00\u9996\u8a69\u6700\u91cd\u8981\u660e\u767d\u5167\u5bb9\uff0c\u5f88\u591a\u6642\u5019\u8a69\u53e5\u4e2d\u6bcf\u500b\u5b57\u4e5f\u8b58\u8b80\uff0c\u4f46\u653e\u5728\u4e00\u8d77\u537b\u4e0d\u77e5\u8aaa\u4ec0\u9ebc\u3002\u9019\u672c\u66f8\u628a\u767e\u5510\u8a69\u7684\u53e5\u5b50\u6574\u7406\uff0c\u6b78\u7d0d\u70ba\u4e8c\u767e\u591a\u7a2e\u4e0d\u540c\u53e5\u5f0f\uff0c\u6bcf\u4e00\u53e5\u518d\u6a19\u6ce8\u5206\u5225\u90a3\u90e8\u4efd\u662f\u4e3b\u8a9e\uff0c\u8cd3\u8a9e\uff0c\u8b02\u8a9e\uff0c\u5b9a\u8a9e\uff0c\u72c0\u8a9e\uff0c\u6bcf\u500b\u5b57\u5c6c\u65bc\u540d\u8a5e\uff0c\u52d5\u8a5e\uff0c\u4ecb\u8a5e\uff0c\u865b\u8a5e\uff0c\u90a3\u4e9b\u662f\u5e38\u7528\u7684\u5012\u88dd\u53e5\u7b49\u7b49\u3002\u9019\u662f\u5f88\u5927\u91cf\u7684\u8cc7\u6599\uff0c\u4f46\u53ea\u8981\u770b\u904e\u8a18\u4f4f\u4e86\uff0c\u89e3\u8b80\u8a69\u53e5\u4fbf\u6beb\u7121\u96e3\u5ea6\u3002\u9664\u4e86\u53e4\u8a69\u5510\u8a69\u5916\uff0c\u9019\u672c\u66f8\u4e5f\u540c\u6a23\u5206\u6790\u5b8b\u8a5e\uff0c\u5f88\u6709\u7cfb\u7d71\u6574\u7406\u8a5e\u8b5c\uff0c\u7528\u97fb\uff0c\u5c0d\u4ed7\u548c\u6587\u6cd5\u7279\u9ede\uff0c\u96d6\u7136\u591a\u4f46\u5f88\u7c21\u55ae\u4e00\u770b\u4fbf\u61c2\uff0c\u53ea\u4e0d\u904e\u662f\u53e6\u4e00\u5957\u7528\u5b57\u898f\u5247\u3002 \u6211\u5b78\u4e86\u5341\u5e7e\u5e74\u4e2d\u6587\uff0c\u7adf\u7136\u9023\u8b02\u8a9e\u662f\u4ec0\u9ebc\u672a\u807d\u904e\uff0c\u66f4\u4e0d\u7528\u8aaa\u4e0d\u540c\u865b\u8a5e\u7684\u61c9\u7528\uff0c\u90fd\u4e0d\u77e5\u9053\u4ee5\u524d\u5b78\u6821\u600e\u6a23\u6559\u4e2d\u6587\u3002\u82e5\u679c\u5b78\u6821\u7528\u9019\u672c\u66f8\u7684\u65b9\u6cd5\u6559\uff0c\u5beb\u8a69\u5176\u5be6\u4e0d\u96e3\uff0c\u53ea\u8981\u6309\u516c\u5f0f\u591a\u52a0\u7df4\u7fd2\uff0c\u6bcf\u53e5\u8a69\u4e5f\u67e5\u8868\u53cd\u8986\u4fee\u6b63\u7528\u5b57\uff0c\u8ab0\u4eba\u4e5f\u53ef\u4ee5\u5beb\u51fa\u4e00\u9996\u5de5\u6574\u7684\u8a69\u3002\u5b78\u751f\u5927\u6168\u88ab\u51fa\u53e3\u6210\u8a69\u7684\u5f62\u50cf\u4f59\u6bd2\uff0c\u4ee5\u70ba\u5beb\u8a69\u662f\u4e00\u4ef6\u5f88\u6d6a\u6f2b\u5f88\u85dd\u8853\u7684\u4e8b\u3002\u5176\u5be6\u5beb\u8a69\u597d\u50cf\u756b\u7d20\u63cf\uff0c\u53ea\u8981\u57fa\u790e\u529f\u592b\u719f\u7df4\uff0c\u4fbf\u53ef\u4ee5\u50cf\u780c\u7a4d\u6728\u822c\uff0c\u5beb\u51fa\u4e00\u9996\u4f3c\u6a21\u4f3c\u6a23\u7684\u8a69\u3002\u800c\u4e45\u7d93\u935b\u7df4\u901f\u5ea6\u52a0\u5feb\uff0c\u9700\u8981\u53cd\u8986\u4fee\u6b63\u7684\u9010\u6f38\u6b21\u6578\u6e1b\u5c11\uff0c\u81ea\u81ea\u7136\u7136\u4fbf\u80fd\u5920\u51fa\u53e3\u6210\u8a69\u3002","rel":"","context":"In &quot;\u66f8\u8a55&quot;","block_context":{"text":"\u66f8\u8a55","link":"https:\/\/www.horace.org\/blog\/category\/_books\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2012\/03\/9789621419095.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":694,"url":"https:\/\/www.horace.org\/blog\/2006\/12\/20\/debugging-david-j-agans\/","url_meta":{"origin":15586,"position":3},"title":"Debugging &#8211; David J. Agans","author":"hevangel","date":"December 20, 2006","format":false,"excerpt":"\u9664\u87f2(Debug)\u662f\u6bcf\u500b\u5beb\u7a0b\u5f0f\u6216\u505a\u8a2d\u8a08\u7684\u4eba\u4e5f\u5fc5\u9808\u8981\u61c2\u7684\u57fa\u672c\u6c42\u751f\u6280\u5de7\u3002\u6c92\u6709\u4eba\u53ef\u4ee5\u843d\u7b46\u6c38\u4e0d\u72af\u932f\ufe50\u6240\u4ee5\u53bb\u627e\u51fa\u932f\u8aa4\u4e26\u52a0\u4ee5\u4fee\u6b63\u662f\u5fc5\u7d93\u7684\u968e\u6bb5\u3002\u9019\u500b\u9664\u87f2\u7684\u904e\u7a0b\u5f88\u591a\u6642\u9593\u75db\u82e6\u800c\u6f2b\u9577\ufe50\u7279\u5225\u662f\u90a3\u96bb\u87f2\u5728\u5225\u4eba\u7684\u5091\u4f5c\u88cf\u9762\u3002\u6211\u81ea\u5c0f\u73a9\u5beb\u7a0b\u5f0f\u548c\u780c\u96fb\u8166\ufe50\u5927\u5b78\u6642\u8b80\u5de5\u7a0b\u7cfb\ufe50\u51fa\u4f86\u505a\u6642\u662f\u7576\u5de5\u7a0b\u5e2b\ufe50\u7121\u4e0d\u662f\u548c\u87f2\u6253\u4ea4\u9053\u3002\u4e0d\u662f\u81ea\u8ce3\u81ea\u8de8\ufe50\u6211\u5c0d\u6297\u87f2\u5bb3\u7d93\u9a57\u8c50\u5bcc\ufe50\u9664\u87f2\u5feb\u800c\u6e96\u3002\u5f88\u591a\u6642\u5019\u6211\u89ba\u5f97\u9664\u87f2\u4e0d\u55ae\u8981\u8166\u7b4b\u597d\ufe50\u9084\u8981\u6709\u9ede\u9664\u87f2\u7684\u85dd\u8853\u624d\u80fd\u5920\u6709\u6548\u7387\u3002\u4f46\u8aaa\u8d77\u4f86\u6211\u9664\u87f2\u597d\u50cf\u6c92\u6709\u4ec0\u9ebc\u7279\u5225\u65b9\u6cd5\ufe50\u4e5f\u6c92\u6709\u4ec0\u9ebc\u53ef\u9760\u7684\u7cfb\u7d71\u53ef\u8a00\u3002\u5c31\u50cf\u8a9e\u6587\u90a3\u6a23\u662f\u8207\u751f\u4ff1\u4f86\u7684\u80fd\u529b\ufe50\u81ea\u5df1\u61c2\u5982\u4f55\u53bb\u505a\ufe50\u4f46\u5f88\u96e3\u6559\u5225\u4eba\u5982\u4f55\u9664\u87f2\u3002Debugging\u9019\u672c\u66f8\u6b63\u597d\u586b\u88dc\u9019\u500b\u7a7a\u4f4d\ufe50\u5f88\u6709\u7cfb\u7d71\u5730\u6b78\u7d0d\u51fa\u9664\u87f2\u4e5d\u5927\u5b9a\u5f8b\u3002 \u9019\u66f8\u7684\u4f5c\u8005\u7562\u696d\u65bcMIT\ufe50\u5728\u79d1\u6280\u884c\u696d\u5de5\u4f5c\u591a\u5e74\ufe50\u662f\u5f88\u6709\u7d93\u9a57\u7684\u5de5\u7a0b\u5e2b\u3002\u4ed6\u898b\u5e02\u9762\u4e0a\u5b8c\u5168\u6c92\u6709\u95dc\u65bc\u9664\u87f2\u7684\u66f8\ufe50\u65bc\u662f\u628a\u591a\u5e74\u7684\u9664\u87f2\u5fc3\u5f97\u6574\u7406\u5beb\u4e0b\u4f86\ufe50\u5e0c\u671b\u53ef\u4ee5\u5e6b\u52a9\u5f8c\u8f29\u638c\u63e1\u9664\u87f2\u6280\u5de7\u3002\u66f8\u4e2d\u4f9d\u6b21\u4f8b\u51fa\u9664\u87f2\u4e5d\u5927\u5b9a\u5f8b\ufe50\u6bcf\u4e00\u5b9a\u5f8b\u4e5f\u6709\u8a73\u7d30\u89e3\u8aaa\ufe50\u4e26\u4e14\u9644\u4ee5\u4f5c\u8005\u7d93\u9a57\u7684\u771f\u5be6\u6848\u4f8b\u53bb\u8aaa\u660e\u61c9\u7528\u3002\u6700\u5f8c\u5e7e\u7ae0\u5c07\u6240\u6709\u5b9a\u5f8b\u878d\u6703\u8cab\u901a\ufe50\u5c55\u8996\u7d66\u8b80\u8005\u7531\u767c\u73fe\u554f\u984c\u5230\u627e\u51fa\u932f\u8aa4\ufe50\u5982\u4f55\u628a\u5b9a\u5f8b\u7d9c\u5408\u6574\u500b\u9664\u87f2\u904e\u7a0b\u3002\u6700\u5f8c\u4e00\u7ae0\u5f88\u7279\u5225\ufe50\u5f9ehelpdesk\u7684\u89d2\u5ea6\u51fa\u767c\ufe50\u628a\u5b9a\u5f8b\u5728\u4ed6\u5011\u7684\u773c\u4e2d\u6f14\u8b6f\u4e00\u6b21\u3002\u5c0d\u5728helpdesk\u7576\u6280\u8853\u652f\u63f4\u7684\u4eba\u6545\u7136\u6709\u7528\ufe50\u5c0d\u6253\u96fb\u8a71\u53bbhelpdesk\u6551\u52a9\u7684\u4eba\ufe50\u5373\u662f\u5176\u4ed6\u6240\u6709\u4eba\u4e5f\u6709\u5e6b\u52a9\u3002\u77e5\u9053helpdesk\u5982\u4f55\u904b\u4f5c\ufe50\u914d\u5408\u4ed6\u5011\u60f3\u8981\u7684\u8cc7\u6599\ufe50\u624d\u80fd\u66f4\u5feb\u89e3\u6c7a\u554f\u984c\u3002 \u6211\u628a\u9664\u87f2\u4e5d\u5927\u5b9a\u5f8b\u7ffb\u8b6f\u51fa\u4f86\ufe50\u7d66\u5927\u5bb6\u4f5c\u4e00\u500b\u7c21\u4ecb\ufe55 1. \u5fb9\u5e95\u660e\u767d\u7cfb\u7d71\u7684\u904b\u4f5c\u3002\u5982\u4e0d\u660e\u767d\ufe50\u8acb\u5148\u628a\u4f7f\u7528\u624b\u518a\u7531\u982d\u5230\u5c3e\u8b80\u4e00\u6b21\u3002 2. \u8b93\u7cfb\u7d71\u5931\u9748\u3002\u7cfb\u7d71\u5931\u9748\u662f\u9664\u87f2\u7684\u7b2c\u4e00\u689d\u7dda\u7d22\ufe50\u770b\u4e0d\u898b\u5931\u9748\u5c31\u627e\u4e0d\u5230\u87f2\u3002 3. \u4e0d\u8981\u9760\u4f30\ufe50\u8981\u770b\u6e05\u695a\u90a3\u5152\u51fa\u932f\u3002\u9664\u87f2\u7684\u7cbe\u9ad3\u4e0d\u5728\u65bc\u8981\u4f30\u5f97\u6e96\ufe50 \u800c\u662f\u5982\u4f55\u53bb\u6e1b\u5c11\u4f30\u932f\u7684\u6a5f\u6703\ufe50\u4e00\u4f30\u932f\u5c31\u6703\u6d6a\u8cbb\u5f88\u591a\u6642\u9593\u884c\u932f\u8def\u3002 4. \u5206\u800c\u653b\u4e4b\u3002\u628a\u87f2\u51fa\u6c92\u7684\u7b35\u570d\u6536\u7a84\ufe50\u5982\u662f\u8005\u5c31\u6703\u627e\u5230\u87f2\u7684\u4f4d\u7f6e\u3002 5. \u6bcf\u6b21\u53ea\u6539\u4e00\u6a23\u3002\u4e00\u6b21\u904e\u6539\u592a\u591a\ufe50\u4e0d\u55ae\u4e0d\u80fd\u9664\u87f2\ufe50\u9084\u6709\u53ef\u80fd\u7522\u751f\u65b0\u7684\u87f2\u3002 6. \u6240\u6709\u4e8b\u4e5f\u8981\u6709\u8a18\u9304\u3002\u6c92\u6709\u8a73\u7d30\u7684\u8a18\u9304\ufe50\u5c31\u6c92\u6709\u8db3\u5920\u7684\u8cc7\u6599\u53bb\u9664\u87f2 7. \u770b\u770b\u6709\u6c92\u6709\u63d2\u96fb\u63a3\u3002\u6700\u5b89\u5168\u7684\u5730\u65b9\u5c31\u662f\u6700\u5371\u96aa\u7684\u5730\u65b9\ufe50 \u6700\u767d\u75f4\u6700\u986f\u773c\u7684\u932f\u8aa4\ufe50\u5f80\u5f80\u6700\u5bb9\u6613\u88ab\u5ffd\u7565\u770b\u4e0d\u898b\u3002 8. \u4e0d\u8981\u947d\u725b\u89d2\u5c16\ufe50\u60f3\u4e0d\u5230\u5c31\u8981\u865b\u5fc3\u554f\u4eba\u3002 9. \u8a66\u6e05\u695a\u4fee\u6b63\u662f\u5426\u6709\u6548\u3002\u5f88\u591a\u6642\u5019\u4ee5\u70ba\u627e\u5230\u87f2\u932f\u8aa4\u4fee\u6b63\u597d\u5c31\u5b8c\u5de5\ufe50 \u53ea\u4e0d\u904e\u6070\u5de7\u90a3\u4e9b\u597d\u5f69\u6c92\u6709\u9047\u4e0a\u554f\u984c\ufe50\u87f2\u9084\u662f\u597d\u7aef\u7aef\u5728\u90a3\u5152\u7b49\u4e0b\u6b21\u518d\u54ac\u4eba\u3002 \u96d6\u7136\u6211\u5728\u770b\u9019\u672c\u66f8\u6642\ufe50\u4e0d\u7981\u60f3\u9019\u9664\u87f2\u4e5d\u5927\u5b9a\u5f8b\u53ea\u4e0d\u904e\u662f\u7c21\u55ae\u5e38\u8b58\ufe50\u4efb\u4f55\u5beb\u904e\u7a0b\u5f0f\u7684\u4eba\u4e5f\u5fc5\u5b9a\u7121\u5e2b\u81ea\u901a\u5b78\u6703\u3002\u53ef\u662f\u56de\u9867\u4e00\u4e0b\u6211\u7684\u9664\u87f2\u7d93\u9a57\ufe50\u4e45\u4e0d\u4e45\u6211\u81ea\u5df1\u4e5f\u6703\u4e00\u6642\u5927\u610f\u9055\u53cd\u9019\u4e9b\u5b9a\u5f8b\ufe50\u5f04\u5f97\u5718\u5718\u8f49\u4e0d\u77e5\u5982\u4f55\u53bb\u89e3\u6c7a\u3002\u73fe\u5728\u6709\u4eba\u5f88\u6709\u7cfb\u7d71\u5730\u5beb\u4e86\u51fa\u4f86\ufe50\u4e0d\u55ae\u8b93\u6211\u66f4\u6df1\u523b\u8a18\u5f97\u9019\u4e9b\u9664\u87f2\u5b9a\u5f8b\ufe50\u9084\u53ef\u4ee5\u8b93\u6211\u5f88\u7cbe\u78ba\u5730\u628a\u9664\u87f2\u6280\u5de7\u6559\u4eba\ufe50\u4e0d\u6703\u81ea\u5df1\u61c2\u4f46\u627e\u4e0d\u5230\u8a00\u8a9e\u5f62\u5bb9\u7684\u7169\u60f1\u3002\u9019\u672c\u66f8\u5949\u9001\u9664\u87f2\u4e5d\u5927\u5b9a\u5f8b\u7684\u6d77\u5831\ufe50\u6211\u7279\u5225\u5370\u4e86\u51fa\u4f86\u8cbc\u5728\u6211\u7684\u5de5\u4f5c\u9593\u3002\u7576\u81ea\u5df1\u627e\u4e0d\u5230\u87f2\u6beb\u7121\u982d\u7dd2\u6642\ufe50\u62ac\u982d\u7d30\u770b\u9019\u4e5d\u5927\u5b9a\u5f8b\ufe50\u56de\u60f3\u81ea\u5df1\u9055\u53cd\u4e86\u90a3\u689d\ufe50\u8b66\u60d5\u81ea\u5df1\u6539\u904e\ufe50\u5f88\u5feb\u5c31\u53ef\u4ee5\u627e\u5230\u5bb3\u87f2\u3002\u7576\u5225\u4eba\u554f\u6211\u6709\u95dc\u9664\u87f2\u7684\u554f\u984c\u6642\ufe50\u6211\u53ef\u4ee5\u5f88\u7701\u6c23\u529b\u5730\u8457\u5176\u4e2d\u4e00\u689d\u56de\u7b54\u4ed6\u3002\u4e0d\u8ad6\u662f\u9664\u87f2\u65b0\u4ed4\u9084\u662f\u7d93\u9a57\u8001\u624b\ufe50\u9019\u672c\u66f8\u61c9\u88ab\u5949\u70ba\u9664\u87f2\u5bf6\u5178\ufe50\u4efb\u4f55\u8a2d\u8a08\u7a0b\u5f0f\u6216\u786c\u4ef6\u7684\u4eba\u4e5f\u61c9\u8a72\u8981\u8b80\u4e00\u904d\u3002","rel":"","context":"In &quot;\u66f8\u8a55&quot;","block_context":{"text":"\u66f8\u8a55","link":"https:\/\/www.horace.org\/blog\/category\/_books\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2006\/12\/081447168401_ss500_sclzzzzzzz_v1118226866_.jpg?fit=500%2C500&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":12395,"url":"https:\/\/www.horace.org\/blog\/2017\/11\/08\/linux-works-brian-ward\/","url_meta":{"origin":15586,"position":4},"title":"How Linux Works &#8211; Brian Ward","author":"hevangel","date":"November 8, 2017","format":false,"excerpt":"\u63a5\u89f8Linux\u5927\u5927\u8a71\u8a71\u90fd\u6709\u5eff\u5e7e\u5e74\uff0c\u5f9e\u6700\u521d\u5514\u77e5\u8cb7\u4e5c\u9b3c\u96dc\u8a8c\u9001CD\uff0c\u81ea\u5df2\u88dd\u4f86\u88dd\u53bb\u5230\u641e\u5514\u6382\u500bgraphics driver\uff0c\u5230\u5f8c\u4f86Linux\u4e00\u7d71\u6c5f\u6e56\uff0c\u65e5\u65e5\u8fd4\u5de5\u90fd\u5728Linux\u4e0a\u5bebcode\uff0c\u5230\u6700\u8fd1\u56e0\u5de5\u4f5c\u9700\u8981\u81ea\u5df1compile Linux\uff0c\u624d\u767c\u89ba\u6211\u5f9e\u4f86\u6c92\u6709\u8a8d\u771f\u5b78\u7fd2\u904eLinux\u3002\u65e5\u5e38\u4f7f\u7528Linux\u8dd1\u7a0b\u5f0f\uff0c\u780c\u6a5f\u704cOS\u88ddLinux\u90a3\u4e9b\u624b\u677f\u773c\u898b\u529f\u592b\uff0c\u9047\u5230\u96e3\u984c\u4e0a\u7db2Google\u7b54\u6848\u8f15\u6613\u904e\u95dc\uff0c\u57fa\u790e\u6253\u4e0d\u597d\uff0c\u73fe\u5728\u66f8\u5230\u7528\u6642\u65b9\u6068\u5c11\uff0c\u8981\u6709\u7cfb\u7d71\u5730\u91cd\u65b0\u8a8d\u8b58Linux\u3002 \u9019\u672c\u300aHow Linux Works\u300b\u96d6\u7136\u7f8e\u5176\u540d\u662f\u5165\u9580\u66f8\u85c9\uff0c\u4e0d\u904e\u9664\u4e86\u7b2c\u4e00\u7ae0\u7684Linux\u7c21\u4ecb\uff0c\u7b2c\u4e8c\u7ae0\u65e5\u5e38\u4f7f\u7528\u7684commands\u5916\uff0c\u7b2c\u4e09\u7ae0\u6253\u5f8c\u96e3\u5ea6\u4e09\u7d1a\u8df3\uff0c\u5f9eFilesystems\uff0c\u5230Kernel Bootup\uff0csystemd\u57f7\u884c\u5148\u5f8c\u6b21\u5e8f\uff0c\u6bcf\u4e00\u500b\u984c\u76ee\u90fd\u8d85\u904e\u4e00\u822c\u7528\u5bb6\u8981\u77e5\u9053\u7684\u77e5\u8b58\uff0c\u53ef\u4ee5\u8aaa\u662fLinux admin\u7684\u6307\u5357\u7d22\u5f15\u3002\u9019\u672c\u66f8\u4e0d\u592a\u539a\u53ea\u6709\u4e0d\u5230\u56db\u767e\u9801\uff0c\u6240\u4ee5\u6bcf\u500b\u984c\u76ee\u90fd\u4e0d\u6703\u8b1b\u5f97\u592a\u6df1\u5165\uff0c\u53cd\u800c\u662f\u7cfb\u7d71\u5316\u5730\u628aLinux\u7684\u5167\u5bb9\u4f8b\u51fa\u4f86\uff0c\u8b80\u8005\u5927\u7d04\u77e5\u9053\u6709\u4ec0\u9ebc\u984c\u76ee\uff0c\u7136\u5f8c\u81ea\u5df1\u518d\u627e\u4e0a\u7db2\u627e\u8cc7\u6599\u3002 \u9019\u672c\u66f8\u7684\u5167\u5bb9\uff0c\u5927\u6168\u6709\u516b\u6210\u6211\u4ee5\u524d\u770b\u904e\uff0c\u6240\u4ee5\u770b\u904e\u672c\u66f8\u975e\u5e38\u5feb\uff0c\u5f88\u591a\u7ae0\u7bc0\u53ea\u662f\u7c97\u7565\u7ffb\u770b\u3002\u5269\u4e0b\u4f86\u7684\u5169\u6210\u65b0\u77e5\u8b58\u975e\u5e38\u6709\u7528\uff0c\u88dc\u5b8c\u6211\u5c0dLinux\u8a8d\u77e5\u7684\u7f3a\u6f0f\uff0c\u6709\u4e9b\u5f88\u7c21\u55ae\u7684\u57fa\u790e\u6168\u5ff5\uff0c\u4e00\u822c\u7db2\u4e0a\u901f\u98df\u89e3\u7b54\u6c92\u6709\u8b1b\u89e3\uff0c\u4f8b\u5982\/usr\u5176\u5be6\u540cuser\u7121\u95dc\uff0c\u65b0process\u5982\u4f55fork\u51fa\u4f86\uff0cshell script\u53ef\u4ee5\u958bsubshell\uff0cX\u7cfb\u7d71server\u540cclient\u7684\u5206\u529f\u7b49\u7b49\u3002\u5f88\u591a\u6771\u897f\u6211\u61c2\u5f97\u7528\u4f46\u4e0d\u6c42\u751a\u89e3\uff0c\u73fe\u5728\u5b78\u597d\u4e86\u57fa\u672c\u77e5\u8b58\uff0c\u958b\u59cb\u770b\u901aLinux\u7684\u8a2d\u8a08\u908f\u8f2f\uff0c\u5f88\u591a\u7591\u554f\u4fbf\u4e00\u7406\u901a\u767e\u7406\u660e\u3002 \u4e0d\u904e\u770b\u5b8c\u9019\u672c\u66f8\uff0c\u96d6\u7136\u5c0dLinux\u7684\u8a8d\u8b58\u662f\u5b8c\u6574\u4e86\uff0c\u5c0d\u65bccompile Linux\u7684\u5e6b\u52a9\u4e0d\u5927\uff0c\u9802\u591a\u5728\u6211\u57f7package\u6642\u81f3\u5c11\u77e5\u9053\u653e\u4e86\u4ec0\u9ebc\u5165\u53bb\u500bbuild\u5ea6\uff0c\u4f46\u89e3\u6c7a\u4e0d\u4e86kernel\u958b\u4e0d\u5230\u6a5f\u7684\u71c3\u7709\u4e4b\u6025\uff0c\u9084\u8981\u7e7c\u7e8c\u627e\u5176\u4ed6\u66f8\u770b\u3002","rel":"","context":"In &quot;\u66f8\u8a55&quot;","block_context":{"text":"\u66f8\u8a55","link":"https:\/\/www.horace.org\/blog\/category\/_books\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2017\/11\/4789070349b7bc1b.png?fit=503%2C666&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":692,"url":"https:\/\/www.horace.org\/blog\/2006\/12\/20\/how-to-win-friends-and-influence-people-dale-carnegie\/","url_meta":{"origin":15586,"position":5},"title":"How to Win Friends and Influence People &#8211; Dale Carnegie","author":"hevangel","date":"December 20, 2006","format":false,"excerpt":"\u9019\u672c\u4eba\u969b\u95dc\u4fc2\u7684\u5929\u66f8\u5728\u516b\u5341\u591a\u5e74\u524d\u5beb\u6210\ufe50 \u5230\u4e86\u4eca\u6642\u4eca\u65e5\u9084\u80fd\u5920\u5728\u66a2\u92b7\u66f8\u699c\u4e2d\ufe50\u9577\u671f\u7dca\u4f54\u4e00\u5e2d\u4f4d\u3002\u5f88\u591a\u540d\u4eba\u4ea6\u63a8\u85a6\u9019\u66f8\u70ba\u5fc5\u8b80\u4f5c\u54c1\ufe50\u8db3\u4ee5\u986f\u51fa\u9019\u672c\u66f8\u7684\u4efd\u91cf\u3002\u66f8\u7684\u5167\u5bb9\u5982\u5176\u540d\ufe50\u5c31\u662f\u6559\u8b80\u8005\u5982\u4f55\u53bb\u8d0f\u53d6\u53cb\u8abc\u548c\u5f71\u97ff\u4ed6\u4eba\u3002\u9019\u672c\u66f8\u7684\u4e2d\u6587\u4e2d\u6587\u8b6f\u540d\u662f\u4eba\u6027\u7684\u5f31\u9ede\ufe50\u6bd4\u82f1\u540d\u539f\u540d\u66f4\u7c21\u6f54\u6709\u529b\ufe50\u53ea\u7528\u56db\u500b\u5b57\u5c31\u7e3d\u62ec\u8aaa\u660e\u8d0f\u53d6\u53cb\u8abc\u548c\u5f71\u97ff\u4ed6\u4eba\u7684\u4e0d\u4e8c\u6cd5\u9580\u3002\u4f9d\u4fd9\u8a18\u5f97\u6211\u5728\u4e2d\u5b78\u5e74\u4ee3\u5df2\u7d93\u8b80\u904e\u9019\u672c\u66f8\ufe50\u56e0\u6642\u9694\u591a\u5e74\u5167\u5bb9\u5df2\u5fd8\u8a18\u5f97\u4e03\u4e03\u516b\u516b\ufe50\u4e5f\u4e0d\u77e5\u9053\u7576\u5e74\u6211\u770b\u660e\u767d\u591a\u5c11\u5167\u5bb9\u3002\u6700\u8fd1\u6211\u4e0b\u8f09\u4e86\u9019\u672c\u66f8\u7684CD\u7248\ufe50\u5728\u99d5\u8eca\u4e0a\u4e0b\u73ed\u6642\u6536\u807d\ufe50\u7576\u662f\u5de5\u9918\u7684\u500b\u4eba\u9032\u4fee\u3002\u9019\u6b21\u91cd\u62fe\u9019\u672c\u66f8\u4f7f\u6211\u7372\u76ca\u826f\u591a\ufe50\u6709\u9ede\u5152\u5f8c\u6094\u9019\u672c\u66f8\u653e\u5728\u66f8\u67b6\u4e0a\u591a\u5e74\ufe50\u4e5f\u4e00\u76f4\u6c92\u6709\u62ff\u8d77\u4f86\u7d30\u5fc3\u95b1\u8b80\u3002 \u66f8\u672c\u5176\u5be6\u662f\u8aaa\u505a\u4eba\u7684\u9053\u7406\ufe50\u770b\u8d77\u4f86\u5f88\u986f\u6dfa\u6613\u898b\ufe50\u7406\u6240\u7576\u7136\u7684\u4eba\u4eba\u4e5f\u61c2\ufe50\u53ef\u662f\u6709\u5f88\u591a\u4eba\u5c31\u662f\u6c92\u6cd5\u505a\u5230\u3002\u53ef\u80fd\u662f\u6839\u672c\u4e0d\u77e5\u9053\ufe50\u66f4\u53ef\u80fd\u662f\u77e5\u9053\u4f46\u5fd8\u8a18\u4e86\u3002\u9019\u672c\u66f8\u628a\u5f85\u4eba\u63a5\u7269\u7684\u65b9\u6cd5\ufe50\u7c21\u55ae\u7684\u6b78\u7d0d\u70ba\u5e7e\u500b\u5927\u539f\u5247\ufe50\u8f14\u4ee5\u540d\u4eba\u9038\u4e8b\ufe50\u53bb\u8aaa\u660e\u5982\u4f55\u6709\u6548\u5730\u904b\u7528\u90a3\u4e9b\u539f\u5247\u7684\u65b9\u6cd5\u3002\u66f8\u4e2d\u5206\u70ba\u4e09\u5927\u90e8\u4efd\ufe50\u5982\u4f55\u8b93\u4eba\u559c\u6b61\u4f60\ufe50\u5982\u4f55\u53bb\u8b93\u4eba\u540c\u610f\u4f60\ufe50\u4ee5\u53ca\u5982\u4f55\u53bb\u6539\u8b8a\u5225\u4eba\u3002\u7576\u4f60\u60f3\u5411\u4ed6\u4eba\u8981\u4e00\u4e9b\u6771\u897f\u6642\ufe50\u9996\u5148\u8981\u8207\u90a3\u500b\u4eba\u6e9d\u901a\u3002\u53ef\u662f\u4eba\u4e0d\u662f\u96fb\u8166\ufe50\u4e0d\u80fd\u76f4\u63a5\u7c21\u55ae\u5730\u8f38\u5165\u547d\u4ee4\ufe50\u5fc5\u9808\u7528\u4e00\u5957\u4ee5\u6709\u6548\u7684\u65b9\u6cd5\u53bb\u6e9d\u901a\ufe50\u9019\u5c31\u662f\u4eba\u969b\u95dc\u4fc2\u7684\u7cbe\u9ad3\u4e86\u3002\u6709\u4eba\u6703\u8aaa\u66f8\u4e2d\u6559\u7684\u90a3\u4e9b\u65b9\u6cd5\u5f88\u5047\ufe50\u662f\u5229\u7528\u4eba\u5fc3\u7684\u6b0a\u8853\u8a6d\u9053\ufe50\u4f46\u7121\u53ef\u5426\u8a8d\u4eba\u6709\u5fc3\u7406\u56e0\u7d20\u9019\u500b\u4e8b\u5be6\ufe50\u82e5\u8981\u6709\u6548\u6e9d\u901a\u5c31\u8981\u6709\u9069\u7576\u7684\u65b9\u6cd5\u3002\u5176\u5be6\u9019\u672c\u66f8\u53ea\u662f\u63d0\u4f9b\u4eba\u969b\u9593\u7684\u5de5\u5177\ufe50\u5de5\u5177\u672c\u8eab\u662f\u4e2d\u6027\u7684\ufe50\u6c92\u6709\u5206\u597d\u58de\ufe50\u662f\u597d\u662f\u58de\u8996\u4e4e\u62ff\u8457\u5de5\u5177\u7684\u4eba\u60f3\u53bb\u505a\u4ec0\u9ebc\u4e8b\u3002 \u5f88\u591a\u4eba\u5c0d\u9019\u672c\u66f8\u6709\u4e00\u500b\u5148\u5165\u70ba\u4e3b\u7684\u504f\u898b\ufe50\u6700\u5927\u539f\u56e0\u53ef\u80fd\u662f\u5c01\u9762\u7684\u8a2d\u8a08\u3002\u5c01\u9762\u5168\u9ed1\u8272\u6709\u4e00\u500b\u9ab7\u9acf\u982d\ufe50\u7d66\u4eba\u6709\u9ede\u90aa\u9580\u7684\u611f\u89ba\u3002\u66f8\u4e2d\u6240\u7528\u7684\u8868\u9054\u65b9\u6cd5\ufe50\u8207\u4e2d\u570b\u50b3\u7d71\u5112\u5bb6\u601d\u60f3\u7684\u541b\u5b50\u89c0\u5ff5\u4e0d\u4e4e\ufe50\u770b\u4f3c\u662f\u5c0f\u4eba\u624d\u6703\u7528\u7684\u624b\u6bb5\u3002\u5176\u5be6\u5982\u679c\u80fd\u5920\u767c\u81ea\u5167\u5fc3\u5730\u505a\u5230\u66f8\u4e2d\u6240\u8b1b\u7684\u9053\u7406\ufe50\u5c31\u5df2\u7d93\u9054\u5230\u8056\u4eba\u7684\u5883\u754c\u3002\u53ef\u662f\u51e1\u4eba\u59cb\u7d42\u4e0d\u662f\u8056\u4eba\ufe50\u505a\u4e0d\u5230\u5167\u5fc3\u81f3\u5c11\u4e5f\u505a\u5916\u8868\ufe50\u7562\u7adf\u9019\u5c0d\u81ea\u5df1\u6700\u6709\u76ca\u8655\u3002\u66f8\u4e2d\u7684\u4f8b\u5b50\u591a\u6578\u7528\u7f8e\u570b\u540d\u4eba\ufe50\u9664\u4e86\u5e7e\u500b\u7e3d\u7d71\u5916\u6211\u5011\u5927\u591a\u4e0d\u8a8d\u8b58\ufe50\u82e5\u679c\u7ffb\u8b6f\u672c\u53ef\u4ee5\u7528\u4e2d\u570b\u540d\u4eba\u7684\u4f8b\u5b50\ufe50\u6211\u60f3\u5438\u5f15\u66f4\u80fd\u8b80\u8005\u7684\u95b1\u8b80\u8208\u8da3\ufe50\u4e0d\u904e\u5012\u8f49\u982d\u60f3\ufe50\u4e2d\u570b\u7684\u6b77\u53f2\u4e0d\u6d41\u884c\u4eba\u969b\u624b\u6bb5\u9019\u5957\ufe50\u5927\u6168\u53ea\u80fd\u627e\u51fa\u53cd\u9762\u6559\u6750\u3002\u66f8\u4e2d\u6709\u4e00\u500b\u5f88\u91cd\u8981\u7684\u554f\u984c\u6c92\u6709\u89e3\u7b54\ufe50\u5c31\u662f\u5982\u4f55\u8655\u7406\u81ea\u5df1\u7684\u4eba\u6027\u5f31\u9ede\ufe50\u6211\u4e5f\u559c\u6b61\u81ea\u5439\u81ea\u64c2\ufe50\u53ef\u662f\u8981\u807d\u4eba\u81ea\u5439\u81ea\u64c2\u624d\u6703\u53d7\u4eba\u559c\u611b\u554a\u3002\u9019\u672c\u66f8\u8655\u7406\u4eba\u969b\u95dc\u4fc2\u7684\u65b9\u6cd5\u4e3b\u8981\u662f\u9ede\u5c0d\u9ede\ufe50\u8981\u5206\u5225\u53bb\u8207\u6bcf\u4e00\u500b\u4eba\u6e9d\u901a\u3002\u82e5\u662f\u8981\u9762\u5c0d\u4e00\u5927\u7fa4\u4eba\ufe50\u9019\u4e9b\u65b9\u6cd5\u4e5f\u8a31\u4e0d\u80fd\u5168\u90e8\u7167\u677f\u716e\u7897\u5730\u61c9\u7528\ufe50\u4e5f\u8a31\u70ba\u6399\u53d6\u5927\u773e\u7684\u652f\u6301\ufe50\u8981\u7528\u8207\u66f8\u4e2d\u9053\u7406\u76f8\u53cd\u7684\u65b9\u6cd5\u53bb\u5c0d\u4ed8\u5c0f\u6578\u6575\u4eba\u3002\u5728\u65e5\u5e38\u751f\u6d3b\u4e2d\ufe50\u4eba\u8207\u4eba\u7684\u95dc\u4fc2\u591a\u662f\u9ede\u5c0d\u9ede\u5f62\u5f0f\u3002\u8981\u5148\u505a\u597d\u9ede\u5c0d\u9ede\u7684\u6e9d\u901a\ufe50\u624d\u6703\u6709\u6a5f\u6703\u53bb\u505a\u66f4\u9ad8\u5c64\u6b21\ufe50\u9762\u5c0d\u7fa4\u773e\u9ede\u5c0d\u5e73\u9762\u7684\u6e9d\u901a\u3002 \u9019\u672c\u66f8\u662f\u5beb\u65bcEQ\u7406\u8ad6\u767c\u660e\u4e4b\u524d\ufe50\u4f46\u66f8\u4e2d\u5404\u7a2e\u65b9\u6cd5\u7d42\u65e8\u548c\u9ad8EQ\u4e0d\u8b00\u800c\u5408\u3002\u6211\u5011\u5f88\u591a\u6642\u5019\u56e0\u70ba\u8ca0\u9762\u60c5\u7dd2\ufe50\u53ea\u6c42\u767c\u6d29\u81ea\u5df1\u7684\u813e\u6c23\ufe50\u6700\u5f8c\u628a\u4e8b\u60c5\u5f04\u7cdf\u4e86\u3002\u9019\u672c\u4e0d\u662f\u90a3\u7a2e\u770b\u5b8c\u4e00\u6b21\u5c31\u53ef\u4ee5\u6389\u7684\u66f8\ufe50\u800c\u662f\u61c9\u8a72\u8981\u4e45\u4e0d\u4e45\u5c31\u7ffb\u958b\u770b\u770b\ufe50\u53cd\u7701\u4e00\u4e0b\u81ea\u5df1\u5728\u751f\u6d3b\u4e2d\u6709\u6c92\u6709\u9075\u5247\u66f8\u4e2d\u7684\u505a\u4eba\u539f\u5247\u3002\u5047\u8457\u6709\u5929\u6211\u7576\u4e86\u540d\u4eba\ufe50\u6709\u5831\u7d19\u96fb\u53f0\u8a2a\u554f\u6211\u95b1\u8b80\u7fd2\u6163\ufe50\u9019\u672c\u66f8\u5fc5\u5b9a\u6703\u662f\u6211\u63a8\u85a6\u7684\u5341\u672c\u597d\u66f8\u4e4b\u4e00\u3002\u4e0d\u904e\u8aaa\u56de\u4f86\ufe50\u82e5\u505a\u4e0d\u5230\u66f8\u4e2d\u7684\u9053\u7406\ufe50\u8981\u7576\u500b\u6210\u529f\u540d\u4eba\u53ef\u6bd4\u767b\u5929\u9084\u96e3\u3002\u82e5\u53ef\u4ee5\u628a\u66f8\u4e2d\u7684\u9053\u7406\u878d\u6703\u8cab\u901a\ufe50\u4e0d\u8ad6\u4f55\u6642\u4f55\u5730\u4e5f\u81ea\u7136\u5730\u904b\u7528\u51fa\u4f86\ufe50\u81f3\u5c11\u9084\u6709\u6210\u529f\u7684\u6a5f\u6703\ufe50\u751a\u81f3\u6709\u53ef\u80fd\u5df2\u7d93\u4e00\u96bb\u8173\u8e0f\u5728\u6210\u529f\u8def\u4e0a\u3002","rel":"","context":"In &quot;\u66f8\u8a55&quot;","block_context":{"text":"\u66f8\u8a55","link":"https:\/\/www.horace.org\/blog\/category\/_books\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.horace.org\/blog\/wp-content\/uploads\/2006\/12\/0671579592.jpg?fit=291%2C254&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":false,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/posts\/15586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/comments?post=15586"}],"version-history":[{"count":2,"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/posts\/15586\/revisions"}],"predecessor-version":[{"id":15590,"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/posts\/15586\/revisions\/15590"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/media\/15587"}],"wp:attachment":[{"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/media?parent=15586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/categories?post=15586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.horace.org\/blog\/wp-json\/wp\/v2\/tags?post=15586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}