Which of the following advantages does IBM release DB2 9.7 correctly compatible with Oracle?

This article mainly describes how IBM releases the actual DB2 9.7 operating solution that is compatible with Oracle, on a very reputable website, I found a document about the actual operation solution for correct Oracle Database compatibility with DB2 9.7 for your sharing.

We all know that IBM releases DB2 9.7 and InfoSphere Warehouse 9.7 to improve operational efficiency and cut storage costs by up to 75%. The unique business analysis features will help enterprises to gain new insights ".

IBM (NYSE: IBM) recently released the latest versions of DB2 and InfoSphere Warehouse software-DB2 9.7 and InfoSphere Warehouse 9.7 to help enterprises get more returns from their IT investments. The latest version of DB2, Cobra, can greatly reduce data storage space and help customers save up to 75% of related costs (including energy costs), far better than any other database software on the market.

The software is also the first database software in the industry that can provide business analysis functions for both relational and XML data. In addition, IBM DB2 9.7 is embedded with the compatibility technology of javasisedb, an open source database vendor, to achieve compatibility with Oracle databases.

Work with EnterpriseDB to be compatible with Oracle databases

EnterpriseDB is an open source database vendor. With its S Plus platform, you can directly use Oracle databases. According to mongoisedb, "according to the agreement between IBM and EnterpriseDB, The Postgres Plus Advanced Server of DB2 and EnterpriseDB will provide powerful compatibility solutions to each other, it also provides extended and convenient applications and technical support for Oracle database users.

In this way, the customer can run programs specially written for the Oracle database on DB2 to reduce migration costs, time and risks ." [1]

"We are very happy to work with IBM to improve our database technology together," said Ed Boyajian, Chief Executive Officer of EnterpriseDB. We are committed to making exciting changes in the evolving database software market ."

Dedicated analysis features help enterprises gain new insights"

Looking at the present, the information generated by enterprises is increasing exponentially. The information explosion has put a heavy burden on the database infrastructure, and the data-related management, power supply, heat dissipation, and storage costs have risen sharply. According to the IBM survey, enterprises generate up to 15 TB of new information every day. Enterprises urgently need a pair of eye-catching insights to explore commercial value in these massive volumes of information.

The new version of DB2 is the first database software in the industry that can provide business analysis functions for both relational and XML data. It enables enterprises to make full use of hardware, improve management efficiency, easily run applications written with other database software, and generate "cutting-edge insights" from valuable XML data ", solve the problem easily.

For example, the University of California Los Angeles Medical Center is using this software with analytical functions to manage medical records, the new features of DB2 9.7 help ucia better analyze and understand the disease development patterns and trends of patients with similar symptoms or symptoms, while reducing the storage space for medical records by 50%. Currently, ucia is developing three clinical applications using the new features of the software to provide better services for patients.

Multi-pronged approach to save time, energy, deployment and development costs

Arvind Krishna, vice president of IBM Information Management and Development, said: "In order to achieve better business results, banking, medical, and retail industries manage, analyze, and access information while, we are also working hard to solve the increasingly prominent energy cost problem. With the innovative features of DB2 and InfoSphere Warehouse software, IBM once again provides customers and partners with higher performance and lower costs ."

Several customers have benefited a lot from this new technology. For example, Douglas Holding AG, a German retailer specializing in spices and fashion products, is using DB2 to manage the sales records of its 1,800 European stores and connect Store cash registers and their data warehouses with XML applications. In the test run of the latest version of DB2 and applications, the company confirmed that the accuracy of sales records has been significantly improved, which helps them better understand the purchasing habits of customers and thus improve the overall business performance.

In addition, BJC Healthcare, a medical facility in St. Louis, Missouri, also chooses to use DB2 to enable the institution and its affiliated medical schools to develop from manual collection of medical research data in the past to electronic data collection. With DB2, the time required to collect data is shortened from months to hours or even minutes.

Now, BJC Healthcare has been able to perform comprehensive queries on massive data and analyze the query results to ensure that the study staff can view the patient's detailed medical records in a timely manner. With this data, the institution is also able to identify cases that comply with clinical research standards and adjust the course of treatment as needed.

InfoSphere Warehouse 9.7 Enterprise Edition uses DB2 9.7, which includes tools for simplifying data analysis and data mining, and the latest Departmental Edition Software for minicomputers and internal departments of large organizations. This new version of software enables organizations to transform data into reliable and Unified Business Intelligence to meet their business needs.

IBM's integrated data management solution helps increase the efficiency of developers-an excellent way to reduce costs for enterprises. The latest technologies included in DB2 9.7 can help IT experts develop and deploy applications more easily and quickly, and even handle applications specially written for other databases. With these latest technologies, developers can now easily leverage these technologies to design, develop, deploy, and manage information with IBM Data Studio.

Enterprises that joined the early stages of the DB2 9.7 program found that they used the new version of DB2 to deploy the application, saving a lot of time. Paolo Juvara, chief technology officer of Openbravo, a Web solution ERP provider and business partner of IBM, said: "It may take about two years to migrate our application to the previous version of DB2, it only takes one week to port DB2 to the latest version.

This will bring us unlimited opportunities to expand global communities including users, partners and developers. We are very honored to be able to work with IBM to deploy new solutions ."

In addition, DB2 9.7 has the workload management and Automatic Computing Features to increase the priority of applications (such as completing quarterly financial reports to help IT staff manage growing data more efficiently) performance, saving 35% of administrative work time.

DB2 9.7 and InfoSphere Warehouse 9.7 will be available soon. Customers, developers, and partners can test and run DB2 9.7 through IBM's early engagement program.