Oracle 10g概念实战：英文版数据库经典指南

需积分: 3 119 浏览量更新于2024-07-31 收藏 6.61MB PDF 举报

Oracle Database Concepts 10g Release 2 (10.2) 是一本经典的Oracle技术书籍，由Michele Cyran担任主要作者，而Paul Lane、JPPolk等多位经验丰富的专家也贡献了他们的专业知识。这本书在2005年10月出版，版权归属Oracle，享有1993年和2005年的版权保护。这本书深入浅出地介绍了Oracle数据库的核心概念，涵盖了10g Release 2的重要特性和功能。它不仅包括软件本身，还包括详尽的文档资料，这些都承载着Oracle公司的知识产权。用户在使用时，必须遵守包含使用限制和保密条款的许可证协议，同时，程序的反编译、分解或逆向工程仅限于为了获得兼容性而进行的必要操作，受到专利、版权以及工业和智力财产法律的保护。书中内容广泛，包括但不限于数据库体系结构、SQL语言基础、数据存储和管理、事务处理、并发控制、安全性、备份恢复策略、性能调优、网络架构、分布式系统管理和维护等多个方面。每一个主题都细致入微，旨在帮助读者理解并掌握Oracle数据库的高效运作和最佳实践。对于那些正在学习、开发或管理Oracle数据库的专业人士而言，这是一本不可或缺的参考书籍，它不仅提供了理论知识，还包含了大量实用的案例和实战指导。无论是初次接触Oracle的新手，还是资深的DBA，都能从中受益匪浅，提升自己的技能水平和解决问题的能力。 Oracle Database Concepts 10g Release 2是Oracle数据库领域的一座知识宝库，无论是作为学习资料，还是作为专业人员的工具书，都能为其职业生涯提供强大的支持。

xvi

Nonvolatile ............................................................................................................................... 16-2

Time Variant ............................................................................................................................. 16-2

Differences Between Data Warehouse and OLTP Systems ...................................................... 16-2

Workload................................................................................................................................... 16-2

Data Modifications................................................................................................................... 16-2

Schema Design ......................................................................................................................... 16-3

Typical Operations................................................................................................................... 16-3

Historical Data.......................................................................................................................... 16-3

Data Warehouse Architecture....................................................................................................... 16-3

Data Warehouse Architecture (Basic)................................................................................... 16-3

Data Warehouse Architecture (with a Staging Area) ......................................................... 16-4

Data Warehouse Architecture (with a Staging Area and Data Marts)............................. 16-5

Overview of Extraction, Transformation, and Loading (ETL) ...................................................... 16-6

Transportable Tablespaces............................................................................................................. 16-7

Table Functions................................................................................................................................ 16-7

External Tables ................................................................................................................................ 16-8

Table Compression ......................................................................................................................... 16-8

Change Data Capture ..................................................................................................................... 16-9

Overview of Materialized Views for Data Warehouses................................................................. 16-9

Overview of Bitmap Indexes in Data Warehousing..................................................................... 16-10

Overview of Parallel Execution ........................................................................................................ 16-11

How Parallel Execution Works................................................................................................... 16-11

Overview of Analytic SQL ................................................................................................................ 16-12

SQL for Aggregation..................................................................................................................... 16-13

SQL for Analysis............................................................................................................................ 16-13

SQL for Modeling.......................................................................................................................... 16-14

Overview of OLAP Capabilities....................................................................................................... 16-14

Benefits of OLAP and RDBMS Integration ............................................................................... 16-14

Scalability ................................................................................................................................ 16-15

Availability.............................................................................................................................. 16-15

Manageability......................................................................................................................... 16-15

Backup and Recovery............................................................................................................ 16-15

Security.................................................................................................................................... 16-16

Overview of Data Mining.................................................................................................................. 16-16

17 High Availability

Introduction to High Availability ...................................................................................................... 17-1

Overview of Unplanned Downtime.................................................................................................. 17-1

Oracle Solutions to System Failures............................................................................................. 17-1

