Patents by Inventor Beda C. Hammerschmidt
Beda C. Hammerschmidt has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 11899644Abstract: 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.Type: GrantFiled: July 8, 2022Date of Patent: February 13, 2024Assignee: Oracle International CorporationInventors: 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
-
Patent number: 11762834Abstract: 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.Type: GrantFiled: July 8, 2022Date of Patent: September 19, 2023Assignee: Oracle International CorporationInventors: 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
-
Publication number: 20220342865Abstract: 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.Type: ApplicationFiled: July 8, 2022Publication date: October 27, 2022Inventors: 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
-
Publication number: 20220342864Abstract: 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.Type: ApplicationFiled: July 8, 2022Publication date: October 27, 2022Inventors: 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
-
Patent number: 11423001Abstract: 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.Type: GrantFiled: June 17, 2020Date of Patent: August 23, 2022Assignee: Oracle International CorporationInventors: 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
-
Patent number: 11397768Abstract: 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.Type: GrantFiled: April 17, 2020Date of Patent: July 26, 2022Assignee: Oracle International CorporationInventors: Zhen Hua Liu, Beda C. Hammerschmidt, Sriram Krishnamurthy, Ying Lu, Douglas J. McMahon, Srividya Tata, Vikas Arora
-
Patent number: 11182429Abstract: 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.Type: GrantFiled: April 17, 2020Date of Patent: November 23, 2021Assignee: Oracle International CorporationInventors: Zhen Hua Liu, Beda C. Hammerschmidt, Sriram Krishnamurthy, Ying Lu, Douglas J. McMahon, Srividya Tata, Vikas Arora
-
Patent number: 11182428Abstract: 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.Type: GrantFiled: April 17, 2020Date of Patent: November 23, 2021Assignee: Oracle International CorporationInventors: Zhen Hua Liu, Beda C. Hammerschmidt, Sriram Krishnamurthy, Ying Lu, Douglas J. McMahon, Srividya Tata, Vikas Arora
-
Publication number: 20210081389Abstract: 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.Type: ApplicationFiled: June 17, 2020Publication date: March 18, 2021Inventors: 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
-
Patent number: 10747814Abstract: 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.Type: GrantFiled: December 20, 2017Date of Patent: August 18, 2020Assignee: Oracle International CorporationInventors: Zhen Hua Liu, Beda C. Hammerschmidt, Sriram Krishnamurthy, Ying Lu, Douglas J. McMahon, Srividya Tata, Vikas Arora
-
Publication number: 20200242157Abstract: 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.Type: ApplicationFiled: April 17, 2020Publication date: July 30, 2020Inventors: Zhen Hua Liu, Beda C. Hammerschmidt, Sriram Krishnamurthy, Ying Lu, Douglas J. McMahon, Srividya Tata, Vikas Arora
-
Publication number: 20200242156Abstract: 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.Type: ApplicationFiled: April 17, 2020Publication date: July 30, 2020Inventors: Zhen Hua Liu, Beda C. Hammerschmidt, Sriram Krishnamurthy, Ying Lu, Douglas J. McMahon, Srividya Tata, Vikas Arora
-
Publication number: 20200242158Abstract: 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.Type: ApplicationFiled: April 17, 2020Publication date: July 30, 2020Inventors: Zhen Hua Liu, Beda C. Hammerschmidt, Sriram Krishnamurthy, Ying Lu, Douglas J. McMahon, Srividya Tata, Vikas Arora
-
Publication number: 20190102476Abstract: 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.Type: ApplicationFiled: December 20, 2017Publication date: April 4, 2019Inventors: Zhen Hua Liu, Beda C. Hammerschmidt, Sriram Krishnamurthy, Ying Lu, Douglas J. McMahon, Srividya Tata, Vikas Arora