Relational data table query method, system, device and storage medium
By dynamically configuring a dual-layer caching cluster and parsing database logs, the performance and flexibility issues of querying complex single-table data volumes are resolved, enabling efficient data table queries and business responses.
CN116628024BActive Publication Date: 2026-03-10CHINA TELECOM CORP LTD
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-05-11
- Publication Date
- 2026-03-10
Smart Images
Figure CN116628024B_ABST
Abstract
The application discloses a kind of relational data table query method, system, device and storage medium, applied to computer technology field, can flexibly and efficiently respond to business demand change, and effectively improve the query efficiency of relational data table.The method comprises the following steps: obtaining the query condition of the relational data table;Wherein, the query condition is obtained according to the dynamic configuration of the query combination condition of the relational data table;First cache cluster is dynamically configured according to the query condition;Wherein, first cache cluster includes index cache structure and entity cache structure, and the index cache structure corresponds to the entity cache structure;The database log of relational database is obtained, the database log is parsed, and data change information is obtained;According to the data change information, the index cache structure and the entity cache structure are synchronously updated, and second cache cluster is obtained;According to the second cache cluster, target business query is carried out, and query result is obtained.
Need to check novelty before this filing date? Find Prior Art
Citation Information
Patent Citations
Database query method, device and system
CN113535777A
Data caching method and device and computer readable storage medium
CN114327603A