# Construction of an Industrial Structure Analysis and Evaluation Model for Oil and Gas Resource-Based Cities Based on Deep Learning Model and Cluster Analysis

Authors: Shuran Deng
Journal: Mathematical Problems in Engineering
 (2022)

---

## Abstract

In the present time of resource integration, the industrial transformation of oil and gas resource-based cities has become inevitable. Through the qualitative and quantitative analysis of the current situation of industrial structure, the overweight of industrial structure is pointed out and reasonable suggestions are put forward for the existing problems. This paper constructs an industrial structure analysis and evaluation model for oil and gas resource-based cities based on deep learning model and cluster analysis. The transformation of traditional industries is a long process, and at present the oil and petrochemical industry should still be an important support for Daqing’s economic development, so more efforts should be made to extend the service life of oil fields and to get more funds and time for successive industries. Fine exploration is being carried out, relying on continuous innovation in exploration theory, methods, technology and management, and re-measuring old exploratory wells in fields that have already been explored.


---

## Body

## 1. Introduction

For historical and national industrial policy reasons, the focus of the petrochemical industry in Daqing has been on the production of fuel oil alone, with a short industrial chain and shallow processing levels, which has led Daqing into a strange circle of a single industrial structure [1]. There are generally two routes of oil processing, one is to process crude oil directly into refined oil products, and the other is to process crude oil into cracking materials [2]. Daqing should accelerate the development of supporting industries, extend the industrial chain, take the route of fine chemicals and strengthen the petrochemical industry [3].Increase investment in scientific research to improve the recovery rate of oil fields. Accelerate the development and application of high technology through cooperation with universities and research institutes to gain time for the development of successive industries [4]. Pay attention to the protection of oil resources, improve the efficiency of resource development and utilization, and strive to create a “century-old oilfield”, so as to provide the necessary accumulation and more time for the transformation of the city’s economy [5].Natural resources such as solar and wind energy have always been recognised worldwide as nonpolluting and cost-free renewable resources [6]. The use of solar energy was proposed as early as 1968. Daqing has an abundance of light, with 2,726 hours of sunshine per year, a total annual solar radiation of 491.4 KJ/cm2 and a high monsoon in spring and autumn, influenced by the cold inland Mongolian air and the warm ocean monsoon [7]. Under the dual pressure of the conventional energy shortage and the deterioration of the global ecological environment, Daqing should increase its independent research and development efforts, accelerate the use of solar and wind energy, continuously optimise the energy structure, improve the efficiency of energy use, and drive the development of related industries to ensure that energy does not become an obstacle to Daqing’s low-carbon transformation [8].On the basis of the oil and petrochemical industry, cultivate new succession industries, gradually invest the large amount of capital accumulated from the development of oil and gas resources and the petrochemical industry into succession industries, cultivate new leading industries, and thus complete the establishment of a diversified economic model as a whole [9]. On the one hand, the development of deep processing industries for agricultural and livestock products. Daqing is rich in arable land and grassland resources, therefore, according to the needs of the market, we can implement the strategy of “conversion of agriculture to animal husbandry” and vigorously develop the farming industry, at the same time, we can support the deep processing of agricultural products enterprises and develop green agriculture. On the other hand, the tertiary industry should be vigorously developed. The tertiary sector is a complex and mixed industry group, and it is important to scientifically determine the priorities and development of the tertiary sector, and to continue to exploit its advantages in order to build Daqing into a distribution and service centre in western Heilongjiang [10, 11].


## 2. Basic Information about Daqing City

Daqing is an oil and chemical capital, located in the western part of Heilongjiang Province, with a total area of 22,200 square kilometres, 5 districts, 3 counties, 1 autonomous county and 1 national high-tech industrial development zone, and is the largest oil production base and an important petrochemical industry base in China [12]. The added value of the city’s industry reached 305.91 billion yuan, an increase of 3.8% year-on-year, of which the added value of the regulated industry reached 241 billion yuan, an increase of 2.3% year-on-year; 40 million tons of crude oil and 3.51 billion cubic metres of natural gas were produced, with the added value of the oil industry reaching 178.8 billion yuan, a decrease of 0.1% year-on-year; the added value of the petrochemical industry reached 27.19 billion yuan, an increase of 7.1% year-on-year. The ratio of the three industries was 4.5 : 77 : 18.5, with the secondary industry dominating and ranking 11th in terms of comprehensive strength among the prefecture-level cities in China, as shown in Table 1[13].Table 1
Gross regional product of Daqing city, 2014.
IndexIndex valueYear on year growth (±%)Regional GDP40704.5Primary industry1858.5The secondary industry31333.7Construction3059.13.8The service sector; the tertiary industry73.9−1.3