Overview of Fast-Start Fault Recovery ................................................................................ 17-2

Overview of Real Application Clusters................................................................................ 17-2

Oracle Solutions to Data Failures.................................................................................................. 17-2

Overview of Backup and Recovery Features for High Availability................................. 17-2

Overview of Partitioning ....................................................................................................... 17-3

Overview of Transparent Application Failover .................................................................. 17-4

Oracle Solutions to Disasters......................................................................................................... 17-5

Overview of Oracle Data Guard............................................................................................ 17-5

xvii

Oracle Solutions to Human Errors ............................................................................................... 17-6

Overview of Oracle Flashback Features............................................................................... 17-7

Overview of LogMiner............................................................................................................ 17-7

Overview of Security Features for High Availability......................................................... 17-8

Overview of Planned Downtime ....................................................................................................... 17-8

System Maintenance....................................................................................................................... 17-8

Data Maintenance ........................................................................................................................... 17-9

Database Maintenance.................................................................................................................... 17-9

18 Partitioned Tables and Indexes

Introduction to Partitioning ................................................................................................................ 18-1

Partition Key .................................................................................................................................... 18-3

Partitioned Tables ........................................................................................................................... 18-3

Partitioned Index-Organized Tables ............................................................................................ 18-3

Overview of Partitioning Methods.................................................................................................... 18-3

Range Partitioning .......................................................................................................................... 18-4

Range Partitioning Example................................................................................................... 18-5

List Partitioning............................................................................................................................... 18-5

List Partitioning Example ....................................................................................................... 18-5

Hash Partitioning ............................................................................................................................ 18-6

Hash Partitioning Example .................................................................................................... 18-6

Composite Partitioning .................................................................................................................. 18-7

Composite Partitioning Range-Hash Example.................................................................... 18-7

Composite Partitioning Range-List Example ...................................................................... 18-8

When to Partition a Table .............................................................................................................. 18-9

Overview of Partitioned Indexes ....................................................................................................... 18-9

Local Partitioned Indexes............................................................................................................. 18-10

Global Partitioned Indexes .......................................................................................................... 18-10

Global Range Partitioned Indexes....................................................................................... 18-10

Global Hash Partitioned Indexes......................................................................................... 18-11

Maintenance of Global Partitioned Indexes....................................................................... 18-11

Global Nonpartitioned Indexes................................................................................................... 18-12

Miscellaneous Information about Creating Indexes on Partitioned Tables ......................... 18-12

Using Partitioned Indexes in OLTP Applications.................................................................... 18-13

Using Partitioned Indexes in Data Warehousing and DSS Applications ............................. 18-13

Partitioned Indexes on Composite Partitions ........................................................................... 18-13

Partitioning to Improve Performance.............................................................................................. 18-13

Partition Pruning........................................................................................................................... 18-13

Partition Pruning Example................................................................................................... 18-14

Partition-wise Joins....................................................................................................................... 18-14

Parallel DML.................................................................................................................................. 18-14

19 Content Management

Introduction to Content Management............................................................................................... 19-1

Overview of XML in Oracle ................................................................................................................ 19-2

Overview of LOBs................................................................................................................................. 19-3

xviii

Overview of Oracle Text....................................................................................................................... 19-3

Oracle Text Index Types................................................................................................................. 19-4

Oracle Text Document Services .................................................................................................... 19-4

Oracle Text Query Package............................................................................................................ 19-4

Oracle Text Advanced Features.................................................................................................... 19-4

Overview of Oracle Ultra Search........................................................................................................ 19-5

Overview of Oracle interMedia.......................................................................................................... 19-5

Overview of Oracle Spatial ................................................................................................................. 19-6

20 Database Security

Introduction to Database Security ..................................................................................................... 20-1

Database Users and Schemas ........................................................................................................ 20-1

Security Domain ...................................................................................................................... 20-1

Privileges .......................................................................................................................................... 20-2

Roles.................................................................................................................................................. 20-2

