Thursday, July 29, 2010

Review the DB2 Viper


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淇濆瓨涓虹粡杩囬鍏堣В鏋愮殑甯︽敞瑙g殑鏍戙?濡備粖甯傞潰涓婂凡鏈夌函XML鏁版嵁搴擄紝浣嗕笉鏄贩鍚堝瀷鏁版嵁搴擄紙杩欐剰鍛崇潃瀹冧滑娌℃湁鍚屾椂瀛樺偍XML鏁版嵁鍜屽叧绯绘暟鎹殑浼樼偣锛夈?鏈変簡DB2 Viper锛孹ML灏卞彲浠ュ瓨鍌ㄤ负鍩轰簬鑺傜偣鐨勫眰娆℃ā鍨嬨?鍦ㄨ繖绉嶆ā鍨嬩腑锛屾瘡涓妭鐐逛笉浣嗕笌鍏剁埗鑺傜偣鐩歌繛鎺ワ紝杩樹笌鍏跺瓙鑺傜偣鐩歌繛鎺ャ?杩欑绾疿ML瀛樺偍鏄闂強瀛樺偍鏁翠釜XML鏂囨。鐨勬渶鏈夋晥鏂规硶锛屾彁渚涗簡鏋佸ぇ鐨勬?鑳戒紭鍔裤?

绾疿ML瀛樺偍鍙互鍘熷皝涓嶅姩鍦板瓨鍌╔ML鏂囨。锛屼粠鑰屾彁渚涗簡BLOB鍜孋LOB鐨勪紭鐐癸紝杩樿В鍐充簡鎬ц兘闂锛屽洜涓烘枃妗e瓨鍌ㄦ病鏈夎铏氭嫙鍖栨垚鍗曚竴銆佽繛缁殑瀛楄妭鑼冨洿銆傛暣缁勬枃妗g殑瀛樺偍琚櫄鎷熷寲鎴愯繛缁殑瀛楄妭鑼冨洿锛屼絾鍚勪釜鑺傜偣鍙互瀹夌疆鍒拌繖涓寖鍥翠腑锛屽鍏朵粬鑺傜偣鍜岀储寮曠殑褰卞搷鏋佸皬銆?br />
DB2 Viper鏃㈡敮鎸佸垎瑙g殑XML锛屽張鏀寔绾疿ML銆傛敮鎸佸垎瑙e姛鑳藉緢閲嶈锛屽洜涓篨ML鍙敤鏉ユ彁渚涚幇鏈夌殑鍏崇郴妯″紡銆傚洜涓烘枃妗d細鍙樺ぇ锛屽湪璁稿鎯呭喌涓嬭繕鍙互鏇存柊锛屾墍浠ML鏂囨。鐨勯潪BLOB瀛樺偍锛堝寘鎷湪鑺傜偣灞傞潰鑰屼笉鏄湪鏂囨。灞傞潰杩涜瀛樺偍锛夊叿鏈夌殑浼樺娍寰堟樉钁椼?

澶у鏁板叕鍙稿唴閮ㄥ凡缁忔湁鍏崇郴鏁版嵁鏈嶅姟鍣紝鑰屼笖鏈夎礋璐f敮鎸佺殑鍛樺伐銆傝櫧鐒禫iper浠h〃鐫?柊棰栥?鍏堣繘鐨刋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鏃ㄥ湪鍙互鏌ヨ琛ㄦ牸鏁版嵁缁撴瀯閭f牱銆俋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瑙f瀽鍣ㄣ?涓嬩竴琛屾寚浠?DB2閬嶅巻CLIENTS.CONTACTINFO鍒椾腑 Client鍏冪礌鐨刦ax瀛愬厓绱犮?姣忎釜fax鍏冪礌杩涜?琚粦瀹氬埌鍙橀噺$y銆傜涓夎琛ㄦ槑锛氭瘡娆¤凯浠h繑鍥?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鏂囨。鐨勫叾浠栬澶氬疄鐢ㄧ▼搴忋?

涓轰簡瑙e喅鏁版嵁璐ㄩ噺闂锛孌B2 Viper鍏佽鍦ㄦ湰鍦癉B2瀛樺偍搴撲腑鍒涘缓鍙婃敞鍐孹ML妯″紡锛堣繖鏄彲閫夋搷浣滐級銆傜劧鍚庯紝搴旂敤绋嬪簭璇曞浘灏嗘枃妗f彃鍏ユ垨鑰呭鍏ヨ〃涓椂锛孌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搴旂敤绋嬪簭鐨勬椂闂淬?

鑷垜绠$悊鍐呭瓨

瀵硅礋璐g‘淇濆簲鐢ㄧ▼搴忓拰鏁版嵁搴撴?鑳藉強鍙敤鎬х殑鏁版嵁搴撶鐞嗗憳锛圖BA锛夎?瑷?紝浠栦滑寰堥毦鎶藉嚭鏃堕棿鍘荤爺绌?XML鍜孲OA杩欎簺鏂版妧鏈?杩戞湡鐨勬瘡涓狣B2鐗堟湰閮芥坊鍔犱簡鍙缉鐭鐞嗘暟鎹簱鎵?渶鏃堕棿鐨勭壒鎬э紝浠庤?鎻愰珮浜咲BA鐨勫伐浣滄晥鐜囥?



鍥? 鏃㈣兘绠$悊鍏崇郴瀛樺偍鍙堣兘绠$悊绾疿ML瀛樺偍鐨凞B2娣峰悎鍨嬫暟鎹湇鍔″櫒

DB2 Viper閲囩敤浜嗘柊鐨勫唴瀛樿皟鏁寸壒鎬э紝瀹冨彲浠ヨ嚜鍔ㄨ缃唴瀛橀厤缃弬鏁板拰缂撳啿姹犲ぇ灏忕殑鍊笺?涓?棪琚惎鐢紝鍐呭瓨璋冩暣鍣ㄥ氨浼氬湪鍑犱釜鍐呭瓨浣跨敤鑰呬箣闂村姩鎬佸垎閰嶅彲鐢ㄥ唴瀛樿祫婧愶紝鍐呭瓨浣跨敤鑰呭寘鎷帓搴忋?鍖呯紦瀛樸?閿佸垪琛ㄥ尯鍩熷拰缂撳啿姹犮?鍦╓indows鍜孉IX骞冲彴涓婏紝鑷垜璋冩暣鍐呭瓨鐗规?杩樺彲浠ョ‘瀹氭?鐨勬暟鎹簱鍐呭瓨闇?眰锛屽苟鍔ㄦ?璋冩暣鏁版嵁搴撳叡浜殑鍐呭瓨銆傝繖椤圭壒鎬цDB2鍦ㄥ伐浣滆礋杞介渶瑕佹椂鍙互浣跨敤鏇村鐨勭墿鐞嗗唴瀛橈紱鏁版嵁搴撳唴瀛橀渶姹傚緢浣庢椂锛屽彲浠ュ皢鍐呭瓨閲婃斁缁欐搷浣滅郴缁熴?

闄や簡绠?寲鍐呭瓨閰嶇疆澶栵紝杩欓」鏂伴銆佽嚜閫傚簲銆佽嚜鎴戣皟鏁寸殑鐗规?杩樺彲浠ラ?杩囨彁渚涙渶浣抽厤缃?鈥旇繖绉嶉厤缃叿鏈夊姩鎬佹?锛岃繕鍙互搴斿宸ヤ綔璐熻浇鐨勭壒鐐瑰嚭鐜扮殑閲嶅ぇ鍙樺寲锛屼粠鑰屾彁楂樻?鑳姐?

鑼冨洿鍒嗗尯

