Duality Views
AI blog Database docker Duality Views Go Graph Java JDBC JMS JPA JSON Kafka livesql microservices MongoDB NodeJS Observability OCI oraclefree Oracle Text ORDS PDB performance PL/SQL python security Spatial SpringBoot Testcontainers TxEventQ TypeScript Vector Search
-

MongoDB Over Relational Data: JSON Relational Duality Views
Can your MongoDB client be used against a document-shaped contract while the system of record stays…
-

Generate JSON Relational Duality Views from JPA entities
Oracle AI Database’s JSON Relational Duality Views (or simply duality views) let you treat relational tables…
-

Hands-on CRUD with JDBC and JSON Relational Duality Views
JSON Relational Duality Views are one of my favorite Oracle AI Database features (I’ll call them…
-

Multiple Views, One Schema: Simple RBAC with Duality Views
In this article, we’ll explore how JSON Relational Duality Views can be used to decompose a…
-

Virtual, Materialized, and @generated columns
In this article, we’ll explore virtual and materialized columns and @generated fields in JSON Relational Duality…
-

Using a modern database? You might not need that ORM anymore
Object Relational Mapping (ORM) frameworks translate programming objects to SQL statements. ORM implementations are found in…
-

Lock-Free Writes at Scale: Under the Hood of Duality Views
In this article, we’ll explore Lock-Free Concurrency, a form of optimistic concurrency control. We’ll see how…
-

GraphQL syntax for JSON Relational Duality Views
Working with JSON Relational Duality Views, you can use the SQL or GraphQL DDL syntax. I…
-

Many-to-many data modelling with JSON Relational Duality Views
Oracle Database JSON Relational Duality Views are a powerful tool that combines the functionality of document…
-

Simple RESTful services with ORDS: Duality Views
In this article, we’ll create a RESTful webservice that can GET/POST/PUT/DELETE relational JSON documents. The best…