Oracle Autonomous Transaction Processing for Advanced OLTP

Autonomous transaction processing (Oracle ATP) is the backbone of modern-day commerce. Whether you are a bank, aviation, online grocery, cab service, food delivery, manufacturing, or any other business with ever-increasing, mission-critical OLTP workloads – you need a high-performance, secure, ACID-reliable (atomicity, consistency, isolation, durability), and fail-safe transaction processing system, capable of intelligently dealing with all the industry-specific challenges using a spectrum of game-changing capabilities.

Hence, the Oracle Autonomous Transaction Processing database service, that singly offers you all the benefits of driving a business in the 21st century, under a unified, converged, next-generation architecture.

What is Autonomous Transaction Processing?

Autonomous Transaction Processing is one of the flagship, cloud-native database services by Oracle, that is designed to phase out the complexities of configuring, provisioning, tuning, scaling, patching, securing, repairing, rollback, failover, etc., and offer a highly available database experience optimized for advanced OLTP, operational intelligence, and event processing related contemporary use cases.

page image 1

With capabilities such as the Real Application Clusters (RAC), partitioning, multitenancy, in-memory, advanced compression, and industry-leading security, building the low-code and heavy-duty, business-critical applications becomes a cakewalk. To further add to its productivity, the Autonomous Transaction Processing service is ready for deployment in both, Oracle Cloud Infrastructure (OCI), and Exadata [email protected] —a dedicated cloud region—behind your enterprise firewall.

Features and Benefits of Autonomous Transaction Processing

  1. Oracle ATP Autonomous Operations

Autonomous provisioning: The Oracle Autonomous Transaction Processing deploys fault-tolerant and highly available databases in a matter of seconds.

Autonomous scaling: Oracle ATP scales out compute and storage resources automatically to match performance and throughput requirements with absolutely zero downtime, enabling a true pay-as-you-go experience for customers via the online dynamic scaling.

Autonomous tuning: Oracle ATP auto-configures and auto-tunes databases, unaffected by the ever-changing data and schema. From data formats, memory configurations, indexes, to access structures, all are optimized for boosting performance, automatically.

Autonomous backups: Autonomous transaction processing also translates to performing full weekly and daily incremental backups of the database inside Oracle Object Storage and preserving them for up to 60 days for instant point-in-time recovery/restore.

Autonomous repairing: Oracle ATP mends all the software and hardware issues by constantly tracking and forecasting failures. Meanwhile, the transactional requests are instantly redirected to healthy devices, upholding the performance of the database.

Autonomous failover: The Oracle Autonomous Database for transaction processing also discards the concerns related to site downtime by keeping a real-time remote copy of the production database, and orchestratedly switching from primary to the remote copy via the Oracle Autonomous Data Guard.

Access an in-depth technical webcast on fast-tracking developer and data productivity with Oracle ATP database’s autonomous capabilities, here.

  1. Oracle ATP – A futuristically-simplified application development platform

Relational and non-relational data models compatibility: Oracle ATP database is natively compatible with multiple data types comprising JSON, graph, document, graph, XML, spatial, etc., for accelerated application development. On top it, the autonomous database also precludes data fragmentation and reduces inconveniences in data management caused by siloed data stores.

The flexible REST API support in Oracle ATP: This feature of the autonomous transaction processing database extends the benefits of database management REST APIs, PL/SQL Gateway, and web interface for a simplified access to all your data.

Low-code/No-code application development with Oracle APEX: This feature refers to the integration of Oracle ATP and Oracle APEX for delivering a low-code application development platform, aimed at discarding a whopping 98% of the physical code work, resulting in a rapid yet high-end application building.

Machine learning (ML) algorithms in Oracle ATP database: The database extends beyond 30 ML algorithms, functions, and integrations with open-source Python/R for fostering more ML models development, and analytical dashboards without having to send data out of the database.

Automated tools for API-driven apps: The Oracle Autonomous Transaction Processing database has a built-in set of data tools that enable self-service data ingestion, data transformations, and business models redefining the running of complex queries surpassing multiple data types, creating sophisticated analytical models, and data visualization.

Rapid cloning: Build fast clones of the complete Oracle database from running instances and backup database, or only the metadata for quickly kickstarting new projects.

Oracle-Microsoft, ATP-Azure Interoperability: This segment of the Oracle Autonomous Transaction Processing extends full support for multi-cloud services via fast interconnections with Microsoft Azure.

  1. Oracle ATP’s Industry-Leading Data Security

The ‘Always-on’ security model: Autonomous transaction processing database by Oracle offers database-wide automatic encryption and admin-defined encryption keys for backups, ensuring the data is always protected, whether at rest or in-flight.

Automatic security updates/patching: Oracle frequently auto-patches ATP database against the new security vulnerabilities, however, at zero downtime – meaning, applications keep running undisturbed throughout the patching sessions.

Data privacy in Oracle ATP: This part of the Oracle autonomous transaction processing empowers admins to execute all administrative tasks without revealing the customer data to the self. Oracle database either blocks access to operating system (OS) or the administrator rights for avoiding phishing attacks.

Data masking with Oracle Data Safe: Fusing Data Safe with Autonomous Transaction Processing turns discovery of the sensitive data, security risks evaluation, data masking, and security control tracking / implementation incredibly easy.

Best-in-class auditing: The Oracle ATP seamlessly logs events with nominal impact on performance, while also opening up the gates for monitoring audits any time of the day for analysis, compliance, or forensics. This feature is also accessible via the Oracle’s new voice assistance, right on users’ mobile devices.

  1. Ultimate performance and availability SLA of 99.95%

Unparalleled performance: Oracle Autonomous Transaction Processing database singly brings 80% lower latency and beyond five-times throughput than any other cloud service providers. This is made possible by harnessing the Oracle’s database-optimized hardware, automatic tuning, and indexing.

Always available: The Oracle ATP offers above 99.95% availability, leveraging a blend of Oracle’s 2nd Generation Cloud Infrastructure, Oracle Real Application Clusters (RAC), Autonomous Data Guard, and regular automatic backups – all declared in the Service Level Agreement (SLA).

Defense against human error: The Oracle Flashback embedded in Oracle Autonomous Transaction Processing, promptly reverses accidental modifications to application schemas, safeguarding the users from human errors. The recovery integration against human error works at all tiers including rows, tables, and transactions across the whole ATP database.