Method, system and device for accurately positioning user based on MAC automatic link establishment collection light number, and medium

Abstract

The invention relates to the technical field of OSS domain access side network element data acquisition, in particular to a method, a system and equipment for accurately positioning a user based on MAC automatic link establishment collection optical numbers, and a medium. According to the method, on the basis of MAC automatic link establishment, collection and acquisition of light splitting numbers are synchronously realized, accurate positioning of a user is realized through collection data of binding of the light splitting numbers and logic IDs, the consistency of customer information of BSS and OSS domains is guaranteed, and the timeliness of MAC automatic link establishment is improved; by optimizing the time of MAC automatic link establishment, the duration of network troubleshooting is greatly shortened, the overall efficiency of network maintenance is improved, and the influence of network interruption on user service is reduced; according to the method, the uniqueness of the logic ID between the CRM system and the network element is ensured, errors caused by logic ID conflicts are eliminated by clearing and calibrating data, the accuracy of the data of the CRM system is improved, and the operation and maintenance complexity caused by data errors is reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of OSS domain access side network data collection, and in particular to a method, system, device and medium for accurately positioning users based on MAC automatic link building, centralized collection and optical splitting. Background Art

[0002] The CRM customer management system is one of the important assets of an enterprise. In the field of communications, the broadband + ITV business accepted by each CRM customer means that the corresponding data needs to be configured on the network side. In order to ensure that the network side data and the front-end data have a unified identification ID to identify the same customer, the CRM system uniformly allocates user logical IDs to achieve the unique association between network configuration data and CRM customer information. However, with the migration, change, development, and off-network of the business, the user logical ID data that is uniquely associated between the front and back ends becomes increasingly distorted, resulting in some user logical IDs recorded in the CRM system being unable to be located on the network side, and even some logical IDs cannot be found on the network side. Once a customer has a network problem, it will cause great difficulty in troubleshooting.

[0003] Through the MAC-based automatic link establishment method, the customer's broadband account is bound to the access side network element and port, solving the problem of troubleshooting when the customer encounters a network failure. However, this method has two problems:

[0004] 1. The MAC-based automatic link establishment method is to scan the entire network's MAC address. The base number is large and can only be collected discretely. The link update cycle is 3-7 days, and the delay is large.

[0005] 2. Because the most critical logical ID that uniquely associates the front-end and back-end customer data has not been calibrated, the consistency of customer information in the BSS and OSS domains cannot be guaranteed, resulting in a series of problems in service activation and logical ID allocation pool management. Summary of the invention

[0006] In view of the fact that the existing MAC-based link establishment method has a large delay and cannot guarantee the consistency of customer information in the BSS and OSS domains, resulting in problems in service activation and logical ID allocation pool management, the present invention proposes a method, system, device and medium for accurately locating users through centralized procurement of spectrometer numbers based on MAC automatic link establishment; on the basis of MAC automatic link establishment, centralized procurement of spectrometer numbers is synchronously implemented, and then the user is accurately located through the collected data bound by the spectrometer numbers and the logical ID, thereby ensuring the consistency of customer information in the BSS and OSS domains and improving the timeliness of MAC automatic link establishment.

[0007] The present invention has the following beneficial effects:

[0008] A method for accurately locating users based on MAC automatic link building and centralized collection of optical splitting numbers, specifically comprising the following steps:

[0009] Step S1: Collect the OLT network element MAC information in a discrete form to obtain the optical split number information corresponding to the PON port MAC address;

[0010] Step S2: Regularly collect the ONU information under the OLT network element to obtain the logical ID corresponding to the PON port split number;

[0011] Step S3: The optical split number information corresponding to the MAC address of the PON port and the logical ID corresponding to the optical split number of the PON port are entered into the enterprise data center through the small file system;

[0012] Step S4: Bind the optical split number information corresponding to the PON port MAC address with the AAA system authentication MAC, automatically link the MAC address, and bind the logical ID corresponding to the PON port optical split number with the optical split number corresponding to the PON port in the link information according to the MAC address after linking, and mount the user logical ID information to the MAC address automatic linking data;

[0013] Step S5: Associating the obtained user basic data information and MAC automatic linking information of the CRM system through the client authentication account, obtaining the user's most recent logical ID information, and realizing user positioning.

[0014] In order to better implement the present invention, further, the step S1 specifically includes the following steps:

[0015] Step S11: Collect the MAC data list of OLT network elements in the whole network in a discrete manner;

[0016] Step S12: parsing the collected OLT network element MAC data list to obtain the PON port, the MAC information corresponding to the PON port, and the optical split number information corresponding to the PON port MAC address;

[0017] Step S13: Analyze and integrate the IP and PON port of the logged-in LOT device, the MAC information corresponding to the PON port, and the optical split number information corresponding to the MAC address of the PON port to establish a user MAC data list model.

[0018] In order to better implement the present invention, further, the step S2 specifically includes the following steps:

[0019] Step S21: According to the set collection time, regularly collect the ONU information data list of the OLT network element from the access side device;

[0020] Step S22: Analyze the collected ONU data to obtain the PON port, the optical split number corresponding to the PON port, and the logical ID information corresponding to the optical split number of the PON port;

[0021] Step S23: Analyze and integrate the IP and PON port of the OLT device, the corresponding optical split number under the PON port, and the logical ID information corresponding to the optical split number under the PON port to establish a user logical data list model.

[0022] In order to better implement the present invention, further, the step S4 specifically includes the following steps:

[0023] Step S41: Through the big data analysis and integration of the enterprise data center, the user MAC data list is bound to the AAA user authentication data authentication MAC, and the customer authentication account, authentication MAC, IP of the OLT device, PON port, and the information integration of the optical split number corresponding to the MAC address under the PON port are completed to realize automatic link establishment based on MAC;

[0024] Step S42: Bind the IP, PON port, and corresponding optical split number of the OLT device in the user logic data list model with the IP, PON port, and corresponding optical split number of the OLT device in the link establishment information to complete the mounting of the user logic ID information on the MAC automatic link establishment data.

[0025] In order to better implement the present invention, further, step S5 specifically includes the following steps:

[0026] Step S51: Associating the customer basic data information and MAC automatic link establishment information of the CRM system through the customer authentication account, obtaining the logical ID corresponding to the PON port optical split number collected by the network element and the logical ID information allocated by the CRM front end;

[0027] Step S52: According to the logical ID corresponding to the optical splitting number under the PON port collected by the network element and the logical ID information allocated by the CRM front end, audit and compare the front-end and back-end services, calibrate the inconsistent logical ID information bound to the CRM and the back end, and clean up the CRM junk data to complete the consistency comparison of the front-end and back-end data in the BSS domain and OSS domain.

[0028] In order to better implement the present invention, further, the name number of the data list starts with the name of the profession or business system and is suffixed with the date in the "YYYYMMDD" format.

[0029] In order to better implement the present invention, further, the index of the data list is based on the principle of minimization and uniqueness, and a partition index is established according to cities as sub-partitions.

[0030] Based on the above-mentioned method for accurately locating users based on MAC automatic link building and centralized collection of spectroscopic numbers, in order to better realize the present invention, further, a system for accurately locating users based on MAC automatic link building and centralized collection of spectroscopic numbers is proposed, which is used to execute the above-mentioned method for accurately locating users based on MAC automatic link building and centralized collection of spectroscopic numbers, including a discrete collection unit, a timing collection unit, an entry unit, a binding unit, and a comparison unit;

[0031] The discrete collection unit is used to collect the MAC information of the OLT network elements of the entire network in a discrete form to obtain the optical split number information corresponding to the MAC address of the PON port;

[0032] The timing collection unit is used to regularly collect the ONU information of the OLT network element of the whole network and obtain the logical ID corresponding to the PON port split number;

[0033] The entry unit is used to enter the optical split number information corresponding to the PON port MAC address and the logical ID corresponding to the PON port optical split number into the enterprise data middle station through the small file system;

[0034] The binding unit is used to bind the split number information corresponding to the PON port MAC address with the AAA system authentication MAC, and bind the logical ID corresponding to the PON port split number with the split number corresponding to the PON port in the link establishment information, so as to complete the mounting of the user logical ID information on the MAC automatic link establishment data;

[0035] The comparison unit is used to associate the customer basic data information obtained from the CRM system and the MAC-based automatic link information wide table through the customer authentication account to obtain the logical ID corresponding to the optical split number under the PON port collected by the network element and the CRM front-end allocated logical ID information.

[0036] Based on the above-mentioned method for accurately locating users based on MAC automatic link building and centralized spectral number acquisition, in order to better realize the present invention, further, an electronic device is proposed, including a memory and a processor; a computer program is stored on the memory; when the computer program is executed on the processor, the above-mentioned method for accurately locating users based on MAC automatic link building and centralized spectral number acquisition is realized.

[0037] Based on the above-mentioned method for accurately locating users based on MAC automatic link building and centralized spectral number acquisition, in order to better realize the present invention, further, a computer-readable storage medium is proposed, on which computer instructions are stored; when the computer instructions are executed on the above-mentioned electronic device, the above-mentioned method for accurately locating users based on MAC automatic link building and centralized spectral number acquisition is realized.

[0038] The present invention has the following beneficial effects:

[0039] (1) The present invention realizes accurate positioning of users through automatic link establishment and centralized acquisition of optical spectrometers based on MAC, ensuring the consistency of customer information in the BSS and OSS systems; and reducing operational risks and customer complaints caused by information mismatch.

[0040] (2) The present invention significantly shortens the time for network troubleshooting and improves the overall efficiency of network maintenance by optimizing the time for MAC automatic link establishment. Faster fault response capability directly reduces the impact of network interruption on user services.

[0041] (3) The present invention ensures the uniqueness of the logical ID between the CRM system and the network element. By cleaning and calibrating data, errors caused by logical ID conflicts are eliminated, the accuracy of CRM system data is improved, and the complexity of operation and maintenance caused by data errors is reduced; by cleaning dirty data in the CRM system, logical ID conflicts in new services are avoided, and the success rate of automatic service activation is improved. This not only reduces the need for manual intervention, but also shortens the activation cycle of new services, improving customer satisfaction. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Figure 1 This is a schematic flowchart of the method for accurately locating users based on MAC automatic link establishment, centralized collection and spectral signaling provided by the present invention.

[0043] Figure 2 A schematic diagram of the optical splitting of sample data returned by a network element provided in an embodiment of the present invention.

[0044] Figure 3 This is a schematic diagram of the mesh network structure provided by the present invention.

[0045] Figure 4 A schematic diagram of ZTE network element MAC data collection provided by an embodiment of the present invention.

[0046] Figure 5 A schematic diagram of some data relationships provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0047] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. It should be understood that the described embodiments are only part of the embodiments of the present invention, not all of the embodiments, and therefore should not be regarded as limiting the scope of protection. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technical personnel in this field without making creative work are within the scope of protection of the present invention.

[0048] In the description of the present invention, it should be noted that, unless otherwise clearly specified and limited, the terms "disposed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be an indirect connection through an intermediate medium, or it can be the internal communication of two elements. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0049] The professional terms and explanations involved in the embodiments of this application are as follows:

[0050] CRM system: customer management system.

[0051] AAA system: network operator user account authentication system.

[0052] BSS domain: data domain of business support system. The BSS domain contains user data and business data, such as user consumption habits, terminal information, ARPU grouping, business content, business target groups, etc.

[0053] OSS domain: data domain of the operation support system. The OSS domain contains network data, such as signaling, alarms, faults, network resources, network configuration, and network performance indicators.

[0054] CTG-DFS: Distributed small file system, a self-developed component of China Telecom.

[0055] OLT: OLT (Optical Line Terminal) is a core device in the optical fiber access network. It is located at the center of the optical fiber access network (FTTx) and is a key component that sends signals from the service provider's data center to the end user.

[0056] ODN: ODN (Optical Distribution Network) is a key component of the fiber access network, connecting the optical line terminal (OLT) and the user's optical network unit (ONU). Its main function is to distribute and transmit the optical signal emitted by the OLT to multiple end users through a series of passive optical components (such as optical fibers, cables, optical splitters, optical couplers, etc.).

[0057] Splitting number: In the field of communications, the splitting number of the OLT (Optical Line Terminal) network element in the access network refers to the splitting ratio number or identification in the optical fiber network. It is related to the optical splitter in the optical distribution network (ODN). The optical splitter divides the optical signal from the OLT into multiple sub-signals and transmits them to different user optical network units (ONUs).

[0058] MAC: The MAC address mentioned in this article is the MAC address of the specific device when the user authenticates the account and password when surfing the Internet. If the wireless router is authenticated, it is the MAC of the wireless router; if the computer is authenticated directly, it is the MAC address of the computer.

[0059] Logical ID: It is uniformly allocated by the CRM customer management system. When a user activates broadband or ITV services, it needs to be sent to the network element for configuration. It is used to uniquely identify a customer on the network side. Generally, one logical ID corresponds to an optical modem device on the customer side.

[0060] Broadband: Broadband in the field of communications refers to a high-speed Internet access technology that can simultaneously transmit multiple types of data, such as video, audio, text, etc., usually through wired or wireless means (this article refers to wired broadband with fiber access). Compared with traditional narrowband (such as dial-up Internet access), broadband can provide higher transmission rates and larger bandwidth to meet users' needs for high-speed data transmission.

[0061] ITV: ITV (Interactive Television) is a television service that combines traditional television broadcasting with interactive functions, allowing viewers to not only watch television programs but also interact with the content through the television screen. This service is usually implemented through digital television, the Internet or IPTV (Internet Protocol Television) technology.

[0062] TELNET collection: Use the Telnet protocol to connect to network devices (usually called "network elements") to collect their operating status, configuration, and performance data.

[0063] Link building: When a customer uses broadband to access the Internet or plays ITV multimedia, the binding of all network element information routed through the network with the customer information is called link building.

[0064] Embodiment 1:

[0065] This embodiment proposes a method for accurately locating users based on MAC automatic link establishment and centralized collection of optical splitting numbers, which specifically includes the following steps:

[0066] Step S1: Collect OLT network element MAC information in a discrete form to obtain the optical split number information corresponding to the PON port MAC address.

[0067] The step S1 specifically includes the following steps:

[0068] Step S11: Collect the MAC data list of OLT network elements in the whole network in a discrete manner;

[0069] Step S12: parsing the collected OLT network element MAC data list to obtain the PON port, the MAC information corresponding to the PON port, and the optical split number information corresponding to the PON port MAC address;

[0070] Step S13: Analyze and integrate the IP and PON port of the logged-in LOT device, the MAC information corresponding to the PON port, and the optical split number information corresponding to the MAC address of the PON port to establish a user MAC data list model.

[0071] Step S2: regularly collect the ONU information under the OLT network element to obtain the logical ID corresponding to the PON port split number.

[0072] The step S2 specifically includes the following steps:

[0073] Step S21: According to the set collection time, regularly collect the ONU information data list of the OLT network element from the access side device;

[0074] Step S22: Analyze the collected ONU data to obtain the PON port, the optical split number corresponding to the PON port, and the logical ID information corresponding to the optical split number of the PON port;

[0075] Step S23: Analyze and integrate the IP and PON port of the OLT device, the corresponding optical split number under the PON port, and the logical ID information corresponding to the optical split number under the PON port to establish a user logical data list model.

[0076] Step S3: The optical split number information corresponding to the PON port MAC address and the logical ID corresponding to the PON port optical split number are entered into the enterprise data center through the small file system.

[0077] Step S4: Bind the optical split number information corresponding to the PON port MAC address with the AAA system authentication MAC, automatically link the MAC address, and bind the logical ID corresponding to the PON port optical split number with the optical split number corresponding to the PON port in the link information according to the MAC address after linking, and mount the user logical ID information to the MAC address automatic linking data;

[0078] The step S4 specifically comprises the following steps:

[0079] Step S41: Through the big data analysis and integration of the enterprise data center, the user MAC data list is bound to the AAA user authentication data authentication MAC, and the customer authentication account, authentication MAC, IP of the OLT device, PON port, and the information integration of the optical split number corresponding to the MAC address under the PON port are completed to realize automatic link establishment based on MAC;

[0080] Step S42: Bind the IP, PON port, and corresponding optical split number of the OLT device in the user logic data list model with the IP, PON port, and corresponding optical split number of the OLT device in the link establishment information to complete the mounting of the user logic ID information on the MAC automatic link establishment data.

[0081] Step S5: Associating the obtained user basic data information and MAC automatic linking information of the CRM system through the client authentication account, obtaining the user's most recent logical ID information, and realizing user positioning.

[0082] Furthermore, the step S5 specifically includes the following steps:

[0083] Step S51: Associating the customer basic data information and MAC automatic link establishment information of the CRM system through the customer authentication account, obtaining the logical ID corresponding to the PON port optical split number collected by the network element and the logical ID information allocated by the CRM front end;

[0084] Step S52: According to the logical ID corresponding to the optical splitting number under the PON port collected by the network element and the logical ID information allocated by the CRM front end, audit and compare the front-end and back-end services, calibrate the inconsistent logical ID information bound to the CRM and the back end, and clean up the CRM junk data to complete the consistency comparison of the front-end and back-end data in the BSS domain and OSS domain.

[0085] Furthermore, the name and number of the data list shall start with the name of the professional or business system and be suffixed with the date in the "YYYYMMDD" format.

[0086] Furthermore, the index of the data list is based on the principle of minimization and uniqueness, and a partition index is established according to cities as sub-partitions.

[0087] Working principle: Based on the automatic MAC link establishment, this embodiment realizes the centralized collection of optical splitting numbers simultaneously, and then realizes the precise positioning of users through the collection data bound by the optical splitting numbers and logical IDs, ensures the consistency of customer information in the BSS and OSS domains, and improves the timeliness of the automatic MAC link establishment.

