Patents by Inventor Joshua Spiegel

Joshua Spiegel 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).

  • TECHNIQUES FOR COMPREHENSIVELY SUPPORTING JSON SCHEMA IN A RDBMS
    Publication number: 20240126726
    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.
    Type: Application
    Filed: October 14, 2022
    Publication date: April 18, 2024
    Inventors: ZHEN HUA LIU, SRIKRISHNAN SURESH, BEDA CHRISTOPH HAMMERSCHMIDT, JOSHUA SPIEGEL, DOUGLAS JAMES MCMAHON
  • TECHNIQUES FOR COMPREHENSIVELY SUPPORTING JSON SCHEMA IN A RDBMS
    Publication number: 20240126727
    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.
    Type: Application
    Filed: October 14, 2022
    Publication date: April 18, 2024
    Inventors: ZHEN HUA LIU, SRIKRISHNAN SURESH, BEDA CHRISTOPH HAMMERSCHMIDT, JOSHUA SPIEGEL, DOUGLAS JAMES MCMAHON
  • Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP
    Patent number: 11899644
    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.
    Type: Grant
    Filed: July 8, 2022
    Date of Patent: February 13, 2024
    Assignee: Oracle International Corporation
    Inventors: 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
  • Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP
    Patent number: 11762834
    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.
    Type: Grant
    Filed: July 8, 2022
    Date of Patent: September 19, 2023
    Assignee: Oracle International Corporation
    Inventors: 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
  • TECHNIQUE OF EFFICIENTLY, COMPREHENSIVELY AND AUTONOMOUSLY SUPPORT NATIVE JSON DATATYPE IN RDBMS FOR BOTH OLTP & OLAP
    Publication number: 20220342865
    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.
    Type: Application
    Filed: July 8, 2022
    Publication date: October 27, 2022
    Inventors: 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
  • TECHNIQUE OF EFFICIENTLY, COMPREHENSIVELY AND AUTONOMOUSLY SUPPORT NATIVE JSON DATATYPE IN RDBMS FOR BOTH OLTP & OLAP
    Publication number: 20220342864
    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.
    Type: Application
    Filed: July 8, 2022
    Publication date: October 27, 2022
    Inventors: 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
  • Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP
    Patent number: 11423001
    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.
    Type: Grant
    Filed: June 17, 2020
    Date of Patent: August 23, 2022
    Assignee: Oracle International Corporation
    Inventors: 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
  • TECHNIQUE OF EFFICIENTLY, COMPREHENSIVELY AND AUTONOMOUSLY SUPPORT NATIVE JSON DATATYPE IN RDBMS FOR BOTH OLTP & OLAP
    Publication number: 20210081389
    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.
    Type: Application
    Filed: June 17, 2020
    Publication date: March 18, 2021
    Inventors: 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
  • Parallel parsing of file partitions storing a single XML document
    Patent number: 9922023
    Abstract: An XML document is stored in a file that is divided into file partitions. Each file partition is assigned to a process of a set processes to search for one or more separate target elements. The target elements are identified by a target element name. Each process scans an assigned file partition for the beginning of a target element. When a target element is found, an XML parser is invoked to parse the target element.
    Type: Grant
    Filed: September 5, 2014
    Date of Patent: March 20, 2018
    Assignee: Oracle International Corporation
    Inventors: Mark Drake, Dmitry Lychagin, Joshua Spiegel
  • System and method for determining when to turn off engines
    Patent number: 9880973
    Abstract: Systems and methods for determining when to turn off an engine are described. The systems and methods may identify when an amount of carboxyhemoglobin exceeds a predetermined threshold; and monitor the amount of carboxyhemoglobin for a period of time. The systems and methods may determine when the amount of carboxyhemoglobin exceeds the predetermined threshold during the time period; and turn off the engine when the amount of carboxyhemoglobin exceeds the predetermined threshold during the time period.
    Type: Grant
    Filed: April 16, 2015
    Date of Patent: January 30, 2018
    Assignee: Board of Trustees of The University of Alabama
    Inventors: Timothy Austin Haskew, Paulius V. Puzinauskas, Joshua Spiegel, Andrew Greff
  • PARALLEL XML PARSER
    Publication number: 20160070694
    Abstract: An XML document is stored in a file that is divided into file partitions. Each file partition is assigned to a process of a set processes to search for one or more separate target elements. The target elements are identified by a target element name. Each process scans an assigned file partition for the beginning of a target element. When a target element is found, an XML parser is invoked to parse the target element.
    Type: Application
    Filed: September 5, 2014
    Publication date: March 10, 2016
    Inventors: Mark Drake, DMITRY LYCHAGIN, JOSHUA SPIEGEL
  • SYSTEM AND METHOD FOR DETERMINING WHEN TO TURN OFF ENGINES
    Publication number: 20150300172
    Abstract: Systems and methods for determining when to turn off an engine are described. The systems and methods may identify when an amount of carboxyhemoglobin exceeds a predetermined threshold; and monitor the amount of carboxyhemoglobin for a period of time. The systems and methods may determine when the amount of carboxyhemoglobin exceeds the predetermined threshold during the time period; and turn off the engine when the amount of carboxyhemoglobin exceeds the predetermined threshold during the time period.
    Type: Application
    Filed: April 16, 2015
    Publication date: October 22, 2015
    Inventors: Timothy Austin Haskew, Paulius V. Puzinauskas, Joshua Spiegel, Andrew Greff