Autonomous Database Newsletter - March 08, 2022

March 7, 2022 | 35 minute read
Keith Laker
Senior Principal Product Manager
Text Size 100%:

 

 

March 08, 2022

Autonomous Database Shared development and product management teams are pleased to announce the following updates:

 
  1. Simpler Management
    • Auto-scaling for storage
    • Track OCI resources, cost, and usage
    • Auto-Partitioning with ADB workshop
  2. Stronger Security
    • Enhancements to Data Safe
    • Critical events for customer-managed key
  3. Faster Innovation
    • Support for cloud code repositories
  4. Richer Analytics
    • Database Actions - Data Analysis tool
  5. Global Leaders Program
    • North America Customer Panel
    • Data Management Community Summit
    • Library of On-Demand Webinars

To watch recordings of our new feature webcasts, head over to our OTube channel!

To subscribe to this newsletter, click here.
To subscribe to the Database Insider Newsletter, click here.

 

SIMPLER MANAGEMENT


AUTO SCALING FOR STORAGE

NEW - Autonomous Database now provides automatic scaling for storage.


SIMPLER MANAGEMENT
icon for managing Autonomous Database
 

Data loading/data processing jobs can fail if the database storage space becomes full. This can result in applications generating errors and cause delays in making data available for analysis. Users need to monitor their space usage and add more storage as needed.

Autonomous Database now provides automatic scaling for storage. This feature works in a similar way to the auto-scaling feature for OCPUs. With this feature enabled (by default, it is switched off), the system will automatically (and transparently) expand the base reserved storage by up to 3x.

For example, when 100 GB or less of allocated storage remains, the database reserves an additional 1 TB of storage. Then as additional storage is used, storage increases when needed in increments of 1 TB, up to the maximum storage (three times the reserved base storage).

 
Sceenshots showing checkboxes to enable automatic scaling feature on create ADB instance form and the change scaling settings form

MORE INFORMATION

DOC: auto scaling for storage, click here.

BLOG: Auto scale your Autonomous Database storage, click here.

 


 

 


RESOURCE, COST, AND USAGE DATA

NEW: Built-in views to query OCI resource, cost, and usage data


SIMPLER MANAGEMENT
icon for managing Autonomous Database
 

Customers can download their cost and usage data directly from the OCI console in csv file format. However, getting to the stage where you can slice and dice and analyze that data can involve a lot of steps.

Autonomous Database now has built-in views that show OCI resources, cost, and usage data. You can access this OCI information using the following views:

  • OCI_AUTONOMOUS_DATABASES
  • OCI_BUDGET_ALERT_RULES
  • OCI_BUDGET_SUMMARY
  • OCI_COST_DATA View
  • OCI_OBJECTSTORAGE_BUCKETS
  • OCI_USAGE_DATA

 

 

MORE INFORMATION

DOC: Track Oracle Cloud Infrastructure resources, cost, and usage reports with Autonomous Database views, click here.


 

 


AUTO PARTITIONING

NEW: Workshop for automatic partitioning in
Autonomous Database


SIMPLER MANAGEMENT
icon for managing Autonomous Database
 

Partitioning can help improve the performance of many workloads and make it easier to manage large tables. However, DBAs and non-technical users typically struggle to find the best partitioning method for their data. It requires deep knowledge of the application workload, data schema, and data distribution.

ADB now comes with a partitioning expert in-a-box. ADB's automatic partitioning analyzes your application workload and automatically applies partitioning to your tables and indexes to improve performance or to allow better management of large tables.

Automatic partitioning makes it easier for all users to benefit from partitioning without performing manual schema and workload analysis. Explore how this feature works using this new free workshop on Oracle LiveLabs:



 

MORE INFORMATION

WORKSHOP: Automatic Partitioning with ADB on Oracle LiveLabs, click here.

BLOG: Automatic Partitioning with Autonomous Database, click here.

 


 

 

 

STRONGER SECURITY


DATA SAFE

UPDATE: Data Safe now runs 100% within the OCI console


STRONGER SECURITY
Database security icon
 

Customers are looking for a way to integrate their data security processes into the OCI event and notification services. They also need API-driven processing to incorporate database security into their broader security dashboards so they can quickly respond to any issues.

Many cloud admins want to automate their data security processes using scripting to create easy-to-use and repeatable processes.

Data Safe’s security center is no longer a separate console; it is now 100% within the OCI console framework.

Data Safe can now be integrated with other OCI event-driven services like the OCI notification service. This allows Data Safe alerts to generate notification emails and SMS messages and makes integrating Data Safe with external services like a SIEM or log analyzer easy.

The full complement of Data Safe APIs is now available, allowing easy orchestration of everything from database target registration through data masking to audit report generation and retrieval. In addition to making things easier, the new APIs allows our customers to include database security in their broader security dashboard, which helps them respond more quickly to issues

 
screenshot showing to setup TLS connection capabilities
 

MORE INFORMATION

DOC: Overview of Data Safe events, click here.
DOC: Event Types for Oracle Data Safe, click here.
DOC: List of Data Safe APIs, click here.
WORKSHOP: Data Safe fundamentals workshop, click here.


 

 


