Optical cable test file repeatability detection method and device, program product and storage medium

Abstract

The invention discloses an optical cable test file repeatability detection method and device, a program product and a storage medium. The method comprises the steps that whether the creation time of a new optical cable test file is within a preset time period or not is judged; if yes, storing the optical cable test file and the coded hash value into a file database; judging whether a coding hash value consistent with the coding hash value of the new optical cable test file exists in a file database or not; if the new optical cable test file exists, judging that the new optical cable test file is repeated with the historical file, otherwise, analyzing each optical cable test file in the file database, and extracting fiber core attenuation curve data in the optical cable test file; based on the fiber core attenuation curve data, attenuation difference values between the new optical cable test file and other optical cable test files in the file database are calculated, if any attenuation difference value is smaller than a preset threshold value, it is judged that the two corresponding optical cable test files are repeated, and otherwise, it is judged that the new optical cable test file is not a repeated file. The method is high in efficiency and accuracy.

Description

TECHNICAL FIELD

[0001] The present application relates to optical fiber testing technology, and in particular to a cable test file repeatability detection method, device, program product and storage medium. BACKGROUND

[0002] Optical cable core testing is an important link to ensure the performance and reliability of optical fiber communication systems. There are various optical cable testing methods, mainly through optical time domain reflectometry (OTDR) to measure optical fiber length, optical fiber transmission attenuation, joint attenuation and fault location, and generate optical cable test files in SOR and other formats.

[0003] Now some communication enterprises invite maintenance companies to test optical cables regularly, and the generated SOR files are uploaded to the communication enterprise management system. The communication enterprise settles the cost according to the uploaded SOR files. During cost settlement, there may be a situation that some personnel use one SOR file to settle the cost multiple times. Therefore, in order to prevent this situation, management personnel need to manually check the SOR files to determine whether they have been settled before. However, the number of SOR files is large, and manual checking requires a lot of time cost. In addition, manual visual inspection is not easy to find extremely small changes, and if someone simply modifies the SOR file and uploads it, it will not be easily found. Therefore, an automatic detection method is needed to detect the repeatability of the SOR file and determine whether multiple uploaded SOR files are repeated. SUMMARY

[0004] In view of the problems in the prior art, the present application aims to provide an automatic optical cable test file repeatability detection method, device, program product and storage medium.

[0005] In order to achieve the above-mentioned application purpose, the present application provides the following technical scheme:

[0006] An optical cable test file repeatability detection method comprises:

[0007] When a new optical cable test file is received, it is determined whether the creation time of the new optical cable test file is within a preset time period;

[0008] If yes, the optical cable test file is stored in a file database, otherwise the detection is ended; wherein the file database stores all historical received optical cable test files and their encoding hash values, and the encoding hash value includes at least two types of hash values obtained according to the encoding of the optical cable test file;

[0009] The encoding hash value of the new optical cable test file is extracted and stored in the file database;

[0010] determining whether there is a coding hash value consistent with the coding hash value of the new optical cable test file in the file database;

[0011] If there is, it is determined that the new optical cable test file is duplicated with the file having the consistent coding hash value, otherwise, each optical cable test file in the file database is parsed to extract the fiber core attenuation curve data in the optical cable test file;

[0012] Based on the fiber core attenuation curve data, the attenuation difference value of the new optical cable test file and each optical cable test file in the file database is calculated, wherein the attenuation difference value is calculated by the ratio of the attenuation of all corresponding points in the two fiber core attenuation curve data;

[0013] If any attenuation difference value is less than a preset threshold, it is determined that the corresponding two optical cable test files are duplicated, otherwise, it is determined that the new optical cable test file has no duplicate file.

[0014] Further, the determination of whether there is a coding hash value consistent with the coding hash value of the new optical cable test file in the file database comprises:

[0015] Extract the coding hash value of all optical cable test files in the file database;

[0016] For the coding hash value of each optical cable test file, determine whether the coding hash value of the new optical cable test file is consistent with it; if the coding hash value of the new optical cable test file is consistent with all the hash values of the coding hash value of any optical cable test file in the file database, it is determined that there is a coding hash value consistent with the coding hash value of the new optical cable test file.

[0017] Further, the parsing of each optical cable test file in the file database to extract the fiber core attenuation curve data in the optical cable test file comprises:

[0018] Converting each optical cable test file in the file database into a binary data stream;

[0019] For the binary data stream of each optical cable test file, a plurality of binary bits belonging to the same data are divided into a binary data block, thereby obtaining a plurality of binary data blocks;

[0020] Each binary data block is converted into a corresponding text format according to the data type to which the data belongs;

[0021] Data belonging to the fiber core attenuation value data type is extracted from the text format to form the fiber core attenuation curve data.

[0022] Further, the loss difference value is calculated by the ratio of the loss of all corresponding points in the two fiber core loss curve data, specifically comprising:

[0023] The loss difference value is calculated according to the following formula:

[0024]

[0025] In the formula, d represents the loss difference value, Y i 1 , Y i 2 respectively represent the fiber core loss value of the i-th point in the two fiber core loss curve data.

[0026] A cable test file repeatability detection device, comprising:

[0027] A file database for storing all historical received cable test files and their encoding hash values, the encoding hash values including at least two types of hash values encoded according to the cable test files;

[0028] A creation time judgment module for judging whether the creation time of a new cable test file is within a preset time period when the new cable test file is received; if yes, the cable test file is stored in the file database, otherwise the detection is ended;

[0029] A hash value extraction module for extracting the encoding hash value of the new cable test file and storing it in the file database;

[0030] A hash value consistency detection module for judging whether there is an encoding hash value consistent with the encoding hash value of the new cable test file in the file database; if the detection result is yes, it is determined that the new cable test file is duplicated with the file having the consistent encoding hash value, otherwise the data analysis module is executed;

[0031] A data analysis module for analyzing each cable test file in the file database and extracting the fiber core loss curve data in the cable test file;

[0032] A difference calculation module for calculating the loss difference value of the new cable test file and each cable test file in the file database based on the fiber core loss curve data; wherein the loss difference value is calculated by the ratio of the loss of all corresponding points in the two fiber core loss curve data;

[0033] A difference judgment module for judging whether there is any loss difference value less than a preset threshold, if yes, it is determined that the corresponding two cable test files are duplicated, otherwise it is determined that the new cable test file has no duplicate file.

[0034] Further, the hash value consistency detection module specifically comprises:

[0035] a file hash value extraction unit configured to extract the encoded hash values of all optical cable test files in the file database;

[0036] a consistency detection unit configured to determine, for each encoded hash value of the optical cable test files, whether the encoded hash value of the new optical cable test file is consistent with the encoded hash value; if the encoded hash value of the new optical cable test file is consistent with all the hash values of the encoded hash value of any optical cable test file in the file database, the detection result is yes.

[0037] Further, the data analysis module specifically comprises:

[0038] a binary conversion unit configured to convert each optical cable test file in the file database into a binary data stream;

[0039] a data block segmentation unit configured to divide the binary data stream of each optical cable test file into a binary data block to which a plurality of binary bits belonging to the same data belong, thereby obtaining a plurality of binary data blocks;

[0040] a data format conversion unit configured to convert each binary data block into a corresponding text format according to the data type to which the data belongs;

[0041] a data combination unit configured to extract data belonging to the fiber core attenuation value data type from the text format and combine the data to form fiber core attenuation curve data.

[0042] Further, the difference calculation module specifically comprises:

[0043] The attenuation difference value is calculated according to the following formula:

[0044]

[0045] In the formula, d represents the attenuation difference value, Y i 1 , and Y i 2 respectively represent the fiber core attenuation values at the i-th point in the two fiber core attenuation curve data.

[0046] A computer program product comprising computer programs / instructions, which, when executed by a processor, implement the above method.

[0047] A computer-readable storage medium having stored thereon computer programs / instructions, which, when executed by a processor, implement the above method.

[0048] Compared with the prior art, the present application has the beneficial effects that: the present application can automatically detect the repeatability of the optical cable test file, has high efficiency and high accuracy, and even if the optical cable test file is changed, it can also identify whether it is changed based on the historical file. BRIEF DESCRIPTION OF DRAWINGS

[0049] Figure 1 is a flowchart of the optical cable test file repeatability detection method provided by the embodiment of the present application;

[0050] Figure 2 is an example diagram of the fiber core attenuation curve data;

[0051] Figure 3 is a structural schematic diagram of the optical cable test file repeatability detection device provided by the embodiment of the present application. DETAILED DESCRIPTION

[0052] The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application.

[0053] Embodiment one

[0054] The embodiment of the present application provides an optical cable test file repeatability detection method, as shown in Figure 1 The method comprises the following steps:

[0055] S101, when a new optical cable test file is received, it is judged whether the creation time of the new optical cable test file is within a preset time period; if yes, step S102 is executed, otherwise the detection is ended.

[0056] The optical cable test file can be a SOR type file, and the preset time period can be set to 12 hours, 24 hours or 48 hours, etc., mainly to ensure the freshness of the optical cable test file, that is, only the recently generated test file can be imported and subjected to repeatability detection, if it is not newly generated, it is directly judged as unqualified, not imported, and no subsequent detection is needed. Thus, the situation of directly using the historically generated optical cable test file for cost settlement is prevented.

[0057] S102, the optical cable test file is stored in the file database.

[0058] The file database stores all the historical received optical cable test files and their encoding hash values, and the encoding hash values include at least two types of hash values obtained by encoding the optical cable test file, such as MD5 value and sha-256 value obtained by encoding the file.

[0059] S103, the encoding hash value of the new optical cable test file is extracted and stored in the file database.

[0060] S104, judge whether there is a coding hash value consistent with the coding hash value of the new optical cable test file in the file database. If yes, execute step S105, otherwise execute step S106.

[0061] In this step, first, extract the coding hash value of all optical cable test files in the file database; then, for the coding hash value of each optical cable test file, judge whether the coding hash value of the new optical cable test file is consistent with it; if the coding hash value of the new optical cable test file is consistent with all the hash values in the coding hash value of any optical cable test file in the file database, it is determined that there is a coding hash value consistent with the coding hash value of the new optical cable test file.

[0062] S105, judge whether the new optical cable test file is duplicated with the file with consistent coding hash value.

[0063] Through the coding hash value, it can be found whether there is a file consistent with the historical optical cable test file.

[0064] S106, parse each optical cable test file in the file database, and extract the core attenuation curve data in the optical cable test file.

[0065] This step specifically includes:

[0066] S1061, binary conversion is performed on each optical cable test file in the file database to generate a binary data stream; the optical cable test file includes test parameters, attenuation curve data, event point data, etc., and the types of each data are different, such as string, integer, floating point number, etc.; when generating the binary data stream, it will be uniformly coded into binary;

[0067] S1062, for the binary data stream of each optical cable test file, a plurality of binary bits belonging to the same data are divided into a binary data block, thereby obtaining a plurality of binary data blocks; wherein, when generating the binary data stream, the same data may be coded into a plurality of binary bits, therefore, according to the data belonging to, the binary data stream is divided into a plurality of binary data blocks;

[0068] S1063, for each binary data block, it is respectively converted into a corresponding text format according to the data type of the data; that is, the binary data block is respectively converted into a string, an integer, a floating point number, etc.

[0069] S1064, data belonging to the core loss value data type is extracted from the text format, and is combined to form a core loss curve data. The core loss value data type is a floating-point decimal. The extracted core loss value is assembled into a json format, and then the core loss curve data is formed. The core loss curve data can be regarded as an (X, Y) point array. X represents the horizontal coordinate, indicating the Nth point, and Y represents the core loss value (db), as shown in the following formula. Figure 2

[0070] S107, based on the core loss curve data, a loss difference value of a new optical cable test file and each optical cable test file in the file database is calculated.

[0071] The loss difference value is calculated by the ratio of the loss of all corresponding points in the two core loss curve data, and can be calculated according to the following formula:

