Home customer site selection method and system based on ElasticSearch full-text retrieval

By leveraging ElasticSearch full-text search technology and the Vue front-end framework, combined with cascading associations and fuzzy matching, the problem of time-consuming and cumbersome operations in the traditional home address selection process has been solved, enabling fast and simple address queries and device information display, thus improving the user experience.

CN119025735APending Publication Date: 2024-11-26INSPUR TIANYUAN COMM INFORMATION SYST CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
CN202411061042.6
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-05
Publication Date
2024-11-26

AI Technical Summary

Technical Problem

In the current home customer site selection process, traditional methods require querying addresses level by level, which is time-consuming and cumbersome, resulting in a poor user experience.

Method used

Using a full-text search method based on ElasticSearch, combined with the Vue front-end framework and Oracle database, and through cascading association and fuzzy matching techniques, we can quickly obtain 11 levels of address information and display related attributes and device information.

Benefits of technology

It enables rapid querying of tens of millions of address information, improves site selection speed and user experience, simplifies operation process, and provides intuitive address coverage query results.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119025735A_ABST
    Figure CN119025735A_ABST
Patent Text Reader

Abstract

The invention discloses a family customer site selection method and system based on ElasticSearch full-text retrieval, belongs to the technical field of big data rapid search processing, and aims to solve the technical problem of how to simply and rapidly query related contents of family customer site selection by a user, improve the query speed of family customer site selection and improve the use experience of the user. According to the technical scheme, the method comprises the steps of obtaining bottom layer data model data; storing a data prototype and address and equipment relation data through an ORACLE database; displaying a front-end page: limiting and querying 11-level address information through a full-text retrieval fuzzy matching function, and building a user page through a VUE front-end framework; and full-text retrieval query: hierarchically displaying an address filtering module, a full-text retrieval query module, an attribute module after address query and a result module, and realizing full-text retrieval address query through a whole set of pages constructed by combination.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of fast search and processing of big data, and in particular to a method and system for selecting a customer's location based on full-text retrieval of ElasticSearch. Background Art

[0002] ElasticSearch (ES for short) is an open source search and analysis engine based on Lucene, located at the core of ElasticStack. As a powerful open source search and analysis engine, ElasticSearch is widely used in various scenarios, including log data analysis, real-time monitoring, enterprise search, data analysis and mining, etc., due to its distributed architecture, real-time performance, powerful query language, support for multiple data types and easy integration.

[0003] The site selection of home customers, especially when it comes to specific customer groups (such as family customers), requires comprehensive consideration of multiple factors to ensure the rationality, convenience and economic benefits of the site selection. The site selection of home customers is a comprehensive decision-making process that requires comprehensive consideration of multiple factors such as market demand, geographical location, cost-effectiveness, policies and regulations, and competitive environment. Through scientific analysis and reasonable planning, the accuracy and effectiveness of the site selection can be ensured, laying a solid foundation for the successful operation of the project.

[0004] As the amount of home and customer address data on the current network has surged to tens of millions, the traditional site selection method requires a general cascade query method to obtain addresses one level at a time, and the time consumed by the last-level address query has exceeded the human waiting limit. At the same time, there is a defect that the user operation is cumbersome.

[0005] Therefore, how to enable users to simply and quickly query the relevant content of home guest site selection, improve the query speed of home guest site selection, and improve the user experience is a technical problem that needs to be solved urgently. Summary of the invention

[0006] The technical task of the present invention is to provide a method and system for home guest site selection based on ElasticSearch full-text retrieval to solve the problem of how to enable users to simply and quickly query the relevant content of home guest site selection, improve the query speed of home guest site selection, and improve the user experience.

[0007] The technical task of the present invention is achieved in the following way: a method for selecting a customer's location based on full-text retrieval of ElasticSearch, which is specifically as follows:

[0008] Obtaining underlying data model data: storing data prototypes and address and device relationship data through ORACLE database;

[0009] Display the front-end page: Use the full-text search fuzzy matching function to limit the query to the 11th level address information, and build the user page through the VUE front-end framework;

[0010] Full-text search query: hierarchical display of address filtering module, full-text search query module, attribute module after address query and result module, through the combination of a whole set of pages, to achieve full-text search address query.

[0011] As a preferred option, the address filtering module uses the VUE front-end framework and springcloud technology to develop the front-end page and back-end code logic, as follows:

[0012] The first four levels of standard address information in the 11-level address stored in the standard address database provided by comprehensive resources are taken out and displayed on the page as enumeration values, which can be clicked;

[0013] After selecting the name of any first-level address information, the second-level address information under the selected first-level address information is obtained through the cascade association between the first-level address information and the second-level address information, and displayed on the page corresponding to the second-level address information;

[0014] Similarly, after selecting the first-level address information and the second-level address information, the third-level address information under the first-level address information and the second-level address information is obtained through cascading association, and displayed on the page; then the cascaded fourth-level road and lane address information is obtained through the selected first-level address information, second-level address information and third-level address information, and displayed on the page;

[0015] Through various cascading relationship selections, the first four levels of address IDs are confirmed, and the first four levels of address IDs are temporarily stored as the preconditions for the current query, and the last seven levels of address information are accurately obtained through the preconditions.

[0016] As a preferred method, the full-text search query module adopts the core distributed search engine technology of Elasticserach, and performs keyword filtering and querying through fuzzy matching. The full-text search query module only queries the address information of the community and the house number; the details are as follows:

[0017] Establish a standard address model with key attributes including model name, resource name and full name of resource address through the database;

[0018] Use Elasticserach's core distributed search engine technology to initialize the standard address model data in the ORACLE database;

[0019] Through keyword search, the data on the residential area and house number in the standard address library is fixedly obtained. The obtained data is displayed on the page. Only the model name, resource name and address full name fields need to be displayed. 10-15 records are displayed on each page. Page turning is performed, and the house number result data is selected for reverse order.

[0020] Among them, the added "only query addresses with coverage" option is used to query the data in the relationship model between standard addresses and coverage devices.

[0021] Preferably, the query results of the full-text search query module include the following forms:

[0022] Form 1: Query all residential areas and house number data managed in the standard address model;

[0023] Form 2: Query all the community and house number data in the standard address and equipment coverage relationship model.

[0024] As a preferred option, the address attribute module uses the VUE front-end framework and Springcloud framework to develop the underlying code and front-end display page; the details are as follows:

[0025] The full-text search query module obtains the precise room-level address, temporarily stores the room address ID, and transmits the room address ID to the address attribute module as a parameter. The address attribute module obtains the community ID from the standard address library through the unique final room ID, and obtains the community's acceptance status, service type, whether it is universal telecommunications service, skin line access method, and whether it supports FTTR activation in the community model through the community ID, and displays it in the upper right corner of the page;

[0026] Through the standard address and device coverage relationship model, use the last room address ID to query and obtain the corresponding coverage device list, and display the device name, total number of ports, number of idle ports, number of broadband users and access method fields at the bottom right of the page;

[0027] There are two buttons, Initiate Expansion Work Order and Select Address, at the bottom right of the page. Initiate Expansion Work Order means that in the queried equipment list, for data with no idle ports, click the Initiate Expansion Work Order button to initiate a work order for on-site expansion equipment to the EOMS system. After clicking the Select Address button, each level of the 11-level standard address information will be fed back to the front-end account opening system in real time through the URL interface, and the account opening system will assemble the address information for dispatching operations.

[0028] Preferably, the list of covered devices includes a smart home service option, which is checked when the front end handles the smart networking service. After checking, the address coverage device returns the address information to the front end unconditionally (the port is not occupied because the installed service does not occupy the port, so the port status is not checked);

[0029] Double-click the overridden device record in the overridden device list:

[0030] If the resources are available, the device selection will be successful.

[0031] If the number of free ports is 0, it will prompt that there is no free port and selection is not allowed;

[0032] If the number of users is greater than or equal to 4, it will prompt that the number of accounts opened under the corresponding address has exceeded the limit and selection is not allowed (if the smart home service in the previous step is checked, these two checks will not be performed and the address can be selected);

[0033] When the number of free ports in the coverage device list is less than or equal to 2, click the button to initiate the expansion work order to initiate the expansion work order. You only need to trigger the interface, as follows:

[0034] When selecting a site at the front desk, the interface content includes the Chinese name of the field, the English name of the field, the parameter length, the description, and whether the field is required; the Chinese name of the field includes the first-level address information, product type, comprehensive capital order number, CRM work order number, login user account, account manager name, account manager mobile phone number, and organization code or name;

[0035] Address return interface: After the front-end address is confirmed, the address information is returned by calling the URL.

