Data MGMT Foundations

Oracle
Tech for
Knowledge
Knowledge
Empowering
Data Management
Foundations
Certification Exam
Alexandre Fagundes
[email protected]
Cloud Architect, Oracle Latin America
Why become Oracle certified?
Make you a better technologist 
Preparing for an Oracle Certification Exam will assess & challenge your ability to think & perform.
Earning a highly recognized and valued Oracle Certification will improve your job prospects and job stability!
Accelerate your career growth, became a better technologist \o/
2
Oracle Cloud Infrastructure Data Management Platform
OCI Certifications
Basics
Data Scientist Security

Professional
Extensive experience
designing, implementing,
and operating advanced,
large-scale solutions Developer DevOps
using Oracle Cloud
Infrastructure.
Architect Operations
Associate
Experience in designing and
implementing solutions using
Oracle Cloud Infrastructure
Architect
Foundations
Learn about Cloud concepts and

Oracle Cloud Infrastructure
3 fundamentals.
OCI Data Management Foundations
4
Exam Topics
 Explain Oracle's Data Management Strategy

 Converged Database
 Discuss multi-cloud and hybrid cloud options
 Autonomous Database and Tools
 Exadata and DBCS
 MySQL and NoSQL
 Resiliency
 Developing an Oracle Database
 Data Lake, Data Warehouse and Machine Learning
 Upgrades and Migrations
5
Cloud Basics
Key terminology
High Availability: A system type with redundant components that provides consistent and
uninterrupted service, even in the event of hardware or software failures
Scalability: The ability to add additional nodes to database environments thereby maintaining
and achieving improved performance
Rolling upgrades: The process where software is developed continuously and the updates are
released in between the major releases. These updates are compatible with earlier versions where
complete re-installation of the software is not required.
Failover: A method of protecting computer systems from failure, in which standby equipment
automatically takes over when the main system fails
Recovery Point Objective (RPO): Tolerance for data loss (sec’s, hours, days); determines
frequency of backups and replication approaches
Recovery Time Objective (RTO): The shorter the Recovery Time Objective (RTO) the quicker you
get back to business
7 Copyright © 2024, Oracle and/or its affiliates | Confidential: Internal

Oracle Data Platform: A complete suite of services
Oracle Data Platform
Integration AI/ML Analytics

Data Sources Business Outcomes
OCI Data OCI Digital
Speech Vision Language Generative AI Classification * Science Assistant
Data Management
Enterprise Data OCI Data Oracle or
Applications data Growth and
& Applications Integration Any Business
Resilience
Applications
Autonomous Oracle Database Exadata MySQL No SQL

Transaction Processing Cloud Service Cloud Service HeatWave Database
ERP CRM Oracle
OIC
Analytics Cloud
Enterprise SaaS (Application Better Forecasts
Applications Integration) Data Warehousing/Analytics Other Open-Source databases and Predictions
☑️ Any
SaaS
Autonomous
Data Warehouse MySQL HeatWave OpenSearch PostgreSQL Redis
GoldenGate Operational
GoldenGate
Social (RT Data Efficiency
IoT Stream
Media Replication) Big Data and Data Lake Analytics
Any
OCI Applications
Data Flow Big Data Data Lake Query Service* Lower
Costs
OCI Data Access, Security, and Governance
Digital Assets Streaming
Identity and Access

Data Catalog Management
8 Copyright © 2024, Oracle and/or its affiliates

Copyright © 2024 Oracle and/or its affiliates.
Oracle Cloud Infrastructure Global Footprint

Stockholm
Amsterdam
Montreal
Frankfurt NEW
London
Israel 2
Toronto
Israel 2 Mumbai
Zurich Dubai
Newport Saudi Arabia 2 Chuncheon
Chicago Hyderabad
Serbia
NEW Madrid
Jerusalem
Milan
Saudi Arabia 3
San Jose Paris Marseille
Abu Dhabi
Ashburn Kenya
Vinhedo NEW Seoul
Phoenix
Jeddah
Singapore 2 Tokyo
Singapore
Bogotá
Osaka
São Paulo
Johannesburg
Queretaro
Santiago
Valparaíso NEW
Monterrey
Melbourne
Sydney
February 2024 Canberra NEW
48 regions; 5 more planned Commercial

Commercial Planned
12 Azure Interconnect Regions Sovereign
Government
Microsoft Interconnect Azure
Service Models
Traditional IT Infrastructure-as- Platform-as-a- Software-as-a-
a-service (IaaS) service (PaaS) service (SaaS)
You Manage
Applications Applications Applications Applications
Data Data Data Data
You Manage
Runtime Runtime Runtime Runtime
Delivered as-a-service
Middleware Middleware Middleware Middleware
You Manage
Operating System Operating System Operating System Operating System
Virtualization Virtualization Virtualization Virtualization
Servers Servers Servers Servers
Storage Storage Storage Storage
Networking Networking Networking Networking
10
Database
Convergence
Organizations typically use many database silos
Types of databases
Data Machine
Lines of Business OLTP Warehouse Document Learning Graph Spatial Blockchain
Finance
Supply Chain
Human Resources
Sales & Marketing
Using multiple databases per application creates complexity and risk
12 Copyright © 2024, Oracle and/or its affiliates. All rights reserved.

