Oracle Brings Database Innovations to Simplify Development and Enhance Protection of Mission-Critical Apps

Oracle Database 23c Beta includes a new approach for addressing the object-relational mismatch for application developers

Enhancements to APEX low-code application development provide a better native mobile user experience

LAS VEGAS, Oct. 18, 2022 /PRNewswire/ -- Oracle CloudWorld -- Oracle today announced Oracle Database 23c Beta, the latest version of the world's leading converged database, supporting all data types, workloads, and development styles. Oracle Database 23c, code named "App Simple," focuses on simplifying applications and development. Many additional innovations across Oracle's database services and products portfolio extend Oracle's leadership in performance, security, and availability for mission-critical workloads.

Oracle Database 23c "App Simple" delivers advanced new capabilities that enable breakthrough developer productivity for applications that are written using JSON, Graph, or microservices, while also enhancing SQL to make it even easier to use and adding JavaScript as a stored procedure language. For example, Oracle Database 23c introduces a groundbreaking new approach called JSON Relational Duality for addressing the mismatch between how applications represent data versus how relational databases store data. JSON Relational Duality simplifies application development by allowing data to be simultaneously used as application-friendly JSON documents and as database-friendly relational tables. 

"Modern applications are built using new types of data such as JSON and Graph, new types of analytics such as machine learning, and new development styles such as microservices. The breadth and depth of data technologies used by modern applications can make developing and running apps increasingly complex," said Juan Loaiza, executive vice president, mission-critical database technologies, Oracle. "Oracle Database 23c 'App Simple' introduces game changing new technologies that make it dramatically easier to develop and run these modern apps."

To enhance data protection for mission-critical Oracle Database services on Oracle Cloud Infrastructure (OCI), Oracle also announced Oracle Database Zero Data Loss Autonomous Recovery Service, enabling organizations to address the challenges of ransomware, outages, and human errors more effectively. In addition, Oracle introduced Oracle Full Stack Disaster Recovery Service which allows customers to configure, monitor, and manage the disaster recovery process for the full stack of technologies used to build applications—including middleware, databases, networks, storage, and compute from the OCI console.

Industry analyst commentary

"JSON Relational Duality in Oracle Database 23c brings substantial simplicity and flexibility to modern app dev," said Carl Olofson, research vice president, Data Management Software, IDC. "It addresses the age-old object–relational mismatch problem, offering an option for developers to pick the best storage and access formats needed for each use case without having to worry about data structure, data mapping, data consistency, or performance tuning. No other specialized document databases offer such a revolutionary solution." 

"With over 300 new features and enhancements, including JSON Relational Duality, Operational Graphs, Microservices support, real-time machine learning and support for new data types, the next generation Oracle Database 23c is poised to gain app developer mindshare and make it extremely simple to develop and run data-driven mission-critical apps," said Holger Mueller, vice president and principal analyst, Constellation Research. "Clearly Oracle has delivered on the 'App Simple' code name of its latest Database 23c, and it'll undoubtedly be a 'must see' debut at CloudWorld."

"Oracle Database 23c more than lives up to its code name—App Simple—by taking application development to unprecedented levels of task reduction, simplification, and automation," said Marc Staimer, senior analyst, Wikibon. "Oracle Database 23c definitively ends the long running 'relational vs. document' debate with JSON Relational Duality delivering the best of both worlds. Data is stored as rows in relational format, while data can be accessed as JSON formats. Developers can operate on the same data without having to worry about data structure, data mapping, data consistency, or performance tuning."

Developer productivity improvements 

• Oracle Database 23c brings new functionality to assist developers in building the next generation of mission-critical, high-performance database applications. As the only complete and simple converged database for developers, data engineers, and DBAs, Oracle Database 23c includes JSON Relational Duality, JavaScript stored procedures, property graph analysis of operational data, automated handling of distributed microservices transactions (known as sagas), enhanced Automatic Materialized Views, real-time SQL Plan Management, True Cache, ML-enhanced prediction of data statistics for optimizing SQL execution, and native replication of database shards. Additional functionality includes the ability to enable Kafka applications to run directly against Oracle Database and protection from unauthorized SQL via any execution path using the new SQL Firewall embedded in the Oracle Database. It is now available in beta globally for Oracle customers who complete the beta sign-up process.
• Oracle Database API for MongoDB now provides MongoDB compatibility to Oracle
  Database for on-premises environments. The API enables MongoDB developers to build and run new MongoDB applications on Oracle Database using the MongoDB tools, drivers, and frameworks that they are familiar with, as well as the ability to migrate existing MongoDB workloads to Oracle Database without modifying their applications. 