[0036] Preferably, the result module uses restfull technology to feedback the address query address ID, specifically: directly returning the selected address in the page through the URL, loading the 11-level address ID information of the page, and directly attaching it to the corresponding requested URL return through URL assembly, so that the user system that queries the address can obtain accurate address ID data.

[0037] A home visitor location selection system based on ElasticSearch full-text retrieval, the system comprising:

[0038] The address filtering module is used to obtain the names of all first-level address information in the database as enumeration values ​​and display them on the page through the first four levels of standard address information in the 11-level address stored in the standard address database provided by comprehensive resources, and can be clicked; after selecting the name of any first-level address information, the second-level address information under the selected first-level address information is obtained through the cascade association of the first-level address information and the second-level address information, and displayed on the page corresponding to the second-level address information; similarly, after selecting the first-level address information and the second-level address information, the third-level address information under the first-level address information and the second-level address information is obtained through the cascade association, and displayed on the page; the cascaded fourth-level road and lane address information is obtained through the selected first-level address information, the second-level address information and the third-level address information, and displayed on the page; the first four-level address IDs are selected through various cascade relationships, and the first four-level address IDs are temporarily stored as the preconditions for the current query, and the last seven levels of address information are accurately obtained through the preconditions;

[0039] The full-text search query module is used to establish a standard address model with key attributes including model name, resource name and full name of resource address through the database; use the core distributed search engine technology of Elasticserach to initialize the standard address model data in the ORACLE database; through keyword search, obtain the data about the two-level addresses of the community and the house number in the standard address library, and display the obtained data on the page. Only the three fields of model name, resource name and full name of address need to be displayed. 10-15 records are displayed per page, and page turning is performed, and the result data of the house number is selected for reverse order;

[0040] The address attribute module is used to obtain the precise room-level address through the full-text search query module, temporarily store the room address ID, and pass the room address ID to the address attribute module as a parameter. The address attribute module obtains the community ID in the standard address library through the unique final room ID, and obtains the community's acceptance status, service type, whether it is universal telecommunications service, skin line access method and whether it supports FTTR activation in the community model through the community ID, and displays it in the upper right corner of the page; and through the standard address and equipment coverage relationship model, the final room address ID is used to query and obtain the corresponding The device list is covered, and the fields showing the device name, total number of ports, number of free ports, number of broadband users and access method are displayed in the lower right corner of the page. There are also two buttons, Initiate Capacity Expansion Work Order and Select Address, in the lower right corner of the page. Among them, Initiate Capacity Expansion Work Order means that in the queried device list, for data with no free ports, click the Initiate Capacity Expansion Work Order button to initiate a work order for on-site capacity expansion equipment to the EOMS system; After clicking the Select Address button, each level of address ID of the 11-level standard address information is fed back to the front-end account opening system in real time through the URL interface, and the account opening system assembles the address information for dispatching operations;

[0041] The result module is used to directly return the selected address in the page through the URL, load the 11-level address ID information of the page, and directly attach it to the URL return of the corresponding request through URL splicing, so that the user system that queries the address can obtain accurate address ID data.

[0042] An electronic device comprising: a memory and at least one processor;

[0043] Wherein, the memory stores a computer program;

[0044] The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the above-mentioned method for selecting home addresses based on ElasticSearch full-text retrieval.

[0045] A computer-readable storage medium having a computer program stored therein, wherein the computer program can be executed by a processor to implement the above-mentioned method for selecting a home visitor's location based on full-text retrieval of ElasticSearch.

[0046] The method and system for selecting a customer's location based on ElasticSearch full-text retrieval has the following advantages:

[0047] (I) The present invention is based on the ElasticSearch technology of the search server of Lucene, and utilizes its characteristic function of fast search of big data to realize the ability to query information of tens of millions of addresses; the resource coverage capability is mainly formed by associating the last level address of the defined standard 11-level address with the coverage device to form a resource coverage model, and by sharing the data in the model, the accurate installation address of the home broadband service is obtained to realize the rapid processing and activation of the service;

[0048] (ii) The present invention uses the fast search method of ElasticSearch technology to achieve fast search and processing of tens of millions of address coverage data, and uses VUE technology to efficiently build simple and clear user pages, thereby achieving fast and accurate site selection using full-text retrieval technology;

