公开(公告)号：US20240070136A1

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

申请号：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.

公开(公告)号：US20240320208A1

公开(公告)日：2024-09-26

申请号：US18671039

申请日：2024-05-22

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 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.