[0088] In this embodiment, the information of the optical split number is collected synchronously when the network element MAC is collected, and the method of applying it to the MAC automatic link establishment realizes the binding of the business account and the optical split number; the data of the logical ID and the optical split number binding information is collected, and the method of applying it to the MAC automatic link establishment realizes the binding of the business account, the optical split number, and the logical ID; the method of reversely auditing the front-end data based on the configuration data of the logical ID actually collected by the back-end breaks away from the idea of ​​manually managing the logical ID pool and reversely calibrates the resource pool with real and effective actual data.

[0089] This embodiment achieves accurate positioning of users and ensures the consistency of customer information in the BSS and OSS systems through MAC-based automatic link establishment and centralized procurement of optical spectrometers. This consistency reduces operational risks and customer complaints caused by information mismatches; by optimizing the time for MAC automatic link establishment, the duration of network troubleshooting is greatly shortened, and the overall efficiency of network maintenance is improved. Faster fault response capabilities directly reduce the impact of network interruptions on user services; ensure the uniqueness of the logical ID between the CRM system and the network element, eliminate errors caused by logical ID conflicts by cleaning and calibrating data, improve the accuracy of CRM system data, and reduce the complexity of operation and maintenance caused by data errors; by cleaning dirty data in the CRM system, logical ID conflicts in new services are avoided, and the success rate of automatic service activation is improved. This not only reduces the need for manual intervention, but also shortens the activation cycle of new services and improves customer satisfaction.

[0090] Embodiment 2:

[0091] This embodiment is based on the above embodiment 1. Figure 1 , Figure 2 , Figure 3 , Figure 4 , Figure 5 As shown, a specific embodiment is described in detail, which specifically includes the following steps.

[0092] Step S1: Collect the MAC data list of OLT network elements in the entire network in a discrete form every day.

[0093] Adapt to the MAC data list collection of access side devices of manufacturers such as ZTE and Huawei. The MAC data list includes: user MAC, OLT network element IP corresponding to MAC, OLT port, and optical split number information;

[0094] Data is collected three times a day for each OLT network element. The collection period is not fixed. For example, the data for a certain OLT network element on the first day may be 10:00, 19:00, and 23:00, and the data may be collected at 7:00, 14:00, and 21:00 on the second day. A discrete collection method is used.

[0095] Analyze the collected information to obtain a data list of user MAC, OLT network element IP corresponding to MAC, OLT port, and optical split number information;

[0096] The user MAC data list model is established by analyzing and integrating the IP and PON port of the OLT device, the MAC corresponding to the PON port, and the optical split number information corresponding to the MAC address under the PON port.

[0097] Step S2: Collect the ONU information data list of the OLT network elements in the whole network at regular intervals every day.

[0098] Adapt to the ONU list collection of access side equipment from manufacturers such as ZTE and Huawei;

[0099] The collected information is parsed to obtain information such as the PON port, the corresponding splitter number under the PON port, and the logical ID information list corresponding to the splitter number under the PON port.

[0100] A user logical data list model is established by analyzing and integrating the IP used to log in to the OLT device, the PON port, the corresponding splitter number under the PON port, and the logical ID information corresponding to the splitter number under the PON port.

[0101] Step S3: Upload the data list of the collected results after the model conversion through the CTG-DFS small file system and enter the data lake into the enterprise data center.

[0102] Step S4: Perform big data analysis and integration through the enterprise data center, bind the user MAC data list with the authentication MAC in the AAA user authentication data, integrate the customer authentication account, authentication MAC, OLT device IP, PON port, and the optical split number corresponding to the MAC address under the PON port, and complete the automatic link based on MAC. The link building process has also synchronously included the optical split number information corresponding to the MAC address in the link building process.

[0103] Then, the IP, PON port, and corresponding optical split number of the OLT device in the user logic data list model are bound to the IP, PON port, and corresponding optical split number of the OLT device in the link establishment information to realize the mounting of the user logic ID information on the MAC automatic link establishment data.

[0104] Step S5: The customer basic data information of the CRM system and the wide table of MAC-based automatic link establishment information are associated through the customer authentication account, and the logical ID corresponding to the optical split number under the PON port collected by the network element and the logical ID information allocated by the CRM front end are output. The front-end and back-end business audits and comparisons are performed on the two logical IDs to calibrate the inconsistency of the logical ID information bound to the CRM and the back end, improve the management capability of the logical ID allocation pool, improve the automatic service activation rate, reduce the automatic activation time and the fault handling time, and realize the consistency comparison of the front-end and back-end data in the BSS domain and OSS domain.

