CN116431638B - Index processing method, equipment and medium for water conservancy industry - Google Patents
Index processing method, equipment and medium for water conservancy industry Download PDFInfo
- Publication number
- CN116431638B CN116431638B CN202310410189.0A CN202310410189A CN116431638B CN 116431638 B CN116431638 B CN 116431638B CN 202310410189 A CN202310410189 A CN 202310410189A CN 116431638 B CN116431638 B CN 116431638B
- Authority
- CN
- China
- Prior art keywords
- index
- generating
- atomic
- water conservancy
- calculation result
- 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.)
- Active
Links
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 title claims abstract description 110
- 238000003672 processing method Methods 0.000 title claims abstract description 12
- 238000004364 calculation method Methods 0.000 claims abstract description 132
- 239000002131 composite material Substances 0.000 claims abstract description 61
- 238000000034 method Methods 0.000 claims abstract description 42
- 238000012545 processing Methods 0.000 claims abstract description 20
- 238000012795 verification Methods 0.000 claims description 14
- 238000003860 storage Methods 0.000 claims description 12
- 238000004140 cleaning Methods 0.000 claims description 3
- 238000004458 analytical method Methods 0.000 abstract description 4
- 238000012544 monitoring process Methods 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 8
- 238000004590 computer program Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 230000009286 beneficial effect Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 230000009466 transformation Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 238000011217 control strategy Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000012360 testing method 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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
- G06F16/24553—Query execution of query operations
-
- 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/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02A—TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
- Y02A10/00—TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE at coastal zones; at river basins
- Y02A10/40—Controlling or monitoring, e.g. of flood or hurricane; Forecasting, e.g. risk assessment or mapping
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Marketing (AREA)
- Software Systems (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- Quality & Reliability (AREA)
- Human Resources & Organizations (AREA)
- Computational Linguistics (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses an index processing method, equipment and medium for water conservancy industry, wherein the method comprises the following steps: acquiring multi-source data of a target water conservancy service; generating an atomic index of the target water conservancy service according to a preset rule; generating a derivative index and a composite index according to the atomic index; and generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model. The method can automatically generate each index and an index calculation result, and can realize an efficient, accurate and reliable index processing method for the target water conservancy service so as to realize real-time monitoring, early warning and analysis of key indexes of the water conservancy industry and improve decision-making efficiency and index processing efficiency of the water conservancy industry.
Description
Technical Field
The application relates to the technical field of data processing, in particular to an index processing method, equipment and medium for water conservancy industry.
Background
Digital transformation is becoming important and urgent for more and more industries. How to better utilize data has become a key to digital transformation, and the accuracy of data often determines the core competitiveness and value of a product, and various data indexes directly affect the implementation of various decisions.
However, in the digital transformation of the water conservancy industry, as the water conservancy data relates to various data sources, the complexity of the water conservancy data is caused, so that in order to ensure the accuracy of the index processing of the water conservancy service, most of manual participation modes are still adopted to divide the index and calculate the index of the water conservancy data, thereby causing the low efficiency of the index processing of the target water conservancy service.
Disclosure of Invention
The embodiment of the application provides an index processing method, equipment and medium for the water conservancy industry, which are used for solving the problem of low index processing efficiency of target water conservancy business.
The embodiment of the application adopts the following technical scheme:
in one aspect, an embodiment of the present application provides an index processing method for a water conservancy industry, where the method includes: acquiring multi-source data of a target water conservancy service; generating an atomic index of the target water conservancy service according to a preset rule; generating a derivative index and a composite index according to the atomic index; and generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model.
In one example, the generating the atomic indicator of the target water conservancy service according to a preset rule specifically includes: determining a dimension for the target water conservancy service; searching a fact table field template corresponding to the dimension in a pre-constructed target water conservancy service dimension template library; generating a fact table of the dimension according to the fact table field template and the multi-source data; and generating the atomic index of the target water conservancy service according to the fact table.
In one example, the generating the derivative indicator and the composite indicator according to the atomic indicator specifically includes: determining a derivative relation dimension corresponding to the atomic index based on the service requirement of the target water conservancy service so as to generate a derivative index of the atomic index; and determining the composite index corresponding to the atomic index according to the operation rule of the target water conservancy service.
In one example, the generating, according to a preset index calculation model, an index calculation result for the atomic index, the derivative index, and the composite index specifically includes: determining first index calculation logic and a first index statistical period of the atomic index based on the operation of a user; determining a second index calculation logic and a second index statistical period of the derivative index; determining a third index calculation logic and a third index statistical period of the composite index; generating an index calculation result of the atomic index through the first index calculation logic based on the first index statistical period; generating an index calculation result of the derived index through the second index calculation logic based on the second index statistical period; and generating an index calculation result of the composite index through the second index calculation logic based on the second index statistical period.
In one example, the obtaining multi-source data of the target water conservancy service specifically includes: determining a data source related to the target water conservancy service, wherein the data source comprises a water conservancy sensor, a satellite remote sensing sensor, a weather bureau and a hydrologic bureau; acquiring initial multi-source data of the target water conservancy service according to the data source; and cleaning and integrating the initial multi-source data to obtain the multi-source data of the target water conservancy service.
In one example, after the generating the index calculation result for the atomic index, the derivative index, and the composite index according to the preset index calculation model, the method further includes: in an alarm rule base of the target water conservancy service, determining alarm rules respectively corresponding to the atomic index, the derivative index and the composite index; judging whether the index calculation result triggers an alarm or not according to the alarm rules corresponding to the indexes; if yes, generating corresponding alarm notification information; and sending the alarm notification information to alarm terminal equipment.
In one example, after the generating the index calculation result for the atomic index, the derivative index, and the composite index according to the preset index calculation model, the method further includes: determining an index display template of the target water conservancy service; generating a display chart of the index calculation result according to the index display template; and displaying the index calculation result to a user interface according to the display chart.
In one example, after the generating the index calculation result for the atomic index, the derivative index, and the composite index according to the preset index calculation model, the method further includes: acquiring an identity verification request of a user; carrying out authenticity verification on the user, and if the verification is passed, authorizing the user; determining the authorized role and the authorized authority of the user so as to establish the association relationship between the user and the corresponding index; and displaying the corresponding index and the calculation result of the corresponding index to the user according to the association relation.
On the other hand, the embodiment of the application provides index processing equipment for water conservancy industry, which comprises: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to: acquiring multi-source data of a target water conservancy service; generating an atomic index of the target water conservancy service according to a preset rule; generating a derivative index and a composite index according to the atomic index; and generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model.
In another aspect, embodiments of the present application provide a non-volatile computer storage medium storing computer-executable instructions for index processing for water conservancy industry, the computer-executable instructions configured to: acquiring multi-source data of a target water conservancy service; generating an atomic index of the target water conservancy service according to a preset rule; generating a derivative index and a composite index according to the atomic index; and generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model.
The above-mentioned at least one technical scheme that this application embodiment adopted can reach following beneficial effect:
the method can automatically generate each index and an index calculation result, and can realize an efficient, accurate and reliable index processing method for the target water conservancy service so as to realize real-time monitoring, early warning and analysis of key indexes of the water conservancy industry and improve decision-making efficiency and index processing efficiency of the water conservancy industry.
Drawings
In order to more clearly illustrate the technical solutions of the present application, some embodiments of the present application will be described in detail below with reference to the accompanying drawings, in which:
fig. 1 is a schematic flow chart of an index processing method for water conservancy industry according to an embodiment of the present application;
fig. 2 is a schematic structural diagram of an index processing device for water conservancy industry according to an embodiment of the present application.
Detailed Description
For the purposes, technical solutions and advantages of the present application, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments and corresponding drawings. It will be apparent that the described embodiments are only some, but not all, of the embodiments of the present application. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.
Some embodiments of the present application are described in detail below with reference to the accompanying drawings.
Fig. 1 is a schematic flow chart of an index processing method for water conservancy industry according to an embodiment of the present application. Some of the input parameters or intermediate results in the flow allow for manual intervention adjustments to help improve accuracy.
The implementation of the analysis method according to the embodiment of the present application may be a terminal device or a server, which is not particularly limited in this application. For ease of understanding and description, the following embodiments are described in detail with reference to a server.
It should be noted that the server may be a single device, or may be a system formed by a plurality of devices, that is, a distributed server, which is not specifically limited in this application.
It should be noted that, in the embodiment of the present application, index processing is implemented by using a water conservancy industry index management tool, where the tool is a data index management tool based on a distributed and B/S architecture and having simple operation, supports one-stage deployment and multi-stage use, provides perfect task monitoring, management and configuration functions, supports drop-down selection of various dimension information, and generates an index display manner in a form of drag on a canvas.
The first-level deployment grading can realize that different users are adopted to create own data fields, share and personally customize data indexes, and display corresponding index information according to user level grading, so that the purpose of first-level deployment grading use is achieved.
The flow in fig. 1 includes the following steps:
s101: and obtaining multi-source data of the target water conservancy service.
In some embodiments of the present application, a data source related to a target water conservancy service is first determined. The data sources comprise a water conservancy sensor, a satellite remote sensing sensor, a weather bureau and a hydrologic bureau.
And then, according to the data source, acquiring initial multi-source data of the target water conservancy service. And then, cleaning and integrating the initial multi-source data to obtain multi-source data of the target water conservancy service.
It should be noted that the target water conservancy service refers to a water conservancy project that needs to be monitored, for example, a target reservoir, a target river channel, and the like.
S102: and generating the atomic index of the target water conservancy service according to a preset rule.
In some embodiments of the present application, dimensions for a target water conservancy service are first determined. And then, searching the fact table field template corresponding to the dimension in a pre-constructed target water conservancy service dimension template library. And then, generating a dimension fact table according to the fact table field template and the multi-source data. And finally, generating an atomic index of the target water conservancy service according to the fact table.
That is, the atomic indicator is a statistical value (sum, count, max, min, avg) of a certain field in the fact table, such as rainfall, water level, etc.
S103: and generating a derivative index and a composite index according to the atomic index.
The derived index is an index generated after dimension combination based on an atomic index, such as average rainfall on the same day, average rainfall in a certain administrative division, and the like.
The composite index is a calculation index formed by an operation rule above the atomic index. Such as average rainfall.
In some embodiments of the present application, first, based on a service requirement of a target water conservancy service, a derivative relation dimension corresponding to an atomic index is determined to generate a derivative index of the atomic index. And then, determining a composite index corresponding to the atomic index according to the operation rule of the target water conservancy service.
S104: and generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model.
In some embodiments of the present application, first, based on a user operation, first index calculation logic and a first index statistical period of an atomic index are determined, and second index calculation logic and a second index statistical period of a derivative index are determined; and third index calculation logic that determines the composite index and a third index statistical period.
Thus, an index calculation result of the atomic index is generated by the first index calculation logic based on the first index statistical period.
Thereby, based on a second index statistical period, generating an index calculation result of the derived index through the second index calculation logic;
thus, an index calculation result of the composite index is generated by the second index calculation logic based on the second index statistical period.
It should be noted that, support on-line test each index, provide index SQL preview function and index calculation function, and print calculation log and index operation result in real time. The index calculation supports a timing operation and terminal equipment operation mechanism, and data calculation of various indexes is realized.
In some embodiments of the present application, early warning is required for the index calculation result, so as to discover the danger generated by the target water conservancy service in time.
Specifically, in an alarm rule base of the target water conservancy service, alarm rules corresponding to the atomic index, the derivative index and the composite index are determined. And then, judging whether the index calculation result triggers an alarm or not according to the alarm rules respectively corresponding to the index calculation result. If yes, generating corresponding alarm notification information, and sending the alarm notification information to alarm terminal equipment. If not, the alarm processing is not performed.
It should be noted that, various alarm modes are supported, including but not limited to, mail, short message, voice, APP, etc. alarm notification channels.
In some examples of the present application, the index calculation results are presented in order to allow the user to more intuitively view the index calculation results.
Firstly, determining an index display template of a target water conservancy service, and then generating a display chart of an index calculation result according to the index display template. And then, displaying the index calculation result to a user interface according to the display chart.
It should be noted that the index presentation templates may include tables, bar charts, line charts, pie charts, etc., i.e., support multiple presentation formats and styles, and provide customizable presentation templates and themes.
In some embodiments of the present application, different metrics may be assigned to different users for maintenance.
Specifically, first, an authentication request of a user is acquired. And then, carrying out authenticity verification on the user, and if the verification is passed, authorizing the user. Then, determining the authorized role and the authorized authority of the user so as to establish the association relationship between the user and the corresponding index. And finally, displaying the corresponding index and the calculation result of the corresponding index to the user according to the association relation.
That is, a plurality of different authority levels and access control strategies are formulated for different users, and the safety and the reliability of the system are ensured.
It should be noted that, although the embodiment of the present application is described with reference to fig. 1 to sequentially describe steps S101 to S104, this does not represent that steps S101 to S104 must be performed in strict order. The steps S101 to S104 are sequentially described according to the sequence shown in fig. 1 in the embodiment of the present application, so as to facilitate the understanding of the technical solution of the embodiment of the present application by those skilled in the art. In other words, in the embodiment of the present application, the sequence between the steps S101 to S104 may be appropriately adjusted according to the actual needs.
By the method of FIG. 1, each index and an index calculation result can be automatically generated, and an efficient, accurate and reliable index processing method for the target water conservancy service can be realized, so that real-time monitoring, early warning and analysis of key indexes of the water conservancy industry are realized, and the decision efficiency and index processing efficiency of the water conservancy industry are improved.
Based on the same thought, some embodiments of the present application further provide a device and a non-volatile computer storage medium corresponding to the above method.
Fig. 2 is a schematic structural diagram of an index processing device for water conservancy industry according to an embodiment of the present application, including:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
acquiring multi-source data of a target water conservancy service;
generating an atomic index of the target water conservancy service according to a preset rule;
generating a derivative index and a composite index according to the atomic index;
and generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model.
Some embodiments of the present application provide a non-volatile computer storage medium for index processing of water conservancy industry, storing computer executable instructions configured to:
acquiring multi-source data of a target water conservancy service;
generating an atomic index of the target water conservancy service according to a preset rule;
generating a derivative index and a composite index according to the atomic index;
and generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model.
All embodiments in the application are described in a progressive manner, and identical and similar parts of all embodiments are mutually referred, so that each embodiment mainly describes differences from other embodiments. In particular, for the apparatus and medium embodiments, the description is relatively simple, as it is substantially similar to the method embodiments, with reference to the section of the method embodiments being relevant.
The devices and media provided in the embodiments of the present application are in one-to-one correspondence with the methods, so that the devices and media also have similar beneficial technical effects as the corresponding methods, and since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media are not described in detail herein.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and changes may be made to the present application by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the technical principles of the present application should fall within the protection scope of the present application.
Claims (4)
1. An index processing method for water conservancy industry, which is characterized by comprising the following steps:
acquiring multi-source data of a target water conservancy service;
generating an atomic index of the target water conservancy service according to a preset rule;
generating a derivative index and a composite index according to the atomic index;
generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model;
the generating the atomic index of the target water conservancy service according to the preset rule specifically comprises:
determining a dimension for the target water conservancy service;
searching a fact table field template corresponding to the dimension in a pre-constructed target water conservancy service dimension template library;
generating a fact table of the dimension according to the fact table field template and the multi-source data;
generating an atomic index of the target water conservancy service according to the fact table;
generating a derivative index and a composite index according to the atomic index, specifically including:
determining a derivative relation dimension corresponding to the atomic index based on the service requirement of the target water conservancy service so as to generate a derivative index of the atomic index;
determining a composite index corresponding to the atomic index according to the operation rule of the target water conservancy service;
generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model, wherein the index calculation result specifically comprises:
determining first index calculation logic and a first index statistical period of the atomic index based on the operation of a user; determining a second index calculation logic and a second index statistical period of the derivative index; determining a third index calculation logic and a third index statistical period of the composite index;
generating an index calculation result of the atomic index through the first index calculation logic based on the first index statistical period;
generating an index calculation result of the derived index through the second index calculation logic based on the second index statistical period;
generating an index calculation result of the composite index through the third index calculation logic based on the third index statistical period;
after generating the index calculation result for the atomic index, the derivative index and the composite index according to the preset index calculation model, the method further includes:
in an alarm rule base of the target water conservancy service, determining alarm rules respectively corresponding to the atomic index, the derivative index and the composite index;
judging whether the index calculation result triggers an alarm or not according to the alarm rules corresponding to the indexes;
if yes, generating corresponding alarm notification information;
sending the alarm notification information to alarm terminal equipment;
after generating the index calculation result for the atomic index, the derivative index and the composite index according to the preset index calculation model, the method further includes:
determining an index display template of the target water conservancy service;
generating a display chart of the index calculation result according to the index display template;
displaying the index calculation result to a user interface according to the display chart;
after generating the index calculation result for the atomic index, the derivative index and the composite index according to the preset index calculation model, the method further includes:
acquiring an identity verification request of a user;
carrying out authenticity verification on the user, and if the verification is passed, authorizing the user;
determining the authorized role and the authorized authority of the user so as to establish the association relationship between the user and the corresponding index;
and displaying the corresponding index and the calculation result of the corresponding index to the user according to the association relation.
2. The method according to claim 1, wherein the obtaining multi-source data of the target water conservancy service specifically comprises:
determining a data source related to the target water conservancy service, wherein the data source comprises a water conservancy sensor, a satellite remote sensing sensor, a weather bureau and a hydrologic bureau;
acquiring initial multi-source data of the target water conservancy service according to the data source;
and cleaning and integrating the initial multi-source data to obtain the multi-source data of the target water conservancy service.
3. Index processing equipment to water conservancy trade, characterized by, include:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
acquiring multi-source data of a target water conservancy service;
generating an atomic index of the target water conservancy service according to a preset rule;
generating a derivative index and a composite index according to the atomic index;
generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model;
the generating the atomic index of the target water conservancy service according to the preset rule specifically comprises:
determining a dimension for the target water conservancy service;
searching a fact table field template corresponding to the dimension in a pre-constructed target water conservancy service dimension template library;
generating a fact table of the dimension according to the fact table field template and the multi-source data;
generating an atomic index of the target water conservancy service according to the fact table;
generating a derivative index and a composite index according to the atomic index, specifically including:
determining a derivative relation dimension corresponding to the atomic index based on the service requirement of the target water conservancy service so as to generate a derivative index of the atomic index;
determining a composite index corresponding to the atomic index according to the operation rule of the target water conservancy service;
generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model, wherein the index calculation result specifically comprises:
determining first index calculation logic and a first index statistical period of the atomic index based on the operation of a user; determining a second index calculation logic and a second index statistical period of the derivative index; determining a third index calculation logic and a third index statistical period of the composite index;
generating an index calculation result of the atomic index through the first index calculation logic based on the first index statistical period;
generating an index calculation result of the derived index through the second index calculation logic based on the second index statistical period;
generating an index calculation result of the composite index through the third index calculation logic based on the third index statistical period;
the method further includes, after generating an index calculation result for the atomic index, the derivative index, and the composite index according to a preset index calculation model, the method further includes:
in an alarm rule base of the target water conservancy service, determining alarm rules respectively corresponding to the atomic index, the derivative index and the composite index;
judging whether the index calculation result triggers an alarm or not according to the alarm rules corresponding to the indexes;
if yes, generating corresponding alarm notification information;
sending the alarm notification information to alarm terminal equipment;
the method further includes, after generating an index calculation result for the atomic index, the derivative index, and the composite index according to a preset index calculation model, the method further includes:
determining an index display template of the target water conservancy service;
generating a display chart of the index calculation result according to the index display template;
displaying the index calculation result to a user interface according to the display chart;
the method further includes, after generating an index calculation result for the atomic index, the derivative index, and the composite index according to a preset index calculation model, the method further includes:
acquiring an identity verification request of a user;
carrying out authenticity verification on the user, and if the verification is passed, authorizing the user;
determining the authorized role and the authorized authority of the user so as to establish the association relationship between the user and the corresponding index;
and displaying the corresponding index and the calculation result of the corresponding index to the user according to the association relation.
4. A non-volatile computer storage medium storing computer executable instructions for index processing of water conservancy industry, characterized in that the computer executable instructions are configured to:
acquiring multi-source data of a target water conservancy service;
generating an atomic index of the target water conservancy service according to a preset rule;
generating a derivative index and a composite index according to the atomic index;
generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model;
the generating the atomic index of the target water conservancy service according to the preset rule specifically comprises:
determining a dimension for the target water conservancy service;
searching a fact table field template corresponding to the dimension in a pre-constructed target water conservancy service dimension template library;
generating a fact table of the dimension according to the fact table field template and the multi-source data;
generating an atomic index of the target water conservancy service according to the fact table;
generating a derivative index and a composite index according to the atomic index, specifically including:
determining a derivative relation dimension corresponding to the atomic index based on the service requirement of the target water conservancy service so as to generate a derivative index of the atomic index;
determining a composite index corresponding to the atomic index according to the operation rule of the target water conservancy service;
generating an index calculation result for the atomic index, the derivative index and the composite index according to a preset index calculation model, wherein the index calculation result specifically comprises:
determining first index calculation logic and a first index statistical period of the atomic index based on the operation of a user; determining a second index calculation logic and a second index statistical period of the derivative index; determining a third index calculation logic and a third index statistical period of the composite index;
generating an index calculation result of the atomic index through the first index calculation logic based on the first index statistical period;
generating an index calculation result of the derived index through the second index calculation logic based on the second index statistical period;
generating an index calculation result of the composite index through the third index calculation logic based on the third index statistical period;
the method further includes, after generating an index calculation result for the atomic index, the derivative index, and the composite index according to a preset index calculation model, the method further includes:
in an alarm rule base of the target water conservancy service, determining alarm rules respectively corresponding to the atomic index, the derivative index and the composite index;
judging whether the index calculation result triggers an alarm or not according to the alarm rules corresponding to the indexes;
if yes, generating corresponding alarm notification information;
sending the alarm notification information to alarm terminal equipment;
the method further includes, after generating an index calculation result for the atomic index, the derivative index, and the composite index according to a preset index calculation model, the method further includes:
determining an index display template of the target water conservancy service;
generating a display chart of the index calculation result according to the index display template;
displaying the index calculation result to a user interface according to the display chart;
the method further includes, after generating an index calculation result for the atomic index, the derivative index, and the composite index according to a preset index calculation model, the method further includes:
acquiring an identity verification request of a user;
carrying out authenticity verification on the user, and if the verification is passed, authorizing the user;
determining the authorized role and the authorized authority of the user so as to establish the association relationship between the user and the corresponding index;
and displaying the corresponding index and the calculation result of the corresponding index to the user according to the association relation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310410189.0A CN116431638B (en) | 2023-04-12 | 2023-04-12 | Index processing method, equipment and medium for water conservancy industry |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310410189.0A CN116431638B (en) | 2023-04-12 | 2023-04-12 | Index processing method, equipment and medium for water conservancy industry |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116431638A CN116431638A (en) | 2023-07-14 |
| CN116431638B true CN116431638B (en) | 2024-03-12 |
Family
ID=87092379
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310410189.0A Active CN116431638B (en) | 2023-04-12 | 2023-04-12 | Index processing method, equipment and medium for water conservancy industry |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116431638B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112328706A (en) * | 2020-11-03 | 2021-02-05 | 成都中科大旗软件股份有限公司 | Dimension modeling calculation method under digital bin system, computer equipment and storage medium |
| CN112541711A (en) * | 2020-12-29 | 2021-03-23 | 广东电网有限责任公司广州供电局 | Model construction method and device, computer equipment and storage medium |
| CN112598289A (en) * | 2020-12-25 | 2021-04-02 | 平安银行股份有限公司 | Index configuration method, system, computer device and computer readable storage medium |
| CN113723822A (en) * | 2021-09-01 | 2021-11-30 | 广东电网有限责任公司广州供电局 | Power supply service data management system |
| CN114881508A (en) * | 2022-05-24 | 2022-08-09 | 中国能源建设集团广东省电力设计研究院有限公司 | Data processing method, device and equipment for power grid index report |
| CN114880405A (en) * | 2022-03-31 | 2022-08-09 | 华能信息技术有限公司 | Data lake-based data processing method and system |
| CN114996247A (en) * | 2022-04-22 | 2022-09-02 | 华能澜沧江水电股份有限公司 | Large-scale drainage basin hydropower enterprise data management method |
| CN115470195A (en) * | 2022-09-29 | 2022-12-13 | 信华信技术股份有限公司 | Index data automatic calculation method and device fusing dimension models |
-
2023
- 2023-04-12 CN CN202310410189.0A patent/CN116431638B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112328706A (en) * | 2020-11-03 | 2021-02-05 | 成都中科大旗软件股份有限公司 | Dimension modeling calculation method under digital bin system, computer equipment and storage medium |
| CN112598289A (en) * | 2020-12-25 | 2021-04-02 | 平安银行股份有限公司 | Index configuration method, system, computer device and computer readable storage medium |
| CN112541711A (en) * | 2020-12-29 | 2021-03-23 | 广东电网有限责任公司广州供电局 | Model construction method and device, computer equipment and storage medium |
| CN113723822A (en) * | 2021-09-01 | 2021-11-30 | 广东电网有限责任公司广州供电局 | Power supply service data management system |
| CN114880405A (en) * | 2022-03-31 | 2022-08-09 | 华能信息技术有限公司 | Data lake-based data processing method and system |
| CN114996247A (en) * | 2022-04-22 | 2022-09-02 | 华能澜沧江水电股份有限公司 | Large-scale drainage basin hydropower enterprise data management method |
| CN114881508A (en) * | 2022-05-24 | 2022-08-09 | 中国能源建设集团广东省电力设计研究院有限公司 | Data processing method, device and equipment for power grid index report |
| CN115470195A (en) * | 2022-09-29 | 2022-12-13 | 信华信技术股份有限公司 | Index data automatic calculation method and device fusing dimension models |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116431638A (en) | 2023-07-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111092757B (en) | Abnormal data detection method, system and equipment | |
| CN112732641A (en) | Electronic file filing method, device and medium | |
| CN108958959B (en) | Method and device for detecting hive data table | |
| TWI709932B (en) | Method, device and equipment for monitoring transaction indicators | |
| CN116431638B (en) | Index processing method, equipment and medium for water conservancy industry | |
| CN107203545B (en) | Data processing method and device | |
| CN116341839B (en) | Order pushing method, equipment and medium for household service personnel | |
| CN110673828A (en) | Product configuration method | |
| CN113626415B (en) | Credit data output method, equipment and medium | |
| CN114493378A (en) | Index acquisition method and device of industrial equipment and computer equipment | |
| CN115687345A (en) | Report generation method and device, storage medium and electronic equipment | |
| CN115114275A (en) | Data acquisition method, device and medium | |
| CN112749754B (en) | Method and device for early warning of abnormal calculation of gear withdrawal time | |
| CN114818637A (en) | Report generation method and device, processor and electronic equipment | |
| CN114298749A (en) | Access method, device and medium for cost data source | |
| CN114462370A (en) | Method and device for generating view, storage medium and electronic equipment | |
| CN113362021A (en) | Organization management method and device, electronic equipment and storage medium | |
| CN112835880A (en) | Monitoring and early warning system, method and equipment based on software as a service (SaaS) | |
| CN112215511B (en) | Attendance data calculation method, device and equipment | |
| CN117764455B (en) | Universal index management method and system for data | |
| CN116610762B (en) | Management method, equipment and medium for enterprise data assets | |
| CN115174503B (en) | Emergency event communication method and device, storage medium and computer equipment | |
| CN114511236A (en) | Audit assessment method and audit assessment device | |
| CN117762667A (en) | System fault plan generation method and device, storage medium and electronic equipment | |
| CN114819245A (en) | Data monitoring and early warning system, method and equipment |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |