CN116910313A - Database establishment method and device and electronic equipment - Google Patents
Database establishment method and device and electronic equipment Download PDFInfo
- Publication number
- CN116910313A CN116910313A CN202310822736.6A CN202310822736A CN116910313A CN 116910313 A CN116910313 A CN 116910313A CN 202310822736 A CN202310822736 A CN 202310822736A CN 116910313 A CN116910313 A CN 116910313A
- Authority
- CN
- China
- Prior art keywords
- target
- equipment
- topological relation
- database
- relation diagram
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 56
- 238000010586 diagram Methods 0.000 claims abstract description 91
- 238000001514 detection method Methods 0.000 claims description 57
- 238000004590 computer program Methods 0.000 claims description 13
- 238000003860 storage Methods 0.000 claims description 10
- 238000009434 installation Methods 0.000 abstract description 11
- 238000012423 maintenance Methods 0.000 abstract description 10
- 230000002159 abnormal effect Effects 0.000 abstract description 7
- 230000003287 optical effect Effects 0.000 description 64
- 238000013461 design Methods 0.000 description 17
- 239000013307 optical fiber Substances 0.000 description 12
- 230000006870 function Effects 0.000 description 10
- 238000009826 distribution Methods 0.000 description 9
- 238000003780 insertion Methods 0.000 description 9
- 230000037431 insertion Effects 0.000 description 9
- 230000008569 process Effects 0.000 description 7
- 238000012545 processing Methods 0.000 description 7
- 238000010276 construction Methods 0.000 description 6
- 238000003745 diagnosis Methods 0.000 description 6
- 230000005856 abnormality Effects 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000000739 chaotic effect Effects 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9024—Graphs; Linked lists
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Small-Scale Networks (AREA)
Abstract
A method and a device for establishing a database and electronic equipment are provided, wherein the method comprises the following steps: obtaining a device information set corresponding to target devices and an initial topological relation diagram, determining target nodes corresponding to the target devices in the initial topological relation diagram, associating the target nodes with the device information set, generating a target topological relation diagram corresponding to the initial topological relation diagram, determining a target structure relation chain corresponding to the target devices from the target topological relation diagram, and generating a target database based on the target topological relation diagram and the target structure relation chain. By the method, the target database comprises the device information set of the target device and the topological connection structure diagram of the target device in the PON network architecture, so that the installation and operation and maintenance of the target device can be realized based on the target database, the abnormal link or abnormal device in the PON network architecture can be diagnosed in time based on the target database, and the convenience of PON ODN management is improved.
Description
Technical Field
The present application relates to the field of network security technologies, and in particular, to a method and an apparatus for establishing a database, and an electronic device.
Background
With the development of network security technologies, normal communication of people is generally implemented based on a PON network architecture, where the PON network architecture is composed of an optical line terminal (in english: optical Line Terminal, abbreviated as OLT), an optical network unit (in english: optical Network Unit, abbreviated as ONU), and an optical distribution network (in english: optical Distribution Network, abbreviated as ODN), where the ODN is an important component of the PON network, and is an optical transmission channel connecting the OLT and the ONU, and mainly includes: optical fiber cables, optical connectors, optical splitters, distribution boxes, splice enclosures, and the like.
In the process of PON ODN network construction installation and operation and maintenance, a record of a new installation port or a new cable resource is related, and the port or the cable resource is maintained, when a device in the PON network architecture fails or connection between ODN devices is abnormal due to loss, because information of the ODN devices in the PON network architecture is in a disordered and chaotic state, a maintainer cannot know the failed device and the abnormal connection node, and a device needs to be sequentially detected based on a construction route of the PON network architecture, so that diagnosis and fault removal cannot be performed on the device in PON ODN network construction in time, thereby wasting a great deal of time and resources.
Disclosure of Invention
The application provides a method and a device for establishing a database and electronic equipment, wherein the target database is established, so that the relation between target equipment and other equipment in a PON network architecture is visualized through a target topological relation diagram.
In a first aspect, the present application provides a method for establishing a database, the method comprising:
obtaining a device information set corresponding to target device and an initial topological relation diagram, wherein the initial topological relation diagram comprises all topological relation structure diagrams with the target device;
determining a target node corresponding to the target device in the initial topological relation diagram, and associating the target node with the device information set to generate a target topological relation diagram corresponding to the initial topological relation diagram;
and determining a target structure relation chain corresponding to the target equipment from the target topological relation diagram, and generating a target database based on the target topological relation diagram and the target structure relation chain.
By the method, the target database is determined, and the target nodes in the initial topological relation diagram are associated with the equipment information set, so that the accuracy of the target database is ensured, and the equipment is favorably installed and maintained based on the target database.
In one possible design, the obtaining the device information set corresponding to the target device includes:
acquiring equipment information and detection data corresponding to the target equipment, wherein the equipment information at least comprises equipment model, equipment image information and equipment ports;
a device information set is generated based on the device information and the detection data.
By the method, the diversity of information in the equipment information set is ensured, the equipment information set contains various types of data corresponding to the target equipment, and the accuracy of generating the target database based on the equipment information set is facilitated.
In one possible design, the determining the target node corresponding to the target device in the initial topological relation diagram includes:
determining a device identifier corresponding to the target device;
determining a data node corresponding to the target equipment in an initial topological relation diagram based on the equipment identifier;
and taking the data node as a target node corresponding to the target equipment.
By the method, the target node of the target device is determined in the initial topological relation diagram, so that the target device achieves the aim of visualization.
In one possible design, the determining, from the target topological relation diagram, a target structural relation chain corresponding to the target device includes:
determining that the target equipment corresponds to the target node;
determining all associated nodes connected with the target node from the target topological relation diagram, wherein the associated nodes are adjacent nodes of the target node;
and generating a target structure relation chain corresponding to the target equipment based on the target node and all the associated nodes.
By the method, the target structure relation chain corresponding to the target equipment is determined based on the target node, so that the framework between the target equipment and other equipment in the optical link is clearer.
In one possible design, after the determining the target database, the method further includes:
acquiring preset detection data corresponding to the target equipment, and calculating a target error between the preset detection data and the detection data;
judging whether the target error is smaller than a preset error or not;
if yes, reserving the preset detection data in the target database;
if not, replacing the preset detection data in the target database with the detection data.
By the method, the optical link is detected, and when the target error is smaller than the preset error, the preset detection data are replaced by the detection data, so that the update of the target database is realized, and the accuracy of the target database is ensured.
In one possible design, after the determining the target database, the method further includes:
acquiring a current equipment identifier corresponding to current equipment;
matching the current equipment identifier with a preset equipment identifier;
and when the consistent equipment identifiers are matched, equipment information corresponding to the current equipment identifier is called from the target database.
By the method, when the user determines that the current equipment identifier of the current equipment is in the target database, the equipment information of the current equipment can be called out, and the installation and operation and maintenance of the equipment based on the target database are ensured.
In a second aspect, the present application provides a database creation apparatus, the apparatus comprising:
the acquisition module is used for acquiring a device information set corresponding to the target device and an initial topological relation diagram;
the determining module is used for determining a target node corresponding to the target device in the initial topological relation diagram, associating the target node with the device information set and generating a target topological relation diagram corresponding to the initial topological relation diagram;
and the target module is used for determining a target structure relation chain corresponding to the target equipment from the target topological relation diagram and generating a target database based on the target topological relation diagram and the target structure relation chain.
In one possible design, the obtaining module is specifically configured to obtain device information and detection data corresponding to the target device, and generate a device information set based on the device information and the detection data.
In one possible design, the determining module is specifically configured to determine an equipment identifier corresponding to the target equipment, determine, based on the equipment identifier, a data node corresponding to the target equipment in an initial topological relation diagram, and use the data node as a target node corresponding to the target equipment.
In one possible design, the determining module is further configured to determine that the target device corresponds to the target node, determine all association nodes connected to the target node from the target topology relationship graph, and generate a target structure relationship chain corresponding to the target device based on the target node and all association nodes.
In one possible design, the target module is specifically configured to obtain preset detection data corresponding to the target device, calculate a target error between the preset detection data and the detection data, determine whether the target error is smaller than a preset error, if yes, reserve the preset detection data in the target database, and if no, replace the preset detection data in the target database with the detection data.
In one possible design, the target module is further configured to obtain a current device identifier corresponding to a current device, match the current device identifier with a preset device identifier, and retrieve device information corresponding to the current device identifier from the target database when a consistent device identifier is matched.
In a third aspect, the present application provides an electronic device, comprising:
a memory for storing a computer program;
and the processor is used for realizing the steps of the method for establishing the database when executing the computer program stored in the memory.
In a fourth aspect, a computer readable storage medium has stored therein a computer program which, when executed by a processor, implements the steps of a method of creating a database as described above.
The technical effects of each of the first to fourth aspects and the technical effects that may be achieved by each aspect are referred to above for the technical effects that may be achieved by the first aspect or the various possible aspects of the first aspect, and are not repeated here.
Drawings
FIG. 1 is a flowchart showing the steps of a method for creating a database according to the present application;
FIG. 2 is a schematic diagram of the optical time domain reflectometer for optical link according to the present application;
FIG. 3 is a schematic diagram illustrating fault diagnosis of an optical link by using an optical time domain reflectometer according to the present application;
fig. 4 is a schematic structural diagram of a database building apparatus according to the present application;
fig. 5 is a schematic structural diagram of an electronic device according to the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings. The specific method of operation in the method embodiment may also be applied to the device embodiment or the system embodiment. In the description of the present application, "a plurality of" means "at least two". "and/or", describes an association relationship of an association object, and indicates that there may be three relationships, for example, a and/or B, and may indicate: a exists alone, A and B exist together, and B exists alone. A is connected with B, and can be represented as follows: both cases of direct connection of A and B and connection of A and B through C. In addition, in the description of the present application, the words "first," "second," and the like are used merely for distinguishing between the descriptions and not be construed as indicating or implying a relative importance or order.
In the prior art, in the process of PON ODN network construction, installation and operation and maintenance, a record of a new installation port or a new cable resource is involved, and the port or the cable resource is maintained, when a device in a PON network architecture fails or connection between ODN devices is abnormal due to loss, because information of the ODN devices in the PON network architecture is in a disordered state, maintenance personnel need to sequentially detect the devices based on a construction route of the PON network architecture, so that the devices in PON ODN network construction cannot be diagnosed in time and the devices cannot be removed from the PON network architecture, and management on the ODN devices in the PON network architecture cannot be performed.
In order to solve the above-described problems, an embodiment of the present application provides a method for establishing a database, by establishing a target database including a target structure relationship chain corresponding to each target device, a topology relationship diagram of the target device in a PON network architecture is visualized, so that when a device in the PON network architecture fails, a failure device in the PON network architecture can be diagnosed in time. The method and the device according to the embodiments of the present application are based on the same technical concept, and because the principles of the problems solved by the method and the device are similar, the embodiments of the device and the method can be referred to each other, and the repetition is not repeated.
Embodiments of the present application will be described in detail below with reference to the accompanying drawings.
Referring to fig. 1, the present application provides a method for establishing a database, which can record and manage a target device in a PON network architecture based on the target database, and can implement rapid diagnosis and operation and maintenance of a fault device through the target database, and the implementation flow of the method is as follows:
step S1: and obtaining a device information set corresponding to the target device and an initial topological relation diagram.
Because various different types of devices are involved in the PON network, and optical fibers, optical cables, and the like are required to be connected between the different types of devices, the target device in the embodiment of the present application may be an ODN device, so that in order to more clearly illustrate the establishment of the target database, the embodiment of the present application is only illustrated by taking one target device as an example.
First, it is necessary to obtain a device information set of a target device, the device information set including device information of the target device and detection data of the target device, the device information including at least: the device type of the target device, the device image information of the target device, and the port information of the target device may further include a device port type, a device port number, an optical fiber type, an optical cable type, an optical fiber core number, an optical cable core number, a device port usage state, an occupied or free optical fiber, and a target device installation step description, where the information in the device information may be increased or decreased according to the actual situation, and will not be described in any more.
In the optical link, the detection data is obtained by detecting the target device, and the optical time domain reflectometer may be used to detect the target device, and since the detection of the target device based on the optical time domain reflectometer is a technology known to those skilled in the art, the detection will not be described in detail herein.
In the actual scenario of the PON network architecture, there is a connection relationship between devices in the same network architecture, and the connection relationship between devices in the PON network architecture is represented by using a topology relationship diagram, so that an initial topology relationship diagram corresponding to a target device needs to be obtained, where the initial topology relationship diagram includes all topology relationship structure diagrams with the target device.
Because the device information sets store various types of information, when the more related device information in the device information sets are, the more functions of device installation, device capacity expansion and device operation and maintenance are realized based on the device information sets, the target database is ensured to be practical in more actual scenes, and data support is provided for device installation and device operation and maintenance.
Step S2: and determining a target node corresponding to the target device in the initial topological relation diagram, and associating the target node with the device information set to generate a target topological relation diagram corresponding to the initial topological relation diagram.
After the initial topological relation diagram corresponding to the target equipment is obtained, in order to visualize the connection relation between the target equipment and other equipment, the equipment identification corresponding to the target equipment needs to be determined, the data node corresponding to the target equipment is determined in the initial topological relation diagram based on the equipment identification, the data node is used as the target node corresponding to the target equipment, and when the user side equipment is accessed, the system can automatically generate a visual model of the PON ODN network framework, so that the automatic updating of the equipment topological relation diagram is realized, and the accuracy of the equipment topological relation diagram is improved.
Because the initial topological relation diagram lacks the device information set of the target device, in order to improve the practicability of the target database, the installation and operation of the device can be realized based on the target database, the target node of the target device and the device information set are required to be associated, the initial topological relation diagram associated with the device information set is taken as the target topological relation diagram, and each node in the target topological relation diagram is associated with a corresponding device information set, which is not described too much.
By the method, the target topological relation diagram corresponding to the target equipment is determined, so that each data node in the target topological relation diagram is associated with the corresponding equipment information set, and the accuracy and convenience of the target topological relation diagram are improved.
Step S3: and determining a target structure relation chain corresponding to the target equipment from the target topological relation diagram, and generating a target database based on the target topological relation diagram and the target structure relation chain.
In order to manage devices in the PON network architecture based on the target database, the target database needs to be obtained, and the specific process of generating the target database is as follows:
determining a target node from a target topological relation diagram, determining all associated nodes connected with the target node from the target topological relation diagram, wherein the associated nodes are adjacent nodes of the target node, generating a target structure relation chain corresponding to the target node and all the associated nodes based on the logic relation between the target node and all the associated nodes in the target topological relation diagram, and then placing the target structure relation chain in a target database.
The target database contains target structure relation chains corresponding to the devices and target topological relation diagrams among the devices, so that the devices can be installed and managed based on the target database. After determining the target database, in order to ensure the detection accuracy of the PON ODN network architecture, it is necessary to detect the performance of the target device, and determine the detection data corresponding to the target device, where a specific confirmation process is as follows:
in order to detect the optical link in the PON network architecture, determining preset detection data corresponding to target equipment, judging target errors between the prediction detection data and the detection data, and in order to determine whether the optical link fails or not, whether the target errors are smaller than the preset errors or not, if so, keeping the preset detection data in a target database; if not, replacing the preset detection data in the target database with the detection data.
Further, when the target error is smaller than the preset error, it represents that the optical link in the PON network architecture is normal.
Example one: as shown in fig. 2, a block diagram of a PON network architecture is connected to a PON OLT device and an optical splitter device via an optical cable, and is connected to a PON ONU terminal via an optical cable, and when detecting the PON network architecture, a detection device needs to be connected to the PON OLT device, and the detection device may be an optical time domain reflectometer.
Further, if the PON network architecture provides broadband services for a subscriber side terminal, it is generally required to detect network connection between a machine room and the subscriber side terminal, and because the machine room provides broadband for the subscriber side terminal through optical fibers, it is required to detect whether equipment corresponding to each node between the machine room and the subscriber side terminal is in a normal state, in fig. 2, the optical fibers are accessed into the machine room through an optical fiber distribution frame accessing the machine room, then the optical fiber distribution frame is connected with a primary optical cross-connect box through a main optical cable, and the primary optical cross-connect box is connected with a secondary optical cross-connect box through a distribution optical cable, where the subscriber side terminal accesses to the secondary optical cross-connect box through an introducing optical fiber.
In order to ensure the accuracy of detecting the connection abnormality between the machine room and the user side terminal, it is necessary to detect whether the optical time domain reflectometer port, the movable connector, the optical splitter insertion loss, the movable connector insertion loss and the optical reflection of the optical fiber connection of the user side terminal are within the normal range, respectively, wherein the link with the optical reflection power within the range of [ -21dBm, -35dBm ] is used as the normal link, the link with the optical reflection power less than-15 dBm is used as the abnormal link, and dBm is a power unit based on the decibel scale.
It is obvious that in fig. 2, the optical reflection of the movable connector is normal, the optical reflection of the insertion loss of the optical splitter is normal, if the insertion loss of the movable connector is less than 0.5 and 0.3<0.5, the insertion loss of the movable connector is normal, and the optical reflection of the optical fiber connection of the user side terminal is normal.
When the optical link detection acceptance in fig. 2 is normal, the detection time, the detection device, and the like of the above-described detection-related path may be updated to the target database.
Example two: the fault diagnosis of the optical link by the optical time domain reflectometer is shown in fig. 3, the optical time domain reflectometer is used to query the optical reflection corresponding to each node in the PON network architecture, and since the connection of the PON network architecture in fig. 3 is the same as that in fig. 2, the description is not repeated here, and the connection between the machine room and the user terminal on the basis of the PON network architecture is referred to the description in fig. 2.
In fig. 3, the optical time domain reflectometer tests that the optical reflection of the port connected to the computer room is in a normal range, the optical reflection of the movable connector is-25 dBm, the standard test data recorded in the target database is-26 dBm, and the optical reflection of the movable connector is normal; the insertion loss of the optical splitter is detected to be 16.9dBm, if the insertion loss recorded in the target database is 16.8dB, if the target error is 0.3 and 0.1<0.3, the insertion loss of the optical splitter is normal; when the insertion loss of the movable connection of the secondary optical distribution box is-12 dBm, the normal loss recorded in the target database is 0.3 dBm-12 >0.3, so that the light reflection of the secondary optical distribution box is abnormal; when the light reflection of the user side terminal is-20 dBm and the light reflection recorded in the target database is-20 dBm, determining that the light reflection of the user side terminal is normal.
When the optical link abnormality is detected, the target database is not updated, and the optical reflection abnormality of the second-stage optical distribution box is determined through the detection of the optical time domain reflectometer, so that a manager can further perform fault diagnosis based on the determined detection result, and the accuracy of optical link detection based on the target database is improved.
In addition, after the target database is determined, when the current equipment identifier corresponding to the current equipment is obtained, in order to determine whether the information corresponding to the current equipment is recorded in the target database, the current equipment identifier needs to be matched with the preset equipment identifier, and when the consistent equipment identifier is matched, the equipment information corresponding to the current equipment identifier is called from the target database, so that the equipment can be installed based on the target database.
Based on the method, the device information set corresponding to the target device and the initial topological relation diagram are collected, the target database is determined, the device information can be updated based on the target database, and the target device can be visualized in the PON network architecture based on the target topological relation diagram, so that the installation or operation and maintenance of the target device can be realized based on the target database, and further the diagnosis can be performed on the optical link based on the target database, so that the ODN devices in the PON network architecture have a logical relation, and the convenience of the ODN device management operation and maintenance is improved.
Based on the same inventive concept, the embodiment of the present application further provides a database establishing device, where the database establishing device is configured to implement a function of a database establishing method, and referring to fig. 4, the device includes:
an obtaining module 401, configured to obtain a device information set corresponding to a target device and an initial topological relation diagram;
a determining module 402, configured to determine a target node corresponding to the target device in the initial topological relation diagram, associate the target node with the device information set, and generate a target topological relation diagram corresponding to the initial topological relation diagram;
and the target module 403 is configured to determine a target structure relationship chain corresponding to the target device from the target topological relation diagram, and generate a target database based on the target topological relation diagram and the target structure relationship chain.
In one possible design, the obtaining module 401 is specifically configured to obtain device information and detection data corresponding to the target device, and generate a device information set based on the device information and the detection data.
In one possible design, the determining module 402 is specifically configured to determine a device identifier corresponding to the target device, determine, based on the device identifier, a data node corresponding to the target device in an initial topological relation diagram, and use the data node as a target node corresponding to the target device.
In one possible design, the determining module 402 is further configured to determine that the target device corresponds to the target node, determine all association nodes connected to the target node from the target topology relationship graph, and generate a target structure relationship chain corresponding to the target device based on the target node and all association nodes.
In one possible design, the target module 403 is specifically configured to obtain preset detection data corresponding to the target device, calculate a target error between the preset detection data and the detection data, determine whether the target error is smaller than a preset error, if yes, reserve the preset detection data in the target database, and if no, replace the preset detection data in the target database with the detection data.
In one possible design, the target module 403 is further configured to obtain a current device identifier corresponding to a current device, match the current device identifier with a preset device identifier, and retrieve device information corresponding to the current device identifier from the target database when a consistent device identifier is matched.
Based on the same inventive concept, the embodiment of the present application further provides an electronic device, where the electronic device may implement the function of the foregoing database building apparatus, and referring to fig. 5, the electronic device includes:
the embodiment of the present application is not limited to a specific connection medium between the processor 501 and the memory 502, and the processor 501 and the memory 502 are exemplified in fig. 5 by a connection between the processor 501 and the memory 502 through the bus 500. The connection between the other components of bus 500 is shown in bold lines in fig. 5, and is merely illustrative and not limiting. Bus 500 may be divided into an address bus, a data bus, a control bus, etc., and is represented by only one thick line in fig. 5 for ease of illustration, but does not represent only one bus or one type of bus. Alternatively, the processor 501 may be referred to as a controller, and the names are not limited.
In the embodiment of the present application, the memory 502 stores instructions executable by the at least one processor 501, and the at least one processor 501 may execute a database creation method as described above by executing the instructions stored in the memory 502. The processor 501 may implement the functions of the various modules in the apparatus shown in fig. 4.
The processor 501 is a control center of the device, and various interfaces and lines can be used to connect various parts of the entire control device, and by executing or executing instructions stored in the memory 502 and invoking data stored in the memory 502, various functions of the device and processing data can be performed to monitor the device as a whole.
In one possible design, processor 501 may include one or more processing units, and processor 501 may integrate an application processor and a modem processor, where the application processor primarily processes operating systems, user interfaces, application programs, and the like, and the modem processor primarily processes wireless communications. It will be appreciated that the modem processor described above may not be integrated into the processor 501. In some embodiments, processor 501 and memory 502 may be implemented on the same chip, or they may be implemented separately on separate chips in some embodiments.
The processor 501 may be a general purpose processor such as a Central Processing Unit (CPU), digital signal processor, application specific integrated circuit, field programmable gate array or other programmable logic device, discrete gate or transistor logic device, discrete hardware components, and may implement or perform the methods, steps and logic blocks disclosed in embodiments of the present application. The general purpose processor may be a microprocessor or any conventional processor or the like. The steps of a database establishing method disclosed in connection with the embodiment of the present application may be directly embodied as execution completion by a hardware processor, or may be executed by a combination of hardware and software modules in the processor.
The memory 502, as a non-volatile computer readable storage medium, may be used to store non-volatile software programs, non-volatile computer executable programs, and modules. The Memory 502 may include at least one type of storage medium, and may include, for example, flash Memory, hard disk, multimedia card, card Memory, random access Memory (Random Access Memory, RAM), static random access Memory (Static Random Access Memory, SRAM), programmable Read-Only Memory (Programmable Read Only Memory, PROM), read-Only Memory (ROM), charged erasable programmable Read-Only Memory (Electrically Erasable Programmable Read-Only Memory), magnetic Memory, magnetic disk, optical disk, and the like. Memory 502 is any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer, but is not limited to such. The memory 502 in embodiments of the present application may also be circuitry or any other device capable of performing storage functions for storing program instructions and/or data.
By programming the processor 501, the code corresponding to the method for creating a database described in the foregoing embodiment may be cured into the chip, so that the chip can execute the steps for creating a database in the embodiment shown in fig. 1 at run-time. How to design and program the processor 501 is a technique well known to those skilled in the art, and will not be described in detail herein.
Based on the same inventive concept, the embodiments of the present application also provide a storage medium storing computer instructions that, when executed on a computer, cause the computer to perform a method of creating a database as previously discussed.
In some possible embodiments, the application provides a method of establishing a database, the aspects of which can also be implemented in the form of a program product comprising program code for causing the control apparatus to carry out the steps of a method of establishing a database according to the various exemplary embodiments of the application as described in the specification, when the program product is run on a device.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present application without departing from the spirit or scope of the application. Thus, it is intended that the present application also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.
Claims (10)
1. A method for creating a database, comprising:
obtaining a device information set corresponding to target device and an initial topological relation diagram, wherein the initial topological relation diagram comprises all topological relation structure diagrams with the target device;
determining a target node corresponding to the target device in the initial topological relation diagram, and associating the target node with the device information set to generate a target topological relation diagram corresponding to the initial topological relation diagram;
and determining a target structure relation chain corresponding to the target equipment from the target topological relation diagram, and generating a target database based on the target topological relation diagram and the target structure relation chain.
2. The method of claim 1, wherein the obtaining the device information set corresponding to the target device comprises:
acquiring equipment information and detection data corresponding to the target equipment, wherein the equipment information at least comprises equipment model, equipment image information and equipment ports;
a device information set is generated based on the device information and the detection data.
3. The method of claim 1, wherein the determining the target node corresponding to the target device in the initial topological graph comprises:
determining a device identifier corresponding to the target device;
determining a data node corresponding to the target equipment in an initial topological relation diagram based on the equipment identifier;
and taking the data node as a target node corresponding to the target equipment.
4. The method of claim 3, wherein the determining, from the target topology map, a target structure relationship chain corresponding to the target device comprises:
determining that the target equipment corresponds to the target node;
determining all associated nodes connected with the target node from the target topological relation diagram, wherein the associated nodes are adjacent nodes of the target node;
and generating a target structure relation chain corresponding to the target equipment based on the target node and all the associated nodes.
5. The method of claim 1, wherein after the determining the target database, further comprising:
acquiring preset detection data corresponding to the target equipment, and calculating a target error between the preset detection data and the detection data;
judging whether the target error is smaller than a preset error or not;
if yes, reserving the preset detection data in the target database;
if not, replacing the preset detection data in the target database with the detection data.
6. The method of claim 1, wherein after the determining the target database, further comprising:
acquiring a current equipment identifier corresponding to current equipment;
matching the current equipment identifier with a preset equipment identifier;
and when the consistent equipment identifiers are matched, equipment information corresponding to the current equipment identifier is called from the target database.
7. A database creation apparatus, comprising:
the acquisition module is used for acquiring a device information set corresponding to the target device and an initial topological relation diagram;
the determining module is used for determining a target node corresponding to the target device in the initial topological relation diagram, associating the target node with the device information set and generating a target topological relation diagram corresponding to the initial topological relation diagram;
and the target module is used for determining a target structure relation chain corresponding to the target equipment from the target topological relation diagram and generating a target database based on the target topological relation diagram and the target structure relation chain.
8. The apparatus of claim 7, wherein the obtaining module is specifically configured to obtain device information and detection data corresponding to the target device, and generate a device information set based on the device information and the detection data.
9. An electronic device, comprising:
a memory for storing a computer program;
a processor for carrying out the method steps of any one of claims 1-6 when executing a computer program stored on said memory.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored therein a computer program which, when executed by a processor, implements the method steps of any of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310822736.6A CN116910313A (en) | 2023-07-05 | 2023-07-05 | Database establishment method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310822736.6A CN116910313A (en) | 2023-07-05 | 2023-07-05 | Database establishment method and device and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116910313A true CN116910313A (en) | 2023-10-20 |
Family
ID=88359496
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310822736.6A Pending CN116910313A (en) | 2023-07-05 | 2023-07-05 | Database establishment method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116910313A (en) |
-
2023
- 2023-07-05 CN CN202310822736.6A patent/CN116910313A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP7434417B2 (en) | Topology processing method, device, and system | |
| US7760658B2 (en) | Automated installation of network service in a telecommunications network | |
| CN110493670B (en) | Optical cable interruption judgment method and device | |
| CN109218857B (en) | Method and system for detecting port state of network equipment | |
| CN109819352B (en) | Optical fiber data processing system architecture and processing method | |
| CN101931463A (en) | Monitoring method and device in EPON network based on multistage POS | |
| CN109995428A (en) | The optical path detection method and device of passive optical network | |
| CN116910313A (en) | Database establishment method and device and electronic equipment | |
| CN108882061B (en) | ODN resource combing method, device and system | |
| CN115133983A (en) | Method, system and device for determining communication link and electronic equipment | |
| CN115589551A (en) | Fault monitoring method and device and electronic equipment | |
| CN111083006B (en) | Broadband data auditing method, device, equipment and storage medium | |
| CN115499861A (en) | Service same-route detection method, device, equipment and storage medium | |
| WO2024140508A1 (en) | Network maintenance method, communication apparatus, and storage medium | |
| RU2787892C1 (en) | Method, device and system for processing of topology | |
| CN114979843B (en) | Topology information updating method and device, electronic equipment and nonvolatile storage medium | |
| CN110213681A (en) | Mix the management method and device of ONU critical to optical power in PON system | |
| CN109614528A (en) | A kind of wire jumper graphically managing method | |
| KR101539929B1 (en) | optical fiber distribution apparatus capable of automatically administrating cable number | |
| KR20010064805A (en) | A method for searching the connection of a fault circuit in telecommunication network | |
| CN115119084B (en) | Management method, device, equipment and storage medium for optical cable cutting alarm | |
| CN113839804B (en) | Network fault determination method and network equipment | |
| CN112995231B (en) | Network port detection method and device | |
| CN117472618A (en) | Fault injection method, device, processor, storage medium and program product | |
| CN116614387A (en) | Verification method and device based on network topology, electronic equipment and storage medium |
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 |