Invention Grant
- Patent Title: Efficiently query compressed time-series data in a database
-
Application No.: US15244399Application Date: 2016-08-23
-
Publication No.: US10776319B2Publication Date: 2020-09-15
- Inventor: Frank Eichinger , Dennis Kurfiss
- Applicant: Frank Eichinger , Dennis Kurfiss
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Mintz, Levin, Cohn, Ferris, Glovsky and Popeo, P.C.
- Main IPC: G06F16/2458
- IPC: G06F16/2458 ; G06F16/174 ; H03M7/30

Abstract:
A query of time series data stored in a database is received that specifies at least one value. The database includes (i) an index table specifying groups of segments of compressed time series data with corresponding ranges each having a lowest value and a highest value, and (ii) a segments table specifying individual segments of compressed time series data. Thereafter, using the index table, at least one group for which the specified at least one value falls within the corresponding range is identified. The segments table is then queried for the segments corresponding to the identified at least one group to generate a new segments table specifying at least one segment. Next, the at least one segment specified by the new segments table is decompressed. Data responsive to the query within the decompressed at least one segment is then identified using the specified at least one value.
Public/Granted literature
- US20160357777A1 Efficiently Query Compressed Time-Series Data in a Database Public/Granted day:2016-12-08
Information query