## 3. Analysis of the Characteristics of the Industrial Structure in Daqing

### 3.1. Basic Characteristics of Daqing’s Industrial Structure

As a typical city of oil and gas resources, Daqing, while making a great contribution to the country, has also accumulated many problems of its own. As far as its industrial structure is concerned, the main problems in Daqing are [14].


#### 3.1.1. Declining Oil Production, Resulting in a Reduction of the Regional GDP

With the continuous exploitation of oil resources, it is an inevitable and objective fact that oil resources are decreasing. After 27 consecutive years of high and stable production of over 50 million tonnes of crude oil per year, Daqing oilfield has produced steadily for 11 years on the 40 million tonne plateau, with the recovery rate of the main oilfield exceeding 50%. It was estimated that the reduction in crude oil production and oil prices reduced Daqing’s GDP by RMB 84.91 billion in current prices. In constant prices, the reduction in crude oil production drove GDP growth down by 1.36 percentage points. According to the plan, the Daqing oilfield will reduce production by 1.5 million tonnes per year. As oil production decreases year after year, the GDP of Daqing will inevitably decline [15].


#### 3.1.2. A Single Industrial Structure, with Serious Implications for the Future Development of the City

Like most resource-based cities in China, Daqing has a single industrial structure, with secondary industries being the mainstay of its industrial structure, and the oil and petrochemical industry having the largest share in terms of industrial structure ratio. Daqing’s economic development is overly dependent on the oil industry, which makes it difficult to switch to other industries and has a weak multiplier effect. Oil as the leading industry drives the development of related industries with slow radiation, which is prone to economic deformation or decline [16].


#### 3.1.3. Scattered Industrial Structure and Difficulty in Urbanisation

Due to the constraints of oil and gas resources generation and exploitation, the exploration, development and refining sites are unevenly distributed and the urban agglomeration is poor. Usually, the city is concentrated on the construction of certain areas in good condition and in the right location, making it a relatively concentrated central living area, such as the early mining area of Jean-Houlou, and then connected by certain traffic routes, forming a cluster of districts, counties and towns in a dotted pattern. The overall layout of Daqing is therefore relatively fragmented, which does not facilitate the full use of some facilities and affects the urbanisation of the city [17].There are many other problems with the industrial structure of Daqing, such as the single structure of scientific and technological talents, the lack of awareness and the management system.


### 3.2. Empirical Analysis of Industrial Structure in Daqing

In order to make the analysis of the industrial structure of Daqing accurate and specific, this paper further analyses the basic characteristics and problems of the industrial structure of Daqing from a quantitative perspective, in addition to the qualitative description. Taking into account the scope of the indicators and the conditions of application, the following indicators have been selected.


#### 3.2.1. Industry Value Added Share

The value added share of industries in resource-based cities can be expressed by the following formula:(1)WIij=GijGi×100%,where Gij is the value added of industry j in region i and Gi is the total value added of industry in region i. Generally speaking, it is considered that the industry is likely to become the leading industry when it is WIij > 15%. As can be seen from Tables 2 and 3, the secondary industry accounts for 77% of the three industries in Daqing and 55% of the key industrial sectors above the scale, which is absolutely dominant. The petroleum and petrochemical industry accounts for 50.6% of the total regional GDP and 65.7% of the secondary industry. It can be seen that the industrial structure of Daqing is dominated by the secondary industry, especially by the petroleum and petrochemical industry, indicating the overweight and homogeneous nature of Daqing’s industrial structure.Table 2
Distribution of Daqing’s three industries in 2014 Unit: RMB billion.
IndexIndustrial added valueWIijPrimary industry1854.5%The secondary industry313377%The service sector; the tertiary industry75218.5%Table 3
Distribution of key industries in Daqing above-scale industry, 2014.
IndexIndustrial added valueWIijOil industry178844%Petrochemical industry271.97%Agricultural and sideline products processing industry98.32%Building materials industry30.11%Equipment manufacturing industry391%


