Techniques for comprehensively supporting JSON schema in a RDBMS
AssigneeOracle International Corporation
InventorsZhen Hua Liu, Srikrishnan Suresh, Beda Christoph Hammerschmidt, Joshua Spiegel, Douglas James McMahon
Life of this patent
Estimating the term…
Abstract
JSON schemas are implemented efficiently within a DBMS. Through these techniques, the power and benefit of schema-based paradigm are realized in a more cost-effective manner in terms of computer system performance. JSON schema-based techniques described herein improve execution efficiency of database statements that access JSON objects and improve software development productivity.
Claims24
A method, comprising:
- a database management system (DBMS) receiving one or more data definition language (DDL) statements defining a JavaScript Object Notation (JSON) schema for a JSON column of a database table, said JSON schema defining a plurality of JSON fields for a JSON object, and said JSON schema declaring a first field of said plurality of JSON fields as a native database data type of said DBMS, wherein said native database data type is assignable to columns of database tables of said DBMS, and said native database data type is recognized as a valid data type of the DBMS without the native database data type being defined in a database dictionary of the DBMS;
- said DBMS receiving a first data manipulation language (DML) statement specifying to insert a particular JSON object into said JSON column;
- and
- in response to receiving the first DML statement:
- determining that a field value for said first field in said particular JSON object conforms to said native database data type;
- and
- inserting said particular JSON object in said JSON column.
One or more non-transitory storage media storing instructions that, when executed by one or more computing devices, cause performance of:
- a database management system (DBMS) receiving one or more data definition language (DDL) statements defining a JavaScript Object Notation (JSON) schema for a JSON column of a database table, said JSON schema defining a plurality of JSON fields for a JSON object, and said JSON schema declaring a first field of said plurality of JSON fields as a native database data type of said DBMS, wherein said native database data type is assignable to columns of database tables of said DBMS, and said native database data type is recognized as a valid data type of the DBMS without the native database data type being defined in a database dictionary of the DBMS;
- said DBMS receiving a first data manipulation language (DML) statement specifying to insert a particular JSON object into said JSON column;
- and
- in response to receiving the first DML statement:
- determining that a field value for said first field in said particular JSON object conforms to said native database data type;
- and
- inserting said particular JSON object in said JSON column.
Dependencies are inferred from the claim text.