{"id":1469,"date":"2005-11-23T11:46:17","date_gmt":"2005-11-23T03:46:17","guid":{"rendered":"http:\/\/jason6956.wordpress.com\/2005\/11\/23\/3%e5%b1%a4%e5%bc%8f%e6%9e%b6%e6%a7%8b3-tier"},"modified":"2015-03-08T18:48:00","modified_gmt":"2015-03-08T10:48:00","slug":"3%e5%b1%a4%e5%bc%8f%e6%9e%b6%e6%a7%8b3-tier-2","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2005\/11\/23\/3%e5%b1%a4%e5%bc%8f%e6%9e%b6%e6%a7%8b3-tier-2\/","title":{"rendered":"3\u5c64\u5f0f\u67b6\u69cb(3-tier)"},"content":{"rendered":"
\n

http:\/\/www.microsoft.com\/taiwan\/msdn\/columns\/200303netappintro.htm<\/a> <\/p>\n

http:\/\/www.ares.com.tw\/gb\/communicate\/Magazine\/22\/three-tier.htm<\/p>\n

http:\/\/www.infolight.com.tw\/journal\/index_view.asp?no=41&filepath=\/journal\/file\/BOOK5.htm<\/p>\n

\u00a0<\/p>\n<\/p>\n

1. \u50b3\u7d71\u7684 1-Tier<\/span>
\u3000\u3000\u4ee5\u524d DBF \u7cfb\u7d71\u5c31\u662f\u5c07\u8cc7\u6599\u5eab\u653e\u65bc Local\uff08\u55ae\u6a5f\u4e0a\uff09\uff0c\u5982\u6211\u5011\u7528 DBASE \u6216 Clipper \u900f\u904eUse \/ Append \/ Replace \/ Delete \/ Seek\u2026\u7b49\u6307\u4ee4\u53bb\u5b58\u53d6DBF\u6a94\u6848\uff0c\u60a8\u5beb\u7684\u7a0b\u5f0f\u662f\u5728 Local \u4e0a\u57f7\u884c\uff0c\u4e26\u547c\u53eb Local \u4e0a\u7684 DBASE \u6216 Clipper LIB\uff08\u6216 DLL\uff09\u53bb\u5b58\u53d6\u9019\u4e9b DBF \u7684\u8cc7\u6599\uff0c\u6574\u500b\u904e\u7a0b\u90fd\u5728\u540c\u4e00\u500b Local PC \u4e0a\u57f7\u884c\uff0c\u6211\u5011\u53ef\u4ee5\u53eb\u5b83 One-Tier\uff0c\u5b83\u7684\u6700\u5927\u7f3a\u9ede\u5c31\u662f\u5728\u65bc\u53ea\u80fd\u55ae\u6a5f\u4f7f\u7528 \u3002<\/p>\n

2. LAN \u7684 1-Tier<\/span>
\u3000\u3000Novell \u53ca Windows \u53ef\u4ee5\u5c07DBF\u7f6e\u65bc File Server \u4e0a\uff0c\u6240\u4ee5\u9032\u5165\u4e86Multi-User \u6642\u4ee3\uff0c\u6b64\u6642\uff0cDBF \u8b93\u591a\u500b PC \u53ef\u4ee5\u5171\u7528\u8cc7\u6599\uff08\u53ef\u8b80\u53ef\u5beb\uff09\uff0c\u78ba\u5be6\u5e36\u4f86\u4fbf\u5229\u6027\u3002\u4f46\u5728 DBASE \u6216 Clipper \u7684PRG \u9084\u662f\u5728 PC \u7aef\u57f7\u884c\uff08\u7a0b\u5f0f\u53ef\u4ee5\u653e\u5728File Server\u4e0a\uff0c\u4f46 Run \u662f\u5728 PC \u4e0a\uff09\uff0c\u6240\u4ee5 PC \u7aef\u53ea\u662f\u53bb\u7db2\u8def Open DBF \u8cc7\u6599\uff0c\u8b80\u5beb\u90fd\u662f\u5728 PC \u7aef\u53bb\u5b8c\u6210\u7684\uff0c\u9019\u500b\u67b6\u69cb\u53ea\u662f DBF \u7684\u5171\u7528\uff0cFile Server \u4e26\u6c92\u6709\u4efb\u4f55\u4e8b\u60c5\u505a\uff0c\u6240\u4ee5\u9084\u662f\u5728 One-Tier \u4e0a\u4f5c\u696d\uff0c\u6240\u4ee5\u6b64\u67b6\u69cb\u7684\u554f\u984c\u5c31\u5728\u65bc\u8cc7\u6599\u4e00\u591a\u5c31\u9020\u6210\u901f\u5ea6\u4e0a\u7684\u74f6\u9838\uff0c\u5c24\u5176\u662f\u8cc7\u6599\u7684\u7a69\u5b9a\u5ea6\u5e38\u56e0 PC \u7576\u6a5f\u9020\u6210\u56b4\u91cd\u7684\u6bc0\u640d\u3002<\/p>\n

3. DataBase Server \u7684 2-Tier<\/span>
\u3000\u30002-Tier \u5c31\u662f Client\/Server \u7684\u67b6\u69cb\uff0cClient \u5c31\u662f PC \u6216\u7d42\u7aef\u6a5f\uff0cServer \u5c31\u662f Database Server\uff0c\u7d04\u5341\u4e94\u5e74\u524d\uff0cIBM\u767c\u5c55 DB2 \u8207 Client\/Server \u958b\u555f\u4e86\u5927\u9580\uff0c\u6b64\u5f8c\u5982\u96e8\u5f8c\u6625\u7b4d\uff0cInformix\/Sybase\/Oracle\/MS-SQL\u76f8\u7e7c\u5d1b\u8d77\uff0c\u5f9e\u6b64 RDBMS\uff08Relation DataBase Management System\uff09\u5df2\u7d93\u6210\u70ba\u8cc7\u6599\u5eab\u7684\u5171\u540c\u6a19\u6e96\u3002
\u3000\u3000\u6240\u8b02 DataBase Server\uff0c\u5c31\u662f\u5c08\u9580\u8655\u7406\u8cc7\u6599\u5eab\u7684\u4e3b\u6a5f\uff0c\u8655\u7406\u8cc7\u6599\u5eab\u7684\u65b9\u6cd5\u662f\u63a1\u7528\u4e00\u7a2e\u5927\u5bb6\u6a19\u6e96\u7684\u8a9e\u8a00\uff0dSQL\uff0c\u9019\u7a2e\u8a9e\u8a00\u5df2\u7d93\u6210\u70ba\u767c\u5c55\u8cc7\u6599\u5eab\u7684\u5171\u540c\u6a19\u6e96\uff08\u5982 ANSI-92 \u6a19\u6e96\uff09\uff0c\u5c31\u662f\u7121\u8ad6\u60a8\u4f7f\u7528\u54ea\u7a2e\u8cc7\u6599\u5eab\uff0c\u60a8\u90fd\u53ef\u4ee5\u4f7f\u7528\u76f8\u540c\u7684 SQL \u8a9e\u8a00\u5373\u53ef\u4ee5\u5b58\u53d6\u8cc7\u6599\u5eab\u3002\u6240\u6709\u7684 PC \u6216Client\u90fd\u5fc5\u9808\u4ee5 SQL \u4f86\u4e0b\u9054\u7d66 Database Server\uff0c\u4e26\u7531 DataBase Server \u5168\u6b0a\u8655\u7406\u3002\u6240\u4ee5Client\/Server \u662f\u4e00\u7a2e\u5206\u5de5\u7684\u6a21\u5f0f\uff0c\u7531 Client \u4f86\u63d0\u51fa\u7533\u8acb\uff0c\u7531Server\u4f86\u5b8c\u6210\u8cc7\u6599\u5b58\u53d6\u7684\u76ee\u7684\uff0c\u5982\u6b64\u5373\u53ef\u4ee5\u5c07\u8cc7\u6599\u5b89\u5168\u96c6\u4e2d\u65bc DataBase Server \u4e0a\uff0c\u4e0d\u5fc5\u50cf DBF \u5206\u6563\u5230 PC \u4e0a\u5b58\u53d6\uff0c\u5bb9\u6613\u4e82\u6389\u8207\u640d\u6bc0\uff08\u5c24\u5176\u662f Index \u6a94\u6848\uff09\uff0c\u8cc7\u6599\u7684\u7a69\u5b9a\u5ea6\u76f8\u5c0d\u63d0\u9ad8\uff0c\u8655\u7406\u5927\u91cf\u8cc7\u6599\u7684\u901f\u5ea6\u4e5f\u76f8\u5c0d\u63d0\u5347\uff08DBF \u8cc7\u6599\u4e00\u5927\uff0c\u901f\u5ea6\u5c31\u662f\u6162\uff09\uff0cC\/S \u67b6\u69cb\u78ba\u5be6\u63d0\u5347\u4e0d\u5c11\u901f\u5ea6\u8207\u54c1\u8cea\u3002<\/p>\n

4.Application Server \u7684 Three-Tier<\/span>
\u3000\u3000\u5176\u5be6 2-TIER \u5df2\u7d93\u89e3\u6c7a\u4e86\u4e0d\u5c11\u8cc7\u6599\u5eab\u7684\u554f\u984c\uff0c\u4f46\u9762\u81e8\u5927\u578b\u7cfb\u7d71\uff0cC\/S\u6703\u56e0\u70baConnection\u6578\u91cf\uff08\u4f7f\u7528\u8005\u7684\u806f\u6a5f\u6578\uff09\u7684\u66b4\u589e\u800c\u9020\u6210Database Server\u7121\u6cd5\u8ca0\u8377\uff0c\u901a\u5e38\u4e00\u500b Application Connection \u53ea\u8981\u5230\u9054 30 \u5230 50 \u500b User \u5c31\u6703\u9020\u6210 DB Server \u75b2\u65bc\u5954\u547d\uff0c\u901f\u5ea6\u8207\u6548\u80fd\u5c07\u6709\u986f\u8457\u7684\u6539\u8b8a\uff1b\u53e6\u4e00\u500b\u554f\u984c\u5c31\u662f\u7576\u8cc7\u6599\u5eab\u7684\u8cc7\u6599\u5f88\u5927\u6642\uff0cClient\/Server \u901a\u5e38\u6703\u4f9d SQL \u547d\u4ee4\u5c07\u5927\u91cf\u6578\u64da\u50b3\u56de Client\uff0c\u5f80\u5f80\u9020\u6210\u7db2\u8def\u8207 Server \u7684\u74f6\u9838\uff1b\u518d\u8005\u5c31\u662f\u7dad\u8b77\u7684\u554f\u984c\uff0c\u5927\u578b\u7684\u7cfb\u7d71\u6709\u5f88\u591a\u5f88\u5927\u7684 Client \u7a0b\u5f0f\uff0c\u5206\u6563\u5230\u5404\u500b Client \u4e0a\uff0c\u6bcf\u7576\u6709\u7a0b\u5f0f\u7248\u672c\u7570\u52d5\u6642\uff0c\u90fd\u5fc5\u9808\u5927\u8cbb\u5468\u7ae0\u7684\u5c07Client \u7a0b\u5f0f\u63db\u6389\uff0c\u518d\u52a0\u4e0a\u76ee\u524d\u6574\u500b A\/P \u7684\u5168\u7403\u767c\u5c55\u8da8\u52e2\u5c31\u662f Thin-Client\uff08\u7626\u5c0f\u7684 Client\uff09\uff0c\u4e26\u8b93 Client \u80fd\u81ea\u52d5\u7dad\u8b77\u6216\u4e0d\u5fc5\u7dad\u8b77\u7684\u6548\u679c\uff0c3-Tier \u7684\u67b6\u69cb\u8207\u76f8\u95dc\u6280\u8853\u4e5f\u5c31\u56e0\u904b\u800c\u751f\u4e86\u3002<\/p>\n

<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

http:\/\/www.microsoft.com\/taiwan\/msdn\/columns\/200303neta … \u95b1\u8b80\u5168\u6587 3\u5c64\u5f0f\u67b6\u69cb(3-tier)<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[29],"tags":[],"class_list":["post-1469","post","type-post","status-publish","format-standard","hentry","category-29","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/1469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=1469"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/1469\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=1469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=1469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=1469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}