一种数据查询方法、装置、电子设备及存储介质
By constructing a multidimensional data model and introducing the StarRocks distributed database, the problems of low data query efficiency and insufficient reusability of API interfaces in the banking and financial industries were solved, achieving efficient and low-cost data querying and reducing system coupling and query overhead.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- PING AN BANK CO LTD
- Filing Date
- 2023-08-15
- Publication Date
- 2026-07-17
AI Technical Summary
Existing API interfaces in the banking and financial industry suffer from poor reusability, high single-table overhead, low efficiency, inability to customize data processing, and risk of exposing internal tables, increasing system coupling and query overhead.
By constructing a multidimensional data model, performing multi-threaded concatenation and caching, we can achieve validation of input parameter requests and data aggregation. We also use the StarRocks distributed database to improve data query efficiency and introduce quick tables and dimension fields to reduce query dependencies.
It enables efficient data querying, reduces dependence on databases, improves reusability and query efficiency, reduces costs, and enhances the timeliness and real-time nature of data queries.
Smart Images
Figure CN117056348B_ABST