Art of Programming Oracle 9i & 10g: In-Depth Database Architecture

Author: Kate
Publisher:
Publish Date: 2006-10-01
Features: This book is an authoritative guide on the architecture of Oracle9i and 10g database systems, covering all important Oracle architecture features, including files, memory structures, and processes, locks and latches, transactions, concurrency and multiversioning, tables and indexes, data types, as well as partitioning and parallelism. It fully utilizes specific examples to introduce each feature, not only discussing what each feature is but also explaining how it works, how to use it to implement software, and common pitfalls. This book is intended for all developers or DBAs involved in Oracle database applications. Whether you are a programmer or a DBA, to create and manage stable, high-quality Oracle systems ultimately requires understanding the architecture of the Oracle database. This book is an undeniable authoritative guide to Oracle databases, condensed decades of valuable experience and profound insights from the world's Oracle expert Thomas Kyte. The book provides an in-depth analysis of the Oracle database architecture, including files, memory structures, and the underlying processes that constitute the Oracle database and instance. It then discusses important database topics such as locking, concurrency control, transactions, redo and undo, and explains the significance of these concepts. Finally, it analyzes the physical structure of the database, such as tables, indexes, and data types, and introduces the techniques that can be used to optimally utilize these physical structures. When introducing each feature, the author fully utilizes specific examples to illustrate, not only discussing what each feature is but also explaining how it works, how to use it to implement software, and covering related common pitfalls. This book can help you unlock the full potential of Oracle technology. Undoubtedly, this is one of the most important Oracle books and absolutely worth owning. —Ken Jacobs, Vice President, Product Strategy (Server Technologies), Oracle Corporation
This book is an authoritative guide on the architecture of Oracle9i & 10g databases, covering all important Oracle architecture features, including files, memory structures, and processes, locks and latches, transactions, concurrency and multiversioning, tables and indexes, data types, as well as partitioning and parallelism, and utilizes specific examples to fully introduce each feature. It not only discusses what each feature is but also explains how it works, how to use it to develop software, and covers related common pitfalls. This book is intended for all developers or DBAs involved in Oracle database applications. Whether you are a programmer or a DBA, to create and manage stable, high-quality Oracle systems ultimately requires understanding the architecture of the Oracle database. This book is an authoritative guide to Oracle databases, condensed decades of valuable experience and profound insights from the world's Oracle expert Thomas Kyte. The book provides an in-depth analysis of the Oracle database architecture, including files, memory structures, and the underlying processes that constitute the Oracle database and instance. It then discusses important database topics such as locking, concurrency control, transactions, redo and undo, and explains the significance of these concepts. Finally, it analyzes the physical structure of the database, such as tables, indexes, and data types, and introduces the techniques that can be used to optimally utilize these physical structures. When introducing each feature, the author fully utilizes specific examples to illustrate, not only discussing what each feature is but also explaining how it works, how to use it to implement software, and covering related common pitfalls.