Oracle Database 12c Plug In. Switch On. Get SMART.

(1)

(2)

Oracle Database 12c

Plug In. Switch On. Get SMART.

Duncan Harvey

Head of Core Technology, Oracle EMEA

March 2015

(3)

Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a

commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Oracle Confidential 3

(4)

Provide continued access to data

Why… Oracle Database 12c

Reduce the cost of storing data

Simplify the consolidation of Oracle databases

Ensure secure access to data

Public 4

(5)

Why... Plug In. Switch On. Get SMART

• Plug In

– Multitenant and pluggable databases for maximum consolidation performance

• Switch On

– Literally “switch on” setup for Oracle Database In-Memory performance

• Get S.M.A.R.T

– Simplify your database infrastructure – Manage many databases as one

– Agile database provisioning and performance – Real-time analysis and results

– Technology that meets your needs today and tomorrow

5

(6)

Oracle Database : Non-stop Innovation

Because of you, Oracle never stops innovating and moving forward

Stored Procedures Partitioning Parallel Query Unstructured Data

Resource Management Real Application Clusters

Data Guard XML

Exadata Multitenant

In-Memory JSON

Big Data & Cloud Internet

Client-Server

(7)

Oracle Database 12c (12.1.0.1)

Oracle Multitenant

• Database consolidation

• Fast Provisioning

• Manage many as one

Oracle Automatic Data Optimization

• Smart Compression

• Automate Tiering

Data Guard Far Sync

• Zero data loss over large distances

Public 7

(8)

Oracle Database 12c (12.1.0.1)

Application Continuity

• Replay of failed transaction

Data Redaction

• Masks application data dynamically

• Largely transparent to application

Pattern Matching

• Sophisticated inter row pattern analysis

And over 500 additional improvements…

Public 8

(9)

Oracle Innovations in the last 12 Months

Database

• 12.1.0.2

• In-Memory

9

Big Data & No SQL

• Hadoop Encryption

• NoSQL 3.0-3.2.5

• Big Data SQL

Developers

• SQL/JSON ANSI Standard

• REST Data Services

• JSON support

Engineered Systems

• Exadata X5-2

• ODA X5-2

• BDA X5-2

• Exadata X4-8

• Recovery Appliance

Public Cloud

• Backup Service

• Database Service

Security

• Key Vault

• Data Masking & Subsetting

(10)

Security & Compliance

Big Data & Data Warehousing Consolidation

Database as a Service Application Development

High Availability In-Memory

Performance & Scalability Data Optimization

10

(11)

Oracle Database 12c Upgrade Experience

Quotes from Non-reference Customers

• “We were successful with the production go-live, and even finished more quickly than planned.”

– Insurance company running PeopleSoft on 12.1.0.1

• “In test the 10g to 12c upgrade of a copy of production took approximately 1.5 hour on a virtual machine with 8GB SGA . Upgraded completed without a hitch. “

– Capital management company upgrading 10g to 12c, OL5 to OL6, and block devices to Direct NFS

• “Our experience with 12c is excellent, we had to have a few patches added to the base installation (issues discovered during the RAT replays)”

– Well known international research institute running several 12.1 RAC databases

• “Very little optimizer mis-behaviour compared to previous release changes”

– Independent Oracle upgrade consultant experience from various customer upgrades

11

(12)

Oracle Database 12c In-Memory Customer Experience

12

Schneider Electric analysis of up to 2 billion General Ledger entries

0 20 40 60 80 100

2B 300K 30K

S e c o n d s

Analytics Query Results

Row Format Column Format

• Analytic queries 7-128x faster

• OLTP transactions 5-9x faster

• 76% storage savings

(13)

Customer Initiatives

Big Data

Database as a Service

Cloud

(14)

Source: Computerworld Strategic Marketing Services, February-March 2014 Cloud Survey

52 ^%

Application Dev/Test

Development, Testing and Deployment in the Cloud

Most popular cloud use case in the next two years

39 ^%

(15)

Dev, Test, and Deploy on Oracle Database Cloud Service

15

On Premises

Traditional Deployment or Private Cloud

Database Cloud Service

(Oracle Cloud) Easily migrate between cloud and on-premises

Same Architecture Same Standards

Same Products

Dev, Test, Deploy

(16)

Journey to Hybrid Database as a Service

Silos

Complex

Standardized

Simple

Consolidated

Efficient

Cloud

Agile

(17)

Co nsoli da tio n Density

Database Consolidation on Clouds

Traditional consolidation methods

17

Share Servers Share Servers & OS Share Servers, OS, & Database

Virtual Machines Dedicated Databases Schema Consolidation

(18)

Co nsoli da tio n Density

Oracle Multitenant : Foundation for Hybrid Cloud

High consolidation density, transparent to existing applications

18

Share Servers Share Servers & OS Share Servers, OS, & Database

Virtual Machines Dedicated Databases Pluggable Databases

(19)

Oracle Database Architecture

Requires memory, processes and database files

19

ERP CRM DW

System Resources

(20)

New Multitenant Architecture

Memory and processes require at container level only

20

ERP CRM DW

System Resources

ERP CRM DW

(21)

Oracle Database Architecture

More efficient utilization of system resources

21

System Resources

ERP CRM DW

(22)

Delivering Database as a Service

Oracle Enterprise Manager, Oracle Multitenant and Oracle Exadata

26

(23)

Database Protection Without Compromise

Oracle Zero Data Loss Recovery Appliance

000s of Databases

Redo and change data

Validated and compressed changes

Replicate changes

offsite to the Cloud

(24)

Customer Initiatives

Database as a Service

Cloud Big Data

(25)

Engineered for Big Data & Data Warehousing

Oracle Confidential – Internal/Restricted/Highly Restricted 33

(26)

Integrating Hadoop, NoSQL and Oracle Database

• Data ingestion

• Batch processing

• HDFS, NoSQL Database

• Scale-out storage

• Java, Pig, Hive, etc

• Data analysis

• Interactive and batch

• Oracle Database

• Scale-out smart storage

• Rich SQL and R analytics

Oracle Big Data Appliance Oracle Exadata

(27)

“ Find transactions that suggest fraudulent activity”

Big Data Analytics

Scalable discovery of business events

• Recognize event patterns in sequence

• Simplify and scale analysis of Big Data

• Find answers as quickly as possible

(28)

Simplifying Big Data Analytics

SQL Pattern Matching with Oracle Database 12c

• Clickstream logs:

– sessionization, search behaviour

• Business transactions:

– fraud detection, stock analysis

• Sensor data:

– Automated observations and detections

**Select * from**

Transactions MATCH_RECOGNIZE (

…

PATTERN(S X{2,4} Y) DEFINE S AS (type = T),

X AS (loc = PREV(loc)), Y AS (loc != PREV(loc))

…

)

Possible fraudulent banking transactions defined as regular expression

Ascend in g Ord er

(29)

Oracle Database 12.1.0.2

Flexible Schema development

JSON JSON

Via RESTful service

Via Native APIs

Data persisted in database In JSON

SQL

Data analyzed via SQL Oracle Database 12c

JSON

(30)

Oracle Database 12c JSON Support

 Store and manage JSON documents in Oracle Database

• JSON documents stored as text (varchar2 or CLOB), or binary (raw or BLOB) for BSON

• JSON documents can be indexed

– Full text index (inverted index) on entire JSON documents – Functional indexes on specific attributes