• GoldenGate 23c is certified with Oracle Database 23c and previous versions, and introduces new features that improve usability, performance, diagnostics, and security. Highlights include faster JSON replication performance, new replication support for blockchain and immutable tables, and application patching without downtime using Edition-Based Redefinition. In addition, OCI GoldenGate now supports 40+ new data connections from Oracle and non-Oracle sources across multicloud environments, including AWS and Azure, and new Stream Analytics for continuous data integration and data-in-motion analytics.
• GoldenGate Free enables prospects, customers, developers, and students to use GoldenGate and its new user experience and entirely automated replication lifecycle for free. It is designed for development, devops, test, and production source or target databases of 20GB or less on OCI, on other clouds, or on-premises.
• Autonomous Data Warehouse introduces new capabilities enabling organizations to improve collaboration across teams by sharing data with the open-source Delta Sharing protocol and business models using in-database Analytic Views. Along with existing built-in support for Oracle Analytics and tools such as Tableau, a new Microsoft Excel add-in and a complete and embedded data integration tool with Transforms will be available. In addition, new Oracle Application Accelerators for Oracle E-Business Suite provide ready-to-use data models, KPIs, and data integration.
• Oracle APEX 22.2 (preview) strengthens its position in low-code application development by introducing enhancements to progressive web apps to provide a virtually native mobile user experience. Also available is a new workflow approval component for integrating task management into APEX apps. In addition, developers now have access to out-of-the-box integrations with 3rd-party apps and data, providing a richer application development platform. Oracle APEX is a fully supported, no-additional-cost feature of Oracle Database and Oracle Autonomous Database, as well as a developer service on OCI.
• Transaction Manager for Microservices Free enables use of distributed transactions in microservices-based applications deployed in Kubernetes. With Transaction Manager for Microservices, customers can create a global transaction that includes multiple microservices developed in various programming languages and on different application platforms. Transaction Manager for Microservices is now free for use by prospects, customers, developers, and students.
• Tuxedo 22c provides enhancements for deploying Tuxedo applications (written in C/C++ or COBOL) in Kubernetes and cloud environments, as well as XA transaction interoperability with microservices deployed in Kubernetes using Oracle Transaction Manager for Microservices. It includes ready-to-use container images, sample Helm charts for various Kubernetes distributions, integration with native Kubernetes tools and environments, new HA enhancements, and stronger security. Used together, the combination of Tuxedo 22c and Transaction Manager for Microservices accelerates the mainframe modernization initiatives underway at many large enterprises.

Continuous protection of mission-critical databases

• Oracle Database Zero Data Loss Autonomous Recovery Service provides secure backup and fast, predictable recovery for Oracle Database services and Autonomous Database running on OCI. It uses database-aware intelligence and automation to help protect transactions as they occur, reduces overhead on operational database services, validates database recoverability, and automates both backup and recovery processes. With this new service, organizations can help mitigate the impact of ransomware, outages, and human errors by restoring databases to the point-in-time just before the attack, outage, or error occurred.
• OCI Full Stack Disaster Recovery Service allows customers to monitor and manage the entire disaster recovery process of their entire technology stack from the OCI console. With a single click, it manages disaster recovery for applications, middleware, networks, storage, and compute for a variety of disaster recovery topologies. It offers intelligent features to quickly create cross-regional relationships, DR plans, and performs comprehensive checks before a disaster recovery plan is executed to ensure success in the standby region.

New Oracle Autonomous Database support for applications

• Oracle E-Business Suite is certified to run on the Oracle Autonomous Database service on OCI, enabling organizations to further reduce database administration, optimize resource utilization, and lower costs.

Additional Resources

• Learn more about Oracle Database
• Read the latest industry analyst reports

About Oracle

Oracle offers integrated suites of applications plus secure, autonomous infrastructure in the Oracle Cloud. For more information about Oracle (NYSE: ORCL), please visit us at oracle.com.

About Oracle CloudWorld

Oracle CloudWorld is Oracle's largest global celebration of customers and partners. Join us to discover the insights you need to tackle your biggest business challenges, build your skills, knowledge, and connections, and learn more about our cloud infrastructure, database and applications from the people that build and use them. For registration, live keynotes, session details, news and more visit oracle.com/cloudworld or oracle.com/news.

Future Product Disclaimer

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle's products may change and remains at the sole discretion of Oracle Corporation.

Forward-Looking Statements Disclaimer

Statements in this article relating to Oracle's future plans, expectations, beliefs, and intentions are "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect Oracle's current expectations and actual results, and could cause actual results to differ materially. A discussion of such factors and other risks that affect Oracle's business is contained in Oracle's Securities and Exchange Commission (SEC) filings, including Oracle's most recent reports on Form 10-K and Form 10-Q under the heading "Risk Factors." These filings are available on the SEC's website or on Oracle's website at http://www.oracle.com/investor. All information in this article is current as of October 18, 2022 and Oracle undertakes no duty to update any statement in light of new information or future events.

Trademarks

Oracle, Java, and MySQL are registered trademarks of Oracle Corporation.

SOURCE Oracle