DB2 Viper's hybrid XML / relational data server in practice is how to work? This personal experience with you the actual performance of DB2 Viper and handling, so that you know the actual DB2 Viper test which aspects should be focused on.
IBM is the data server to the next stage of development: introduced to manage relations between pure and pure XML data in a single hybrid engine. DB2 Viper the new technology used for many companies to understand the relationship between non-business data, such as Excel spreadsheets inside financial information, or commonly found in paper or word processing document, an important contract. Using DB2 Viper, a join statement can only be the rich business data combined with traditional relational data in full view. For electronic forms, contracts, fax image, or receipt of manual search can be a simple statement to be replaced. Access this XML data standard mechanism to ensure that: the existing reporting tools and interfaces to these new data can be provided directly to the desktop. Pure XML technology is critical for business success agility.
New hybrid XML / relational functioning, not for Linux, Unix and Windows, DB2 Viper is the only new features are. This article will discuss the main features of DB2 Viper has. Readers can open by Viper test procedures (http://www-306.ibm.com/software/data/db2/9/), personally try some of these features.
XML-driven business
In addition to relational data can be stored outside, DB2 Viper hybrid engine can also use plain XML structure to store the XML document. Thus, the increasing recourse to XML, companies can use high-performance XML storage engine, you can also use the existing employee database skills to manage and protect XML data (see Figure 1).
XML on the importance of today's companies, which for many reasons. In service-oriented architecture (SOA) environment, if you use a separate universal service, you do not need for each application developed their own access methods, and contribute to integrated applications. XML is often between applications and common services, contact the language used in messaging. For example, in stock, the customer through the Web interface to buy a share of stock. The Web process XML messages to send to the broker system, said to perform transactions. The XML message is temporary, only to trigger agent systems exist. DB2 Viper can save this XML message, while allowing digital signatures remain the same. Thus, these XML messages are now available for regulatory compliance audits.
Today, most companies can not easily access existing business data, because the use of database technology, the large number of platforms and data formats. By creating a unified data format, SOA common services can access data from the original data source, the data Ge Shihua into the standard format and stored in XML, thus contributing to flexible, standards of access to critical business data.
Able to store critical business-type documents (such as Excel spreadsheets, or legal contracts), and the relationship between the data and related data link, which is one of the main advantages Viper. Microsoft Office, Adobe programs and products provide the majority of prospects will be stored as XML document formats. Enterprise users can now easily access the electronic form data, because the Microsoft Excel spreadsheet (often used to store important financial decision-making statistical data) as the XML format can now be stored in the DB2 Viper data server which, not stored in easily damaged file server or hard top.
Pure XML
Existing relational data server XML document stored as a character or binary large object (CLOB or BLOB). But in the CLOB or BLOB, the data is stored as a single unit or a continuous string of bytes. If the query a value inside XML documents, or just update the XML document as part of the performance of this storage format will bring problems. Analysis of the entire record must be read and then can be evaluate predicate (predicate evaluation). Indexing can reduce search costs; However, XML documents need to update the index on the XML update. In addition, the updated XML document need to rewrite the entire document.
Decomposition of the XML document is the relational database management system (RDBMS) another storage method. By mapping each element of XML document to the relevant Series, XML documents can be stored in multiple tables and columns. Once the document is decomposed, structure, and any related items (such as digital signatures) will be lost; However, if the entire XML document need not retained, decomposition may be a practical solution.
DB2 Viper灏嗘渶绾补褰㈠紡鐨刋ML淇濆瓨涓虹粡杩囬鍏堣В鏋愮殑甯︽敞瑙ｇ殑鏍戙?濡備粖甯傞潰涓婂凡鏈夌函XML鏁版嵁搴擄紝浣嗕笉鏄贩鍚堝瀷鏁版嵁搴擄紙杩欐剰鍛崇潃瀹冧滑娌℃湁鍚屾椂瀛樺偍XML鏁版嵁鍜屽叧绯绘暟鎹殑浼樼偣锛夈?鏈変簡DB2 Viper锛孹ML灏卞彲浠ュ瓨鍌ㄤ负鍩轰簬鑺傜偣鐨勫眰娆℃ā鍨嬨?鍦ㄨ繖绉嶆ā鍨嬩腑锛屾瘡涓妭鐐逛笉浣嗕笌鍏剁埗鑺傜偣鐩歌繛鎺ワ紝杩樹笌鍏跺瓙鑺傜偣鐩歌繛鎺ャ?杩欑绾疿ML瀛樺偍鏄闂強瀛樺偍鏁翠釜XML鏂囨。鐨勬渶鏈夋晥鏂规硶锛屾彁渚涗簡鏋佸ぇ鐨勬?鑳戒紭鍔裤?
绾疿ML瀛樺偍鍙互鍘熷皝涓嶅姩鍦板瓨鍌╔ML鏂囨。锛屼粠鑰屾彁渚涗簡BLOB鍜孋LOB鐨勪紭鐐癸紝杩樿В鍐充簡鎬ц兘闂锛屽洜涓烘枃妗ｅ瓨鍌ㄦ病鏈夎铏氭嫙鍖栨垚鍗曚竴銆佽繛缁殑瀛楄妭鑼冨洿銆傛暣缁勬枃妗ｇ殑瀛樺偍琚櫄鎷熷寲鎴愯繛缁殑瀛楄妭鑼冨洿锛屼絾鍚勪釜鑺傜偣鍙互瀹夌疆鍒拌繖涓寖鍥翠腑锛屽鍏朵粬鑺傜偣鍜岀储寮曠殑褰卞搷鏋佸皬銆?br />
DB2 Viper鏃㈡敮鎸佸垎瑙ｇ殑XML锛屽張鏀寔绾疿ML銆傛敮鎸佸垎瑙ｅ姛鑳藉緢閲嶈锛屽洜涓篨ML鍙敤鏉ユ彁渚涚幇鏈夌殑鍏崇郴妯″紡銆傚洜涓烘枃妗ｄ細鍙樺ぇ锛屽湪璁稿鎯呭喌涓嬭繕鍙互鏇存柊锛屾墍浠ML鏂囨。鐨勯潪BLOB瀛樺偍锛堝寘鎷湪鑺傜偣灞傞潰鑰屼笉鏄湪鏂囨。灞傞潰杩涜瀛樺偍锛夊叿鏈夌殑浼樺娍寰堟樉钁椼?
澶у鏁板叕鍙稿唴閮ㄥ凡缁忔湁鍏崇郴鏁版嵁鏈嶅姟鍣紝鑰屼笖鏈夎礋璐ｆ敮鎸佺殑鍛樺伐銆傝櫧鐒禫iper浠ｈ〃鐫?柊棰栥?鍏堣繘鐨刋ML鎶?湳锛屼絾骞朵笉瑕佹眰鍏徃闆囩敤鏂扮殑绮鹃?XML鐨勫紑鍙戜汉鍛樸?涓轰簡鍒涘缓DB2娣峰悎琛紙璇ヨ〃鍚屾椂鍚湁鍏崇郴鏁版嵁鍜孹ML鏁版嵁锛夛紝鍙渶瑕佷竴涓畝鍗曠殑CREATE TABLE璇彞鍙婃柊鐨刋ML鏁版嵁绫诲瀷锛?br />
create table clients(
銆?d int primary key not null,
銆?ame varchar(50),
銆?tatus varchar(10),
銆?ontactinfo xml
)
涓轰簡璁块棶娣峰悎琛紝IBM鏀寔 SQL鍩轰簬琛屼笟鏍囧噯鐨勬墿灞曪細SQL/XML銆傝繖浜涙墿灞曞彲浠ヤ娇鐢ㄧ畝鍗曠殑SELECT璇彞鏉ユ绱?XML鏂囨。鎴栬?XML鏂囨。鐨勪竴閮ㄥ垎銆傞櫎浜哠QL/XML澶栵紝DB2杩樻敮鎸佹柊鐨刋ML Query锛堝嵆XQuery锛夎瑷??XQuery鏄敱涓囩淮缃戣仈鐩燂紙W3C锛夋帹鍔ㄧ殑涓?」鏍囧噯锛屾棬鍦ㄥ彲浠ユ煡璇ML鐨勫眰娆″寲缁撴瀯锛屾濡係QL鏃ㄥ湪鍙互鏌ヨ琛ㄦ牸鏁版嵁缁撴瀯閭ｆ牱銆俋Query涓嶅悓浜嶴QL鐨勪竴涓湴鏂瑰氨鍦ㄤ簬锛屽畠鑳藉鎻愪緵璺緞琛ㄨ揪寮忥紝浠庤?浣跨▼搴忓憳鑳藉杞绘澗娴忚XML鐨勫眰娆″寲缁撴瀯銆備互涓嬬ず渚嬪氨鏄繑鍥炲鎴疯仈绯讳汉鏁版嵁鐨勭畝鍗昘Query锛?br />
xquery db2-fn:xmlcolumn(''CLIENTS.CONTACTINFO'')
鍋囪甯屾湜妫?储鎵?湁瀹㈡埛鐨勪紶鐪熷彿鐮併?浠ヤ笅鏄彲浠ョ紪鍐欐煡璇㈢殑涓?釜鏂规硶锛?br />
xquery
for $y in db2-fn:xmlcolumn
(''CLIENTS.CONTACTINFO'')/Client/fax
return $y
绗竴琛屾寚浠B2璋冪敤鍏禭Query瑙ｆ瀽鍣ㄣ?涓嬩竴琛屾寚浠?DB2閬嶅巻CLIENTS.CONTACTINFO鍒椾腑 Client鍏冪礌鐨刦ax瀛愬厓绱犮?姣忎釜fax鍏冪礌杩涜?琚粦瀹氬埌鍙橀噺$y銆傜涓夎琛ㄦ槑锛氭瘡娆¤凯浠ｈ繑鍥?y鐨勫?銆傜粨鏋滃氨鏄笅闈㈢殑XML鍏冪礌搴忓垪锛?br />
< fax>4081112222< /fax>
< fax>5559998888< /fax>
DB2鏀寔 XQuery锛岃繖鎰忓懗鐫?畠鏍规湰涓嶅繀鎶奨Query杞崲涓篠QL锛堣浆鎹細甯︽潵涓嶅繀瑕佺殑寮?攢锛屽苟涓旈?鎴愯涔変笉涓?嚧锛夈?瀹冧篃涓嶉渶瑕佸鎴峰皢XQuery璇彞灏佽鍦⊿QL璇彞閲岄潰銆傜浉鍙嶏紝DB2瀹㈡埛鍙互鍦ㄩ渶瑕佹椂鍏呭垎鍒╃敤XQuery鍜孲QL锛涚敋鑷冲彲鏈涘埄鐢ㄢ?鍙岃鈥濇煡璇紝浠庤?鍒╃敤姣忕璇█鍏锋湁鐨勭嫭鐗瑰姛鑳姐?鏂扮殑銆佸厛杩涚殑XML绱㈠紩鎶?湳琛ュ厖浜哣iper瀵筍QL/XML鍜孹Query鐨勬敮鎸侊紝鑳藉鎻愪緵鑹ソ鐨勮繍琛屾?鑳姐?
搴旂敤绋嬪簭鏀寔
DB2 Viper绠?寲浜嗗湪鑷繁寮?彂鎴栬?濂楄鐨勫簲鐢ㄧ▼搴忎腑瀹炵幇DB2銆傛柊璁捐鐨勫紑鍙戝伐浣滃彴锛圖eveloper Workbench锛夊熀浜嶦clipse骞冲彴锛岃兘澶熷悓鍩轰簬Eclipse鐨勫伐鍏峰Rational Application Developer瀹炵幇鍏煎銆傚紑鍙戝伐浣滃彴銆佹敮鎸佺殑鎵?湁寮?彂鐣岄潰鍜孉PI浠ュ強鏂板伐鍏凤紙濡俋Query鏋勫缓鍣級閮藉寘鎷簡鏀寔鏂扮殑XML鎶?湳杩欎竴鍔熻兘銆傛槗浜庝娇鐢ㄧ殑XQuery鏋勫缓鍣ㄦ彁渚涗簡璇硶褰╄壊鏄剧ず銆佷唬鐮佽嚜鍔ㄥ畬鎴愶紝浠ュ強鍔犲揩鍒涘缓XQuery鍜?XML鏂囨。鐨勫叾浠栬澶氬疄鐢ㄧ▼搴忋?
涓轰簡瑙ｅ喅鏁版嵁璐ㄩ噺闂锛孌B2 Viper鍏佽鍦ㄦ湰鍦癉B2瀛樺偍搴撲腑鍒涘缓鍙婃敞鍐孹ML妯″紡锛堣繖鏄彲閫夋搷浣滐級銆傜劧鍚庯紝搴旂敤绋嬪簭璇曞浘灏嗘枃妗ｆ彃鍏ユ垨鑰呭鍏ヨ〃涓椂锛孌B2灏卞彲浠ュ鐓ц繖浜涙ā寮忔潵楠岃瘉XML鏁版嵁銆備负浜嗚幏寰楁渶澶х殑鐏垫椿鎬э紝DB2鍏佽鍦ㄨ〃鐨勫悓涓?垪涓瓨鍌ㄤ笌涓嶅悓 XML妯″紡鐩稿叧鐨刋ML鏂囨。銆傝繖鏍蜂竴鏉ュ彲浠ユ敮鎸佹ā寮忔紨鍖栵紝骞朵笖浣緿B2鑳藉婊¤冻涓嶆柇鍙樺寲鐨勪笟鍔￠渶姹傦紝鍙堢敤涓嶇潃鐮村潖鐜版湁鐨勫簲鐢ㄧ▼搴忥紝鎴栬?琚揩瀵规暟鎹簱妯″紡杩涜鎴愭湰楂樻槀鐨勪慨鏀广?
闄や簡XML鏂归潰鐨勬敼杩涘锛孌B2 Viper杩樺.NET鐜鍋氫簡鏇存繁鍏ョ殑鍒嗘瀽銆侱B2鏂扮殑.NET鏁版嵁鎻愪緵绋嬪簭鏈夊姪浜庡.NET Framework 2.0绫诲簱杩涜璁块棶銆傚畠杩樺彲浠ラ?杩囩紪绋嬩汉鍛橀?鎷╃殑璇█缂栧啓鑰屾垚鐨勫瓨鍌ㄨ繃绋嬫潵鎵╁睍 DB2鏁版嵁婧愯闂姛鑳斤紝杩欎簺璇█鍖呮嫭涓庨?鐢ㄨ瑷?繍琛屾椂锛圕LR锛夊吋瀹圭殑浠讳綍璇█锛堝C#鎴栬?Visual Basic .NET锛夈?DB2 Viper杩樺紩鍏ヤ簡鏀寔 Visual Studio 2005鐨勫寮哄瀷鏁版嵁搴撴彃浠躲?杩欎簺鐗规?鍙互鍏卞悓甯姪寮?彂浜哄憳缂╃煭涓篋B2鏈嶅姟鍣ㄧ郴鍒楀紑鍙?Net搴旂敤绋嬪簭鐨勬椂闂淬?
鑷垜绠＄悊鍐呭瓨
瀵硅礋璐ｇ‘淇濆簲鐢ㄧ▼搴忓拰鏁版嵁搴撴?鑳藉強鍙敤鎬х殑鏁版嵁搴撶鐞嗗憳锛圖BA锛夎?瑷?紝浠栦滑寰堥毦鎶藉嚭鏃堕棿鍘荤爺绌?XML鍜孲OA杩欎簺鏂版妧鏈?杩戞湡鐨勬瘡涓狣B2鐗堟湰閮芥坊鍔犱簡鍙缉鐭鐞嗘暟鎹簱鎵?渶鏃堕棿鐨勭壒鎬э紝浠庤?鎻愰珮浜咲BA鐨勫伐浣滄晥鐜囥?
鍥? 鏃㈣兘绠＄悊鍏崇郴瀛樺偍鍙堣兘绠＄悊绾疿ML瀛樺偍鐨凞B2娣峰悎鍨嬫暟鎹湇鍔″櫒
DB2 Viper閲囩敤浜嗘柊鐨勫唴瀛樿皟鏁寸壒鎬э紝瀹冨彲浠ヨ嚜鍔ㄨ缃唴瀛橀厤缃弬鏁板拰缂撳啿姹犲ぇ灏忕殑鍊笺?涓?棪琚惎鐢紝鍐呭瓨璋冩暣鍣ㄥ氨浼氬湪鍑犱釜鍐呭瓨浣跨敤鑰呬箣闂村姩鎬佸垎閰嶅彲鐢ㄥ唴瀛樿祫婧愶紝鍐呭瓨浣跨敤鑰呭寘鎷帓搴忋?鍖呯紦瀛樸?閿佸垪琛ㄥ尯鍩熷拰缂撳啿姹犮?鍦╓indows鍜孉IX骞冲彴涓婏紝鑷垜璋冩暣鍐呭瓨鐗规?杩樺彲浠ョ‘瀹氭?鐨勬暟鎹簱鍐呭瓨闇?眰锛屽苟鍔ㄦ?璋冩暣鏁版嵁搴撳叡浜殑鍐呭瓨銆傝繖椤圭壒鎬цDB2鍦ㄥ伐浣滆礋杞介渶瑕佹椂鍙互浣跨敤鏇村鐨勭墿鐞嗗唴瀛橈紱鏁版嵁搴撳唴瀛橀渶姹傚緢浣庢椂锛屽彲浠ュ皢鍐呭瓨閲婃斁缁欐搷浣滅郴缁熴?
闄や簡绠?寲鍐呭瓨閰嶇疆澶栵紝杩欓」鏂伴銆佽嚜閫傚簲銆佽嚜鎴戣皟鏁寸殑鐗规?杩樺彲浠ラ?杩囨彁渚涙渶浣抽厤缃?鈥旇繖绉嶉厤缃叿鏈夊姩鎬佹?锛岃繕鍙互搴斿宸ヤ綔璐熻浇鐨勭壒鐐瑰嚭鐜扮殑閲嶅ぇ鍙樺寲锛屼粠鑰屾彁楂樻?鑳姐?
鑼冨洿鍒嗗尯
闈㈠悜Linux銆乁nix鍜學indows鐨凞B2寮曞叆浜嗕竴椤规柊鐨勫垎鍖烘妧鏈紝鍙互鎻愰珮鏁版嵁浠撳簱鐨勬?鑳斤紝骞剁缉鐭鐞嗘椂闂淬?鏂扮殑琛ㄥ垎鍖烘柟娉曢?甯哥О涓鸿寖鍥村垎鍖猴紙range partitioning锛夛紝鍙互涓烘瘡涓垎鍖哄畾涔夋暟鎹寖鍥达紝骞舵牴鎹暟鎹寖鍥村皢鏁版嵁瀛樺偍涓虹嫭绔嬪璞°?璀璇达紝鍙互鏍规嵁琛ㄤ腑鐨勬棩鏈熷垪锛屾寜鐓у勾鍜屾湀瀵硅〃杩涜鍒嗗尯銆傝繖浜涘瓨鍌ㄥ璞″彲浠ヤ綅浜庝笉鍚岀殑琛ㄧ┖闂淬?鍚屼竴琛ㄧ┖闂达紝鎴栬?涓ょ鎯呭喌鐨勭粍鍚堬紙瑙佸浘2锛夈?
涓嶈灏嗚繖绉嶅垎鍖烘妧鏈笌鏁版嵁搴撳垎鍖哄姛鑳斤紙DPF锛夌浉娣锋穯锛孌PF 鍏佽鏍规嵁鍒嗗竷閿拰鏁ｅ垪鍑芥暟璺ㄥ涓暟鎹簱鍒嗗尯瀵规暟鎹繘琛屽垎甯冿紝寰?線鐢ㄤ簬鎻愰珮鍙墿灞曟?锛屼粠鑰屾敮鎸侀潪甯稿ぇ鐨勬暟鎹簱銆?br />
琛ㄥ垎鍖鸿瀛樺偍瀵硅薄鐨勮涓哄氨鍍忓崟涓殑琛ㄩ偅鏍凤紝閫氳繃浣跨敤ALTER TABLE...ATTACH璇彞灏嗙幇鏈夌殑琛ㄤ笌鍒嗗尯鐨勮〃杩涜鍚堝苟锛屼粠鑰岃交鏉惧疄鐜板揩閫熻浆鍏ワ紙roll-in锛夈?鍚屾牱锛岀敤ALTER TABLE...DETACH 璇彞寰堝鏄撳疄鐜拌浆鍑猴紙roll-out锛夈?鏌ヨ澶勭悊鍙互鍒╃敤鍒嗛殧鏉ラ伩鍏嶆壂鎻忔棤鍏崇殑鏁版嵁锛屼粠鑰屼负璁稿鏁版嵁浠撳簱椋庢牸鐨勬煡璇㈡彁渚涙洿濂界殑鏌ヨ鎬ц兘銆?br />
琛ㄥ垎鍖哄線寰?敤鏉ュ瓨鍌ㄤ緵鍒嗘瀽鐨勫巻鍙叉暟鎹?璀璇达紝鍏稿瀷鐨勪繚闄╂暟鎹粨搴撳彲鑳戒繚瀛樹簡涓夊勾鐨勭储璧旀暟鎹?灏嗘瘡涓湀鐨勬暟鎹浇鍏ヤ粨搴撳悗锛屾渶鏃╅偅涓湀鐨勬暟鎹氨琚瓨妗ｏ紝骞朵粠娲诲姩琛ㄤ腑鍒犻櫎銆傛柊鐨勮浆鍏ュ拰杞嚭鐗规?鏈夊姪浜庤繖绉嶆暟鎹Щ鍔紝浠庤?缂╃煭浜嗙鐞嗘椂闂淬?鍙壂鎻忛?鐢ㄥ垎鍖轰腑鐨勬暟鎹彲浠ュ姞蹇煡璇㈤?搴︼紝浠庤?鎻愰珮鎬ц兘銆傝寖鍥村湪CREATE TABLE璇彞鐨凱ARTITION BY瀛愬彞涓姞浠ユ寚瀹氥?杩欎釜瀹氫箟浣跨敤鐨勫垪琚О涓鸿〃鍒嗗尯閿垪銆?br />
琛ㄥ垎鍖哄彲浠ュ崟鐙娇鐢紝涔熷彲浠ョ粨鍚堝叾浠栫粍缁囨柟妗堜娇鐢ㄣ?CREATE TABLE璇彞鐨勬瘡涓瓙鍙ラ兘鍚湁绠楁硶鏉ヨ〃鏄庡簲濡備綍缁勭粐鏁版嵁銆備互涓嬩笁涓瓙鍙ヨ〃鏄庝簡鏁版嵁缁勭粐绾у埆锛岃繖浜涚骇鍒彲浠ヤ互浠讳綍缁勫悎褰㈠紡鏉ヤ娇鐢細
鈼?DISTRIBUTE BY璺ㄦ暟鎹簱鍒嗗尯鍧囧寑鍦板垎甯冩暟鎹?浣跨敤杩欎釜瀛愬彞鍙疄鐜版煡璇㈤棿骞惰鏈哄埗锛屽苟涓旇法姣忎釜鏁版嵁搴撳垎鍖鸿繘琛岃礋杞藉钩琛°?杩欎釜姒傚康绉颁负鏁版嵁搴撳垎鍖猴紝寰楀埌浜咲PF鐨勬敮鎸併?
鈼?PARTITION BY鎶婁竴涓淮涓叿鏈夌浉浼煎?鐨勮鍒嗙粍鍦ㄥ悓涓?暟鎹垎鍖轰腑銆傝繖涓蹇电О涓鸿〃鍒嗗尯銆?br />
鈼?ORGANIZE BY 鎶婂涓淮涓叿鏈夌浉浼煎?鐨勮鍒嗙粍鍦ㄥ悓涓?〃鍖洪棿涓?杩欎釜姒傚康绉颁负澶氱淮缇ら泦锛圡DC锛夈?
杩欎釜璇硶鎻愪緵浜嗗瓙鍙ヤ箣闂寸殑涓?嚧鎬э紝杩樹负灏嗘潵鐨勬暟鎹粍缁囩畻娉曟彁渚涗簡鏀寔銆傜粨鍚堜娇鐢–REATE TABLE璇彞鐨凞ISTRIBUTE BY鍜孭ARTITION BY瀛愬彞浣挎暟鎹兘澶熻法鏁版嵁搴撳垎鍖猴紙鍒嗗尯鏈韩妯法澶氫釜琛ㄧ┖闂达級杩涜鍒嗗竷銆?br />
DB2 Viper灏嗘槸绗竴涓悓鏃舵敮鎸佹墍鏈変笁绉嶅父瑙佺殑鏁版嵁搴撳垎鍖烘柟娉曠殑鏁版嵁鏈嶅姟鍣ㄢ?鈥旇繖鏄姞寮烘暟鎹鐞嗐?鎻愰珮淇℃伅鍙敤鎬ф柟闈㈢殑閲嶅ぇ鍒涙柊銆?br />
鏁版嵁琛屽帇缂?br />
鏃╂湡鐨勬祴璇曠粨鏋滆〃鏄庯紝DB2 Viper鍘嬬缉鎶?湳鏈?鍙互鑺傜渷80%鐨勫瓨鍌ㄧ┖闂淬?鐢变簬琛岀殑澶у皬鍑忓皬鈥斺?杩欎細灏介噺鍑忓皯I/O鎿嶄綔銆佹彁楂樼紦鍐叉睜鐨勫懡涓巼锛岀墿鐞咺/O鎿嶄綔鐨勬暟閲忓拰缂撳啿姹犻渶姹備篃闅忎箣鍑忓皯銆傛渶缁堢粨鏋滄槸锛岀敤浜庡瓨鍌ㄦ柟闈㈢殑棰勭畻鍑忓皯浜嗭紱鍦ㄦ煇浜涙儏鍐典笅锛岃繕鎻愰珮浜嗘?鑳姐?
DB2 Viper鍘嬬缉瑙ｅ喅鏂规绫讳技闈㈠悜z/OS鐨凞B2鎵?敤鐨勮В鍐虫柟妗堛?鍘嬬缉鏂规硶灏辨槸鎶婃暟鎹閲岄潰鐨勯噸澶嶆暟鎹ā寮忔槧灏勬垚姣旇緝灏忕殑绗﹀彿锛屼粠鑰屽噺灏忚〃鏁版嵁鐨勬?澶у皬銆傝繖绉嶈В鍐虫柟妗堜娇鐢ㄥ熀浜庤瘝鍏哥殑闈欐?鍘嬬缉绠楁硶锛岄?琛岃繘琛屽帇缂┿?涓庨潰鍚憐/OS鐨凞B2涓?牱锛屾墍鐢ㄧ殑鏄疞empel-Ziv鍘嬬缉绠楁硶鐨勪竴绉嶅彉浣撱?
杩欓」鏂扮壒鎬ч櫎浜嗛?鐢ㄤ簬鍙埄鐢ㄤ笂杩版柊鐨勫垎鍖虹壒鎬х殑琛ㄥ锛岃繕閫傜敤浜庣幇鏈夌殑DB2琛ㄣ?
CREATE TABLE鍜孉LTER TABLE璇硶鍖呭惈涓?釜鏂扮殑COMPRESS NO/YES瀛愬彞锛岀敤浜庤缃強鍙栨秷琛ㄧ殑琛屽帇缂╁睘鎬с?璁剧疆COMPRESS YES锛屼箣鍚庢墽琛岀绾跨殑琛≧EORG锛屽氨鍙互瀵硅〃涓墍鏈夌鍚堟潯浠剁殑琛岃繘琛屽帇缂┿?涓?棪璇嶅吀宸茬粡瀛樺湪銆丆OMPRESS YES宸茶璁剧疆濂斤紝鎻掑叆鎴栬?瑁呭叆鍒拌〃涓殑鎵?湁鏂拌灏卞彲浠ヤ娇鐢ㄨ繖涓瘝鍏歌繘琛屽帇缂┿?
鍘嬬缉璇嶅吀鏄?杩囨壂鎻忔暣涓〃锛岀劧鍚庢牴鎹〃鍊煎缓绔嬭?鎴愮殑銆傝繖绉嶆柟娉曟湁鍒簬涓烘瘡涓〉寤虹珛鍘嬬缉璇嶅吀鐨勫叾浠栨暟鎹簱鍘嬬缉鎶?湳銆傞?杩囧湪琛ㄥ眰闈㈣?涓嶆槸鍦ㄩ〉灞傞潰寤虹珛鍘嬬缉璇嶅吀锛屽氨鍙互鍒嗘瀽鏁翠釜琛紝浠庤?璇嗗埆妯″紡锛岃?涓嶆槸灞?檺浜庡垎鏋愬崟涓〉銆?br />
鍩轰簬鏍囩鐨勬帶鍒?br />
鏁版嵁搴撻潰涓寸殑鍐呭濞佽儊鍦ㄤ笌鏃ヤ勘澧炪?鍏徃浼佷笟鍜屾斂搴滅洃绠￠儴闂ㄩ兘鎵胯闇?鍔犲己瀵规暟鎹簱鐨勪繚鎶わ紝骞朵笖瑕佹眰杩欐牱鍋氥?DB2 Viper鍒╃敤鍩轰簬鏍囩鐨勮闂帶鍒讹紙LBAC锛夋潵瑙ｅ喅杩欎簺瀹夊叏闂銆侺BAC鍦ㄥ崟涓鍜屽崟涓垪灞傞潰涓婃彁渚涗簡缁嗗寲鐨勮鍐欒闂帶鍒躲?
鍙皟鏁碙BAC鐨勫姛鑳戒粠鑰屾弧瓒虫瘡瀹跺叕鍙哥壒瀹氱殑瀹夊叏闇?眰銆侷BM寤鸿锛氭墍鏈塋BAC閰嶇疆搴旂敱鍏徃瀹夊叏绠＄悊鍛樻潵鎵ц銆侱B2 Viper鍒涘缓浜嗘柊鐨凞B2瀹夊叏绠＄悊鍛樿鑹诧紙SECADM锛夛紝瀹冨叿鏈夌壒瀹氱殑瀹夊叏鐗规潈銆?br />
瀹夊叏绠＄悊鍛橀?杩囧垱寤哄畨鍏ㄧ瓥鐣ユ潵閰嶇疆LBAC绯荤粺銆傚畨鍏ㄧ瓥鐣ユ弿杩颁簡灏嗙敤鏉ュ喅瀹氳皝鍙互璁块棶鍝簺鏁版嵁鐨勬爣鍑嗐?鍒涘缓浜嗗畨鍏ㄧ瓥鐣ヤ箣鍚庯紝瀹夊叏绠＄悊鍛樺垱寤哄悕涓哄畨鍏ㄦ爣绛剧殑瀵硅薄锛屽畠浠槸绛栫暐鐨勪竴閮ㄥ垎銆傚彈瀹夊叏鏍囩淇濇姢鐨勬暟鎹О涓哄彈淇濇姢鏁版嵁銆傚畨鍏ㄧ鐞嗗憳閫氳繃鍚戠敤鎴锋巿浜堝畨鍏ㄦ爣绛炬潵鍏佽鐢ㄦ埛璁块棶鍙椾繚鎶ゆ暟鎹?濡傛灉鐢ㄦ埛璇曞浘璁块棶鍙椾繚鎶ゆ暟鎹紝璇ョ敤鎴风殑瀹夊叏鏍囩鍜屼繚鎶ゆ暟鎹殑瀹夊叏鏍囩闇?杩涜瀵规瘮銆傚鏋滅敤鎴疯瘯鍥捐鍙栦粬浠殑LBAC璇佷功涓嶅厑璁歌鍙栫殑鍙椾繚鎶よ锛孌B2 灏变細琛ㄧ幇鎴愯繖浜涜涓嶅瓨鍦ㄤ竴鏍枫?涓嶈兘閫夋嫨杩欎簺琛屼綔涓轰换浣?SQL璇彞鐨勪竴閮ㄥ垎锛屽寘鎷琒ELECT銆乁PDATE鎴栬?DELETE璇彞銆傝繛鑱氬悎鍑芥暟涔熶細蹇界暐鐢ㄦ埛鐨凩BAC璇佷功涓嶅厑璁哥殑琛屻?璀璇达紝COUNT(*) 鍑芥暟鍙細杩斿洖鐢ㄦ埛鎷ユ湁璇诲彇璁块棶鏉冪殑琛岀殑鏁伴噺銆?br />
相关链接:
Mp4 to 3gp converter
How to convert mp3 to aac
Liang Wang: Whitman's China troubles
No Drag And Drop The Title Of The Window
The Open Group President Of Beijing University Speech
UIM PHS market Price of 700 yuan more than today
Storage Inventory And Barcoding
Hot Astrology Or BIORHYTHMS Or Mystic
free download converter mp4 to 3gp
matroska FILE
Simple Accounting AND Finance
USER experience better! See the latest features TT4.4.1
How to reduce the lead time ---- to the WORLD-CLASS manufacturing of the third practice
How To Enhance The Productivity Of Textile And Garment Factories?
Unavoidable five "winter" rule
Novell SUSE Lin EXPANSION
