-
公开(公告)号：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.
-
公开(公告)号：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.
-
公开(公告)号：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.
-
Patent Agency Ranking
公开(公告)号：US20250147936A1
公开(公告)日：2025-05-08
申请号：US18420708
申请日：2024-01-23
Applicant: Oracle International Corporation
Inventor： Shashank Gugnani , Ajit Mylavarapu , Sukhada Pendse , Tirthankar Lahiri , Shadab Ahmed , Sanju Gowda , Beda C. Hammerschmidt , Zhen Hua Liu
Abstract: Techniques for automatically migrating documents from a document database to a relational database are provided. In one technique, it is determined whether a set of documents, from a document database system, can be stored in a relational database system. If so, one or more entities to be normalized are identified based on a hierarchical structure of the set of documents. One or more scripts are generated based on the identified one or more entities. In a related technique, a set of documents from a document database system is stored. It is validated that the set of documents can be converted to one or more duality views. Data of the set of documents is normalized for storing in a relational database system. A script is generated that, when executed, generates the one or more duality views.
-
公开(公告)号：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.
-
公开(公告)号：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
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.
-
公开(公告)号：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.
-
-
-
-
-
-
-
-
-
Search Results
14
records
(took 0.014 seconds)
