{"id":1457,"date":"2013-07-25T23:14:23","date_gmt":"2013-07-25T15:14:23","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1457"},"modified":"2013-08-02T14:22:25","modified_gmt":"2013-08-02T06:22:25","slug":"20130725-%e4%b8%8a%e6%b5%b7oow%e7%ac%ac%e5%9b%9b%e6%97%a5","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1457","title":{"rendered":"20130725 \u4e0a\u6d77OOW\u7b2c\u56db\u65e5"},"content":{"rendered":"<p>\u4eca\u5929\u7ec8\u4e8e\u6709\u7a7a\u542c\u4e86\u4e00\u4e0b\u6280\u672f\u4e3b\u9898\u3002<br \/>\n\u5c55\u53f0\u7684\u5956\u54c1\u5df2\u7ecf\u57fa\u672c\u4e0a\u53d1\u5b8c\u4e86\uff0c\u800c\u4e14\u4eca\u5929\u662f\u6700\u540e\u4e00\u5929\uff0c\u4eba\u76f8\u5bf9\u5c11\u4e00\u4e9b\uff0c\u56e0\u6b64\u4e0a\u5348\u62bd\u51fa\u4e00\u4e9b\u65f6\u95f4\u53bb\u542c\u4e86\u4e00\u4e2a\u6280\u672f\u7684\u4e13\u9898\u3002<br \/>\n\u8fd9\u4e2a\u4e3b\u9898\u4e3b\u8981\u4ecb\u7ecd\u4e8612c\u6027\u80fd\u65b9\u9762\u7684\u7279\u6027\u3002\u5f00\u7bc7Oracle\u5148\u4ecb\u7ecd\u4e86\u5728\u5404\u4e2a\u573a\u666f\u4e0bTPCC\u7684\u8bb0\u5f55\u90fd\u662fOracle\u4fdd\u6301\u7684\uff0c\u5e76\u5c55\u793a\u4e86\u90a3\u5f20\u5f15\u6765\u65e0\u6570\u5173\u6ce8\u7684TPMC\u6d4b\u8bd5\u7ed3\u679c\uff1aSUN\u5e73\u53f0\u6027\u80fd\u8d85\u8fc7HP\u5e73\u53f0\u76847\u500d\u3002<br \/>\n\u4e3b\u9898\u4e2d\u7684\u53e6\u4e00\u4e2a\u4eae\u70b9\u662f\u4ecb\u7ecd\u4e86Oracle\u81ea\u5df1\u7528\u6765\u627f\u8f7d\u90ae\u4ef6\u3001\u65e5\u5386\u3001\u8054\u7cfb\u4eba\u3001\u804a\u5929\u3001\u6587\u6863\u4ee5\u53ca\u7f51\u7edc\u4f1a\u8bae\u7684Oracle\u96c6\u7fa4\uff0c\u75319\u53f0X2-2\u7ec4\u6210\uff0c\u4e00\u51712376\u6838\uff0c2PB\u6570\u636e\u91cf\uff0c7T\u5185\u5c42\u548c48T\u95ea\u5b58\u3002\u8fd9\u4e2a\u5e94\u8be5\u662f\u5b9e\u9645\u4e0a\u6700\u5927\u7684Oracle\u96c6\u7fa4\u90e8\u7f72\u5728\u5965\u65af\u6c40\uff0c\u901a\u8fc7DG\u6280\u672f\u5c06\u5907\u7528\u73af\u5883\u90e8\u7f72\u5728\u72b9\u4ed6\u6570\u636e\u4e2d\u5fc3\u3002\u8fd9\u4e2a\u73af\u5883\u4e2d\u5145\u5206\u5229\u7528\u4e86Oracle\u5404\u79cd\u8f6f\u4ef6\u529f\u80fd\uff1aRAC\u3001Streams\u3001Active Data Guard\u3001Secure Backup\u3001RMAN\u3001Flashback Database\u3001ASM\u3001Partition\u7b49\u3002\u6570\u636e\u5e93\u5229\u7528SecureFiles\u7684\u538b\u7f29\u529f\u80fd\u8282\u7701\u4e862\u500d\u7684\u7a7a\u95f4\u3002<br \/>\n\u6700\u540e\u7ec8\u4e8e\u4ecb\u7ecd\u4e8612c\u4e2d\u4e00\u4e9b\u4e0e\u6027\u80fd\u6709\u5173\u7684\u7279\u6027\uff1a\u5185\u5b58\u4e2d\u5e76\u884c\u6267\u884c\u3001\u81ea\u9002\u5e94\u6267\u884c\u8ba1\u5212\u3001\u901a\u8fc7WITH\u5c06PL\/SQL\u5185\u5d4c\u5230SQL\u4e2d\u3001\u5185\u5b58\u4e2d\u7684\u5168\u5c40\u4e34\u65f6\u8868\u3001\u5185\u5b58\u4e2d\u7684LOB\u67e5\u8be2\u548c\u66f4\u65b0\u3001\u5e76\u884c\u52a0\u8f7d\u548c\u79fb\u52a8LOB\u3001\u57fa\u4e8e\u5185\u5b58\u961f\u5217\u7684\u5feb\u901f\u5ba1\u8ba1\u3001\u81ea\u52a8\u6570\u636e\u4f18\u5316\u3001\u9ad8\u7ea7\u538b\u7f29\u7b49\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u5929\u7ec8\u4e8e\u6709\u7a7a\u542c\u4e86\u4e00\u4e0b\u6280\u672f\u4e3b\u9898\u3002 \u5c55\u53f0\u7684\u5956\u54c1\u5df2\u7ecf\u57fa\u672c\u4e0a\u53d1\u5b8c\u4e86\uff0c\u800c\u4e14\u4eca\u5929\u662f\u6700\u540e\u4e00\u5929\uff0c\u4eba\u76f8\u5bf9\u5c11\u4e00\u4e9b\uff0c\u56e0\u6b64\u4e0a\u5348\u62bd\u51fa\u4e00\u4e9b\u65f6\u95f4\u53bb\u542c\u4e86\u4e00\u4e2a\u6280\u672f\u7684\u4e13\u9898\u3002 \u8fd9\u4e2a\u4e3b\u9898\u4e3b\u8981\u4ecb\u7ecd\u4e8612c\u6027\u80fd\u65b9\u9762\u7684\u7279\u6027\u3002\u5f00\u7bc7Oracle\u5148\u4ecb\u7ecd\u4e86\u5728\u5404\u4e2a\u573a\u666f\u4e0bTPCC\u7684\u8bb0\u5f55\u90fd\u662fOracle\u4fdd\u6301\u7684\uff0c\u5e76\u5c55\u793a\u4e86\u90a3\u5f20\u5f15\u6765\u65e0\u6570\u5173\u6ce8\u7684TPMC\u6d4b\u8bd5\u7ed3\u679c\uff1aSUN\u5e73\u53f0\u6027\u80fd\u8d85\u8fc7HP\u5e73\u53f0\u76847\u500d\u3002 \u4e3b\u9898\u4e2d\u7684\u53e6\u4e00\u4e2a\u4eae\u70b9\u662f\u4ecb\u7ecd\u4e86Oracle\u81ea\u5df1\u7528\u6765\u627f\u8f7d\u90ae\u4ef6\u3001\u65e5\u5386\u3001\u8054\u7cfb\u4eba\u3001\u804a\u5929\u3001\u6587\u6863\u4ee5\u53ca\u7f51\u7edc\u4f1a\u8bae\u7684Oracle\u96c6\u7fa4\uff0c\u75319\u53f0X2-2\u7ec4\u6210\uff0c\u4e00\u51712376\u6838\uff0c2PB\u6570\u636e\u91cf\uff0c7T\u5185\u5c42\u548c48T\u95ea\u5b58\u3002\u8fd9\u4e2a\u5e94\u8be5\u662f\u5b9e\u9645\u4e0a\u6700\u5927\u7684Oracle\u96c6\u7fa4\u90e8\u7f72\u5728\u5965\u65af\u6c40\uff0c\u901a\u8fc7DG\u6280\u672f\u5c06\u5907\u7528\u73af\u5883\u90e8\u7f72\u5728\u72b9\u4ed6\u6570\u636e\u4e2d\u5fc3\u3002\u8fd9\u4e2a\u73af\u5883\u4e2d\u5145\u5206\u5229\u7528\u4e86Oracle\u5404\u79cd\u8f6f\u4ef6\u529f\u80fd\uff1aRAC\u3001Streams\u3001Active Data Guard\u3001Secure Backup\u3001RMAN\u3001Flashback Database\u3001ASM\u3001Partition\u7b49\u3002\u6570\u636e\u5e93\u5229\u7528SecureFiles\u7684\u538b\u7f29\u529f\u80fd\u8282\u7701\u4e862\u500d\u7684\u7a7a\u95f4\u3002 \u6700\u540e\u7ec8\u4e8e\u4ecb\u7ecd\u4e8612c\u4e2d\u4e00\u4e9b\u4e0e\u6027\u80fd\u6709\u5173\u7684\u7279\u6027\uff1a\u5185\u5b58\u4e2d\u5e76\u884c\u6267\u884c\u3001\u81ea\u9002\u5e94\u6267\u884c\u8ba1\u5212\u3001\u901a\u8fc7WITH\u5c06PL\/SQL\u5185\u5d4c\u5230SQL\u4e2d\u3001\u5185\u5b58\u4e2d\u7684\u5168\u5c40\u4e34\u65f6\u8868\u3001\u5185\u5b58\u4e2d\u7684LOB\u67e5\u8be2\u548c\u66f4\u65b0\u3001\u5e76\u884c\u52a0\u8f7d\u548c\u79fb\u52a8LOB\u3001\u57fa\u4e8e\u5185\u5b58\u961f\u5217\u7684\u5feb\u901f\u5ba1\u8ba1\u3001\u81ea\u52a8\u6570\u636e\u4f18\u5316\u3001\u9ad8\u7ea7\u538b\u7f29\u7b49\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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":""},"categories":[1],"tags":[1088,1090,1263],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-nv","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1457"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1457"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1457\/revisions"}],"predecessor-version":[{"id":1459,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1457\/revisions\/1459"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}