Five secrets to decrypt DB2

Database experts are available in different regions.DB2 databaseIt is one of the members of this big group. It can be said that the performance of the DB2 database is remarkable. As a useful database system, the DB2 database has won the favor of many users. Challenges such as large-capacity data, unstructured data, data compression, compatibility, and data analysis come as a result? The IBM DB2 database has quietly become a secret of five secrets. Here we will decrypt its unique secret!

Fa Bao 1: Deep Compression

This is similar to the deep compression function provided by DB2, which uses internal gas to narrow the gap between bones and reduce the size of the body. DB2 uses the data row compression method based on the dictionary table. When compressing data, it can use a small number of database pages to represent the same data, this saves disk storage space. This feature is especially suitable for large tables with duplicate patterns in rows ｡

The practice of many IBM customers has proved that DB2's deep compression greatly reduces storage space and costs, and improves I/O efficiency. For example, a software company used DB2 data storage to reduce space by more than 60% and improve transaction performance by 10%. A telecom company and a bank both reduced data storage by 50%.

Magic Weapon 2: lingbo Microstep-pureXML

PureXML is an added feature of the DB2 database after V9. It can store XML data in the original format in database tables. XML data is hierarchical in nature and can be naturally expressed as a tree that contains nodes with parent, child, and compatriot relationships. The XML data types provided by DB2 store parsed XML documents and fragments, with node-level granularity, can retain the original XML data hierarchy. The advantage is that data does not need to be parsed when complicated relational models or extraction is not required. Therefore, both the storage space and the read speed are greatly improved. For example, with the support of pureXML technology, a 1 tb xml Benchmark test only requires a bare device space of 6,763 GB and can process XML transactions per second. In this way, DB2 becomes a hybrid database tool for relational and XML data.

"Hugh xunfei, erratic as a god, lingbo weibu, Luo Sohu shengchen. Impermanence, if dangerous. Difficult to start, if you want to continue ." Is the description of "lingbo Microstep" in "Luo Shenfu" similar to that of pureXML?

Fa Bao 3: Fei Long in the sky-unlimited expansion of pureScale

Adhering to the traditional knowledge of DB2 for z/OS Coupling Facility, pureScale is a solution closest to z/OS "golden standard" on a distributed platform. Based on the Z Sysplex model, it uses the COTS component, with high availability and scalability, it is superior to competitors in the market. PureScale can provide almost unlimited capacity for any transactional workloads. Expansion systems can effectively expand multiple servers without changing application code by connecting to new nodes and issuing two simple commands.

Combined with the IBM Power7 server, pureScale provides near-linear performance expansion capabilities, just like "Flying Dragon in the sky, see adults ".

Magic Weapon 4: Qiankun's great migration-compatibility with Haina baichuan

Qian Kun's way, Yin and Yang exchange, rigid and flexible reverse, from nothing to have, from have to none. Qian Kun's Great shift has always been one of the most powerful martial arts handed down by the Ming Dynasty. Its fundamental principle is not mysterious, but it only needs to stimulate its own potential and then lead the move, but the changes are amazing, it is incredible.

In the real application environment, customers often face multi-Database Parallel environments. The compatibility of DB2 can be non-collaborative with databases of other brands. In addition, if the customer intends to migrate data, DB2 also provides migration tools for Oracle and Sybase databases respectively. In some customers and ISV tests, DB2 has more than 95% compatibility with Oracle databases, and can easily support Oracle-based applications. It takes only one week to migrate applications from Oracle to DB2; the SQL Skin for Sybase database migration has also been tested and migrated by customers such as BJC Healthcare and Pep Boys.

Magic Weapon 5: Powerful-superior performance

It is said that for the purpose of all sentient beings, the Buddha has been able to escape from erhua and pass on a set of martial arts secrets to ordinary people. Just as DB2 on IBM Power is an undisputed performance leader, far surpassing competitors in the same industry. In the development process of IBM Power7, the design is integrated with the high performance of IBM DB2. DB2 can automatically utilize large-scale hardware concurrency Based on the POWER7 system, thus reducing costs and improving performance. It can automatically utilize and optimize multithreading without modifying the application. In this way, DB2, which runs on Power systems, requires less processors to complete the same job, less hardware and software costs, less processor authorization required) and maintenance costs, thus, database managers who are plagued by high operating costs are "general.

This is the five magic weapons that DB2 Databases play a certain role in the database market. The content mentioned above can be used for your reference and I hope to help you.