CN104951541A - Chemical engineering accident statistical analysis system based on database - Google Patents
Chemical engineering accident statistical analysis system based on database Download PDFInfo
- Publication number
- CN104951541A CN104951541A CN201510346244.XA CN201510346244A CN104951541A CN 104951541 A CN104951541 A CN 104951541A CN 201510346244 A CN201510346244 A CN 201510346244A CN 104951541 A CN104951541 A CN 104951541A
- Authority
- CN
- China
- Prior art keywords
- accident
- information
- database
- statistics
- scientific research
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a chemical engineering accident statistical analysis system based on a database. The system comprises a user interface which is divided into three parts, namely, an enterprise part, a safety supervision department part and a scientific research institution data part. The enterprise part includes reported accident information and shared information query. The safety supervision department part includes detailed information query, accident report information submitting and accident statistics information. The scientific research institution data part includes shared information query and accident statistics. By means of the system, chemical engineering enterprises can conveniently report accident information in a timely and standard mode, and important assistance is provided for safety production supervision and management departments to conduct accident statistics and is provided for scientific research institutions to research accident occurrence rules.
Description
Technical field
The invention belongs to chemical technology field, relate to a kind of chemical accident statistical analysis system based on database.
Background technology
Chemical process has the features such as production procedure is long, operation is many, complex process, a lot of operation requirements carries out under high temperature, condition of high voltage, raw material, intermediate product, product and discarded object have inflammable, explosive or poisonous, harmful, corrosion-prone characteristic mostly, these factors determine Chemical Manufacture accident have occur suddenly, diffusion rapidly, the feature such as the duration is long, involve a wide range of knowledge and hazard analysis and HACCP is serious.According to statistics, the loss that causes because of chemical accident and chemical hazard every year of the whole world is more than 4,000 hundred million yuans.
After within 1984, India's Bhopal accident to leak the poison gas occurs, countries in the world and associated safety mechanism thereof come to realise the importance reported accident, analyze and study, and the developed countries such as the U.S., Europe, Japan establish chemical accident management and notification database respectively.These databases have the features such as data are abundant, perfect in shape and function, standardization, achieve effective integration and the information sharing of chemical accident information, for analysis on accident cause, accident research, safety evaluation and safety training etc., in prevention or minimizing accident, play extremely important effect.
But the chemical accident database establishment of current China is also relatively backward, its Data Structure Design is simple, institute contains that accident quantity is few, information is imperfect, in quality or quantitatively all can not meet the requirement of accident research.Therefore, China's chemical accident Basis of Database carry out statistical study to chemical accident and studies its pests occurrence rule improving, for the prevention of chemical industry major accident, promoting chemical industry general safety production level and be significant.
Summary of the invention
The object of the present invention is to provide a kind of chemical accident statistical analysis system based on database, the key issue that the present invention determines:
1. accident information collection.Because the temporary unrealized accident information of China is shared, the full detail obtaining accident is difficult to by means of only the data such as website and books, especially the significant data such as culprit, the number of casualties and economic loss lacks usually, if this problem can not get solving, produce extreme influence by the realization of each function of accident statistical analysis system.This problem is in research process, except network and documents and materials, also undertaken investigating and investigating by going deep into each chemical enterprise, and actively contact the investigation group expert of major accident, with the particulars of acquisition accident generating process, guarantee the accident case information completely in database.
2. statistical indicator is determined.Along with the continuous maximization, complicated of chemical process, accident genesis mechanism is also increasingly sophisticated, and traditional accident statistics index can not meet accident research needs as the accident in certain time period plays number, death toll, number of injured people, direct economic loss etc.This problem is intended carrying out on in-depth analysis basis to the different demands of safety regulator to accident statistics, for different user arranges different statistical indicator, as culprit statistics, accident pattern statistics, accident probability analysis etc., to meet the research of accident pests occurrence rule and accident prevention needs.
The technical solution adopted in the present invention is that system comprises user interface, and user interface is divided into three parts, is respectively enterprise-class, safety supervision department and scientific research institution's data; Wherein, enterprise-class comprises accident reporting information and shared information inquiry, and safety supervision department comprises details inquiry, submits accident report information and accident statistics information to, and scientific research institution's data comprise shared information inquiry and accident statistics.
The invention has the beneficial effects as follows that this system can facilitate chemical enterprise in time, report accident information to specification, and carry out accident statistics for security production supervision and management department and scientific research institution's research accident pests occurrence rule provides valuable help.
Accompanying drawing explanation
Fig. 1 is the chemical accident statistical analysis system structural representation that the present invention is based on database.
Embodiment
Below in conjunction with embodiment, the present invention is described in detail.
The key issue run in the processes such as research contents of the present invention reports for chemical enterprise accident, safety supervision management department accident statistics and scientific research institution's accident pests occurrence rule research is launched, present system structure as shown in Figure 1, comprise user interface, user interface is divided into three parts, is respectively enterprise-class, safety supervision department and scientific research institution's data; Wherein, enterprise-class comprises accident reporting information and shared information inquiry, and safety supervision department comprises details inquiry, submits accident report information and accident statistics information to, and scientific research institution's data comprise shared information inquiry and accident statistics.
1. chemical accident factor analysis.On the basis analyzed typical chemical accident case, with reference to external advanced chemical accident database, extract and describe the necessary key element of chemical accident.These key elements should be able to complete, all sidedly accident information is described, and the needs of data retrieval, statistical study and the research of accident pests occurrence rule can be met.
2. casualty data storehouse design.This problem is intended adopting SQL Server 2000 as background data base, according to factor analysis result, determines form needed for database and field, design data library structure.
3. accident case arranges and adds.Accident case needed for problem is mainly from State Administration of Quality and Technical Supervision, each province and city Work Safety Supervision Bureau website, library's document data, large chemical complex's accident histories data etc.For meeting the needs of accident statistical analysis and accident law study etc., all accident cases all should have comparatively detailed description, comprise the information such as accident generating process, culprit, the number of casualties and economic loss, scene of the accident picture.
4. user-interface design and exploitation.System user interface adopts VB6.0 exploitation, and for meeting the demand of different user, system should be different users and gives different operating rights, and designs different user interfaces.
This project by design chemical accident database, and with this database for core exploitation accident report, the function such as accident statistics, analysis on accident cause.This system can facilitate chemical enterprise in time, report accident information to specification, and carries out accident statistics for security production supervision and management department and scientific research institution's research accident pests occurrence rule provides valuable help.In addition, shared by accident information, this system also can be enterprise and formulates accident prevention, carries out Employee Security training etc. and provide important evidence.
The above is only to better embodiment of the present invention, not any pro forma restriction is done to the present invention, every any simple modification done above embodiment according to technical spirit of the present invention, equivalent variations and modification, all belong in the scope of technical solution of the present invention.
Claims (1)
1. based on a chemical accident statistical analysis system for database, it is characterized in that: system comprises user interface, user interface is divided into three parts, is respectively enterprise-class, safety supervision department and scientific research institution's data; Wherein, enterprise-class comprises accident reporting information and shared information inquiry, and safety supervision department comprises details inquiry, submits accident report information and accident statistics information to, and scientific research institution's data comprise shared information inquiry and accident statistics.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510346244.XA CN104951541A (en) | 2015-06-23 | 2015-06-23 | Chemical engineering accident statistical analysis system based on database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510346244.XA CN104951541A (en) | 2015-06-23 | 2015-06-23 | Chemical engineering accident statistical analysis system based on database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104951541A true CN104951541A (en) | 2015-09-30 |
Family
ID=54166199
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510346244.XA Pending CN104951541A (en) | 2015-06-23 | 2015-06-23 | Chemical engineering accident statistical analysis system based on database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104951541A (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090093996A1 (en) * | 2006-05-09 | 2009-04-09 | Hsb Solomon Associates | Performance analysis system and method |
| CN101800822A (en) * | 2010-01-06 | 2010-08-11 | 中国石油化工股份有限公司 | Consultation system for chemical accident emergencies |
-
2015
- 2015-06-23 CN CN201510346244.XA patent/CN104951541A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090093996A1 (en) * | 2006-05-09 | 2009-04-09 | Hsb Solomon Associates | Performance analysis system and method |
| CN101800822A (en) * | 2010-01-06 | 2010-08-11 | 中国石油化工股份有限公司 | Consultation system for chemical accident emergencies |
Non-Patent Citations (2)
| Title |
|---|
| 付靖春 等: "国内外化学事故数据库的发展现状与展望", 《中国安全科学学报》 * |
| 李俊: "基于CBR的危险化学品事故数据库的研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| De Rassenfosse et al. | An introduction to the Patstat database with example queries | |
| CN106682150B (en) | Information processing method and device | |
| Kumar et al. | Whom should I follow? Identifying relevant users during crises | |
| Qiao et al. | Using data mining techniques to analyze the influencing factor of unsafe behaviors in Chinese underground coal mines | |
| Ahmed et al. | Where are mines located in sub Saharan Africa and how have they expanded overtime? | |
| US20200334314A1 (en) | Emergency disposal support system | |
| Huang et al. | Case database construction and temporal-spatial analysis of mass incidents in China based on GIS | |
| Baroutsis et al. | Social geography, space, and place in education | |
| CN103903210A (en) | Case feature series-parallel analysis method | |
| CN104951541A (en) | Chemical engineering accident statistical analysis system based on database | |
| Jin et al. | Work-related fatalities in the People's Republic of China | |
| Yongfu et al. | Connotation and selection of disruptive technologies that lead industrial change | |
| Nath | Crime data mining | |
| Hogg | Penology from city to country: Rurality and penality in Australia | |
| Sujatha et al. | A proposal for analysis of crime based on socio–economic impact using data mining techniques | |
| Huang et al. | A Comparative Study of Differences in Government Regulation of Food Safety between China and the United States | |
| Guaralda | Australian urbanism and the meaning of public space: Placemaking and urban design in South-East Queensland | |
| Song | Analysis of Information Security Risks and Countermeasures of Smart Cities from the Perspective of Information Ecology | |
| Cuencua et al. | Accounting, political rationales and financial access in Central America: the case of a Worker's bank | |
| Jin et al. | The social negative mood index for social networks | |
| Harris et al. | Courting justice beyond the cityscape: Access to justice and the rural, regional and remote magistrates' courts | |
| Jaquelyn et al. | Speaking up: a feminist analysis of the possibility of cultural change in women’s artistic gymnastics in Australia and England | |
| Renganathan | Business Intelligence: An overview | |
| de Montclos | Violence in Nigeria | |
| Li et al. | A Study of Extraction Methods for Incident Subject Terms Based on Left-Right Branch and Between-Class Distribution Entropies |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150930 |
|
| WD01 | Invention patent application deemed withdrawn after publication |