Patents by Inventor Paul Willems

Paul Willems 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: 12380078
    Abstract: Arrangements for a reading scheme for column-oriented databases are provided. A virtual column may be generated by applying a structured query language operation on distinct values in a column of data in a table. Based on applying the structured query language operation, the virtual column may be populated with corresponding precalculated values. The virtual column may be compressed with dictionary-based compression. The compressing may include generating a column of value identifiers, each of the value identifiers representing a distinct value in the column of data. A database query against the compressed virtual column may be received. A result of the database query may be returned by retrieving one or more of the precalculated values from the compressed virtual column.
    Type: Grant
    Filed: June 3, 2024
    Date of Patent: August 5, 2025
    Assignee: SAP SE
    Inventors: Nico Bohnsack, Andreas Amler, Paul Willems, Manuel Mayr
  • Patent number: 12339840
    Abstract: In some implementations, there is provided a method that includes detecting in a query plan a pipeline that includes a last restart query operator that can cause a retry of the query plan during execution of the query plan; configuring the pipeline to execute the pipeline using an open call configuration, configuring at least one subsequent pipeline to execute in a fetch call configuration; executing the query plan including the pipeline in the open call configuration; sending, by the send operator, a message indicating the last restart query operator cannot cause a retry of the execution of the query plan; and causing execution of at least one operator in the subsequent pipeline to execute in the fetch call configuration, in which result streaming of partial results is allowed for the at least one operator.
    Type: Grant
    Filed: July 20, 2023
    Date of Patent: June 24, 2025
    Assignee: SAP SE
    Inventors: Stefan Noll, Paul Willems
  • Patent number: 12332890
    Abstract: A database management system (DBMS) traverses an operator topology of a query plan to identify pipelines within the query plan. The query plan may include at least a first shared subplan reference, where the first shared subplan reference refers to a first shared subplan, and where the first shared subplan is associated with a shared node in the operator topology. Also, the DBMS assigns, based on an order of execution, pipeline indices to the pipelines in the query plan. Additionally, the DBMS tracks pipeline dependencies of the query plan. For each shared subplan reference, the database management system specifies the shared subplan reference as a pipeline breaker if its pipeline has a dependency to a pipeline with an index greater than a corresponding shared subplan. Otherwise, the shared subplan reference is specified as a non-pipeline breaker. Then, the query plan is updated based on these shared subplan reference specifications.
    Type: Grant
    Filed: June 5, 2024
    Date of Patent: June 17, 2025
    Assignee: SAP SE
    Inventors: Manuel Mayr, Paul Willems, Till Merker
  • Patent number: 12332897
    Abstract: Methods, systems, and computer-readable storage media for a set of pipelines that enable selective skipping of dictionary scans and/or index lookups when processing queries in database management systems, such that dictionary scans and/or index lookups are only executed when needed, eliminating unnecessary execution of dictionary scans and/or index lookups to improve efficiency of the database system in terms of reducing load on technical resources and improve query performance by reducing latency in returning query results.
    Type: Grant
    Filed: August 23, 2024
    Date of Patent: June 17, 2025
    Assignee: SAP SE
    Inventors: Oliver Horn, Cheng-Lun Li, Paul Willems
  • Publication number: 20250109204
    Abstract: The present invention relates to pharmaceutical compositions comprising antibodies capable of binding a human V?9V?2 T cell receptor. The invention further relates to uses of the pharmaceutical compositions of the invention for medical treatment.
    Type: Application
    Filed: December 13, 2024
    Publication date: April 3, 2025
    Inventors: Paul Willem Henri Ida PARREN, Robertus Cornelis ROOVERS, Johannes Jelle VAN DER VLIET, David LUTJE HULSIK, Peter Alexander Gerardus Maria MACHIELSEN, Michiel VAN WESTERHOVEN, Lisa Anna KING, Felix-Lennart FENNEMANN, Jochem Willem VAN DER VEEN
  • Patent number: 12265537
    Abstract: Systems, methods, and articles of manufacture, including computer program products, provide a system including at least one data processor and at least one memory storing instructions which, when executed by the at least one data processor, cause operations comprising: generating, by a database execution engine, a query plan including a plurality of operators; inserting, by the database execution engine, an enforce compilation operator into the query plan that includes the plurality of operators, the plurality of operators comprising a first operator, the enforce compilation operator, and a second operator; executing at least the first operator of the query plan; in response to executing the first operator, evaluating, by the database execution engine, an output of the first operator to determine whether a condition is satisfied; and in response to the condition being satisfied, triggering, by the database execution engine, a just-in-time compilation of the second operator.
    Type: Grant
    Filed: July 19, 2023
    Date of Patent: April 1, 2025
    Assignee: SAP SE
    Inventors: Cheng-Lun Li, Till Merker, Manuel Mayr, Paul Willems
  • Publication number: 20250099581
    Abstract: The present invention relates to novel uses of gamma delta T-cell activating antibodies, in particular uses of such antibodies in patients that are also being treated, or have recently been treated, with aminobisphosphonates, or other inhibitors of the mevalonate pathway that inhibit farnesyl pyrophosphate synthase or an enzyme further downstream in the mevalonate pathway.
    Type: Application
    Filed: April 19, 2024
    Publication date: March 27, 2025
    Inventors: Johannes Jelle VAN DER VLIET, Paul Willem Henri Ida PARREN, Jurjen Matthijs RUBEN, Erik ENSING
  • Publication number: 20250045118
    Abstract: A method for allocating worker threads may include receiving a first fetch call for a query accessing a dataset stored at a database. The first fetch call may require a first portion of a result for the query. A first quantity of worker threads may be allocated to generate the first portion of the result for the query in response to the first fetch call. In response to a second fetch call for the query by determining a threshold corresponding to the first quantity of worker threads, a second quantity of data required for the second fetch call, and a third quantity of data buffered from the first fetch call. A second quantity of worker threads to generate a second portion of the result for the query may be allocated based on the threshold. Related systems and computer program products are also provided.
    Type: Application
    Filed: October 23, 2024
    Publication date: February 6, 2025
    Inventors: Christina Teflioudi, Paul Willems
  • Publication number: 20250036627
    Abstract: In some implementations, there is provided executing a query execution plan for a query; setting a first flag to indicate to a plurality of worker threads to stop executing tasks in a first queue of a memory stack; pushing into the memory stack, a second queue containing one or more exclusive tasks associated with the query; setting a second flag to indicate to the plurality of worker threads to resume working; and in response to the second queue being empty of the one or more exclusive tasks, setting a third flag to indicate to the plurality of worker threads to stop executing tasks in the second queue, and setting a fourth flag to indicate to the plurality of worker threads to resume working on the tasks in the first queue.
    Type: Application
    Filed: July 25, 2023
    Publication date: January 30, 2025
    Inventors: Marius Eich, Christina Teflioudi, Paul Willems
  • Publication number: 20250028719
    Abstract: Systems, methods, and articles of manufacture, including computer program products, provide a system including at least one data processor and at least one memory storing instructions which, when executed by the at least one data processor, cause operations comprising: generating, by a database execution engine, a query plan including a plurality of operators; inserting, by the database execution engine, an enforce compilation operator into the query plan that includes the plurality of operators, the plurality of operators comprising a first operator, the enforce compilation operator, and a second operator; executing at least the first operator of the query plan; in response to executing the first operator, evaluating, by the database execution engine, an output of the first operator to determine whether a condition is satisfied; and in response to the condition being satisfied, triggering, by the database execution engine, a just-in-time compilation of the second operator.
    Type: Application
    Filed: July 19, 2023
    Publication date: January 23, 2025
    Inventors: Cheng-Lun Li, Till Merker, Manuel Mayr, Paul Willems
  • Publication number: 20250028722
    Abstract: In some implementations, there is provided a method including generating a query plan including in a first pipeline a first join operator and in a second pipeline a second join operator; executing at least a portion of the query plan including the first pipeline and the first join operator; detecting, based on the at least one operator usage state and the at least one operator pruning condition, an empty state object shared between the first join operator and the second join operator in the second pipeline; and processing, by the at least one operator pruning condition, an indication of the empty state object, wherein the least one operator pruning condition is associated with the second join operator and includes at least a first rule to mark the second join operator for pruning.
    Type: Application
    Filed: July 2, 2024
    Publication date: January 23, 2025
    Inventor: Paul Willems
  • Publication number: 20250028718
    Abstract: In some implementations, there is provided a method that includes receiving a query request including a top k query operator for query plan generation, optimization, and execution, wherein k defines a threshold limit of query results for the top k query operator; inserting into a query plan a check operator associated with the top k query operator; in response to executing the query plan, checking, by the check operator, whether an early exit occurs due to the top k query operator reaching the threshold limit; in response to the early exit occurring due to the top k query operator reaching the threshold limit, stopping processing, by the check operator, including opening of another fragment of a database table; and in response to the early exit not occurring, allowing, by the check operator, the opening of the other fragment of the database table.
    Type: Application
    Filed: July 19, 2023
    Publication date: January 23, 2025
    Inventors: Christina Teflioudi, Paul Willems, Till Merker
  • Publication number: 20250028724
    Abstract: In some implementations, there is provided pipeline bypassing of certain operators. In some implementations, a method includes generating a query plan including at least one pipeline of operators; determining whether the at least one pipeline of operators includes a first operator that requires a complete result set as an input and further includes a second operator that supports providing the complete result set using a state identified by a state reference; and in response to determining the at least one pipeline of operators includes the first operator that requires the complete result set as the input and further includes the second operator that supports providing the complete result set using the state identified by the state reference, bypassing in the query plan pipelining between the first operator and the second operator.
    Type: Application
    Filed: July 19, 2023
    Publication date: January 23, 2025
    Inventors: Alexander Ostertag, Paul Willems
  • Patent number: 12204537
    Abstract: In some implementations, there is provided a method that includes receiving a query request including a top k query operator for query plan generation, optimization, and execution, wherein k defines a threshold limit of query results for the top k query operator; inserting into a query plan a check operator associated with the top k query operator; in response to executing the query plan, checking, by the check operator, whether an early exit occurs due to the top k query operator reaching the threshold limit; in response to the early exit occurring due to the top k query operator reaching the threshold limit, stopping processing, by the check operator, including opening of another fragment of a database table; and in response to the early exit not occurring, allowing, by the check operator, the opening of the other fragment of the database table.
    Type: Grant
    Filed: July 19, 2023
    Date of Patent: January 21, 2025
    Assignee: SAP SE
    Inventors: Christina Teflioudi, Paul Willems, Till Merker
  • Patent number: 12197453
    Abstract: A method for performing a parallelized heapsort operation may include updating, by a first worker thread, a first buffer while a second worker thread updates a second buffer in parallel. The first worker thread may update the first buffer by adding, to the first buffer, elements from a first partition of a dataset. The second worker thread may update the second buffer by adding, to the second buffer, elements from a second partition of the dataset. Upon the first buffer reaching a threshold size, the first worker thread may acquire a lock for the first worker thread to update a heap based on the first buffer while the second worker thread is prevented from updating the heap based on the second buffer. A result of a top k query comprising a k quantity of smallest elements from the dataset may be generated based on the heap.
    Type: Grant
    Filed: August 22, 2023
    Date of Patent: January 14, 2025
    Assignee: SAP SE
    Inventors: Alexander Gellner, Paul Willems
  • Publication number: 20250013574
    Abstract: A system and/or method for spill-to-disk in projection operations includes receiving a query including a projection, receiving a plurality of rows in response to the query processed by a processing thread of a plurality of processing threads, determining whether the query specifies an order for the plurality of rows, determining whether a disk buffer associated with the processing thread contains a stored row in response to the query specifying the order, storing the plurality of rows in the disk buffer in response to determining the disk buffer contains the stored row, storing the plurality of rows in a memory buffer associated with the processing thread in response to determining the disk buffer does not contain the stored row and the memory buffer contains at least a threshold amount of memory to store the plurality of rows, and providing the stored plurality of rows in response to the query.
    Type: Application
    Filed: July 6, 2023
    Publication date: January 9, 2025
    Inventors: Canberk Morelli, Paul Willems
  • Publication number: 20240419660
    Abstract: In some implementations, there is provided a method that includes detecting in a query plan a pipeline that includes a last restart query operator that can cause a retry of the query plan during execution of the query plan; configuring the pipeline to execute the pipeline using an open call configuration, configuring at least one subsequent pipeline to execute in a fetch call configuration; executing the query plan including the pipeline in the open call configuration; sending, by the send operator, a message indicating the last restart query operator cannot cause a retry of the execution of the query plan; and causing execution of at least one operator in the subsequent pipeline to execute in the fetch call configuration, in which result streaming of partial results is allowed for the at least one operator.
    Type: Application
    Filed: July 20, 2023
    Publication date: December 19, 2024
    Inventors: Stefan Noll, Paul Willems
  • Publication number: 20240409634
    Abstract: The invention relates to multispecific antibodies and pharmaceutical compositions comprising said antibodies, to processes for the preparation of said antibodies and to the use of said antibodies targeting CD33 and to their use in the treatment of diseases, e.g., cancer.
    Type: Application
    Filed: September 12, 2022
    Publication date: December 12, 2024
    Inventors: Patrick John DOONAN, Sherry Lynn LA PORTE, Sanjaya SINGH, Paul Willem Henri lda PARREN, Sabrina Julia Louisa MERAT, Robertus Cornelis ROOVERS, Sara Mohamed A ELASHKAR, Ulrike PHILIPPAR
  • Patent number: 12164519
    Abstract: In some example embodiments, there is provided a method that includes receiving a query for query plan generation and query plan optimization; detecting whether the query plan includes a restart pipeline, the restart pipeline including one or more first operators that cause a query plan restart; detecting whether the query plan includes a result pipeline, the result pipeline including one or more second operators that provide result streaming; determining whether there is a dependency between execution of the restart pipeline and execution of the result pipeline; in response to determining there is no dependency, reordering the restart pipeline in the query plan such that the restart pipeline will be executed before the result pipeline in order to enable result streaming optimization; and providing the reordered query plan for execution. Related systems and computer program products are also provided.
    Type: Grant
    Filed: April 18, 2023
    Date of Patent: December 10, 2024
    Assignee: SAP SE
    Inventors: Christina Teflioudi, Paul Willems, Till Merker
  • Patent number: 12153965
    Abstract: A method for allocating worker threads may include receiving a first fetch call for a query accessing a dataset stored at a database. The first fetch call may require a first portion of a result for the query. A first quantity of worker threads may be allocated to generate the first portion of the result for the query in response to the first fetch call. In response to a second fetch call for the query by determining a threshold corresponding to the first quantity of worker threads, a second quantity of data required for the second fetch call, and a third quantity of data buffered from the first fetch call. A second quantity of worker threads to generate a second portion of the result for the query may be allocated based on the threshold. Related systems and computer program products are also provided.
    Type: Grant
    Filed: March 7, 2022
    Date of Patent: November 26, 2024
    Assignee: SAP SE
    Inventors: Christina Teflioudi, Paul Willems