Among the network security problems, SQL injection is a common and challenging network attack means, which can cause inestimable loop-breaking and loss to the database, and how to detect SQL injection statements is one of the current research hotspots. Based on the data characteristics of SQL statements, a deep neural network-based SQL injection detection model and algorithm are built. The core method is to convert the data into word vector form by word pause method, then form a sparse matrix and pass it into the model for training, build a multihidden layer deep neural network model containing ReLU function, optimize the traditional loss function, and introduce Dropout method to improve the generalization ability of this model. The accuracy of the final model is maintained at over 96%. By comparing the experimental results with traditional machine learning algorithms and LSTM algorithms, the proposed algorithm effectively solves the problems of overfitting in machine learning and the need for manual screening to extract features, which greatly improves the accuracy of SQL injection detection.
1 February 2021 in Science of The Total Environment
The rising temperature makes the weather becoming more extreme. Understanding how extreme hot temperature-heat wave events (HWEs)-are likely to alter individual heat exposure and sensitivity is crucial for developing climate change mitigation and adaptation strategies. Despite the importance, little is known about the real-time impacts of HWEs on individual daily life in developing nations, like China. To fill this gap, we adopt over 1544 thousand Weibo (Chinese Twitter) social media data, coupled with meteorological conditions people face when posting, to assess the heat exposure and people's sensitivity to HWEs across 31 mega-cities in China. The results show the hotspot of Weibo heat is coincident with the extremely hot temperature, with a correlation of 0.7 (p < 0.05). The intensities, frequencies, and durations of HWEs in both geographical and social media space have high spatial heterogeneity. Its spatial variation can be explained by the type of climate zone and the unique geographical environment. The cities with extreme hot weather are more likely to adapt to the heatwave and less sensitivity to HWEs. The proposed framework, which integrates the real-time social media semantic analysis, statistical method, and spatial techniques, provides a new paradigm to assess the HWEs exposure and sensitivity analysis in China.
The use of social media data provided powerful data support to reveal the spatiotemporal characteristics and mechanisms of human activity, as it integrated rich spatiotemporal and textual semantic information. However, previous research has not fully utilized its semantic and spatiotemporal information, due to its technical and algorithmic limitations. The efficiency of the deep mining of textual semantic resources was also low. In this research, a multi-classification of text model, based on natural language processing technology and the Bidirectional Encoder Representations from Transformers (BERT) framework is constructed. The residents’ activities in Beijing were then classified using the Sina Weibo data in 2019. The results showed that the accuracy of the classifications was more than 90%. The types and distribution of residents’ activities were closely related to the characteristics of the activities and holiday arrangements. From the perspective of a short timescale, the activity rhythm on weekends was delayed by one hour as compared to that on weekdays. There was a significant agglomeration of residents’ activities that presented a spatial co-location cluster pattern, but the proportion of balanced co-location cluster areas was small. The research demonstrated that location conditions, especially the microlocation condition (the distance to the nearest subway station), were the driving factors that affected the resident activity cluster patterns. In this research, the proposed framework integrates textual semantic analysis, statistical method, and spatial techniques, broadens the application areas of social media data, especially text data, and provides a new paradigm for the research of residents’ activities and spatiotemporal behavior.
Air pollution seriously threats to human health. Understanding the health effects of air pollution is of great importance for developing countermeasures. However, little is known about the real-time impacts of air pollution on the human heath in a comprehensive way in developing nations, like China. To fill this research gap, the Chinese urbanites' health were sensed from more than 210.82 million Weibo (Chinese Twitter) data in 2017. The association between air pollution and the health sensing were quantified through generalized additive models, based on which the sensitivities and adaptions to air pollution in 70 China's cities were assessed. The results documented that the Weibo data can well sense urbanites' health in real time. With the different geographical characteristics and socio-economic conditions, the Chinese residents have adaption to air pollution, indicated by the spatial heterogeneity of the sensitivities to air pollution. Cities with good air quality in South China and East China were more sensitive to air pollution, while cities with worse air quality in Northwest China and North China were less sensitive. This research provides a new perspective and methodologies for health sensing and the health effect of air pollution.
Urban heatwaves increase residential health risks. Identifying urban residential sensitivity to heatwave risks is an important prerequisite for mitigating the risks through urban planning practices. This research proposes a new paradigm for urban residential sensitivity to heatwave risks based on social media Big Data, and describes empirical research in five megacities in China, namely, Beijing, Nanjing, Wuhan, Xi’an and Guangzhou, which explores the application of this paradigm to real-world environments. Specifically, a method to identify urban residential sensitive to heatwave risks was developed by using natural language processing (NLP) technology. Then, based on remote sensing images and Weibo data, from the perspective of the relationship between people (group perception) and the ground (meteorological temperature), the relationship between high temperature and crowd sensitivity in geographic space was studied. Spatial patterns of the residential sensitivity to heatwaves over the study area were characterized at fine scales, using the information extracted from remote sensing information, spatial analysis, and time series analysis. The results showed that the observed residential sensitivity to urban heatwave events (HWEs), extracted from Weibo data (Chinese Twitter), best matched the temporal trends of HWEs in geographic space. At the same time, the spatial distribution of observed residential sensitivity to HWEs in the cities had similar characteristics, with low sensitivity in the urban center but higher sensitivity in the countryside. This research illustrates the benefits of applying multi-source Big Data and intelligent analysis technologies to the understand of impacts of heatwave events on residential life, and provide decision-making data for urban planning and management.
Air pollution has brought about serious challenges to public health. With the limitations of available data, previous studies overlooked spatiotemporal heterogeneities in PM2.5-related health (PM2.5-RH) and multiple associated factors at the subdistrict scale. In this research, social media Weibo data was employed to extract PM2.5-RH based on the Bidirectional Encoder Representations from Transformers (BERT) model, in Beijing, China. Then, the relationship between PM2.5-RH and eight associated factors was qualified based on multi-source geospatial big data using Geographically Weighted Regression (GWR) models. The results indicate that the PM2.5-RH in the study area showed a spatial pattern of agglomeration to the city center and seasonal variation in the spatially non-stationary effects. The impacts of varied factors on PM2.5-RH were also spatiotemporally heterogeneous. Specifically, nighttime light (NTL), population density (PD) and the normalized difference built-up index (NDBI) had outstanding effects on PM2.5-RH in the four seasons, but with spatial disparities. The impact of the normalized difference vegetation index (NDVI) on PM2.5-RH was significant in summer, especially in the central urban areas, while in winter, the contribution of the air quality index (AQI) was increased. This research further demonstrates the feasibility of using social media data to indicate the effect of air pollution on public health and provides new insights into the seasonal impacts of associated driving factors on the health effects of air pollution.