CN112966000A - Dynamic data statistical method and system based on multi-dimensional data annotation - Google Patents
Dynamic data statistical method and system based on multi-dimensional data annotation Download PDFInfo
- Publication number
- CN112966000A CN112966000A CN202110205048.6A CN202110205048A CN112966000A CN 112966000 A CN112966000 A CN 112966000A CN 202110205048 A CN202110205048 A CN 202110205048A CN 112966000 A CN112966000 A CN 112966000A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- dynamic
- statistical
- accumulated
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000007619 statistical method Methods 0.000 title claims abstract description 29
- 238000002372 labelling Methods 0.000 claims abstract description 22
- 238000004364 calculation method Methods 0.000 claims abstract description 17
- 238000000034 method Methods 0.000 claims abstract description 13
- 238000012545 processing Methods 0.000 claims abstract description 13
- 238000012552 review Methods 0.000 claims abstract description 5
- 238000009825 accumulation Methods 0.000 claims description 12
- 238000004422 calculation algorithm Methods 0.000 claims description 8
- 238000004140 cleaning Methods 0.000 claims description 4
- 238000013502 data validation Methods 0.000 claims description 4
- 238000005192 partition Methods 0.000 claims description 3
- 238000010835 comparative analysis Methods 0.000 abstract description 5
- 238000012544 monitoring process Methods 0.000 abstract description 5
- 230000000694 effects Effects 0.000 description 6
- 230000001186 cumulative effect Effects 0.000 description 4
- 238000012937 correction Methods 0.000 description 2
- 230000008520 organization Effects 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000087 stabilizing effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Abstract
The invention discloses a dynamic data statistical method and a system based on multi-dimensional data annotation, and the specific dynamic data statistical method comprises the following steps: the method comprises the following steps: technical responsible personnel organize technical personnel to carry out the review of the dynamic data statistical method, ask questions and answer, the technical personnel compile special dynamic data statistical methods and attention details and carry out technical background to the working personnel; step two: establishing a data statistics system and the data statistics system comprises: the device comprises a data reading type module, a time point judging module, a data reading range module and a data statistical processing module, wherein the data reading type module, the time point judging module, the data reading range module and the data statistical processing module are all connected with a processor through leads. The existing dynamic data statistical method and system based on multi-dimensional data labeling have simple steps, are convenient for accumulative calculation, dynamic monitoring and comparative analysis, can take deviation rectifying measures on deviated data in time and are convenient for saving manpower and material resources.
Description
Technical Field
The invention belongs to the technical field of data processing, and particularly relates to a dynamic data statistical method and system based on multi-dimensional data annotation.
Background
Statistics in the information age can help people to know information more intuitively. In the prior art, the statistical item calculation results of data and query data can be searched in a single organization mode through a fixed query statement, so that statistical data is obtained. However, there is a problem in that the organization of data may vary and may be diversified as necessary. Existing methods have been unable to accommodate this change. Meanwhile, for the same statistical object, indexes to be counted are not invariable, the existing dynamic data statistical method and system based on multi-dimensional data labeling have complex steps, are inconvenient for accumulative calculation, dynamic monitoring and comparative analysis, cannot take correction measures for deviated data in time, are inconvenient for saving manpower and material resources, and the existing operation statistical system has low precision, low speed and unobvious use effect.
Disclosure of Invention
The invention aims to provide a dynamic data statistical method and a system based on multi-dimensional data labeling, and aims to solve the problems that the existing dynamic data statistical method and the system based on multi-dimensional data labeling in the background art are complex in steps, inconvenient for accumulative calculation, dynamic monitoring and comparative analysis, incapable of taking deviation correcting measures for deviated data in time and inconvenient for saving manpower and material resources, and the existing operation statistical system is low in precision, low in speed and unobvious in using effect.
In order to achieve the purpose, the invention provides the following technical scheme: a dynamic data statistical method and a system based on multi-dimensional data labeling are disclosed, wherein the specific dynamic data statistical method comprises the following steps:
the method comprises the following steps: technical responsible personnel organize technical personnel to carry out the review of the dynamic data statistical method, ask questions and answer, the technical personnel compile special dynamic data statistical methods and attention details and carry out technical background to the working personnel;
step two: establishing a data statistics system and the data statistics system comprises: the device comprises a read data type module, a time point judgment module, a read data range module and a data statistics processing module, wherein the read data type module, the time point judgment module, the read data range module and the data statistics processing module are all connected with a processor through leads;
step three: establishing a database platform and the database platform comprises: the query module, the operation module, the comparison and analysis module and the historical curve module are convenient for comparison and analysis of newly input data information and establishment of a data time curve;
step four: the data in the database platform is inquired, and the data classification, statistics and listing are carried out through the comparison analysis module, so that the trend of the data can be summarized visually, the input data is drawn into a historical curve graph through the historical curve module, the classification and labeling are convenient, and the information data are obtained from the graph;
step five: performing online accumulation on the classified and labeled data in the step four, and performing data accumulation calculation according to an accumulation business rule;
step six: updating the last-period data of the online accumulator by using a partition parallel mode until all data are updated, and setting an accumulated data validation identifier to enable the updated data to validate the online application, wherein accumulated data information is validated as an accumulated plan data value;
step seven: the staff compares the accumulated plan data value with the actual accumulated data, dynamically tracks and monitors the dynamic data and the accumulated calculation data result, and takes corrective measures in time when the comparison result deviates.
Furthermore, the data statistical system is connected with the database platform through a GPRS module through a wireless network.
Further, the cumulative business rule in the fifth step includes a cumulative dimension, a cumulative quota, a cumulative algorithm, and a cleaning algorithm.
Furthermore, in the fourth step, an actual value is compiled according to data obtained by actual statistics, a planned value and a target value are established through the processor, and the actual value, the planned value and the target value are compared at an interval of 24 h.
Furthermore, the data statistical system supports query of index statistical data of any classification and comparison results of multi-classification statistics after associating classification information with a statistical result table generated according to an index set created by the index system.
Furthermore, in the data statistical system, the statistical object is labeled by using classification data of the classification system, and the statistical object ID and the association relation with the classification are stored in the classification system.
Furthermore, the data statistics system comprises a UPS power supply, and the input end of the processor is connected with the output end of the UPS power supply through a wire.
Compared with the prior art, the invention has the beneficial effects that:
(1) the data statistics system is established to automatically locate the type, the data size and the data range of data through the data type module, the time point judgment module, the data reading range module and the data statistics processing module, so that the data information can be conveniently classified and stored in the processor, and the database platform is established to conveniently compare and analyze the newly-entered data information of the processor and establish a data time curve through the query module, the operation module, the comparison and analysis module and the historical curve module.
(2) The data classification, statistics and listing are carried out through the comparison analysis module, the data trend can be summarized visually conveniently, the historical curve module is used for drawing the input data into a historical curve graph, the classification and labeling are convenient, the information data are obtained from the graph, the accumulated plan data value is compared with the actual accumulated data, the dynamic data and the accumulated calculation data result are dynamically tracked and monitored, and the deviation rectification measures are taken timely when the comparison result deviates.
(3) The existing dynamic data statistical method and system based on multi-dimensional data labeling have the advantages of simple steps, convenience for accumulative calculation, dynamic monitoring and comparative analysis, capability of taking deviation rectifying measures for deviated data in time and convenience for saving manpower and material resources, high precision, high operation speed, high stability and obvious use effect, and are suitable for wide popularization and use.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example 1
A dynamic data statistical method and a system based on multi-dimensional data labeling are disclosed, wherein the specific dynamic data statistical method comprises the following steps:
the method comprises the following steps: technical responsible personnel organize technical personnel to carry out the review of the dynamic data statistical method, ask questions and answer, the technical personnel compile special dynamic data statistical methods and attention details and carry out technical background to the working personnel;
step two: establishing a data statistics system and the data statistics system comprises: the device comprises a read data type module, a time point judgment module, a read data range module and a data statistics processing module, wherein the read data type module, the time point judgment module, the read data range module and the data statistics processing module are all connected with a processor through leads;
step three: establishing a database platform and the database platform comprises: the query module, the operation module, the comparison and analysis module and the historical curve module are convenient for comparison and analysis of newly input data information and establishment of a data time curve;
step four: the data in the database platform is inquired, and the data classification, statistics and listing are carried out through the comparison analysis module, so that the trend of the data can be summarized visually, the input data is drawn into a historical curve graph through the historical curve module, the classification and labeling are convenient, and the information data are obtained from the graph;
step five: performing online accumulation on the classified and labeled data in the step four, and performing data accumulation calculation according to an accumulation business rule;
step six: updating the last-period data of the online accumulator by using a partition parallel mode until all data are updated, and setting an accumulated data validation identifier to enable the updated data to validate the online application, wherein accumulated data information is validated as an accumulated plan data value;
step seven: the staff compares the accumulated plan data value with the actual accumulated data, dynamically tracks and monitors the dynamic data and the accumulated calculation data result, and takes corrective measures in time when the comparison result deviates.
The data statistical system is connected with the database platform through a GPRS module through a wireless network.
And the fifth step of accumulating business rules comprises accumulating dimensionality, accumulating quota, accumulating algorithm and cleaning algorithm.
And in the fourth step, an actual value is compiled according to data obtained by actual statistics, a planned value and a target value are established through a processor, and the actual value, the planned value and the target value are compared at an interval of 24 h.
The data statistical system supports query of index statistical data of any classification and comparison results of multi-classification statistics after associating classification information with a statistical result table generated according to an index set created by the index system.
In the data statistical system, a statistical object is marked by using classification data of a classification system, and the ID of the statistical object and the association relation with the classification are stored in the classification system.
The data statistics system comprises a UPS power supply, and the input end of the processor is connected with the output end of the UPS power supply through a wire.
Example 2
A dynamic data statistical method and a system based on multi-dimensional data labeling are disclosed, wherein the specific dynamic data statistical method comprises the following steps:
the method comprises the following steps: technical responsible personnel organize technical personnel to carry out the review of the dynamic data statistical method, ask questions and answer, the technical personnel compile special dynamic data statistical methods and attention details and carry out technical background to the working personnel;
step two: establishing a data statistics system and the data statistics system comprises: the device comprises a read data type module, a time point judgment module, a read data range module and a data statistics processing module, wherein the read data type module, the time point judgment module, the read data range module and the data statistics processing module are all connected with a processor through leads;
step three: establishing a database platform and the database platform comprises: the query module, the operation module, the comparison and analysis module and the historical curve module are convenient for comparison and analysis of newly input data information and establishment of a data time curve;
step four: the data in the database platform is inquired, and the data classification, statistics and listing are carried out through the comparison analysis module, so that the trend of the data can be summarized visually, the input data is drawn into a historical curve graph through the historical curve module, the classification and labeling are convenient, and the information data are obtained from the graph;
step five: carrying out batch accumulation on the classified and labeled data in the step four, and carrying out data accumulation calculation according to an accumulation business rule;
step six: setting an accumulative data validation identifier until all data are updated, and enabling the updated data application to take effect, wherein the accumulative data information takes effect as an accumulative planned data value;
step seven: the staff compares the accumulated plan data value with the actual accumulated data, dynamically tracks and monitors the dynamic data and the accumulated calculation data result, and takes corrective measures in time when the comparison result deviates.
The data statistical system is connected with the database platform through a GPRS module through a wireless network, and the GPRS module is used for facilitating data transmission and reception.
The accumulated business rule in the fifth step comprises accumulated dimensionality, accumulated quota, accumulated algorithm and cleaning algorithm, and the method is high in calculation precision, high in operation speed and good in stabilizing effect.
And in the fourth step, an actual value is compiled according to data obtained by actual statistics, a planned value and a target value are established through a processor, the actual value, the planned value and the target value are compared at intervals of 24h, and a deviation value is found out after comparison and analysis, so that deviation correction measures can be conveniently taken.
The data statistical system supports query of index statistical data of any classification and comparison results of multi-classification statistics after associating classification information with a statistical result table generated according to an index set created by the index system.
In the data statistical system, a statistical object is marked by using classification data of a classification system, a statistical object ID and an association relation with classification are stored in the classification system, the statistical object ID is stored, and the data statistical system is convenient to search through a query module.
The data statistics system comprises a UPS (uninterrupted power supply), the input end of the processor is connected with the output end of the UPS through a wire, and the UPS is used for supplying power to the electric equipment conveniently so as to enable the electric equipment to run stably.
When the invention works: the data statistics system is established to automatically locate the type, the data size and the data range of data through the data type module, the time point judgment module, the data reading range module and the data statistics processing module, so that the data information can be conveniently classified and stored in the processor, and the database platform is established to conveniently compare and analyze the newly-entered data information of the processor and establish a data time curve through the query module, the operation module, the comparison and analysis module and the historical curve module. The data classification, statistics and listing are carried out through the comparison analysis module, the data trend can be summarized visually conveniently, the historical curve module is used for drawing the input data into a historical curve graph, the classification and labeling are convenient, the information data are obtained from the graph, the accumulated plan data value is compared with the actual accumulated data, the dynamic data and the accumulated calculation data result are dynamically tracked and monitored, and the deviation rectification measures are taken timely when the comparison result deviates. The existing dynamic data statistical method and system based on multi-dimensional data labeling have the advantages of simple steps, convenience for accumulative calculation, dynamic monitoring and comparative analysis, capability of taking deviation rectifying measures for deviated data in time and convenience for saving manpower and material resources, high precision, high operation speed, high stability and obvious use effect, and are suitable for wide popularization and use.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (7)
1. A dynamic data statistical method and a system based on multi-dimensional data labeling are characterized in that the specific dynamic data statistical method comprises the following steps:
the method comprises the following steps: technical responsible personnel organize technical personnel to carry out the review of the dynamic data statistical method, ask questions and answer, the technical personnel compile special dynamic data statistical methods and attention details and carry out technical background to the working personnel;
step two: establishing a data statistics system and the data statistics system comprises: the device comprises a read data type module, a time point judgment module, a read data range module and a data statistics processing module, wherein the read data type module, the time point judgment module, the read data range module and the data statistics processing module are all connected with a processor through leads;
step three: establishing a database platform and the database platform comprises: the query module, the operation module, the comparison and analysis module and the historical curve module are convenient for comparison and analysis of newly input data information and establishment of a data time curve;
step four: the data in the database platform is inquired, and the data classification, statistics and listing are carried out through the comparison analysis module, so that the trend of the data can be summarized visually, the input data is drawn into a historical curve graph through the historical curve module, the classification and labeling are convenient, and the information data are obtained from the graph;
step five: performing online accumulation on the classified and labeled data in the step four, and performing data accumulation calculation according to an accumulation business rule;
step six: updating the last-period data of the online accumulator by using a partition parallel mode until all data are updated, and setting an accumulated data validation identifier to enable the updated data to validate the online application, wherein accumulated data information is validated as an accumulated plan data value;
step seven: the staff compares the accumulated plan data value with the actual accumulated data, dynamically tracks and monitors the dynamic data and the accumulated calculation data result, and takes corrective measures in time when the comparison result deviates.
2. The method and system for dynamic data statistics based on multi-dimensional data labeling according to claim 1, wherein: the data statistical system is connected with the database platform through a GPRS module through a wireless network.
3. The method and system for dynamic data statistics based on multi-dimensional data labeling according to claim 1, wherein: and the accumulated business rule in the fifth step comprises accumulated dimension, accumulated quota, accumulated algorithm and cleaning algorithm.
4. The method and system for dynamic data statistics based on multi-dimensional data labeling according to claim 1, wherein: and in the fourth step, an actual value is compiled according to data obtained by actual statistics, a planned value and a target value are established through a processor, and the actual value, the planned value and the target value are compared at an interval of 24 h.
5. The method and system for dynamic data statistics based on multi-dimensional data labeling according to claim 1, wherein: the data statistical system supports the inquiry of index statistical data of any classification and comparison results of multi-classification statistics after associating classification information with a statistical result table generated according to an index set created by the index system.
6. The method and system for dynamic data statistics based on multi-dimensional data labeling according to claim 1, wherein: in the data statistical system, the statistical object is marked by using classification data of the classification system, and the statistical object ID and the association relation with the classification are stored in the classification system.
7. The method and system for dynamic data statistics based on multi-dimensional data labeling according to claim 1, wherein: the data statistics system comprises a UPS power supply, and the input end of the processor is connected with the output end of the UPS power supply through a wire.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110205048.6A CN112966000A (en) | 2021-02-24 | 2021-02-24 | Dynamic data statistical method and system based on multi-dimensional data annotation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110205048.6A CN112966000A (en) | 2021-02-24 | 2021-02-24 | Dynamic data statistical method and system based on multi-dimensional data annotation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112966000A true CN112966000A (en) | 2021-06-15 |
Family
ID=76285859
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110205048.6A Pending CN112966000A (en) | 2021-02-24 | 2021-02-24 | Dynamic data statistical method and system based on multi-dimensional data annotation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112966000A (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104156442A (en) * | 2014-08-13 | 2014-11-19 | 中国银行股份有限公司 | Method and system for multi-dimension accumulation on basis of dynamic data and static data and accumulated data application method |
| CN110069575A (en) * | 2019-04-25 | 2019-07-30 | 中电科嘉兴新型智慧城市科技发展有限公司 | A kind of dynamic data statistical method and system based on multidimensional data mark |
-
2021
- 2021-02-24 CN CN202110205048.6A patent/CN112966000A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104156442A (en) * | 2014-08-13 | 2014-11-19 | 中国银行股份有限公司 | Method and system for multi-dimension accumulation on basis of dynamic data and static data and accumulated data application method |
| CN110069575A (en) * | 2019-04-25 | 2019-07-30 | 中电科嘉兴新型智慧城市科技发展有限公司 | A kind of dynamic data statistical method and system based on multidimensional data mark |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110134708A (en) | Electric net platform region line loss abnormal cause diagnostic method, device, computer equipment and storage medium | |
| CN101789006A (en) | Intelligent search based quick searching method of power grid enterprise information integrating system | |
| CN111090643B (en) | Mass electricity consumption data mining method based on data analysis system | |
| CN112766780A (en) | Advanced plan scheduling system and method based on big data machine learning | |
| CN111159204B (en) | Method and system for generating label in configuration mode | |
| CN102346765B (en) | A kind of method of audit memory data and device | |
| CN114461644A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN108876154A (en) | A kind of Electric Power Network Planning big data analysis system | |
| CN112966000A (en) | Dynamic data statistical method and system based on multi-dimensional data annotation | |
| CN113642933A (en) | Power distribution station low-voltage diagnosis method and device | |
| CN106383917A (en) | Data processing method based on user logs | |
| CN112052965A (en) | Visual electric power equipment online management system and management method | |
| CN116246765A (en) | Intelligent maintenance management method and system for full life cycle of medical equipment | |
| CN105721586A (en) | Information intelligent distribution device, method and system | |
| CN115544010A (en) | Mapping relation determining method and device, electronic equipment and storage medium | |
| CN116361367A (en) | Content identification system and method for efficiently publishing recruitment information | |
| CN110378585A (en) | Electric network fault disposes calculating task layout call method, system and storage medium | |
| CN113852196A (en) | Power supply system data management system | |
| Ya’An | Application of artificial intelligence in computer network technology in the era of big data | |
| WO2020228211A1 (en) | Enterprise work progress query system | |
| CN112308437A (en) | Line loss management method, system, device and storage medium based on big data analysis | |
| CN105912568A (en) | Monitoring signal fuzzy matching query method under cloud environment | |
| CN112101798A (en) | Power equipment service life management method based on big data technology | |
| CN105159967A (en) | Patent tracking system and tracking method therefor | |
| CN112183997A (en) | Monitoring and analyzing system for abnormal state of energy consumption unit |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210615 |