Patents by Inventor Robert Matthew Wehrmeister

Robert Matthew Wehrmeister 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: 11526505
    Abstract: A database system receives a request from a user. The request invokes a data set function (DSF) and uses a property to be provided by the DSF. The database system determines that a function descriptor is available for the DSF. The function descriptor is expressed as markup language instructions. The function descriptor defines the property of the DSF. The database system uses the function descriptor to define a property for the DSF.
    Type: Grant
    Filed: December 5, 2019
    Date of Patent: December 13, 2022
    Assignee: Teradata US, Inc.
    Inventors: B. Anantha Subramanian, Mohamed Yassin Eltabakh, Mahbub Hasan, Robert Matthew Wehrmeister, Awny Kayed Al-Omari, Sanjay Sukumaran Nair, Kashif Abdullah Siddiqui, Mohammed Yassin Al-Kateb
  • Patent number: 11409745
    Abstract: Execution of a query invoking an analytical function (AF) is optimized. The query includes a join operation between an AF table and an AuxiliaryTable. A determination is made that the AF includes a plurality of AF properties. Query-level properties about the query are inferred. A determination is made to change an order of the join operation from the plurality of AF properties and query-level properties.
    Type: Grant
    Filed: December 5, 2019
    Date of Patent: August 9, 2022
    Assignee: Teradata US, Inc.
    Inventors: Christina Pavlopoulou, Mahbub Hasan, B. Anantha Subramanian, Mohammed Al-Kateb, Awny Kayed Al-Omari, Kashif Abdullah Siddiqui, Robert Matthew Wehrmeister, Mohamed Yassin Eltabakh
  • Publication number: 20200278966
    Abstract: As an abstract representation, a set of equivalent logical structures representative of multiple execution plans for execution of a database query can be used to optimize a database query. A logical structure can include one or more logical operators each representing multiple physical operators for executing the database query. Group and Operator Rules can be applied as rules to the set of equivalent logical structures to obtain additional equivalent logical structures and logical operator until no additional logical operators can be obtained. A set of possible implementation plans for the total number of the obtained logical operators can be obtained, for example, based on physical and/or implementation context.
    Type: Application
    Filed: April 28, 2020
    Publication date: September 3, 2020
    Inventors: Awny Kayed Al-Omari, Robert Matthew Wehrmeister, Kashif Abdullah Siddiqui
  • Patent number: 10740329
    Abstract: As an abstract representation, a set of equivalent logical structures representative of multiple execution plans for execution of a database query can be used to optimize a database query. A logical structure can include one or more logical operators each representing multiple physical operators for executing the database query. Group and Operator Rules can be applied as rules to the set of equivalent logical structures to obtain additional equivalent logical structures and logical operator until no additional logical operators can be obtained. A set of possible implementation plans for the total number of the obtained logical operators can be obtained, for example, based on physical and/or implementation context.
    Type: Grant
    Filed: March 12, 2014
    Date of Patent: August 11, 2020
    Assignee: Teradata US, Inc.
    Inventors: Awny Kayed Al-Omari, Robert Matthew Wehrmeister, Kashif Abdullah Siddiqui
  • Patent number: 10740330
    Abstract: The execution of the one or more database queries can be optimized by using a multi-platform cost model that take into account the respective cost of execution in each one of the multiple execution platforms. The respective costs of the execution can, for example, include cost associated with one or more operators for executing the one or more database queries in each one of the multiple execution platforms and/or the costs of exchanging data between the multiple execution platforms.
    Type: Grant
    Filed: March 12, 2014
    Date of Patent: August 11, 2020
    Assignee: Teradata US, Inc.
    Inventors: Robert Matthew Wehrmeister, Awny Kayed Al-Omari, Kashif Abdullah Siddiqui
  • Publication number: 20200183921
    Abstract: A database system receives a request from a user. The request invokes a data set function (DSF) and uses a property to be provided by the DSF. The database system determines that a function descriptor is available for the DSF. The function descriptor is expressed as markup language instructions. The function descriptor defines the property of the DSF. The database system uses the function descriptor to define a property for the DSF.
    Type: Application
    Filed: December 5, 2019
    Publication date: June 11, 2020
    Applicant: Teradata US, Inc
    Inventors: B. Anantha Subramanian, Mohamed Yassin Eltabakh, Mahbub Hasan, Robert Matthew Wehrmeister, Awny Kayed Al-Omari, Sanjay Sukumaran Nair, Kashif Abdullah Siddiqui
  • Publication number: 20200183935
    Abstract: Execution of a query invoking an analytical function (AF) is optimized. The query includes a join operation between an AF table and an AuxiliaryTable and includes determining that the AF includes a plurality of AF properties. Query-level properties about the query are inferred. It is determined to change an order of the join operation from the plurality of AF properties and query-level properties.
    Type: Application
    Filed: December 5, 2019
    Publication date: June 11, 2020
    Applicant: Teradata US, Inc
    Inventors: Christina Pavlopoulou, Mahbub Hasan, B. Anantha Subramanian, Mohammed Al-Kateb, Awny Kayed Al-Omari, Kashif Abdullah Siddiqui, Robert Matthew Wehrmeister, Mohamed Yassin Eltabakh
  • Publication number: 20150032722
    Abstract: As an abstract representation, a set of equivalent logical structures representative of multiple execution plans for execution of a database query can be used to optimize a database query. A logical structure can include one or more logical operators each representing multiple physical operators for executing the database query. Group and Operator Rules can be applied as rules to the set of equivalent logical structures to obtain additional equivalent logical structures and logical operator until no additional logical operators can be obtained. A set of possible implementation plans for the total number of the obtained logical operators can be obtained, for example, based on physical and/or implementation context.
    Type: Application
    Filed: March 12, 2014
    Publication date: January 29, 2015
    Applicant: Teradata Corporation
    Inventors: Awny Kayed Al-Omari, Robert Matthew Wehrmeister, Kashif Abdullah Siddiqui
  • Publication number: 20140317088
    Abstract: As an abstract representation, a set of equivalent logical structures representative of multiple execution plans for execution of a database query can be used to optimize a database query. A logical structure can include one or more logical operators each representing multiple physical operators for executing the database query. Group and Operator Rules can be applied as rules to the set of equivalent logical structures to obtain additional equivalent logical structures and logical operator until no additional logical operators can be obtained. A set of possible implementation plans for the total number of the obtained logical operators can be obtained, for example, based on physical and/or implementation context.
    Type: Application
    Filed: March 12, 2014
    Publication date: October 23, 2014
    Applicant: Teradata Corporation
    Inventors: Awny Kayed Al-Omari, Robert Matthew Wehrmeister, Kashif Abdullah Siddiqui
  • Publication number: 20140317085
    Abstract: The execution of the one or more database queries can be optimized by using a multi-platform cost model that take into account the respective cost of execution in each one of the multiple execution platforms. The respective costs of the execution can, for example, include cost associated with one or more operators for executing the one or more database queries in each one of the multiple execution platforms and/or the costs of exchanging data between the multiple execution platforms.
    Type: Application
    Filed: March 12, 2014
    Publication date: October 23, 2014
    Applicant: Teradata Corporation
    Inventors: Robert Matthew Wehrmeister, Awny Kayed Al-Omari, Kashif Abdullah Siddiqui
  • Patent number: 7765531
    Abstract: Systems and methods to indicate whether to store a database query language module in a local directory or a global directory are disclosed. An application program can be created once, tested once, and deployed in separate environments. The database query language modules can be shared among a group of application programs running in a common environment. Separate query language modules can be maintained for each environment.
    Type: Grant
    Filed: October 6, 2004
    Date of Patent: July 27, 2010
    Assignee: Hewlett-Packard Development Company, L.P.
    Inventors: Gary Martin Gilbert, Hansjorg Zeller, Robert Matthew Wehrmeister, Thomas Canivel Reyes, Anoop Sharma, David Wayne Birdsall, Michael James Hanlon