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????????????????????????????????????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 />
????:
The process of recording impromptu slide show reaction
Acorn International is digital coverage
Ma, “New York Times” Published A Signed Article: Small Is Beautiful Because
Premier Launchers And Task Managers
Jobs for the iPhone price cut apology gift certificate will be returned to 100 U.S. dollars
ESRI Experts, Non-Chan: Snow Emergency GIS Can Do More
“Su Health” Simple completely RAIDERS
FreeBSD Serial (93): reverse proxy load balancing
