CN117670148A - Management system for business index system in coal industry - Google Patents
Management system for business index system in coal industry Download PDFInfo
- Publication number
- CN117670148A CN117670148A CN202410140892.9A CN202410140892A CN117670148A CN 117670148 A CN117670148 A CN 117670148A CN 202410140892 A CN202410140892 A CN 202410140892A CN 117670148 A CN117670148 A CN 117670148A
- Authority
- CN
- China
- Prior art keywords
- index
- data
- information
- coal industry
- coal
- 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.)
- Granted
Links
- 239000003245 coal Substances 0.000 title claims abstract description 132
- 238000007726 management method Methods 0.000 claims abstract description 86
- 238000004458 analytical method Methods 0.000 claims abstract description 51
- 238000012423 maintenance Methods 0.000 claims abstract description 26
- 238000007405 data analysis Methods 0.000 claims abstract description 18
- 238000013523 data management Methods 0.000 claims abstract description 16
- 238000007418 data mining Methods 0.000 claims abstract description 8
- 238000010276 construction Methods 0.000 claims abstract description 7
- 230000000007 visual effect Effects 0.000 claims abstract description 5
- 238000004364 calculation method Methods 0.000 claims description 24
- 239000002131 composite material Substances 0.000 claims description 19
- 230000008520 organization Effects 0.000 claims description 14
- 238000005259 measurement Methods 0.000 claims description 12
- 238000012544 monitoring process Methods 0.000 claims description 11
- 238000013441 quality evaluation Methods 0.000 claims description 10
- 230000003068 static effect Effects 0.000 claims description 7
- 230000008859 change Effects 0.000 claims description 6
- 238000013500 data storage Methods 0.000 claims description 6
- 150000001875 compounds Chemical class 0.000 claims description 5
- 238000007711 solidification Methods 0.000 claims description 5
- 230000008023 solidification Effects 0.000 claims description 5
- 230000002159 abnormal effect Effects 0.000 claims description 3
- 238000011084 recovery Methods 0.000 claims description 3
- 238000012800 visualization Methods 0.000 claims description 3
- 230000007246 mechanism Effects 0.000 claims description 2
- 238000001303 quality assessment method Methods 0.000 claims description 2
- 238000000034 method Methods 0.000 abstract description 5
- 238000013508 migration Methods 0.000 abstract description 4
- 230000005012 migration Effects 0.000 abstract description 4
- 230000008093 supporting effect Effects 0.000 abstract description 4
- OKTJSMMVPCPJKN-UHFFFAOYSA-N Carbon Chemical compound [C] OKTJSMMVPCPJKN-UHFFFAOYSA-N 0.000 abstract 1
- 229910052799 carbon Inorganic materials 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 8
- 238000004519 manufacturing process Methods 0.000 description 8
- 230000002776 aggregation Effects 0.000 description 5
- 238000004220 aggregation Methods 0.000 description 5
- 238000005065 mining Methods 0.000 description 5
- 239000000463 material Substances 0.000 description 4
- 230000001186 cumulative effect Effects 0.000 description 3
- 230000000737 periodic effect Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 238000013480 data collection Methods 0.000 description 2
- 238000009795 derivation Methods 0.000 description 2
- 238000005265 energy consumption Methods 0.000 description 2
- 238000010438 heat treatment Methods 0.000 description 2
- 238000000265 homogenisation Methods 0.000 description 2
- 230000002045 lasting effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000002085 persistent effect Effects 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- NINIDFKCEFEMDL-UHFFFAOYSA-N Sulfur Chemical compound [S] NINIDFKCEFEMDL-UHFFFAOYSA-N 0.000 description 1
- 238000007605 air drying Methods 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 238000013475 authorization Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000009776 industrial production Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 230000001376 precipitating effect Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 229910052717 sulfur Inorganic materials 0.000 description 1
- 239000011593 sulfur Substances 0.000 description 1
- 238000011144 upstream manufacturing Methods 0.000 description 1
- 238000005406 washing Methods 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application provides a business index system management system in coal industry, which relates to the technical field of coal, and comprises the following components: the data management module comprises a data acquisition unit which is used for connecting a plurality of data sources corresponding to the coal mine so as to acquire multi-source heterogeneous data of the coal mine; the index system construction module is used for building a coal industry business index system based on the tree structure; the index definition and maintenance module is used for performing index definition and index maintenance; the index data analysis module is used for performing index visual analysis, two-dimensional data mining report analysis and key index billboard analysis on the business indexes of each coal industry; the index authority management module is used for dividing the grading management authority corresponding to each coal industry business index for each user. The method ensures consistency of statistics caliber of cross-system and cross-department indexes, improves systematicness of index management, adapts to characteristics of coal and carbon industry, can support cross-mine migration, supports customizing analysis view angles based on data analysis templates, and achieves better industry supporting capability.
Description
Technical Field
The application relates to the technical field of coal, in particular to a business index system management system in the coal industry.
Background
In the mine production operation process, various key indexes are required to be monitored so as to timely adjust production plans, discover safety risks and hidden dangers as early as possible and effectively support various operation decisions.
In the related art, index statistics and calculation work are generally scattered in different systems or departments, global property and systematicness are lacking, and the situation that index names are the same in different forms but have different meanings or index names are inconsistent but have the same actual calculation mode often occurs; in addition, the traditional index statistics work is usually carried out when reporting demands exist, a persistent maintenance means is lacked, although the data values in each statistics period are different, the calculation logic is basically consistent, so that the statistics of different rounds have a plurality of homogeneous repeated works, and once statistics personnel change, the early experience is difficult to reuse, in most cases, the index analysis work needs to collect data from various departments or systems according to each analysis demand, the process is complex and time-consuming, the problem of untimely data update can occur, and once the analysis demand is adjusted, the supplementary data collection work is likely to be needed.
Disclosure of Invention
The present application aims to solve, at least to some extent, one of the technical problems in the related art.
An embodiment of a first aspect of the present application provides a system for managing a business index system in a coal industry, including: the system comprises a data management module, an index system construction module, an index definition and maintenance module, an index data analysis module and an index authority management module, wherein:
the data management module comprises a data acquisition unit, wherein the data acquisition unit is used for connecting a plurality of data sources corresponding to the coal mine so as to acquire multi-source heterogeneous data of the coal mine.
The index system construction module is used for building a coal industry business index system based on the tree structure, wherein the coal industry business index system comprises a plurality of coal industry business indexes and association relations among the coal industry business indexes.
The index definition and maintenance module is used for performing index definition and index maintenance, wherein the index definition refers to dividing business indexes of each coal industry into atomic indexes, derivative indexes, compound indexes, solidification indexes and nominal indexes, and the index maintenance comprises Chinese and English name information, business theme domain information, return department information, statistics period information, measurement unit information, father level index information, calculation logic information, data source information and shared data interface information of management indexes, and is used for adding, deleting and modifying the indexes.
The index data analysis module is used for performing index visual analysis, two-dimensional data mining report analysis and key index billboard analysis on the business indexes of each coal industry.
The index authority management module is used for dividing the hierarchical management authority corresponding to each coal industry service index for each user, wherein the hierarchical management authority corresponding to each coal industry service index comprises five levels of authority including authority for checking index information, authority for checking index data, authority for updating index, authority for authorizing index and authority for deleting index.
According to one embodiment of the application, the data management module further comprises a data quality assessment unit, a data management unit and a data storage unit, wherein: the data quality evaluation unit is used for performing quality evaluation on all acquired multi-source heterogeneous data of the coal mine; the data management unit is used for eliminating or modifying the data which does not accord with the specification after the quality evaluation; the data storage unit is used for recording a table pattern corresponding to the coal industry and generating a table structure of each theme table of the coal industry based on the table pattern.
According to one embodiment of the present application, the table paradigm includes a single/multi-metric real-time value record table, a single/multi-metric period cumulative value record table, an event record table, a geographic space type record table, a hierarchical relationship table, an associative relationship table, a static/quasi-static information table, wherein:
the single/multiple metric real-time value record table is used for recording the change data of the single/multiple metric attributes along with time.
The single/multiple metric period accumulated value record table is used for recording accumulated data of the single/multiple metric attributes in the time interval.
The event record table is used for recording event attributes and event occurrence time.
The geographical space type record table is used for recording geographical position identification and related attributes of each entity at each time stamp, such as a personnel positioning information table, a vehicle positioning information table and a device positioning information table.
The hierarchical relation type table is used for recording data with father-son relations, and comprises an organization hierarchical relation table, a personnel information hierarchical relation table, a device/sensor arrangement hierarchical relation table and the like.
The association relation type table is used for recording association relations among different entities.
The static/quasi-static information table is used for recording stable information in a preset time period, wherein the stable information is basically unchanged or slowly changed information.
According to one embodiment of the present application, an atomic index refers to a base index that is directly accessed from a data source; the derived index is an index generated after the atomic index is derived and reproduced in different dimensions; the composite index is an index generated by performing composite logic calculation of a plurality of indexes based on an atomic index, a curing index, a composite index or a derivative index; the curing index is an index generated after the data are subjected to curing statistics in the time dimension; the nominal index is a custom form index which does not contain data so as to meet the maintenance requirement of a user on the logic level relation of the complex index.
According to one embodiment of the application, each coal industry business index corresponds to an index unique ID, and each data source corresponds to a data source unique ID, wherein: the method comprises the steps that index related information corresponding to the coal industry business index and index calculation logic are stored in an A table of a coal industry business index system management system database; and storing the data source related information corresponding to the data source in a B table of a coal industry business index system management system database.
According to an embodiment of the application, the index data analysis module is further configured to generate a custom index analysis template corresponding to the user based on analysis mode selection of the user for index visualization analysis, two-dimensional data mining report analysis and key index billboard analysis.
According to one embodiment of the application, the coal industry business index system management system further comprises an index log module, an organization module, a system monitoring module and a system management module, wherein: the index log module is used for recording and managing access records of various indexes in the coal industry; the organization mechanism module is used for managing organization architecture information, role information, user information and post information of coal enterprises; the system monitoring module is used for monitoring the running state, system login information, access information and abnormal conditions of the whole index system management system; the system management module is used for providing overall management functions of the system, including a user management function, a configuration management function, a menu management function, a dictionary management function, a system interface configuration function and a data backup and recovery function.
According to one embodiment of the application, a data sharing interface of the coal industry business index system management system is connected with an external application.
According to one embodiment of the present application, the derived metrics and composite metrics support a low-code logical editing approach.
The application at least realizes the following beneficial effects: according to the coal industry business index system management system, on one hand, index management can be carried out globally, consistency of cross-system and cross-department index statistics caliber is guaranteed, organization is carried out in a hierarchical classification mode, systemization of index management is improved, on the other hand, after a data source is accessed, real-time checking of data can be achieved, different analysis modes such as a data chart and a report form are provided, an important supporting effect on accurate management and efficient decision making can be achieved, lasting maintenance of an index system can be achieved, an accessed data source is matched, latest index values of a current state are obtained at any time, running current situations such as enterprise production, safety and operation are rapidly mastered, and management and decision making are effectively assisted.
Drawings
The foregoing and/or additional aspects and advantages of the present application will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings, in which:
FIG. 1 is a schematic diagram of an exemplary manner in which a coal industry business index system management system is shown in accordance with one embodiment of the present application.
FIG. 2 is an exemplary diagram of a coal industry business metric system as illustrated in one embodiment of the present application.
FIG. 3 is a schematic diagram of an exemplary low-code logic editing scheme of a derived index, as shown in one embodiment of the present application.
FIG. 4 is a schematic diagram of an exemplary low-code logic editing mode of a composite index, as shown in one embodiment of the present application.
Detailed Description
Embodiments of the present application are described in detail below, examples of which are illustrated in the accompanying drawings, wherein the same or similar reference numerals refer to the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the drawings are exemplary and intended for the purpose of explaining the present application and are not to be construed as limiting the present application.
Fig. 1 is a schematic diagram of an exemplary manner of a coal industry business index system management system shown in the present application, as shown in fig. 1, where the coal industry business index system management system includes a data management module, an index system construction module, an index definition and maintenance module, an index data analysis module, and an index authority management module, where:
the data management module comprises a data acquisition unit, wherein the data acquisition unit is used for connecting a plurality of data sources corresponding to the coal mine so as to acquire multi-source heterogeneous data of the coal mine and support MySQL, clickHouse and other main stream common data sources.
The index system construction module is used for building a coal industry business index system based on the tree structure, wherein the coal industry business index system comprises a plurality of coal industry business indexes and association relations among the coal industry business indexes. Fig. 2 is an exemplary diagram of a coal industry business index system shown in the present application, where, as shown in fig. 2, the coal industry business index system is used to monitor a business development status, including indexes commonly used in the coal industry, and organized by a hierarchical structure, so that a cross-mine migration can be implemented, and by flexibly configuring a parent index of each index, the index architecture can be flexibly adjusted according to the actual situation of each coal mine.
The index definition and maintenance module is used for performing index definition and index maintenance, wherein the index definition refers to dividing business indexes of each coal industry into atomic indexes, derivative indexes, compound indexes, solidification indexes and nominal indexes, and the index maintenance comprises information such as Chinese and English name information, business theme domain information, return department information, statistics period information, measurement unit information, father level index information, calculation logic information, data source information, shared data interface information and the like of management indexes, and is used for adding, deleting and modifying the indexes.
The index data analysis module is used for carrying out index visual analysis, two-dimensional data mining report analysis and key index billboard analysis on the business indexes of each coal industry so as to rapidly realize data analysis, realize automatic update of data by means of the unified management function of the indexes, reduce data collection work and realize flexible and instant analysis.
The index authority management module is used for dividing the grading management authority corresponding to each coal industry service index for each user, wherein the grading management authority corresponding to each coal industry service index comprises five levels of authority including index information checking authority, index data checking authority, index updating authority, index authorizing authority and index deleting authority, so that grading authority management of each user and each index is realized, batch authorization can be carried out according to the subject domain, the return department or the departments and roles of the users of the indexes, and meanwhile, the system catalog can also configure visibility according to the user authority, so that different user visible catalog menus (super manager, index developer, index analyzer and the like) of different levels are realized.
According to the coal industry business index system management system, on one hand, index management can be carried out globally, consistency of cross-system and cross-department index statistics caliber is guaranteed, organization is carried out in a hierarchical classification mode, systemization of index management is improved, on the other hand, after a data source is accessed, real-time checking of data can be achieved, different analysis modes such as a data chart and a report form are provided, an important supporting effect on accurate management and efficient decision making can be achieved, lasting maintenance of an index system can be achieved, an accessed data source is matched, latest index values of a current state are obtained at any time, running current situations such as enterprise production, safety and operation are rapidly mastered, and management and decision making are effectively assisted.
The following is a supplementary description of each of the above modules:
the data management module further comprises a data quality evaluation unit, a data management unit and a data storage unit, wherein: the data quality evaluation unit is used for performing quality evaluation on all acquired multi-source heterogeneous data of the coal mine; the data management unit is used for eliminating or modifying the data which does not accord with the specification after the quality evaluation; the data storage unit is used for recording a table pattern corresponding to the coal industry and generating a table structure of each theme table of the coal industry based on the table pattern.
In the application, a set of data access specifications is formulated by referring to a typical data model and a storage structure of coal industry data, wherein a table paradigm comprises a single/multi-measurement real-time value record table, a single/multi-measurement period accumulated value record table, an event record table, a geographic space record table, a hierarchical relation table, an association relation table and a static/quasi-static information table, and the data access specifications comprise:
1. the single/multiple metric real-time value record table is used for recording the change data of the single/multiple metric attributes along with time. For example, real-time bin position information of a coal bin, voltage, current and other operation data of equipment, when such data are aggregated, the application of a summation function may not have business significance, and time columns are not necessarily equidistant.
Table 1 is an example of a single/multiple metric real-time value record table shown in this application, recording the change over time of single/multiple metric properties.
The dimension columns are feature descriptions or columns related to range limitation, such as mine names, coal bin numbers, zone names and the like, and derivative indexes can be generated through screening and aggregation according to the dimensions.
For example, the bin space of the coal bin, the numerical value of the bin space meter is a measurement value row, the bin number, the coal types and the like are dimension rows, the coal bin space can be screened according to the dimension of the bin number to generate derivative indexes of the bin space of the number 1, the bin space of the number 2 and the like, or the coal types are screened according to the dimension of the coal types, and then different derivative indexes of raw coal reserves, lump coal reserves, end coal reserves and the like are generated after certain aggregation calculation.
The measurement value sequence comprises a plurality of columns which can be determined according to specific conditions, for example, when the bin positions of the coal bins are monitored, a left bin position meter and a right bin position meter are usually installed in one coal bin, and the measurement value is 2 columns; for example, when coal quality monitoring is performed, different indexes such as total water, air drying base moisture, ash, volatile matters, total sulfur, high-level heating value, low-level heating value and the like are measured, and the measurement values can be in multiple columns; for another example, the washout information table may include only one column of the washout amount.
2. The single/multiple metric period accumulated value record table is used for recording accumulated data of the single/multiple metric attributes in the time interval.
Table 2 is an example of a single/multiple metric period cumulative value record table shown herein, recording the cumulative status of single/multiple metric attributes over a time interval, such as the yield of fills, footage data, railroad, highway sales data, etc., with time columns generally equally spaced.
3. The event record table is used for recording event attributes and event occurrence time.
Table 3 is an example of an event record table shown in the present application, and records events that occur at different times, such as inspection, investigation, etc. with intervention of a person, and each time, each attribute of an event that occurs at a certain time is recorded.
4. The geographical space type record table is used for recording geographical position identification and related attributes of each entity at each time stamp, and comprises a personnel positioning information table, a vehicle positioning information table, a device positioning information table and the like. The geographical space record table comprises a time column, one or more geographical position identification columns (with different identification modes, such as address character string identification, longitude and latitude identification or identification divided by region, etc.), a plurality of dimension columns and one or more measurement value columns.
5. The hierarchical relation type table is used for recording data with father-son relations, and comprises an organization hierarchical relation table, a personnel information hierarchical relation table, a device/sensor arrangement hierarchical relation table and the like, and comprises an identification column (name, device number and the like) of a minimum entity and each level of subordinate relation series.
6. The association relation type table is used for recording association relations among different entities, such as material receiving conditions (association relation between materials and departments), association conditions of security substations and personnel positioning cards in different areas (association relation between fixed substations and mobile personnel), and the like, and comprises a plurality of identification columns corresponding to each type of entity and a plurality of attribute columns representing the association relation.
7. The static/quasi-static information table is used for recording stable information within a preset time period. Such as mine basic information table, working face basic information table, roadway basic information table, mining connection schedule table, etc., stores some information which is basically unchanged or is changed very slowly. The static/quasi-static information table typically contains columns of entities (possibly one or more columns of identities of entities, such as face names, face IDs, etc.) and columns of attributes (such as recording design length of each face, successive faces, reserves, depth of cut, elevation of cut, coal mining process, zone of interest, etc.).
Further, the table structure of each topic table is formulated according to different table formats, the table structure is exemplified by a yield table, and table 4 is an example of a yield table shown in the present application.
In the above index definition and maintenance module, the atomic index refers to a basic index directly accessed from a data source, such as yield, footage, storage information, washing information, coal quality, equipment failure information, risk, hidden danger, three violations, alarm, sales, scheduling and the like, when the atomic index is connected, a corresponding data source needs to be selected, and by selecting the data source and the data table, the field name and the dimension attribute are configured in a personalized manner, so that the corresponding relationship between each field in the bottom data table and each dimension of the atomic index is constructed.
In the index definition and maintenance module, the derived index refers to an index generated after the atomic index is derived and multiplied in different dimensions, and by taking the yield as an example, a user can derive the yield index into two indexes of 'first coal mine yield' and 'second coal mine yield' in the mine dimension, so that the personalized customization of the index by the user is realized.
In the above-mentioned index definition and maintenance module, the composite index refers to an index generated by performing composite logic calculation of multiple indexes based on an atomic index, a curing index, a composite index or a derivative index, for example, a user can perform composite calculation on two indexes of "yield" and "energy consumption" through simple selection and dragging, so as to generate an index of "ton coal energy consumption".
In the above-mentioned index definition and maintenance module, the curing index refers to an index generated after the curing statistics is performed on the atomic index or the derivative index or the composite index in the time dimension, so that the operations of curing dimension screening, data grouping, aggregation and the like can be realized, after the curing index is defined, the system can establish a periodic scheduling task, and the calculation and automatic curing of the index are performed according to a set time period so as to meet the requirement of users on periodic data statistics, and still taking the yield as an example, the curing indexes such as "daily yield", "monthly yield", "annual yield" and the like can be rapidly generated by curing the yield index.
In the above-mentioned index definition and maintenance module, the nominal index refers to a custom form index that does not include data, so as to meet the maintenance requirement of the user on the complex index logic hierarchy relationship, for example, the user may create a nominal index named "production", and collect the created "yield" index under the "production" index, so as to form a reasonable tree structure.
In the system for managing the coal industry business index system, the derived index and the composite index support a low-code logic editing mode, namely an editor is provided for the derived index and the composite index, and the sql logic is coded low. FIG. 3 is a schematic diagram of an exemplary low-code logic editing manner of a derived index, as shown in FIG. 3, where a user may derive and spawn atomic indexes in different dimensions through low-code editing, and may logically combine the atomic indexes to support changing priorities through brackets; FIG. 4 is a schematic diagram of an exemplary low-code logical editing scheme of a composite index as shown in FIG. 4, where a user may perform multiple index composite logical calculations on an atomic index, a cure index, a composite index, or a derivative index via low-code editing.
According to the coal industry business index system management system, several common table structures are summarized according to common data table conditions of coal industry data, an operation flow is designed according to a common analysis flow, the system is more suitable for industrial production data, the deriving and compound operation modes of indexes are more in line with industrial characteristics, calculating logics (deriving logics, compound logics and the like) of industry indexes are precipitated in the system, when new mines are applied, data sources are configured according to access specifications, most of common indexes can be directly used, redefinition is not needed, and each mine is supplemented with personalized indexes according to actual conditions.
Further, in the coal industry business index system management system provided by the application, each coal industry business index corresponds to an index unique ID, each data source corresponds to a data source unique ID, the data source used in index calculation is determined through the corresponding relation between the index unique ID and the data source unique ID, and index related information corresponding to the coal industry business index and index calculation logic are stored in an A table of a coal industry business index system management system database; and storing the data source related information corresponding to the data source in a B table of a coal industry business index system management system database. When the mining migration is performed, each piece of connection information corresponding to the unique ID of the data source in the data source B table is replaced, the relevant solidification index scheduling task of the data source is updated, and the calculation logic of the index is stored in the A table without modification, so that the separation of the calculation logic and physical storage of the index is realized.
In the index data analysis module, the index visual analysis refers to that after single or multiple indexes are checked in an index tree, charts such as a line chart, a bar chart, a pie chart, a scatter chart, a data detail table and the like can be quickly generated, and functions such as conversion of chart forms, time range selection, comparison of multiple indexes, chart derivation, addition of explanatory characters for the charts, direct derivation of analysis reports and the like can be realized through simple configuration.
In the index data analysis module, the two-dimensional data mining report analysis refers to multi-dimensional joint analysis aiming at single indexes, a two-dimensional report form is adopted, the transverse and vertical axis dimensions of the report are configured (for example, for yield, the transverse axis dimension selects a time dimension, the vertical axis dimension selects a coal mining team name dimension, the production conditions of different coal mining teams in different time periods can be analyzed), and the transverse axis and the vertical axis can carry out various data aggregation (support of different aggregation logics such as summation, average, median, maximum, minimum, count and the like).
In the index data analysis module, the key index billboard analysis refers to rapid checking and comparison analysis of a plurality of indexes at the same time point, and adopts a key index billboard form, so that the plurality of indexes can be flexibly selected, the dimension of each index and the position relation of each index on the billboard are configured, the data billboard is rapidly configured, and the index data of each key node is checked by switching the billboard time.
Further, the index data analysis module is further used for generating a user-defined index analysis template corresponding to the user based on the analysis mode selection of the user on the index visualization analysis, the two-dimensional data mining report analysis and the key index signboard analysis, so as to select different index combinations concerned by the user according to different post roles, and precipitating the common analysis flow as the index analysis template for multiplexing. The index analysis template can enable a user to store the most concerned index combination or the most commonly used index change analysis chart, after one-time configuration, analysis of different periods can be realized only by adjusting time points or time intervals, the periodic report can be replaced by compiling work, different templates can be stored according to different analysis requirements of the user, and a key index report form facing a superior management department, a butt joint index communication form facing a parallel cooperation department, an operation index analysis form facing an operator of the department and the like can be rapidly manufactured. In addition, the user can be provided with a personalized homepage function, the data in the homepage is updated in real time, and the indexes focused by different users can be continuously tracked.
Furthermore, the index data analysis module also provides a plurality of predictive early warning and anomaly monitoring algorithm modules, and supports the further analysis of professional analysts.
The index authority management module realizes fine-grained authority management, and 'check index information authority' can only see the index in an enterprise, can see the basic information of the index, and cannot check specific data of the index; the 'check index data authority' can see specific data conditions, can apply a check interface carried by a tool to screen data, can acquire an interface address of the data, each user has a token of the user, can authenticate the data interface according to the token, and can form an access log of the index according to the authentication; the "update index authority" may update information of an index or modify calculation logic of the index, the "index authority" may authorize the index to other users in the system, the deletion authority may not be authorized except for super administrators and administrators, and the "delete index authority" may delete (soft delete, recoverable from a recycle bin) the index.
Further, the coal industry business index system management system further comprises an index log module, an organization module, a system monitoring module and a system management module, wherein:
and the index log module is used for recording and managing access records of various indexes in the coal industry.
The organization module is used for managing organization architecture information, role information, user information and post information of coal enterprises.
The system monitoring module is used for monitoring the running state, system login information, access information and abnormal conditions of the whole index system management system.
The system management module is used for providing overall management functions of the system, including a user management function, a configuration management function, a menu management function, a dictionary management function, a system interface configuration function and a data backup and recovery function.
Furthermore, the data sharing interface of the coal industry business index system management system can be connected with external applications so as to ensure the consistency of the same index in different applications.
The coal industry business index system management system provided by the application can be used by business analysts, management personnel and implementation personnel of various digital projects in coal mine enterprises, and index calculation logic of a mine general basic index system is deposited in the coal industry business index system management system provided by the application, so that access specifications are met only when cross-mine deployment is carried out, and the calculation logic of a basic index is not required to be redefined.
For data analysts of coal mine enterprises, the system can help the data analysts to flexibly construct customized data charts according to requirements, quickly access and define various index data, and can realize automatic calculation and statistics of indexes, thereby reducing repeated work of homogenization and improving work efficiency; meanwhile, through the data chart and report analysis function provided by the system, data analysts can analyze the data conditions more quickly, flexibly and intuitively.
For the manager of coal mine enterprises, the system can quickly master the production and operation conditions of each department of the coal enterprises, and ensure the consistency of cross-system and cross-department index statistical apertures, so that the decision is more accurate and reliable.
For operators of various digital projects of coal mine enterprises, the system can provide a unified index data interface, support persistent index maintenance and management, effectively assist the reliable implementation of the digital projects, reduce the repeated work of homogenization and improve the working efficiency.
Furthermore, the coal industry business index system management system adapts to the characteristics of the coal industry by internally arranging the coal industry index system, index calculation logic, data analysis templates and the like, can support the cross-mine migration, supports the customization and analysis view angle based on the data analysis templates, and achieves better industry supporting capability.
Based on the coal industry business index system management system provided by the application, a coal industry business index system management tool can be generated, and the system comprises a software system with a management function and a built-in coal industry business index system management system. The component can be used as an independent product, can also be used as a component of an industrial Internet platform, and is communicated with upstream components such as data access, service libraries and the like, and downstream components such as a management and control platform, industrial application and the like.
In the description of the present application, it should be understood that the terms "center," "longitudinal," "transverse," "length," "width," "thickness," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," "clockwise," "counterclockwise," "axial," "radial," "circumferential," etc. indicate orientations or positional relationships based on the orientations or positional relationships illustrated in the drawings, are merely for convenience in describing the present application and simplifying the description, and do not indicate or imply that the device or element being referred to must have a particular orientation, be configured and operated in a particular orientation, and therefore should not be construed as limiting the present application.
Furthermore, the terms "first," "second," and the like, are used for descriptive purposes only and are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include one or more such feature. In the description of the present application, the meaning of "a plurality" is two or more, unless explicitly defined otherwise.
In the description of the present specification, a description referring to terms "one embodiment," "some embodiments," "examples," "specific examples," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present application. In this specification, schematic representations of the above terms are not necessarily directed to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, the different embodiments or examples described in this specification and the features of the different embodiments or examples may be combined and combined by those skilled in the art without contradiction.
Although embodiments of the present application have been shown and described above, it will be understood that the above embodiments are illustrative and not to be construed as limiting the application, and that variations, modifications, alternatives, and variations may be made to the above embodiments by one of ordinary skill in the art within the scope of the application.
Claims (9)
1. The system for managing the business index system in the coal industry is characterized by comprising a data management module, an index system construction module, an index definition and maintenance module, an index data analysis module and an index authority management module, wherein:
the data management module comprises a data acquisition unit, wherein the data acquisition unit is used for connecting a plurality of data sources corresponding to a coal mine so as to acquire multi-source heterogeneous data of the coal mine;
the index system construction module is used for building a coal industry business index system based on a tree structure, and the coal industry business index system comprises a plurality of coal industry business indexes and association relations among the coal industry business indexes;
the index definition and maintenance module is used for performing index definition and index maintenance, wherein the index definition refers to dividing service indexes of each coal industry into atomic indexes, derivative indexes, compound indexes, curing indexes and nominal indexes, and the index maintenance comprises Chinese and English name information, service theme domain information, return department information, statistics period information, measurement unit information, father-level index information, calculation logic information, data source information and shared data interface information of the management indexes, and is used for adding, deleting and modifying the indexes;
the index data analysis module is used for performing index visual analysis, two-dimensional data mining report analysis and key index billboard analysis on the business indexes of each coal industry;
the index authority management module is used for dividing the hierarchical management authority corresponding to each coal industry service index for each user, wherein the hierarchical management authority corresponding to each coal industry service index comprises five levels of authority including index information checking authority, index data checking authority, index updating authority, index authority, and index deleting authority.
2. The coal industry business index system management system of claim 1, wherein the data management module further comprises a data quality assessment unit, a data management unit, and a data storage unit, wherein:
the data quality evaluation unit is used for performing quality evaluation on all acquired multi-source heterogeneous data of the coal mine;
the data management unit is used for eliminating or modifying the data which does not accord with the specification after the quality evaluation;
the data storage unit is used for recording a table paradigm corresponding to the coal industry and generating a table structure of each theme table of the coal industry based on the table paradigm.
3. The coal industry business index system management system of claim 2, wherein the table paradigm comprises a single/multi-metric real-time value record table, a single/multi-metric period accumulated value record table, an event record table, a geographic space record table, a hierarchical relationship table, an association relationship table, a static/quasi-static information table, wherein:
the single/multi-metric real-time value record table is used for recording the change data of the single/multi-metric attribute along with time;
the single/multi-measurement period accumulated value recording table is used for recording accumulated data of single/multiple measurement attributes in a time interval;
the event record table is used for recording event attributes and event occurrence time;
the geographical space type record table is used for recording geographical position identifiers and related attributes of each entity at each time stamp, and comprises a personnel positioning information table, a vehicle positioning information table and a device positioning information table;
the hierarchy relation table is used for recording data with father-son relations, and comprises an organization hierarchy relation table, a personnel information hierarchy relation table and a device/sensor arrangement hierarchy relation table;
the association relation type table is used for recording association relations among different entities;
the static/quasi-static information table is used for recording stable information in a preset time period.
4. The coal industry business index system management system of claim 3, wherein:
the atomic index refers to a basic index directly accessed from a data source;
the derived index refers to an index generated after the atomic index is derived and reproduced in different dimensions;
the composite index is an index generated by performing composite logic calculation on a plurality of indexes based on an atomic index, a curing index, a composite index or a derivative index;
the solidification index is an index generated after solidification statistics is carried out on the data in the time dimension;
the nominal index is a custom form index which does not contain data so as to meet the maintenance requirement of a user on the logic level relation of the complex index.
5. The coal industry business index system management system of claim 4, wherein each of the coal industry business indexes corresponds to an index unique ID, each of the data sources corresponds to a data source unique ID, wherein:
the index related information corresponding to the coal industry business index and the index calculation logic are stored in an A table of a coal industry business index system management system database;
and the data source related information corresponding to the data source is stored in a B table of a coal industry business index system management system database.
6. The system for managing a coal industry business index system according to claim 5, wherein the index data analysis module is further configured to generate a custom index analysis template corresponding to a user based on analysis mode selection of the user for index visualization analysis, two-dimensional data mining report analysis and key index billboard analysis.
7. The coal industry business index system management system of claim 6, further comprising an index log module, an organization module, a system monitoring module, and a system management module, wherein:
the index log module is used for recording and managing access records of various indexes in the coal industry;
the organization mechanism module is used for managing organization architecture information, role information, user information and post information of coal enterprises;
the system monitoring module is used for monitoring the running state, system login information, access information and abnormal conditions of the whole index system management system;
the system management module is used for providing overall management functions of the system, including a user management function, a configuration management function, a menu management function, a dictionary management function, a system interface configuration function and a data backup and recovery function.
8. The coal industry business index system management system of claim 7, wherein the data sharing interface of the coal industry business index system management system is connected with an external application.
9. The coal industry business index system management system of claim 7, wherein the derived index and the composite index support a low-code logical editing mode.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410140892.9A CN117670148B (en) | 2024-02-01 | 2024-02-01 | Management system for business index system in coal industry |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410140892.9A CN117670148B (en) | 2024-02-01 | 2024-02-01 | Management system for business index system in coal industry |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117670148A true CN117670148A (en) | 2024-03-08 |
| CN117670148B CN117670148B (en) | 2024-05-14 |
Family
ID=90073523
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410140892.9A Active CN117670148B (en) | 2024-02-01 | 2024-02-01 | Management system for business index system in coal industry |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117670148B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8639650B1 (en) * | 2003-06-25 | 2014-01-28 | Susan Pierpoint Gill | Profile-responsive system for information exchange in human- and device-adaptive query-response networks for task and crowd management, distributed collaboration and data integration |
| CN107945047A (en) * | 2017-10-26 | 2018-04-20 | 中国南方电网有限责任公司 | A kind of visual configuration system for the automatic recursive calculation of index for being used to dispatch daily paper |
| CN109582712A (en) * | 2018-11-29 | 2019-04-05 | 陕西陕煤铜川矿业有限公司 | Goods and materials managing and control system |
| CN109840718A (en) * | 2019-02-28 | 2019-06-04 | 东北大学 | A kind of production target Visualized Monitoring System and method based on configuration |
| WO2022012285A1 (en) * | 2020-07-16 | 2022-01-20 | 中国能源建设集团湖南省电力设计院有限公司 | Multi-source integrated multi-platform energy information management system |
| CN116383198A (en) * | 2023-03-03 | 2023-07-04 | 天元大数据信用管理有限公司 | Decision analysis method and system based on big data |
-
2024
- 2024-02-01 CN CN202410140892.9A patent/CN117670148B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8639650B1 (en) * | 2003-06-25 | 2014-01-28 | Susan Pierpoint Gill | Profile-responsive system for information exchange in human- and device-adaptive query-response networks for task and crowd management, distributed collaboration and data integration |
| CN107945047A (en) * | 2017-10-26 | 2018-04-20 | 中国南方电网有限责任公司 | A kind of visual configuration system for the automatic recursive calculation of index for being used to dispatch daily paper |
| CN109582712A (en) * | 2018-11-29 | 2019-04-05 | 陕西陕煤铜川矿业有限公司 | Goods and materials managing and control system |
| CN109840718A (en) * | 2019-02-28 | 2019-06-04 | 东北大学 | A kind of production target Visualized Monitoring System and method based on configuration |
| WO2022012285A1 (en) * | 2020-07-16 | 2022-01-20 | 中国能源建设集团湖南省电力设计院有限公司 | Multi-source integrated multi-platform energy information management system |
| CN116383198A (en) * | 2023-03-03 | 2023-07-04 | 天元大数据信用管理有限公司 | Decision analysis method and system based on big data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117670148B (en) | 2024-05-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110147948B (en) | Coal mine enterprise risk identification management and control platform and implementation method thereof | |
| CN112396404A (en) | Data center system | |
| US6519763B1 (en) | Time management and task completion and prediction software | |
| CN112163724A (en) | Environment information data resource integration system | |
| CN105868373B (en) | Method and device for processing key data of power business information system | |
| CN113179173A (en) | Operation and maintenance monitoring system for highway system | |
| CN113723822A (en) | Power supply service data management system | |
| Nagabhushana | Data warehousing OLAP and data mining | |
| CN115730900A (en) | Project data processing method and device, computer equipment and storage medium | |
| CN115358522A (en) | Enterprise online monitoring system and method | |
| CN117670148B (en) | Management system for business index system in coal industry | |
| CN110264150A (en) | Distributed construction point progress control method and management platform based on GIS-Geographic Information System | |
| CN114118696A (en) | Transportation index management system based on space dimensionality | |
| CN115526526A (en) | Mountain tunnel construction safety risk management method based on space-time model | |
| Tytenko et al. | Software and information support for business analysis in enterprise management | |
| CN112784129A (en) | Pump station equipment operation and maintenance data supervision platform | |
| CN110502219B (en) | Enterprise-level IT architecture asset management system and method | |
| Ahmad et al. | Bringing excellence in asset management through Streamlined Automated Reporting & KPI tracking System | |
| Huang et al. | The production management system of mining group based on business intelligence | |
| CN112883013B (en) | Urban atmospheric pollution source emission list consistency auditing system | |
| CN118096052A (en) | Basic data management system for coal mine production | |
| Ouschan et al. | Digital Documentation-and Data Management for Grouting Measures | |
| Kim et al. | A study on facility maintenance information composition and sophisticated technology utilization measures | |
| CN115034941A (en) | Map-based asset management method and system | |
| Rakhmangulov et al. | Expand Excellence: Business Intelligence Tools for Drilling Data Analysis as Enhanced Efficiency Approach |
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 |