公开(公告)号：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.

公开(公告)号：US20240119031A1

公开(公告)日：2024-04-11

申请号：US18115629

申请日：2023-02-28

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Srikrishnan Suresh ,  Beda Christoph Hammerschmidt ,  Adrian Daniel Popescu ,  Jesse Kamp ,  Zhen Hua Liu

IPC: G06F16/21 ,  G06F16/23 ,  G06F16/25

CPC classification number: G06F16/212 ,  G06F16/2365 ,  G06F16/258

Abstract: A computer analyzes a relational schema of a database to generate a data entry schema and encodes the data entry schema as JSON. The data entry schema is sent to a database client so that the client can validate entered data before the entered data is sent for storage. From the client, entered data is received that conforms to the data entry schema because the client used the data entry schema to validate the entered data before sending the data. Into the database, the entered data is stored that conforms to the data entry schema. The data entry schema and the relational schema have corresponding constraints on a datum to be stored, such as a range limit for a database column or an express set of distinct valid values. A constraint may specify a format mask or regular expression that values in the column should conform to, or a correlation between values of multiple columns.

公开(公告)号：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.

公开(公告)号：US12147398B2

公开(公告)日：2024-11-19

申请号：US18115629

申请日：2023-02-28

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Srikrishnan Suresh ,  Beda Christoph Hammerschmidt ,  Adrian Daniel Popescu ,  Jesse Kamp ,  Zhen Hua Liu

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/23 ,  G06F16/25

Abstract: A computer analyzes a relational schema of a database to generate a data entry schema and encodes the data entry schema as JSON. The data entry schema is sent to a database client so that the client can validate entered data before the entered data is sent for storage. From the client, entered data is received that conforms to the data entry schema because the client used the data entry schema to validate the entered data before sending the data. Into the database, the entered data is stored that conforms to the data entry schema. The data entry schema and the relational schema have corresponding constraints on a datum to be stored, such as a range limit for a database column or an express set of distinct valid values. A constraint may specify a format mask or regular expression that values in the column should conform to, or a correlation between values of multiple columns.

公开(公告)号：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.