Please enable JavaScript.
Coggle requires JavaScript to display documents.
Oracle Autonomous Database - Coggle Diagram
Oracle Autonomous Database
Autonomous Database Technical Overview
Oracle Cloud Infrastructure
Oracle Cloud Infrastructure is a true enterprise cloud
Highest, Most Consistent Performance
Low, Predictable Pricing
Automation, Innovation
Move critical workloads to cloud without compromises
Automation Expertise
Migration Services
Consistent & Compatible
Better Performance
Compatible with our customers' workloads
Oracle Enterprise Applications
Customer & ISV Apps On Oracle Database
Performance Intensive Workloads
Cloud Native Applications
A Comprehensive Enterprise Cloud Strategy
OCI Region - HA Building Blocks
Region
AD
FD
Fast and Scalable Bare Metal, VM, and GPU Compute
Enterprise Web & Application Servers
Enterprise Application Servers, Haddop
HPC, AI/ML, 3D Rendering
DNA Sequencing, CFD, Crash Simulations
Oracle Database, Spark, Containers
Oracle Cloud Infrastructure Cluster Networking
Clustered RDMA Network
CPU Servers
GPU Servers
Exadata
Block Storage
Consistently fast storage performance across workloads
Cloud infrastructure trusted by enterprise customers
Deeper customer isolation
Data encryption end-to-end
Network protection
Verifiable security
Complete cloud infrastructure services
Autonomous Database Overview
Autonomous Database Key Features
Benefits
Lowers Cost
Reduces Risk
Accelerates Innovation
Simple
Fast
Elastic
Atributos
Self-Driving
Automatic Tuning
Automatic Indexing
Automated Management
Rapid Provisioning
Self Scaling
Self-Securing
Encryption by Default
Self Patching
Separation of Duties
Auditing
Self-Repairing
Self Healing Hardware
Self Healing Software
Autonomous Database Architectural Components
Exadata Cloud Infrastructure
Based on Region
Oracle responsabiloity: patching, software, versions and isolation
mini. size/cost: 1OCPU and 1TB
mini. time: 1 hour
Architecture
Oracle Data Visualization Desktop
SQL Developer
Service Console
Oracle Machine Learning (ML)
OCI Integration
Exadata Server
Storage Server
Application Server
Connection Manager Servers
Oracle Machine Learning/Servers
Interfaces
Cloud UI and REST APIs
Cloud Service Dashboard
SQL Developer
Oracle Rest Data Services (ORDS)
Describe a typical workflow for using Autonomous Database
Determine level of automation and functionality
Determine main workload characteristics for the database
Select ADW or ATP service
4.Provision the selected ADB service
Load Data to the new database
Migrate application
Provisioning and Connectivity
Connect and navigate the OCI console
OCI Consle
Oracle My Services
OCI Services
Provision an Autonomous Database service
Find and download database credentials
Secure connections via Wallet credentials file
Wallet is downloaded
Console
API
Connect to an ADB service
Client Computer
ODBC
JDBC OCI
Oracle Call Interface (OCI)
JDBC Thin
SQL*Net
Secure
Certificate
Encrypted key in Wallet files
Two connectivity
Public Internet
FastConnect with Public Peering
OCI Service Gateway (Hosts is cloud)
Predefined Database Service Names
tpurgent
tp
high
medium
low
SQL Developer
JDBC
Migration and Data Loading into Autonomous Database
Describe the options and considerations for migrating to ADB
Converted to PDB
Migrate to ADB using Data Pump
How?
Data file copying
Direct path
External tables
Network link import
Version
10.1 and above
Commands
expdp
impdp
Export
Parallelism
schemas and data
Migrate to ADB using GoldenGate
Use Case
Real-time Data Warehousing
Operatinal Reporting
Configure Oracle GoldenGate On Premises for Replication
Configure Oracle GoldenGate Manager and Classic Replicat
Load data with Data Sync
OAAC
Many sources
Load data using DBMS_CLOUD
Generate the Auth Token
Create a Credential in ADB
ADB APIs for Object Storaa Access
Use the Credential Name in dbms_cloud
File URI Format
Data Loading API, dbms_cloud.copy_data
External Table API, dbms_cloud.create_external_table
Loading Autonomous Database using SQL Developer
SQL Developer Import Wizard
Loading Autonomous Database Using SQL*Loader
Managing and Maintaining Autonomous Database
Manage users and user privileges in ADB
Creating users
create user ocitest identified by PaSSw0rd
grant dwrole to ocitest
Start, stop and scale ADB
Use rest APIs to manage ADB
Use the OCI command line to manage ADB
Manage ADB Backups and Restores
Backup 60 days
You do manually
Explore ADB using SQL Developer
Understand ADB for Experienced Users
Monitoring Autonomous Database
Monitor ADB Using the OCI Service Console
Statistics Management
Hints
Understading ADB Consumer Groups
low, medium, high, tp, tpurgent
Autonomous Database
Checking your consumer group
Checking resource allocation
Tools,Reporting and Analytics
Describe how to use ADW with 3rd party software
ADW Connectivity
SQL*Net, JDBC, ODBC
Connecting .NET Applications
ODT and ODP.NET
Visual Studio, NuGet
TLS 1.2
Wallet
JDBC Thin or UCP
JDBC Thin URL
JDBC Thin HTTP Proxy
Describe how to build analytic views
Explain how to use Oracle Machine Learning
Create Oracle Machine Learning User
Create workspaces
Create projects
Create notebooks
Run SQL scripts/statements
Explain how to install and configure Oracle Analytics Cloud and Data Visualization Desktop
Standard
Essbase
Enterprise
Data Visualization
Essbase
Business Intelligence
Explain how to connect the Oracle Analytics Cloud and Data Visualization Desktop to the Autonomous Data Warehouse
Connections
Connection Settings
Data Sets
Schemas and Tables
Columns and Objects
Data Elements