#### 3.2.2. Value of Change in Industrial Structure

The value of the change in the industrial structure of a resource-based city can be expressed by the following formula:(2)K=∑i=1nqi1−qi0,where qi1 and qi0 are the shares of the output value of industry i in the total output value in the reporting period and the base period respectively. The value of industrial structure change, K, is an indicator of the rate of change of industrial structure, the larger the value, the greater the rate of change of industrial structure; conversely, the smaller the value [18].Using the data in Table4 to calculate the value of industrial structure change in Daqing City, we calculated the value of industrial structure change in Daqing City from 2011 to 2014 with the ratio of K2011 = 0.004, K2012 = 0.026, K2013 = 0.056 and K2014 = 0.104, which shows that the industrial structure of Daqing City tends to be constant.Table 4
Structure ratio of three industries in Daqing, 2010–2014.
Index20102011201220132014Gross output value of primary industry95132.9153.6175.6185Total output value of secondary industry2385.130703235.93318.43133Total output value of tertiary industry420537.4611687.5752Proportion of tertiary industrial structure3.3 : 82.2 : 14.53.5 : 82.1 : 14.43.8 : 80.9 : 15.34.2 : 79.4 : 16.44.5 : 77 : 18.5


#### 3.2.3. Industrial Structure Entropy Values

The entropy value of the industrial structure of a resource-based city can be expressed by the following formula:(3)et=∑i=1nWitln1Wit,where et is the entropy value of the industrial structure in period t, Witit is the proportion of the output value of industry i in period t, and n is the number of industrial sectors. The larger the entropy value of the industrial structure, the more balanced the industrial development is and the more diversified the development structure tends to be.Table4 was used to calculate the entropy value of the industrial structure of Daqing, see Table 5. From Table 6, it can be seen that the entropy value of the industrial structure of Daqing is on the rise between 2010 and 2014, but the value is small compared to the national entropy value of the industrial structure, indicating that the overall development of the industrial structure of Daqing tends to be homogeneous and uneven.Table 5
National structure ratio of three industries, 2010–2014.
Index20102011201220132014Gross output value of primary industry40533.647486.252373.65695758332Total output value of secondary industry187383.2220412.8235162249684.4271392Total output value of tertiary industry173596205205231934.5262203.8306739Proportion of tertiary industrial structure10.1 : 46.7 : 43.210 : 46.6 : 43.310.1 : 45.3 : 44.610 : 43.9 : 46.19.2 : 42.6 : 48.2Table 6
Industry structure entropy index values in Daqing and nationally, 2010–2014.
Particular yearDaqing cityWhole country20100.5430.949420110.5450.948720120.5580.950320130.6380.948420140.6530.9220


## 3.1. Basic Characteristics of Daqing’s Industrial Structure

As a typical city of oil and gas resources, Daqing, while making a great contribution to the country, has also accumulated many problems of its own. As far as its industrial structure is concerned, the main problems in Daqing are [14].


### 3.1.1. Declining Oil Production, Resulting in a Reduction of the Regional GDP

With the continuous exploitation of oil resources, it is an inevitable and objective fact that oil resources are decreasing. After 27 consecutive years of high and stable production of over 50 million tonnes of crude oil per year, Daqing oilfield has produced steadily for 11 years on the 40 million tonne plateau, with the recovery rate of the main oilfield exceeding 50%. It was estimated that the reduction in crude oil production and oil prices reduced Daqing’s GDP by RMB 84.91 billion in current prices. In constant prices, the reduction in crude oil production drove GDP growth down by 1.36 percentage points. According to the plan, the Daqing oilfield will reduce production by 1.5 million tonnes per year. As oil production decreases year after year, the GDP of Daqing will inevitably decline [15].


### 3.1.2. A Single Industrial Structure, with Serious Implications for the Future Development of the City

