CN109740789B - Wiring management method, device, equipment and storage medium - Google Patents
Wiring management method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN109740789B CN109740789B CN201811395285.8A CN201811395285A CN109740789B CN 109740789 B CN109740789 B CN 109740789B CN 201811395285 A CN201811395285 A CN 201811395285A CN 109740789 B CN109740789 B CN 109740789B
- Authority
- CN
- China
- Prior art keywords
- wiring
- machine room
- information
- list
- equipment
- 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.)
- Active
Links
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present disclosure relates to the field of machine room management technologies, and in particular, to a wiring management method, device, equipment, and storage medium. A wiring management method includes: acquiring wiring requirements, extracting key data in the wiring requirements, and generating a wiring information list according to the key data; judging whether the source equipment and the target equipment are in the same machine room or not; if the wiring information points which are not used in the equipment room of the distribution source equipment are in the same equipment room, inquiring and generating a wiring path if the wiring information points are not in the same equipment room; distributing wiring information points closest to the source equipment from unused wiring information points of the target equipment room according to the wiring path; and after wiring is finished, summarizing all wiring information generated in the wiring process, and predicting trend of the wiring information to provide basis for subsequent wiring. According to the method and the device, manual operation is not needed, a large amount of working time is saved, error rate is reduced, and especially the wiring efficiency of a machine room is improved, trend prediction is carried out on wiring information, and basis is provided for subsequent wiring.
Description
Technical Field
The present disclosure relates to the field of machine room management technologies, and in particular, to a wiring management method, device, equipment, and storage medium.
Background
The comprehensive wiring of the machine room is a modularized and extremely flexible information transmission channel in the machine room or between the machine rooms. By means of which voice equipment, data equipment, switching equipment and various control equipment can be connected to the information management system, and also the integrated wiring of these equipment to an external communication network. It also includes all cables and related connection components between the connection points of the computer lab external network or telecommunication lines and the application system devices. The integrated wiring is composed of different series and specifications of components, including: transmission media, associated connection hardware (e.g., patch panels, connectors, jacks, plugs, adapters), electrical protection devices, and the like. These components can be used to construct a variety of subsystems, each of which has its own specific use, and which is not only easy to implement, but also can be smoothly upgraded with changing demands.
The existing comprehensive wiring process of the machine room has the following problems:
1. the wiring requirements submitted by the summarized users need to be manually consolidated.
2. When wiring is carried out across a machine room, whether the wiring is reasonable or not, checking and selecting comprehensive wiring information points on site, and manually updating and recording the use state of the information points are needed to be judged manually.
Due to the existence of the problems, the traditional wiring technology has high labor cost, low efficiency and high error rate.
Disclosure of Invention
In view of this, it is necessary to provide a wiring management method, apparatus, device and storage medium for the problem that an automated wiring management system is lacking in the existing machine room wiring process to perform overall management on the wiring process, and the problem that the wiring requirement submitted by a user needs to be manually arranged and the comprehensive wiring information point is checked and selected on site.
A wiring management method comprising the steps of:
acquiring wiring requirements input by a user, analyzing the wiring requirements, extracting key data in the wiring requirements, and generating a wiring information list according to the key data;
extracting machine room information in the wiring information list, and judging whether source equipment and target equipment of the wiring information list are in the same machine room according to the machine room information;
if the source equipment and the target equipment are in the same machine room, distributing unused wiring information points in the machine room where the source equipment and the target equipment are located, and if the source equipment and the target equipment are not in the same machine room, inquiring and generating a wiring path by using a recursion traversal method;
Distributing wiring information points closest to the source equipment from unused wiring information points in a machine room where the target equipment is located according to the wiring path, and sending a distribution result to a wiring terminal;
and after wiring is finished, summarizing all wiring information generated in the wiring process, carrying out trend prediction on the wiring information through a trend prediction algorithm, and taking the result of the trend prediction as a basis for wiring again.
In one possible embodiment, the obtaining the wiring requirement input by the user, analyzing the wiring requirement, extracting key data in the wiring requirement, and generating a wiring information list according to the key data includes:
connecting a wiring demand terminal, and acquiring wiring demands input by a user from the wiring demand terminal;
traversing the detail data of the wiring requirement through a parser, and generating a form according to the detail data obtained after traversing;
acquiring an analysis rule of the form from a wiring management database, and extracting a rule object from the analysis rule;
using rule attributes of the rule objects to find data nodes where the key data are located, and extracting the key data according to the data nodes;
And generating a wiring information list according to the key data.
In one possible embodiment, the extracting the room information in the wiring information list, and determining whether the source device and the target device of the wiring information list are in the same room according to the room information includes:
extracting machine room information of the source equipment and the target equipment from the wiring information list, wherein the machine room information comprises machine room names;
if the machine room names of the source equipment and the target equipment are the same, judging that the source equipment and the target equipment are in the same machine room, and if the machine room names of the source equipment and the target equipment are different, judging that the source equipment and the target equipment are not in the same machine room.
In one possible embodiment, if the source device and the target device are in the same machine room, the routing information points that are not used in the machine room where the source device and the target device are located are allocated, and if the source device and the target device are not in the same machine room, a recursive traversal method is used to query and generate a routing path, including:
if the source equipment and the target equipment are in the same machine room, calling a machine room wiring information point statistical table from a machine room information query database, and extracting unused wiring information points from the wiring information point statistical table for distribution;
If the source equipment and the target equipment are not in the same machine room, inquiring and acquiring a first-level opposite-end machine room list of unused wiring information points in the machine room where the source equipment is located by taking the machine room where the source equipment is located as a starting point, and judging whether the machine room where the target equipment is located exists in the first-level opposite-end machine room list;
if the machine room where the target equipment is located exists in the first-level opposite-end machine room list, generating a wiring path;
if the primary opposite terminal machine room list does not have the machine room where the target equipment is located, continuously inquiring a secondary opposite terminal machine room list of unused wiring information points in each machine room in the primary opposite terminal machine room list, and judging whether the secondary opposite terminal machine room list has the machine room where the target equipment is located;
if the machine room where the target equipment is located exists in the secondary opposite end machine room list, generating a wiring path according to a path from the machine room where the source equipment is located to the primary opposite end machine room list to the machine room where the target equipment is located;
and if the machine room in which the target equipment is located is not in the secondary opposite terminal machine room list, stopping inquiring, and marking the wiring information list as failed.
In one possible embodiment, the allocating, according to the routing path, a routing information point closest to the source device from among routing information points unused in a machine room where the target device is located, and sending an allocation result to a routing terminal, including a calculation process of allocating a routing information point closest to the source device, specifically includes:
establishing a coordinate system by taking any point as an origin, wherein the coordinates of the position of the source equipment are (a, b), and the coordinates of the position of the unused wiring information point in the machine room of the target equipment are (x, y);
and obtaining the square of the distance between the unused wiring information point in the machine room where the target equipment is located and the source equipment through calculation, wherein the calculation formula is as follows:
D i ＝(b-y) 2 +(a-x) 2
wherein D is i The square of the distance between the unused wiring information point i in the machine room where the target equipment is located and the source equipment is obtained;
screening D corresponding to each unused wiring information point i Most of (3)Small value D min The D is min The position of the corresponding coordinate is the wiring information point closest to the source equipment in the unused wiring information points in the machine room where the target equipment is located.
In one possible embodiment, after the wiring is finished, summarizing all wiring information generated in the wiring process, performing trend prediction on the wiring information through a trend prediction algorithm, and taking a result of the trend prediction as a basis for wiring again, where the method includes:
Receiving wiring ending information;
extracting key data including wiring time consumption, wiring path and nearest wiring information points from the wiring ending information, and importing the key data into a preset wiring list;
acquiring a starting time node of data extraction preset in the wiring list, and extracting item wiring data from the starting time node to the latest wiring end of each item in the wiring list according to the starting time node;
drawing a wiring data graph according to the item wiring data, wherein the wiring data graph takes time as an abscissa and the item wiring data as an ordinate;
and carrying out trend prediction on the wiring data graph by using a trend prediction algorithm, and storing the prediction result into the wiring list as the basis of the next wiring.
In one possible embodiment, the trend prediction algorithm is used for trend prediction of the wiring data graph, and the prediction result is stored in the wiring list and used as a basis of the next wiring, including:
acquiring any two adjacent data in the wiring data curve, calculating the average value of the two adjacent data, and drawing a data average value curve;
And (3) taking the average value of the data into a primary smoothing algorithm formula to predict trend, wherein the formula is as follows:
y t+1 ＝ax t +(1-a)y t ，
wherein y is t+1 A smoothed value for time t+1; x is x t Is the actual value of time t;
y t a smoothed value for time t; a is a smoothing constant, and the value range is [0.1,1]；
And importing the prediction result of the parameter output into the wiring data curve, making a trend line of the wiring data curve according to a least square method, and carrying out trend prediction again if the slope of the trend line is larger than a preset threshold value, otherwise importing the prediction result into a wiring list.
A wiring management device comprising the following modules:
the wiring information list generation module is used for acquiring wiring requirements input by a user, analyzing the wiring requirements, extracting key data in the wiring requirements and generating a wiring information list according to the key data;
the judging module is used for extracting the machine room information in the wiring information list and judging whether the source equipment and the target equipment of the wiring information list are in the same machine room or not according to the machine room information;
the wiring path generation module is configured to allocate unused wiring information points in a machine room where the source equipment and the target equipment are located if the source equipment and the target equipment are located in the same machine room, and query and generate a wiring path by using a recursive traversal method if the source equipment and the target equipment are not located in the same machine room;
A wiring information point allocation module configured to allocate, according to the wiring path, a wiring information point closest to the source device from among unused wiring information points in a machine room where the target device is located, and send an allocation result to a wiring terminal;
and the trend prediction module is used for summarizing all wiring information generated in the wiring process after wiring is finished, carrying out trend prediction on the wiring information through a trend prediction algorithm, and taking the result of the trend prediction as a basis for wiring again.
A computer device comprising a memory and a processor, the memory having stored therein computer readable instructions which, when executed by one or more of the processors, cause the one or more processors to perform the steps of the above-described wiring management method.
A storage medium storing computer readable instructions that, when executed by one or more processors, cause one or more of the processors to perform the steps of the above-described wire management method.
The wiring management method, the device, the equipment and the storage medium comprise the following steps: acquiring wiring requirements input by a user, analyzing the wiring requirements, extracting key data in the wiring requirements, and generating a wiring information list according to the key data; extracting machine room information in the wiring information list, and judging whether source equipment and target equipment of the wiring information list are in the same machine room according to the machine room information; if the source equipment and the target equipment are in the same machine room, distributing unused wiring information points in the machine room where the source equipment and the target equipment are located, and if the source equipment and the target equipment are not in the same machine room, inquiring and generating a wiring path by using a recursion traversal method; distributing wiring information points closest to the source equipment from unused wiring information points in a machine room where the target equipment is located according to the wiring path; and after wiring is finished, summarizing all wiring information generated in the wiring process, carrying out trend prediction on the wiring information through a trend prediction algorithm, and taking the result of the trend prediction as a basis for wiring again. According to the technical scheme, the wiring path is automatically generated through traversing inquiry, wiring information points closest to the source equipment are selected through calculation, manual operation is not needed, a large amount of working time is saved, especially the wiring efficiency of a machine room is improved, trend prediction is carried out on wiring information through a trend prediction algorithm, and a basis is provided for wiring again.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention.
FIG. 1 is an overall flow chart of a method of routing management in one embodiment of the present invention;
FIG. 2 is a schematic diagram of a routing information inventory generation process in a routing management method in one embodiment of the present invention;
FIG. 3 is a schematic diagram of a routing path generation process in a routing management method in one embodiment of the present invention;
fig. 4 is a block diagram of a wiring management device in one embodiment of the invention.
Detailed Description
The present invention will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present invention more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
As used herein, the singular forms "a", "an", "the" and "the" are intended to include the plural forms as well, unless expressly stated otherwise, as understood by those skilled in the art. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
FIG. 1 is an overall flow chart of a wiring management method of the present invention, as shown, comprising the steps of:
step S1, obtaining wiring requirements input by a user, analyzing the wiring requirements, extracting key data in the wiring requirements, and generating a wiring information list according to the key data.
When the steps are executed, the wiring demand terminal is connected, the wiring demand input by a user is acquired from the wiring demand terminal, wherein the wiring demand terminal is a ServiceBot system, and the Service Bot system is an ITSM (IT Service management) tool based on an ITIL idea, and functional modules such as event management, problem management, change management and the like are integrated. And the IT service management and the operation and maintenance management are seamlessly abutted, so that the operation and maintenance efficiency and the IT service quality are improved, and the operation cost and risk are reduced. The user enters a ServiceBot system, selects and processes the field grouping and then enters an editing page of the wiring application, fills in wiring requirements at the interface, clicks and submits after editing is completed, generates the wiring requirements after submitting and stores the wiring requirements in a database of the ServiceBot system.
When the steps are executed, after wiring requirements input by a user are acquired, traversing the detail data of the wiring requirements through a parser, and generating a form according to the detail data obtained after traversing; acquiring an analysis rule of the form from a wiring management database, and extracting a rule object from the analysis rule; using rule attributes of the rule objects to find data nodes where the key data are located, and extracting the key data according to the data nodes; and generating a wiring information list according to the key data.
Wherein the critical data includes wiring information such as: machine room information of source equipment and target equipment of the wiring, source equipment position, port, target equipment position, cable, joint type and the like are applied.
And S2, extracting the machine room information in the wiring information list, and judging whether the source equipment and the target equipment of the wiring information list are in the same machine room or not according to the machine room information.
And when the steps are executed, extracting information of a machine room where the source equipment and the target equipment are located from the wiring information list, wherein the information of the machine room comprises machine room names, and judging that the source equipment and the target equipment are located in the same machine room if the machine room names of the source equipment and the target equipment are the same.
In a preferred embodiment, the feature characters of the machine room information of the source device and the target device are extracted respectively, the feature characters of the machine room information of the source device and the target device are compared, and if the feature characters of the source device and the target device are the same, it can be judged that the source device and the target device belong to the same machine room.
And S3, if the source equipment and the target equipment are in the same machine room, distributing unused wiring information points in the machine room where the source equipment and the target equipment are located, and if the source equipment and the target equipment are not in the same machine room, querying and generating a wiring path by using a recursion traversal method.
When the above steps are executed, if the source device and the target device are in the same machine room, the unused wiring information points are queried in the machine room, and one wiring information point is randomly allocated in the unused wiring information points, or one wiring information point closest to the source device is allocated. If the source equipment and the target equipment are not in the same machine room, traversing the machine room where the target equipment is located by using a recursion traversal method, and generating a wiring path according to a path from the machine room where the source equipment is located to the machine room where the target equipment is located.
And S4, distributing wiring information points closest to the source equipment from unused wiring information points in the machine room where the target equipment is located according to the wiring path, and sending a distribution result to a wiring terminal.
And S5, after wiring is finished, summarizing all wiring information generated in the wiring process, carrying out trend prediction on the wiring information through a trend prediction algorithm, and taking the result of the trend prediction as a basis for wiring again.
The trend prediction algorithm mainly comprises an exponential smoothing method, wherein the exponential smoothing method is one of moving average methods, and is characterized in that the past observations are given different weights, namely the weights of the more recent observations are larger than the weights of the more distant observations. According to the difference of the smoothing times, the exponential smoothing method is classified into a primary exponential smoothing method, a secondary exponential smoothing method, a tertiary exponential smoothing method, and the like. But their basic ideas are: the predicted value is a weighted sum of previous observations and different weights are given to different data, with new data given a larger weight and old data given a smaller weight.
According to the method and the device, the wiring path is automatically generated through traversing the query, and the wiring information point closest to the source equipment is selected through calculation, so that manual operation is not needed, a great amount of working time is saved, trend prediction is carried out on data generated by wiring, the wiring process can be well controlled, the efficiency of wiring management is improved, and the wiring process is optimized.
In one embodiment, fig. 2 is a schematic diagram of a wiring information list generating process in a wiring management method according to the present invention, as shown in the drawing, in the step S1, a wiring requirement input by a user is obtained, the wiring requirement is parsed, key data in the wiring requirement is extracted, and a wiring information list is generated according to the key data, including the following steps:
step S101, connecting a wiring demand terminal, and acquiring a wiring demand input by a user from the wiring demand terminal;
step S102, traversing the detail data of the wiring requirement through a parser, and generating a form according to the detail data obtained after traversing;
step S103, obtaining analysis rules of the form from a wiring management database, and extracting rule objects from the analysis rules;
step S104, using rule attributes of the rule objects to find data nodes where the key data are located, and extracting the key data according to the data nodes;
Step S105, generating a wiring information list according to the key data.
The detail data comprise specific data such as a requirement ID, a requirement description, a requirement report date, a requirement report person, a requirement processing state, requirement form content and the like.
When the steps are executed, a json parser is used to traverse the requirement information including the requirement ID, the requirement description, the requirement reporting date, the requirement reporting person and the form content and the detail data in the requirement information. For example, the traversed demand information and detail data include: demand ID: "REQ2018071806586", description of demand: wiring between xx device and xx device, demand reporting date: "2018-9-23 16:21", demand report: "xxx", form content: "wiring information". And generating a form according to the traversed demand information and the detail data.
The method for extracting the analysis rules can analyze the configuration file through a JDOM analyzer to extract the analysis rules.
The key data to be extracted are stored in a certain < TABLE > node, and the < tr > node in the sub-nodes can be defined as 'row node', which represents each row of data, according to the TABLE specification of the Html, while the < td > sub-node under the < tr > node is 'column node', which represents each field of data. Combining the characteristics, establishing grabbing rules for different forms, and adding a method for locating a < table > node of stored data and a field identification method of the < td > node. The required key data can be extracted.
In the embodiment, the data nodes where the key data are located are found, so that the key data are extracted, and the recognition degree of the key data is enhanced.
In one embodiment, the step S2 is to send the wiring application to the terminal of the management group, and then receive the wiring application that passes the verification of the terminal of the management group, and includes the following steps:
extracting machine room information of the source equipment and the target equipment from the wiring information list, wherein the machine room information comprises machine room names;
if the machine room names of the source equipment and the target equipment are the same, judging that the source equipment and the target equipment are in the same machine room, and if the machine room names of the source equipment and the target equipment are different, judging that the source equipment and the target equipment are not in the same machine room.
In one embodiment, fig. 3 is a schematic diagram of a routing path generating process in a routing management method according to the present invention, as shown in the drawing, in the step S3, if the source device and the target device are in the same machine room, unused routing information points in the machine room where the source device and the target device are located are allocated, and if the source device and the target device are not in the same machine room, a recursive traversal method is used to query and generate a routing path, including the following steps:
Step S301, if the source device and the target device are in the same machine room, retrieving the machine room wiring information point statistics table from a machine room information query database, and extracting unused wiring information points from the wiring information point statistics table for allocation;
step S302, if the source equipment and the target equipment are not in the same machine room, inquiring and acquiring a first-level opposite-end machine room list of unused wiring information points in the machine room where the source equipment is located by taking the machine room where the source equipment is located as a starting point, and judging whether the machine room where the target equipment is located exists in the first-level opposite-end machine room list;
step S303, if the machine room where the target equipment is located exists in the primary opposite end machine room list, a wiring path is generated;
step S304, if the primary opposite terminal machine room list does not have the machine room where the target equipment is located, continuously inquiring a secondary opposite terminal machine room list of unused wiring information points in each machine room in the primary opposite terminal machine room list, and judging whether the secondary opposite terminal machine room list has the machine room where the target equipment is located;
step S305, if the machine room where the target device is located is in the second-level opposite-end machine room list, generating a wiring path according to a path from the machine room where the source device is located to the first-level opposite-end machine room list to the machine room where the target device is located;
And step S306, if the machine room in which the target equipment is located is not in the secondary opposite terminal machine room list, stopping inquiring, and marking the wiring information list as failed.
When the steps are executed, if the source equipment and the target equipment are not in the same machine room, firstly, a wiring information point statistical table of the machine room M where the source equipment is located is called from a machine room information query database, unused wiring information points of the machine room M are traversed from the wiring information point statistical table by a recursion traversal method, and then a first-level opposite-end machine room list of each unused wiring information point is queried and obtained. The first-stage opposite-end machine room is a machine room directly connected with the M machine rooms by wires, for example, A, C, D machine rooms are listed in a first-stage opposite-end machine room list. Judging whether a target equipment is located in a A, C, D machine room or not, if the A machine room is the machine room where the target equipment is located, the wiring path is from the M machine room to the A machine room, if the target equipment is not located in the machine room, respectively inquiring A, C, D a secondary opposite end machine room list of unused wiring information points of the machine room, wherein the secondary opposite end machine rooms are machine rooms which are respectively connected with the A, C, D machine rooms in a wiring way. Assuming that the two-stage opposite-end machine rooms of the A, C machine room are a B machine room and an E machine room respectively, judging whether target equipment is located in the B machine room and the E machine room, and generating a path if the target equipment is located in the E machine room: and the primary path is from the M machine room to the C machine room, the secondary path is from the C machine room to the E machine room, if not, the inquiry is stopped, the wiring information list is marked as failure, and an administrator is informed through mail after the failure information is summarized, so that a user is informed of modifying wiring resources.
According to the embodiment, the routing path is automatically generated by traversing the query through a recursion traversal method, meanwhile, whether the routing paths are different or not is checked, the problem that the routing information points are too many is solved, and a large amount of working time is saved.
In one embodiment, the step S4 allocates, according to the routing path, a routing information point closest to the source device from among routing information points unused in a machine room where the target device is located, and sends an allocation result to a routing terminal, including a calculation process of allocating a routing information point closest to the source device, including:
establishing a coordinate system by taking any point as an origin, wherein the coordinates of the position of the source equipment are (a, b), and the coordinates of the position of the unused wiring information point in the machine room of the target equipment are (x, y);
and obtaining the square of the distance between the unused wiring information point in the machine room where the target equipment is located and the source equipment through calculation, wherein the calculation formula is as follows:
D i ＝(b-y) 2 +(a-x) 2
wherein D is i The square of the distance between the unused wiring information point i in the machine room where the target equipment is located and the source equipment is obtained;
screening D corresponding to each unused wiring information point i Minimum value D of (2) min The D is min The position of the corresponding coordinate is the wiring information point closest to the source equipment in the unused wiring information points in the machine room where the target equipment is located. The wiring information point i may be an ith wiring information point, where i is a natural number other than 0.
In the embodiment, the nearest wiring information points are automatically distributed in the wiring path according to the near principle, so that the cost of the cable is saved.
In one embodiment, after the wiring is finished, step S5 is performed, summarizing all wiring information generated in the wiring process, performing trend prediction on the wiring information by using a trend prediction algorithm, and taking a result of the trend prediction as a basis for performing wiring again, where the step S5 includes:
receiving wiring ending information;
extracting key data including wiring time consumption, wiring path and nearest wiring information points from the wiring ending information, and importing the key data into a preset wiring list;
acquiring a starting time node of data extraction preset in the wiring list, and extracting item wiring data from the starting time node to the latest wiring end of each item in the wiring list according to the starting time node;
Drawing a wiring data graph according to the item wiring data, wherein the wiring data graph takes time as an abscissa and the item wiring data as an ordinate;
and carrying out trend prediction on the wiring data graph by using a trend prediction algorithm, and storing the prediction result into the wiring list as the basis of the next wiring.
According to the embodiment, the wiring process can be better guided to the next wiring process by summarizing and predicting the wiring process, so that the subsequent wiring process is smoother, and the wiring efficiency is improved.
In one embodiment, the trend prediction algorithm is applied to perform trend prediction on the wiring data graph, and the prediction result is stored in the wiring list and used as the basis of the next wiring, including:
acquiring any two adjacent data in the wiring data curve, calculating the average value of the two adjacent data, and drawing a data average value curve;
and (3) taking the average value of the data into a primary smoothing algorithm formula to predict trend, wherein the formula is as follows:
y t+1 ＝ax t +(1-a)y t ，
wherein y is t+1 A smoothed value for time t+1; x is x t Is the actual value of time t;
y t a smoothed value for time t; a is a smoothing constant, and the value range is [0.1,1 ]；
And importing the prediction result of the parameter output into the wiring data curve, making a trend line of the wiring data curve according to a least square method, and carrying out trend prediction again if the slope of the trend line is larger than a preset threshold value, otherwise importing the prediction result into a wiring list.
When trend prediction is performed, firstly, a time section of historical data is selected, the historical data is intercepted according to the time section, and then trend prediction is performed according to the intercepted data. Multiple predictions may be made during trend prediction and then the average taken as the final prediction result.
According to the embodiment, the subsequent wiring is predicted according to the existing wiring data, so that the speed and efficiency of the subsequent wiring can be effectively improved.
A wiring management device, as shown in fig. 4, includes the following modules:
the wiring information list generation module is used for acquiring wiring requirements input by a user, analyzing the wiring requirements, extracting key data in the wiring requirements and generating a wiring information list according to the key data;
the judging module is used for extracting the machine room information in the wiring information list and judging whether the source equipment and the target equipment of the wiring information list are in the same machine room or not according to the machine room information;
The wiring path generation module is configured to allocate unused wiring information points in a machine room where the source equipment and the target equipment are located if the source equipment and the target equipment are located in the same machine room, and query and generate a wiring path by using a recursive traversal method if the source equipment and the target equipment are not located in the same machine room;
a wiring information point allocation module configured to allocate, according to the wiring path, a wiring information point closest to the source device from among unused wiring information points in a machine room where the target device is located, and send an allocation result to a wiring terminal;
and the trend prediction module is used for summarizing all wiring information generated in the wiring process after wiring is finished, carrying out trend prediction on the wiring information through a trend prediction algorithm, and taking the result of the trend prediction as a basis for wiring again.
In one embodiment, a computer device is provided that includes a memory and a processor, the memory having stored therein computer readable instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of the routing management method described in the above embodiments.
In one embodiment, a storage medium storing computer readable instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of the wire management method described in the above embodiments is presented. Wherein the storage medium may be a non-volatile storage medium.
Those of ordinary skill in the art will appreciate that all or part of the steps in the various methods of the above embodiments may be implemented by a program to instruct related hardware, the program may be stored in a computer readable storage medium, and the storage medium may include: read Only Memory (ROM), random access Memory (RAM, random Access Memory), magnetic or optical disk, and the like.
The technical features of the above-described embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above-described embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above-described embodiments represent only some exemplary embodiments of the invention, which are described in more detail and are not to be construed as limiting the scope of the invention. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the invention, which are all within the scope of the invention. Accordingly, the scope of protection of the present invention is to be determined by the appended claims.
Claims (8)
1. A wiring management method, characterized by comprising the steps of:
acquiring wiring requirements input by a user, analyzing the wiring requirements, extracting key data in the wiring requirements, and generating a wiring information list according to the key data;
extracting machine room information in the wiring information list, and judging whether source equipment and target equipment of the wiring information list are in the same machine room according to the machine room information;
if the source equipment and the target equipment are in the same machine room, distributing unused wiring information points in the machine room where the source equipment and the target equipment are located, and if the source equipment and the target equipment are not in the same machine room, inquiring and generating a wiring path by using a recursion traversal method;
distributing wiring information points closest to the source equipment from unused wiring information points in a machine room where the target equipment is located according to the wiring path, and sending a distribution result to a wiring terminal;
after wiring is finished, summarizing all wiring information generated in the wiring process, carrying out trend prediction on the wiring information through a trend prediction algorithm, and taking the result of the trend prediction as a basis for wiring again;
If the source device and the target device are in the same machine room, distributing unused wiring information points in the machine room where the source device and the target device are located, and if the source device and the target device are not in the same machine room, querying and generating a wiring path by using a recursion traversal method, wherein the method comprises the following steps:
if the source equipment and the target equipment are in the same machine room, calling a machine room wiring information point statistical table from a machine room information query database, and extracting unused wiring information points from the wiring information point statistical table for distribution;
if the source equipment and the target equipment are not in the same machine room, inquiring and acquiring a first-level opposite-end machine room list of unused wiring information points in the machine room where the source equipment is located by taking the machine room where the source equipment is located as a starting point, and judging whether the machine room where the target equipment is located exists in the first-level opposite-end machine room list;
if the machine room where the target equipment is located exists in the first-level opposite-end machine room list, generating a wiring path;
if the primary opposite terminal machine room list does not have the machine room where the target equipment is located, continuously inquiring a secondary opposite terminal machine room list of unused wiring information points in each machine room in the primary opposite terminal machine room list, and judging whether the secondary opposite terminal machine room list has the machine room where the target equipment is located;
If the machine room where the target equipment is located exists in the secondary opposite end machine room list, generating a wiring path according to a path from the machine room where the source equipment is located to the primary opposite end machine room list to the machine room where the target equipment is located;
if the machine room in which the target equipment is located is not in the secondary opposite terminal machine room list, stopping inquiring, and marking the wiring information list as failure;
after the wiring is finished, summarizing all wiring information generated in the wiring process, carrying out trend prediction on the wiring information through a trend prediction algorithm, and taking the result of the trend prediction as a basis for wiring again, wherein the method comprises the following steps:
receiving wiring ending information;
extracting key data including wiring time consumption, wiring path and nearest wiring information points from the wiring ending information, and importing the key data into a preset wiring list;
acquiring a starting time node of data extraction preset in the wiring list, and extracting item wiring data from the starting time node to the latest wiring end of each item in the wiring list according to the starting time node;
drawing a wiring data graph according to the item wiring data, wherein the wiring data graph takes time as an abscissa and the item wiring data as an ordinate;
And carrying out trend prediction on the wiring data graph by using a trend prediction algorithm, and storing the prediction result into the wiring list as the basis of the next wiring.
2. The method for managing wires according to claim 1, wherein the steps of obtaining a wire demand input by a user, analyzing the wire demand, extracting key data in the wire demand, and generating a wire information list according to the key data, include:
connecting a wiring demand terminal, and acquiring wiring demands input by a user from the wiring demand terminal;
traversing the detail data of the wiring requirement through a parser, and generating a form according to the detail data obtained after traversing;
acquiring an analysis rule of the form from a wiring management database, and extracting a rule object from the analysis rule;
using rule attributes of the rule objects to find data nodes where the key data are located, and extracting the key data according to the data nodes;
and generating a wiring information list according to the key data.
3. The wiring management method according to claim 1, wherein the extracting the room information in the wiring information list, and judging whether the source device and the target device of the wiring information list are in the same room based on the room information, comprises:
Extracting machine room information of the source equipment and the target equipment from the wiring information list, wherein the machine room information comprises machine room names;
if the machine room names of the source equipment and the target equipment are the same, judging that the source equipment and the target equipment are in the same machine room, and if the machine room names of the source equipment and the target equipment are different, judging that the source equipment and the target equipment are not in the same machine room.
4. The wiring management method according to claim 1, wherein the allocating wiring information points closest to the source device from among the unused wiring information points in the machine room where the target device is located according to the wiring path, and transmitting the allocation result to the wiring terminal, includes a calculation process of allocating wiring information points closest to the source device, specifically including:
establishing a coordinate system by taking any point as an origin, wherein the coordinates of the position of the source equipment are (a, b), and the coordinates of the position of the unused wiring information point in the machine room of the target equipment are (x, y);
and obtaining the square of the distance between the unused wiring information point in the machine room where the target equipment is located and the source equipment through calculation, wherein the calculation formula is as follows:
D i =(b-y) 2 +(a-x) 2
Wherein D is i The square of the distance between the unused wiring information point i in the machine room where the target equipment is located and the source equipment is obtained;
screening D corresponding to each unused wiring information point i Minimum value D of (2) min The D is min The position of the corresponding coordinate is the wiring information point closest to the source equipment in the unused wiring information points in the machine room where the target equipment is located.
5. The wiring management method according to claim 1, wherein the applying a trend prediction algorithm to trend the wiring data graph, storing the prediction result in the wiring list as a basis for the next wiring, comprises:
acquiring any two adjacent data in the wiring data curve, calculating the average value of the two adjacent data, and drawing a data average value curve;
and (3) taking the average value of the data into a primary smoothing algorithm formula to predict trend, wherein the formula is as follows:
y t+1 =ax t +(1-a)y t ，
wherein y is t+1 A smoothed value for time t+1; x is x t Is the actual value of time t;
y t a smoothed value for time t; a is a smoothing constant, and the value range is [0.1,1]；
And importing the prediction result of the parameter output into the wiring data curve, making a trend line of the wiring data curve according to a least square method, and carrying out trend prediction again if the slope of the trend line is larger than a preset threshold value, otherwise importing the prediction result into a wiring list.
6. A wiring management device comprising the following modules:
the wiring information list generation module is used for acquiring wiring requirements input by a user, analyzing the wiring requirements, extracting key data in the wiring requirements and generating a wiring information list according to the key data;
the judging module is used for extracting the machine room information in the wiring information list and judging whether the source equipment and the target equipment of the wiring information list are in the same machine room or not according to the machine room information;
the wiring path generation module is configured to allocate unused wiring information points in a machine room where the source equipment and the target equipment are located if the source equipment and the target equipment are located in the same machine room, and query and generate a wiring path by using a recursive traversal method if the source equipment and the target equipment are not located in the same machine room;
a wiring information point allocation module configured to allocate, according to the wiring path, a wiring information point closest to the source device from among unused wiring information points in a machine room where the target device is located, and send an allocation result to a wiring terminal;
the trend prediction module is used for summarizing all wiring information generated in the wiring process after wiring is finished, carrying out trend prediction on the wiring information through a trend prediction algorithm, and taking the result of the trend prediction as a basis for wiring again;
The wiring path generating module is specifically configured to, if the source device and the target device are in the same machine room, retrieve the machine room wiring information point statistics table from a machine room information query database, extract unused wiring information points from the wiring information point statistics table, and distribute the wiring information points;
if the source equipment and the target equipment are not in the same machine room, inquiring and acquiring a first-level opposite-end machine room list of unused wiring information points in the machine room where the source equipment is located by taking the machine room where the source equipment is located as a starting point, and judging whether the machine room where the target equipment is located exists in the first-level opposite-end machine room list;
if the machine room where the target equipment is located exists in the first-level opposite-end machine room list, generating a wiring path;
if the primary opposite terminal machine room list does not have the machine room where the target equipment is located, continuously inquiring a secondary opposite terminal machine room list of unused wiring information points in each machine room in the primary opposite terminal machine room list, and judging whether the secondary opposite terminal machine room list has the machine room where the target equipment is located;
if the machine room where the target equipment is located exists in the secondary opposite end machine room list, generating a wiring path according to a path from the machine room where the source equipment is located to the primary opposite end machine room list to the machine room where the target equipment is located;
If the machine room in which the target equipment is located is not in the secondary opposite terminal machine room list, stopping inquiring, and marking the wiring information list as failure;
the trend prediction module is specifically configured to receive wiring ending information;
extracting key data including wiring time consumption, wiring path and nearest wiring information points from the wiring ending information, and importing the key data into a preset wiring list;
acquiring a starting time node of data extraction preset in the wiring list, and extracting item wiring data from the starting time node to the latest wiring end of each item in the wiring list according to the starting time node;
drawing a wiring data graph according to the item wiring data, wherein the wiring data graph takes time as an abscissa and the item wiring data as an ordinate;
and carrying out trend prediction on the wiring data graph by using a trend prediction algorithm, and storing the prediction result into the wiring list as the basis of the next wiring.
7. A computer device comprising a memory and a processor, the memory having stored therein computer readable instructions that, when executed by one or more of the processors, cause the one or more processors to perform the steps of the wire management method of any of claims 1 to 5.
8. A storage medium storing computer-readable instructions that, when executed by one or more processors, cause one or more of the processors to perform the steps of the wire management method of any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811395285.8A CN109740789B (en) | 2018-11-22 | 2018-11-22 | Wiring management method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811395285.8A CN109740789B (en) | 2018-11-22 | 2018-11-22 | Wiring management method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109740789A CN109740789A (en) | 2019-05-10 |
| CN109740789B true CN109740789B (en) | 2023-07-25 |
Family
ID=66357050
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811395285.8A Active CN109740789B (en) | 2018-11-22 | 2018-11-22 | Wiring management method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109740789B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110222099A (en) * | 2019-06-21 | 2019-09-10 | 湖北广信汇科技有限公司 | Cable management system, equipment and storage medium |
| CN113536730A (en) * | 2021-06-16 | 2021-10-22 | 浙江华消科技有限公司 | Wiring method and device of control cabinet, electronic device and storage medium |
| CN115484172B (en) * | 2022-09-16 | 2023-09-26 | 深圳市兴海物联科技有限公司 | Management system and method of computer control terminal based on Internet of things |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105654249A (en) * | 2016-02-01 | 2016-06-08 | 武汉邮电科学研究院 | Entity identifier management method and device for underground pipeline management and decision-making system |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7792662B2 (en) * | 2006-04-28 | 2010-09-07 | Caterpillar Inc | Automatic hose and harness routing method and system |
| US8831920B2 (en) * | 2010-12-15 | 2014-09-09 | Fluor Technologies Corporation | Automated cabling layout systems and methods |
| FR2973903B1 (en) * | 2011-04-05 | 2013-04-05 | Bull Sas | METHOD AND DEVICE FOR MANAGING WIRING IN A CLUSTER |
| US9390216B2 (en) * | 2014-10-20 | 2016-07-12 | Oracle International Corporation | System and method for obstacle-avoiding signal bus routing |
-
2018
- 2018-11-22 CN CN201811395285.8A patent/CN109740789B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105654249A (en) * | 2016-02-01 | 2016-06-08 | 武汉邮电科学研究院 | Entity identifier management method and device for underground pipeline management and decision-making system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109740789A (en) | 2019-05-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6637620B2 (en) | Agent allocation method, apparatus, server and recording medium | |
| CN109740789B (en) | Wiring management method, device, equipment and storage medium | |
| CN111124917B (en) | Method, device, equipment and storage medium for managing and controlling public test cases | |
| CN111628941A (en) | Network traffic classification processing method, device, equipment and medium | |
| EP2255562A2 (en) | System for visualizing design and organization of wireless mesh networks in physical space | |
| CN108446712B (en) | ODN network intelligent planning method, device and system | |
| CN114091610A (en) | Intelligent decision method and device | |
| CN111045790A (en) | Virtual machine deployment method and device | |
| CN112911272B (en) | IPTV group fault early warning method and system | |
| CN105243078A (en) | File resource distribution method, system and apparatus | |
| CN113795032B (en) | Method and device for judging invisible faults of indoor division, storage medium and equipment | |
| CN113194107B (en) | Internet-based regional characteristic addressing method and device | |
| CN115118631A (en) | Link exception handling method and device, electronic equipment and storage medium | |
| CN115221967A (en) | BIM model component grouping method and device and electronic equipment | |
| CN113419745A (en) | Application instance number management method and device, electronic equipment and computer readable medium | |
| CN108683551B (en) | Pipeline type flow control method and device | |
| CN111885159A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN117608257B (en) | Cable production scheme generation method and electronic equipment | |
| EP3891930A1 (en) | Method and technician allocating system for allocating a field technician | |
| CN102486747B (en) | Statistical method for conventional functions of software system and engineering | |
| CN117495604A (en) | Interaction method and device of service operation interface of electric power system | |
| WO2024066292A1 (en) | Device group fault identification method and apparatus, and computer-readable storage medium | |
| CN111163088B (en) | Message processing method, system and device and electronic equipment | |
| JP4562125B2 (en) | Medium inventory totalizing apparatus and method, and program | |
| CN116302473A (en) | Resource allocation method and device |
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 |