- Patent Title: Using time information to prune queries against partitioned data
-
Application No.: US14572010Application Date: 2014-12-16
-
Publication No.: US10013466B2Publication Date: 2018-07-03
- Inventor: Peter K. Zimmerer
- Applicant: Peter K. Zimmerer
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
The disclosure generally describes computer-implemented methods, software, and systems, including a method for storing information. In a database including plural records having time-related characteristics, a time-related partition is identified for relocating records in the partition to secondary storage. For each pair in one or more pairs of different time-related characteristic values of the records in the partition, a time-related distance is determined between the different time-related characteristic values. The time-related distances are aggregated for the partition. Information is stored in an index in primary storage that identifies the aggregated time-related distances for the partition.
Public/Granted literature
- US20160171035A1 USING TIME INFORMATION TO PRUNE QUERIES AGAINST PARTITIONED DATA Public/Granted day:2016-06-16
Information query