17966736. NATIVELY SUPPORTING JSON DUALITY VIEW IN A DATABASE MANAGEMENT SYSTEM simplified abstract (Oracle International Corporation)

From WikiPatents
Jump to navigation Jump to search

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 17966736 titled 'NATIVELY SUPPORTING JSON DUALITY VIEW IN A DATABASE MANAGEMENT SYSTEM

Simplified Explanation

In a JSON Duality View, JDV objects are virtual objects that are not stored in a database as JSON objects. Instead, they are stored in shredded form across tables and table attributes, and are returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Changes to the state of a JDV object can be specified at the level of the object, and JDV objects are updated in a database using optimistic lock.

  • JDV objects are virtual objects stored 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.
  • JDV objects are updated in a database using optimistic lock.

Potential Applications

The technology of JSON Duality Views can be applied in various fields such as data management, database systems, and software development.

Problems Solved

JSON Duality Views help in managing complex data structures efficiently, enabling easy retrieval and manipulation of data stored in a database.

Benefits

- Improved data management and organization - Efficient retrieval and manipulation of data - Optimistic lock for updating JDV objects

Potential Commercial Applications

Optimized database systems for large-scale enterprises

Possible Prior Art

Prior art in the field of database management systems and object-oriented programming languages may exist, but further research is needed to identify specific examples.

Unanswered Questions

How does JSON Duality Views compare to traditional object-relational mapping techniques?

JSON Duality Views provide a different approach to managing object views in a database compared to traditional object-relational mapping techniques. While traditional techniques map objects to relational tables, JSON Duality Views store virtual objects in shredded form across tables and attributes. This allows for more flexibility and efficiency in managing complex data structures.

What are the potential security implications of using JSON Duality Views in a database system?

The use of JSON Duality Views in a database system may raise security concerns related to data access and manipulation. It is important to consider how access control mechanisms can be implemented to ensure the integrity and confidentiality of data stored in JDV objects.


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.