[0049] (III) The present invention uses the corresponding capabilities provided by mature platforms such as Elasticsearch technology, VUE front-end framework, and ORACLE database to realize full-text search address query. At the same time, the present invention uses a fuzzy matching method, which has more friendly feedback results than word segmentation matching, making this method easier to use;

[0050] (iv) The present invention uses big data search capabilities and a universal fuzzy matching method to simply and clearly query the desired address content, which can solve the user's cumbersome operation mode, improve the query speed of site selection, and enhance the user's usage perception;

[0051] (V) The present invention can effectively improve the speed of address coverage query, and display the results of home customer address coverage query in a more friendly way, providing a more user-friendly site selection page for the front end, so that users can more quickly open home customer services, and the present invention can also be promoted as a general method for use throughout the country, which can bring the coverage site selection method to a new level;

[0052] (VI) The present invention uses the big data search capability of ElasticSearch technology to quickly retrieve accurate addresses through fuzzy matching;

[0053] (VII) The present invention uses the VUE front-end framework to quickly and beautifully develop user pages, intuitively displaying address attribute results, device information list space ports and other information;

[0054] (VIII) The present invention directly splices all address IDs, community attributes and other data into the URL for feedback through page selection. BRIEF DESCRIPTION OF THE DRAWINGS

[0055] The present invention is further described below in conjunction with the accompanying drawings.

[0056] Attached Figure 1 This is the structural diagram of the home-customer location selection system based on ElasticSearch full-text retrieval;

[0057] Attached Figure 2 This is a screenshot of the full-text search site selection page;

[0058] Attached Figure 3 This is a screenshot of the filter module interface;

[0059] Attached Figure 4 This is a screenshot of the interface of the full-text search query module;

[0060] Attached Figure 5 This is a screenshot of the interface of the address attribute module. DETAILED DESCRIPTION

[0061] The following detailed description is made of the method and system for selecting a home visitor's location based on ElasticSearch full-text retrieval with reference to the accompanying drawings and specific embodiments of the specification.

[0062] Embodiment 1:

[0063] As attached Figure 2 As shown, this embodiment provides a method for selecting a home customer location based on full-text retrieval of ElasticSearch, and the method is specifically as follows:

[0064] S1. Obtaining underlying data model data: storing data prototypes and address and device relationship data through ORACLE database;

[0065] S2. Display the front-end page: Use the full-text search fuzzy matching function to limit the query to the 11th level address information, and build the user page through the VUE front-end framework;

[0066] S3. Full-text search query: hierarchical display of address filtering module, full-text search query module, attribute module after address query and result module, through the combination of a whole set of pages, to achieve full-text search address query.

[0067] As attached Figure 3 As shown, the address filtering module in this embodiment uses the VUE front-end framework and springcloud technology to develop the front-end page and back-end code logic, as follows:

[0068] (1) The first four levels of standard address information in the 11-level address stored in the standard address database provided by comprehensive resources are taken out and displayed on the page as enumeration values, which can be clicked;

[0069] (2) After selecting the name of any first-level address information, the second-level address information under the selected first-level address information is obtained through the cascade association of the first-level address information and the second-level address information, and is displayed on the page corresponding to the second-level address information;

[0070] (3) Similarly, after selecting the first-level address information and the second-level address information, the third-level address information under the first-level address information and the second-level address information is obtained through cascading association and displayed on the page; then the cascaded fourth-level road and lane address information is obtained through the selected first-level address information, the second-level address information and the third-level address information, and displayed on the page;

[0071] (4) Through various cascading relationships, the first four levels of address IDs are selected and confirmed, and the first four levels of address IDs are temporarily stored as the preconditions for the current query, and the address information of the last seven levels is accurately obtained through the preconditions.

[0072] As attached Figure 4 As shown, the full-text search query module in this embodiment adopts the core distributed search engine technology of Elasticserach, and performs keyword filtering and querying by fuzzy matching. The full-text search query module only queries the address information of the community and the house number; the details are as follows:

[0073] (1) Establish a standard address model with key attributes including model name, resource name and full name of resource address through the database;

[0074] (2) Use Elasticserach's core distributed search engine technology to initialize the standard address model data in the ORACLE database;

[0075] (3) Through keyword search, the data on the residential area and house number in the standard address database is fixedly obtained. The obtained data is displayed on the page. Only the three fields of model name, resource name and address full name need to be displayed. 10-15 records are displayed on each page. The page is turned, and the house number result data is selected for reverse order.