Oracle Database’s complete capabilities enable database convergence
Multiple data types Multiple workloads

Structured: Relational, Graph, Avro, Transactional: OLTP, IOT,
Parquet, Blockchain distributed, key-value
Unstructured: Geospatial, XML, Analytical: Data warehouse, data
JSON, Text lake, operational intelligence,
Modularize and containerize machine learning, multi-
databases by application service dimensional
Shop Ship Stock

Mission-critical Multiple development
capabilities styles
Scaling: Performance, capacity, query Decentralized: Microservices, events,

parallelism, analytics, multitenant data mesh, APIs
Risk reduction: Disaster protection, Accelerated: Low code, data
replication, security, zero data loss engineering, schema-less, SaaS
backup, crypto-security

Converged capabilities reduce the number of database types you need
Non-converged databases Converged Oracle Database

Apps integrate multiple database types, Apps use one database for all
one for each type of data data types and workloads

How Oracle improves converged database consolidation
Complete data type and Automation of the Mission-critical apps Important data is
workload support complete dev lifecycle are easy to run easy to secure
• Developers use one database when • Point-and-click cloud native • Automatic performance • Transparent encryption protects data
working with multiple data types development using native tools optimizations on Exadata at rest, in motion, and in backups
reduce tuning requirements
• Multiple application databases run • AutoML helps automate • Data masking and redaction remove
and are managed together using machine learning model creation • Transparent query parallelism sensitive information
Oracle Multitenant simplify performance tuning
• Autoscaling eliminates the need • Separation of duties controls
• Native JSON with high performance for developers to implement • Consistent governance of self- administrative access to data,
and scale simplify modern apps scaling inside applications service databases with fleet software, and infrastructure
management
• Multiple types of analytics and • Autoindexing eliminates the • Label security and virtual private
machine learning eliminate stand- need for DBAs to tune database • Databases run unchanged for databases limit users access to data
alone services indexes for greater performance Oracle and 3rd-party apps
• Blockchain tables enable tamper-
resistant ledgers for centralized apps

Database
Offerings
Oracle Spent Last 23 Years •
•
Machine Learning Algorithms
Native Json
Automating Database Technology •
•
In-Memory improve
Blockchain tables 21c
19c
• Automatic Indexes
• SQL Quarantine
18c
• Real-Time Statistics
• Autonomous Health Framework
• Automatic Diagnostic Framework
• Automatic Refresh of Clones • Automatic Columnar Flash
• Automatic IM population
•
•
Automatic Memory Management
Automatic Segment Space Mgmt
12c • Automatic Application Continuity
• Automatic Statistics Gathering

• Automatic Storage Management
• Automatic Query Rewrite

• Automatic Undo Management
•
•
Automatic Workload Repository
Automatic Diagnostic Monitor 11g
9i 10g •
•
Automatic SQL Tuning
Automatic Workload Capture/Replay
• Automatic SQL Plan Management
• Automatic Capture of SQL Monitor
• Automatic Data Optimization
OCI Oracle Database options
Everything enterprise databases need to run in cloud
Flexibility Scalability Reliability
• Converged database • VMs with 2 to 128 vCPUs • Continuous availability

• Any database workload • 2-node active-active clusters • Disaster recovery
Simplicity Security Cost

Effectiveness
• Lifecycle management • Security-first infrastructure • Elastic compute consumption
• Low-code development • Oracle Data Safe included • 4 tiers of licensing options
Oracle Base Database Service
Simple path to move Oracle Database instances to Oracle Cloud Infrastructure
Feature and Pricing tiers

• Oracle Standard Database Service
• Oracle Enterprise Database Service
• Oracle Enterprise Database Service high performance
• Oracle Enterprise Database Service extreme performance
Versions: All supported Oracle Database versions

Licensing: License Included options or Bring Your Own License
Management: Oracle managed infrastructure with customer managed databases
Oracle Database Deployment
Virtual Machines (VMs)
• Easier deployment for small databases.

• You may provision 1 OCPU, the minimum Compute Power unit available on Oracle Cloud.
• Memory allocation related to the selected VM shape.
• Size of storage may be scaled up as needed at any time.
• The number of CPU cores on an existing VM DB system cannot be changed.
• Option of selecting an older database version.
• Oracle RAC may be enabled in a 2-node DB cluster.
• Data Guard within and across ADs is available for VM DB systems (requires DB Enterprise Edition).
Bare Metal (BMs)
• Direct access to the machines (Bare Metal definition)

