Invention Grant
- Patent Title: Single level, multi-dimension, hash-based table partitioning
-
Application No.: US14826626Application Date: 2015-08-14
-
Publication No.: US10482076B2Publication Date: 2019-11-19
- Inventor: Christian Bensberg
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/2455 ; G06F16/28

Abstract:
In a general aspect, a method includes inserting a record in a partitioned fact table of a star schema data mart. Inserting the record can include determining a first hash value from a first dimension value of the record and determining a first set of candidate partitions from the first hash value. The method can further include determining a second hash value from a second dimension value of the record and determining a second set of candidate partitions from the first hash value. The method can further include comparing the first set of candidate partitions with the second set of candidate partitions to determine a common partition and inserting the record into the common partition.
Public/Granted literature
- US20170046371A1 SINGLE-LEVEL, MULTI-DIMENSION, HASH-BASED TABLE PARTITIONING Public/Granted day:2017-02-16
Information query