Performance of DB2 9 XML in real Environments

This article mainly tells you about the performance of DB2 9 XML in the real environment. The following describes the performance of DB2 9 XML in the real environment, if you are curious about it, the following articles will unveil its mysteries.

Beijing Xicheng District Health Bureau provides services for about 1 million people. It stores the customer list in a large database, including sensitive data. The health system needs to combine complete documents (such as doctors' reports) with data from many data sources, so XML flexibility is very necessary.

Zhu Shu Hong, CIO of the Health Bureau, pointed out that "DB2 9 with the pureXML feature is not only suitable for the core database storage model, but also for the form of raw data collection and data exchange ". Mr. Zhu believes that XML can process complex personal health records, which makes XML very suitable for them. XML provides flexible query functions to quickly respond to real-time on-demand information, this is important for some medical activities. In particular, Xicheng District Health Bureau combines its large DB2 9 database with IBM's Service-Oriented Architecture (SOA, A "Service Bus" is implemented for Web services that provide data to applications ".

German Research Center for Competitive Sports (Das Deutsche Forschungszentrum für Leistungssport) developed an application called eActe, this program is used to collect and analyze basic information about sports science and application research information. Data collection is the most difficult aspect of this program.

This database contains a wide range of content, including a large amount of data generated by monitoring devices, scanned images, and a large amount of manual input data. For example, there are 3,000 parameters collected in 9 forms, a total of 63 pages. Data is captured through a dedicated online portal or client Application using Lotus Forms Software and then transmitted through an IBM WebSphere Application Server, and stored in the relational format and XML format in IBM DB2 9.

For a research center in Koln, pureXML can quickly capture complex motion test results and submit data in XML format, which is easy for other programs to analyze.

Another German organization, Douglas Holding AG, uses IBM DB2 9 and pureXML to collect data from 1,600 retail stores and 800 spice stores for a very traditional retail job: organize cash receipts for each store every day and prepare results for the company's data warehouse. In this case, pureXML is used to compress data and determine the data structure. Douglas finds that this system is easier to use than the previous one (see the "Joy of success" section in the relevant content ).

These examples show that the efficiency, response speed, and query flexibility of the pureXML data storage are good. The above content is an introduction to the performance of DB2 9 XML in the real environment. I hope you will find some gains.

The above content describes the performance of DB2 9 XML in the real environment, hoping to help you in this regard.