Patents by Inventor Scott P. Hanson

Scott P. Hanson 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).

  • Transforming a user-defined table function to a derived table in a database management system
    Patent number: 11354313
    Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.
    Type: Grant
    Filed: September 10, 2019
    Date of Patent: June 7, 2022
    Assignee: Alibaba Group Holding Limited
    Inventors: Craig S. Aldrich, Stephanie A. Burrichter, Scott P. Hanson, Rafal P. Konik, Roger A. Mittelstadt, Jane A. Vold
  • Transforming a user-defined table function to a derived table in a database management system
    Patent number: 10846291
    Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.
    Type: Grant
    Filed: April 18, 2019
    Date of Patent: November 24, 2020
    Assignee: Alibaba Group Holding Limited
    Inventors: Craig S. Aldrich, Stephanie A. Burrichter, Scott P. Hanson, Rafal P. Konik, Roger A. Mittelstadt, Jane A. Vold
  • Transforming a user-defined table function to a derived table in a database management system
    Patent number: 10558662
    Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.
    Type: Grant
    Filed: January 14, 2017
    Date of Patent: February 11, 2020
    Assignee: International Business Machines Corporation
    Inventors: Craig S. Aldrich, Stephanie A. Burrichter, Scott P. Hanson, Rafal P. Konik, Roger A. Mittelstadt, Jane A. Vold
  • TRANSFORMING A USER-DEFINED TABLE FUNCTION TO A DERIVED TABLE IN A DATABASE MANAGEMENT SYSTEM
    Publication number: 20200004750
    Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.
    Type: Application
    Filed: September 10, 2019
    Publication date: January 2, 2020
    Inventors: Craig S. Aldrich, Stephanie A. Burrichter, Scott P. Hanson, Rafal P. Konik, Roger A. Mittelstadt, Jane A. Vold
  • TRANSFORMING A USER-DEFINED TABLE FUNCTION TO A DERIVED TABLE IN A DATABASE MANAGEMENT SYSTEM
    Publication number: 20190243833
    Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.
    Type: Application
    Filed: April 18, 2019
    Publication date: August 8, 2019
    Inventors: Craig S. Aldrich, Stephanie A. Burrichter, Scott P. Hanson, Rafal P. Konik, Roger A. Mittelstadt, Jane A. Vold
  • TRANSFORMING A USER-DEFINED TABLE FUNCTION TO A DERIVED TABLE IN A DATABASE MANAGEMENT SYSTEM
    Publication number: 20180203898
    Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.
    Type: Application
    Filed: January 14, 2017
    Publication date: July 19, 2018
    Inventors: Craig S. Aldrich, Stephanie A. Burrichter, Scott P. Hanson, Rafal P. Konik, Roger A. Mittelstadt, Jane A. Vold
  • TRANSFORMING A USER-DEFINED TABLE FUNCTION TO A DERIVED TABLE IN A DATABASE MANAGEMENT SYSTEM
    Publication number: 20180203900
    Abstract: Disclosed aspects relate to transforming a user-defined table function (UDTF) to a derived table in a database management system (DBMS). It may be detected by the DBMS that a query indicates the UDTF. A derived table may be constructed from the UDTF. The derived table may be derived from a set of statements of the UDTF. The derived table may be introduced to the query to fulfill the UDTF. A query plan may be generated for the query by the DBMS. The query plan may be generated in response to introducing the derived table in the query.
    Type: Application
    Filed: December 29, 2017
    Publication date: July 19, 2018
    Inventors: Craig S. Aldrich, Stephanie A. Burrichter, Scott P. Hanson, Rafal P. Konik, Roger A. Mittelstadt, Jane A. Vold
  • Method and system in a data processing system for association of source code instructions with an optimized listing of object code instructions
    Patent number: 5946493
    Abstract: A method and system in a data processing system for associating source code instructions with an optimized listing of object code instructions are disclosed. Source code instructions are compiled utilizing an optimizing compiler to generate a listing of object code instructions. The object code instructions are included within the listing in an optimized sequence. One of the object code instructions is compared with a second plurality of object code instructions. The second plurality of object code instructions are all located after the one object code instruction in the listing. In response to the comparison, a determination is made whether a selection of the one object code instruction will prohibit selection of a third plurality of object code instructions. If a determination is made a selection of the one object code instruction will not prohibit selection of a third plurality of object code instructions, the one object code instruction is associated with one of the source code instructions.
    Type: Grant
    Filed: March 28, 1997
    Date of Patent: August 31, 1999
    Assignee: International Business Machines Corporation
    Inventor: Scott P. Hanson