Realization Technology of Real-time Power Reporting Based on AnalyticDB

According to the business requirements of State Grid’s marketing electricity business, on the 1st of each month, the financial quick report, development quick report, and industrywide sales of electricity quick report need to be completed, and the districts, counties and municipalities need to carry out real-time statistics of the report based on the actual business. At the same time, verify business according to the statistical results of the current breakdown of data to assist in business development. Some of the real-time statistical functions cannot be realized in the business middle platform, resulting in insufficient support for real-time requirements. This paper proposes a real-time reporting solution based on Ali AnalyticDB real-time query library. Through data synchronization, data statistics, data consistency checking, data accuracy checking and other modules, it realizes real-time financial quick report and development quick report of electricity, meets the demand for real-time reports in the business process, improves the timeliness of report statistics, and reduces the workload of front-line staff at the same time.