Oracle international corporation (20240126728). 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 20240126728 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 level of the object, and they are updated in a database using optimistic lock.

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

Potential Applications

The technology described in this patent application could have potential applications in:

• Database management systems
• Data modeling and storage
• Object-oriented programming

Problems Solved

This technology addresses the following problems:

• Efficient storage and retrieval of JSON objects in a database
• Simplifying the process of updating object states in a database
• Optimistic locking to prevent data conflicts

Benefits

The benefits of this technology include:

• Improved performance in handling JSON objects
• Enhanced data management capabilities
• Simplified data modeling processes

Potential Commercial Applications

A potential commercial application for this technology could be:

• Developing advanced database management systems for large enterprises

Possible Prior Art

One possible prior art related to this technology is the use of object-relational mapping (ORM) tools to map object-oriented programming concepts to relational databases.

Unanswered Questions

How does this technology compare to traditional object-relational mapping tools?

This article does not provide a direct comparison between JSON duality views and traditional ORM tools in terms of performance, scalability, or ease of use.

Are there any limitations or drawbacks to using JSON duality views?

The article does not address any potential limitations or drawbacks of implementing JSON duality views in a database management system.

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.