公开(公告)号：US10747814B2

公开(公告)日：2020-08-18

申请号：US15848737

申请日：2017-12-20

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Beda C. Hammerschmidt ,  Sriram Krishnamurthy ,  Ying Lu ,  Douglas J. McMahon ,  Srividya Tata ,  Vikas Arora

IPC: G06F16/30 ,  G06F16/84 ,  G06F16/27 ,  G06F16/2458 ,  G06F16/83 ,  G06F16/81

Abstract: Techniques are described herein for leveraging and extending relational data sharding infrastructure to provide comprehensive support for sharding semi-structured and unstructured data, in addition to the relational data, in a single sharded database system. Specifically, techniques are described in which a catalog server pre-gathers all data it needs to answer fetches from a dynamically created temporary lob. In addition, techniques are provided in which a catalog server encodes shard identifiers in lob locators sent to the client. Techniques are provided for pushing down various operators to shard servers.

公开(公告)号：US20200242158A1

公开(公告)日：2020-07-30

申请号：US16852094

申请日：2020-04-17

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Beda C. Hammerschmidt ,  Sriram Krishnamurthy ,  Ying Lu ,  Douglas J. McMahon ,  Srividya Tata ,  Vikas Arora

IPC: G06F16/84 ,  G06F16/27 ,  G06F16/2458 ,  G06F16/83 ,  G06F16/81 ,  G06F16/30

Abstract: Techniques are described herein for leveraging and extending relational data sharding infrastructure to provide comprehensive support for sharding semi-structured and unstructured data, in addition to the relational data, in a single sharded database system. Specifically, techniques are described in which a catalog server pre-gathers all data it needs to answer fetches from a dynamically created temporary lob. In addition, techniques are provided in which a catalog server encodes shard identifiers in lob locators sent to the client. Techniques are provided for pushing down various operators to shard servers.

公开(公告)号：US20190102476A1

公开(公告)日：2019-04-04

申请号：US15848737

申请日：2017-12-20

Applicant: Oracle International Corporation

Inventor： Zhen Hua Liu ,  Beda C. Hammerschmidt ,  Sriram Krishnamurthy ,  Ying Lu ,  Douglas J. McMahon ,  Srividya Tata ,  Vikas Arora

IPC: G06F17/30

Abstract: Techniques are described herein for leveraging and extending relational data sharding infrastructure to provide comprehensive support for sharding semi-structured and unstructured data, in addition to the relational data, in a single sharded database system. Specifically, techniques are described in which a catalog server pre-gathers all data it needs to answer fetches from a dynamically created temporary lob. In addition, techniques are provided in which a catalog server encodes shard identifiers in lob locators sent to the client. Techniques are provided for pushing down various operators to shard servers.

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

公开(公告)号：US11640380B2

公开(公告)日：2023-05-02

申请号：US17198159

申请日：2021-03-10

Applicant: Oracle International Corporation

Inventor： Hui Zhang ,  Zhen Hua Liu ,  Ying Lu ,  Beda Christoph Hammerschmidt ,  Douglas James McMahon ,  Denis B. Mukhin

IPC: G06F16/22

Abstract: Herein is acceleration for JavaScript object notation (JSON) documents in a relational database based on multilevel, multifield, multivalued indexing and querying. In an embodiment, into a table in a relational database, a computer stores many hierarchical data objects that respectively contain multiple levels that respectively contain one or more fields. An index is generated for indexed values in fields in at least two of the multiple levels. Based on the index, a database statement that references the table in the relational database and at least one of the indexed fields is executed. Indices herein provide matching to more fields in more levels of hierarchical data objects thereby decreasing or eliminating further filtering by brute force after index access. Matching ordinal positions within an array field needs no further filtration after index access. A single index provides increased spatial locality of index entries for acceleration. Index maintenance is minimized for acceleration.

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

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

公开(公告)号：US11481439B2

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

申请号：US17129085

申请日：2020-12-21

Applicant: oracle international corporation

Inventor： Zhen Hua Liu ,  Ying Lu ,  Hui Joe Chang

IPC: G06F16/835

Abstract: Techniques are described to improve query evaluation in computer systems. In an embodiment, a system receives a full text query for evaluation against a collection of hierarchically marked data object sets. The query specifies token(s) and context(s) which indicate hierarchical location(s) to match within a queried hierarchical data structure. To evaluate the query, the system determines a) data object set(s) that contain the query specified token(s) using token list(s), and/or b) data object set(s) that contain the query specified context(s) using label list(s).