Always look at some books to introduce the surrounding skills of the database, a bit greasy. Recently bought a "massive database solutions" This book, has read, in the content of the arrangement or more features, the content of both the foreign masterpiece of the knowledge of the introduction, and domestic books that kind of peripheral skills introduced, feel a different style. Although the title of the book is a massive database solution, but after reading I do not feel the slightest amount of thought, a lot of other is the database optimization knowledge Introduction, more specifically about the Oracle database some optimization knowledge introduction, so want to read the person should have psychological preparation, don't be confused by the title.
The title did get tricky, but some knowledge about the Oracle database is good, such as various tables and index implementation models, run plans, and so on. Some of the author's practical experience and domestic still have a lot of different places, such as the author of the cluster data, high-speed data return and other aspects of knowledge, but these ideas have been talked about less. I personally think that clustering data processing is still a good optimization method, of course, can be used to solve the problem of clustering, but also to consider the Index organization table or table by clustering key reconstruction to get a similar effect, only the cluster data processing by the database at the bottom of a more reasonable. As for the high-speed data return is more suitable for the traditional C/s architecture data display, b/s is generally used for paging processing.
The 4th chapter of the book describes the construction of the index of the strategic plan, the author of the index evaluation idea, in fact, a professional assessment of the index of the thinking process, but feel that the actual operation is expected to be more complex, I think it is more appropriate to use software to recommend index algorithm ideas.
Assuming your database is just a terabyte-level Oracle system, this book will be useful, assuming you really want to engage in petabytes of massive databases that might disappoint you.