Invention Grant
- Patent Title: Natively supporting JSON duality view in a database management system
-
Application No.: US17966730Application Date: 2022-10-14
-
Publication No.: US12287777B2Publication Date: 2025-04-29
- Inventor: Zhen Hua Liu , Juan R. Loaiza , Sundeep Abraham , Shubha Bose , Hui Joe Chang , Shashank Gugnani , Beda Christoph Hammerschmidt , Tirthankar Lahiri , Ying Lu , Douglas James McMahon , Aurosish Mishra , Ajit Mylavarapu , Sukhada Pendse , Ananth Raghavan
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Becker Bingham Ledesma LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/23 ; G06F16/2455

Abstract:
JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.
Public/Granted literature
- US20240126743A1 NATIVELY SUPPORTING JSON DUALITY VIEW IN A DATABASE MANAGEMENT SYSTEM Public/Granted day:2024-04-18
Information query