Oracle international corporation (20240126729). NATIVELY SUPPORTING JSON DUALITY VIEW IN A DATABASE MANAGEMENT SYSTEM simplified abstract

NATIVELY SUPPORTING JSON DUALITY VIEW IN A DATABASE MANAGEMENT SYSTEM

Organization Name

oracle international corporation

Inventor(s)

ZHEN HUA Liu of San Mateo CA (US)

JUAN R. Loaiza of Woodside CA (US)

SUNDEEP Abraham of Redwood City CA (US)

SHUBHA Bose of Foster City CA (US)

HUI JOE Chang of San Jose CA (US)

SHASHANK Gugnani of Redwood City CA (US)

BEDA CHRISTOPH Hammerschmidt of Palo Alto CA (US)

TIRTHANKAR Lahiri of Palo Alto CA (US)

YING Lu of San Jose CA (US)

DOUGLAS JAMES Mcmahon of Redwood City CA (US)

AUROSISH Mishra of Sunnyvale CA (US)

AJIT Mylavarapu of Mountain View CA (US)

SUKHADA Pendse of Foster City CA (US)

ANANTH Raghavan of San Francisco CA (US)

NATIVELY SUPPORTING JSON DUALITY VIEW IN A DATABASE MANAGEMENT SYSTEM - A simplified explanation of the abstract

This abstract first appeared for US patent application 20240126729 titled 'NATIVELY SUPPORTING JSON DUALITY VIEW IN A DATABASE MANAGEMENT SYSTEM

Simplified Explanation

The abstract describes a patent application related to JSON duality views, which are object views that return JDV objects. These JDV objects are virtual and not stored in a database as JSON objects, but rather in shredded form across tables and table attributes. Changes to the state of a JDV object can be specified at the JDV object level, and they are updated in a database using optimistic lock.

• JSON duality views return JDV objects
• JDV objects are virtual and stored in shredded form across tables
• Changes to JDV objects can be specified at the object level
• JDV objects are updated in a database using optimistic lock

Potential Applications

The technology could be applied in database management systems, data analytics, and data integration tools.

Problems Solved

This technology solves the problem of efficiently managing and updating virtual objects in a database without storing them as JSON objects.

Benefits

The benefits of this technology include improved performance, flexibility in managing object views, and enhanced data organization.

Potential Commercial Applications

The technology could be commercially apply in database software, data management tools, and enterprise software solutions.

Possible Prior Art

One possible prior art could be the use of virtual objects in database systems for improved data management.

How does this technology impact database performance?

This article does not provide specific details on the performance implications of using JSON duality views. Further research or testing may be needed to understand the performance impact.

Are there any limitations to the optimistic lock approach in updating JDV objects?

The article does not discuss any potential limitations or challenges associated with using optimistic lock for updating JDV objects. Further investigation may be required to identify any drawbacks of this approach.

Original Abstract Submitted

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.