• Better performance due to the lack of virtualization.
• Locally attached 51 TB NVMe storage (raw).
• Start with 2 cores and scale up/down OCPUs based on requirement.
• Data Guard within and across ADs (requires DB Enterprise Edition).
• If single node fails, launch another system and restore the databases from current backups.
• Oracle RAC not available (Deploy a highly available bare metal database)
Exadata DB System
• Full Oracle Database with all advanced options.

• On fastest and most available database platform.
• Scale-Out Compute, Scale-Out Storage.
• Complete Isolation of tenants with no overprovisioning.
• All Benefits of Public Cloud in Cloud@Customer.
• Fast, Elastic, Web Driven Provisioning.
• Oracle Experts Deploy and Manage Infrastructure.
Oracle Exadata is the best place to run Oracle Database
A fully automated and optimized platform coengineered with Oracle Database
Autonomous Database and Oracle Database

• Unique capabilities available only with Exadata
• Available in OCI and customer data centers
Database-Aware System Software

• Smart system software with unique algorithms accelerate
OLTP, analytics, and consolidated workloads
• Automatic storage tiering and resource management with I/O
prioritization by workload
Scalable, Highly Available Hardware

• Scale-out with optimized compute, networking and storage for
best performance at lowest cost
• Fully automated and optimized configuration, performance,
fault-tolerance, and updates

Exadata architecture optimizes all Oracle Database workloads
Database Servers
Fastest OLTP
• Uses RDMA instead of IO to read PMEM in smart storage servers
RoCE RDMA
• Unique algorithms for inter-node cluster coordination
Storage Servers • Result: 19µs IO – 10X faster than flash
Fastest Analytics
• Automatically offloads SQL processing to parallel smart storage servers
Hot PMEM
• Smart flash cache and Storage Index accelerates database IO automatically
Warm FLASH
• Unique columnarization converts data to fast in-memory formats
Best Consolidation
Cold
• Unique prioritization of latency sensitive and important workloads
• Isolation of multiple tenants and workloads
World’s Only Shared Persistent Memory Optimized for Database

Oracle DB Systems
Managed DB Systems – Exadata, RAC, Bare Metal, VM

Exadata DB
Systems
Complete lifecycle automation – Provisioning, Patching, Backup & Restore

RAC
High Availability and DR – RAC & Data Guard
Scalability – Dynamic CPU and Storage scaling

Systems
BM DB
Security – Infrastructure (IAM, VCN, Audit), Database (TDE, Encrypted

RMAN backup / Block volume encryption)
Systems
VM DB
Bring Your Own License (BYOL)

Autonomous
Database
Oracle Autonomous Database
Simplifies advanced data management obfuscating database and infrastructure complexity
Oracle Cloud
Oracle Complete Complete Automated Data

Autonomous Infrastructure Database Center Operations and
Database Automation Automation Machine Learning

Autonomous Database Options
Autonomous - Shared Autonomous - Dedicated
Self-Repairing
Self-Driving
Self-Securing
Oracle Autonomous Database – serverless or dedicated deployments
Autonomous JSON, Transaction Processing or Autonomous Data Warehouse
Self-driving Self-securing Self-repairing

• Scale-out database with fault- • Automatically applies security • Recovers automatically from
tolerance and DR updates online any failure
• Runs on enterprise-proven • Secure configuration with full • 99.995% uptime including
Exadata platform database encryption maintenance
• Full compatibility with existing • Sensitive data hidden from • Elastically scales compute or
enterprise databases Oracle or customer admins storage as needed

The complete database lifecycle is automated
Provisioning Security Management

Create scalable databases Protects against external and Automates all infrastructure
quickly internal threats and database management
Create in Exadata Monitor threats, apply online Perform all OS and SYSDBA
Cloud Infrastructure, security updates, encrypt all operations, adjust settings, fix all
RAC scale-out database, data, secure connections software online, diagnose errors
Active Data Guard standby
The complete database lifecycle is automated
1 2 3 4 5
Protection Scalability Optimization

Recover from any failure Online scale for higher Machine learning optimizes the
without downtime performance and lower cost database for each workload
Automates backup, restore, The instant online elasticity Continuously optimizes

application transparent of serverless computing and memory, data formats,
failover in scale-out cluster or storage enables true pay-per- indexes, parallelism and
to active remote standby use plans for each workload
Oracle Autonomous Database provides workload optimized service options
Oracle
Autonomous
Database
Autonomous Autonomous
Autonomous JSON Database
Data Warehouse (ATP) Transaction Processing (ATP)
Analytics Workloads OLTP and Mixed Workloads Application Development
• Mobile applications
• Data warehouse, data mart • Transactions, batch, reporting, • User profile management
• Data lake, machine learning IoT • Customer 360
• Application development, • Catalog and content
machine learning management
Choose the one that best meets your workload needs

https://www.oracle.com/autonomous-database/
Simplify innovation and prototyping
Immediately start developing using cloud native tools; nothing to install
Deploy in minutes
Data Modeling Low-code APEX Notebooks Data Analysis
Autonomous SQL Worksheet REST Services ML Modeling Data Sharing

Database
{JSON}
JSON Worksheet Data Catalog Graph Modeling Data Integration
Copyright © 2024, Oracle and/or its affiliates

Simplify development using your favorite tools
Example: Microsoft Visual Studio Code + Free Oracle Developer Tools plugin
Lifecycle management of Oracle

Autonomous Database
• Oracle Cloud Infrastructure Explorer
• Create, Start, Stop, Terminate ADBs
• Simple database connections
Develop database apps
• Edit and Execute SQL and PLSQL
• Format results in CSV, JSON…
• Autocomplete and Intellisense
• SQL history and bookmarks
• Syntax highlighting/Code Snippets

Use your favorite language with high performance drivers
Java ODP Java ODP R PHP Ruby Perl Julia Erlang Rust Go Node.js Python Python
DBD:: Oracle.jl oranif rust-oracle godror node- cx_Oracle python-
ruby-oci8
Thin
.NET JDBC-OCI
.NET ROracle OCI8
PDO_OCI Oracle oracledb oracledb
Managed Unmanaged
ODPI-C
Also used by custom apps
Oracle Call Interface (OCI) C Language API

Typically from Oracle Instant Client ZIPs or RPMs
Oracle Proprietary Drivers Third Party Open Source Drivers Oracle Open Source Drivers
Oracle maintains key driver APIs and works closely with driver communities

Get started quickly developing with Python
Example: python-oracledb
• Oracle Database driver for Python

• Single step install < 20MB
Python
• Default Thin mode: no Oracle Client libraries
• Runtime choice to use Thick Mode
• Support of new platforms: Alpine, Apple M1/M2, IoT
python-oracledb
driver
Users Autonomous • Python 3.6 – 3.11
Database
• Dual Apache 2 or UPL open source license
Python Process
• Binary module for performance
• Python Database API V2 support

Develop faster, more scalable AI/ML apps with Python
Bring algorithms to the data using Autonomous Database
Classification Clustering Association Rules

• Decision Tree • Expectation Maximization (EM) • Apriori – Association Rules
• Naïve Bayes • Gaussian Mixture Models via EM
• Generalized Linear Model • Hierarchical k-Means
• Support Vector Machine Feature Extraction
• Random Forest
• Neural Network Attribute Importance • Explicit Semantic Analysis
• XGBoost (21c) • Nonnegative Matrix Factorization
• Minimum Description Length • Principal Comp Analysis via SVD
• Random Forest • Singular Value Decomposition
Regression
• Generalized Linear Model Anomaly Detection Time Series
• Neural Network • One-Class Support Vector Mach • Single Exponential Smoothing
• Support Vector Machine • Double Exponential Smoothing
• XGBoost (21c) • Triple Exponential Smoothing
Supports automatic data preparation, partitioned model ensembles, integrated text mining

Simplify developing modern apps
Use multiple data types and analytics for intelligent applications
Derive those insights in a single, mixed-workload data

platform:
• Eliminate administrative overhead; no need to deploy
specialized analytic engines
• Build applications faster by reducing data integration
complexity
• Minimize security risks introduced by moving data to
specialized engines
• Reduce latency by bringing algorithms to the data
• Use your favorite tools and frameworks to develop the
solution
Autonomous
Database
Copyright © 2024 Oracle and/or its affiliates | All Rights Reserved.

Complete JSON database within Autonomous Database
Unique blending of transactional NoSQL APIs with SQL analytics
Designed to simplify development

• Flexible and fast at scale Developer
• Full ACID compliance simple NoSQL APIs
• Native JSON storage

• Simple document APIs
• MongoDB API compatible
• Language drivers, command-line, and REST powerful SQL analytics
• Gain instant insights using SQL analytics

across relational tables and JSON documents
Analyst

Use productive DevOps methodology with Autonomous Database
Self-Service APIs Cloud Events, Cloud agnostic Monitoring

for database Metrics and Terraform/Ansible Dashboards and
lifecycle: Alarms integrated Orchestration team messaging
provisioning, for hands-free simplifies plugins for real-time
cloning, scaling and automation deployments collaboration
more…

