Advantages and disadvantages of parsing the DB2 9 database

Introduction: DB2 9 databaseIt is an important development in the development history of DB2 databases, but DB2 9 databases are not perfect, so there are both good and bad aspects, the following describes the advantages and disadvantages of the DB2 9 database.

Compared with other database management systems, DB2 9 has made significant innovations. In fact, DB2 9's support for XML is not only reflected in XML data, but also can be used to solve some problems that are difficult to solve Using relational models. DB2 9's support for XML is not negligible compared with the classic relational data model.

Compared with other mainstream database management systems, DB2 has its own advantages and disadvantages. The performance of DB2 on the datawarehouse system should be very good. At the same time, DB2 is doing very well on the optimizer. For most complex queries, it can be effectively rewritten as the optimal statement, and allocate reasonable execution plans.

DB2 has some shortcomings in the closing mechanism. This is related to the DB2 design framework. The use of memory locks improves efficiency while also having the highest requirement on system optimization. If the user does not optimize the database itself or the application, DB2 may easily encounter lock wait.

In addition, DB2 is still incomplete in providing APIs and functions. But the researchers at the Toronto lab are doing their best to improve this module, and we look forward to seeing more and more powerful functions in DB2 9.

At the same time, the high availability of all database systems is also a headache. High Availability in DB2 may be complicated for common users, but IBM has some classic technical documents for reference to help users set their own. For DBAs that manage multi-partition systems, it is important to reasonably set the partition key for how to coordinate each partition.

As a technical support team, it is most important to have a deep understanding of the communication and working mechanisms between different partitions. I remember reading an article saying that the share nothing architecture of DB2 is a lie. I personally think that it is because he only understood the multi-partition theory of DB2, however, we do not understand the allocation of memory CPU and disk resources.

Many people may think that DB2 is much more complicated than other database systems, but I think it is because these people do not know their underlying architecture and models. After understanding DB2, we will find that every module is carefully designed. If the system can be fully optimized, many common database problems will not occur.

We will introduce the advantages and disadvantages of the DB2 9 database to you. You can summarize more about the DB2 9 database in future work, we hope that the content described above will help you.

1. Four moves to install the database management software for DB2 9
2. DB2 9 Database Server Management-DB2 Security
3. Use MySQL skills to learn the DB2 9 database