CN111813831A - Method, equipment and readable medium for presuming substation to which communication base station belongs - Google Patents
Method, equipment and readable medium for presuming substation to which communication base station belongs Download PDFInfo
- Publication number
- CN111813831A CN111813831A CN202010661204.5A CN202010661204A CN111813831A CN 111813831 A CN111813831 A CN 111813831A CN 202010661204 A CN202010661204 A CN 202010661204A CN 111813831 A CN111813831 A CN 111813831A
- Authority
- CN
- China
- Prior art keywords
- communication base
- base station
- substation
- station belongs
- base stations
- 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.)
- Granted
Links
- 238000004891 communication Methods 0.000 title claims abstract description 236
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000012423 maintenance Methods 0.000 claims description 19
- 239000013598 vector Substances 0.000 claims description 5
- 238000012544 monitoring process Methods 0.000 claims description 4
- 238000004590 computer program Methods 0.000 claims description 3
- 238000012790 confirmation Methods 0.000 abstract description 3
- 206010017472 Fumbling Diseases 0.000 abstract 1
- XEEYBQQBJWHFJM-UHFFFAOYSA-N Iron Chemical compound [Fe] XEEYBQQBJWHFJM-UHFFFAOYSA-N 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000010248 power generation Methods 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
- 229910052742 iron Inorganic materials 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- 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
- G06F16/285—Clustering or classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/23—Clustering techniques
- G06F18/232—Non-hierarchical techniques
- G06F18/2321—Non-hierarchical techniques using statistics or function optimisation, e.g. modelling of probability density functions
-
- 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—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Probability & Statistics with Applications (AREA)
- Business, Economics & Management (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Primary Health Care (AREA)
- Evolutionary Biology (AREA)
- Bioinformatics & Computational Biology (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Artificial Intelligence (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Evolutionary Computation (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Remote Monitoring And Control Of Power-Distribution Networks (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method, equipment and a readable medium for presuming a substation to which a communication base station belongs, wherein the method comprises the following steps: acquiring key information of all communication base stations and a corresponding relation table of known communication base stations and transformer substations to which the known communication base stations belong according to historical power failure record information of all communication base stations; generating the key information of all the communication base stations into data clusters through a clustering algorithm, wherein each cluster formed by clustering represents all the communication base station sets with power failure at the same time; and traversing each data cluster, and inferring the substation to which the unknown communication base station belongs according to the corresponding relation table of the known communication base station and the substation to which the known communication base station belongs in the data cluster. According to the method for estimating the substation to which the communication base station belongs, the known communication base station is used for estimating the substation to which the unknown communication base station belongs, the problem that the substation to which the communication base station belongs is difficult to confirm in a complex environment is solved, the fumbling workload of maintainers is reduced, and the confirmation efficiency of the substation to which the communication base station belongs is improved.
Description
Technical Field
The present invention relates to the field of communications technologies, and in particular, to a method, a device, and a readable medium for estimating a substation to which a communication base station belongs.
Background
To ensure high quality wireless communication services, communication infrastructure providers need to provide 24 hours of uninterrupted power to the communication base stations. When a power supply company is in planned power failure, a large number of communication base stations are often powered off at the same time, and great pressure is brought to the maintenance of the base stations.
The patent with the application number of CN201911258254.2 discloses an iron tower energy intelligent scheduling system, which comprises a scheduling platform, a data collector and scheduling resources; and the power supply stability of the communication base station is ensured by automatically scheduling resources. Communication infrastructure service providers usually perform power emergency automatic scheduling through manual scheduling or by using a scheduling system or a similar system as described in the above patent, however, no matter what scheduling method is adopted, the scheduling is premised on knowing the substation to which each communication base station belongs; in the existing solution, a maintainer searches for a substation to which a power connection position of a base station belongs station by station, then registers the substation in a book, and when a power supply company issues a planned power failure notification, the maintainer performs power generation and standby work of the relevant base station in advance, so that the influence caused by power failure is finally reduced. However, the power supply company has complex power grid routing and wide base station distribution positions, and maintenance personnel can only confirm the substation to which a part of base station electricity-leading positions belong.
In summary, the existing communication base station has the problem that the substation is difficult to confirm.
Disclosure of Invention
In order to solve the problem that the existing communication base station is difficult to confirm in the substation, the invention provides a method, equipment and a readable medium for estimating the substation to which the communication base station belongs, wherein the method for estimating the substation to which the communication base station belongs comprises a known communication base station and an unknown communication base station, the known communication base station records the communication base station corresponding to the substation to which the known communication base station belongs, and the unknown communication base station does not record the communication base station corresponding to the substation to which the unknown communication base station belongs, and the method comprises the following steps:
s100, acquiring key information of all communication base stations and a corresponding relation table of known communication base stations and transformer substations to which the known communication base stations belong according to historical power failure record information of all communication base stations;
s200, generating the key information of all the communication base stations into data clusters through a clustering algorithm, wherein each cluster formed by clustering represents all the communication base station sets with power failure at the same time;
s300, traversing each data cluster, and presuming the substation to which the unknown communication base station belongs according to the corresponding relation table of the known communication base station and the substation to which the known communication base station belongs.
Further, the step S100 includes the steps of:
s101, downloading historical power failure warning lists of all communication base stations from an operation and maintenance monitoring system;
and S102, retaining three types of key information, namely station address codes, district and county information and power failure information in the historical power failure warning list.
Further, the step S200 includes the steps of:
s201, establishing power failure characteristic vectors of all communication base stations according to three types of key information, namely station address codes, district and county information and power failure information;
and S202, generating the data clusters of all communication base stations with power failure by using the feature vectors through a clustering algorithm.
Further, the clustering algorithm is a DBSCAN clustering algorithm.
Further, the specific steps of generating the data cluster by using the DBSCAN clustering algorithm are as follows:
s2011, constructing the key information of all the communication base stations into a format of DBSCAN input parameters; wherein, each piece of key information is arranged into metadata with the format of site code, district code and power failure occurrence time;
s2012, collecting all metadata to form a set;
s2013, clustering by using a set formed by key information as input data and using a DBSCAN algorithm to generate and output a text-format clustering result;
in the clustering algorithm, the number of the minimum clusters in the clustering parameters is set to be 5, and the maximum distance is set to be 2.
Further, the step S300 includes the steps of:
s301, traversing each data cluster, and counting the occurrence frequency of the transformer substation to which the known communication base station belongs in each data cluster;
and S302, taking the transformer substation with the highest occurrence frequency of the transformer substations in each data cluster as the transformer substation to which the unknown communication base station belongs in the data cluster.
Further, the step S300 includes the steps of:
s301, traversing each data cluster, and counting the occurrence frequency of the transformer substation to which the known communication base station belongs in each data cluster;
and S302, taking the transformer substation with the highest occurrence frequency of the transformer substations in each data cluster as the transformer substation to which all communication base stations in the data cluster belong.
Further, when the same communication base station appears in a plurality of clusters, traversing all the clusters to obtain the corresponding times of the communication base station and the transformer substation, and taking the transformer substation with the highest numerical value of the times as the transformer substation to which the communication base station belongs.
The present invention further provides an apparatus for estimating a substation to which a communication base station belongs, the apparatus including:
the information acquisition module is used for acquiring key information of all communication base stations and a corresponding relation table of known communication base stations and the transformer substation to which the known communication base stations belong according to historical power failure record information of all communication base stations;
the information clustering module is used for generating data clusters from the key information of all the communication base stations through a clustering algorithm, and each cluster formed by clustering represents all the communication base station sets with power failure at the same time;
and the transformer substation conjecture module is used for traversing each data cluster and conjecturing the transformer substation to which the unknown communication base station belongs according to the corresponding relation table of the known communication base station and the transformer substation to which the known communication base station belongs.
The present invention also provides a computer readable storage medium having stored thereon computer program code which, when executed by a computer, performs a method as any of the above.
According to the method for presuming the substation to which the communication base station belongs, the key information of all the communication base stations is generated into all the communication base station sets which are powered off at the same time through the clustering algorithm, each set is traversed, and the unknown substation to which the communication base station belongs is presumed through the communication base stations which are recorded in the sets and correspond to the substation to which the communication base station belongs, so that the difficulty of confirming the substation to which the communication base station belongs by maintenance personnel is greatly reduced, the problem that the substation to which the communication base station belongs is difficult to confirm under a complex environment is solved, the research workload of the maintenance personnel is reduced, and the confirmation efficiency of the substation to which the communication base station belongs is.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a flowchart of a method for estimating a substation to which a communication base station belongs according to the present invention;
FIG. 2 is a flow chart of a method of obtaining key information;
FIG. 3 is a flow chart of a method of generating a data cluster;
FIG. 4 is a flow chart of a method for inferring unknown communication stations from known communication stations;
FIG. 5 is a flow chart of a method for inferring all communication stations based on a known communication station;
FIG. 6 is a diagram of clustering results in text format;
fig. 7 is an architecture diagram of a substation to which a communication base station belongs.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention provides a method, equipment and a readable medium for estimating a substation to which a communication base station belongs, wherein the method for estimating the substation to which the communication base station belongs comprises a known communication base station and an unknown communication base station, the known communication base station records the communication base station of the substation to which the known communication base station corresponds, and the unknown communication base station does not record the communication base station of the substation to which the unknown communication base station corresponds, and the method comprises the following steps:
s100, acquiring key information of all communication base stations and a corresponding relation table of known communication base stations and transformer substations to which the known communication base stations belong according to historical power failure record information of all communication base stations;
s200, generating the key information of all the communication base stations into data clusters through a clustering algorithm, wherein each cluster formed by clustering represents all the communication base station sets with power failure at the same time;
s300, traversing each data cluster, and presuming the substation to which the unknown communication base station belongs according to the corresponding relation table of the known communication base station and the substation to which the known communication base station belongs.
In specific implementation, as shown in fig. 1 to fig. 3, all communication base stations are divided into two types, known communication base stations and unknown communication base stations; the known communication base station is a communication base station which records the corresponding substation, wherein the known communication base station can be known and recorded in a book through groping by maintenance personnel or other channels; the unknown communication base station is a communication base station which does not record the corresponding substation; the method for presuming the substation to which the communication base station belongs comprises the following steps:
firstly, downloading a historical power failure alarm list (namely historical power failure record information) of all communication base stations from an operation and maintenance monitoring system, and extracting key information in the historical power failure alarm list; preferably, in the embodiment, three types of key information, namely, a station address code, an administrative district and a power failure occurrence time, are extracted; the operation and maintenance monitoring system is a platform for a communication company to monitor the running state of the base station in real time and can record historical power failure records of all communication base stations. It should be noted that, but not limited to, java.
Secondly, establishing power failure characteristic vectors of all communication base stations by using three types of key information, namely station address codes, counties and power failure information, converting the key information into data clusters through a clustering algorithm, and enabling each cluster formed by clustering to represent all communication base station sets with power failure at the same time;
and finally, traversing each data cluster, and inferring the substation to which the unknown communication base station belongs in the data cluster by using the corresponding relation between the known communication base station in the data cluster and the substation.
According to the method for presuming the substation to which the communication base station belongs, the key information of all the communication base stations is generated into all the communication base station sets which are powered off at the same time through the clustering algorithm, each set is traversed, and the unknown substation to which the communication base station belongs is presumed through the communication base stations which are recorded in the sets and correspond to the substation to which the communication base station belongs, so that the difficulty of confirming the substation to which the communication base station belongs by maintenance personnel is greatly reduced, the problem that the substation to which the communication base station belongs is difficult to confirm under a complex environment is solved, the research workload of the maintenance personnel is reduced, and the confirmation efficiency of the substation to which the communication base station belongs is.
Preferably, the clustering algorithm is a DBSCAN clustering algorithm.
Preferably, the specific steps of generating the data cluster by using the DBSCAN clustering algorithm are as follows:
s2011, constructing the extracted key information of all the communication base stations into a format of DBSCAN input parameters; wherein, each piece of key information is arranged into metadata with the format of site code, district code and power failure occurrence time;
s2012, collecting all metadata to form a data set;
s2021, clustering by using a data set formed by key information as input data and using a DBSCAN algorithm to generate and output a text-format clustering result;
in the clustering algorithm, according to experience, the number of the minimum clusters in the clustering parameters is set to be 5, and the maximum distance is set to be 2; the clustering result in the output text format is shown in fig. 6, where metadata in the same data cluster are adjacent to each other, and a blank line is another data cluster.
Preferably, in order to solve the problem that the existing communication base station is difficult to confirm in the substation, the step S300 specifically includes the following steps:
s301, traversing each data cluster, and counting the occurrence frequency of the transformer substation to which the known communication base station belongs in each data cluster;
and S302, taking the transformer substation with the highest occurrence frequency of the transformer substations in each data cluster as the transformer substation to which the unknown communication base station belongs in the data cluster.
In the specific implementation, as shown in fig. 4, in the above method steps, in the set of communication base stations with power failure, the substation corresponding to one part of the base stations can be confirmed by the field layout of the maintenance personnel, and the other part of the substation is difficult to confirm, and the communication base station of the confirmed substation is used for estimating the unknown communication base station; for example: and 5 communication base stations are arranged in one data cluster, the communication base stations are powered off in sequence within a certain very short time, and if 2 communication base stations are known to correspond to the substation A, the substations corresponding to the other 3 communication base stations are also known to be A. Through the steps of the method, the unknown communication base station is presumed according to the known communication base station, so that the problem that part of the communication base stations are difficult to confirm is solved, and the difficulty of confirming the transformer substation to which the communication base station belongs by maintenance personnel is reduced.
Preferably, in order to solve the problem that the maintenance personnel mistakenly makes the substation to which the communication base station belongs due to negligence and the like, the step S300 may specifically include:
s301, traversing each data cluster, and counting the occurrence frequency of the transformer substation to which the known communication base station belongs in each data cluster;
and S302, taking the transformer substation with the highest occurrence frequency of the transformer substations in each data cluster as the transformer substation to which all communication base stations in the data cluster belong.
In the specific implementation, as shown in fig. 5, in the above method steps, in the set of communication base stations with power failure, the substation corresponding to one part of the base stations can be confirmed by the field layout of the maintenance personnel, and the other part of the substation is difficult to confirm, and all the communication base stations in the set are estimated by using the communication base stations of the confirmed substation; for example: the method comprises the following steps that 5 communication base stations are arranged in one data cluster, the communication base stations are powered off in sequence in a certain very short time, and it is known that 2 communication base stations correspond to a substation to which the communication base stations belong, and 1 communication base station corresponds to a substation to which the communication base stations are wrongly recorded as B by maintenance personnel, but the maintenance personnel do not find the mistake; because the number of times of occurrence of the substation A in the data cluster is the largest, the substation A is used as the substation of all communication base stations in the data cluster, namely, the substations corresponding to 5 communication base stations are all A. Through the steps of the method, the wrong corresponding relation between the individual communication base station and the transformer substation caused by negligence of maintenance personnel and the like is corrected, and the accuracy of presuming the transformer substation to which the communication base station belongs is improved.
Preferably, when the same communication base station is present in a plurality of data clusters, the communication base station may obtain the result of the conflicting affiliated substation in different data clusters, so that the communication base station cannot confirm the affiliated substation, and in order to solve the above problem and improve the accuracy of the inference, the following method is proposed: and traversing all the data clusters to obtain the corresponding times of the communication base station and the transformer substation, and taking the transformer substation with the highest numerical value as the transformer substation to which the communication base station belongs.
In specific implementation, it is assumed that the communication base station 1 appears in the data cluster 1 and the data cluster 2 at the same time, and it is known that the substation a appears 2 times and the substation B appears 1 time in the data cluster 1, and the information of the substation a recorded in the data cluster 1 is recorded by the maintainer in error, but is not found by the maintainer; if the substation B appears 2 times and the substation C appears 1 time in the data cluster 2, and the substation with the highest occurrence frequency in the data cluster is taken as the substation of the communication base station 1, two conflicting conjecture results can be obtained; the substation to which the communication base station 1 belongs is presumed to be A according to the data cluster 1, the substation to which the communication base station 1 belongs is presumed to be B according to the data cluster 2, and different presumed results are presumed according to different data clusters, so that the communication base station 1 cannot confirm the substation to which the communication base station belongs.
In the method, when the communication base station 1 appears in a plurality of data clusters, the appearance times of the transformer substation A, the transformer substation B and the transformer substation C are respectively accumulated, 2 times of appearance of the transformer substation A, 3 times of appearance of the transformer substation B and 1 time of appearance of the transformer substation C are obtained through statistics, and the transformer substation B with the highest current number is taken out to serve as the transformer substation to which the communication base station 1 belongs; through the steps of the method, the error correspondence between the individual communication base station and the transformer substation caused by negligence and the like of maintenance personnel can be corrected, and the accuracy of presuming the transformer substation to which the communication base station belongs is further improved.
In actual application, as shown in fig. 7, a worker of a communication company may manually download historical outage record information of a communication base station, and form a more complete and correct correspondence table of the communication base station and the substation by calling a substation inference program to which the base station belongs in combination with correspondence of the communication base station and the substation confirmed by a maintainer. When a power supply company issues a plan to stop power supply and supply power, relevant personnel can check the correspondence table of the communication base stations and the transformer substation, so that the communication base stations which need to be prepared for power generation and standby power supply can be known in advance.
The present invention further provides an apparatus for estimating a substation to which a communication base station belongs, the apparatus including:
the information acquisition module is used for acquiring key information of all communication base stations and a corresponding relation table of known communication base stations and the transformer substation to which the known communication base stations belong according to historical power failure record information of all communication base stations;
the information clustering module is used for generating data clusters from the key information of all the communication base stations through a clustering algorithm, and each cluster formed by clustering represents all the communication base station sets with power failure at the same time;
and the transformer substation conjecture module is used for traversing each data cluster and conjecturing the transformer substation to which the unknown communication base station belongs according to the corresponding relation table of the known communication base station and the transformer substation to which the known communication base station belongs.
The present invention also provides a computer readable storage medium having stored thereon computer program code which, when executed by a computer, performs a method as any of the above.
Although terms such as known and unknown communication base stations are used more often herein, the possibility of using other terms is not excluded. These terms are used merely to more conveniently describe and explain the nature of the present invention; they are to be construed as being without limitation to any additional limitations that may be imposed by the spirit of the present invention.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for estimating a substation to which a communication base station belongs comprises a known communication base station and an unknown communication base station, wherein the known communication base station records the communication base station corresponding to the substation to which the known communication base station belongs, and the unknown communication base station does not record the communication base station corresponding to the substation to which the unknown communication base station belongs, and is characterized by comprising the following steps:
s100, acquiring key information of all communication base stations and a corresponding relation table of known communication base stations and transformer substations to which the known communication base stations belong according to historical power failure record information of all communication base stations;
s200, generating the key information of all the communication base stations into data clusters through a clustering algorithm, wherein each cluster formed by clustering represents all the communication base station sets with power failure at the same time;
s300, traversing each data cluster, and presuming the substation to which the unknown communication base station belongs according to the corresponding relation table of the known communication base station and the substation to which the known communication base station belongs.
2. The method for estimating a substation to which a communication base station belongs according to claim 1, wherein the step S100 comprises the steps of:
s101, downloading historical power failure warning lists of all communication base stations from an operation and maintenance monitoring system;
and S102, retaining three types of key information, namely station address codes, district and county information and power failure information in the historical power failure warning list.
3. The method of estimating a substation to which a communication base station belongs according to claim 2, wherein the step S200 comprises the steps of:
s201, establishing power failure characteristic vectors of all communication base stations according to three types of key information, namely station address codes, district and county information and power failure information;
and S202, generating the data clusters of all communication base stations with power failure by using the feature vectors through a clustering algorithm.
4. The method of inferring a substation to which a communication base station belongs according to claim 3, characterized in that: the clustering algorithm is a DBSCAN clustering algorithm.
5. The method for presuming the substation to which the communication base station belongs according to claim 4, wherein the specific steps of generating the data cluster by using the DBSCAN clustering algorithm are as follows:
s2011, constructing the key information of all the communication base stations into a format of DBSCAN input parameters; wherein, each piece of key information is arranged into metadata with the format of site code, district code and power failure occurrence time;
s2012, collecting all metadata to form a set;
s2021, clustering by using a set formed by key information as input data and using a DBSCAN algorithm to generate and output a text-format clustering result;
in the clustering algorithm, the number of the minimum clusters in the clustering parameters is set to be 5, and the maximum distance is set to be 2.
6. The method of inferring a substation to which a communication base station belongs according to claim 1, characterized in that: the step S300 includes the steps of:
s301, traversing each data cluster, and counting the occurrence frequency of the transformer substation to which the known communication base station belongs in each data cluster;
and S302, taking the transformer substation with the highest occurrence frequency of the transformer substations in each data cluster as the transformer substation to which the unknown communication base station belongs in the data cluster.
7. The method of inferring a substation to which a communication base station belongs according to claim 1, characterized in that: the step S300 includes the steps of:
s301, traversing each data cluster, and counting the occurrence frequency of the transformer substation to which the known communication base station belongs in each data cluster;
and S302, taking the transformer substation with the highest occurrence frequency of the transformer substations in each data cluster as the transformer substation to which all communication base stations in the data cluster belong.
8. The method for estimating the substation to which the communication base station belongs according to any one of claims 1 to 7, wherein when the same communication base station appears in a plurality of clusters, all clusters are traversed to obtain the corresponding times of the communication base station and the substation, and the substation with the highest numerical value is taken as the substation to which the communication base station belongs.
9. An apparatus for presuming a substation to which a communication base station belongs, the apparatus comprising:
the information acquisition module is used for acquiring key information of all communication base stations and a corresponding relation table of known communication base stations and the transformer substation to which the known communication base stations belong according to historical power failure record information of all communication base stations;
the information clustering module is used for generating data clusters from the key information of all the communication base stations through a clustering algorithm, and each cluster formed by clustering represents all the communication base station sets with power failure at the same time;
and the transformer substation conjecture module is used for traversing each data cluster and conjecturing the transformer substation to which the unknown communication base station belongs according to the corresponding relation table of the known communication base station and the transformer substation to which the known communication base station belongs.
10. A computer-readable storage medium characterized by: the storage medium has stored thereon computer program code which, when executed by a computer, performs the method of any of claims 1-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010661204.5A CN111813831B (en) | 2020-07-10 | 2020-07-10 | Method, device and readable medium for presuming substation to which communication base station belongs |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010661204.5A CN111813831B (en) | 2020-07-10 | 2020-07-10 | Method, device and readable medium for presuming substation to which communication base station belongs |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111813831A true CN111813831A (en) | 2020-10-23 |
| CN111813831B CN111813831B (en) | 2022-10-14 |
Family
ID=72842114
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010661204.5A Active CN111813831B (en) | 2020-07-10 | 2020-07-10 | Method, device and readable medium for presuming substation to which communication base station belongs |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111813831B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115147943A (en) * | 2022-06-01 | 2022-10-04 | 中国铁塔股份有限公司厦门市分公司 | Parking intelligent charging method and system based on second-hand car trading market |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016116734A1 (en) * | 2015-01-20 | 2016-07-28 | Tumbling Dice Limited | Improvements in and relating to network analysis |
| CN108243426A (en) * | 2016-12-26 | 2018-07-03 | 中国移动通信集团设计院有限公司 | A kind of method and server of determining wireless base station demand point |
| CN110912272A (en) * | 2019-12-03 | 2020-03-24 | 合肥工业大学 | Urban power grid fault detection method and system based on regional abnormal pattern recognition |
| CN111178932A (en) * | 2019-11-26 | 2020-05-19 | 深圳壹账通智能科技有限公司 | User geographic portrait generation method and device, computer equipment and storage medium |
-
2020
- 2020-07-10 CN CN202010661204.5A patent/CN111813831B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016116734A1 (en) * | 2015-01-20 | 2016-07-28 | Tumbling Dice Limited | Improvements in and relating to network analysis |
| CN108243426A (en) * | 2016-12-26 | 2018-07-03 | 中国移动通信集团设计院有限公司 | A kind of method and server of determining wireless base station demand point |
| CN111178932A (en) * | 2019-11-26 | 2020-05-19 | 深圳壹账通智能科技有限公司 | User geographic portrait generation method and device, computer equipment and storage medium |
| CN110912272A (en) * | 2019-12-03 | 2020-03-24 | 合肥工业大学 | Urban power grid fault detection method and system based on regional abnormal pattern recognition |
Non-Patent Citations (1)
| Title |
|---|
| 刘承萍: "变电站综合自动化系统远动指标统计算法", 《自动化与仪器仪表》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115147943A (en) * | 2022-06-01 | 2022-10-04 | 中国铁塔股份有限公司厦门市分公司 | Parking intelligent charging method and system based on second-hand car trading market |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111813831B (en) | 2022-10-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108536770B (en) | Distribution network ring net automatic generation method based on distribution GIS model | |
| CN109120464A (en) | Secondary equipment of intelligent converting station configuration information remote online control device | |
| CN105305393A (en) | Distribution network emergency repair commanding system and method based on marketing and distribution communication | |
| CN103683511A (en) | Method and system for processing fault of integrated monitoring platform based on power distribution network | |
| CN106655523A (en) | Smart electric service system | |
| CN110866735A (en) | Method and system for positioning switch of distribution network line contact point by using GIS model and readable storage medium | |
| CN109933634B (en) | Power system graph drawing method based on power radiation range | |
| CN103065269A (en) | Marketing-distribution master data management system | |
| CN104104151A (en) | Access method of power distribution terminal equipment information | |
| CN110058126A (en) | Distribution network failure judgment method and device | |
| CN110825834A (en) | Method and system for measuring correlation matching between automation terminal data and GIS system distribution transformer and readable storage medium | |
| CN111813831B (en) | Method, device and readable medium for presuming substation to which communication base station belongs | |
| CN112311639A (en) | Monitoring information data checking method based on real-time message bus | |
| CN104112183B (en) | The intelligent scheduling model management system and management method of intelligent substation plug and play | |
| CN106530112A (en) | Distribution management system | |
| CN113132166A (en) | Communication network fault scheduling method and system | |
| CN110516828B (en) | Monitoring information processing system and method | |
| CN111476547A (en) | Method for analyzing assets of distribution network line ring-out point arrangement in user | |
| CN109980787B (en) | Fault interval positioning method based on distribution network real-time data and equipment topology | |
| CN111146868A (en) | Power communication machine room dynamic loop monitoring standardized access method and system | |
| CN106533958B (en) | Data consistency checking method for heterogeneous system of cross-network isolation device | |
| CN112286884B (en) | Method, system and medium for automatically generating topology of ring main unit of power distribution network | |
| CN112364210B (en) | Power distribution network power outage plan duplicate checking method | |
| CN112614017B (en) | Power failure information management system, power failure information management method, and storage medium | |
| CN115224687A (en) | Power failure overhaul safety checking method and system for power transmission and transformation equipment below 220KV |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |