A report query method, device and equipment and a storage medium
By receiving detailed query requests and filtering cached data, the inefficiency of traditional batch query schemes is solved, enabling fast aggregate queries on massive amounts of data and improving system performance and user experience.
CN115599827BActive Publication Date: 2026-05-19KINGDEE SOFTWARE(CHINA) CO LTD
2 Cites 0 Cited by
Patent Information
- Application Number
- CN202211288707.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-10-20
- Publication Date
- 2026-05-19
- Estimated Expiration
- 2042-10-20
AI Technical Summary
Technical Problem
Traditional batch query solutions require multiple scrolling down to see the total rows when querying massive amounts of data, resulting in high manpower and computing costs, low efficiency, and poor system performance and stability.
Method used
By receiving detailed query requests, filtering and caching detailed data, limiting the amount of response data according to a preset data size threshold, and directly using cached total data or querying the database for total data when receiving total query requests, the number of database accesses is reduced.
Benefits of technology
It enables fast querying of detailed and total data, reduces system pressure, improves response speed and user experience, and reduces computational load and database access frequency.
✦ Generated by Eureka AI based on patent content.
Abstract
The application discloses a report query method and device, equipment and a storage medium, relates to the computer technical field, and is suitable for various enterprise resource planning (ERP) systems. The method comprises the following steps: receiving a detailed query request for a report; performing detailed query processing according to the detailed query request to obtain detailed data of the report; performing screening processing on the detailed data according to a preset data size threshold, and responding to the detailed query request according to target data screened out; wherein the data size of the target data does not exceed the preset data size threshold; receiving a total query request initiated based on the target data, and responding to the total query request according to total data of the detailed data. The application improves the query efficiency and reduces the system pressure.
Need to check novelty before this filing date? Find Prior Art