-
公开(公告)号:US20200242156A1
公开(公告)日:2020-07-30
申请号:US16852075
申请日: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
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.
-
2.
公开(公告)号:US20200210398A1
公开(公告)日:2020-07-02
申请号:US16690817
申请日:2019-11-21
Applicant: Oracle International Corporation
Inventor: Zhen Hua Liu , Vikas Arora , Ying Lu , Sriram Krishnamurthy , Hui Joe Chang , Beda Christoph Hammerschmidt , Joshua Jeffrey Spiegel
IPC: G06F16/22 , G06F16/2455 , G06F16/28
Abstract: The present invention relates to autonomous tuning of a data grid of documents in a database. Herein are techniques for storage cells to autonomously maintain local indices and other optimization metadata and algorithms to accelerate selective access into a distributed collection of documents. In an embodiment, each storage cell persists a respective subset of documents. Each storage cell stores, in memory, respective index(s) that map each item to location(s), in one or more documents of the respective subset of documents, where the item occurs. One or more computers execute, based on at least a subset of the indices of the storage cells, a data access request from a database management system. In an embodiment, a cloud of JSON document services provides an easy-to-use, fully autonomous JSON document database that horizontally and elastically scales to deliver fast execution of document transactions and queries without needing tuning by a database administrator.
-
公开(公告)号: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.
-
公开(公告)号: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.
-
公开(公告)号:US11507590B2
公开(公告)日:2022-11-22
申请号:US16904392
申请日:2020-06-17
Applicant: Oracle International Corporation
Inventor: Siva Ravada , Ying Hu , Zhen Hua Liu , Shasank Kisan Chavan , Aurosish Mishra , Vikas Arora
IPC: G06F16/25 , G06F16/22 , G06F9/38 , G06F16/242 , G06F16/2457
Abstract: Techniques are introduced herein for maintaining geometry-type data on persistent storage and in memory. Specifically, a DBMS that maintains a database table, which includes at least one column storing spatial data objects (SDOs), also maintains metadata for the database table that includes definition data for one or more virtual columns of the table. According to an embodiment, the definition data includes one or more expressions that calculate minimum bounding box values for SDOs stored in the geometry-type column in the table. The one or more expressions in the metadata maintained for the table are used to create one or more in-memory columns that materialize the bounding box data for the represented SDOs. When a query that uses spatial-type operators to perform spatial filtering over data in the geometry-type column is received, the DBMS replaces the spatial-type operators with operators that operate over the scalar bounding box information materialized in memory.
-
公开(公告)号:US11226955B2
公开(公告)日:2022-01-18
申请号:US16022465
申请日:2018-06-28
Applicant: Oracle International Corporation
Inventor: Zhen Hua Liu , Aurosish Mishra , Shasank K. Chavan , Douglas J. McMahon , Vikas Arora , Hui Joe Chang , Shubhro Jyoti Roy
IPC: G06F16/30 , G06F16/23 , G06F16/22 , G06F16/2455
Abstract: A “hybrid derived cache” stores semi-structured data or unstructured text data in an in-memory mirrored form and columns in another form, such as column-major format. The hybrid derived cache may cache scalar type columns in column-major format. The structure of the in-memory mirrored form of semi-structured data or unstructured text data enables and/or enhances access to perform path-based and/or text based query operations. A hybrid derived cache improves cache containment for executing query operations. The in-memory mirrored form is used to compute queries in a transactionally consistent manner through the use of an invalid vector that used to determine when to retrieve the transactionally consistent persistent form of semi-structured data or unstructured text data in lieu of the in-memory form.
-
公开(公告)号:US20210081428A1
公开(公告)日:2021-03-18
申请号:US16904392
申请日:2020-06-17
Applicant: Oracle International Corporation
Inventor: Siva Ravada , Ying Hu , Zhen Hua Liu , Shasank Kisan Chavan , Aurosish Mishra , Vikas Arora
IPC: G06F16/25 , G06F16/22 , G06F16/2457 , G06F16/242 , G06F9/38
Abstract: Techniques are introduced herein for maintaining geometry-type data on persistent storage and in memory. Specifically, a DBMS that maintains a database table, which includes at least one column storing spatial data objects (SDOs), also maintains metadata for the database table that includes definition data for one or more virtual columns of the table. According to an embodiment, the definition data includes one or more expressions that calculate minimum bounding box values for SDOs stored in the geometry-type column in the table. The one or more expressions in the metadata maintained for the table are used to create one or more in-memory columns that materialize the bounding box data for the represented SDOs. When a query that uses spatial-type operators to perform spatial filtering over data in the geometry-type column is received, the DBMS replaces the spatial-type operators with operators that operate over the scalar bounding box information materialized in memory.
-
公开(公告)号: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
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.
-
-
-
-
-
-
-
-
-