Storage Settings and Quotas.......................................................................................................... 20-2

Default Tablespace .................................................................................................................. 20-2

Temporary Tablespace ........................................................................................................... 20-2

Tablespace Quotas ................................................................................................................... 20-2

Profiles and Resource Limits.................................................................................................. 20-2

Overview of Transparent Data Encryption ...................................................................................... 20-3

Overview of Authentication Methods ............................................................................................. 20-4

Authentication by the Operating System ................................................................................... 20-4

Authentication by the Network ................................................................................................... 20-4

Third Party-Based Authentication Technologies ................................................................ 20-5

Public-Key-Infrastructure-Based Authentication................................................................ 20-5

Remote Authentication ........................................................................................................... 20-5

Authentication by the Oracle Database ...................................................................................... 20-5

Password Encryption .............................................................................................................. 20-6

Account Locking ..................................................................................................................... 20-6

Password Lifetime and Expiration ....................................................................................... 20-6

Password Complexity Verification ....................................................................................... 20-6

Multitier Authentication and Authorization ............................................................................. 20-7

Authentication by the Secure Socket Layer Protocol................................................................. 20-7

Authentication of Database Administrators .............................................................................. 20-7

Overview of Authorization ................................................................................................................ 20-8

User Resource Limits and Profiles................................................................................................ 20-9

Types of System Resources and Limits ................................................................................ 20-9

Profiles .................................................................................................................................... 20-11

Introduction to Privileges ............................................................................................................ 20-11

System Privileges ................................................................................................................... 20-12

Schema Object Privileges...................................................................................................... 20-12

Introduction to Roles .................................................................................................................... 20-12

Common Uses for Roles ....................................................................................................... 20-13

Role Mechanisms ................................................................................................................... 20-14

The Operating System and Roles ........................................................................................ 20-14

Secure Application Roles ............................................................................................................. 20-15

xix

Overview of Access Restrictions on Tables, Views, Synonyms, or Rows................................ 20-15

Fine-Grained Access Control....................................................................................................... 20-15

Dynamic Predicates .............................................................................................................. 20-16

Application Context...................................................................................................................... 20-16

Dynamic Contexts.................................................................................................................. 20-16

Fine-Grained Auditing................................................................................................................. 20-17

Overview of Security Policies .......................................................................................................... 20-17

System Security Policy ................................................................................................................. 20-18

Database User Management................................................................................................. 20-18

User Authentication............................................................................................................... 20-18

Operating System Security................................................................................................... 20-18

Data Security Policy...................................................................................................................... 20-18

User Security Policy...................................................................................................................... 20-19

General User Security............................................................................................................ 20-19

End-User Security .................................................................................................................. 20-19

Administrator Security.......................................................................................................... 20-20

Application Developer Security........................................................................................... 20-20

Application Administrator Security.................................................................................... 20-21

Password Management Policy.................................................................................................... 20-21

Auditing Policy.............................................................................................................................. 20-21

Overview of Database Auditing....................................................................................................... 20-21

Types and Records of Auditing .................................................................................................. 20-22

Audit Records and the Audit Trails.................................................................................... 20-23

21 Data Integrity

Introduction to Data Integrity............................................................................................................. 21-1

Types of Data Integrity .................................................................................................................. 21-3

Null Rule ................................................................................................................................... 21-3

Unique Column Values........................................................................................................... 21-3

Primary Key Values................................................................................................................. 21-3

Referential Integrity Rules...................................................................................................... 21-3

Complex Integrity Checking.................................................................................................. 21-3

How Oracle Enforces Data Integrity ........................................................................................... 21-3

Integrity Constraints Description.......................................................................................... 21-4

Database Triggers .................................................................................................................... 21-4

Overview of Integrity Constraints ..................................................................................................... 21-4

Advantages of Integrity Constraints ........................................................................................... 21-5

Declarative Ease ....................................................................................................................... 21-5

Centralized Rules..................................................................................................................... 21-5

Maximum Application Development Productivity............................................................ 21-5

