Oracle Essentials: Oracle Database 11g (Essentials)

  Author:    Rick Greenwald, Robert Stackowiak, Jonathan Stern
  ISBN:    0596514549
  Sales Rank:    72155
  Published:    2007-11-15
  Publisher:    O'Reilly Media, Inc.
  # Pages:    352
  Binding:    Paperback
  Avg. Rating:    5.0 based on 4 reviews
  Used Offers:    8 from $22.37
  Amazon Price:    $26.39
  (Data above last updated:  2008-09-06 04:58:39 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
Oracle Essentials: Oracle Database 11g (Essentials)
  
Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g.

This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on:
  • Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i)


  • Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition)


  • Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing)


  • Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider
The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types)

For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.

"Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases."

--Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation
                  Reader Reviews 1 - 4 of 4                 
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
09-05-08 4 (NA)
(Hide Review...)  Very informative book!
Reviewer Permalink
This book is well written and organized. It provides a comprehensive overview of Oracle features and technologies, including the latest Oracle database 11g for begineers. The focus is on principles rather than syntax, such as Oracle security & auditing, performance, multiuser concurrency, transaction processing and high availability.
(Review Data Last Updated: 2008-09-06 05:01:43 EST)
04-04-08 5 (NA)
(Hide Review...)  A comprehensive reference for new and old users alike!
Reviewer Permalink
The 4th updated edition of ORACLE ESSENTIALS is a must for any library strong in databases in general and Oracle in particular, offering an easily-read reference packed with tips on data structures, installation, networking, and customization processes. Features beyond the Oracle database: Express, Fusion Middleware, and more - compliment specifics on the latest Oracle Database 11g, providing a comprehensive reference for new and old users alike!

Diane C. Donovan
California Bookwatch
(Review Data Last Updated: 2008-09-05 05:01:57 EST)
12-07-07 5 2\3
(Hide Review...)  Clearly explains the inner workings of Oracle
Reviewer Permalink
Oracle Essentials, Oracle Database 11g, 4th edition
Rick Greenwald et al.
O'Reilly - 4th Edition (11g)
http://www.oreilly.com/catalog/9780596514549/index.html

This is a very detailed overview of the inner workings of Oracle. Each chapter is a small book in itself going into the detail of the subject. This might be confusing to those without a clear understanding of how databases work in general, and a background in computer science would help. Overall, the author does a nice job of explaining each topic in such a way that it would be reasonably clear either way though. There are many diagrams, tables, lists, and pictures to help explain the material. This would not be so much a reference for programming Oracle as it explains what is available in Oracle and how Oracle provides its features. The book should be usefully to Oracle DBAs and system administrators. It will also appeal to those that want a book that goes beyond stating what Oracle can do and shows how Oracle actually does what it can do.

Generally chapters cover:

Overview
Architecture
Installation and Running
Data Structures (B*-trees, etc.)
Management
Security
Performance
Concurrency
Transactions
Warehousing, Business Intelligence
Availability
Hardware
Distributed Databases
Object Oriented Development
New Features of 11g

Summary:

- The internal workings of Oracle are clearly explained through out.
- A great book for system administrator, DBAs, and those who take care of Oracle databases.
(Review Data Last Updated: 2008-04-04 18:44:27 EST)
11-19-07 5 1\2
(Hide Review...)  Does a great job of explaining 11g and how to use it
Reviewer Permalink
This book is for people of all levels of Oracle experience and includes database administrators, system administrators, and application developers. Even though there is some introductory material that more experienced people might be tempted to skip over, it is probably best to go through the book from beginning to end just to make sure you don't miss some minute point of Oracle. It does not try to teach database theory, though. You need to be familiar with that in a general sense before you read this book.

The main purpose of this fourth edition is to add information relevant to the newest release, Oracle Database 11g. Appendix A is handy in that it contains, in a condensed form, what is new for 11g. The book manage to concentrate on the most important Oracle issues and principles. It isn't possible to write one book that encompasses everything about Oracle, particularly syntax details, so you'll need to refer to Oracle documentation for complete details. The following is the table of contents of the book, which is currently not included in the product description:

Chapter 1. Introducing Oracle
Section 1.1. The Evolution of the Relational Database
Section 1.2. The Oracle Database Family
Section 1.3. Summary of Oracle Database Features
Section 1.4. Database Application Development Features
Section 1.5. Database Connection Features
Section 1.6. Distributed Database Features
Section 1.7. Data Movement Features
Section 1.8. Database Performance Features
Section 1.9. Database Management Features
Section 1.10. Database Security Features
Section 1.11. Oracle Development Tools
Section 1.12. Embedded Databases

