Data aggregation method and apparatus, computer-readable storage medium, and electronic device
By splitting cascading field values in JSON format into multiple cells within a relational database system and then aggregating them using preset aggregation rules and SQL statements, the problem of difficult aggregation of JSON data is solved, achieving efficient data aggregation.
CN116340409BActive Publication Date: 2026-06-19SHANGHAI TAIMEI DIGITAL TECH CO LTD
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- SHANGHAI TAIMEI DIGITAL TECH CO LTD
- Filing Date
- 2023-04-06
- Publication Date
- 2026-06-19
AI Technical Summary
Technical Problem
In relational database systems, JSON data is stored as a whole in a single cell of the table to be aggregated, making it difficult to aggregate JSON data in the table.
Method used
The cascading field values in JSON format are split into multiple field values to be aggregated, and stored in multiple cells respectively. These field values are then aggregated using preset aggregation rules and SQL aggregation statements to achieve indirect data aggregation.
Benefits of technology
It enables efficient aggregation of JSON format data, improves aggregation efficiency and flexibility, and simplifies aggregation operations.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN116340409B_ABST
Abstract
The application relates to the technical field of data processing, in particular to a data aggregation method and device, a computer readable storage medium and an electronic device, and solves the problem that it is difficult to aggregate JSON format data in a to-be-aggregated table. The data aggregation method comprises the following steps: acquiring a first to-be-aggregated table, wherein the first to-be-aggregated table stores cascade field values, the cascade field values are stored in a cell in the first to-be-aggregated table in a JSON format; splitting the cascade field values in the first to-be-aggregated table to obtain P to-be-aggregated field values, and storing the P to-be-aggregated field values in P cells in a second to-be-aggregated table respectively, wherein P is a positive integer greater than 1; receiving a first aggregation parameter; and using a preset aggregation rule taking the first aggregation parameter as input to perform aggregation processing on the P to-be-aggregated field values in the second to-be-aggregated table, thereby obtaining a first aggregation result.
Need to check novelty before this filing date? Find Prior Art