CI/CD on Autonomous Database
Liquibase + SQLcl Terraform/Ansible support provides industry standard EBR simplifies online
simple schema database-as-code for you automated deployments updates of
versioning, enables you
to execute commands to application schema,
generate a changelog for allows gradual transition
a single object or a full from old applications to
schema editions without
heavyweight cloning
processes
OCI DevOps with
Jenkins or Pipeline APIs for easy code
Process allow for management with
integration of the GitHub, AWS
database to your CodeCommit and
automation processes Azure repos

Simplify management
Focus on what’s needed - manage by exception
OCI Events Performance Hub

Get notified for maintenance Analyze and drill down
windows, ADMIN password SQL performance
expiry, New IP address
database logon…
Service Metrics Notifications

Alarm on exceptions based Notify stakeholders
on service metrics - CPU, using Slack, Teams,
Sessions, IO… email and more

Driving data discoveries through richer in-database analytics
Extensive domain specific algorithms

• Apply algorithms to all types of data
Spatial
Analytics • Use multiple algorithms to derive insights quickly
Collaborative web-based notebooks
• Easily visualize and document discoveries
Graph
analytics • Supports any user: data scientists, analysts, application
developers and DBAs
Machine Agile, fast and secure
Learning
• Use ADB processing power to apply algorithms to the data
• Keep data secure by avoiding copy contagion

AutoML brings machine learning opportunities to all users
Enables non-expert users to leverage machine learning
• Eliminate repetitive tasks of model building/evaluation to increase user productivity

• Enable non-expert users to leverage machine learning
• Apply ML to the ML process to reduce algorithm and hyperparameters search space and reduce
compute time and cost
OML AutoML UI Experiment Pipeline

Auto Algorithm Adaptive Auto Feature Auto Model
Selection Sampling Selection Tuning
• Identify in-database • Identify right • De-noise data • Improves model
algorithms likely to sample size for • Reduce features by accuracy
achieve higher training data identifying most • Automated tuning of
model quality • Adjust sample for predictive hyperparameters
Data • Find best algorithm unbalanced data • Improve accuracy • Avoid manual or
faster than and performance exhaustive search OML
exhaustive search techniques
Model
Feature Prediction Impact
Plus… • Rank features most influential for scoring
• Algorithm-agnostic technique
• For each final model per algorithm

Enable powerful analytics based on connectivity
Graph analytics
What is a graph?
• Data model representing entities as vertices and
relationships as edges C B
• Optionally including attributes
What are typical graphs? A D
• Social Networks
• LinkedIn, Facebook, Twitter, ... F
• Physical networks, Supplier networks,...
• Dependency Graphs
E
• Part hierarchies, data lineage, org charts, ...
• Knowledge Graphs
• Apple SIRI, Google Knowledge Graph, ...

Enable powerful analytics based on connectivity
Graph use cases
Community detection and influencer analysis

• Churn risk analysis/targeted marketing, HR Turnover analysis,
Customer 360
Product recommendation
• Collaborative filtering, clustering
Anomaly detection
• Social Network Analysis (spam detection),
fraud detection in healthcare
Path analysis and reachability
• Outage analysis in utilities networks, data lineage,
vulnerability analysis in IP networks, „Panama Papers“,
access management/GDPR compliance
Pattern matching
• Tax fraud detection, anti-money-laundering, data extraction

Built in spatial analytics using SQL
Geospatial data Processing Spatial Analysis Through SQL

Convert address data or place names to geospatial data
Prepare, validate and cleanse geospatial data SELECT a.customer_name,
Geospatial data Analysis
a.phone_number
Categorize or filter based on location and proximity FROM policy_holders a
Map visualization WHERE
Graphical representation for interactive analysis or reporting sdo_within_distance(
a.policy_location,
hurricane_path,
Are events occurring within a mile of each ‘distance=10 unit=KM’) =‘TRUE’;
other? Which is the nearest? Which tax zone is
this in? Where can we deliver within 35
minutes? Which are in my sales territory? Is
this built in a flood zone?

Accelerate migration of existing workloads to the cloud
Use your existing skills Compatible with existing apps Migrate with zero-downtime
{ JSON }
PL/SQL
No need to learn new database Supports existing workloads and Migrate your database with no
skills or languages because apps from on-premise deployments downtime using Zero Downtime
Autonomous Database fully (Oracle Apps, APEX apps, custom Database Migration Service
supports all of SQL and PL/SQL. apps, data marts, EDWs, etc)

Accelerate moving to cloud – low risk, no disruption, zero downtime
Reduced risk - 100% portability and compatibility with on-premise Oracle databases
1. Assess and 2. Plan migration 3. Leverage migration 4. Execute

evaluate resources tools migration
DIY
Zero Downtime
vs.
Migration (ZDM)
Cloud Lift
Services
Database Migration
Service (DMS)