Chapter 2. Oracle Architecture
Section 2.1. Databases and Instances
Section 2.2. Deploying Physical Components
Section 2.3. Instance Memory and Processes
Section 2.4. The Data Dictionary

Chapter 3. Installing and Running Oracle
Section 3.1. Installing Oracle
Section 3.2. Creating a Database
Section 3.3. Configuring Oracle Net
Section 3.4. Starting Up the Database
Section 3.5. Shutting Down the Database
Section 3.6. Accessing a Database
Section 3.7. Oracle at Work

Chapter 4. Oracle Data Structures
Section 4.1. Datatypes
Section 4.2. Basic Data Structures
Section 4.3. Additional Data Structures
Section 4.4. Extended Logic for Data
Section 4.5. Data Design
Section 4.6. Constraints
Section 4.7. Triggers
Section 4.8. Query Optimization
Section 4.9. Understanding the Execution Plan
Section 4.10. SQL Advisors
Section 4.11. Data Dictionary Tables

Chapter 5. Managing Oracle
Section 5.1. Manageability Features
Section 5.2. Oracle Enterprise Manager
Section 5.3. Fragmentation and Reorganization
Section 5.4. Backup and Recovery
Section 5.5. Working with Oracle Support

Chapter 6. Oracle Security, Auditing, and Compliance
Section 6.1. Security
Section 6.2. Auditing
Section 6.3. Compliance

Chapter 7. Oracle Performance
Section 7.1. Performance Tuning Basics
Section 7.2. Oracle and Disk I/O Resources
Section 7.3. Oracle and Parallelism
Section 7.4. Oracle and Memory Resources
Section 7.5. Oracle and CPU Resources
Section 7.6. Database Resource Manager

Chapter 8. Oracle Multiuser Concurrency
Section 8.1. Basics of Concurrent Access
Section 8.2. Oracle and Concurrent User Access
Section 8.3. Oracle's Isolation Levels
Section 8.4. Oracle Concurrency Features
Section 8.5. How Oracle Handles Locking
Section 8.6. Concurrent Access and Performance
Section 8.7. Workspaces

Chapter 9. Oracle and Transaction Processing
Section 9.1. OLTP Basics
Section 9.2. Oracle's OLTP Heritage
Section 9.3. Architectures for OLTP
Section 9.4. Oracle Features for OLTP
Section 9.5. High Availability
Section 9.6. Oracle Streams and Advanced Queuing
Section 9.7. Object Technologies and Distributed Components

Chapter 10. Oracle Data Warehousing and Business Intelligence
Section 10.1. Business Intelligence Basics
Section 10.2. Data Warehouse Design
Section 10.3. Query Optimization
Section 10.4. Analytics, OLAP, and Data Mining in the Database
Section 10.5. Managing the Data Warehouse
Section 10.6. Other Software for the Data Warehouse
Section 10.7. The Metadata Challenge
Section 10.8. Best Practices

Chapter 11. Oracle and High Availability
Section 11.1. What Is High Availability?
Section 11.2. System Failure
Section 11.3. Protecting Against System Failure
Section 11.4. Recovering from Failures
Section 11.5. Complete Site Failure
Section 11.6. Data Redundancy Solutions
Section 11.7. Rolling Upgrades

Chapter 12. Oracle and Hardware Architecture
Section 12.1. System Basics
Section 12.2. Uniprocessor Systems
Section 12.3. Symmetric Multiprocessing Systems
Section 12.4. Clusters
Section 12.5. Non-Uniform Memory Access Systems
Section 12.6. Grid Computing
Section 12.7. Disk and Storage Technology
Section 12.8. Which Platform Deployment Solution?

Chapter 13. Oracle Distributed Databases and Distributed Data
Section 13.1. Accessing Multiple Databases As a Single Entity
Section 13.2. Moving Data Between Distributed Systems

Chapter 14. Oracle Extended Datatypes
Section 14.1. Object-Oriented Development
Section 14.2. Extensibility Features and Options
Section 14.3. Using the Extensibility Framework in Oracle

Chapter 15. Beyond the Oracle Database
Section 15.1. Application Express
Section 15.2. Oracle Fusion Middleware
Section 15.3. Oracle SOA Suite