CUSTOMER MANAGED KEYS

NEW: critical events with customer-managed keys


STRONGER SECURITY
Database security icon
 

Customers are looking for a way to integrate their use of customer-managed keys into the OCI event and notification services. They want to receive notifications and alerts when there is an issue with the keys.

SOLUTION: Autonomous Database events are triggered when an instance is using customer-managed keys, and the database becomes inaccessible or when the database recovers from being inaccessible. Two new events have been added:

 

 

MORE INFORMATION

DOC: About critical events on Autonomous Database, click here.


 
  • DatabaseInaccessibleBegin
  • DatabaseInaccessibleEnd

 

FASTER INNOVATION


CODE REPOSITORIES

NEW: Use a Cloud Code Repository with Autonomous Database


FASTER INNOVATION
Database security icon
 

Developers typically use code repoistory tools to manage all their application code. Autonomous Database now provides routines that allow developers and general users to manage and store their code files in Cloud Code (Git) Repositories.

The supported Cloud Code Repositories are: GitHub Repository, AWS CodeCommit, and Azure Repos. The DBMS_CLOUD_REPO package provides a single interface for accessing a Cloud Code Repository from Autonomous Database.

Autonomous Database provides the following to help you work with Cloud Code Repositories:

  • Repository initialization operations to allow you to initialize a repository.
  • Repository management operations that let you create, list, update or delete a repository.
  • Repository file management operations to upload, download, update, and delete files.
  • SQL install operations that let you export database object metadata DDL to a repository and install SQL statements into the database from a Cloud Code Repository.

 

 

MORE INFORMATION

DOC: Using and Managing a Cloud Code Repository with Autonomous Database, click here.
 


 

 

RICHER ANALYTICS


DATA ANALYSIS TOOL

NEW: Business model tool now integrated into
Database Actions Data Analysis tool


RICHER ANALYTICS

Icon for analytics over a data set
 

Many data visualization tools layer a multidimensional model over the underlying relational data model to make it easier for users to slice and dice and analyze their data. However, each tool builds and manages its own model in isolation, making it incredibly difficult to centralize the definition and management of dimensions, hierarchies, attributes, and measures to ensure consistency across reports and charts.

Deriving the multidimensional metadata within each tool takes significant time and effort because it requires a deep understanding of the underlying relational data model.

The Database Actions Data Analysis tool (replaces the Business Models tool) provides a user-friendly interface to create multidimensional models. The new interface allows users to automatically create Analytic Views from the underlying fact tables and dimension tables in the Autonomous Database.

Additional capability includes new tools to analyze the multidimensional model's data, gain immediate insights, and review any relevant data quality issues.

The Analytic view created using this tool can be used directly in Oracle Analytics Cloud and many other tools. The curated Analytic View can be exported directly as a Tableau project for further analysis.

Screenshot below of new Database Actions Data Analysis page.

 
screenshot showing mew Database Actions Data Analytic tool web page within ADB

 
 

MORE INFORMATION

DOC: Data Analysis Tool, click here.

WORKSHOP: Important Tools for Everyone Using Oracle Autonomous Database Workshop, click here.


 

 

ORACLE GLOBAL LEADERS


UPCOMING EVENTS

Oracle Global Leaders Event Registration logo

REGISTER: Global Leaders Customer Panel
Accelerating time to value, extending capabilities, and lowering costs by replacing AWS with Autonomous Database

 

Join Thomson Reuters, Wilson Transportation & Leasing Group, and JASCI Software for a lively discussion on how their companies are driving efficiencies, providing new services, and growing revenues with Oracle Cloud platform: Oracle Autonomous Database, Oracle APEX, and more. Our speakers will share how they leverage their solutions to address unanticipated business needs and accelerate time to value by lowering administrative and development costs and boosting availability, performance, and security.

To register, click here.

MAR 8

12:00 PM ET


 
Oracle Global Leaders Event Registration logo

REGISTER: Oracle Global Leaders Data Management Community Summit

Learn from and interact with other customers to share experiences and best practices. A unique and interactive event for Oracle Customers using Oracle data management products and services to share the details of their success, illustrate new and planned ideas, and inspire innovative applications and powerful use-cases.

To register, click here.

MAR 30

10:00 AM CET


 
 
Oracle Global Leaders Event Replay logo

REPLAYS: Library of On-Demand Webinars

Watch recorded webinars that explore the power of Oracle's Autonomous Database and related Oracle Cloud Infrastructure services. Click here.



 

 

 

Copyright © 2022 Oracle and/or its affiliates. All rights reserved.

Keith Laker

Senior Principal Product Manager

Product Manager for Autonomous Database and Analytic SQL with extensive experience in data warehouse and business intelligence projects. Worked in various roles, including post-sales consultancy, customer support, and product management at locations across Europe and US.

 

Show more

Previous Post

Automatic Partitioning with Autonomous Database

Hermann Baer | 3 min read

Next Post


Auto scale your Autonomous Database storage

Nilay Panchal | 3 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider