Autonomous Database Features
Deliver new projects
Newcomers to Oracle Autonomous Database can get up and running quickly with a minimal learning curve. Preexisting expertise in Oracle Database isn’t required to be productive with Autonomous Database.
- Deploy a new Autonomous Database of any size in minutes.
- IT staff don’t have to spend time on routine operations since Autonomous Database automatically takes care of them.
- Analysts can build better descriptive and predictive analytics using their preferred tools. Autonomous Database includes built-in machine learning, graph, spatial, and text analytics and integrates with other databases, clouds, and data lakes to eliminate data silos.
- Developers have flexibility to use their tech stack, architecture, and approach of choice to build applications. There’s no need to use multiple specialty databases, and DevOps teams will find those applications easier to manage and perform operational reporting.
Migrate databases and applications
Autonomous Database is a fully automated Oracle Database. It offers the easiest way to move Oracle Database workloads to the cloud.
- There’s no need to learn new database skills and languages because Autonomous Database fully supports PL/SQL.
- Analytics and apps from on-premises Oracle Database deployment are supported.
- Analyze your database estate to identify the best candidates to move today.
- Migrate your database to Oracle Cloud Infrastructure (OCI) without downtime using Oracle Zero Downtime Migration. Accelerate your migration with guidance from cloud engineers on planning, architecting, prototyping, and managing cloud migrations through Oracle Cloud Lift Services.
Analyze the data in your Oracle applications
Whether you’re using Oracle Fusion Applications or Oracle’s NetSuite, E-Business Suite, or PeopleSoft applications, take advantage of ready-to-use data models, pipelines, and analytics to put data to work quickly.
- Use insights from data in Oracle Cloud’s ERP, HCM, SCM, and CX application suites. Oracle Fusion Analytics Warehouse includes prebuilt KPIs, machine learning, and simpler data management.
- Gain actionable insights from your NetSuite data. Oracle NetSuite Analytics Warehouse delivers powerful data analysis that drives actionable insights. Without relying on IT, business professionals can load data as well as quickly build and run their own analyses.
- Start getting new insights from your E-Business Suite data up to 70% faster than building analytics on your own. The E-Business Suite accelerator includes a prebuilt extract, transform, and load pipeline; data model; prebuilt KPIs; dashboards; and reports.
Integrate with other public clouds
Get the data access, performance, and usability of a single cloud but in a multicloud environment.
- Get single cloud ease of access to data using Autonomous Database, which securely integrates with Amazon S3, Azure Blob Storage, and Google Cloud Storage.
- Get single cloud performance for your application with a low latency, high bandwidth link between Oracle Cloud Infrastructure and Azure.
- Get a single cloud UI using the Azure console to configure and operate enterprise-grade Oracle Database services residing in OCI. There’s no need to learn how to use a new console with Oracle Database Service for Microsoft Azure.
- Coming soon: Run your workloads where you choose with fully managed Oracle database services running on OCI but inside Azure. Experience the highest level of Oracle Database performance, scale, and availability, as well as feature and pricing parity.
Support all workloads
Get native support for all modern data types, workloads, and analytics built into a single service, giving developers a platform with fewer moving pieces and less complexity. Take advantage of an environment that supports applications or analytics at any scale or criticality without requiring time-consuming integration of multiple services or multiple specialty databases.
- All modern data formats are supported: relational, graph, geospatial, JSON, text, and more. There’s no need to use numerous specialty databases for different data types.
- All modern workloads are supported: OLTP, IoT, temporal, ledger/blockchain, streaming, analytic, and more. There’s no need for different specialty databases to support different workloads.
- All modern analytics are supported: advanced SQL, machine learning, graph analytics, text/search analytics, geospatial analytics, and more—all including data lake access. There’s no need to move data to specialty databases for analytics.
- All modern development styles and paradigms are supported: containers, events, REST, low code, microservices, CI/CD, and more. Simplify operations with a single database to support all your development needs.
- Create a single, secure environment quickly and safely with seamless and identical security across all data types and workloads.
Perform self-service analytics
Line-of-business teams can deploy their own analytics environment using an end-to-end data analytics ecosystem without relying on IT staff.
- Load and transform data from more than 100 application, database, and data lake sources without IT help using the Transforms UI of Oracle Autonomous Database Data Studio.
- Create complex analytic calculations with ease using the built-in data analysis UI in Data Studio—and share those calculations with your favorite tools, including Oracle Analytics Cloud, Tableau, Excel, and more.
- Share data securely, quickly, and openly within and outside your organization.
- Understand your data sources and track changes using the catalog UI in Data Studio.
- Easily access your data from spreadsheets with add-ins for Excel and Google Sheets.
- Empower your data scientists with built-in machine learning and graph algorithms, native Python and R support, and a built-in notebook UI.
- Ask questions in natural language and get answers from your organization’s data in Autonomous Database using Select AI.
Build cloud native applications
Build microservices faster using a tech stack you know and make them easier for DevOps to operate.
- Use your favorite tools with support for open source frameworks, REST/JSON-based development, and a MongoDB-compatible API.
- Operationalize insights using built-in advanced analytics, including multidimensional models, machine learning, graph, spatial, and text without requiring the additional complexity of specialized analytic engines.
- Java Database Connectivity (JDBC) is supported for any tool or application.
- Access data using Python with cx_Oracle, which conforms to the open-standards Python database API.
- Access and analyze all data, including JSON, graph, and spatial data using SQL.
- Keep data protected without downtime—your database deployment is secure by default and automatically kept up-to-date with the latest database and security patches.
- Develop applications using free options of Autonomous Database, either in the cloud with Autonomous Database on Oracle Cloud Free Tier or with Autonomous Database free container image for offline development.
Use natural language in your applications
Autonomous Database speaks “human.”
- Simply ask a question using natural language—it’s the simplest way to get answers about your business.
- Easily build natural language capabilities into your applications using Autonomous Database Select AI.
Develop applications with low code
Line-of-business analysts and nonprofessional developers can quickly develop smaller departmental applications as well as sophisticated enterprise-scale applications.
- Use Oracle APEX, an enterprise low-code application platform, to develop applications 20X faster and with 100X less code.
- Integrate advanced analytics into your applications with minimum coding using UI-based tools. Use Data Studio data analysis to build multidimensional models, AutoML, Oracle Spatial Studio, and Graph Studio.
Run data lake analytics
Analyze all your data—both inside Autonomous Database and outside in data lakes or cloud storage using the same tools, processes, and access methods as the database.
- Query and analyze data in
- Any cloud object storage, including OCI Object Storage, Amazon S3, Azure Blob Storage, and Google Cloud Storage
- Any data lake file type: Parquet, Avro, JSON, csv, XLSX, and more
- Any major data lake table structure, such as Delta tables or Iceberg tables
- Keep data secure using the native security policies of object storage combined with the advanced security of Autonomous Database.
- Run SQL queries directly against your object store source and correlate them with data stored in Autonomous Database.
- Instantly find and access enterprise data sets by leveraging OCI Data Catalog and AWS Glue metadata repositories.
- Use Apache Spark to analyze data in Autonomous Database with high performance.
Run mission-critical apps
Run and extend Oracle apps, such as PeopleSoft, JD Edwards, and Siebel, or your custom or ISV apps for improved performance, availability, and security.
- Migrating apps is easy. Autonomous Database runs the same Oracle Database you’re accustomed to running on-premises.
- Accelerate performance—Autonomous Database is preconfigured with optimized storage, automatic indexing, and data caching.
- Rely on a proven, industry-leading platform for all types of transaction processing, including OLTP transactions, lightweight transactions, augmented transactions, and stream event processing.
- Industry-proven transparent scalability and availability are provided.
- The workload is monitored, and indexes are automatically created and maintained.
- Protect data without downtime. Your database deployment is secure by default and automatically kept up-to-date with the latest database and security patches.
Develop JSON-centric apps
Develop apps quickly using a JSON document store that’s MongoDB-compatible but faster, more secure, and less expensive.
- Build JSON apps with high availability, dynamic scalability, and advanced security.
- Develop new apps using familiar MongoDB-compatible drivers, tools, and frameworks or migrate current MongoDB apps—all using Oracle Database API for MongoDB.
- Analyze your JSON data with scalable SQL, and access JSON from any relational tool or application.
- Tackle the hardest problems facing JSON database developers with ease, including multi-document ACID compliance, cross-collection joins, in-database procedural logic, and more.
- Enable analysts and data scientists to analyze data across the document store and relational store using SQL.
Reduce data management TCO
Automation reduces human labor costs and elastic scaling reduces licensing costs, with big benefits for total cost of operating enterprise applications. An IDC study of Autonomous Data Warehouse customers shows
- There’s an average five-year ROI of 417%, with breakeven on the investment occurring in an average of five months.
- Reducing management and licensing costs and user productivity lost to downtime enables organizations to lower their total cost of operations by an average of 63%.
- A flexible licensing model enables customers to cut their licensing costs by an average of 45%.
- The time needed to deploy a new database drops by an average of 84% and the staff time required falls by 85%.
Automate database administration tasks
Database administrators can move from manual administrative tasks to higher-value IT projects by taking advantage of automated management .
- Reduce time spent on DBA-related tasks by an average of 68% and save up to 63% in operational costs.
- Rely on automation for all database management tasks: provisioning, monitoring, backups, auditing, alerting, disaster recovery, and more.
- Deliver better service levels with proactive database health monitoring and built-in fault tolerance. Patches and updates are applied automatically without downtime or human intervention.
- Improve application performance without manually investigating the workloads and data distribution. Automatic partitioning and automatic indexing tune the database for your workloads.
Reduce costs with pay-per-use
Spend less on licensing and cloud consumption and avoid overprovisioning by deploying on an elastic cloud database.
- Ensure usage and billing are aligned with actual application needs and consumption with elastic autoscaling. Compute and storage scale up and down independently in response to transient changes in workload, up to 3X base-provisioned resources, and with no downtime.
- Increase base-provisioned resources at any time in response to longer-term compute and storage needs.
- Access your data lake data up to 20X faster with the same pricing as object storage by storing all your data in Autonomous Database.
- Consolidate database instances into elastic resource pools that scale up and down without downtime, potentially providing compute cost savings of up to 87% versus paying for each instance individually.
Address compliance
Reduce the risks associated with operating enterprise applications.
- Frequent, automatic patching without downtime means that Autonomous Database is always up-to-date on security patches.
- Backups are fully automated, with optional long-term backups available for 10 years.
- Auditing is always enabled.
- Autonomous Database meets certified regulatory compliance standards, including Federal Risk and Authorization Management Program (FedRAMP) High, the Health Insurance Portability and Accountability Act (HIPAA), the Payment Card Industry Data Security Standard (PCI DSS), System and Organization Controls (SOC) 1, and SOC 2.
Protect all your data
Autonomous Database helps keep all your data secure from unauthorized access by insiders, outsiders, and cyberattacks, including ransomware and malware.
- Frequent, automatic patching without downtime means that Autonomous Database is always up-to-date on security patches.
- Create a secure environment that will remain secure over time as conditions change. Use the included Oracle Data Safe to understand data sensitivity, evaluate data risks, mask sensitive data, implement and monitor security controls, assess user security, and monitor user activity.
- Protect against bad actors or malware with transparent data encryption. All data is always encrypted at rest, in motion, and when backed up.
- Prevent unauthorized users from accessing sensitive data, prevent unauthorized database changes, and address industry, regulatory, or corporate security standards with the included Oracle Database Vault.
- All users will see only appropriate data with advanced role-based access control, including redaction, masking, and filtering.
Ensure the highest availability for mission-critical applications
IT organizations can keep mission-critical applications running with less human involvement.
- Take advantage of 99.995% availability for Autonomous Database with Oracle Autonomous Data Guard (including planned and unplanned downtime). Maximize protection with multiple standby databases across multiple regions.
- Keep apps running with Application Continuity, which transparently recovers in-flight database transactions during outages.
- Avoid planned downtime with automated updates, backups, and patching that require no downtime and no human intervention.
- For less-critical apps, the default availability is 99.95%, and a lower-cost disaster recovery is available.