Accelerate success – Run all your Oracle Apps better on ADB
Complete portfolio of Oracle Apps now certified
1
Simplify managing applications
Take advantage of Autonomous Database full
managed operations
2
Lower costs and risks
Only pay for the resources you use with auto-
scaling. Backup, restore, and cloning of Oracle
E-Business suite environments
3
Fast-track getting started
Use certified procedures for migrating to
Autonomous Database

Accelerate insights with Data Model Accelerators
Prebuilt solutions fast-track developing models, pipelines, KPIs and dashboards
NetSuite Data Warehouse Manufacturing Data Platform

E-Business Analytics Accelerator
Accelerator for Autonomous Accelerator
for Autonomous Database
Database for Autonomous Database

Open Source
Databases
OCI Database with MySQL
Fast Prosivioning Standlone Options
Elasticitade High Availability Option
Compute 3-nodes
Storage RAC
HeatWave
OCI Database with PostgreSQL
Fully Managed:
• Automated deployment and patching
Highly Available:
• SLA is 99.99%
• Data distributed across multiple redundant Availability
AD1 AD2 AD3 Domains or across multiple Fault Domains (single AD)
• Shared storage architecture with Zero RPO and Low RTO
Primary Read Repl. 1 Read Repl. 2 • Dynamic storage scaling (zero downtime)
High Performance
• 3x higher perf than the open-source version
Scalable:
Database Optimized Storage • Scales linearly with additional read replicas - utilizing
shared storage
Regional Block Volume Secure:
Availability Availability Availability • End-to-end encryption
Domain Domain Domain • Automatic security patching
Best-in-class TCO:
• 60% less expensive than Amazon Aurora PostgreSQL.
• Pay-as-you-grow shared(across nodes) storage
Open Source Databases - NoSQL
NoSQL Data Model Flexibility

High Performance –
Milisecond latencies
Oracle NoSQL Database Cloud Service – Value Proposition
Fully Managed Elastic High Performance

Database operation, Dynamically change Predictable low latency
maintenance, tuning throughput and for all types of
are managed by storage capacities workloads
Oracle based on workloads
Data Model Flexibility Security Low Operating Cost

Document, columnar, Enterprise grade Pay only for the
key/value models security with roles, throughput and storage
supported with a single privileges, encryption capacities provisioned
application interface
Developer Friendly Always Available Hybrid Cloud

Easy-to-use APIs and Built-in high availability Interoperate with Oracle
integrated with different to ensure business NoSQL on-premise
developer tools continuity solution using a single
application interface
NoSQL Database –Use Cases
Mobile Internet of 360 degree User profile Catalog

applications things customer view management data
Content Online Real time Social Gaming

management advertising Big data network
Max Availability
Max Security
Architectures
Oracle Maximum Availability Architecture (MAA)
Continuous Availability
Customer Insights & Expert

Recommendations Application Global Data
Platinum Continuity Services
Data Protection
Gold
24
HA Features,
Silver Reference Replication Configurations & Flashback RMAN + ZDLRA
Architectures Operational
Practices Active Replication
Bronze
Production Site Replicated Site
Active Data Guard GoldenGate
Deployment Choices
Scale Out
Generic Engineered DBCS Autonomous

Systems Systems ExaCS/ExaCC DB RAC ASM Sharding

MAA Reference Architectures for the Cloud
Availability service levels
Platinum
Gold Mission Critical
Business Critical
Silver Gold
Gold ++
Prod/Departmental Silver + GoldenGate
Bronze Silver + Zero Downtime
Bronze + Edition Based
Golden Redefinition
Gate Cloud Svc.
Maintenance / Migration
Dev, Test, Prod Bronze + Zero Data Loss with
DB Replication
Database HA with DR to
HA andthe
DRCloud Use Case
Zero Downtime Active Data Guard
Single Instance DB High
RAC Availability
RAC
Zero Data Loss Backup
Restartable Application Continuity
to the Cloud
Backup
Backup / and Use Case
Recovery
Restore
All tiers exist with on-premise and cloud. However, platinum currently must be configured manually while bronze to gold are covered with cloud tool automation

Securing the Oracle Database
Strengthen
authentication
Encrypt Control
data access
Minimize Monitor
attack activity
surface
Assess
configuration
and detect
drift
Securing the Oracle Database
Strengthen
authentication
Encrypt Control
data access
Minimize
Monitor
attack
activity
surface
Assess
configuration
and detect
drift

Database Strong Authentication
Database Centrally Managed Users
Getting down to details Database IAM integration
Database Password Profiles
Database Roles and Privileges

Database Centrally Managed Users
Database Virtual Private Database
Strengthen Database Real Application Security
Database Blockchain and immutable tables
authentication Database Vault
Advanced Security Transparent Data Encryption Label Security
Key Vault Advanced Security Data Redaction
Encrypt Control
Database Native Network Encryption
Database Transport Layer Security (TLS) data access
Data Safe User Assessment Database Unified Auditing

Database Security Assessment Tool Minimize Audit Vault and Database Firewall
Database Privilege Analysis Monitor
attack Data Safe Auditing
activity
Data Safe Masking surface
Data Masking and Subsetting Assess
Legend
configuration
and detect
Feature
Option
drift
Product Database Security Assessment Tool
Service Data Safe Security Assessment
Key to Database Security Controls
Maximum Security Architecture Assess Prevent Detect
Data-Driven Security
Virtual Private Database
Data Redaction
Label Security
Users
Real Application Security
Database Immutable Tables

Firewall
Blockchain Tables
Discover Sensitive Data
Events
Database Vault
Applications
Alerts
Reports
Test Dev
Policies
Audit Data & Transparent Key Vault Data Masking
Event Logs Data and Subsetting
Audit Vault
Encryption Data Safe
Data Safe

OCI Data Lake
Oracle Cloud Infrastructure (OCI) Data Lake
OCI Data Lake is a fully managed service which provides centralized storage for structured and
unstructured data with unified access control and centralized metadata
• Seamlessly ingest data into the lake by leveraging

integration with OCI Data Integration service
• Secure and govern data in the lake with fine grained

access control all managed at one place in the lake
• Define access control policies in OCI Data Lake once and

apply to all data access/processing tools
• Data compaction and garbage collection routines in

managed tables helps optimize the data storage
• Easily discover entities stored in the Data Lake,

understand the flow of data with OCI Data Catalog
67 Copyright © 2024, Oracle and/or its affiliates | Confidential: Restricted 5/8/2024

OCI Data Services
Drive Advanced Outcomes with All Data
Data Data Big Data Services Data Warehouse AI / ML

Sources Integration (Spark, Hadoop, OpenSearch) Services
Meaningful
Business Insight
Autonomous Data
Database
Warehouse
Oracle
MySQL HeatWave
GoldenGate
Accurate
Data Lake (Storage Zone for All Data) Forecasts and
Applications Predictions
Data Sharing
Share data securely across the Enterprise.
OCI Data
Video Integration
Service
Data Catalog Improved Real-
time Visibility
Unified security and governance.
Log Lake Mounts and Tables

Data trust and performance.
Anomaly
OCI Streaming Detection
Service Object Storage Analysis
IoT
(Apache Kafka) Scalable raw storage for all data.

Storage in OCI Data Lake
• Mount – File Storage

• External Mount – Files are referenced to Object Storage Folder/Bucket
• Managed Mount – Data stored within OCI Data Lake
• Schema & Table – Logical Entity (Metadata stored in OCI Data Lake)
• External Table – Table Data is referenced to Object Storage Folder/Bucket or Mount
• Managed Table – Data Stored within OCI Data Lake and Access via OCI Data Lake
OCI Data
Lake
Managed External Object Storage

Mount Mount Bucket/Folder
Managed
Tables
Schemas External Object Storage

Tables Bucket/Folder

Building Data Lake in OCI
File Formats
• OCI Data Lake enable Data Engineers to store and work with data in a format of their choice
• OCI Data Lake supports CSV, JSON, Parquet, AVRO, ORC, DELTA and Text files
• DELTA file format provides ACID transactions, time travel support and is best suited for analytics
workloads
Data Sources Data Ingestion Data Storage
Data Integration OCI Data Lake

Managed
OCI Data Integration Mounts/Tables
Amazon
RDS
OCIExternal
Object Storage
SDK/APIs Mounts/Tables

Multi Cloud
DB Options
Unify database management across hybrid and multicloud environments
Regardless of where the application binaries run and low latency connection available
Unified Database Management 100 Gbps network

Run all database workloads
OCI-Azure Interconnect
Autonomous
Database <2ms RTT latency between clouds AZURE
Exadata
Database FastConnect / VPN Customer
Service Data Center
Customer-dedicated
Exadata Cloud Infrastructure X9M
Disaster recovery
FastConnect / VPN
Oracle Cloud Infrastructure Customer Data Center

Autonomous Database simplifies multi-cloud solutions
Deep integration with native cloud services abstracts differences
• Uses cloud vendor’s native authorization rules

• Offers direct SQL access to object stores and databases
Access any • Supports all popular file types (csv, Parquet, ORC, Avro,
data JSON and more)
• Integrates data from over 100 sources, including
databases, SaaS apps and cloud services
Under- Simplifies data access by synchronizing

stand metadata cloud catalogs
any data
Collaborate Share messages on email, Microsoft Teams,

Slack and more
See documentation for details on support

Summary of Autonomous Database multi-cloud integration
Code
Data Lake
Notifications Repositories
File Formats
Github AWS Azure

Codecommit Repos
Data integration
sources
Secure object
Direct store access
Query Access Data
Catalogs
OCI
Data Amazon
Catalog Glue
ODSA creates more options for customers to harness cloud innovation
Build with the best of OCI and Use fully managed Oracle Run exclusive OCI database
Azure services Databases with Azure services with Azure
Cloud Infrastructure Cloud Infrastructure Cloud Infrastructure
Any Azure Analytics Any Azure App
Autonomous App Services

Exadata
Power BI Autonomous eCommerce
Database Database App Tier
Kubernetes Database App
Synapse Service
Virtual Machines
HDInsights
Functions
Event Clusters Containers
On-Prem
Customer- Exadata
managed Database App
Oracle DB Machine

ODSA creates more options for customers to harness cloud innovation
Build with the best of OCI and Use fully managed Oracle
Azure services Databases with Azure
Cloud Infrastructure Cloud Infrastructure
Any Azure Analytics Any Azure App
MySQL Power BI App Services MySQL Marketing

HeatWave HeatWave
Synapse
Kubernetes analytics app
Virtual Machines
HDInsights
Functions
Event Clusters Containers
Customer-managed
MySQL database for transactions +
analytics database + ML tools + ETL
processes between data stores

Oracle Database@Azure
Available December 2024
MICROSOFT AZURE Region
Azure Cloud Services
• Oracle and Microsoft deliver

Oracle database services on OCI Compute Kubernetes DevOps
in Microsoft Azure datacenters …

Oracle Database
App Entra ID Fabric @Azure
Service
Microsoft Managed Infrastructure Oracle Managed Infrastructure

78
Certification:
OCI Data Management Foundations 2023
→ Oracle University:
→ Become an OCI Data Management Foundations Associate 2023
→ Real-Practical Labs and Exercises in LiveLabs

→ Access LiveLabs
Any doubts?
Pls let me know!
Alexandre Fagundes
[email protected]
Cloud Architect, Oracle Latin America

Data MGMT Foundations

Uploaded by

Copyright:

Available Formats

Data MGMT Foundations

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Data MGMT Foundations

Uploaded by

Copyright:

Available Formats

Oracle

Data Scientist Security

Learn about Cloud concepts and

 Explain Oracle's Data Management Strategy

7 Copyright © 2024, Oracle and/or its affiliates | Confidential: Internal

Integration AI/ML Analytics

Autonomous Oracle Database Exadata MySQL No SQL

Identity and Access

8 Copyright © 2024, Oracle and/or its affiliates

Oracle Cloud Infrastructure Global Footprint

February 2024 Canberra NEW

48 regions; 5 more planned Commercial

12 Azure Interconnect Regions Sovereign

Data Data Data Data

Servers Servers Servers Servers

Storage Storage Storage Storage

Networking Networking Networking Networking

Sales & Marketing

Using multiple databases per application creates complexity and risk

12 Copyright © 2024, Oracle and/or its affiliates. All rights reserved.

Multiple data types Multiple workloads

Shop Ship Stock

Scaling: Performance, capacity, query Decentralized: Microservices, events,

13 Copyright © 2024, Oracle and/or its affiliates. All rights reserved.

Non-converged databases Converged Oracle Database

14 Copyright © 2024, Oracle and/or its affiliates. All rights reserved.

15 Copyright © 2024, Oracle and/or its affiliates. All rights reserved.

• Automatic Statistics Gathering

• Automatic Query Rewrite

Flexibility Scalability Reliability

• Converged database • VMs with 2 to 128 vCPUs • Continuous availability

Simplicity Security Cost

Feature and Pricing tiers

Versions: All supported Oracle Database versions

• Easier deployment for small databases.

• Direct access to the machines (Bare Metal definition)

• Full Oracle Database with all advanced options.

Autonomous Database and Oracle Database

Database-Aware System Software

Scalable, Highly Available Hardware

24 Copyright © 2024, Oracle and/or its affiliates

World’s Only Shared Persistent Memory Optimized for Database

Managed DB Systems – Exadata, RAC, Bare Metal, VM

Complete lifecycle automation – Provisioning, Patching, Backup & Restore

High Availability and DR – RAC & Data Guard

Scalability – Dynamic CPU and Storage scaling

Security – Infrastructure (IAM, VCN, Audit), Database (TDE, Encrypted

Bring Your Own License (BYOL)

Oracle Complete Complete Automated Data

28 Copyright © 2024, Oracle and/or its affiliates

Autonomous - Shared Autonomous - Dedicated

Self-driving Self-securing Self-repairing

30 Copyright © 2024, Oracle and/or its affiliates

Provisioning Security Management

Protection Scalability Optimization

Automates backup, restore, The instant online elasticity Continuously optimizes

Analytics Workloads OLTP and Mixed Workloads Application Development

Choose the one that best meets your workload needs

Autonomous SQL Worksheet REST Services ML Modeling Data Sharing