技术白皮书金仓数据库管理系统1金仓数据库管理系统金仓数据库管理系统金仓数据库管理系统技术白皮书技术白皮书.indd12009-11-118:49:372技术白皮书.indd22009-11-118:49:37技术白皮书金仓数据库管理系统3技术白皮书技术白皮书.indd32009-11-118:49:384目录1.………………………………………………………………………………………62.…………………………………………………………………………………63.…………………………………………………………………………………74.……………………………………………………………………………………74.1………………………………………………………………………………………………74.2…………………………………………………………………………………………………84.3…………………………………………………………………………………………………84.4………………………………………………………………………………………84.5XML…………………………………………………………………………………………………94.6………………………………………………………………………………………………94.7Web…………………………………………………………………………………………95.……………………………………………………………………………………95.1………………………………………………………………………………………95.2……………………………………………………………………………………105.3…………………………………………………………………………………………105.4…………………………………………………………………………………………105.5SMP64……………………………………………………………………………………115.6…………………………………………………………………………………………………116.………………………………………………………………………………116.1………………………………………………………………………………………116.2………………………………………………………………………………………116.3……………………………………………………………………………………………126.4……………………………………………………………………………………………137.………………………………………………………………………………137.1……………………………………………………………………………………………137.2……………………………………………………………………………………………137.3……………………………………………………………………………………………147.4…………………………………………………………………………………………………148.………………………………………………………………148.1Oracle…………………………………………………………………………………………148.2DB2……………………………………………………………………………………………14技术白皮书.indd42009-11-118:49:38技术白皮书金仓数据库管理系统58.3SQLServer……………………………………………………………………………………159.…………………………………………………………………159.1………………………………………………………………………………………………159.2………………………………………………………………………………………………159.3………………………………………………………………………………………………159.4………………………………………………………………………………………169.5………………………………………………………………………………………169.6………………………………………………………………………………………169.7……………………………………………………………………………………………169.8………………………………………………………………………………………169.9…………………………………………………………………………………………………1610.………………………………………………………………………………1710.1…………………………………………………………………………………………1710.2…………………………………………………………………………………………1711.………………………………………………………………………………1811.1……………………………………………………………………………………………………18………………………………………………………………………………………………18………………………………………………………………………………………………1811.2……………………………………………………………………………………………………19………………………………………………………………………………………………19………………………………………………………………………………………………19…………………………………………………………………………………19技术白皮书.indd52009-11-118:49:3861.KingbaseES“863”(DBMS)。,,1000、TB、GB。Windows、Linux、UNIX,、、、。KingbaseES。,2005。、、,:、。、、。KingbaseES、,DBMS,、、,。4、6,SQL,TPC-C、TPC-W,KingbaseES,《GB/T20273-2006》(TCSECB1),。2.KingbaseES,SQL。KingbaseES,。::、技术白皮书.indd62009-11-118:49:39技术白皮书金仓数据库管理系统73.。SQL。。,。、、、、、、、XML、。、、、、、。、,,。,,;。/,SQL、。SQL,,,。DML,、,,。4.KingbaseES,,SQL,,。4.1SQLKingbaseESSQL92。SQL92。ODBC3.0ODBC。JDBC3.0JDBC,Hibernate,JDBC4.0XML。OLEDBOLEDB。技术白皮书.indd72009-11-118:49:398.NET.NETDataProvider。PHP。Perl。OracleOCI。VisualStudio.NET、Eclipse、NetBeans、JBuilder、PowerBuilder、Delphi、C++Builder。WebSphere、WebLogic、JBoss、TomCat、TongWeb、Apusic、InforWeb。(Oracle、DB2、SQLServer),,,。PowerDesigner,,。4.2KingbaseES、,。,。KingbaseESWindows,Linux,Kylin,AIX、HP-UX、SolarisUNIX。KingbaseESJava,,,,。KingbaseES,。KingbaseES。,InternetB/S。TCP/IP。。4.3KingbaseES,、、UNICODE。KingbaseESGBK、GB18030,GB18030。KingbaseES。4.4KingbaseES,,,。KingbaseESTB,、。,TB。。(BLOB)(CLOB),2G。技术白皮书.indd82009-11-118:49:39技术白皮书金仓数据库管理系统9,。,I/O,。4.5XMLInternet,。XML,Schema,;XML,。KingbaseESXML,SQL/XML,XML,,(:、),XML。KingbaseESXML,XML。4.6KingbaseES,。,,、。:,CONTAINS。,AND、OR、NOT。SQLWHERE。4.7WebKingbaseES,,Web。KingbaseESJDBC,Java;.NETDataProvider,NETWeb。5.5.1KingbaseES,,。(DBMS),,DBMS。KingbaseES(MVCC)(2PL)(MV2PL)。,S,。,KingbaseES,,,。KingbaseES,。技术白皮书.indd92009-11-118:49:39105.2,SQL。KingbaseES。。:,。,,。,。。KingbaseES。SQLSQL、SQL。、。SQL,;,。,。,,SQL。KingbaseES,。5.3,KingbaseES,I/O,。I/O,,。KingbaseES,、、,。KingbaseES,SQLSQL,。,,。,,KingbaseES,,。5.4KingbaseES,技术白皮书.indd102009-11-118:49:40技术白皮书金仓数据库管理系统11,SQL。,,、OLTP,。B/S,,C/S,。,。,,。5.5SMP64KingbaseESSMP。SMP。CPU,。KingbaseES,SMP、、CPU、,,CPU、。KingbaseES64,64,64。64,4G。5.6KingbaseES,。,,。DBADDL,(),。,:DBA、,。,,。,,。,。,,,,。OLAP,,I/O。,,,,。6.,KingbaseES。、、、。、、。技术白皮书.indd112009-11-118:49:4012,《GB/T20273-2006》(TCSECB1),。6.1KingbaseES。:、、。、、。,,。、、,。KingbaseES,,,。。KingbaseES、。,。6.2KingbaseES。,。KingbaseES。:、、、。。KingbaseESACL()。,。,,。KingbaseES。。,,,——、,、。。KingbaseES,,,,。6.3KingbaseES。,技术白皮书.indd122009-11-118:49:40技术白皮书金仓数据库管理系统13,。KingbaseES,/。KingbaseES,,。。KingbaseES,,。,。DBMS,。,,。6.4KingbaseES,SSL。SSL。、、、。7.KingbaseES,。7.1KingbaseES。,KingbaseES。、、,。。KingbaseES://7.2KingbaseES,。7X24,。,,,。,,,,。,,,,。,。技术白皮书.indd132009-11-118:49:40147.3KingbaseES,。,,。7.4KingbaseES,(Master)(Slave),,(,),,,。,。8.KingbaseESOracle、DB2、SQLServer,、、,KingbaseES,,、KingbaseES。8.1OracleOracle(DBA|ALL|USER)_TABLES、(DBA|ALL|USER)_OBJECTSOracleDUALOracleROWNUMVARCHAR2CHAR(nCHAR|BYTE)OracleSYSDATEEMPTY_BLOBEMPTY_CLOBNVL、NVL2TRUNCNUMERIC_AND、NUMERIC_OROracleTO_NUMBEROracleTO_CHAROracle(+)CREATEORREPLACETRIGGEROraclePLSQLSQLDEFAULT8.2DB2CURRENTTIMESTAMPTIMESTAMP+YEARS|MONTHS技术白皮书.indd142009-11-118:49:40技术白皮书金仓数据库管理系统15UPDATELEFT、RIGHT8.3SQLServerIDENTITYSQLServerTOPDATEADD、DATEDIFF、DATEPARTISNUMERICREPLICATECONNECTIONSU