[0072]

[0073] In the formula, d represents the loss difference value, Y i 1 , and Y i 2 respectively represent the core loss value of the ith point in the two core loss curve data.

[0074] S108, if there is any loss difference value less than a preset threshold, it is determined that the corresponding two optical cable test files are repeated, otherwise, it is determined that the new optical cable test file has no repeated file.

[0075] An individual may simply change part of the data in the optical cable test file, thereby changing the encoding hash value, so that the encoding hash value cannot identify whether it is a simple change. At this time, the loss difference value detection is performed. Because the modification tool of the third party can only modify the test parameters, event points and other data blocks, the curve data cannot be adjusted and changed. Therefore, the application further adopts the loss difference value of the curve data for comparison to determine whether it is repeated. When the loss difference values of the new optical cable test file and all historical optical cable test files are not within the preset threshold, it is determined that there is no repetition, otherwise it is determined that there is repetition.

[0076] Embodiment two

[0077] The embodiment of the application provides an optical cable test file repeatability detection device, as shown in the following formula. Figure 3

[0078] The file database 201 is used for storing all historical received optical cable test files and encoding hash values thereof, and the encoding hash values include at least two types of hash values obtained by encoding the optical cable test file.

[0079] ​​The creation time judging module 202 is configured to judge whether the creation time of the new optical cable test file is within a preset time period when the new optical cable test file is received; if yes, the optical cable test file is stored in the file database; otherwise, the detection is ended.

[0080] The hash value extraction module 203 is configured to extract the encoding hash value of the new optical cable test file and store the encoding hash value in the file database.

[0081] The hash value consistency detection module 204 is configured to judge whether there is an encoding hash value consistent with the encoding hash value of the new optical cable test file in the file database; if the detection result is yes, it is determined that the new optical cable test file is duplicated with the file having the consistent encoding hash value; otherwise, the data analysis module 205 is executed.

[0082] The data analysis module 205 is configured to analyze each optical cable test file in the file database and extract the fiber core attenuation curve data in the optical cable test file.

[0083] The difference calculation module 206 is configured to calculate the attenuation difference value of the new optical cable test file and each optical cable test file in the file database based on the fiber core attenuation curve data; wherein the attenuation difference value is calculated by the ratio of the attenuation of all corresponding points in the two fiber core attenuation curve data.

[0084] The difference judging module 207 is configured to judge whether there is any attenuation difference value less than a preset threshold; if yes, it is determined that the corresponding two optical cable test files are duplicated; otherwise, it is determined that the new optical cable test file has no duplicate file.

[0085] The hash value consistency detection module 204 specifically includes:

[0086] The file hash value extraction unit is configured to extract the encoding hash value of all optical cable test files in the file database.

[0087] The consistency detection unit is configured to judge whether the encoding hash value of the new optical cable test file is consistent with the encoding hash value of each optical cable test file; if the encoding hash value of the new optical cable test file is consistent with all the hash values of the encoding hash value of any optical cable test file in the file database, the detection result is yes.

[0088] The data analysis module 205 specifically includes:

[0089] The binary conversion unit is configured to perform binary conversion on each optical cable test file in the file database to generate a binary data stream.

[0090] The data block splitting unit is configured to divide a plurality of binary bits belonging to the same data into a binary data block for each binary data stream of the optical cable test file, thereby obtaining a plurality of binary data blocks.

[0091] The data format conversion unit is configured to convert each binary data block into a corresponding text format according to a data type of the data.

[0092] The data combination unit is configured to extract data belonging to the fiber core attenuation value data type from the text format and combine the data to form fiber core attenuation curve data.

[0093] The difference calculation module 206 specifically includes: calculating the attenuation difference value according to the following formula:

[0094]

[0095] In the formula, d represents the attenuation difference value, Y i 1 , and Y i 2 respectively represent fiber core attenuation values at the i th point in the two fiber core attenuation curve data.

[0096] The apparatus provided by the embodiment of the present application can be used to execute the method provided by the embodiment one of the present application, and has the corresponding functions and advantages of the method.