Appendix A. What's New in This Book for Oracle Database 11g
Section A.1. Introducing Oracle
Section A.2. Oracle Architecture
Section A.3. Installing and Running Oracle
Section A.4. Data Structures
Section A.5. Managing Oracle
Section A.6. Oracle Security, Auditing, and Compliance
Section A.7. Oracle Performance
Section A.8. Oracle Multiuser Concurrency
Section A.9. Oracle and Transaction Processing
Section A.10. Oracle Data Warehousing and Business Intelligence
Section A.11. Oracle and High Availability
Section A.12. Oracle and Hardware Architecture
Section A.13. Oracle Distributed Databases and Distributed Data
Section A.14. Oracle Extended Datatypes
Section A.15. Beyond the Oracle Database

Appendix B. Additional Resources
Section B.1. Web Sites
Section B.2. Books and Oracle Documentation
(Review Data Last Updated: 2007-12-08 11:08:55 EST)
  
                  Reader Reviews 1 - 4 of 4                 
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated
Iraq Top Rated
Supreme Court Top Rated
All Books Top Rated
Arts Top Rated
Photography Top Rated
Digital Photography Top Rated
Digital Cameras Top Rated
Biography Top Rated
Business Top Rated
Management Top Rated
Marketing Top Rated
Sales Top Rated
Stocks Top Rated
Bonds Top Rated
Real Estate Top Rated
Trading Top Rated
Commodities Trading Top Rated
Time Management Top Rated
Starting A Business Top Rated
Children's Top Rated
Comics Top Rated
Computers Top Rated
PC Top Rated
Mac Top Rated
Programming Top Rated
Design Patterns Top Rated
.Net Top Rated
C# Top Rated
Vb.Net Top Rated
Asp.Net Top Rated
Java Top Rated
Python Top Rated
PHP Top Rated
Perl Top Rated
Javascript Top Rated
Ajax Top Rated
CSS Top Rated
Open Source Top Rated
SQL Top Rated
Databases Top Rated
Oracle Top Rated
MySql Top Rated
Sql Server Top Rated
IIS Top Rated
Apache Top Rated
Linux Top Rated
Windows Server Top Rated
Project Management Top Rated
HTML Top Rated
UML Top Rated
IT Certifications Top Rated
Cisco Certifications Top Rated
MCSE Top Rated
MCSD Top Rated
Cooking Top Rated
Italian Cooking Top Rated
Vegetarian Cooking Top Rated
Wine Top Rated
Engineering Top Rated
Entertainment Top Rated
Health Top Rated
Nutrition Top Rated
Dieting Top Rated
Sex Top Rated
History Top Rated
Military History Top Rated
British History Top Rated
Middle East History Top Rated
Land Battles Top Rated
Naval Warfare Top Rated
Air Warfare Top Rated
9/11 Top Rated
Terrorism Top Rated
Home Top Rated
Mortgage\Home Equity Loan Top Rated
Cars Top Rated
Car Buying Top Rated
Sports Cars Top Rated
Cat Top Rated
Humor Top Rated
Horror Top Rated
Law Top Rated
IP Law Top Rated
Legal History Top Rated
Fiction Top Rated
Oprah's Book Club Top Rated
Medicine Top Rated
Cancer Top Rated
Stroke Top Rated
Heart Disease Top Rated
Fertility Top Rated
Diabetes Top Rated
Pharmacology Top Rated
Back Problems Top Rated
Menopause Top Rated
Thyroid Top Rated
Pain Top Rated
Organic Chemistry Top Rated
Immune System Top Rated
Mystery Top Rated
Nonfiction Top Rated
Outdoors Top Rated
Running Top Rated
Radio Control Models Top Rated
Guns Top Rated
Parenting Top Rated
Divorce Top Rated
Professional Top Rated
Reference Top Rated
Religion Top Rated
Romance Top Rated
Science Top Rated
Physics Top Rated
Chemistry Top Rated
Astronomy Top Rated
Psychology Top Rated
Science Fiction Top Rated
Sports Top Rated
Teens Top Rated
Travel Top Rated
USA Top Rated
Europe Top Rated
France Top Rated
Italy Top Rated
England Top Rated
China Top Rated
All Books Arts Biography Click Here For An A-Z Index Of All 213 Best-Seller Subjects Business Children's Comics
Computers Cooking Engineering Entertainment Health History Home Horror Humor Law Fiction Medicine Mystery
Nonfiction Outdoors Parenting Professional Reference Religion Romance Science Sci-Fi Sports Teens Travel
In Association with Amazon.com

Cache miss
(not cached)