Explore how to evolve database applications entirely online in this 23-minute Oracle Database World conference talk. Discover unique Oracle Database features that enable safe and uninterrupted schema changes, data movement, and table reorganizations. Learn about integrating DevOps tools for code versioning control and implementing automated development pipelines. Dive into topics such as rolling deployments, stateful dependencies, database cloning, SQL development tools, and consistent schema change management. Examine the benefits of Edition-Based Redefinition and online table redefinition for mission-critical application workloads. Gain insights into building and testing at every code merge in feature branches, and understand how to optimize database operations for continuous application evolution without disrupting traffic.
How to Evolve Your Database Applications Entirely Online
Overview
Syllabus
Intro
Software Development DevOps concepts
OCI DevOps A complete
Online Application Upgrades with Rolling Deployments Application containers are usually stateless
Online Application Upgrades with Stateful Dependencies Databases are stateful, so what about incompatible schema changes?
Pipelining the Database Cloning An example: using Autonomous Database dones
Use the Right Tool for SQL Development SQLd integrales perfectly with CVCD pipelines
Generate and Apply Consistent and Repeatable Changes Versioning and controlling the schema changes
Build and Test at Every Code Merge in the Feature Branches A Partial Example of CI Pipeline Specification
Edition-Based Redefinition
Non-Editionable Objects Online Operations Optimized for mission-critical application workloads
Online Table Redefinition Where normal online operation cannot go, there is DBMS_REDEFINITION
Taught by
Oracle