[0097] It is worth noting that, in the embodiments of the above apparatus, each unit and module included is only divided according to the function logic, but is not limited to the above division, as long as the corresponding function can be realized; in addition, the specific name of each functional unit is only for the convenience of mutual distinction, and does not limit the protection scope of the present application.

[0098] The above-described embodiments are only illustrative, and the modules described as separate components can or can not be physically separated, and the components shown as modules can or can not be physical modules, i.e., they can be located in one place or distributed on multiple network modules. According to actual needs, some or all of the modules can be selected to achieve the purpose of the present embodiment. Those skilled in the art can clearly understand that each embodiment can be realized by means of software and necessary general hardware platform, and of course, it can also be realized by hardware only, as long as the function or effect can be realized.

[0099] Embodiment three

[0100] The embodiments of the present application also provide a computer program product, such as an app on a mobile phone, a tablet, an installation program on a computer, etc. The product includes computer programs / instructions which, when executed by a processor, implement the method of Embodiment One. The code for a computer program to perform the operations of the present application can be written in one or more programming languages, or combinations thereof, including an object oriented programming language such as Java, Smalltalk, C++ or conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code can execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer, or entirely on the remote computer or server. In the latter scenario, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider).

[0101] Embodiment Four

[0102] The embodiments of the present application provide a storage medium containing computer executable programs which, when executed by a computer processor, are used to perform the method of Embodiment One.

[0103] The storage medium of the embodiments of the present application can use any combination of one or more computer readable media. The computer readable medium can be a computer readable signal medium or a computer readable storage medium. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or apparatus, or any suitable combination of the above. More specific examples (a non-exhaustive list) of the computer readable storage medium include an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, the computer readable storage medium can be any tangible medium that contains or stores a program that can be used by or in connection with an instruction execution system, apparatus, or device.

[0104] Of course, the storage medium containing computer executable programs provided by the embodiments of the present application is not limited to the method operations described above, but can also perform related operations in the method provided by any embodiment of the present application.

[0105] It should be appreciated that the above examples and description of the present application are only the principles, main features and advantages of the present application, and various changes and improvements can be made to the present application without departing from the spirit and scope of the present application, and these changes and improvements are also within the scope of the present application.

Claims

1. An optical cable test file repeatability detection method, characterized in that, The application comprises the following steps: When a new optical cable test file is received, it is determined whether the creation time of the new optical cable test file is within a preset time period; If yes, the optical cable test file is stored in a file database, otherwise the detection is ended; wherein the file database stores all the historical received optical cable test files and their encoding hash values, and the encoding hash values comprise at least two types of hash values obtained by encoding the optical cable test file; The encoding hash value of the new optical cable test file is extracted and stored in the file database; It is determined whether there is an encoding hash value consistent with the encoding hash value of the new optical cable test file in the file database; If yes, it is determined that the new optical cable test file is duplicated with the file having the consistent encoding hash value, otherwise, the fiber core attenuation curve data in the optical cable test file is extracted by parsing each optical cable test file in the file database; Based on the fiber core attenuation curve data, the attenuation difference value between the new optical cable test file and each optical cable test file in the file database is calculated, wherein the attenuation difference value is calculated by the ratio of the attenuation of all corresponding points in the two fiber core attenuation curve data; If any attenuation difference value is less than a preset threshold, it is determined that the corresponding two optical cable test files are duplicated, otherwise, it is determined that the new optical cable test file has no duplicate file.

2. The optical cable test file repeatability detection method of claim 1, wherein, The determination of whether there is an encoding hash value consistent with the encoding hash value of the new optical cable test file in the file database comprises: Extracting the encoding hash values of all the optical cable test files in the file database; For the encoding hash value of each optical cable test file, it is determined whether the encoding hash value of the new optical cable test file is consistent with it; if the encoding hash value of the new optical cable test file is consistent with all the hash values of the encoding hash value of any optical cable test file in the file database, it is determined that there is an encoding hash value consistent with the encoding hash value of the new optical cable test file.

