公开(公告)号：US20250036672A1

公开(公告)日：2025-01-30

申请号：US18358796

申请日：2023-07-25

Applicant: SAP SE

Inventor： Andreas Amler ,  Joerg Fellmann ,  Till Merker ,  Oliver Horn

IPC: G06F16/33 ,  G06F16/335

Abstract: Methods and systems for object-based text searching using group score expressions are provided. A method may include receiving a query including a request to search specified columns of a table for a set of search terms, and a group score filter for use in filtering the table based at least on a group score associated with a plurality of groups of rows of the table, determining the group score for each of a plurality of groups of rows of the table, filtering the table based at least on the group score filter included in the query and the group score determined for each of the plurality of groups of rows of the table, and providing at least one group of rows of the plurality of groups of rows that includes at least the portion of the set of search terms.

公开(公告)号：US20230367819A1

公开(公告)日：2023-11-16

申请号：US17741328

申请日：2022-05-10

Applicant: SAP SE

Inventor： Joerg Fellmann ,  Till Merker ,  Paul Willems ,  Dan Bi Park ,  Heesik Shin ,  Jin Su Lee ,  Myunggu Kang

IPC: G06F16/903

CPC classification number: G06F16/90335

Abstract: A global index with a repartitioning operator is provided. A method for executing a query includes receiving a query including a request to search a first table based on a first value in a first column. The method may include generating a second table by partitioning the second table based on the first column and including, in the second table, a partition identifier and a reference row identifier. The method may include pruning the second table such that a row corresponding to the first value remains in the second table. The method may include repartitioning the row to a stream based on the partition identifier. The method may include executing the query by at least searching the partition of the first table based on the stream and the row identifier of the row. Related systems and articles of manufacture are provided.

公开(公告)号：US12265568B2

公开(公告)日：2025-04-01

申请号：US18358796

申请日：2023-07-25

Applicant: SAP SE

Inventor： Andreas Amler ,  Joerg Fellmann ,  Till Merker ,  Oliver Horn

IPC: G06F7/00 ,  G06F16/00 ,  G06F16/334 ,  G06F16/335

Abstract: Methods and systems for object-based text searching using group score expressions are provided. A method may include receiving a query including a request to search specified columns of a table for a set of search terms, and a group score filter for use in filtering the table based at least on a group score associated with a plurality of groups of rows of the table, determining the group score for each of a plurality of groups of rows of the table, filtering the table based at least on the group score filter included in the query and the group score determined for each of the plurality of groups of rows of the table, and providing at least one group of rows of the plurality of groups of rows that includes at least the portion of the set of search terms.

公开(公告)号：US20180150518A1

公开(公告)日：2018-05-31

申请号：US15364026

申请日：2016-11-29

Applicant: SAP SE

Inventor： Till Merker ,  Timm Steinbeck ,  Paul Willems ,  Oliver Horn ,  Joerg Fellmann

IPC: G06F17/30

CPC classification number: G06F16/24542

Abstract: In some aspects, there is provided a method for database query execution planning. In some aspects, a method may include receiving, at a database execution engine, a query; generating, by the database execution engine, a query algebra for the query, the query algebra optimized by a query optimizer at the database execution engine; generating, based on the optimized query algebra, a query plan for execution, the query plan including pre-compiled code and code generated just-in-time; and executing, by the database execution engine, at least part of the query plan including pre-compiled code and code generated just-in-time. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US12242476B2

公开(公告)日：2025-03-04

申请号：US18357920

申请日：2023-07-24

Applicant: SAP SE

Inventor： Oliver Horn ,  Wolfgang Stephan ,  Joerg Fellmann ,  Till Merker

IPC: G06F16/2453 ,  G06F16/2457

Abstract: Systems and methods are provided for text searching using partial score expressions. A method may include receiving a query to search for a search term in at least a first column of a first table and a second column of a second table, scanning the first column and the second column for at least a portion of the search term, generating a first partial score table, generating a second partial score table, determining a combined score for each row in the first column and/or the second column containing at least the portion of the search term based at least on a join of the first partial score table and the second partial score table, and providing, in response to the query and based at least on the combined score, a row of the first column and/or the second column including at least the portion of the search term.

公开(公告)号：US10558661B2

公开(公告)日：2020-02-11

申请号：US15364004

申请日：2016-11-29

Applicant: SAP SE

Inventor： Till Merker ,  Joerg Fellmann

IPC: G06F17/30 ,  G06F16/2453 ,  G06F16/22 ,  G06F16/2455

Abstract: In some aspects, there is provided a method for database query execution planning using table adapters. In some aspects, a method may include receiving, at a database execution engine, a query; generating, by the database execution engine, a query plan for execution of the query, the query requiring access to at least one table; calling, by the database execution engine, a table adapter to prepare at least one table object to enable access, during runtime, to the at least one table; and receiving, by the database execution engine, the at least one table object prepared by the table adapter. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US20180150517A1

公开(公告)日：2018-05-31

申请号：US15364004

申请日：2016-11-29

Applicant: SAP SE

Inventor： Till Merker ,  Joerg Fellmann

IPC: G06F17/30

Abstract: In some aspects, there is provided a method for database query execution planning using table adapters. In some aspects, a method may include receiving, at a database execution engine, a query; generating, by the database execution engine, a query plan for execution of the query, the query requiring access to at least one table; calling, by the database execution engine, a table adapter to prepare at least one table object to enable access, during runtime, to the at least one table; and receiving, by the database execution engine, the at least one table object prepared by the table adapter. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US20250036619A1

公开(公告)日：2025-01-30

申请号：US18357920

申请日：2023-07-24

Applicant: SAP SE

Inventor： Oliver Horn ,  Wolfgang Stephan ,  Joerg Fellmann ,  Till Merker

IPC: G06F16/2453 ,  G06F16/2457

Abstract: Systems and methods are provided for text searching using partial score expressions. A method may include receiving a query to search for a search term in at least a first column of a first table and a second column of a second table, scanning the first column and the second column for at least a portion of the search term, generating a first partial score table, generating a second partial score table, determining a combined score for each row in the first column and/or the second column containing at least the portion of the search term based at least on a join of the first partial score table and the second partial score table, and providing, in response to the query and based at least on the combined score, a row of the first column and/or the second column including at least the portion of the search term.

公开(公告)号：US11977582B2

公开(公告)日：2024-05-07

申请号：US17741328

申请日：2022-05-10

Applicant: SAP SE

Inventor： Joerg Fellmann ,  Till Merker ,  Paul Willems ,  Dan Bi Park ,  Heesik Shin ,  Jin Su Lee ,  Myunggu Kang

IPC: G06F16/90 ,  G06F16/903

CPC classification number: G06F16/90335

Abstract: A global index with a repartitioning operator is provided. A method for executing a query includes receiving a query including a request to search a first table based on a first value in a first column. The method may include generating a second table by partitioning the second table based on the first column and including, in the second table, a partition identifier and a reference row identifier. The method may include pruning the second table such that a row corresponding to the first value remains in the second table. The method may include repartitioning the row to a stream based on the partition identifier. The method may include executing the query by at least searching the partition of the first table based on the stream and the row identifier of the row. Related systems and articles of manufacture are provided.

公开(公告)号：US11016973B2

公开(公告)日：2021-05-25

申请号：US15364026

申请日：2016-11-29

Applicant: SAP SE

Inventor： Till Merker ,  Timm Steinbeck ,  Paul Willems ,  Oliver Horn ,  Joerg Fellmann

IPC: G06F16/00 ,  G06F16/2453

Abstract: In some aspects, there is provided a method for database query execution planning. In some aspects, a method may include receiving, at a database execution engine, a query; generating, by the database execution engine, a query algebra for the query, the query algebra optimized by a query optimizer at the database execution engine; generating, based on the optimized query algebra, a query plan for execution, the query plan including pre-compiled code and code generated just-in-time; and executing, by the database execution engine, at least part of the query plan including pre-compiled code and code generated just-in-time. Related systems, methods, and articles of manufacture are also described.