Like most resource-based cities in China, Daqing has a single industrial structure, with secondary industries being the mainstay of its industrial structure, and the oil and petrochemical industry having the largest share in terms of industrial structure ratio. Daqing’s economic development is overly dependent on the oil industry, which makes it difficult to switch to other industries and has a weak multiplier effect. Oil as the leading industry drives the development of related industries with slow radiation, which is prone to economic deformation or decline [16].


### 3.1.3. Scattered Industrial Structure and Difficulty in Urbanisation

Due to the constraints of oil and gas resources generation and exploitation, the exploration, development and refining sites are unevenly distributed and the urban agglomeration is poor. Usually, the city is concentrated on the construction of certain areas in good condition and in the right location, making it a relatively concentrated central living area, such as the early mining area of Jean-Houlou, and then connected by certain traffic routes, forming a cluster of districts, counties and towns in a dotted pattern. The overall layout of Daqing is therefore relatively fragmented, which does not facilitate the full use of some facilities and affects the urbanisation of the city [17].There are many other problems with the industrial structure of Daqing, such as the single structure of scientific and technological talents, the lack of awareness and the management system.


## 3.1.1. Declining Oil Production, Resulting in a Reduction of the Regional GDP

With the continuous exploitation of oil resources, it is an inevitable and objective fact that oil resources are decreasing. After 27 consecutive years of high and stable production of over 50 million tonnes of crude oil per year, Daqing oilfield has produced steadily for 11 years on the 40 million tonne plateau, with the recovery rate of the main oilfield exceeding 50%. It was estimated that the reduction in crude oil production and oil prices reduced Daqing’s GDP by RMB 84.91 billion in current prices. In constant prices, the reduction in crude oil production drove GDP growth down by 1.36 percentage points. According to the plan, the Daqing oilfield will reduce production by 1.5 million tonnes per year. As oil production decreases year after year, the GDP of Daqing will inevitably decline [15].


## 3.1.2. A Single Industrial Structure, with Serious Implications for the Future Development of the City

Like most resource-based cities in China, Daqing has a single industrial structure, with secondary industries being the mainstay of its industrial structure, and the oil and petrochemical industry having the largest share in terms of industrial structure ratio. Daqing’s economic development is overly dependent on the oil industry, which makes it difficult to switch to other industries and has a weak multiplier effect. Oil as the leading industry drives the development of related industries with slow radiation, which is prone to economic deformation or decline [16].


## 3.1.3. Scattered Industrial Structure and Difficulty in Urbanisation

Due to the constraints of oil and gas resources generation and exploitation, the exploration, development and refining sites are unevenly distributed and the urban agglomeration is poor. Usually, the city is concentrated on the construction of certain areas in good condition and in the right location, making it a relatively concentrated central living area, such as the early mining area of Jean-Houlou, and then connected by certain traffic routes, forming a cluster of districts, counties and towns in a dotted pattern. The overall layout of Daqing is therefore relatively fragmented, which does not facilitate the full use of some facilities and affects the urbanisation of the city [17].There are many other problems with the industrial structure of Daqing, such as the single structure of scientific and technological talents, the lack of awareness and the management system.


## 3.2. Empirical Analysis of Industrial Structure in Daqing

In order to make the analysis of the industrial structure of Daqing accurate and specific, this paper further analyses the basic characteristics and problems of the industrial structure of Daqing from a quantitative perspective, in addition to the qualitative description. Taking into account the scope of the indicators and the conditions of application, the following indicators have been selected.


### 3.2.1. Industry Value Added Share

The value added share of industries in resource-based cities can be expressed by the following formula:(1)WIij=GijGi×100%,where Gij is the value added of industry j in region i and Gi is the total value added of industry in region i. Generally speaking, it is considered that the industry is likely to become the leading industry when it is WIij > 15%. As can be seen from Tables 2 and 3, the secondary industry accounts for 77% of the three industries in Daqing and 55% of the key industrial sectors above the scale, which is absolutely dominant. The petroleum and petrochemical industry accounts for 50.6% of the total regional GDP and 65.7% of the secondary industry. It can be seen that the industrial structure of Daqing is dominated by the secondary industry, especially by the petroleum and petrochemical industry, indicating the overweight and homogeneous nature of Daqing’s industrial structure.Table 2
Distribution of Daqing’s three industries in 2014 Unit: RMB billion.
IndexIndustrial added valueWIijPrimary industry1854.5%The secondary industry313377%The service sector; the tertiary industry75218.5%Table 3
Distribution of key industries in Daqing above-scale industry, 2014.
IndexIndustrial added valueWIijOil industry178844%Petrochemical industry271.97%Agricultural and sideline products processing industry98.32%Building materials industry30.11%Equipment manufacturing industry391%