闈㈠悜Linux銆乁nix鍜學indows鐨凞B2寮曞叆浜嗕竴椤规柊鐨勫垎鍖烘妧鏈紝鍙互鎻愰珮鏁版嵁浠撳簱鐨勬?鑳斤紝骞剁缉鐭鐞嗘椂闂淬?鏂扮殑琛ㄥ垎鍖烘柟娉曢?甯哥О涓鸿寖鍥村垎鍖猴紙range partitioning锛夛紝鍙互涓烘瘡涓垎鍖哄畾涔夋暟鎹寖鍥达紝骞舵牴鎹暟鎹寖鍥村皢鏁版嵁瀛樺偍涓虹嫭绔嬪璞°?璀璇达紝鍙互鏍规嵁琛ㄤ腑鐨勬棩鏈熷垪锛屾寜鐓у勾鍜屾湀瀵硅〃杩涜鍒嗗尯銆傝繖浜涘瓨鍌ㄥ璞″彲浠ヤ綅浜庝笉鍚岀殑琛ㄧ┖闂淬?鍚屼竴琛ㄧ┖闂达紝鎴栬?涓ょ鎯呭喌鐨勭粍鍚堬紙瑙佸浘2锛夈?



涓嶈灏嗚繖绉嶅垎鍖烘妧鏈笌鏁版嵁搴撳垎鍖哄姛鑳斤紙DPF锛夌浉娣锋穯锛孌PF 鍏佽鏍规嵁鍒嗗竷閿拰鏁e垪鍑芥暟璺ㄥ涓暟鎹簱鍒嗗尯瀵规暟鎹繘琛屽垎甯冿紝寰?線鐢ㄤ簬鎻愰珮鍙墿灞曟?锛屼粠鑰屾敮鎸侀潪甯稿ぇ鐨勬暟鎹簱銆?br />
琛ㄥ垎鍖鸿瀛樺偍瀵硅薄鐨勮涓哄氨鍍忓崟涓殑琛ㄩ偅鏍凤紝閫氳繃浣跨敤ALTER TABLE...ATTACH璇彞灏嗙幇鏈夌殑琛ㄤ笌鍒嗗尯鐨勮〃杩涜鍚堝苟锛屼粠鑰岃交鏉惧疄鐜板揩閫熻浆鍏ワ紙roll-in锛夈?鍚屾牱锛岀敤ALTER TABLE...DETACH 璇彞寰堝鏄撳疄鐜拌浆鍑猴紙roll-out锛夈?鏌ヨ澶勭悊鍙互鍒╃敤鍒嗛殧鏉ラ伩鍏嶆壂鎻忔棤鍏崇殑鏁版嵁锛屼粠鑰屼负璁稿鏁版嵁浠撳簱椋庢牸鐨勬煡璇㈡彁渚涙洿濂界殑鏌ヨ鎬ц兘銆?br />
琛ㄥ垎鍖哄線寰?敤鏉ュ瓨鍌ㄤ緵鍒嗘瀽鐨勫巻鍙叉暟鎹?璀璇达紝鍏稿瀷鐨勪繚闄╂暟鎹粨搴撳彲鑳戒繚瀛樹簡涓夊勾鐨勭储璧旀暟鎹?灏嗘瘡涓湀鐨勬暟鎹浇鍏ヤ粨搴撳悗锛屾渶鏃╅偅涓湀鐨勬暟鎹氨琚瓨妗o紝骞朵粠娲诲姩琛ㄤ腑鍒犻櫎銆傛柊鐨勮浆鍏ュ拰杞嚭鐗规?鏈夊姪浜庤繖绉嶆暟鎹Щ鍔紝浠庤?缂╃煭浜嗙鐞嗘椂闂淬?鍙壂鎻忛?鐢ㄥ垎鍖轰腑鐨勬暟鎹彲浠ュ姞蹇煡璇㈤?搴︼紝浠庤?鎻愰珮鎬ц兘銆傝寖鍥村湪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鍘嬬缉瑙e喅鏂规绫讳技闈㈠悜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锛夋潵瑙e喅杩欎簺瀹夊叏闂銆侺BAC鍦ㄥ崟涓鍜屽崟涓垪灞傞潰涓婃彁渚涗簡缁嗗寲鐨勮鍐欒闂帶鍒躲?

