Data processing method, data querying method, and server device
US11907264B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Oct 28, 2021 |
| Grant date | Feb 20, 2024 |
| Priority date | — |
| Expiry date | Nov 22, 2041 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/26
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A data processing method includes: pulling full data regularly in accordance with a predetermined time, partitioning a DFS by date, and storing the full data in a corresponding partition of the DFS; filtering through the full data to obtain incremental data, sorting the incremental data, and storing the sorted data in a dimension table and an event table of a data warehouse detail layer, the dimension table being associated with the event table through a surrogate key; and associating the dimension table with the event table to generate a report, generating an aggregate table in accordance with a predetermined aggregation demand, and storing the generated aggregate table at a reporting layer.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.