公开(公告)号：US11106676B2

公开(公告)日：2021-08-31

申请号：US14581813

申请日：2014-12-23

Applicant: SAP SE

Inventor： Martin Weidner ,  Jonathan Dees ,  Peter Sanders

IPC: G06F16/2455 ,  G06F16/2453

Abstract: Techniques are described for efficient execution of analytical queries on large amounts of data in a parallel database cluster while making maximal use of the available hardware.

公开(公告)号：US20190079974A1

公开(公告)日：2019-03-14

申请号：US15702004

申请日：2017-09-12

Applicant: SAP SE

Inventor： Maik Goergens ,  Jonathan Dees

IPC: G06F17/30

Abstract: Various examples are directed to systems and methods optimizing database queries. A database management system may receive a first query comprising a plurality of query expressions. The database management system may determine that a first expression of the first query is nullable and that the first expression is null preserving. The database management system may generate optimized query code for the first query. The optimized query code may comprise a first code segment and a conditional jump instruction. The first code segment that, when executed by a processor, may cause the processor to perform operations comprising determining a value of the first expression. The conditional jump instruction may, when executed by the processor, cause the processor to perform operations comprising: skipping execution of at least a portion of the first code segment and returning null for the first expression.

公开(公告)号：US12019608B2

公开(公告)日：2024-06-25

申请号：US17893608

申请日：2022-08-23

Applicant: SAP SE

Inventor： Christian Bensberg ,  Jonathan Dees ,  Markus Fath

IPC: G06F16/22 ,  G06F16/21 ,  G06F16/2455

CPC classification number: G06F16/2282 ,  G06F16/213 ,  G06F16/2255 ,  G06F16/2456

Abstract: Various embodiments for a triple integration and querying system with dictionary compression are described herein. An embodiment operates by identifying a table of a database with four or more columns with triple formatted data including one subject column, one predicate column, and two or more object columns. It is determined that a master dictionary is to be generated for the both the subject column and the predicate column based on an identical datatype being used for both columns. A subject data dictionary and a predicate data dictionary are generated. A unique value is assigned a same unique identifier a in both the object data dictionary and the subject data dictionary. A master dictionary including both the unique values from the subject data dictionary and the predicate data dictionary is generated. Values in the subject column and the predicate column are replaced based on the unique values from the master dictionary.

公开(公告)号：US11947509B2

公开(公告)日：2024-04-02

申请号：US17893592

申请日：2022-08-23

Applicant: SAP SE

Inventor： Christian Bensberg ,  Jonathan Dees ,  Markus Fath

IPC: G06F16/00 ,  G06F16/22 ,  G06F16/2455

CPC classification number: G06F16/221 ,  G06F16/2255 ,  G06F16/2282 ,  G06F16/2456

Abstract: Various embodiments for a triple integration and querying system are described herein. An embodiment operates by identifying a plurality of triples corresponding to a knowledge graph, and generating a table in a database into which to import the set of triples. The table includes a subject column, a predicate column, and multiple object columns across different datatypes. Values from the triples of the knowledge graph are loaded into the table and a query is executed on the table.

公开(公告)号：US20240086426A1

公开(公告)日：2024-03-14

申请号：US18515898

申请日：2023-11-21

Applicant: SAP SE

Inventor： Andreas Amler ,  Jonathan Dees ,  Till Merker

IPC: G06F16/28 ,  G06F16/27

CPC classification number: G06F16/285 ,  G06F16/278

Abstract: A method for executing a query may include generating a partition value identifier for a partitioned table. The partitioned table may include a main fragment including a main dictionary storing a first value and a main value identifier corresponding to the first value and a delta fragment including a delta dictionary storing a second value and a delta value identifier corresponding to the second value. The partition value identifier may be set based at least in part on the first value and the second value. The generated partition value identifier and a corresponding one of the main value identifier and the delta value identified may be maintained as part of a mapping. A query to group data stored in the partitioned table may be received. The query may be executed by at least using the mapping.

公开(公告)号：US11860906B2

公开(公告)日：2024-01-02

申请号：US17745741

申请日：2022-05-16

Applicant: SAP SE

Inventor： Andreas Amler ,  Jonathan Dees ,  Till Merker

IPC: G06F16/00 ,  G06F16/28 ,  G06F16/27

CPC classification number: G06F16/285 ,  G06F16/278

Abstract: A method for executing a query may include generating a partition value identifier for a partitioned table. The partitioned table may include a main fragment including a main dictionary storing a first value and a main value identifier corresponding to the first value and a delta fragment including a delta dictionary storing a second value and a delta value identifier corresponding to the second value. The partition value identifier may be set based at least in part on the first value and the second value. The generated partition value identifier and a corresponding one of the main value identifier and the delta value identified may be maintained as part of a mapping. A query to group data stored in the partitioned table may be received. The query may be executed by at least using the mapping.

公开(公告)号：US10542127B2

公开(公告)日：2020-01-21

申请号：US15696874

申请日：2017-09-06

Applicant: SAP SE

Inventor： Jan Stengler ,  Jonathan Dees ,  Martin Weidner

IPC: H04L12/26 ,  H04L29/14 ,  H04L12/24 ,  H04L29/06 ,  H04L12/703

Abstract: Disclosed herein are system, method, and computer program product embodiments for fault tolerant communications in a distributed system. An embodiment operates by determining a failure of a first node of a cluster of a plurality of nodes. Prior to the failure, a second node transmitted a first message to the first node. The second node determines content corresponding to the first message. A third node to which to provide the content of the first sub-task is identified. A second message, including content corresponding to the first message, is transmit to the third node.

公开(公告)号：US20190075194A1

公开(公告)日：2019-03-07

申请号：US15696874

申请日：2017-09-06

Applicant: SAP SE

Inventor： Jan Stengler ,  Jonathan Dees ,  Martin Weidner

IPC: H04L29/14 ,  H04L12/24

CPC classification number: H04L69/40 ,  H04L41/0654 ,  H04L45/28 ,  H04L67/10 ,  H04L69/14

Abstract: Disclosed herein are system, method, and computer program product embodiments for fault tolerant communications in a distributed system. An embodiment operates by determining a failure of a first node of a cluster of a plurality of nodes. Prior to the failure, a second node transmitted a first message to the first node. The second node determines content corresponding to the first message. A third node to which to provide the content of the first sub-task is identified. A second message, including content corresponding to the first message, is transmit to the third node.

公开(公告)号：US20170177685A1

公开(公告)日：2017-06-22

申请号：US14975489

申请日：2015-12-18

Applicant: SAP SE

Inventor： Achim Becker ,  Franz Faerber ,  Florian Foebel ,  Kesavaprakash Vasudevan ,  Martin Weidner ,  Jonathan Dees

IPC: G06F17/30

CPC classification number: G06F16/27 ,  G06F16/2282 ,  G06F16/2471

Abstract: Technologies are provided for scaling applications via application scenarios. Portions of application resource content stored in a database are associated with application scenarios. The portions of the resource content associated with an application scenario are replicated to one or more computing nodes associated with the application scenario. Requests associated with the application scenario are transmitted to the one or more one or more computing nodes, where they are processed using the replicated portions of the resource content associated with the application scenario.