Patents by Inventor Alfonso Colunga Sosa

Alfonso Colunga Sosa 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).

  • 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