Impact of JSON Relational Duality Views on Development

This document is a technical report that discusses the introduction of JSON Relational Duality Views in Oracle 23c and their potential impact on database application development. It outlines a historical perspective on database application development shifts from traditional relational databases to modern web architectures utilizing REST services and object-oriented programming. The report explains how the new duality views allow for a more effective approach to Object-Relational Mapping (ORM) by enabling a direct mapping of JSON documents to relational tables, thereby simplifying data retrieval and manipulation. It details the advantages of using duality views, including a declarative approach that reduces the need for coding while ensuring ACID compliance in data operations. Additionally, the report highlights the limitations of duality views in supporting XML and suggests a potential solution for future Oracle releases. Overall, the insights presented may significantly influence how developers design and implement database solutions in contemporary environments.