鍙皟鏁碙BAC鐨勫姛鑳戒粠鑰屾弧瓒虫瘡瀹跺叕鍙哥壒瀹氱殑瀹夊叏闇?眰銆侷BM寤鸿锛氭墍鏈塋BAC閰嶇疆搴旂敱鍏徃瀹夊叏绠$悊鍛樻潵鎵ц銆侱B2 Viper鍒涘缓浜嗘柊鐨凞B2瀹夊叏绠$悊鍛樿鑹诧紙SECADM锛夛紝瀹冨叿鏈夌壒瀹氱殑瀹夊叏鐗规潈銆?br />
瀹夊叏绠$悊鍛橀?杩囧垱寤哄畨鍏ㄧ瓥鐣ユ潵閰嶇疆LBAC绯荤粺銆傚畨鍏ㄧ瓥鐣ユ弿杩颁簡灏嗙敤鏉ュ喅瀹氳皝鍙互璁块棶鍝簺鏁版嵁鐨勬爣鍑嗐?鍒涘缓浜嗗畨鍏ㄧ瓥鐣ヤ箣鍚庯紝瀹夊叏绠$悊鍛樺垱寤哄悕涓哄畨鍏ㄦ爣绛剧殑瀵硅薄锛屽畠浠槸绛栫暐鐨勪竴閮ㄥ垎銆傚彈瀹夊叏鏍囩淇濇姢鐨勬暟鎹О涓哄彈淇濇姢鏁版嵁銆傚畨鍏ㄧ鐞嗗憳閫氳繃鍚戠敤鎴锋巿浜堝畨鍏ㄦ爣绛炬潵鍏佽鐢ㄦ埛璁块棶鍙椾繚鎶ゆ暟鎹?濡傛灉鐢ㄦ埛璇曞浘璁块棶鍙椾繚鎶ゆ暟鎹紝璇ョ敤鎴风殑瀹夊叏鏍囩鍜屼繚鎶ゆ暟鎹殑瀹夊叏鏍囩闇?杩涜瀵规瘮銆傚鏋滅敤鎴疯瘯鍥捐鍙栦粬浠殑LBAC璇佷功涓嶅厑璁歌鍙栫殑鍙椾繚鎶よ锛孌B2 灏变細琛ㄧ幇鎴愯繖浜涜涓嶅瓨鍦ㄤ竴鏍枫?涓嶈兘閫夋嫨杩欎簺琛屼綔涓轰换浣?SQL璇彞鐨勪竴閮ㄥ垎锛屽寘鎷琒ELECT銆乁PDATE鎴栬?DELETE璇彞銆傝繛鑱氬悎鍑芥暟涔熶細蹇界暐鐢ㄦ埛鐨凩BAC璇佷功涓嶅厑璁哥殑琛屻?璀璇达紝COUNT(*) 鍑芥暟鍙細杩斿洖鐢ㄦ埛鎷ユ湁璇诲彇璁块棶鏉冪殑琛岀殑鏁伴噺銆?br />





相关链接:



The Xenofex Photoshop filters



E-Mail Clients introduction



MM produced a cartoon picture will BLINK



RECOMMEND Anti-Virus Tools



Carefully key In secret



Shuo-side by side with the day thinking up the computer "settle down"



mp4 3gp video converter



"Jingdong model" kept short board



youtube to mpg



flac to MP3



.TS file



Office Suites And Tools Catalogs



Premier Web Development



Review: Liu's "marathon" Life



TTE Drag The Resignation Of Li Dongsheng TCL Robert Hu Personally In Command Performance



No comments:

Post a Comment