Extjs frame based intelligent data analysis system and method

Abstract

The invention discloses an Extjs frame based intelligent data analysis method. The intelligent data analysis method adopts a B / S framework, all report configuration and query operation can be completed on a browser, and further, cross-system-platform and cross-browser operation can be realized. The invention further provides determination methods of a report template and a report. The determination method of the report template comprises steps as follows: determining size, line number and row number of the report template; determining the type of the report template; determining an array for storing added data rules. The determination method of the report comprises steps as follows: selecting one report template; spreading the data rules contained in the selected report template; binding a specific database object survey point for the data rules adopting a database as a data source. With the adoption of the methods, reuse of configuration files can be realized, and configuration work can be reduced. Besides, the invention provides a method for rapidly updating cell data. The execution speed can be greatly increased with the method for rapidly updating the cell data.

Description

Technical field [0001] The invention relates to the technical field of data processing, in particular to a data intelligent analysis system and method based on an Extjs framework. Background technique [0002] In the subway energy management system, reports are mainly used for energy consumption statistics and energy consumption analysis of management objects such as air conditioning systems, ventilation systems, lighting systems, water supply and drainage systems, power supply and distribution systems, and escalators in each station. Since the equipment types and quantities of equipment in each station and subsystem are the same or similar, the operating parameters that need statistical analysis are the same. Therefore, in the report application, there will be a large number of reports with exactly the same content format and calculation process, such as 10KV electricity at each station. Load statistics report and so on. But in practice, these reports are all independently conf...

AI Technical Summary

Problems solved by technology

[0004] 1. Part of the software only implements the function of querying and publishing reports through the web, while the basic report configuration tools are still implemented based on the C / S architecture

[0005] 2. Most of the web report software is developed based on the Microsoft Excel platform, which makes it incompatible with the non-IE core browsers (such as Chrome, FireFox, etc.) that are widely used today, and the versatility is greatly reduced

Images