[0105] In order to improve the data operation of the enterprise data center, improve the timeliness of data analysis, and complete business wide table data sharing, this embodiment designs a storage solution. The working principle of the overall storage solution is shown in Table 1 below.

[0106] Table 1 Storage scheme correspondence table

[0107]

[0108] This embodiment first collects the MAC address of the access side network element, synchronously extracts the optical split number information corresponding to the mac, outputs the user MAC, the OLT network element IP / OLT port corresponding to the MAC, and the optical split number information, and adapts to the collection of access network element devices such as ZTE and Huawei. The network element returns sample data such as Figure 2 As shown, Figure 2 The one selected in the middle box is the spectrophotometer number.

[0109] ZTE NE MAC collection returns sample data, where the value of the Port field in the collected text is in the format of "port: optical splitter number". Taking "gpon-onu_1 / 2 / 1:1" as an example, gpon-onu_1 / 2 / 1 represents the NA-1-2-1 port, and the number 1 after the colon is the optical splitter number 1:

[0110] like Figure 3 As shown, take a PON access splitter with a splitting ratio of 1:4 under the OLT as an example. Because the splitting ratio is 1:4, that is, it can split 4 customer terminal optical modems, the link between the optical fiber from the OLT to the splitter forms a specific splitting number and is recorded in the network element data of the OLT, that is, there are four splitting numbers 1, 2, 3, and 4 under the PON port.

[0111] like Figure 4 As shown in the figure, taking Huawei's OLT network element as an example, connect to the network element through the Telnet protocol and enter the command "display mac-address al1" to obtain the full MAC data list of the network element. The MAC data list contains: MAC is the user MAC, F / S / P is the OLT port, and VPI is the split optical number information.

[0112] Huawei network element MAC collection returns sample data, similar to ZTE network element MAC collection data such as Figure 4 shown.

[0113] Secondly, the user MAC of the AAA authentication data is addressed with the user MAC collected by the network element, the OLT network element IP / OLT port corresponding to the MAC, and the optical split number information, completing the automatic MAC link establishment and realizing the binding of the service account, MAC, OLT and PON port, and optical split number data.

[0114] Then, by scanning the ONU of the access side network element, the OLT-IP, OLT-PON port, optical splitter number, and logical ID data are collected. This data is the network element configuration data and is not affected by whether the user is online. It can be collected multiple times a day and the latest data is selected.

[0115] Finally, based on the automatic MAC link building, the latest logical ID information corresponding to the customer is obtained through the association of OLT-IP, OLT-PON port, and optical splitter number, and finally the data wide table bound by business number, OLT-IP, OLT-PON port, optical splitter number, and logical ID is output. Based on the automatic MAC link building and centralized optical splitter number, the user's precise positioning method is realized, and the binding relationship between the business number and logical ID of the CRM system is reversely audited to see if it is correct, and the CRM junk data is cleaned up.

[0116] The data list names and indexes involved in this embodiment are designed as follows:

[0117] The data list name number starts with the name of the professional or business system and is suffixed with the date in the "YYYYMMDD" format to implement data list naming. For example: JRW_OLT_MAC_YYYYMMDD.txt is the access network MAC address list collection.

[0118] PostgreSQL indexes are based on the principle of minimization and unique indexes. Partition indexes are established according to cities as sub-partitions to improve data query and search efficiency.

[0119] The existing MAC-based automatic link establishment method is a full-network MAC scan, which has a large base and is limited by the user MAC addressing integrity. The link update cycle is 3-7 days, and the delay is large. In the case of a basic link, this embodiment can set up a PON port for data update collection to improve the timeliness of link establishment. Provide real data basis for the logical ID that is uniquely associated with the front-end and back-end customer data, ensure the consistency of BSS and OSS domain customer information through data audit and calibration, and solve a series of problems in service activation and logical ID allocation pool management. Significantly improve the efficiency of network operation and maintenance, data accuracy, and the success rate of service activation, ultimately bringing higher customer satisfaction and a more stable operating environment.

[0120] This embodiment is based on the automatic link establishment of MAC and the precise positioning of the centralized procurement spectrometer number, and uses the MAC address and centralized procurement spectrometer number technology to achieve precise positioning of users; using the network data configuration list of the spectrometer number and the logical ID to support the consistency audit of customer information in the BSS and OSS systems, and reduce the risks caused by data mismatch.