3. The optical cable test file repeatability detection method of claim 1, wherein, The parsing of each optical cable test file in the file database and the extraction of the fiber core attenuation curve data in the optical cable test file comprise: Converting each optical cable test file in the file database into binary data stream; For the binary data stream of each optical cable test file, a plurality of binary bits belonging to the same data are divided into a binary data block, thereby obtaining a plurality of binary data blocks; According to the data type to which the data belongs, each binary data block is converted into a corresponding text format; The data belonging to the fiber core attenuation value data type is extracted from the text format and combined to form the fiber core attenuation curve data.

4. The optical cable test file repeatability detection method of claim 1, wherein, The attenuation difference value is calculated by the ratio of the attenuation of all corresponding points in the two fiber core attenuation curve data, and comprises: The attenuation difference value is calculated according to the following formula: In the formula, d represents a loss difference value, Y i 1 , Y i 2 respectively represent the fiber core loss value at the i-th point in the two fiber core loss curve data.

5. An optical cable test file repeatability detection apparatus, characterized by, The application comprises the following steps: A file database is used to store all the historical received optical cable test files and their encoding hash values, and the encoding hash values comprise at least two types of hash values obtained by encoding the optical cable test file; A creation time determination module is used to determine whether the creation time of the new optical cable test file is within a preset time period when the new optical cable test file is received; if yes, the optical cable test file is stored in the file database, otherwise the detection is ended; The hash value extraction module is configured to extract an encoding hash value of the new optical cable test file and store the encoding hash value in the file database. The hash value consistency detection module is configured to determine whether there is an encoding hash value consistent with the encoding hash value of the new optical cable test file in the file database. If the detection result is yes, it is determined that the new optical cable test file is duplicated with the file having the consistent encoding hash value, otherwise, the data analysis module is executed. The data analysis module is configured to analyze each optical cable test file in the file database and extract fiber core attenuation curve data in the optical cable test file. The difference calculation module is configured to calculate an attenuation difference value of the new optical cable test file and each optical cable test file in the file database based on the fiber core attenuation curve data, wherein the attenuation difference value is calculated by the ratio of attenuations at all corresponding points in two fiber core attenuation curve data. The difference judgment module is configured to determine whether there is any attenuation difference value less than a preset threshold value, if yes, it is determined that the corresponding two optical cable test files are duplicated, otherwise, it is determined that the new optical cable test file has no duplicate file.

6. The optical cable test file repeatability detection apparatus of claim 5, wherein, The hash value consistency detection module specifically includes: The file hash value extraction unit is configured to extract the encoding hash value of all optical cable test files in the file database. The consistency detection unit is configured to determine whether the encoding hash value of the new optical cable test file is consistent with the encoding hash value of each optical cable test file, if the encoding hash value of the new optical cable test file is consistent with all hash values of the encoding hash value of any optical cable test file in the file database, the detection result is yes.

7. The optical cable test file repeatability detection apparatus of claim 5, wherein, The data analysis module specifically includes: The binary conversion unit is configured to convert each optical cable test file in the file database into binary data stream. The data block segmentation unit is configured to divide a plurality of binary bits belonging to the same data into a binary data block for each optical cable test file binary data stream, thereby obtaining a plurality of binary data blocks. The data format conversion unit is configured to convert each binary data block into a corresponding text format according to the data type of the data. The data combination unit is configured to extract the data belonging to the fiber core attenuation value data type from the text format and combine the data to form the fiber core attenuation curve data.

8. The optical cable test file repeatability detection apparatus of claim 5, wherein, The difference calculation module specifically includes: The attenuation difference value is calculated according to the following formula: In the formula, d represents a loss difference value, Y i 1 , Y i 2 respectively represent the core loss value at the i-th point in the two core loss curve data.

9. A computer program product comprising computer programs / instructions, characterized in that: The computer program / instruction is executed by the processor to realize the method in any one of claims 1-4.

10. A computer readable storage medium having stored thereon computer programs / instructions, characterized in that: The computer program / instruction is executed by the processor to realize the method in any one of claims 1-4.

Images