[0076] Among them, the added "only query addresses with coverage" option is used to query the data in the relationship model between standard addresses and coverage devices.

[0077] The query results of the full-text search query module in this embodiment include the following forms:

[0078] Form 1: Query all residential areas and house number data managed in the standard address model;

[0079] Form 2: Query all the community and house number data in the standard address and equipment coverage relationship model.

[0080] As attached Figure 5 As shown, the address attribute module in this embodiment uses the VUE front-end framework and Springcloud framework to develop the underlying code and front-end display page; the details are as follows:

[0081] (1) The full-text search query module obtains the precise room-level address, temporarily stores the room-level address ID, and transmits the room-level address ID to the address attribute module as a parameter. The address attribute module obtains the community ID from the standard address library through the unique final room-level ID. The community model obtains the community's acceptance status, service type, whether it provides universal telecommunications service, the method of accessing the household with a skin line, and whether it supports FTTR activation through the community ID, and displays the information on the upper right corner of the page;

[0082] (2) Through the standard address and device coverage relationship model, use the last room address ID to query and obtain the corresponding coverage device list, and display the device name, total number of ports, number of idle ports, number of broadband users, and access method fields at the bottom right of the page;

[0083] (3) There are two buttons at the bottom right of the page: Initiate Capacity Expansion Work Order and Select Address. Initiate Capacity Expansion Work Order means that in the queried device list, for data with no idle ports, click the Initiate Capacity Expansion Work Order button to initiate a work order for on-site capacity expansion equipment to the EOMS system. After clicking the Select Address button, the address ID of each level of the 11-level standard address information is fed back to the front-end account opening system in real time through the URL interface. The account opening system assembles the address information for dispatching operations.

[0084] The coverage device list in this embodiment includes a smart home service option. The smart home service option is checked when the front end handles the smart networking service. After checking, the address coverage device returns the address information to the front end unconditionally (the port is not occupied when the service is installed, so the port status is not checked);

[0085] Double-click the overridden device record in the overridden device list:

[0086] If the resources are available, the device selection will be successful.

[0087] If the number of free ports is 0, it will prompt that there is no free port and selection is not allowed;

[0088] If the number of users is greater than or equal to 4, it will prompt that the number of accounts opened under the corresponding address has exceeded the limit and selection is not allowed (if the smart home service in the previous step is checked, these two checks will not be performed and the address can be selected);

[0089] When the number of free ports in the coverage device list is less than or equal to 2, click the button to initiate the expansion work order to initiate the expansion work order. You only need to trigger the interface, as follows:

[0090] When selecting a site at the front desk, the interface content includes the Chinese name of the field, the English name of the field, the parameter length, the description, and whether the field is required; the Chinese name of the field includes the first-level address information, product type, comprehensive capital order number, CRM work order number, login user account, account manager name, account manager mobile phone number, and organization code or name; as shown in the following table:

[0091]

[0092] Address return interface: After the front-end address is confirmed, the address information is returned by calling the URL.

[0093] Interface type: Link.

[0094] Interface URL: After the device is successfully selected by double-clicking, the following address information is fed back to the front desk through the URL;

[0095] XML format string, initiate message:

[0096] It is recommended that the front end be in json format;

[0097]

[0098]

[0099] Response message:

[0100]

[0101] The result module in this embodiment uses restfull technology to feedback the address query address ID, specifically: directly returning the selected address in the page through the URL, loading the 11-level address ID information of the page, and directly attaching it to the corresponding requested URL return through URL assembly, so that the user system that queries the address can obtain accurate address ID data.

[0102] Embodiment 2:

[0103] As attached Figure 1 As shown, this embodiment provides a home customer location selection system based on ElasticSearch full-text retrieval, the system comprising:

[0104] The address filtering module is used to obtain the names of all first-level address information in the database as enumeration values ​​and display them on the page through the first four levels of standard address information in the 11-level address stored in the standard address database provided by comprehensive resources, and can be clicked; after selecting the name of any first-level address information, the second-level address information under the selected first-level address information is obtained through the cascade association of the first-level address information and the second-level address information, and displayed on the page corresponding to the second-level address information; similarly, after selecting the first-level address information and the second-level address information, the third-level address information under the first-level address information and the second-level address information is obtained through the cascade association, and displayed on the page; the cascaded fourth-level road and lane address information is obtained through the selected first-level address information, the second-level address information and the third-level address information, and displayed on the page; the first four-level address IDs are selected through various cascade relationships, and the first four-level address IDs are temporarily stored as the preconditions for the current query, and the last seven levels of address information are accurately obtained through the preconditions;