[0121] This embodiment optimizes the MAC automatic link establishment time and shortens the link establishment time by optimizing the link establishment process; improves the efficiency of fault detection and network maintenance, and reduces the impact of network interruption on users.

[0122] This embodiment ensures the uniqueness of the logical ID between the CRM and the network element, eliminates ID conflicts by cleaning and calibrating the logical ID data, improves the data accuracy in the CRM system, and reduces the complexity of operation and maintenance.

[0123] This embodiment cleans up dirty data in the CRM system, improves the success rate of automatic activation of new services, clears dirty data in the CRM system, avoids logical ID conflicts, improves the success rate of automatic activation of new services, reduces manual intervention, shortens activation time, and improves customer satisfaction.

[0124] The other parts of this embodiment are the same as those of the above-mentioned embodiment 1, and thus will not be described in detail.

[0125] Embodiment 3:

[0126] Based on any one of the above-mentioned embodiments 1 to 2, this embodiment proposes a system for accurately locating users based on MAC automatic link building and centralized collection of spectroscopic numbers, which is used to execute the above-mentioned method for accurately locating users based on MAC automatic link building and centralized collection of spectroscopic numbers, including a discrete collection unit, a timing collection unit, an entry unit, a binding unit, and a comparison unit;

[0127] The discrete collection unit is used to collect the MAC information of the OLT network elements of the entire network in a discrete form to obtain the optical split number information corresponding to the MAC address of the PON port;

[0128] The timing collection unit is used to regularly collect the ONU information of the OLT network element of the whole network and obtain the logical ID corresponding to the PON port split number;

[0129] The entry unit is used to enter the optical split number information corresponding to the PON port MAC address and the logical ID corresponding to the PON port optical split number into the enterprise data middle station through the small file system;

[0130] The binding unit is used to bind the split number information corresponding to the PON port MAC address with the AAA system authentication MAC, and bind the logical ID corresponding to the PON port split number with the split number corresponding to the PON port in the link establishment information, so as to complete the mounting of the user logical ID information on the MAC automatic link establishment data;

[0131] The comparison unit is used to associate the customer basic data information obtained from the CRM system and the MAC-based automatic link information wide table through the customer authentication account to obtain the logical ID corresponding to the optical split number under the PON port collected by the network element and the CRM front-end allocated logical ID information.

[0132] This embodiment also proposes an electronic device, including a memory and a processor; a computer program is stored on the memory; when the computer program is executed on the processor, the above-mentioned method of accurately locating users based on MAC automatic link establishment and centralized optical splitting number is implemented.

[0133] This embodiment further proposes a computer-readable storage medium, on which computer instructions are stored; when the computer instructions are executed on the above-mentioned electronic device, the above-mentioned method of accurately locating users based on MAC automatic link establishment and centralized acquisition of optical spectrometry numbers is implemented.

[0134] The other parts of this embodiment are the same as any of the above-mentioned embodiments 1 to 2, and thus will not be described in detail.

[0135] The above description is only a preferred embodiment of the present invention and does not limit the present invention in any form. Any simple modification or equivalent change made to the above embodiment based on the technical essence of the present invention shall fall within the protection scope of the present invention.

Claims

1. A method for accurately locating users based on MAC automatic link building and centralized collection of optical numbers, characterized in that: The specific steps include: Step S1: Collect OLT network element MAC information in a discrete form to obtain the optical split number information corresponding to the PON port MAC address; Step S2: regularly collect the ONU information under the OLT network element to obtain the logical ID corresponding to the PON port split number; Step S3: The optical split number information corresponding to the PON port MAC address and the logical ID corresponding to the PON port optical split number are entered into the enterprise data center through the small file system; Step S4: Bind the optical split number information corresponding to the PON port MAC address with the AAA system authentication MAC, automatically link the MAC address, and bind the logical ID corresponding to the PON port optical split number with the optical split number corresponding to the PON port in the link information according to the MAC address after linking, and mount the user logical ID information to the MAC address automatic linking data; Step S5: Associating the obtained user basic data information and MAC automatic linking information of the CRM system through the client authentication account, obtaining the user's most recent logical ID information, and realizing user positioning.

2. According to claim 1, a method for accurately locating users based on MAC automatic link building, centralized collection and spectral number, characterized in that: The step S1 specifically includes the following steps: Step S11: Collect the MAC data list of OLT network elements in the whole network in a discrete manner; Step S12: parsing the collected OLT network element MAC data list to obtain the PON port, the MAC information corresponding to the PON port, and the optical split number information corresponding to the PON port MAC address; Step S13: Analyze and integrate the IP and PON port of the logged-in LOT device, the MAC information corresponding to the PON port, and the optical split number information corresponding to the MAC address of the PON port to establish a user MAC data list model.

