Organizing time-series data for query acceleration and storage optimization
US11341150B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | May 20, 2021 |
| Grant date | May 24, 2022 |
| Priority date | — |
| Expiry date | May 20, 2041 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24552
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The long-lived and recently modified (LLRM) partitioning is a system and method for partitioning slowly changing aged data for a given year into one long-lived partition (LLP) and multiple recently modified partitions (RMP) where the RMP corresponds to a time period of a first time granularity. Each record has a start and end time to indicate its lifetime. A record in a RMP is modified at a timepoint corresponding to the time period of a RMP. RMP records can be sampled every second, minute, hour or day. The LLP holds records whose lifetime is greater than the time period of a first time granularity. Queries pertaining to a given timepoint is performed on data that is a union of the LLP and the RMP pertaining to that timepoint instead of the unpartitioned table thus leading to shorter query processing time and better utilization of memory storage.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.