[0105] The full-text search query module is used to establish a standard address model with key attributes including model name, resource name and full name of resource address through the database; use the core distributed search engine technology of Elasticserach to initialize the standard address model data in the ORACLE database; through keyword search, obtain the data about the two-level addresses of the community and the house number in the standard address library, and display the obtained data on the page. Only the three fields of model name, resource name and full name of address need to be displayed. 10-15 records are displayed per page, and page turning is performed, and the result data of the house number is selected for reverse order;

[0106] The address attribute module is used to obtain the precise room-level address through the full-text search query module, temporarily store the room address ID, and pass the room address ID to the address attribute module as a parameter. The address attribute module obtains the community ID in the standard address library through the unique final room ID, and obtains the community's acceptance status, service type, whether it is universal telecommunications service, skin line access method and whether it supports FTTR activation in the community model through the community ID, and displays it in the upper right corner of the page; and through the standard address and equipment coverage relationship model, the final room address ID is used to query and obtain the corresponding The device list is covered, and the fields showing the device name, total number of ports, number of free ports, number of broadband users and access method are displayed in the lower right corner of the page. There are also two buttons, Initiate Capacity Expansion Work Order and Select Address, in the lower right corner of the page. Among them, Initiate Capacity Expansion Work Order means that in the queried device list, for data with no free ports, click the Initiate Capacity Expansion Work Order button to initiate a work order for on-site capacity expansion equipment to the EOMS system; After clicking the Select Address button, each level of address ID of the 11-level standard address information is fed back to the front-end account opening system in real time through the URL interface, and the account opening system assembles the address information for dispatching operations;

[0107] The result module is used to feedback the address query address ID using RESTfull technology. Specifically, the selected address is directly returned in the page through the URL, the 11-level address ID information of the page is loaded, and it is directly attached to the URL returned by the corresponding request through URL splicing, so that the user system that queries the address can obtain accurate address ID data.

[0108] Embodiment 3:

[0109] An embodiment of the present invention further provides an electronic device, comprising: a memory and a processor;

[0110] Wherein, the memory stores computer-executable instructions;

[0111] The processor executes the computer-executable instructions stored in the memory, so that the processor executes the method for selecting home addresses based on ElasticSearch full-text retrieval in any embodiment of the present invention.

[0112] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor may be a microprocessor or any conventional processor, etc.

[0113] The memory can be used to store computer programs and / or modules. The processor realizes various functions of the electronic device by running or executing the computer programs and / or modules stored in the memory, and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc.; the data storage area can store data created according to the use of the terminal, etc. In addition, the memory can also include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SMC), a secure digital (SD) card, a flash memory card, at least one disk storage period, a flash memory device, or other volatile solid-state storage devices.

[0114] Embodiment 4:

[0115] This embodiment also provides a computer-readable storage medium, which stores a plurality of instructions, which are loaded by a processor to enable the processor to execute the method for selecting a home address based on full-text retrieval of ElasticSearch in any embodiment of the present invention. Specifically, a system or device equipped with a storage medium can be provided, on which software program codes for implementing the functions of any of the above embodiments are stored, and a computer (or CPU or MPU) of the system or device can read and execute the program code stored in the storage medium.

[0116] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.

[0117] The storage medium embodiments for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RYM, DVD-RW, DVD+RW), a magnetic tape, a non-volatile memory card, and a ROM. Alternatively, the program code can be downloaded from a server computer via a communication network.

[0118] In addition, it should be clear that the functions of any of the above embodiments can be implemented not only by executing the program code read by the computer, but also by enabling an operating system operating on the computer to complete part or all of the actual operations based on instructions from the program code.

[0119] In addition, it can be understood that the program code read from the storage medium is written to a memory provided in an expansion board inserted into the computer or written to a memory provided in an expansion unit connected to the computer, and then based on the instructions of the program code, a CPU installed on the expansion board or the expansion unit is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above-mentioned embodiments.