3. According to claim 2, a method for accurately locating users based on MAC automatic link building, centralized collection and spectral number, characterized in that: The step S2 specifically includes the following steps: Step S21: According to the set collection time, regularly collect the ONU information data list of the OLT network element from the access side device; Step S22: parse the collected ONU data to obtain the PON port, the optical split number corresponding to the PON port, and the logical ID information corresponding to the optical split number of the PON port; Step S23: Analyze and integrate the IP and PON port of the OLT device, the corresponding optical split number under the PON port, and the logical ID information corresponding to the optical split number under the PON port to establish a user logical data list model.

4. According to claim 3, a method for accurately locating users based on MAC automatic link building, centralized collection and optical splitting number, characterized in that: The step S4 specifically comprises the following steps: Step S41: Through the big data analysis and integration of the enterprise data center, the user MAC data list is bound to the AAA user authentication data authentication MAC, and the customer authentication account, authentication MAC, IP of the OLT device, PON port, and the information integration of the optical split number corresponding to the MAC address under the PON port are completed to realize automatic link establishment based on MAC; Step S42: Bind the IP, PON port, and corresponding optical split number of the OLT device in the user logic data list model with the IP, PON port, and corresponding optical split number of the OLT device in the link establishment information to complete the mounting of the user logic ID information on the MAC automatic link establishment data.

5. According to claim 4, a method for accurately locating users based on MAC automatic link building, centralized collection and spectral number, characterized in that: The step S5 specifically comprises the following steps: Step S51: Associating the customer basic data information and MAC automatic link establishment information of the CRM system through the customer authentication account, obtaining the logical ID corresponding to the PON port optical split number collected by the network element and the logical ID information allocated by the CRM front end; Step S52: According to the logical ID corresponding to the optical splitting number under the PON port collected by the network element and the logical ID information allocated by the CRM front end, audit and compare the front-end and back-end services, calibrate the inconsistent logical ID information bound to the CRM and the back end, and clean up the CRM junk data to complete the consistency comparison of the front-end and back-end data in the BSS domain and OSS domain.

6. A method for accurately locating users based on MAC automatic link building and centralized collection of optical numbers according to claim 2 or 3, characterized in that: The name and number of the data list starts with the name of the profession or business system and is suffixed with the date in the "YYYYMMDD" format.

7. A method for accurately locating users based on MAC automatic link building and centralized collection of optical spectrometry numbers according to claim 2 or 3, characterized in that: The index of the data list is based on the principle of minimization and uniqueness, and a partition index is established with cities as sub-partitions.

8. A system for accurately locating users based on MAC automatic link building and centralized collection of spectroscopic numbers, used to execute the method for accurately locating users based on MAC automatic link building and centralized collection of spectroscopic numbers as claimed in claim 1, characterized in that: It includes discrete collection unit, timed collection unit, lake entry unit, binding unit and comparison unit; The discrete collection unit is used to collect the MAC information of the OLT network elements of the entire network in a discrete form to obtain the optical split number information corresponding to the MAC address of the PON port; The timing collection unit is used to regularly collect the ONU information of the OLT network element of the whole network and obtain the logical ID corresponding to the PON port split number; The entry unit is used to enter the optical split number information corresponding to the PON port MAC address and the logical ID corresponding to the PON port optical split number into the enterprise data middle station through the small file system; The binding unit is used to bind the split number information corresponding to the PON port MAC address with the AAA system authentication MAC, and bind the logical ID corresponding to the PON port split number with the split number corresponding to the PON port in the link establishment information, so as to complete the mounting of the user logical ID information on the MAC automatic link establishment data; The comparison unit is used to associate the customer basic data information obtained from the CRM system and the MAC-based automatic link information wide table through the customer authentication account to obtain the logical ID corresponding to the optical split number under the PON port collected by the network element and the CRM front-end allocated logical ID information.

9. An electronic device, characterized in that: It comprises a memory and a processor; a computer program is stored on the memory; when the computer program is executed on the processor, the method for accurately locating users based on MAC automatic link establishment, centralized acquisition and spectroscopic number as described in any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions; when the computer instructions are executed on the electronic device as described in claim 9, the method for accurately locating users based on MAC automatic link establishment and centralized optical spectrometry number as described in any one of claims 1-7 is implemented.

Images