# Coal and Gas Outburst Risk Prediction and Management Based on WOA-ELM
## 4 Data Sources and Processing
\begin{table}
\begin{tabular}{c c c c c c c c c c c} \hline \hline
**Accident Cases** & **Order Number** & **1** & **2** & **3** & **4** & **5** & **6** & **7** & **8** & **9** & **10** \\ \hline gas pressure & 1.99 & 4.54 & 1.74 & 3.62 & 1.4 & 0.28 & 3.2 & 1.6 & 2.5 & 2.45 \\ \hline gas content & 26 & 21 & 20.34 & 18.25 & 17.4 & 17.36 & 17.32 & 16.42 & 14.32 & 13.91 \\ \hline initial velocity of gas diffusion & 16 & 15 & 11 & 35 & 10 & 9 & 6 & 15 & 9 & 8 \\ \hline coal sturdiness factor & 0.17 & 0.4 & 0.39 & 0.12 & 0.52 & 0.78 & 1.3 & 0.36 & 0.34 & 0.48 \\ \hline porosity & 6.5 & 5.9 & 4.9 & 7.7 & 6.2 & 6.21 & 5.2 & 3.6 & 7.25 & 9.36 \\ \hline evaluation of Prominent Coal Seams & 100\% & 100\% & 100\% & 0 & 100\% & 100\% & 0 & 10\% & 50\% & 100\% \\ \hline regional risk forecast & 30\% & 100\% & 20\% & 0 & 10\% & 10\% & 20\% & 0 & 0 & 20\% \\ \hline comprehensive regional preventive measures & 50\% & 40\% & 0 & 0 & 10\% & 40\% & 40\% & 0 & 0 & 0 \\ \hline testing the effectiveness of regional preventive measures & 50\% & 100\% & 100\% & 10\% & 10\% & 10\% & 30\% & 0 & 20\% & 0 \\ \hline regional validation & 20\% & 100\% & 100\% & 10\% & 10\% & 10\% & 40\% & 0 & 30\% & 0 \\ \hline prediction of working face risks & 50\% & 100\% & 100\% & 50\% & 40\% & 30\% & 0 & 0 & 0.1 \\ \hline local preventive measures & 70\% & 100\% & 60\% & 100\% & 100\% & 50\% & 0 & 100\% & 0 & 0 \\ \hline local integrated control measures testing & 50\% & 100\% & 40\% & 100\% & 100\% & 20\% & 0 & 100\% & 10\% & 20\% \\ \hline gas monitoring system management & 10\% & 100\% & 100\% & 100\% & 0 & 50\% & 10\% & 10\% & 10\% & 10\% \\ \hline mine ventilation system management & 100\% & 100\% & 100\% & 100\% & 100\% & 0 & 100\% & 100\% & 0 \\ \hline management of compressed air self-help systems & 0 & 100\% & 100\% & 100\% & 50\% & 100\% & 50\% & 100\% & 100\% & 0 \\ \hline management of emergency evacuation systems & 50\% & 100\% & 80\% & 100\% & 100\% & 100\% & 40\% & 100\% & 100\% & 20\% \\ \hline personnel location system management & 100\% & 100\% & 20\% & 100\% & 100\% & 50\% & 50\% & 100\% & 100\% & 20\% \\ \hline countermeasures after the occurrence of coal and gas outburst & 100\% & 10\% & 10\% & 20\% & 10\% & 100\% & 0 & 10\% & 20\% & 30\% \\ \hline whether to operate in accordance with safety regulations & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline safety protection and personal safety protection are in line with the requirements & 0 & 1 & 1 & 1 & 1 & 0 & 0 & 1 & 1 & 1 \\ \hline are the procedures or plans or technical measures prepared as required & 0 & 1 & 1 & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline adequacy of geological structure or mine pressure monitoring or studies & 0 & 1 & 1 & 1 & 0 & 1 & 1 & 0 & 0 & 0 \\ \hline Gas outburst & Q/t & 340 & 87 & 32 & 120 & 18 & 33 & 17.8 & 170 & 82 & 39 \\ \hline Risk level & \(Z_{i}\) & 4 & 3 & 2 & 4 & 2 & 2 & 2 & 4 & 3 & 2 \\ \hline \hline \end{tabular}
\end{table} 
Table 6: Partial data. In the formula: _r_--number of nodes in the input layer; _s_--number of nodes in the output layer; _M_--number of hidden layer nodes; _n_--number of samples; _m_--constants. With other conditions unchanged, the number of hidden layer neuron nodes is changed, and the root means the square error of the training results is compared. The number of hidden layer neuron nodes is determined to be 10, and the Sigmoid function is selected as the activation function. In addition, a database needs to be established. The database's purpose is to use CBR to manage the risk level of gas outbursts. This paper selects the SQL Server2018 database system and names the database Case_Management. This article uses DataServer to read monitoring and detection information data. The data is organized according to the specified data standard protocol, and the read data is parsed and stored using DataGather. The data collected by both are stored in the database Case_Management. As shown in Tables 7 and 8, in the database Case_Management, there are two main data tables: the Case Information table and the Exception Information table.