Oracle Essentials: Oracle Database 12c
What you need to know about Oracle Databse Architecture and Features
Paperback Engels 2013 5e druk 9781449343033Samenvatting
Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle's product line, including its architecture, data structures, networking, concurrency, and tuning.
Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. 'Oracle Essentials' provides the conceptual background you need to understand how Oracle truly works.
Topics include:
- A complete overview of Oracle databases and data stores, and Fusion Middleware products and features
- Core concepts and structures in Oracle's architecture, including pluggable databases
- Oracle objects and the various datatypes Oracle supports
- System and database management, including Oracle Enterprise Manager 12c
- Security options, basic auditing capabilities, and options for meeting compliance needs
- Performance characteristics of disk, memory, and CPU tuning
- Basic principles of multiuser concurrency
- Oracle's online transaction processing (OLTP)
- Data warehouses, Big Data, and Oracle's business intelligence tools
- Backup and recovery, and high availability and failover solutions
Specificaties
Lezersrecensies
Inhoudsopgave
1. Introducing Oracle
-The Evolution of the Relational Database
-The Oracle Database Family
-Summary of Oracle Database Features
-Database Application Development Features
-Database Connection Features
-Distributed Database Features
-Data Movement Features
-Database Performance Features
-Database Management Features
-Database Security Features
-Oracle Development Tools
-Embedded Databases
2. Oracle Architecture
-Databases and Instances
-Deploying Physical Components
-Instance Memory and Processes
-The Data Dictionary
3. Installing and Running Oracle
-Installing Oracle
-Creating a Database
-Configuring Oracle Net
-Starting Up the Database
-Shutting Down the Database
-Accessing a Database
-Oracle at Work
4. Oracle Data Structures
-Datatypes
-Basic Data Structures
-Additional Data Structures
-Extended Logic for Data
-Data Design
-Constraints
-Triggers
-Query Optimization
-Understanding the Execution Plan
-SQL Advisors
-Data Dictionary Tables
5. Managing Oracle
-Manageability Features
-Oracle Enterprise Manager
-Fragmentation and Reorganization
-Backup and Recovery
-Working with Oracle Support
6. Oracle Security, Auditing, and Compliance
-Security
-Auditing
-Compliance
7. Oracle Performance
-Performance Tuning Basics
-Oracle and Disk I/O Resources
-Oracle and Parallelism
-Oracle and Memory Resources
-Oracle and CPU Resources
-Database Resource Manager
-Basics of Concurrent Access
-Oracle and Concurrent User Access
-Oracle's Isolation Levels
-Oracle Concurrency Features
-How Oracle Handles Locking
-Concurrent Access and Performance
-Workspaces
9. Oracle and Transaction Processing
-OLTP Basics
-Oracle's OLTP Heritage
-Architectures for OLTP
-Oracle Features for OLTP
-High Availability
-Oracle Streams and Advanced Queuing
-Object Technologies and Distributed Components
10. Oracle Data Warehousing and Business Intelligence
-Business Intelligence Basics
-Data Warehouse Design
-Query Optimization
-Analytics, OLAP, and Data Mining in the Database
-Managing the Data Warehouse
-Other Software for the Data Warehouse
-The Metadata Challenge
-Best Practices
11. Oracle and High Availability
-What Is High Availability?
-System Failure
-Protecting Against System Failure
-Recovering from Failures
-Complete Site Failure
-Data Redundancy Solutions
-Rolling Upgrades
12. Oracle and Hardware Architecture
-System Basics
-Uniprocessor Systems
-Symmetric Multiprocessing Systems
-Clusters
-Non-Uniform Memory Access Systems
-Grid Computing
-Disk and Storage Technology
-Which Platform Deployment Solution?
13. Oracle Distributed Databases and Distributed Data
-Accessing Multiple Databases As a Single Entity
-Moving Data Between Distributed Systems
14. Oracle Extended Datatypes
-Object-Oriented Development
-Extensibility Features and Options
-Using the Extensibility Framework in Oracle
15. Beyond the Oracle Database
-Application Express
-Oracle Fusion Middleware
-Oracle SOA Suite
Appendix A: What's New in This Book for Oracle Database 11g
Appendix B: Additional Resources
Index
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan