Method and device for optimizing data warehouse, electronic equipment and storage medium
By conducting health analysis and unified management of multiple business lines in the data warehouse, and using preset indicators to calculate health status, the problem of low optimization efficiency in the data warehouse has been solved, and efficient data warehouse optimization and quality control have been achieved.
CN116226087BActive Publication Date: 2026-09-04PING AN TECH (SHENZHEN) CO LTD
2 Cites 0 Cited by
Patent Information
- Application Number
- CN202310136689.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-02-09
- Publication Date
- 2026-09-04
- Estimated Expiration
- 2043-02-09
AI Technical Summary
Technical Problem
The lack of unified management and standardized specifications in enterprise data warehouses leads to low optimization efficiency and an inability to clean up or repair unhealthy data warehouses in a timely manner.
Method used
Health analysis is performed on the sub-data warehouses of various business lines of the data warehouse using multiple preset indicators, the health level is calculated, and the data warehouse is monitored and optimized based on the health level, using a unified logic for optimization.
Benefits of technology
It enables unified management and quality control of the data warehouse, improves optimization efficiency and accuracy, and solves the problems of data redundancy and non-standardization.
✦ Generated by Eureka AI based on patent content.
Abstract
The application relates to the technical field of big data, and provides an optimization method and device of a data warehouse, electronic equipment and a storage medium, the method comprising the following steps: in response to an abnormality monitoring request received, obtaining a data warehouse to be monitored; according to each business line, performing health analysis on a corresponding sub-data warehouse by using multiple preset indexes; calculating the health degree of the corresponding sub-data warehouse according to multiple health analysis results of the multiple preset indexes; monitoring the corresponding sub-data warehouse according to the health degree of each sub-data warehouse calculated; and optimizing the data warehouse according to multiple monitoring results returned by multiple sub-data warehouses. The health of the sub-data warehouses of each business line in the data warehouse is analyzed by using multiple preset indexes, unified management of the data warehouse is realized, and the optimization efficiency of the data warehouse is improved.
Need to check novelty before this filing date? Find Prior Art