Proofreading for massive database solutions

In the first part, all the elements that affect the efficiency of data reading are classified, and their respective concepts, principles, characteristics, application guidelines, as well as the structural characteristics of tables, diversified index types, the internal role of the optimizer, and the execution plan formulated by the optimizer for various results are described in detail, and based on the correct understanding of the optimizer, the index construction strategy that has the greatest impact on the execution plan and execution speed is proposed. In the second part, we will introduce specific strategies for improving data reading efficiency, introduce the principles and specific application methods of local range scanning related to data reading efficiency, and elaborate on all types of table joins that are considered to be the basis for improving the efficiency of database use.

The series has been loved by a wide range of readers for 10 years, and while it has been hailed as the Bible, it has become an indispensable must-read for database users. The author strives to find an ingenious method that can be easily applied and controlled by IT workers in their actual work, and provide solutions for massive databases that do more with less.

Ideal for database developers and database administrators.

Indexes such as b-tree indexes, b-tree cluster indexes, and hash cluster indexes are commonly used in relational databases.

B-tree indexes have many duplicate values, especially when users create a large number of combined indexes to improve query speed, which will pay a lot of money when processing massive data.

B-tree indexes require columns to have good dispersion, and only again can they ensure good read efficiency. In cases where the dispersion of the index columns is not very good, even if the index is created, the optimizer may ignore the index and the optimizer will be able to make a judgment based on the statistics.

If the columns in the composite index do not appear in the query criteria, or if non-equivalent operators are paid to the middle columns of the composite index in the query criteria, the read efficiency of the data is often greatly affected. Solution: Create multiple composite indexes so that the same column is used multiple times in different indexes.

The limitation of b-tree indexes is that when query conditions composed of null or not are used, or when the query statement contains complex OR, the role of the index cannot be fully played. Solution: Perform a comprehensive analysis of all query requirements (drive query conditions).

The RDBMS classics, which cover the latest core technologies of database specialists, contain advanced methods to reduce ** to 1 10 and increase the speed by 10 times.

Unraveling the true face of relational databases.

1 billion won 400,000 copies sold myth.

Mr. Lee Hwa-sik, a Korean database master, has swept Japan and South Korea with his strength.

Translated by Dr. Guoqiang Gai and Dr. Zheng Baowei Edited by Le Yi Cui Hua Reviewed "Massive Database Solution" is a high-level classic book that comprehensively reflects the rapid development of the latest database application technology of commercial DBMS in the past 10 years, strengthens the principle of flexible application of database technology and systematizes specific application guidelines.

Massive Database Solutions has been published in Korea and Japan at the same time. At the same time that the most authoritative database publishing house in Japan, Xiangyongsha Publishing Co., Ltd., published and distributed "Massive Database Solution", and also spread Korea's advanced database technology to Japan. While publishing the Chinese version this time, we also hope that the technologies covered in "Massive Database Solutions" will be helpful to the majority of readers in China.

The universal principles of the Mass Database Solution are applicable to any DBMS and can be used effectively across all DBMS with minor tuning of the syntax. In order to facilitate the reader to have a full understanding of the concept of relational databases, the flexible application principles of optimizers, and the clear application guidelines applicable to diverse practical businesses, these contents are explained in detail through examples in "Massive Database Solutions".

The "Massive Database Solutions" series has been loved by readers for 10 years, and while it has been hailed as the "Bible", it has become an indispensable must-read for database users. The authors strive to find clever ways to make it easy for IT workers to apply and control in their real work, and provide solutions to massive databases that do more with less.

This book is suitable for database developers and database administrators, alike.

The RDBMS classics, which cover the latest core technologies of database specialists, contain advanced methods to reduce the number of data by 1 to 10 times and increase the speed by 10 times.

Unveiled the true face of relational databases and demonstrated new technologies that had not been used flexibly until now.

1. All massive database solutions. It is recommended to learn the OCP literacy class first, and it is recommended to read it after learning the OCM, otherwise you won't be able to understand it at all!! It was written by Koreans, and Gai Guoqiang participated in the translation.

Oracle in the first detail

It's said to be pretty good

You can take a look.

Since it is a university, of course, it is necessary to do something of practical significance. I think I can get a "library borrowing management system", which includes, student materials, book categories, borrowing time management (borrowing time, borrowing volume, renewal and other functions), damage compensation, etc.

This year, you can also get a new campus meal ordering or something.