### 3.2.2. Value of Change in Industrial Structure

The value of the change in the industrial structure of a resource-based city can be expressed by the following formula:(2)K=∑i=1nqi1−qi0,where qi1 and qi0 are the shares of the output value of industry i in the total output value in the reporting period and the base period respectively. The value of industrial structure change, K, is an indicator of the rate of change of industrial structure, the larger the value, the greater the rate of change of industrial structure; conversely, the smaller the value [18].Using the data in Table4 to calculate the value of industrial structure change in Daqing City, we calculated the value of industrial structure change in Daqing City from 2011 to 2014 with the ratio of K2011 = 0.004, K2012 = 0.026, K2013 = 0.056 and K2014 = 0.104, which shows that the industrial structure of Daqing City tends to be constant.Table 4
Structure ratio of three industries in Daqing, 2010–2014.
Index20102011201220132014Gross output value of primary industry95132.9153.6175.6185Total output value of secondary industry2385.130703235.93318.43133Total output value of tertiary industry420537.4611687.5752Proportion of tertiary industrial structure3.3 : 82.2 : 14.53.5 : 82.1 : 14.43.8 : 80.9 : 15.34.2 : 79.4 : 16.44.5 : 77 : 18.5


### 3.2.3. Industrial Structure Entropy Values

The entropy value of the industrial structure of a resource-based city can be expressed by the following formula:(3)et=∑i=1nWitln1Wit,where et is the entropy value of the industrial structure in period t, Witit is the proportion of the output value of industry i in period t, and n is the number of industrial sectors. The larger the entropy value of the industrial structure, the more balanced the industrial development is and the more diversified the development structure tends to be.Table4 was used to calculate the entropy value of the industrial structure of Daqing, see Table 5. From Table 6, it can be seen that the entropy value of the industrial structure of Daqing is on the rise between 2010 and 2014, but the value is small compared to the national entropy value of the industrial structure, indicating that the overall development of the industrial structure of Daqing tends to be homogeneous and uneven.Table 5
National structure ratio of three industries, 2010–2014.
Index20102011201220132014Gross output value of primary industry40533.647486.252373.65695758332Total output value of secondary industry187383.2220412.8235162249684.4271392Total output value of tertiary industry173596205205231934.5262203.8306739Proportion of tertiary industrial structure10.1 : 46.7 : 43.210 : 46.6 : 43.310.1 : 45.3 : 44.610 : 43.9 : 46.19.2 : 42.6 : 48.2Table 6
Industry structure entropy index values in Daqing and nationally, 2010–2014.
Particular yearDaqing cityWhole country20100.5430.949420110.5450.948720120.5580.950320130.6380.948420140.6530.9220


## 3.2.1. Industry Value Added Share

The value added share of industries in resource-based cities can be expressed by the following formula:(1)WIij=GijGi×100%,where Gij is the value added of industry j in region i and Gi is the total value added of industry in region i. Generally speaking, it is considered that the industry is likely to become the leading industry when it is WIij > 15%. As can be seen from Tables 2 and 3, the secondary industry accounts for 77% of the three industries in Daqing and 55% of the key industrial sectors above the scale, which is absolutely dominant. The petroleum and petrochemical industry accounts for 50.6% of the total regional GDP and 65.7% of the secondary industry. It can be seen that the industrial structure of Daqing is dominated by the secondary industry, especially by the petroleum and petrochemical industry, indicating the overweight and homogeneous nature of Daqing’s industrial structure.Table 2
Distribution of Daqing’s three industries in 2014 Unit: RMB billion.
IndexIndustrial added valueWIijPrimary industry1854.5%The secondary industry313377%The service sector; the tertiary industry75218.5%Table 3
Distribution of key industries in Daqing above-scale industry, 2014.
IndexIndustrial added valueWIijOil industry178844%Petrochemical industry271.97%Agricultural and sideline products processing industry98.32%Building materials industry30.11%Equipment manufacturing industry391%