[0120] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for selecting a customer's location based on full-text retrieval of ElasticSearch, characterized in that: The method is as follows: Obtaining underlying data model data: storing data prototypes and address and device relationship data through ORACLE database; Display the front-end page: Use the full-text search fuzzy matching function to limit the query to the 11th level address information, and build the user page through the VUE front-end framework; Full-text search query: hierarchical display of address filtering module, full-text search query module, attribute module after address query and result module, through the combination of a whole set of pages, to achieve full-text search address query.

2. The method for selecting a customer's location based on full-text retrieval of ElasticSearch according to claim 1, characterized in that: The address filtering module uses the VUE front-end framework and springcloud technology to develop the front-end page and back-end code logic, as follows: The first four levels of standard address information in the 11-level address stored in the standard address database provided by comprehensive resources are taken out and displayed on the page as enumeration values, which can be clicked; After selecting the name of any first-level address information, the second-level address information under the selected first-level address information is obtained through the cascade association between the first-level address information and the second-level address information, and displayed on the page corresponding to the second-level address information; Similarly, after selecting the first-level address information and the second-level address information, the third-level address information under the first-level address information and the second-level address information is obtained through cascading association, and displayed on the page; then the cascaded fourth-level road and lane address information is obtained through the selected first-level address information, second-level address information and third-level address information, and displayed on the page; Through various cascading relationship selections, the first four levels of address IDs are confirmed, and the first four levels of address IDs are temporarily stored as the preconditions for the current query, and the last seven levels of address information are accurately obtained through the preconditions.

3. The method for selecting a customer's location based on full-text retrieval of ElasticSearch according to claim 1, characterized in that: The full-text search query module uses the core distributed search engine technology of Elasticserach, and performs keyword filtering and querying through fuzzy matching. The full-text search query module only queries the address information of the community and the house number; the details are as follows: Establish a standard address model with key attributes including model name, resource name and full name of resource address through the database; Use Elasticserach's core distributed search engine technology to initialize the standard address model data in the ORACLE database; Through keyword search, the data on the residential area and house number in the standard address library is fixedly obtained. The obtained data is displayed on the page. Only the model name, resource name and address full name fields need to be displayed. 10-15 records are displayed on each page. Page turning is performed, and the house number result data is selected for reverse order. Among them, the added "only query addresses with coverage" option is used to query the data in the relationship model between standard addresses and coverage devices.

4. The method for selecting a customer's location based on full-text retrieval of ElasticSearch according to claim 3 is characterized in that: The query results of the full-text search query module include the following forms: Form 1: Query all residential areas and house number data managed in the standard address model; Form 2: Query all the community and house number data in the standard address and equipment coverage relationship model.

5. The method for selecting a customer's location based on full-text retrieval of ElasticSearch according to claim 1, characterized in that: The address attribute module uses the VUE front-end framework and Springcloud framework to develop the underlying code and front-end display page; the details are as follows: The full-text search query module obtains the precise room-level address, temporarily stores the room address ID, and transmits the room address ID to the address attribute module as a parameter. The address attribute module obtains the community ID from the standard address library through the unique final room ID, and obtains the community's acceptance status, service type, whether it is universal telecommunications service, skin line access method, and whether it supports FTTR activation in the community model through the community ID, and displays it in the upper right corner of the page; Through the standard address and device coverage relationship model, use the last room address ID to query and obtain the corresponding coverage device list, and display the device name, total number of ports, number of idle ports, number of broadband users and access method fields at the bottom right of the page; There are two buttons, Initiate Expansion Work Order and Select Address, at the bottom right of the page. Initiate Expansion Work Order means that in the queried equipment list, for data with no idle ports, click the Initiate Expansion Work Order button to initiate a work order for on-site expansion equipment to the EOMS system. After clicking the Select Address button, each level of the 11-level standard address information will be fed back to the front-end account opening system in real time through the URL interface, and the account opening system will assemble the address information for dispatching operations.

6. The method for selecting a customer's location based on full-text retrieval of ElasticSearch according to claim 5, characterized in that: The list of covered devices includes the option of whether to provide smart home services. The option of whether to provide smart home services is checked when the front end handles the smart networking service. If checked, the address coverage device will return the address information to the front end unconditionally. Double-click the overridden device record in the overridden device list: If the resources are available, the device selection will be successful. If the number of free ports is 0, it will prompt that there is no free port and selection is not allowed; If the number of users is greater than or equal to 4, it will prompt that the number of accounts opened under the corresponding address has exceeded the limit and selection is not allowed; When the number of free ports in the coverage device list is less than or equal to 2, click the button to initiate the expansion work order to initiate the expansion work order. You only need to trigger the interface, as follows: When selecting a site at the front desk, the interface content includes the Chinese name of the field, the English name of the field, the parameter length, the description, and whether the field is required; the Chinese name of the field includes the first-level address information, product type, comprehensive capital order number, CRM work order number, login user account, account manager name, account manager mobile phone number, and organization code or name; Address return interface: After the front-end address is confirmed, the address information is returned by calling the URL.

