CN114500230A - Optical transmission fault recording and broadcasting method and system based on time axis - Google Patents
Optical transmission fault recording and broadcasting method and system based on time axis Download PDFInfo
- Publication number
- CN114500230A CN114500230A CN202210046375.6A CN202210046375A CN114500230A CN 114500230 A CN114500230 A CN 114500230A CN 202210046375 A CN202210046375 A CN 202210046375A CN 114500230 A CN114500230 A CN 114500230A
- Authority
- CN
- China
- Prior art keywords
- record
- alarm
- work order
- data
- time
- 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
- 230000003287 optical effect Effects 0.000 title claims abstract description 66
- 230000005540 biological transmission Effects 0.000 title claims abstract description 17
- 238000000034 method Methods 0.000 title claims abstract description 16
- 238000007726 management method Methods 0.000 claims description 24
- 238000012986 modification Methods 0.000 claims description 17
- 230000004048 modification Effects 0.000 claims description 17
- 238000012217 deletion Methods 0.000 claims description 16
- 230000037430 deletion Effects 0.000 claims description 16
- 238000013500 data storage Methods 0.000 claims description 6
- 238000009795 derivation Methods 0.000 claims description 3
- 238000012545 processing Methods 0.000 abstract description 4
- 238000005065 mining Methods 0.000 abstract description 3
- 238000012216 screening Methods 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 9
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000009897 systematic effect Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/06—Management of faults, events, alarms or notifications
- H04L41/0631—Management of faults, events, alarms or notifications using root cause analysis; using analysis of correlation between notifications, alarms or events based on decision criteria, e.g. hierarchy, tree or time analysis
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04B—TRANSMISSION
- H04B10/00—Transmission systems employing electromagnetic waves other than radio-waves, e.g. infrared, visible or ultraviolet light, or employing corpuscular radiation, e.g. quantum communication
- H04B10/07—Arrangements for monitoring or testing transmission systems; Arrangements for fault measurement of transmission systems
- H04B10/075—Arrangements for monitoring or testing transmission systems; Arrangements for fault measurement of transmission systems using an in-service signal
- H04B10/079—Arrangements for monitoring or testing transmission systems; Arrangements for fault measurement of transmission systems using an in-service signal using measurements of the data signal
- H04B10/0793—Network aspects, e.g. central monitoring of transmission parameters
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/06—Management of faults, events, alarms or notifications
- H04L41/0631—Management of faults, events, alarms or notifications using root cause analysis; using analysis of correlation between notifications, alarms or events based on decision criteria, e.g. hierarchy, tree or time analysis
- H04L41/064—Management of faults, events, alarms or notifications using root cause analysis; using analysis of correlation between notifications, alarms or events based on decision criteria, e.g. hierarchy, tree or time analysis involving time analysis
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/06—Management of faults, events, alarms or notifications
- H04L41/069—Management of faults, events, alarms or notifications using logs of notifications; Post-processing of notifications
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Physics & Mathematics (AREA)
- Electromagnetism (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention belongs to the technical field of optical transmission networks, and discloses an optical transmission fault recording and broadcasting method and system based on a time axis, which comprises the following steps: acquiring configuration and operation data and alarm data of a device network management system; acquiring work order data of a work order system; screening and warehousing the data, and performing first association on the work order data and the records with the same ID in the configuration and the operation data; performing second association on the alarm information of different influence levels according to the occurrence time and the clearing time of each alarm record; performing third association according to the start time and completion time of each work order record and the alarm record; and generating event time point backtracking, event time point topology and event time point details according to the association. Has the advantages that: by mining the incidence relation among the work order record, the configuration and operation record and the alarm record to generate event time point backtracking, event time point topology and event time point detail, the system fault reason can be conveniently traced by the working personnel, and the fault processing efficiency is improved.
Description
Technical Field
The invention relates to the technical field of optical transmission networks, in particular to an optical transmission fault recording and broadcasting method and system based on a time axis.
Background
According to the management requirement of power grid operation, communication alarms all need to be subjected to fault registration, wherein the main contents of the manual registration in the routing inspection report comprise network elements generated by various alarms, influenced services and related processing conditions, but due to the lack of registration of the network elements, board cards corresponding to the slot positions of the network elements, light path information connected with the network elements, borne circuit information and dimensional data of performance when the alarms occur, the existing manual registration means cannot meet the requirement of complete recording and broadcasting of faults so that workers can find the fault reasons along with the development of networks and the improvement of fault management and control requirements.
Disclosure of Invention
The purpose of the invention is: the system and the method realize recording and broadcasting of alarm information and the like in the system, and can facilitate workers to find fault reasons according to a time axis.
In order to achieve the above object, the present invention provides, comprising:
acquiring configuration and operation data and alarm data of a device network management system; acquiring work order data of a work order system; the configuration and operation data comprises a plurality of configuration and operation records, the alarm data comprises a plurality of alarm records, and the work order data comprises a plurality of work order records;
judging whether any record is put into a warehouse or not according to the ID and the content of any record in the configuration and operation data, the alarm data and the work order data;
performing first association on the worksheet data in the database and the records with the same configuration and ID in the operating data;
performing second association and marking on the alarm information of different influence levels according to the occurrence time and the clearing time of each alarm record; performing third association according to the start time and completion time of each work order record and the alarm record;
and generating event time point backtracking, event time point topology and event time point details according to the first association, the second association and the third association.
Further, the configuration and operation data includes: the network element, the board card corresponding to each slot position of the network element, the optical path connected with the network element, the carried circuit information and the adding and deleting modification information of the network element, the slot position, the optical path and the circuit; the work order data includes: the work order name, the work order type, the network element related to the work order, the light path and circuit information related to the work order, the work starting time of the work order and the work finishing time of the work order.
Further, the determining, according to the ID and the content of any one record in the configuration and operation data, the alarm data, and the work order data, whether to put any one record into a library specifically includes:
comparing the ID of each configuration and operation record with the ID stored in the database, and if the ID of the configuration and operation record does not exist in the database, directly warehousing the configuration and operation record and marking the creation time; if the ID of the configuration and operation record is stored in the database and the content of the configuration and operation record and the data recorded in the database change, updating the configuration and operation record in the database and updating the modification time; if the database stores the ID of the configuration and operation record but no content record, marking the configuration and operation record in the database as a deletion record and marking the deletion time;
comparing the ID of each alarm record with the ID stored in the database, and directly storing the alarm record in a warehouse if the ID of the alarm record does not exist in the database; if the ID of the alarm record exists in the database and the content of the alarm record and the data recorded in the database change, updating the alarm record in the database;
comparing the ID of each work order record with the ID stored in the database, and directly warehousing the work order record if the ID of the work order record does not exist in the database; if the ID of the work order record already exists in the database and the content of the work order record and the data recorded in the database change, the work order record in the database is further changed.
Further, the first association is performed on the worksheet data in the database and the record with the same ID in the configuration and the operating data, specifically:
and performing first association on the ID of the network element, the ID of the optical path and the ID of the circuit in each work order record of the work order data and the ID of the circuit in each configuration and operation record of the operation data which are the same.
Further, the second association and marking are performed on the alarm information of different impact levels according to the occurrence time and the clearing time of each alarm record, specifically:
recording the alarm record to be judged as the current alarm record, judging the influence level of the current alarm record, searching the alarm record of which the alarm occurrence time is equal to or more than the alarm occurrence time of the current alarm record except the current alarm record in a database, the alarm clearing time is equal to or not more than 10 seconds of the alarm clearing time of the current alarm record, or the alarm clearing time and the alarm clearing time of the current alarm record are both empty, and the network element, the slot position and the port belong to the content of the influence level of the current alarm record, and marking the derivative information of the searched alarm record, wherein the derivative information is derived from the current alarm record; the marked alarm records do not participate in searching and marking any more; the impact levels include: network element, slot position, port;
analyzing the alarm records with the alarm influence level of a port in the alarm records, when the port has a light path relation, acquiring the information of the network element, the slot position and the port of the opposite end, searching the alarm records of which the alarm occurrence time is equal to or more than the alarm occurrence time of the current alarm record, the alarm clearing time is equal to or less than 10 seconds of the alarm clearing time of the current alarm record, or the alarm clearing time and the alarm clearing time of the current alarm record are empty, the network element, the slot position and the port are equal to the opposite end of the current alarm record, and marking the peer relation of the searched alarm records as peer derivation; the marked alarm records do not participate in searching and marking any more.
Further, the third correlation is performed according to the start time, the completion time and the alarm record of each work order record, specifically:
analyzing the alarm record with the derived information being empty in the alarm record, searching the work order record with the work order starting time of the work order in the work order system being less than or equal to the alarm generation time of the alarm record, the completion time of the work order being less than or equal to the alarm clearing time of the alarm record, or the completion time of the work order and the alarm clearing time of the alarm record being empty, and the network elements and circuits related to the content of the work order and the network elements and circuits of the alarm record being consistent with the network elements and circuits of the alarm record, and marking the alarm generation work order of the alarm record as the name of the work order record; the marked alarm records do not participate in searching and marking any more.
Further, the generating event time point backtracking, event time point topology and event time point details according to the first association, the second association and the third association specifically includes:
marking the work order record, the alarm record, the configuration record and the operation record which are mutually associated at the same time point of a time axis to obtain event time point backtracking; generating a connection relation graph of the network element and the optical path at the moment according to the date corresponding to the event in the event time point backtracking; and generating the detail of the event time according to the work order record, the configuration and operation record and the alarm record included in the same time point.
The invention also discloses a system for recording and broadcasting the optical transmission fault based on the time axis, which comprises the following components: the system comprises a data acquisition module, a data storage module, a data operation module and an application function module;
the data acquisition module is used for acquiring configuration and operation data and alarm data of a device network management system; acquiring work order data of a work order system; the configuration and operation data comprises a plurality of configuration and operation records, the alarm data comprises a plurality of alarm records, and the work order data comprises a plurality of work order records;
the data storage module is used for judging whether any record is stored in a storage mode according to the ID and the content of any record in the configuration and operation data, the alarm data and the work order data;
the data operation module is used for performing first association on the worksheet data in the database and the records with the same ID in the configuration and operation data; performing second association and marking on the alarm information of different influence levels according to the occurrence time and the clearing time of each alarm record; performing third association according to the start time and completion time of each work order record and the alarm record;
the application function module is used for generating event time point backtracking, event time point topology and event time point details according to the first association, the second association and the third association.
Further, the configuration and operation data includes: the network element, the board card corresponding to each slot position of the network element, the optical path connected with the network element, the carried circuit information and the adding and deleting modification information of the network element, the slot position, the optical path and the circuit; the work order data includes: the work order name, the work order type, the network element related to the work order, the light path and circuit information related to the work order, the work starting time of the work order and the work finishing time of the work order.
Further, the method is characterized in that whether any record is put into a warehouse is judged according to the ID and the content of any record in the configuration and operation data, the alarm data and the work order data, and specifically comprises the following steps:
comparing the ID of each configuration and operation record with the ID stored in the database, and if the ID of the configuration and operation record does not exist in the database, directly warehousing the configuration and operation record and marking the creation time; if the ID of the configuration and operation record is stored in the database and the content of the configuration and operation record and the data recorded in the database change, updating the configuration and operation record in the database and updating the modification time; if the database stores the ID of the configuration and operation record but no content record, marking the configuration and operation record in the database as a deletion record and marking the deletion time;
comparing the ID of each alarm record with the ID stored in the database, and directly storing the alarm record in a warehouse if the ID of the alarm record does not exist in the database; if the ID of the alarm record exists in the database and the content of the alarm record and the data recorded in the database change, updating the alarm record in the database;
comparing the ID of each work order record with the ID stored in the database, and directly warehousing the work order record if the ID of the work order record does not exist in the database; if the ID of the work order record already exists in the database and the content of the work order record and the data recorded in the database change, the work order record in the database is further changed.
Compared with the prior art, the embodiment and the system of the invention have the advantages that: according to the obtained various data information, data screening is carried out to avoid easy data, and more systematic and automatic acquisition is carried out, so that higher labor cost expenditure of manpower records is avoided; by mining the incidence relation among the work order record, the configuration and operation record and the alarm record to generate event time point backtracking, event time point topology and event time point detail, the system fault reason can be conveniently traced by the working personnel, and the fault processing efficiency is improved.
Drawings
FIG. 1 is a schematic flow diagram of the present invention;
FIG. 2 is a schematic model diagram of a device network management system according to the present invention;
FIG. 3 is a schematic diagram of a work order record in the work order system of the present invention;
FIG. 4 is a schematic diagram of alarm records and configuration and operation records in the device network management system of the present invention;
FIG. 5 is a schematic diagram of the relationship of the present invention;
FIG. 6 is a schematic diagram of event backtracking, topology and detail generated based on a timeline in the present invention;
fig. 7 is a schematic diagram of a first structure of an optical transmission failure recording and broadcasting system based on a time axis according to the present invention;
fig. 8 is a schematic diagram of a second structure of an optical transmission failure recording and broadcasting system based on a time axis according to the present invention.
Detailed Description
The following detailed description of embodiments of the present invention is provided in connection with the accompanying drawings and examples. The following examples are intended to illustrate the invention but are not intended to limit the scope of the invention.
Example 1:
as shown in fig. 1, the present invention mainly comprises the following steps:
step S1, collecting the configuration and operation data and alarm data of the equipment network management system; acquiring work order data of a work order system; the configuration and operation data comprises a plurality of configuration and operation records, the alarm data comprises a plurality of alarm records, and the work order data comprises a plurality of work order records;
step S2, judging whether any record is put in storage according to ID and content of any record in configuration and operation data, alarm data and work order data;
step S3, performing first association on the worksheet data in the database and the records with the same ID in the configuration and operation data; performing second association and marking on the alarm information of different influence levels according to the occurrence time and the clearing time of each alarm record; performing third association according to the start time and completion time of each work order record and the alarm record;
and step S4, generating event time point backtracking, event time point topology and event time point details according to the first association, the second association and the third association.
In this embodiment, referring to fig. 2, in order to facilitate public understanding of the technical solution of the present invention, a model schematic diagram of an equipment network management system is provided; the equipment network management system comprises a plurality of network elements, wherein the network elements are connected through ports and are also used for being connected with circuits. A network element may have N slots, 1 slot may have N ports, and 1 port may have N slots (e.g., SDH type) or only the port (e.g., PDH type).
In this embodiment, the optical path is specifically a connection between two network elements through SDH. The name of the connection is [ optical path ]; according to the port level, at least 63 time slots of VC12 levels are formed in 1 optical path. PDH port: the network element and other network elements are not connectable through the port.
In this embodiment, the circuit must pass [ optical path ] and occupy one of [ time slot ]. The egress can be SDH port (occupying one of the slots), PDH port (occupying the entire port).
In this embodiment, if 1 network element generates the alarm information a, the slot, port, and related optical path or circuit below the network element all generate the alarm N, but the generation time is equal to or longer than the generation time of the alarm information a; however, after the alarm information A is cleared, clearing time exists, and the clearing time of the alarm N is equal to or not more than 10 seconds of the clearing time of the alarm information A. Similarly, if 1 port alarms, the relevant optical path or circuit alarms N. In this embodiment, other network elements related to the present network element may be determined through the optical path information.
In order to generate time point backtracking, event time point topology and event time point details based on a time axis, first, information of a system needs to be collected.
In step S1, collecting configuration and operation data and alarm data of the device network management system; acquiring work order data of a work order system; the configuration and operation data comprises a plurality of configuration and operation records, the alarm data comprises a plurality of alarm records, and the work order data comprises a plurality of work order records.
In this implementation, the configuration and operation data includes: the network element, the board card corresponding to each slot position of the network element, the optical path connected with the network element, the carried circuit information and the adding and deleting modification information of the network element, the slot position, the optical path and the circuit; the work order data includes: the work order name, the work order type, the network element related to the work order, the light path and circuit information related to the work order, the work starting time of the work order and the work finishing time of the work order.
In this embodiment, each time the network element, the board card corresponding to each slot of the network element, the optical path connected to the network element, and the loaded circuit in the equipment network management system are added, deleted, or modified, the on/off of the devices in the equipment network management system is performed through the operation corresponding to the task issued in the work order system. Each addition, deletion, and modification can be recorded as an event. Each time of adding and deleting has creation time, modification time and deletion time.
In this embodiment, the relationship between the device network management system and the work order system includes:
relationship of alarm records: in addition to the burst alarm information (such as natural disaster and personal accident) of the equipment network management system, other alarm records are necessarily generated by the operation corresponding to the assigned task in the work order system: for example, when the optical path is interrupted after the "which optical path" is to be interrupted, the optical path may generate an alarm record in the device network management system, and if the related circuit of the optical path is not migrated to another optical path before, the related circuit may also generate an alarm record, and until the optical path is switched on, the corresponding alarm record may not be cleared.
Relationship of the running information: all the adding, deleting and modifying information of the network elements, the slot positions, the ports, the optical paths and the circuits of the equipment network management system are from the operation corresponding to the tasks issued in the work order system.
In this embodiment, the content included in the work order record mainly includes the related network element, optical path or circuit, the work order start time, and the work order completion time; according to the definition range of the related network element, optical path or circuit, the start time of the work order and the completion time of the work order are used for being associated and matched with the time range interval of the alarm record or the adding, deleting and modifying information; the work order name, type, is typically used to be recorded in an automatically generated report.
In step S2, to avoid redundant duplication of data, the data needs to be filtered accordingly to simplify the database. The method is to judge whether any record is put in storage according to the ID and the content of any record in the configuration and operation data, the alarm data and the work order data.
In this embodiment, the determining whether to put any record into the library according to the ID and the content of any record in the configuration and operation data, the alarm data, and the work order data specifically includes:
comparing the ID of each configuration and operation record with the ID stored in the database, and if the ID of the configuration and operation record does not exist in the database, directly warehousing the configuration and operation record and marking the creation time; if the ID of the configuration and operation record is stored in the database and the content of the configuration and operation record and the data recorded in the database change, updating the configuration and operation record in the database and updating the modification time; if the database stores the ID of the configuration and operation record but no content record, marking the configuration and operation record in the database as a deletion record and marking the deletion time;
comparing the ID of each alarm record with the ID stored in the database, and directly storing the alarm record in a warehouse if the ID of the alarm record does not exist in the database; if the ID of the alarm record exists in the database and the content of the alarm record and the data recorded in the database change, updating the alarm record in the database;
comparing the ID of each work order record with the ID stored in the database, and directly warehousing the work order record if the ID of the work order record does not exist in the database; if the ID of the work order record already exists in the database and the content of the work order record and the data recorded in the database change, the work order record in the database is further changed.
After the required data is input into the database, the data in the database can be processed to obtain the relation between different information, so as to generate a corresponding time axis.
In step S3, referring to fig. 3, 4, and 5, the work order data in the database and the record having the same ID as the configuration in the operation data are first associated; performing second association and marking on the alarm information of different influence levels according to the occurrence time and the clearing time of each alarm record; and performing third association according to the start time and completion time of each work order record and the alarm record.
In this implementation, the first association between the worksheet data in the database and the record with the same ID in the configuration and the operating data is specifically:
and performing first association on the ID of the network element, the ID of the optical path, the ID of the circuit and the configuration in each work order record of the work order data and the ID of the network element, the ID of the optical path and the ID of the circuit in each configuration and operation record of the operation data.
In this embodiment, when the network element, the optical path, and the circuit involved in the work order data need to be modified by addition or deletion, or other alarms exist in the device network itself, such as an interruption alarm at the network element level, the slot position and the slot position port below the network element can be affected, the port of the opposite-end network element related to the optical path can be affected, and an alarm related to the circuit of the network element, multiple multi-level alarms can be generated at the same time, and the multiple multi-level alarms respectively relate to the network element, the slot position, the port, the optical path, and the circuit; if the interruption alarm of the slot position level affects the port below the interruption alarm, affects the port of the opposite terminal network element related to the optical path and the alarm of the circuit related to the network element, a plurality of multi-level alarms are generated simultaneously and respectively relate to the slot position, the port, the optical path and the circuit; if the interruption alarm at the port level affects the port of the opposite-end network element related to the optical path and the alarm related to the circuit of the network element, a plurality of multi-level alarms are generated simultaneously and respectively related to the port, the optical path and the circuit; when an alarm clears, its associated alarm will also clear. Therefore, the alarm data of each level can be analyzed according to the alarm occurrence time and the alarm clearing time to find out the association relation. In addition, generally, during the time from the work order start time to the completion time, the network elements, optical paths and circuits related to the work order may generate alarms, so that the work order can be associated with the alarms, and whether the alarms are generated by normal service adjustment or other reasons can be further judged.
In this implementation, the second association and marking of the alarm information of different impact levels according to the occurrence time and the clearing time of each alarm record specifically includes:
the method comprises the steps of firstly, recording an alarm record for judgment as a current alarm record, judging the influence level of the current alarm record, searching for alarm records which are in a database except the current alarm record, have alarm occurrence time equal to or more than the alarm occurrence time of the current alarm record and have alarm clearing time equal to or less than 10 seconds of the alarm clearing time of the current alarm record, or have the alarm clearing time and the alarm clearing time of the current alarm record both empty and have network elements, slot positions and ports belonging to the content of the influence level of the current alarm record, and marking the derivative information of the searched alarm record to be derived from the current alarm record; the marked alarm records do not participate in searching and marking any more; the impact levels include: network element, slot, port.
The first step of the second association is exemplified:
if the analyzed alarm record a is a network element with the impact level, the actually affected network element name is the network element a, the alarm occurrence time is 14: 00 min 00 s at 11/16/2021, month and 16/2021, 00 min 00 s, then a record B is found, in which the actually affected network element name is the network element a, the slot position or the port has a value, the alarm occurrence time is equal to or greater than 14: 00 s at 11/16/2021, month and 16/2021, and the alarm clearing time is less than 10 s at 16: 00 p at 11/16/2021, of other alarm records, and the "derived information" of the record B is labeled as a record a; this record B is no longer sought by other records and no new annotation is made.
Analyzing the alarm records with the alarm influence level of a port in the alarm records, when the port has a light path relation, acquiring the information of the network element, the slot position and the port of the opposite end, searching the alarm records of which the alarm occurrence time is equal to or more than the alarm occurrence time of the current alarm record, the alarm clearing time is equal to or less than 10 seconds of the alarm clearing time of the current alarm record, or the alarm clearing time and the alarm clearing time of the current alarm record are empty, the network element, the slot position and the port are equal to the opposite end of the current alarm record, and marking the peer relation of the searched alarm records as peer derivation; the marked alarm records do not participate in searching and marking any more.
The second step of the second association is exemplified:
for example, in the analyzed alarm record a1, the influence level is port, the actually influenced slot port information of the network element is network element a 1-slot AA 1-port AAA1, the alarm occurrence time is 14: 00/second at 11/16/2021, and the alarm clearing time is 16: 00/second at 11/16/2021; the optical path connection information exists, the opposite-end network element is a network element B1-slot BB 1-port BBB1, then a record B1 which is the network element B1, has the slot BB1 and the port BBB1, has the alarm occurrence time equal to or more than 2021 year 11, 16, 14, 00, min and 10 s and has the alarm clearing time less than 2021 year 11, 16, 00, min and 10 s is found out, and the 'sibling relation' of the record B1 is marked as 'record A1'; the record B1 is no longer sought by other records and no new annotation is made.
In this implementation, the third association is performed according to the start time and completion time of each work order record and the alarm record, specifically:
analyzing the alarm record with the derived information being empty in the alarm record, searching the work order record with the work order starting time of the work order in the work order system being less than or equal to the alarm generation time of the alarm record, the completion time of the work order being less than or equal to the alarm clearing time of the alarm record, or the completion time of the work order and the alarm clearing time of the alarm record being empty, and the network elements and circuits related to the content of the work order and the network elements and circuits of the alarm record being consistent with the network elements and circuits of the alarm record, and marking the alarm generation work order of the alarm record as the name of the work order record; the marked alarm records do not participate in searching and marking any more.
The third association is exemplified:
if the analyzed alarm record C includes the network element with the impact level, the actually affected network element name is the network element a, the alarm occurrence time is 14: 00 min 00 s at 11/16/2021, month and 16/00 min 00 s at 2021, year, the actually affected network element name in the work order record is found to include the network element a, the start time is less than or equal to 14: 00 s at 11/16/2021, month and the completion time is less than or equal to 16: 00 min 00 s at 11/16/2021, the work order number C1 is found, and the "alarm generation work order" marked on the alarm record C is the "single number C1"; this record C is no longer sought by other records and no new annotation is made.
In this embodiment, referring to fig. 6, the generating event time point backtracking, event time point topology and event time point details according to the first association, the second association and the third association specifically includes:
marking the work order record, the alarm record, the configuration record and the operation record which are mutually associated at the same time point of a time axis to obtain event time point backtracking; generating a connection relation graph of the network element and the optical path at the moment according to the date corresponding to the event in the event time point backtracking; and generating the detail of the event time according to the work order record, the configuration and operation record and the alarm record included in the same time point.
In this embodiment, event time point backtracking: annotating the event information for each dimension with a timeline that supports dragging to present a record for each time period: configuration and operation information: the method comprises the information of adding, deleting and modifying the network elements, the slot positions, the light paths and the circuits, and the creation time, the modification time and the deletion time are taken as the standard. And (3) warning information: the alarm information of each influence level is included, and the alarm occurrence time is taken as the standard. And (4) work order information: the system comprises various work order information, and the start time of the work order is taken as the standard.
Event time point topology: presenting the network element and light path connection relation in the configuration and operation data according to the date of the selected event in the time axis, wherein if a certain network element and a light path have an alarm in the date, marking in the topology; the topology changes with the change in the records in the time axis.
Event time point details: presenting configuration and operation information, alarm information and work order information contents in a list according to the date of the selected event in the time axis; the record of the type of the alarm information does not show the labeled alarm record of the derivative information and the alarm generation work order, and the record of the type needs to be checked after the relevance is clicked by the corresponding work order type or the alarm record so as to carry out the convergence of the alarm display information; the record is clicked, and the content of the data change of the last 1 month recorded in the selected record before the date can be checked.
On the basis of the content of the above embodiment, the alarm report generation may be further performed: the alarm records in the list or the alarm records presented in association can be used for generating fault reports by the system, and the report contents mainly comprise the following contents: basic information of the alarm: namely the alarm name, the alarm occurrence time and the alarm clearing time. Generation of alarm work order information: namely, the associated work order information in the alarm generation work order comprises the name and the type of the work order, the involved network elements, the involved optical path and circuit information, the start time and the completion time. And alarm association alarm information: namely, the basic information of each alarm related to the alarm in the "derived information" and the "peer relationship". If the alarm influence level is a port, the performance data before the alarm occurs and after the alarm is cleared is presented, wherein the performance data comprises the performance data acquired last before the alarm occurs and the performance data acquired first after the alarm is cleared, and the performance data comprises received optical power and sent optical power.
The alarm report can record the incidence relation between the work order system and the equipment network management system in the power dispatching work, record the information of each object which mainly changes in the equipment network management system, carry out convergence management on the alarm record in the equipment network management system, and generate a fault report of data comparison before and after alarm and alarm correlation; the power dispatching personnel are not required to analyze each alarm in the equipment network management system and manually generate fault reports by combining the work order system information and performance data before and after the alarm tracking, so that the power dispatching operation and maintenance efficiency and the report quality are greatly improved.
Example 2:
referring to fig. 7 and 8, the present invention discloses an optical transmission fault recording and broadcasting system based on a time axis, including: the system comprises a data acquisition module 101, a data storage module 102, a data operation module 103 and an application function module 104;
the data acquisition module 101 is used for acquiring configuration and operation data and alarm data of a device network management system; acquiring work order data of a work order system; the configuration and operation data comprises a plurality of configuration and operation records, the alarm data comprises a plurality of alarm records, and the work order data comprises a plurality of work order records;
the data storage module 102 is configured to determine whether any record is stored according to the ID and content of any record in the configuration and operation data, the alarm data, and the work order data;
the data operation module 103 is configured to perform a first association on the worksheet data in the database and the records with the same ID in the configuration and operation data; performing second association and marking on the alarm information of different influence levels according to the occurrence time and the clearing time of each alarm record; performing third association according to the start time and completion time of each work order record and the alarm record;
the application function module 104 is configured to generate event time point backtracking, event time point topology, and event time point details according to the first association, the second association, and the third association.
In this implementation, the configuration and operation data includes: the network element, the board card corresponding to each slot position of the network element, the optical path connected with the network element, the carried circuit information and the adding and deleting modification information of the network element, the slot position, the optical path and the circuit; the work order data includes: the work order name, the work order type, the network element related to the work order, the light path and circuit information related to the work order, the work starting time of the work order and the work finishing time of the work order.
In this embodiment, the determining whether to put any record into a library according to the ID and the content of any record in the configuration and operation data, the alarm data, and the work order data specifically includes:
comparing the ID of each configuration and operation record with the ID stored in the database, and if the ID of the configuration and operation record does not exist in the database, directly storing the configuration and operation record in a warehouse and marking the creation time; if the ID of the configuration and operation record is stored in the database and the content of the configuration and operation record and the data recorded in the database change, updating the configuration and operation record in the database and updating the modification time; if the database stores the ID of the configuration and operation record but no content record, marking the configuration and operation record in the database as a deletion record and marking the deletion time;
comparing the ID of each alarm record with the ID stored in the database, and directly storing the alarm record in a warehouse if the ID of the alarm record does not exist in the database; if the ID of the alarm record exists in the database and the content of the alarm record and the data recorded in the database change, updating the alarm record in the database;
comparing the ID of each work order record with the ID stored in the database, and directly warehousing the work order record if the ID of the work order record does not exist in the database; if the ID of the work order record already exists in the database and the content of the work order record and the data recorded in the database change, the work order record in the database is further changed.
Example 2 was written based on example 1, and includes the same technical features as example 1, and therefore, the description of the same technical features and the technical features will not be repeated in example 2.
In summary, the embodiment of the present invention provides a system, which has the following beneficial effects: according to the obtained various data information, data screening is carried out to avoid easy data, and more systematic and automatic acquisition is carried out, so that higher labor cost expenditure of manpower records is avoided; by mining the incidence relation among the work order record, the configuration and operation record and the alarm record to generate event time point backtracking, event time point topology and event time point detail, the system fault reason can be conveniently traced by the working personnel, and the fault processing efficiency is improved.
The above description is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and substitutions can be made without departing from the technical principle of the present invention, and these modifications and substitutions should also be regarded as the protection scope of the present invention.
Claims (10)
1. A method for recording and broadcasting optical transmission faults based on a time axis is characterized by comprising the following steps:
acquiring configuration and operation data and alarm data of a device network management system; acquiring work order data of a work order system; the configuration and operation data comprises a plurality of configuration and operation records, the alarm data comprises a plurality of alarm records, and the work order data comprises a plurality of work order records;
judging whether any record is put into a warehouse or not according to the ID and the content of any record in the configuration and operation data, the alarm data and the work order data;
performing first association on the worksheet data in the database and the records with the same configuration and ID in the operating data; performing second association and marking on the alarm information of different influence levels according to the occurrence time and the clearing time of each alarm record; performing third association according to the start time and completion time of each work order record and the alarm record;
and generating event time point backtracking, event time point topology and event time point details according to the first association, the second association and the third association.
2. The method according to claim 1, wherein the configuration and operation data includes: the network element, the board card corresponding to each slot position of the network element, the optical path connected with the network element, the carried circuit information and the adding and deleting modification information of the network element, the slot position, the optical path and the circuit; the work order data includes: the work order name, the work order type, the network element related to the work order, the light path and circuit information related to the work order, the work starting time of the work order and the work finishing time of the work order.
3. The method according to claim 1, wherein the determining whether to put any record in storage is performed according to the ID and content of any record in the configuration and operation data, the alarm data, and the work order data, specifically:
comparing the ID of each configuration and operation record with the ID stored in the database, and if the ID of the configuration and operation record does not exist in the database, directly warehousing the configuration and operation record and marking the creation time; if the ID of the configuration and operation record is stored in the database and the content of the configuration and operation record and the data recorded in the database change, updating the configuration and operation record in the database and updating the modification time; if the database stores the ID of the configuration and operation record but no content record, marking the configuration and operation record in the database as a deletion record and marking the deletion time;
comparing the ID of each alarm record with the ID stored in the database, and directly storing the alarm record in a warehouse if the ID of the alarm record does not exist in the database; if the ID of the alarm record exists in the database and the content of the alarm record and the data recorded in the database change, updating the alarm record in the database;
comparing the ID of each work order record with the ID stored in the database, and directly warehousing the work order record if the ID of the work order record does not exist in the database; if the ID of the work order record already exists in the database and the content of the work order record and the data recorded in the database change, the work order record in the database is further changed.
4. The method for recording and broadcasting the optical transmission fault based on the time axis as claimed in claim 1, wherein the first association is performed on the worksheet data in the database and the record with the same configuration and ID in the operating data, specifically:
and performing first association on the ID of the network element, the ID of the optical path, the ID of the circuit and the configuration in each work order record of the work order data and the ID of the network element, the ID of the optical path and the ID of the circuit in each configuration and operation record of the operation data.
5. The method for recording and broadcasting the optical transmission fault based on the time axis as claimed in claim 1, wherein the second association and marking of the alarm information of different impact levels is performed according to the occurrence time and the clearing time of each alarm record, and specifically comprises:
recording the alarm record to be judged as the current alarm record, judging the influence level of the current alarm record, searching the alarm record of which the alarm occurrence time is equal to or more than the alarm occurrence time of the current alarm record except the current alarm record in a database, the alarm clearing time is equal to or not more than 10 seconds of the alarm clearing time of the current alarm record, or the alarm clearing time and the alarm clearing time of the current alarm record are both empty, and the network element, the slot position and the port belong to the content of the influence level of the current alarm record, and marking the derivative information of the searched alarm record, wherein the derivative information is derived from the current alarm record; the marked alarm records do not participate in searching and marking any more; the impact levels include: network element, slot position, port;
analyzing the alarm records with the alarm influence level of a port in the alarm records, when the port has a light path relation, acquiring the information of the network element, the slot position and the port of the opposite end, searching the alarm records of which the alarm occurrence time is equal to or more than the alarm occurrence time of the current alarm record, the alarm clearing time is equal to or less than 10 seconds of the alarm clearing time of the current alarm record, or the alarm clearing time and the alarm clearing time of the current alarm record are empty, the network element, the slot position and the port are equal to the opposite end of the current alarm record, and marking the peer relation of the searched alarm records as peer derivation; the marked alarm records do not participate in searching and marking any more.
6. The optical transmission fault recording and broadcasting method based on the time axis as claimed in claim 1, wherein the third association is performed according to the start time and completion time of each work order record and the alarm record, specifically:
analyzing the alarm record with the derived information being empty in the alarm record, searching the work order record with the work order starting time of the work order in the work order system being less than or equal to the alarm generation time of the alarm record, the completion time of the work order being less than or equal to the alarm clearing time of the alarm record, or the completion time of the work order and the alarm clearing time of the alarm record being empty, and the network elements and circuits related to the content of the work order and the network elements and circuits of the alarm record being consistent with the network elements and circuits of the alarm record, and marking the alarm generation work order of the alarm record as the name of the work order record; the marked alarm records do not participate in searching and marking any more.
7. The method for recording and broadcasting the optical transmission failure based on the time axis according to claim 1, wherein the event time point backtracking, the event time point topology and the event time point detail are generated according to the first association, the second association and the third association, and specifically:
marking the work order record, the alarm record, the configuration record and the operation record which are mutually associated at the same time point of a time axis to obtain event time point backtracking; generating a connection relation graph of the network element and the optical path at the moment according to the date corresponding to the event in the event time point backtracking; and generating the detail of the event time according to the work order record, the configuration and operation record and the alarm record included in the same time point.
8. An optical transmission fault recording and broadcasting system based on a time axis is characterized by comprising: the system comprises a data acquisition module, a data storage module, a data operation module and an application function module;
the data acquisition module is used for acquiring configuration and operation data and alarm data of a device network management system; acquiring work order data of a work order system; the configuration and operation data comprises a plurality of configuration and operation records, the alarm data comprises a plurality of alarm records, and the work order data comprises a plurality of work order records;
the data storage module is used for judging whether any record is stored in a storage according to the ID and the content of any record in the configuration and operation data, the alarm data and the work order data;
the data operation module is used for performing first association on the worksheet data in the database and the records with the same ID in the configuration and operation data; performing second association and marking on the alarm information of different influence levels according to the occurrence time and the clearing time of each alarm record; performing third association according to the start time and completion time of each work order record and the alarm record;
the application function module is used for generating event time point backtracking, event time point topology and event time point details according to the first association, the second association and the third association.
9. The system according to claim 8, wherein the configuration and operation data includes: the network element, the board card corresponding to each slot position of the network element, the optical path connected with the network element, the carried circuit information and the adding and deleting modification information of the network element, the slot position, the optical path and the circuit; the work order data includes: the work order name, the work order type, the network element related to the work order, the light path and circuit information related to the work order, the work starting time of the work order and the work finishing time of the work order.
10. The optical transmission fault recording and broadcasting system based on the time axis according to claim 8, wherein the determining whether to put any record in storage according to the ID and content of any record in the configuration and operation data, the alarm data and the work order data is specifically:
comparing the ID of each configuration and operation record with the ID stored in the database, and if the ID of the configuration and operation record does not exist in the database, directly warehousing the configuration and operation record and marking the creation time; if the ID of the configuration and operation record is stored in the database and the content of the configuration and operation record and the data recorded in the database change, updating the configuration and operation record in the database and updating the modification time; if the database stores the ID of the configuration and operation record but no content record, marking the configuration and operation record in the database as a deletion record and marking the deletion time;
comparing the ID of each alarm record with the ID stored in the database, and directly storing the alarm record in a warehouse if the ID of the alarm record does not exist in the database; if the ID of the alarm record exists in the database and the content of the alarm record and the data recorded in the database change, updating the alarm record in the database;
comparing the ID of each work order record with the ID stored in the database, and directly warehousing the work order record if the ID of the work order record does not exist in the database; if the ID of the work order record already exists in the database and the content of the work order record and the data recorded in the database change, the work order record in the database is further changed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210046375.6A CN114500230B (en) | 2022-01-14 | 2022-01-14 | Optical transmission fault recording and broadcasting method and system based on time axis |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210046375.6A CN114500230B (en) | 2022-01-14 | 2022-01-14 | Optical transmission fault recording and broadcasting method and system based on time axis |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114500230A true CN114500230A (en) | 2022-05-13 |
| CN114500230B CN114500230B (en) | 2024-01-26 |
Family
ID=81511937
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210046375.6A Active CN114500230B (en) | 2022-01-14 | 2022-01-14 | Optical transmission fault recording and broadcasting method and system based on time axis |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114500230B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102075344A (en) * | 2009-11-20 | 2011-05-25 | 中国移动通信集团北京有限公司 | Work order distributing method and alarm information filtering device in communication network |
| CN104573100A (en) * | 2015-01-29 | 2015-04-29 | 无锡江南计算技术研究所 | Step-by-step database synchronization method with autoincrement identifications |
| CN105427039A (en) * | 2015-05-22 | 2016-03-23 | 国网青海省电力公司西宁供电公司 | Efficient processing method of distribution network repair work orders based on responsibility areas |
| CN106789347A (en) * | 2017-01-22 | 2017-05-31 | 山东浪潮商用系统有限公司 | A kind of method that alarm association and network fault diagnosis are realized based on alarm data |
| WO2019141144A1 (en) * | 2018-01-17 | 2019-07-25 | 华为技术有限公司 | Method and apparatus for determining network failure |
| CN111460242A (en) * | 2020-03-25 | 2020-07-28 | 天津市中力神盾电子科技有限公司 | Alarm query processing method and device for power distribution management system |
| CN112399284A (en) * | 2020-10-22 | 2021-02-23 | 成都中讯创新科技股份有限公司 | Service configuration method of optical network unit |
| CN113256244A (en) * | 2021-04-30 | 2021-08-13 | 新奇点智能科技集团有限公司 | Method, device and equipment for generating alarm work order by intelligent traffic cloud management platform and storage medium |
-
2022
- 2022-01-14 CN CN202210046375.6A patent/CN114500230B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102075344A (en) * | 2009-11-20 | 2011-05-25 | 中国移动通信集团北京有限公司 | Work order distributing method and alarm information filtering device in communication network |
| CN104573100A (en) * | 2015-01-29 | 2015-04-29 | 无锡江南计算技术研究所 | Step-by-step database synchronization method with autoincrement identifications |
| CN105427039A (en) * | 2015-05-22 | 2016-03-23 | 国网青海省电力公司西宁供电公司 | Efficient processing method of distribution network repair work orders based on responsibility areas |
| CN106789347A (en) * | 2017-01-22 | 2017-05-31 | 山东浪潮商用系统有限公司 | A kind of method that alarm association and network fault diagnosis are realized based on alarm data |
| WO2019141144A1 (en) * | 2018-01-17 | 2019-07-25 | 华为技术有限公司 | Method and apparatus for determining network failure |
| CN111460242A (en) * | 2020-03-25 | 2020-07-28 | 天津市中力神盾电子科技有限公司 | Alarm query processing method and device for power distribution management system |
| CN112399284A (en) * | 2020-10-22 | 2021-02-23 | 成都中讯创新科技股份有限公司 | Service configuration method of optical network unit |
| CN113256244A (en) * | 2021-04-30 | 2021-08-13 | 新奇点智能科技集团有限公司 | Method, device and equipment for generating alarm work order by intelligent traffic cloud management platform and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 曾俊;: "集中监控下的工单派发研究", 信息通信, no. 10 * |
| 潘洋: "中国联通电子运行维护系统—工单模块设计与实现", 《中国优秀硕士论文电子期刊网》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114500230B (en) | 2024-01-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102483025B1 (en) | Operational maintenance systems and methods | |
| US7043661B2 (en) | Topology-based reasoning apparatus for root-cause analysis of network faults | |
| US7010718B2 (en) | Method and system for supporting network system troubleshooting | |
| US5771274A (en) | Topology-based fault analysis in telecommunications networks | |
| CN108650140B (en) | Automatic auxiliary analysis method and system for service fault of optical transmission equipment | |
| US5745693A (en) | System for gathering and reporting real time data from an IDNX communications network | |
| CN101997709B (en) | Root alarm data analysis method and system | |
| CN101197621B (en) | Method and system for remote diagnosing and locating failure of network management system | |
| JP2021517370A (en) | Topology processing methods, equipment, and systems | |
| US20130176858A1 (en) | Method for Determining a Severity of a Network Incident | |
| CN100495978C (en) | A method and apparatus for fault location in communication network | |
| US8483091B1 (en) | Automatic displaying of alarms in a communications network | |
| CN104574219A (en) | System and method for monitoring and early warning of operation conditions of power grid service information system | |
| CN113505048A (en) | Unified monitoring platform based on application system portrait and implementation method | |
| CN105207797A (en) | Fault locating method and fault locating device | |
| CN104639386A (en) | Fault positioning system and method | |
| CN109818795B (en) | Fault analysis method and system for intelligent service dynamic switching | |
| CN112182233A (en) | Knowledge base for storing equipment fault records and method and system for assisting in locating equipment fault by using knowledge base | |
| US7796500B1 (en) | Automated determination of service impacting events in a communications network | |
| CN114500230A (en) | Optical transmission fault recording and broadcasting method and system based on time axis | |
| US7701843B1 (en) | Intelligent-topology-driven alarm placement | |
| CN113821412A (en) | Equipment operation and maintenance management method and device | |
| CN110609761A (en) | Method and device for determining fault source, storage medium and electronic equipment | |
| US20030088319A1 (en) | Supervisory control apparatus | |
| US8015278B1 (en) | Automating alarm handling in a communications network using network-generated tickets and customer-generated tickets |
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 |