Databases Reference
In-Depth Information
Chapter 8: Oracle Multiuser Concurrency
The ability to handle very large groups of users without excessive contention, while
protecting data integrity, has long been one of the best features of the Oracle database
and a core part of the Oracle database for over 20 years. This chapter also covers work‐
spaces—the query optimizer was further improved in Oracle Database 12
c
in support
of them.
Chapter 9: Oracle and Transaction Processing
Oracle has been one of the leading databases for OLTP for many years. New features in
Oracle Database 12
c
include:
Transaction Guard
Provides an API enabling developers to build code that determines a transaction's
state.
Application Continuity
Enables creation of database requests to take action using information provided by
Transaction Guard.
Chapter 10: Oracle Data Warehousing and Business
Intelligence
In addition to covering the Oracle database for data warehousing, this chapter describes
Oracle's current suites of business intelligence tools and business intelligence applica‐
tions. New in this edition is a description of the Advanced Analytics Option, the role
of Big Data and Hadoop, and descriptions of how engineered systems are used for query
optimization and analyses. For example, how Hybrid Columnar Compression and flash
in Exadata are used to improve query performance is described. New features in Oracle
Database 12
c
include:
Data Mining enhancements in the Advanced Analytics Option
A new probabilistic clustering algorithm, Expectation Maximization, was added to
solve problems such as finding the most representative customer in the largest
cluster. Other improvements to Data Mining features include Generalized Linear
Model feature selection and creation, and simplified model building, deployment,
and testing for unstructured text data.
SQL Pattern Matching
SQL capability added for matching patterns in multiple rows of data tied to a data
item of interest.