## 3.2.2. Value of Change in Industrial Structure

The value of the change in the industrial structure of a resource-based city can be expressed by the following formula:(2)K=∑i=1nqi1−qi0,where qi1 and qi0 are the shares of the output value of industry i in the total output value in the reporting period and the base period respectively. The value of industrial structure change, K, is an indicator of the rate of change of industrial structure, the larger the value, the greater the rate of change of industrial structure; conversely, the smaller the value [18].Using the data in Table4 to calculate the value of industrial structure change in Daqing City, we calculated the value of industrial structure change in Daqing City from 2011 to 2014 with the ratio of K2011 = 0.004, K2012 = 0.026, K2013 = 0.056 and K2014 = 0.104, which shows that the industrial structure of Daqing City tends to be constant.Table 4
Structure ratio of three industries in Daqing, 2010–2014.
Index20102011201220132014Gross output value of primary industry95132.9153.6175.6185Total output value of secondary industry2385.130703235.93318.43133Total output value of tertiary industry420537.4611687.5752Proportion of tertiary industrial structure3.3 : 82.2 : 14.53.5 : 82.1 : 14.43.8 : 80.9 : 15.34.2 : 79.4 : 16.44.5 : 77 : 18.5


## 3.2.3. Industrial Structure Entropy Values

The entropy value of the industrial structure of a resource-based city can be expressed by the following formula:(3)et=∑i=1nWitln1Wit,where et is the entropy value of the industrial structure in period t, Witit is the proportion of the output value of industry i in period t, and n is the number of industrial sectors. The larger the entropy value of the industrial structure, the more balanced the industrial development is and the more diversified the development structure tends to be.Table4 was used to calculate the entropy value of the industrial structure of Daqing, see Table 5. From Table 6, it can be seen that the entropy value of the industrial structure of Daqing is on the rise between 2010 and 2014, but the value is small compared to the national entropy value of the industrial structure, indicating that the overall development of the industrial structure of Daqing tends to be homogeneous and uneven.Table 5
National structure ratio of three industries, 2010–2014.
Index20102011201220132014Gross output value of primary industry40533.647486.252373.65695758332Total output value of secondary industry187383.2220412.8235162249684.4271392Total output value of tertiary industry173596205205231934.5262203.8306739Proportion of tertiary industrial structure10.1 : 46.7 : 43.210 : 46.6 : 43.310.1 : 45.3 : 44.610 : 43.9 : 46.19.2 : 42.6 : 48.2Table 6
Industry structure entropy index values in Daqing and nationally, 2010–2014.
Particular yearDaqing cityWhole country20100.5430.949420110.5450.948720120.5580.950320130.6380.948420140.6530.9220


## 4. Cluster Analysis and Deep Learning-Based Industrial Structure Optimisation

