CN116842255A - Accident data management method, visualization system and display method based on metallurgical industry - Google Patents
Accident data management method, visualization system and display method based on metallurgical industry Download PDFInfo
- Publication number
- CN116842255A CN116842255A CN202310769997.6A CN202310769997A CN116842255A CN 116842255 A CN116842255 A CN 116842255A CN 202310769997 A CN202310769997 A CN 202310769997A CN 116842255 A CN116842255 A CN 116842255A
- Authority
- CN
- China
- Prior art keywords
- accident
- data
- metallurgical
- chart
- attribute
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 82
- 238000013523 data management Methods 0.000 title claims abstract description 17
- 238000012800 visualization Methods 0.000 title claims abstract description 10
- 208000027418 Wounds and injury Diseases 0.000 claims abstract description 74
- 230000006378 damage Effects 0.000 claims abstract description 73
- 208000014674 injury Diseases 0.000 claims abstract description 73
- 238000004140 cleaning Methods 0.000 claims abstract description 36
- 238000004458 analytical method Methods 0.000 claims description 30
- 238000012216 screening Methods 0.000 claims description 28
- 230000000007 visual effect Effects 0.000 claims description 23
- 238000007405 data analysis Methods 0.000 claims description 18
- 238000009826 distribution Methods 0.000 claims description 14
- 239000000126 substance Substances 0.000 claims description 8
- 238000009877 rendering Methods 0.000 claims description 7
- 238000010310 metallurgical process Methods 0.000 claims description 4
- 241000894007 species Species 0.000 claims description 3
- 241000607479 Yersinia pestis Species 0.000 claims description 2
- 238000011049 filling Methods 0.000 claims description 2
- 238000007726 management method Methods 0.000 abstract description 16
- 230000003993 interaction Effects 0.000 abstract description 5
- 238000004519 manufacturing process Methods 0.000 description 42
- 238000010586 diagram Methods 0.000 description 12
- 238000013461 design Methods 0.000 description 7
- XEEYBQQBJWHFJM-UHFFFAOYSA-N Iron Chemical compound [Fe] XEEYBQQBJWHFJM-UHFFFAOYSA-N 0.000 description 6
- 238000007619 statistical method Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 5
- 238000005098 hot rolling Methods 0.000 description 5
- ODINCKMPIJJUCX-UHFFFAOYSA-N Calcium oxide Chemical compound [Ca]=O ODINCKMPIJJUCX-UHFFFAOYSA-N 0.000 description 4
- 229910000831 Steel Inorganic materials 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000003068 static effect Effects 0.000 description 4
- 239000010959 steel Substances 0.000 description 4
- 238000009628 steelmaking Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 229910052742 iron Inorganic materials 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 208000012260 Accidental injury Diseases 0.000 description 2
- QVGXLLKOCUKJST-UHFFFAOYSA-N atomic oxygen Chemical compound [O] QVGXLLKOCUKJST-UHFFFAOYSA-N 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 2
- 235000012255 calcium oxide Nutrition 0.000 description 2
- 239000000292 calcium oxide Substances 0.000 description 2
- 238000004939 coking Methods 0.000 description 2
- 239000003086 colorant Substances 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000005611 electricity Effects 0.000 description 2
- 238000011065 in-situ storage Methods 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 229910052760 oxygen Inorganic materials 0.000 description 2
- 239000001301 oxygen Substances 0.000 description 2
- 239000008188 pellet Substances 0.000 description 2
- 238000007781 pre-processing Methods 0.000 description 2
- 238000004064 recycling Methods 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 238000005096 rolling process Methods 0.000 description 2
- 238000005245 sintering Methods 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 230000003044 adaptive effect Effects 0.000 description 1
- 238000013475 authorization Methods 0.000 description 1
- 238000009960 carding Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000012824 chemical production Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000013079 data visualisation Methods 0.000 description 1
- 230000002939 deleterious effect Effects 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 238000004141 dimensional analysis Methods 0.000 description 1
- 238000004880 explosion Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 238000011068 loading method Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000005272 metallurgy Methods 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 231100000572 poisoning Toxicity 0.000 description 1
- 230000000607 poisoning effect Effects 0.000 description 1
- 238000005381 potential energy Methods 0.000 description 1
- 230000002265 prevention Effects 0.000 description 1
- 238000005215 recombination Methods 0.000 description 1
- 230000006798 recombination Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000000547 structure data Methods 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
- 231100000331 toxic Toxicity 0.000 description 1
- 230000002588 toxic effect Effects 0.000 description 1
- 238000012549 training Methods 0.000 description 1
- 230000000472 traumatic effect Effects 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/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9535—Search customisation based on user profiles and personalisation
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/243—Natural language query formulation
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0635—Risk analysis of enterprise or organisation activities
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Mathematical Physics (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Software Systems (AREA)
- Operations Research (AREA)
- Computational Linguistics (AREA)
- Artificial Intelligence (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an accident data management method, a visualization system and a display method based on the metallurgical industry. Step 1: constructing a generalized word data table of keywords to which the accident key information of the metallurgical industry belongs; step 2: scene keywords are extracted from accident reporting cases and Internet public metallurgical accident cases, and accident cases of key information are collected and stored in a collection database; step 3: extracting the collected accident cases according to the accident information keywords, and storing the accident cases in a collection database; step 4: cleaning accident cases in the acquisition database, and storing the accident cases in a cleaning database; step 5: and taking the keywords affiliated to the labels affiliated to the accident information keywords and the injury personnel keywords as attribute information of the accident cases and storing the attribute information in a cleaning database. According to the combination of the data attributes, the metallurgical accident case is subjected to omnibearing management, display and calling by display, interaction and reporting.
Description
Technical Field
The invention belongs to the technical field of safety production, and particularly relates to an accident data management method, a visualization system and a display method based on the metallurgical industry.
Background
From the statistical data of safety production accidents, various explosion, fire and poisoning accidents occur in the metallurgical industry, and the metallurgical industry has important dangerous factors caused by high kinetic energy, high potential energy and high heat energy determined by production process conditions, toxic and harmful substances common to chemical production and mechanical injury accidents common to the general mechanical industry.
However, related work of accident data analysis in the metallurgical industry is few, systematic carding is not performed, big data analysis is not performed, and the traditional accident management has the following defects:
(1) The enterprise accident management is focused on empirical management, and is less managed by adopting a system analysis mode; (2) Enterprises rarely establish a standard accident database, and the accident information is difficult to carry out rapid statistical analysis; (3) Most enterprises perform certain explanation and description on the position of the accident in the accident file, but less retrospectively locate the production procedure of the accident, the generated safety production accident cannot be associated with various dimensions such as time, space and the like, and therefore, comprehensive analysis cannot be realized, visual analysis on the distribution condition of the safety production accident in a large scale range is difficult, and more comprehensive data support is difficult to be provided for management of government authorities.
Disclosure of Invention
The invention aims to provide an accident data management display method and a visual system based on the metallurgical industry, aiming at the defects of the prior art, which are used for solving the problems that accident information statistics in the steel industry in the prior art is independent, information collection is incomplete, the statistical method is not standard, and key information statistics such as accident attributes, injury personnel attributes and the like are not standard; the accident information is low in utilization efficiency.
The technical scheme of the invention is as follows: a first aspect of the present invention provides an accident data management method based on metallurgical industry, comprising the steps of:
step 1: establishing a generalized word data table of keywords to which the accident key information belongs in the metallurgical industry, associating and storing the generalized word data table as an auxiliary label of the keywords to which the accident key information belongs with the keywords, and simultaneously using the auxiliary label of the keywords to which the accident key information belongs as the keywords for judging the attribute of the accident key information;
step 2: extracting scene keywords from accident reporting cases and Internet public metallurgical accident cases, determining metallurgical accident key information and injury personnel key information according to the scene keywords, collecting accident cases with partial corresponding key information from the accident reporting cases and Internet public metallurgical accident cases, and storing the accident cases in a collection database;
Step 3: the collected accident cases stored in the collection database are extracted according to accident information keywords and injury personnel keywords, and are stored in the collection database as attribute information of the accident cases;
step 4: based on the key words of the accident key information and the key information of the injury personnel, cleaning the accident cases stored in the acquisition database, and storing the accident cases in a cleaning database;
step 5: based on the accident key information and the key words to which the injury personnel key information belongs, cleaning the accident cases stored in the acquisition database, and meanwhile, taking the key words to which the labels to which the accident information key words and the injury personnel key words belong as attribute information of the accident cases to be stored in the cleaning database.
The attribute of the accident key information comprises: accident occurrence time, administrative areas, key procedures, accident types, causative objects and responsible bodies; wherein the attribute of the injury personnel key information comprises: age, type, injury site, nature of injury, pest, accident category, and injury degree.
And (2) the generalized word data table in the step (1) is used as an affiliated tag of a keyword to which the injury personnel key information belongs to be associated with the keyword for storage, and meanwhile, the affiliated tag of the keyword to which the injury personnel key information belongs is used as the keyword for judging the attribute of the injury personnel key information.
A second aspect of the present invention provides a visualization system for a metallurgical industry based incident data management method, comprising:
the data acquisition module is used for acquiring accident reporting cases and Internet public metallurgical accident cases and comprises enterprise uploading accident case data;
the data cleaning module is used for screening effective accident case data and formatting data information of standardized metallurgical accident cases;
the data analysis module is used for carrying out comparison analysis on various attributes of the accident case information and creating a chart;
the data display module is used for carrying out batch display and multi-condition screening display on accident case information, forming a big data billboard, visually and intuitively knowing accident case information, the distribution of metallurgical accidents and injurors in time, the distribution in working procedures and the regional distribution, and the distribution conditions of different dimensions of the responsible objects, responsible bodies, personnel working ages, working species, injuring parts, injuring properties, injures, accident types and injuring degrees according to the accident types;
the report deriving module is used for carrying out automatic homonymy and girth analysis on the accident occurrence time, administrative areas, key procedures, accident types, causative objects, responsible bodies, personnel working ages, working types, injury parts, injury properties, harmful substances and accident types related to the accident case information through the accident key conditions, and the injury degree is analyzed according to the annual, quarternary, monthly and other reports to form an effective metallurgical accident report.
The data acquisition module adopts a mode of simulating manual reading by reading web and api to acquire accident cases, and adopts the keyword rules of accident occurrence time, administrative areas, key procedures, accident categories, causative objects, responsible bodies, personnel working ages, working species, injury parts, injury properties, injury causing substances, accident categories and injury degree related to the accident key conditions in claim 1 to clean data.
The data acquisition module and the data cleaning module acquire data, the cleaned data and the formal data are stored by adopting a separate database, and the cleaned data is added into the manual auditing module before being compiled into the formal data.
The data analysis module comprises a foreground logic controller, a background logic controller and a background database, a custom data view of the cleaned formal data is obtained through an api interface, and according to data fields, the custom data view is embedded into an echartits chart library and a threejs three-dimensional engine, and attribute data of a chart component are created in a multi-dimensional manner and stored in the background database; performing grid layout by using a vuejs script and the web, combining and nesting attribute data of the chart component into attribute data of a large-screen layout of the visual large data, and simultaneously storing the large-screen layout and the attribute data of the chart component in a background database; the configuration/setting API of the chart attribute and the layout attribute is output through the background logic controller.
And the data display module loads display data in a large screen, and performs unified rendering on the data by combining the echarties chart component and the threjs component.
The embedded echartists chart library and threejs three-dimensional engine creates attribute data of a chart component in a multi-dimension manner, and the embedded echartists chart library and threejs three-dimensional engine further comprises:
the three-dimensional chart shows that the threejs three-dimensional engine is integrated into the echorts, the unified data dimension configuration mode of the echorts chart is continued, the configuration realization operation modes of the three-dimensional chart type and the table type are unified, and other different chart types are unified: the data formats of the pie charts, the bar charts, the line charts and the bar charts are combined, the ring charts, the instrument panel, the humanoid charts, the metallurgical process charts and the administrative region charts are converted, and the configuration realization operation modes of different chart types and table types are unified by adopting the same data dimension configuration mode.
The third aspect of the invention provides an accident data display method based on metallurgical industry, which comprises the following steps:
step 1: view query is carried out on the content of the formal accident database after cleaning, and the attribute keywords of the accident key information and the attribute keywords of the injury personnel key information are output and contain the attribute values associated with the keywords;
Step 2: selecting a chart type, drag-putting a keyword of a dimension to be displayed into a dimension column, selecting an attribute value type of the keyword, drag-putting a keyword of a value to be displayed into a value column, and selecting the attribute value type of the keyword;
step 3: adding screening conditions, filling names and descriptions, and storing the set charts and data attributes into a background database;
step 4: creating a large-screen layout, adding a plurality of stored chart components into the layout, carrying out layout adjustment by dragging, and storing chart attributes and setting data together with the large-screen layout data into a background database;
step 5: the large screen display page acquires data and sets a rendering data layout and a chart through display data api;
the large-screen display page is provided with screening conditions, after the screening conditions are selected, parameters of the screening conditions are directly transmitted into the foreground logic controller through display data api, and the large-screen display page acquires data which are recombined after screening the screening conditions through the display data api, and sets a rendering data layout and a chart.
The invention uses a metallurgical accident collection tool, adopts attribute keywords and accessory tags (generalized words) of accident case information and injury personnel information to extract matching keywords from accident reporting cases and Internet public metallurgical accident cases, and judges effective metallurgical accident case information;
Acquiring accident reporting cases, internet disclosed metallurgical accident cases and manually inputting the accident reporting cases through enterprises, and storing the accident reporting cases and the Internet disclosed metallurgical accident cases in an acquisition database;
extracting the key words of the collected metallurgical accident cases, formatting the metallurgical accident case attributes, and storing the metallurgical accident case attributes and the metallurgical accident case attributes in a cleaning database;
according to the formatted accident case attribute, perfecting the information of the metallurgical case attribute through an auditing function, and storing the information in a formal accident database;
and carrying out omnibearing management, display and calling on the metallurgical accident case according to the combination of the data attributes, the display, the interaction and the report.
The accident data display adopts the data view output of formatted data and is used for multi-dimensional multi-numerical comparison of chart display; drag type combinations with different dimensions and different values are intuitively used for creating and comparing a data chart; the visual big data billboard of arbitrary combination is according to user's demand self-defined drag overall arrangement, reduces the use threshold and increases the flexibility of data show, no longer is the permanent fixed view, improves metallurgical industry accident case information display ability greatly.
The beneficial technical effects of the invention are as follows: according to the combination of the data attributes, the metallurgical accident case is subjected to omnibearing management, display and calling by display, interaction and report; has positive significance for customizing enterprise safety management strategies, reducing production safety accidents, safety management training and the like.
Drawings
FIG. 1 is a diagram of an accident data management method, visualization system, display method logic architecture based on the metallurgical industry.
Detailed Description
Other advantages and functions of the present application will become readily apparent to those skilled in the art of metallurgy and data analysis from the teachings herein, by reference to the specific examples that follow.
The application may be practiced or carried out in other embodiments, and details in this description may be modified or varied from various points of view and applications without departing from the spirit of the application, it being understood that the following examples and features of the examples may be combined with each other without conflict.
1. Accident data management method implementation mode based on metallurgical industry.
Extracting matching keywords from accident reporting cases and Internet public metallurgical accident cases by using a metallurgical accident acquisition tool and adopting attribute keywords and accessory tags (generalized words) of accident case information and injury personnel information, and judging effective metallurgical accident case information; comprising the following steps: editing an accident collection tool keyword library, normalizing keywords by attribute key information related to all metallurgical accident cases, and adding generalized word labels.
TABLE 1 generalized word tag schematic
。
Obtaining accident reporting cases, internet public metallurgical accident cases and manually inputting the accident reporting cases through enterprises, and storing the accident reporting cases and the internet public metallurgical accident cases in an acquisition database, wherein the method comprises the following steps of: downloading effective metallurgical accident case contents through a metallurgical accident acquisition tool, automatically recording source addresses or information, and storing the source addresses or information, the metallurgical accident case contents and keywords in an acquisition database in an associated manner; the accident cases can be stored in batches to the acquisition database in a manual input mode.
Extracting the key words of the collected metallurgical accident cases, formatting the metallurgical accident case attributes, and storing the metallurgical accident case attributes and the metallurgical accident case attributes in a cleaning database, wherein the method comprises the following steps of: the cleaning tool automatically compares preset metallurgical accident case information, attribute keywords of injury personnel information and auxiliary labels (generalized words) with the metallurgical accident case information in the collection database, extracts the metallurgical accident case information keywords or labels with a plurality of attribute keywords and auxiliary labels, automatically standardizes the labels into corresponding attribute keywords, and stores the corresponding attribute keywords and the metallurgical accident case information in the cleaning database.
According to the formatted accident case attribute, perfecting the information of the metallurgical case attribute through an auditing function, storing the information in a formal accident database, and comprising: editing data content and attribute keywords (directly selecting through an attribute keyword list) can be carried out in the draft library of the accident database by transferring the data of the cleaning library, and the keyword information can be perfected through editing, secondary checking is carried out through an auditing function, and the auditing is stored in the formal accident database.
According to the combination of data attributes, the metallurgical accident case is subjected to omnibearing management, display and calling by display, interaction and report, and the method comprises the following steps: presetting a data query view in a database, and recombining the data query in the database according to attribute keyword information; the graph component save can be managed by combining and comparing attributes in the query view.
2. Accident big data visualization system based on metallurgical industry.
A data acquisition module comprising: the accident dictionary can be used for inputting metallurgical accident attributes (such as accident working conditions) and keywords (such as traffic transportation), can be used for inputting generalized word labels (such as on-duty roads, factory roads and the like) under the keyword attributes, and can be used for defining keyword colors (chart colors for globally unifying the same fields in data chart display); and the task management can create a plurality of acquisition tasks, and each task can independently input rules such as directory addresses, analysis types, character string positioning and the like in the web site.
A data cleansing module comprising: creating a cleaning rule, inputting data, matching front and rear characters, matching metallurgical accident attributes in an accident dictionary, automatically matching keywords and generalized words in the accident attributes by a system, comparing the keywords and generalized words with metallurgical accident case information in a collection database, screening out effective metallurgical accident cases conforming to the rule, and storing the effective metallurgical accident cases, the corresponding attributes and the keywords in the cleaning database.
A data analysis module, comprising: the data in the cleaning database is transferred to a draft library of the formal accident database, and is edited or audited and stored in the formal accident database; creating a chart, selecting a data source of a formal accident database and selecting a preset data query view, wherein the system lists metallurgical accident attribute fields of the query view through an API (application program interface) output by a foreground logic controller, then can drag the attribute fields to a dimension and value area, adds screening conditions, selects a chart type (the chart type is acquired by selecting a chart component), fills in names and descriptions, saves matching configuration data of relevant settings, the attribute fields, the dimension and the value to a background database, does not save keyword data of accident cases and attributes, and displays the data according to the setting and configuration data requests at a display module; and when the chart type is selected, the chart types of a histogram, a line graph, a pie chart, and the like in the echartis chart library can be selected, and the three-dimensional metallurgical production process chart integrating the echartis chart and the Threejs three-dimensional engine can also be selected, wherein the three-dimensional view of the Threejs metallurgical process is configured under the same interface with the echartis chart and the text report chart. And can convert the chart types at any time. And the multiple charts can be subjected to multi-dimensional and multi-numerical dragging configuration, and can be subjected to multi-condition screening setting according to chart types when data are configured, so that the configuration realization operation modes of different chart types and table types are unified.
A data presentation module, comprising: creating a data board, selecting a plurality of data charts to insert into the data board, and adjusting the layout of the data board by dragging, wherein the layout information of the data board is stored, and the relevant setting, attribute fields, dimension and numerical matching configuration data of all the data charts in the data board are stored in a background database.
A report derivation module comprising: creating a report billboard, selecting a plurality of data charts and report paragraph charts, inserting the report billboard, adjusting the layout of the report billboard by dragging, saving, reporting the layout information of the billboard, saving the relevant settings of all the data charts in the report billboard, matching configuration data of attribute fields, dimensionality, numerical values and statistical contents in the paragraphs to a background database, saving the keyword data of accident cases and attributes, saving the paragraph chart contents in the report billboard, and requesting the display data in a preview page of a report export panel of a half module according to the settings and configuration data and screening conditions.
The appearance UI module is used for data display.
The large screen display page layout adopts blue pixel city background and semitransparent chart component layout, the color configuration of the chart is customized, the upper right side is provided with condition screening, and the selected conditions are displayed in a label form and can be closed. The upper left corner uses menu buttons for large screen switching.
The appearance of the graph layout adopts a draggable layout, the width adopts 24 grids, and the height is infinite; each chart width, height may be customized. An unlimited number of chart units may be loaded. And may be adaptive according to screen size.
The invention is based on the WBD visualization system infrastructure to perform low-code secondary development.
The function construction of the invention is mainly completed by a code generator, namely, most codes of service functions are automatically generated through visual configuration.
The code generator realizes more than 20 configurable attributes, can flexibly configure functions such as display, inquiry, editing, import, export, master-slave relationship and the like, realizes business logic by low codes, realizes data visual analysis without codes, and has intelligent data grabbing and cleaning function configuration.
The basic function of the invention can generate the related class (controller/expansion controller, service interface/expansion service interface, interface realization/expansion interface realization class) of the background list and support the main codes of the list form and the master-slave form only by checking and confirming.
The accident data analysis is mainly divided into four layers of a demand layer, a data layer, an analysis layer and an output layer.
Grasping of Internet public data information: constructing a generalized word data table of keywords to which the metallurgical accident key information belongs, associating and storing the generalized word data table as an auxiliary label of the keywords to which the accident key information belongs with the keywords, and simultaneously using the auxiliary label of the keywords to which the accident key information belongs as the keywords to serve as an attribute judging method of the accident key information; similarly, a generalized word data table of keywords to which the injury personnel key information of the metallurgical accident belongs is constructed, the generalized word data table is used as an affiliated tag of the keywords to which the injury personnel key information belongs to be associated with the keywords for storage, and meanwhile, the affiliated tag of the keywords to which the injury personnel key information belongs is used as the keywords to be used as an attribute judging method of the injury personnel key information. Based on the design, the grabbing of the metallurgical accident case disclosed by the Internet is realized.
Data cleaning design: based on the key words of the accident key information and the key information of the injury personnel, the collected accident occurrence time, administrative area, key working procedure, accident category, causative object, responsible main body, personnel working age, working class, injury position, injury property, injury, accident category, injury degree and other key word rules related to the accident case stored in the collection database are subjected to data cleaning, related attribute information is extracted, and the relevant attribute information is stored in the accident database.
System visual display design: the vue +Echarts+Threejs+. Netcore technology route is mainly adopted.
And acquiring a custom data view of the cleaned formal data through an API interface by adopting a front-back end separation technology, embedding an Echarts chart library and a Threejs three-dimensional engine according to data fields, creating attribute data of the chart component in a multi-dimensional manner, and storing the attribute data in a background database.
And carrying out grid layout by using the vuejs script and the web technology, combining and nesting the attribute data of the chart component into the attribute data of the large-data large-screen layout, and simultaneously storing the large-screen layout and the attribute data of the chart component in a background database.
The configuration/setting API of the chart attribute and the layout attribute is output through the background logic controller; the foreground logic controller requests data from formal accident data through a display data API, matches the large-screen layout output by the background logic controller with the chart component attribute data (configuration/setting) API, and outputs display data after data recombination; and loading the display data in a large screen, and uniformly rendering the data by combining the Echarts chart component and the Threejs component.
The data acquisition module mainly realizes the functions:
Firstly, acquiring data (static data) through manual input of enterprises, and acquiring and storing the data according to accident keywords such as metallurgical accident occurrence time, administrative areas, key procedures, accident types, causative objects, responsible bodies, personnel working ages, work types, injury parts, injury properties, harmful substances, accident types, injury degrees and the like;
secondly, by means of the design of the web crawler, the system has an automatic internet accident data retrieval function, related production safety accident data are automatically retrieved from a designated website at regular time in a directed manner, accident information is acquired through multiple channels, and the comprehensiveness of a database is improved;
thirdly, the system has the functions of importing metallurgical accident static data in batches, editing, auditing, warehousing, filtering, exporting and the like, forms an accident data release base which is stored in a standard classification mode, and provides support for subsequent data analysis work.
According to the data analysis function requirement, through enterprise investigation and collection and analysis of relevant standard specifications, indexes required by accident data statistical analysis are researched and discussed, an accident statistical analysis index system of the metallurgical industry is established, 15 accident statistical indexes are contained, specific classification standards of the indexes are discussed, 340 remainder items are divided altogether according to national industry standard specification query, collection, classification and research, and a fixed form template for metallurgical accident data input is designed based on the fixed form template.
15. The statistical index of each accident:
a. injury personnel age group/proportion (18-60, one for every 3 years, 15 total);
b. the working age of injured personnel/proportion (0-0.3-0.6-0.9-1-3-6-10-15-20-25-35-40-45-50, 14 segments total);
c. the month of occurrence/proportion (1-2-3-4-5-6-7-8-9-10-11-12, 12 segments);
d. time period/ratio of occurrence: (12 segments of points 0-2, 2-4, 4-6, 6-8, 8-10, 10-12, 12-14, 14-16, 16-18, 18-20, 20-22, 22-24);
e. accident occurrence production procedures/proportion (15 primary production procedures of sintering pellets, iron making, steel rolling, coking, oxygen making, quicklime and rotary hearth furnace recycling, energy power, in-situ transportation, electricity, other and the like, 154 secondary production procedures);
f. accident conditions: the method is divided into normal production, on-line inspection and maintenance, production stopping and inspection and maintenance, independent construction engineering, transportation and other working conditions and 5 types;
g. accident injury degree: reference GB6441-86 is divided into 5 classes: a traumatic, light, severe, dead, or an event;
h. accident level: the major accidents, major accidents and general accidents are classified; in addition, the minor events are included in the statistical range in the later development;
i. Accident responsibility main body: "this factory (including labor dispatch)", "collaboration unit (including labor contractor)", etc.; j, accident types/proportion (44 types);
k. direct deleterious factors/ratios (classified as class 23 according to GB 6441-86);
accident type/proportion (classification according to GB6441, class 20); m. injury site/ratio (classification according to GB6441, class 15);
n. wound properties/proportions (classification according to GB6441, class 18);
accident occurrence administrative district coordinates (county): and determining the administrative region position according to the provincial region.
Meanwhile, the main production procedures and secondary procedures of metallurgical enterprises are studied in detail, and the main production procedures and secondary procedures are decomposed into 15 primary production procedures and 154 corresponding secondary production procedures, wherein the 15 primary production procedures and the 154 secondary production procedures are respectively performed by sintering pellets, iron making, steel rolling, coking, oxygen making, quick lime and rotary hearth furnace recycling, energy power, in-situ transportation, electricity and other procedures.
In order to ensure the rigor and the uniqueness of data input, the system considers manual auditing and is divided into a release library, a draft library and a possible repeated data comparison library, and the draft library and the release library are designed to be separated, so that data can be conveniently screened and corrected; the data can be repeated to provide contrast display with the interface data, so that the judgment and operation of an inputter are facilitated.
Meanwhile, the characteristics of the metallurgical accident history data are researched and analyzed, 22 metallurgical accident high-frequency words are extracted, task management is set, a plurality of acquisition tasks can be created, rules such as directory addresses, analysis types, character string positioning and the like in web websites can be independently input in each task, XPath of accident information is set by matching established keywords, and the production safety accident data of the metallurgical industry are regularly acquired by collecting and sorting accident information from appointed websites such as government, enterprise websites and public platforms.
The data cleaning module mainly realizes the functions: the system preliminarily realizes the functions of cleaning, preprocessing and screening the metallurgical accident key data obtained by automatic retrieval, and simultaneously, the system design meets the basic conditions for manual auditing, so that the accuracy of accident warehouse entry data obtained by a web crawler is ensured.
The method comprises the steps of establishing cleaning rules for initial accident information acquired by a web crawler, inputting data, matching front and rear characters, matching metallurgical accident attributes in an accident dictionary, automatically matching keywords and generalized words in the accident attributes by a system, comparing the metallurgical accident case information in an acquisition database, screening out effective metallurgical accident cases conforming to the rules, processing the effective data separately according to the effective degree of data extraction, transferring the accident case information conforming to the requirements of the effective data to a draft library of a formal accident database, storing the accident case information with insufficient data effective information together with the corresponding attributes and keywords in the cleaning database, setting a manual auditing flow, and editing or auditing and storing the manual auditing flow in the formal accident database so as to ensure the reliability and effectiveness of the warehousing accident data. Meanwhile, the system is convenient for manual auditing, and the source information of accidents is reserved.
In the system testing stage, six grabbing tasks are set, 2150 pieces of accident information are grab in a total mode, and 961 pieces of accidents are reserved for manual checking and warehousing after system data are cleaned.
The data analysis module mainly realizes the functions: the method has the advantages that the real-time dynamic acquisition and the position analysis record of the warehouse-in metallurgical accident information are realized, the nested division is supported, the data meeting the front-end display requirement is formed, on one hand, the comparison analysis of different dimensionalities of the accident case information is realized, and on the other hand, the accurate record of the accident position and the accurate positioning on an electronic map are realized.
On the one hand, by creating a chart, selecting a data source of a formal accident database and selecting a preset data query view, the system lists metallurgical accident attribute fields of the query view through an API output by a foreground logic controller, then can drag the attribute fields to a dimension and value area, adds screening conditions, selects a chart type (the chart type is acquired by selecting a chart component), fills in names and descriptions, saves matching configuration data of relevant settings, the attribute fields, the dimension and the value to a background database, and requests to display the data according to the settings and the configuration data at a display module.
On the other hand, position information such as administrative areas, production procedures and the like to which the accidents belong in the data release library is classified according to attributes, keyword information is extracted and correspondingly matched with the point positions of the built electronic map or electronic model, and the data analysis of the accident occurrence areas and the production procedures is realized through the accident occurrence position extraction recording function.
The data display module mainly realizes the functions: the method realizes batch display of multi-dimensional accident case information, can screen under multiple conditions, and forms a visual billboard for analyzing the big data of the production safety production accidents of metallurgical enterprises mainly based on thermodynamic diagrams and related charts, and the accident case information is intuitively known.
The method realizes batch display of multi-dimensional accident case information, can screen under multiple conditions, and forms a visual billboard for analyzing the big data of the production safety production accidents of metallurgical enterprises mainly based on thermodynamic diagrams and related charts, and the accident case information is intuitively known.
The method comprises the steps of outputting field multidimensional form chart structure data of different types through an accident data view, combining layout components into a large screen display layout data, storing the large screen display layout data, outputting an API through a logic controller of a system background, matching a data API output by a foreground logic controller, displaying the accident data through a chart component and a three-dimensional engine component, screening through accident key conditions, and globally displaying a screened accident data analysis chart. The method can provide related data such as accident occurrence time, administrative areas, key procedures, accident types, origins, responsible subjects, personnel working ages, working types, injury parts, injury properties, harmful substances, accident types, injury degrees and the like for metallurgical enterprises, and displays the data of the proportion, the numerical value and the detailed cases.
Meanwhile, the system is combined with gITF, OBJ, FBX and other three-dimensional model processing components to build a national administrative region electronic map, a metallurgical main production procedure two-dimensional plane electronic map and an ironmaking/converter steelmaking/hot rolling 3D electronic model, and the system is used for visual analysis and display of accident location areas and production procedures.
The data display module mainly comprises the following parts.
a. And analyzing and displaying accident data in the administrative region. The constructed national administrative region electronic map is drawn, information such as accident occurrence time, detailed casualties and geographical position coordinates of the accident occurrence in an accident database is used as basic data, and the data is visually rendered by utilizing an encapsulated EChart chart, so that the safety production accident data in any time period is expressed in a thermodynamic diagram form on the administrative region map.
The display module can express the spatial distribution of accidents in administrative areas of metallurgical enterprises in a thermodynamic diagram mode, display big data analysis results in real time according to warehouse-in data, and display the current accident situation in history; the system can screen and display according to accident occurrence time periods, areas and the like, and synchronously analyze data of accident occurrence years, months, time periods, accident types, accident grades, injury degree, accident direct reasons, accident responsibility main bodies and the like.
b. And analyzing and displaying the two-dimensional plane accident data of the main body production process of the metallurgical enterprise. By drawing an electronic map of the established metallurgical main production processes (two-dimensional) (15 main processes, 154 secondary processes), according to the incident data in storage, the expression of the spatial distribution of the incidents in any time period is realized in a thermodynamic diagram form according to the main production processes of the steel enterprises, and the analysis results of other incident data are displayed in a visual form of a chart.
The display module can express the spatial distribution of the metallurgical enterprise accidents in the production procedures of each main body of the metallurgical enterprise in a thermodynamic diagram mode, display the analysis result of big data in real time according to the warehouse-in data and display the detail of the accidents in the production procedures; the system can be screened and displayed according to accident occurrence time periods, working procedures and the like, and synchronously analyzes data such as accident occurrence years, month and time periods, accident types, accident grades, injury degrees, accident direct reasons, accident responsibility main bodies and the like.
And analyzing and displaying the accident data of the three-dimensional model.
The three-dimensional model of the production process of the metallurgical enterprise is visually rendered by utilizing three.js through drawing a built electronic model map of the ironmaking/converter steelmaking/hot rolling (three-dimensional) (38 secondary processes), the space distribution of accidents in any time period is expressed in a thermodynamic diagram mode according to the production processes of the blast furnace, the converter and the hot rolling, and the analysis result of the big accident data is displayed in a visual chart mode.
The display module can realize the spatial distribution of the metallurgical enterprise accidents in the lower-layer secondary production process of each main process of the metallurgical enterprise in a thermodynamic diagram mode, display the analysis result of big data in real time according to the warehouse-in data and display the accident situation in the production process; wherein the procedures of iron making, converter steel making and hot rolling can be shown on the established 3D model.
The system can be screened and displayed according to accident time periods, working procedures and the like, and synchronously analyze data of accident occurrence years, months, time periods, accident types, accident grades, injury degrees, direct accident reasons, accident responsibility main bodies and the like.
And (5) analyzing and displaying the data statistics chart.
According to the requirement of the data analysis and display function, 16 charts of different categories are researched and designed, and the data are visually displayed by utilizing the EChart chart packaged by the Vue. Js assembly. And the definition of the mapping relation between the chart and the data can be completed by configuring the data source and the matching rule of each chart, and the chart component is displayed.
When the chart type is selected, the bar chart, the line chart, the pie chart, the chart types in the Echarts chart library can be selected, the three-dimensional metallurgical production process chart integrating the Echarts chart and the Threejs three-dimensional engine can be selected, and the three-dimensional view of the Threejs metallurgical process, the Echarts chart and the text report chart are configured on the same interface.
The chart types can be converted at any time, a plurality of charts can be subjected to multi-dimensional and multi-numerical dragging configuration, multi-condition screening setting can be performed according to the chart types when data are configured, and the configuration of different chart types and the chart types can be unified in operation mode.
The module can be used for classifying the accident injury personnel according to the age, the work age, the occurrence time, the accident type, the injury parts and the like based on the warehouse-in accident data, carrying out statistical analysis on the accident indexes, and intuitively displaying the analysis results through various charts.
Report exporting module, which realizes main functions: the function of regularly pushing and guiding out analysis reports according to accident statistics reports (templates) of fixed design is realized.
The report board is created through the system, a plurality of data charts and report paragraph charts are selected to be inserted into the report board, the layout of the report board can be adjusted through dragging, the report board layout information is saved, the relevant settings, attribute fields, the dimension, the numerical value and matching configuration data of statistical contents in paragraphs of all the data charts in the report board are queried, the matching configuration data is saved to a background database, and the display data is requested in a preview page of a report export panel of a half module according to the settings and configuration data and screening conditions.
The method is used for automatically analyzing accident occurrence time, administrative areas, key procedures, accident categories, causes, responsibility subjects, personnel working ages, work types, injury parts, injury properties, injury causing substances, accident categories, injury courses and the like related to accident case information through accident key conditions according to annual, quarternary, monthly and other reports, and automatically forming accident analysis reports of metallurgical industry or enterprises.
Meanwhile, a file management module is arranged, so that operations such as downloading, modifying, perfecting and uploading can be performed on accident analysis reports automatically produced by the system, more perfect metallurgical industry and enterprise accident analysis reports can be provided for member units, and guiding reference suggestions can be provided for safety management work of the member units.
The invention has the functions of accident material collection, importing and uploading, preprocessing, automatic searching, data cleaning, accident database establishment, online address analysis service based on a mainstream network electronic map, thermodynamic diagram and related chart display of safety production accidents.
The invention has the following characteristics.
(1) The low code implements business logic. A basic code (such as user authentication and authorization, request response log and task scheduling) which is automatically generated is built in, and a service module can be expanded in a self-defined mode; front and back ends are separated, and the front end calls back logic to complete a service flow through a background RESTful API; the page forms (e.g., chart, table, select list, etc.) automatically bind the corresponding source data in the backend database.
(2) And automatically generating source data required by the SQL statement query chart. The system queries the databases by constructing SQL sentences, and the back-end query is processed by using Presto, so that various databases can be queried uniformly, besides the traditional relational database, HDFS can be queried, and the query capability is high; the front-end part fraction data query is divided into interactive elements such as dimensionality, data, screening, sorting, data number and the like mainly through deconstructing of SQL sentences, so that users without SQL foundation can use the data conveniently, and the interaction of the users at the front end dynamically generates SQL according to specific grammar rules and sends the SQL to the rear end for querying a database.
(3) The intelligent grabbing and cleaning are realized without codes. The background service configures a grabbing task running at regular time, configures the URL address of data by the regular task, and grabs key information by combining XPath rules.
(4) The accident data analysis display module is designed to take account of the individual setting requirements of different clients, and utilizes vue-grid-layout to carry out grid layout on pages according to charts related to the signboards, then query data and visual rendering are carried out according to the saved charts, meanwhile, layout is supported by dragging, size adjustment and the like, and the functions of displaying the layout of an interface and self-setting of icon module users are realized; and supporting the popup window display function of the module click highlighting amplifying display and accident specific information in the interface.
(5) The assembly packaging Apache EChart chart can be displayed by designating the incoming source data, so that the front end can perform accident early warning on an electronic map in real time according to the warehouse-in accident data by using a thermodynamic diagram visualization technology and intuitively display the statistical analysis result of the accident big data in a chart form.
The beneficial technical effects of the invention are as follows.
(1) The accident data acquisition mode comprises the following steps: the accident data acquisition technology combining static accident information (historical data) +dynamic web crawlers is developed, the accident acquisition efficiency is improved, and the comprehensiveness of accident acquisition is ensured.
Besides static manual input, a function of capturing public data of the Internet is set, 22 metallurgical accident high-frequency words extracted by matching research are set, and accident data are retrieved from a specified network station in a timing way through XPath setting and orientation. Based on the accident key information and the key words of the injury personnel key information, cleaning the accident cases stored in the acquisition database, extracting the acquired accident cases stored in the acquisition database according to the accident information key words and the injury personnel key words, and storing the extracted accident cases in the acquisition database as attribute information of the accident cases.
In the system test stage, 2150 accidents are directionally grasped and 961 accidents are reserved for manual checking and warehousing after the system data are cleaned.
Accident analysis display carrier: the method of combining the electronic map and the analysis chart to display the accident analysis result is adopted, so that the visual expression effect of accident data is enhanced.
The project drawing builds an electronic map of national administrative areas, main metallurgical production procedures (two dimensions) (15 main procedures, 154 secondary procedures) and ironmaking/converter steelmaking/hot rolling (three dimensions) (38 secondary procedures), designs a diversified chart (16 types), and visually renders data by using the packaged EChart chart and a metallurgical enterprise procedure three-dimensional visual model to visually display the data analysis result.
The accident early warning mode can adopt a thermodynamic diagram visual early warning mode, provides important treatment and accurate treatment reference for enterprise safety management, and improves the pre-prevention capability of enterprises.
The system is developed by adopting a visual system architecture based on WBD, so that the system is more flexible and more convenient to operate, and the personalized operation requirements among users are met.
The system framework is internally provided with a code generator function, namely a visual configuration function, so that more than 20 flexibly configurable attributes are realized, and the custom extended service codes can be generated after configuration; the back-end data query package prest is used for processing, so that multiple types of databases (SQL and DFS) can be queried uniformly, and the front-end data query is performed through SQL statement analysis, so that the function is strong, and the use is convenient; the background is provided with a self-defined chart and a large screen function, a client can automatically establish an analysis chart and manage a large screen interface according to primary and secondary accident statistics indexes and multi-dimensional analysis requirements, and each module can change the form and can be combined at will; the operation interface is provided with functions of amplifying display, retrieving accident details and the like so as to meet the operation habit and management requirements of personnel at all levels.
Claims (10)
1. The accident data management method based on the metallurgical industry is characterized by comprising the following steps:
step 1: establishing a generalized word data table of keywords to which the accident key information belongs in the metallurgical industry, associating and storing the generalized word data table as an auxiliary label of the keywords to which the accident key information belongs with the keywords, and simultaneously using the auxiliary label of the keywords to which the accident key information belongs as the keywords for judging the attribute of the accident key information;
step 2: extracting scene keywords from accident reporting cases and Internet public metallurgical accident cases, determining metallurgical accident key information and injury personnel key information according to the scene keywords, collecting accident cases with partial corresponding key information from the accident reporting cases and Internet public metallurgical accident cases, and storing the accident cases in a collection database;
step 3: the collected accident cases stored in the collection database are extracted according to accident information keywords and injury personnel keywords, and are stored in the collection database as attribute information of the accident cases;
step 4: based on the key words of the accident key information and the key information of the injury personnel, cleaning the accident cases stored in the acquisition database, and storing the accident cases in a cleaning database;
Step 5: based on the accident key information and the key words to which the injury personnel key information belongs, cleaning the accident cases stored in the acquisition database, and meanwhile, taking the key words to which the labels to which the accident information key words and the injury personnel key words belong as attribute information of the accident cases to be stored in the cleaning database.
2. The method for managing accident data based on the metallurgical industry according to claim 1, wherein the attribute of the accident key information comprises: accident occurrence time, administrative areas, key procedures, accident types, causative objects and responsible bodies; wherein the attribute of the injury personnel key information comprises: age, type, injury site, nature of injury, pest, accident category, and injury degree.
3. The accident data management method based on metallurgical industry of claim, wherein in the step 1, the generalized word data table is stored as an affiliated tag of a keyword to which the injury personnel key information belongs in association with the keyword, and meanwhile, the affiliated tag of the keyword to which the injury personnel key information belongs is used as the keyword for judging the attribute of the injury personnel key information.
4. A visualization system for an accident data management method based on metallurgical industry, characterized by comprising:
the data acquisition module is used for acquiring accident reporting cases and Internet public metallurgical accident cases and comprises enterprise uploading accident case data;
the data cleaning module is used for screening effective accident case data and formatting data information of standardized metallurgical accident cases;
the data analysis module is used for carrying out comparison analysis on various attributes of the accident case information and creating a chart;
the data display module is used for carrying out batch display and multi-condition screening display on accident case information, forming a big data billboard, visually and intuitively knowing accident case information, the distribution of metallurgical accidents and injurors in time, the distribution in working procedures and the regional distribution, and the distribution conditions of different dimensions of the responsible objects, responsible bodies, personnel working ages, working species, injuring parts, injuring properties, injures, accident types and injuring degrees according to the accident types;
the report deriving module is used for carrying out automatic homonymy and girth analysis on the accident occurrence time, administrative areas, key procedures, accident types, causative objects, responsible bodies, personnel working ages, working types, injury parts, injury properties, harmful substances and accident types related to the accident case information through the accident key conditions, and the injury degree is analyzed according to the annual, quarternary, monthly and other reports to form an effective metallurgical accident report.
5. The visual system of the accident data management method based on the metallurgical industry according to claim 4, wherein the data acquisition module performs accident case acquisition by adopting a mode of simulating manual reading by reading web+api, and performs data cleaning by adopting accident occurrence time, administrative areas, key procedures, accident categories, causative objects, responsible subjects, personnel working ages, working types, injury parts, injury properties, injury causing substances, accident categories and injury degree keyword rules related to the accident key conditions in claim 1.
6. The visual system of the accident data management method based on the metallurgical industry according to claim 4, wherein the data acquisition module, the data cleaning module acquire data, the cleaned data and the formal data are stored by adopting a separate database, and the cleaned data is added into the manual auditing module before being compiled into the formal data.
7. The visual system of the accident data management method based on the metallurgical industry according to claim 4, wherein the data analysis module comprises a foreground logic controller, a background logic controller and a background database, and the self-defined data view of the cleaned formal data is obtained through an api interface, and according to the data field, the self-defined data view is embedded into an echarts chart library and a threejs three-dimensional engine, and the attribute data of the chart component is created in a multi-dimension manner and stored in the background database; performing grid layout by using a vuejs script and the web, combining and nesting attribute data of the chart component into attribute data of a large-screen layout of the visual large data, and simultaneously storing the large-screen layout and the attribute data of the chart component in a background database; the configuration/setting API of the chart attribute and the layout attribute is output through the background logic controller.
8. The visual system of the accident data management method based on the metallurgical industry of claim 4, the data display module is characterized in that display data are loaded in a large screen, and the data are uniformly rendered by combining the echartits chart component and the threjs component.
9. The visualization system of the metallurgical industry based incident data management method of claim 5, wherein the embedded echartists schema library and threjs three-dimensional engine, multidimensional create schema component attribute data, further comprises:
the three-dimensional chart shows that the threejs three-dimensional engine is integrated into the echorts, the unified data dimension configuration mode of the echorts chart is continued, the configuration realization operation modes of the three-dimensional chart type and the table type are unified, and other different chart types are unified: the data formats of the pie charts, the bar charts, the line charts and the bar charts are combined, the ring charts, the instrument panel, the humanoid charts, the metallurgical process charts and the administrative region charts are converted, and the configuration realization operation modes of different chart types and table types are unified by adopting the same data dimension configuration mode.
10. The accident data display method based on the metallurgical industry is characterized by comprising the following steps:
Step 1: view query is carried out on the content of the formal accident database after cleaning, and the attribute keywords of the accident key information and the attribute keywords of the injury personnel key information are output and contain the attribute values associated with the keywords;
step 2: selecting a chart type, drag-putting a keyword of a dimension to be displayed into a dimension column, selecting an attribute value type of the keyword, drag-putting a keyword of a value to be displayed into a value column, and selecting the attribute value type of the keyword;
step 3: adding screening conditions, filling names and descriptions, and storing the set charts and data attributes into a background database;
step 4: creating a large-screen layout, adding a plurality of stored chart components into the layout, carrying out layout adjustment by dragging, and storing chart attributes and setting data together with the large-screen layout data into a background database;
step 5: the large screen display page acquires data and sets a rendering data layout and a chart through display data api;
the large-screen display page is provided with screening conditions, after the screening conditions are selected, parameters of the screening conditions are directly transmitted into the foreground logic controller through display data api, and the large-screen display page acquires data which are recombined after screening the screening conditions through the display data api, and sets a rendering data layout and a chart.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310769997.6A CN116842255A (en) | 2023-06-28 | 2023-06-28 | Accident data management method, visualization system and display method based on metallurgical industry |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310769997.6A CN116842255A (en) | 2023-06-28 | 2023-06-28 | Accident data management method, visualization system and display method based on metallurgical industry |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116842255A true CN116842255A (en) | 2023-10-03 |
Family
ID=88166303
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310769997.6A Pending CN116842255A (en) | 2023-06-28 | 2023-06-28 | Accident data management method, visualization system and display method based on metallurgical industry |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116842255A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116894032A (en) * | 2023-09-05 | 2023-10-17 | 江苏数兑科技有限公司 | Method for automatically generating data cleaning rule based on data exploration analysis result |
| CN117151350A (en) * | 2023-10-31 | 2023-12-01 | 广东正迪科技股份有限公司 | Visual billboard system, method, device and medium for decision management |
-
2023
- 2023-06-28 CN CN202310769997.6A patent/CN116842255A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116894032A (en) * | 2023-09-05 | 2023-10-17 | 江苏数兑科技有限公司 | Method for automatically generating data cleaning rule based on data exploration analysis result |
| CN116894032B (en) * | 2023-09-05 | 2023-11-21 | 江苏数兑科技有限公司 | Method for automatically generating data cleaning rule based on data exploration analysis result |
| CN117151350A (en) * | 2023-10-31 | 2023-12-01 | 广东正迪科技股份有限公司 | Visual billboard system, method, device and medium for decision management |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN116842255A (en) | Accident data management method, visualization system and display method based on metallurgical industry | |
| CN106599039B (en) | Statistical representation method supporting free combination nesting of relational database data | |
| WO2015176526A1 (en) | Superimposed-relationship-based document identification, association, search, and display system | |
| JP5570608B2 (en) | Excel-based analysis report creation system and method | |
| CA2646362A1 (en) | Report generation with integrated quality management | |
| CN105868310A (en) | Data processing method and device and electronic device | |
| CN112559351B (en) | CFD software verification and confirmation database platform | |
| US20200334314A1 (en) | Emergency disposal support system | |
| CN101751400A (en) | System and method of technical data analysis and system of patent analysis | |
| CN116384889A (en) | Intelligent analysis method for information big data based on natural language processing technology | |
| CN110837703A (en) | Pro/E-based hydraulic cylinder rapid design system and method | |
| CN115496452A (en) | Digital delivery system based on digital twin | |
| CN101000670A (en) | Workflow management system | |
| CN113722564A (en) | Visualization method and device for energy and material supply chain based on space map convolution | |
| US20060080277A1 (en) | Method and system for designing, implementing and documenting OLAP | |
| CN103810243A (en) | Innovative hotspot pre-warning recognition system and method | |
| CN111784192A (en) | Industrial park emergency plan executable system based on dynamic evolution | |
| CN101441645A (en) | System and method of technical data analysis | |
| CN116303336A (en) | Data management method based on data braiding architecture | |
| CN115906213A (en) | Editing method and system of visual chess evaluation statistical model | |
| Sarhan | Development of a lean construction framework for the Saudi Arabian construction industry | |
| WO2021041813A1 (en) | Methods and systems for depiction of project data via transmogrification using fractal-based structures | |
| TW201316192A (en) | Reading system for technical documents and method and computer readable storage medium for generating patent information of patent documentss thereof | |
| CN110795449A (en) | BS architecture-based environment-friendly public opinion system | |
| CN103810242A (en) | System and method for automatically recognizing innovative literature graticules and literature positions |
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 |