Actual Operation Performance of DB2 9 XML in the real environment

This article mainly describes the actual operational performance of DB2 9 XML in the real environment, as well as the precautions worth attention in its actual operations and the description of its actual application code, the following is a detailed description of the main content of the article. I hope you will have a better understanding of it after browsing.

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, it is stored in IBM DB2 9 in relational and DB2 9 XML format. 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 and response speed of pureXML data storage and the query flexibility of DB2 9 XML data are both good.

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