The precise and efficient allocation of the hundreds of associated oil manufacturing points is a key factor affecting the structure of the industry. In this paper, machine learning techniques are used to adjust the network configuration of oil manufacturing points in order to achieve uniform distribution of network service load among the capacity layer, coverage layer and wide and deep coverage layer according to the oil carrying capacity [19]. At the same time, oil types are classified according to the characteristics of urban oil production distribution, and personalised optimisation schemes are generated for different types of oil, and the load optimisation schemes can be updated automatically as the network service development changes. The process of industrial structure optimisation based on machine learning is shown in Figure 1.Figure 1
Machine learning-based industrial structure optimisation process.The data obtained are petroleum-grade data for a certain period of time, including public petroleum manufacturing point data, measurement report (MR) data, configuration data and performance data. The ETL (extract-transform-load) processing of the data is done based on the storage and computing resources of the Big Data platform, providing useable formatted data for subsequent analysis and modelling [20].The MR data are segmented according to RSRP (reference signal receiving power) strength, and the data are classified according to RSRP strength, reference signal receiving power, reference signal receiving power, reference signal receiving power, and reference signal receiving power. The two-dimensional curves are plotted according to RSRP strength and MR quantity, as shown in Figure2.Figure 2
Example of the distribution of MR sampling points in the RSRP intensity interval.The key features for oil scene classification were extracted from the MR data. The arithmetic mean, variance, kurtosis coefficient and skewness coefficient of each MR data were extracted. Using these four extracted features for scene delineation, the scene is automatically delineated using theK-means clustering algorithm, defining the number of oil as N, and the MR data of each oil has the above four features extracted, the data matrix is as follows:(4)x11x12x13x14x21x22x23x24…xN1xN2xN3xN4,where xij denotes the jth attribute of the i-th sector.First,K points are randomly selected from the data set as the initial cluster centres, then the distance between each sample and the cluster centre is calculated and the sample is assigned to the class in which the nearest cluster centre is located. Euclidean distance is used to calculate the distance between data objects:(5)distxi,xj=∑d=14xi,d−xj,d2.Update the class cluster centre: the average value of all data objects in the corresponding class cluster, i.e. the updated class cluster centre of that class cluster. Define the class cluster centre of the kth class cluster asCenterk, then the class cluster centre is updated as follows:(6)Centerk=1Ck∑xi∈Ckxi,where Ck is the kth class cluster and Ck is the number of data objects in the kth class cluster, the summation here is the sum of all elements in class cluster Ck over each column of attributes, so Centerk is also a vector with 4 attributes, denoted as(7)Centerk=Centerk,1,Centerk,2,…,Centerk,4.Iterations are continuously performed to reclassify the class clusters and update the class cluster centres, and the number of iterationsT is set, and the iteration is terminated after the T th iteration, at which point the resulting class clusters are the final clustering results.Based on the scenarios classified in (2), the impact of configuration oil manufacturing points on performance indicators and the implied relationship between configuration and performance data are explored in each scenario to adjust the wireless oil manufacturing points, improve network performance and enhance the network KPI (key performance indicator). A DNN (deep neural network) model is used to learn the intrinsic relationship between the configured oil manufacturing points and the performance indicator oil manufacturing points to obtain a trained and stable neural network model.Define the configuration of oil manufacturing pointsX to include the whole set of oil manufacturing points of the entire oil group, including the resource configuration oil manufacturing points, frequency configuration oil manufacturing points and boundary level configuration oil manufacturing points of each oil it contains, etc. The matrix containing m frequency points and n oil manufacturing points per frequency point can be expressed as(8)X=x11x12…x1nx21x22…x2n…xm1xm2…xmn,where xmn denotes the nth oil manufacturing point for the mth frequency point. If the network structure of F1D1D2FDD 900 MHz contains 4 frequency points and each frequency point has 12 oil manufacturing points configuration data, the size of the X matrix is (4, 12).The performance indicator oil manufacturing pointY is the determination indicator data of the industrial structure of the oil group, which may include: the maximum number of connected users of RRC (radio resource control), the utilization rate of uplink PRB (physical resource block) and downlink PRB utilization rate of each frequency point included in the oil group, including m frequency points, each frequency point has k oil manufacturing points, and the matrix size is (m, k), which can be expressed as(9)Y=y11y12⋯y1ky21y22⋯y2k⋯ym1ym2⋯ymk,where ymk is the kth load indicator data for the mth frequency point. If the network structure of F1D1D2FDD 900 MHz contains 4 frequency points, each with 3 indicator data, the size of the Y matrix is (4, 3).The relationship between performance metrics and configured oil manufacturing points is investigated and the problem is modelled as a multivariate regression problem. The intrinsic relationship of the regression problem is learnt using a fully connected neural network algorithm model, using training data to train the neural network model. The input isX. The data in X is read in and converted to a column matrix as the input to the neural network, and similarly the Y matrix is converted to a column matrix as the output of the neural network.The output of the regression problem,Y, contains multiple variables, so the cost function is designed based on this problem as(10)MSEy,y′=∑i=1lyi−yi′2l,where yi is the sample data and yi′ is the predicted value calculated by the neural network.The average of MSE (mean squared error) of each variable is used as the loss function, and the cost function of the network is minimized by training the model, adjusting the weights and bias, thus obtaining a stable neural network model [21].


## 5. Model Training and Results Analysis

According to the oil scene classification method proposed above, the oil scene is classified using MR data. The scene is automatically classified using the K-means clustering algorithm, and the time complexity of the algorithm isO(t × k × m × n) and the space complexity is O(m × (n + k)), where t is the number of iterations, k is the number of clusters, m is the number of features and n is the number of samples [22, 23]. Generally t, k and m can be considered as constants, so the time and space complexity can be simplified to O(n). The mean value of MR statistics for each category is found, and the distribution of the mean value of MR statistics for each scene category is shown in Figure 3.Figure 3
Mean distribution of MR statistics by scenario category.The model of the relationship between configuration oil manufacturing points and performance oil manufacturing points was trained for each of the four types of oil scenarios, and the deep learning algorithm model was used to learn the intrinsic relationship between configuration oil manufacturing points and performance index oil manufacturing points. The complexity of the DNN algorithm is mainly determined by the number of hidden layers, hidden units and samples. The evaluation indexes of the DNN model are shown in Table7, and the evaluation results show that the deep learning algorithm has a good fit to the data and the error between the predicted data and the real data is small.Table 7
DNN model evaluation metrics.
Evaluating indicatorPerformance parameterClass A scenarioClass B scenarioClass C scenarioClass D scenarioMAEF10.05030510.0850690.083260.072D10.075814530.0813560.09030.0974D20.049532810.0623310.059160.0634FDD900 MHz0.06624230.0560630.077290.082MSEF10.004713820.0120490.014590.0086D10.009467740.01045740.011830.0152D20.004050080.0070630.005610.0069FDD900 MHz0.00695520.0049950.009560.0116R-squaredF10.041087960.0729580.111810.1228D10.287457440.2870980.233280.1461D20.29602210.1974560.290420.1505FDD900 MHz0.162224460.2265270.252510.0653The optimisation search is performed based on the trained DNN model, and the optimized configuration recommendations and tuning effect prediction results are output. The problem is transformed into a hill-climbing algorithm to solve the multi-dimensional constrained optimisation problem, and the optimized configuration recommendations and tuning prediction results are shown in Table8. The oil scenario selected in this paper is F1D1D2FDD 900 MHz, where F1, D1 and D2 are all 20 MHz bandwidth in the existing network, and FDD 900 MHz is 5 MHz bandwidth. Therefore, the closer the amount of services carried by the four frequency points is to the bandwidth ratio, the better the service balance is.Table 8
Optimisation proposals and predicted results of adjustment effects.
ResultClass A scenarioClass B scenarioClass C scenarioClass D scenarioOptimize configuration parameters−103−109−107−110−101−103−99−92−87−93−86−101−98−101−98−88−88−85−84−96Business forecast proportionF10.3050.3110.306D10.3050.3110.306D20.3100.3110.298FDD 900 MHz0.0770.0710.068Relying on the provincial big data platform and the resource capacity of the cloud resource pool, the above for the oil scenario segmentation, DNN model training and optimal configuration of oil manufacturing point solution are all done on the offline side, which is a light-weight operation. The efficiency of the online deployment part depends mainly on the number of samples, which is much less complex compared to the offline side, and is more beneficial for real-time and efficient oil manufacturing point optimisation. The current manual configuration solution is labour- and time-consuming and has a low percentage of improvement for load-unbalanced oil. Test results show that the machine learning-based load optimisation solution can achieve fine-grained load sharing according to the bandwidth capacity of the oil, and the improvement ratio of oil with unbalanced load reaches over 90%, saving a lot of manpower while improving the accuracy of load optimisation.


## 6. Conclusion

This paper presents a cluster analysis and deep learning-based solution for the industrial structure of oil cities. At the same time, the development of the load optimisation system and the validation of the existing network have been carried out jointly with the manufacturer. In the selected test grid for the poor load optimisation of the existing network, the oil is tested and validated in the existing network, and the test improvement ratio can reach 90%. The system truly combines machine learning with industrial economic optimisation, forming a technical solution for network oil manufacturing point tuning based on machine learning, and exploring a dynamic urban industrial adaptive load optimisation solution with more refined oil granularity and time granularity.



---

*Source: 2179494-2022-04-07.xml*