Sumário Itens Encontrados: 112Preface xi1. Introducing Oracle 1The Evolution of the Relational Database 2The Oracle Database Family 7Summary of Oracle Database Features 9Database Application Development Features 9Database Connection Features 13Distributed Database Features 17Data Movement Features 18Database Performance Features 20Database Management Features 23Database Security Features 27Oracle Development Tools 28Embedded Databases 312. Oracle Architecture 33Databases and Instances 33Deploying Physical Components 38Instance Memory and Processes 48The Data Dictionary 543. Installing and Running Oracle 56Installing Oracle 56Creating a Database 59Configuring Oracle Net 63Starting Up the Database 68Shutting Down the Database 69Accessing a Database 70Oracle at Work 774. Oracle Data Structures 82Datatypes 82Basic Data Structures 90Additional Data Structures 98Extended Logic for Data 100Data Design 102Constraints 104Triggers 107Query Optimization 108Understanding the Execution Plan 118SQL Advisors 120Data Dictionary Tables 1205. Managing Oracle 122Manageability Features 124Oracle Enterprise Manager 126Fragmentation and Reorganization 132Backup and Recovery 133Working with Oracle Support 1376. Oracle Security, Auditing, and Compliance 139Security 139Auditing 150Compliance 1517. Oracle Performance 154Performance Tuning Basics 154Oracle and Disk I/O Resources 160Oracle and Parallelism 169Oracle and Memory Resources 176Oracle and CPU Resources 182Database Resource Manager 1848. Oracle Multiuser Concurrency 186Basics of Concurrent Access 187Oracle and Concurrent User Access 190Oracleâs Isolation Levels 191Oracle Concurrency Features 192How Oracle Handles Locking 194Concurrent Access and Performance 197Workspaces 1989. Oracle and Transaction Processing 201OLTP Basics 201Oracleâs OLTP Heritage 205Architectures for OLTP 206Oracle Features for OLTP 211High Availability 217Oracle Streams and Advanced Queuing 218Object Technologies and Distributed Components 22110. Oracle Data Warehousing and Business Intelligence 222Business Intelligence Basics 223Data Warehouse Design 227Query Optimization 230Analytics, OLAP, and Data Mining in the Database 233Managing the Data Warehouse 236Other Software for the Data Warehouse 236The Metadata Challenge 248Best Practices 24911. Oracle and High Availability 253What Is High Availability? 254System Failure 257Protecting Against System Failure 262Recovering from Failures 275Complete Site Failure 281Data Redundancy Solutions 285Rolling Upgrades 28912. Oracle and Hardware Architecture 290System Basics 290Uniprocessor Systems 292Symmetric Multiprocessing Systems 293Clusters 295Non-Uniform Memory Access Systems 298Grid Computing 299Disk and Storage Technology 300Which Platform Deployment Solution? 30213. Oracle Distributed Databases and Distributed Data 305Accessing Multiple Databases As a Single Entity 305Moving Data Between Distributed Systems 31014. Oracle Extended Datatypes 318Object-Oriented Development 318Extensibility Features and Options 324Using the Extensibility Framework in Oracle 32915. Beyond the Oracle Database 331Application Express 331Oracle Fusion Middleware 332Oracle SOA Suite 345A. Whatâs New in This Book for Oracle Database 11g 349B. Additional Resources 356Index 365