公开(公告)号：US11762834B2

公开(公告)日：2023-09-19

申请号：US17860192

申请日：2022-07-08

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Sriram Krishnamurthy ,  Beda C. Hammerschmidt ,  Douglas J. McMahon ,  Hui Joe Chang ,  Ying Lu ,  Joshua Spiegel ,  Srikrishnan Suresh ,  Vikas Arora ,  Geeta Arora ,  Sundeep Abraham ,  Hui Zhang ,  Alfonso Colunga Sosa

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F11/34 ,  G06F16/242

CPC classification number: G06F16/2282 ,  G06F11/3409 ,  G06F16/221 ,  G06F16/244 ,  G06F16/248 ,  G06F16/24552 ,  G06F16/24556

Abstract: Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.

公开(公告)号：US20210081389A1

公开(公告)日：2021-03-18

申请号：US16904417

申请日：2020-06-17

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Sriram Krishnamurthy ,  Beda C. Hammerschmidt ,  Douglas J. McMahon ,  Hui Joe Chang ,  Ying Lu ,  Joshua Spiegel ,  Srikrishnan Suresh ,  Vikas Arora ,  Geeta Arora ,  Sundeep Abraham ,  Hui Zhang ,  Alfonso Colunga Sosa

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F16/242 ,  G06F11/34

Abstract: Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.

公开(公告)号：US12298946B2

公开(公告)日：2025-05-13

申请号：US17966736

申请日：2022-10-14

Applicant: Oracle International Corporation

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

IPC: G06F16/20 ,  G06F16/21 ,  G06F16/2453 ,  G06F16/84

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.

公开(公告)号：US11899644B2

公开(公告)日：2024-02-13

申请号：US17860187

申请日：2022-07-08

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Sriram Krishnamurthy ,  Beda C. Hammerschmidt ,  Douglas J. McMahon ,  Hui Joe Chang ,  Ying Lu ,  Joshua Spiegel ,  Srikrishnan Suresh ,  Vikas Arora ,  Geeta Arora ,  Sundeep Abraham ,  Hui Zhang ,  Alfonso Colunga Sosa

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F11/34 ,  G06F16/242

CPC classification number: G06F16/2282 ,  G06F11/3409 ,  G06F16/221 ,  G06F16/244 ,  G06F16/248 ,  G06F16/24552 ,  G06F16/24556

Abstract: Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.

公开(公告)号：US11423001B2

公开(公告)日：2022-08-23

申请号：US16904417

申请日：2020-06-17

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Sriram Krishnamurthy ,  Beda C. Hammerschmidt ,  Douglas J. McMahon ,  Hui Joe Chang ,  Ying Lu ,  Joshua Spiegel ,  Srikrishnan Suresh ,  Vikas Arora ,  Geeta Arora ,  Sundeep Abraham ,  Hui Zhang ,  Alfonso Colunga Sosa

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F11/34 ,  G06F16/242

Abstract: Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.

公开(公告)号：US12287777B2

公开(公告)日：2025-04-29

申请号：US17966730

申请日：2022-10-14

Applicant: Oracle International Corporation

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

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.

公开(公告)号：US20220342865A1

公开(公告)日：2022-10-27

申请号：US17860192

申请日：2022-07-08

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Sriram Krishnamurthy ,  Beda C. Hammerschmidt ,  Douglas J. McMahon ,  Hui Joe Chang ,  Ying Lu ,  Joshua Spiegel ,  Srikrishnan Suresh ,  Vikas Arora ,  Geeta Arora ,  Sundeep Abraham ,  Hui Zhang ,  Alfonso Colunga Sosa

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F11/34 ,  G06F16/242

Abstract: Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.

公开(公告)号：US20220342864A1

公开(公告)日：2022-10-27

申请号：US17860187

申请日：2022-07-08

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Sriram Krishnamurthy ,  Beda C. Hammerschmidt ,  Douglas J. McMahon ,  Hui Joe Chang ,  Ying Lu ,  Joshua Spiegel ,  Srikrishnan Suresh ,  Vikas Arora ,  Geeta Arora ,  Sundeep Abraham ,  Hui Zhang ,  Alfonso Colunga Sosa

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F11/34 ,  G06F16/242

Abstract: Herein is a self-tuning database management system (DBMS) storing JavaScript object notation (JSON) documents and operating a JSON datatype as native to the DBMS. In an embodiment, a computer hosts a DBMS that executes a data definition language (DDL) statement that defines, in a database dictionary of the DBMS, a JSON document column of a database table that stores JSON documents as instances of the JSON datatype that is native in the DBMS. The DBMS may autonomously set or adjust configuration settings that control behaviors such as a default width of a JSON document column, in lining or not of the JSON document column, kind and scope and duration of indexing of the JSON document column, and/or caching of the JSON document column such as in an in memory columnar unit (IMCU). The DBMS may use the various configuration settings to control how JSON documents and the native JSON datatype are stored and/or processed.