Patents by Inventor JAN MAHON

JAN MAHON 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).

  • Optimizing relational online analytical processing sort operations
    Patent number: 11768833
    Abstract: Concepts for processing a SQL statement comprising a ROLAP sort operation are presented. One such concept comprises: determining whether a ROLAP partitioning column of the SQL statement does not refer to database columns from a sort operation of the SQL statement; and determining whether the ROLAP partitioning columns of the SQL statement are all referenced in the output of the SQL statement. Responsive to determining a ROLAP partitioning column of the SQL statement does not refer to database columns from a sort operation of the SQL statement, and to determining all of the ROLAP partitioning columns of the SQL statement are referenced in the output of the SQL statement, the SQL statement is modified by removing the ROLAP sort operation from the SQL statement.
    Type: Grant
    Filed: July 24, 2019
    Date of Patent: September 26, 2023
    Assignee: International Business Machines Corporation
    Inventors: Pedro Miguel Barbas, David Kelly, Jan Mahon, Donald Fraser
  • OPTIMIZING RELATIONAL ONLINE ANALYTICAL PROCESSING SORT OPERATIONS
    Publication number: 20210026852
    Abstract: Concepts for processing a SQL statement comprising a ROLAP sort operation are presented. One such concept comprises: determining whether a ROLAP partitioning column of the SQL statement does not refer to database columns from a sort operation of the SQL statement; and determining whether the ROLAP partitioning columns of the SQL statement are all referenced in the output of the SQL statement. Responsive to determining a ROLAP partitioning column of the SQL statement does not refer to database columns from a sort operation of the SQL statement, and to determining all of the ROLAP partitioning columns of the SQL statement are referenced in the output of the SQL statement, the SQL statement is modified by removing the ROLAP sort operation from the SQL statement.
    Type: Application
    Filed: July 24, 2019
    Publication date: January 28, 2021
    Inventors: Pedro Miguel Barbas, DAVID KELLY, JAN MAHON, DONALD FRASER