Immediate User Feedback ...................................................................................................... 21-5

Superior Performance.............................................................................................................. 21-5

Flexibility for Data Loads and Identification of Integrity Violations............................... 21-6

The Performance Cost of Integrity Constraints ......................................................................... 21-6

Types of Integrity Constraints ............................................................................................................ 21-6

NOT NULL Integrity Constraints ................................................................................................ 21-6

UNIQUE Key Integrity Constraints ............................................................................................ 21-7

Unique Keys.............................................................................................................................. 21-7

UNIQUE Key Constraints and Indexes................................................................................ 21-8

Combine UNIQUE Key and NOT NULL Integrity Constraints....................................... 21-9

PRIMARY KEY Integrity Constraints ......................................................................................... 21-9

Primary Keys ............................................................................................................................ 21-9

PRIMARY KEY Constraints and Indexes........................................................................... 21-10

Referential Integrity Constraints ................................................................................................ 21-10

Self-Referential Integrity Constraints.................................................................................. 21-12

Nulls and Foreign Keys......................................................................................................... 21-13

Actions Defined by Referential Integrity Constraints...................................................... 21-13

Concurrency Control, Indexes, and Foreign Keys............................................................ 21-14

CHECK Integrity Constraints ..................................................................................................... 21-16

The Check Condition............................................................................................................. 21-16

Multiple CHECK Constraints .............................................................................................. 21-17

The Mechanisms of Constraint Checking ...................................................................................... 21-17

Default Column Values and Integrity Constraint Checking ................................................. 21-19

Deferred Constraint Checking.......................................................................................................... 21-19

Constraint Attributes ................................................................................................................... 21-19

SET CONSTRAINTS Mode ........................................................................................................ 21-19

Unique Constraints and Indexes ................................................................................................ 21-20

Constraint States.................................................................................................................................. 21-20

Constraint State Modification...................................................................................................... 21-21

22 Triggers

Introduction to Triggers ...................................................................................................................... 22-1

How Triggers Are Used ................................................................................................................ 22-2

Some Cautionary Notes about Triggers .............................................................................. 22-3

Triggers Compared with Declarative Integrity Constraints ............................................. 22-4

Parts of a Trigger.................................................................................................................................... 22-5

The Triggering Event or Statement ............................................................................................. 22-5

Trigger Restriction .......................................................................................................................... 22-6

Trigger Action ................................................................................................................................. 22-6

Types of Triggers ................................................................................................................................... 22-7

Row Triggers and Statement Triggers ........................................................................................ 22-7

Row Triggers ........................................................................................................................... 22-7

Statement Triggers .................................................................................................................. 22-7

BEFORE and AFTER Triggers ...................................................................................................... 22-7

BEFORE Triggers .................................................................................................................... 22-8

AFTER Triggers ....................................................................................................................... 22-8

Trigger Type Combinations .................................................................................................. 22-8

INSTEAD OF Triggers ................................................................................................................... 22-9

Modify Views .......................................................................................................................... 22-9

Views That Are Not Modifiable ............................................................................................ 22-9

INSTEAD OF Triggers on Nested Tables .......................................................................... 22-10

Triggers on System Events and User Events ............................................................................ 22-10

Event Publication .................................................................................................................. 22-11

Event Attributes .................................................................................................................... 22-11

剩余541页未读，继续阅读

efjioe

粉丝: 0

Oracle 10g概念实战：英文版数据库经典指南

oracle 10g concepts

Oracle 10g Concepts 中文版

Oracle 10g Concepts （Oracle 10g 概念中文手册）——破解版！！

Oracle 10G concepts(中英文对照)

Oracle 10g Concepts 深入解析

Oracle 10g Concepts 中英文对照版

Oracle10g Concepts：数据库详解与应用

Oracle 10g Concepts详解：数据库架构与特性

Oracle 10g Concepts: 数据库架构与特性解析

Oracle 10g Concepts 中文指南：数据库架构与核心概念

最新资源