7. The method for selecting a customer's location based on full-text retrieval of ElasticSearch according to claim 1, characterized in that: The result module uses restfull technology to feedback the address query address ID, specifically: directly return the selected address in the page through the URL, load the 11-level address ID information of the page, and directly attach it to the corresponding request URL return through URL splicing, so that the user system that queries the address can obtain accurate address ID data.

8. A full-text retrieval system for selecting customers' locations based on ElasticSearch, characterized in that: The system includes: The address filtering module is used to obtain the names of all first-level address information in the database as enumeration values ​​and display them on the page through the first four levels of standard address information in the 11-level address stored in the standard address database provided by comprehensive resources, and can be clicked; after selecting the name of any first-level address information, the second-level address information under the selected first-level address information is obtained through the cascade association of the first-level address information and the second-level address information, and displayed on the page corresponding to the second-level address information; similarly, after selecting the first-level address information and the second-level address information, the third-level address information under the first-level address information and the second-level address information is obtained through the cascade association, and displayed on the page; the cascaded fourth-level road and lane address information is obtained through the selected first-level address information, the second-level address information and the third-level address information, and displayed on the page; the first four-level address IDs are selected through various cascade relationships, and the first four-level address IDs are temporarily stored as the preconditions for the current query, and the last seven levels of address information are accurately obtained through the preconditions; The full-text search query module is used to establish a standard address model with key attributes including model name, resource name and full name of resource address through the database; use the core distributed search engine technology of Elasticserach to initialize the standard address model data in the ORACLE database; through keyword search, obtain the data about the two-level addresses of the community and the house number in the standard address library, and display the obtained data on the page. Only the three fields of model name, resource name and full name of address need to be displayed. 10-15 records are displayed per page, and page turning is performed, and the result data of the house number is selected for reverse order; The address attribute module is used to obtain the precise room-level address through the full-text search query module, temporarily store the room address ID, and pass the room address ID to the address attribute module as a parameter. The address attribute module obtains the community ID in the standard address library through the unique final room ID, and obtains the community's acceptance status, service type, whether it is universal telecommunications service, skin line access method and whether it supports FTTR activation in the community model through the community ID, and displays it in the upper right corner of the page; and through the standard address and equipment coverage relationship model, the final room address ID is used to query and obtain the corresponding The device list is covered, and the fields showing the device name, total number of ports, number of free ports, number of broadband users and access method are displayed in the lower right corner of the page. There are also two buttons, Initiate Capacity Expansion Work Order and Select Address, in the lower right corner of the page. Among them, Initiate Capacity Expansion Work Order means that in the queried device list, for data with no free ports, click the Initiate Capacity Expansion Work Order button to initiate a work order for on-site capacity expansion equipment to the EOMS system; After clicking the Select Address button, each level of address ID of the 11-level standard address information is fed back to the front-end account opening system in real time through the URL interface, and the account opening system assembles the address information for dispatching operations; The result module is used to directly return the selected address in the page through the URL, load the 11-level address ID information of the page, and directly attach it to the URL return of the corresponding request through URL splicing, so that the user system that queries the address can obtain accurate address ID data.

9. An electronic device, characterized in that: include: memory and at least one processor; Wherein, the memory stores a computer program; The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the method for selecting home addresses based on ElasticSearch full-text retrieval as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, which can be executed by a processor to implement the method for selecting a home visitor's location based on ElasticSearch full-text retrieval as described in any one of claims 1 to 7.

Citation Information

Patent Citations

  • Chinese place name address searching and matching method, terminal and computer readable storage medium

    CN110399448A

  • Configurable credit file retrieval method and system based on Elasticsearch technology

    CN112269807A

  • Method and system covering AOI and POI standard address matching engines

    CN112328910A

  • Rich text full-text retrieval and cloud storage system

    CN114546948A