Difference and connection between DB2 and Oracle databases

A few days ago, the only annual event in the database field in China will be held by Shengtuo media's IT168 website, which will bring together its ITPUB, IXPUB, and ChinaUnix's three major enterprise-level technical community advantages.

A few days ago, the only annual event in the database field in China will be held by Shengtuo media's IT168 website, which will bring together its ITPUB, IXPUB, and ChinaUnix's three major enterprise-level technical community advantages.

A few days ago, the only annual event in the Chinese Database field was held in Beijing at the 2011 database technology conference hosted by Shengtuo media's IT168 website, ITPUB, IXPUB, and ChinaUnix China's three major enterprise-level technical communities. This Conference was an unprecedented event, and a large number of database technical experts gathered. At the Database Conference, the reporter interviewed Wang feipeng, senior consultant from ibm cdl DB2, to have an in-depth discussion on topics in mainstream data fields such as Oracle and DB2 databases.

Reporter: What are the differences between ORACLE databases and DB2 databases?

Wang feipeng: There are two phases to look at this problem. Before DB2 V97, DB2 and ORACLE went further and further in terms of architecture, design, and development.

However, after DB2 97, there was a "watershed". DB2 and ORACLE were getting closer and closer in terms of architecture, design, and development ". The reason for "moving closer" is based on the user's needs. For example, from the developer's perspective, can developers better write code;

2. ORACLE is based on the share-disk architecture and DB2 adopts the share-nothing architecture. Can DB2 provide the share-disk architecture? The answer is also acceptable.

Reporter: What are the features of your ORACLE database?

Wang feipeng: it is more flexible and convenient, especially when developers and developers start to work in ORACLE, developers can convert characters. In DB2 97, DB2 data is relatively rigorous and direct conversion is not allowed. In addition, after DB297, DB2 provided flexibility and was "moving closer" for developers ".

ORALCE has been in the shar disk path in structure. Therefore, in terms of architecture, DB2 seems to be better than ORACLE because it enables both architectures at the same time, but everything depends on the market choice.

Reporter: What features does DB2 have?

Wang feipeng: Traditionally, DB2 databases are mainly used in banking, telecommunications, and other industries. DB2 databases have stood the test of the industry and have been widely used in traditional industries. From the perspective of the industry, DB2 is gradually gaining user recognition in the manufacturing industry and in small and medium-sized enterprises on the open platform. The reason is that the development needs are considered more at the beginning of DB2.

Reporter: based on the performance of the two databases, should we create a compatibility database for mongoel in DB2?

Wang feipeng: only three steps are required:

1. Innovate databases and activate environment variables;

2. There are not many differences between innovative databases and traditional databases;

3. enable two switches. First, the switch controls the deployment of the database object switch. This switch is enabled. 2. ORACLE databases should be rounded to different places, so that they should be rounded to the same place to meet user needs. In this way, DB2 is used as an ORACLE database.

Reporter: What are the points of integration between ORACLE and DB2?

Wang feipeng: in terms of design, temporary table design and index design all belong to logic design. There is no much difference in physical design. DB2 is used as ORACLE, but it is cheaper than ORACLE.

In terms of maintenance, ORACLE provides many maintenance tools and DB also provides many maintenance tools, but the methods are the same. In terms of maintenance, we often say that the system performance can be optimized, and we can find a simple and effective way to optimize the system.

Reporter: In your opinion, how should we select databases for small and medium-sized enterprises?

Wang feipeng: database selection for small and medium-sized enterprises is divided into two aspects:

1. open source database. The advantages and disadvantages of open-source databases are very prominent. The disadvantages are high maintenance costs and high TCO costs, which cannot be easily solved.

2. commercial databases mainly refer to ORACLE, SBYASE, SQL SERVER, and DB2 databases. DB2 is also more widely used in small and medium-sized enterprises, especially on the LINUX platform. Therefore, ORACLE is supported on the linux platform. It is the same as other platforms.

DB2 has a good platform on the P branch column. Can it be tested on linux? We did some tests and we achieved certain results in the performance and functions of the linux platform. Therefore, if small and medium-sized enterprises use commercial databases to consider their cost-effectiveness, such as the high price of El, DB2 prices are lower and it is easy to get service support.

The profits of small and medium-sized enterprises are not very high in the database is relatively low, usually small and medium-sized enterprises put the database on a layer of architecture problems, if the database vendor price increases, the architecture is difficult to adjust. Therefore, with the development of small and medium-sized enterprises, it is sometimes necessary to balance the database architecture. For example, some businesses use ORACLE and some businesses use DB2. In this way, when cooperating with the manufacturer, the business system will not be "kidnapped" by a vendor, so there will be no risk.