Method and apparatus for data retrieval

By obtaining and summarizing employee identification and latitude and longitude information in customer behavior flow data, identifying the attribution organization and administrative area, the problem of low data display efficiency in the existing technology is solved, and the correlation display of data and geographical location is realized, and the user experience is improved. and data analysis capabilities.

CN114238730BActive Publication Date: 2024-11-19CHINA CONSTRUCTION BANK
View PDF 6 Cites 0 Cited by

Patent Information

Application Number
CN202111574359.6
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-12-21
Publication Date
2024-11-19
Estimated Expiration
2041-12-21

AI Technical Summary

Technical Problem

The existing marketing activities customer data display methods can only form a simple data display effect, the correlation between the data volume and data is limited, the retrieval efficiency is not high, and the user experience is poor.

Method used

By obtaining customer behavior flow data, including employee identification and latitude and longitude information, identifying the affiliated institutions and administrative regions of customer behavior, performing data summary and statistics, and storing them to a distributed search server, realizing the correlation display of data and geographical locations, and improving data Retrieval efficiency.

Benefits of technology

It improves the efficiency of data retrieval, improves user experience, can intuitively reflect regional data differences, enhances global data analysis capabilities, and realizes real-time monitoring capabilities of the entire bank's data, so as to quickly respond to market changes for decision makers.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114238730B_ABST
    Figure CN114238730B_ABST
Patent Text Reader

Abstract

The present application provides a method and device for data retrieval, which relates to the field of data visualization technology. By binding customer behavior flow data and regions, the display of corresponding data at each regional level can be realized, thereby improving the efficiency of data retrieval and user experience. The method includes: obtaining customer behavior flow data, which includes employee identification and longitude and latitude information; based on the employee identification and longitude and latitude information, identifying the affiliated institutions and administrative regions corresponding to the customer behavior in the above customer behavior flow data, and obtaining detailed data; according to the affiliated institutions and administrative regions, summarizing and counting the detailed data, and obtaining first summary data, which includes the number of visits and visitors to marketing activities under different levels of affiliated institutions and administrative regions; storing the detailed data and the first summary data in a distributed retrieval server.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the technical field of data visualization, and in particular to a method and device for data retrieval. Background Art

[0002] The existing method of displaying customer data for marketing activities is to count customer data according to a certain caliber (such as the branch to which the customer belongs, and the branch where the account manager who markets the customer is located) and to aggregate the information in the form of statistical reports to the head office, first-tier branches, second-tier branches, sub-branches, and branches.

[0003] However, the above method can only form a simple data display effect. Through this display effect, the amount of data and the correlation between the data obtained by relevant personnel are very limited, the retrieval efficiency is low, and the user experience is not good. Summary of the invention

[0004] The present application provides a method and device for data retrieval, which can display the corresponding data of each regional level by binding customer behavior flow data and regions, thereby improving the efficiency of data retrieval and thus improving the user experience.

[0005] In a first aspect, a method for data retrieval is provided, which can be executed by a data retrieval device, the method comprising: obtaining customer behavior flow data, the customer behavior flow data comprising employee identification, and longitude and latitude information; based on the employee identification and the longitude and latitude information, identifying the affiliation organization and administrative region corresponding to the customer behavior in the customer behavior flow data to obtain detailed data; summarizing and counting the detailed data according to the affiliation organization and the administrative region to obtain first summary data, the first summary data comprising the number of visits and the number of visitors to marketing activities under different levels of affiliation organizations and administrative regions; storing the detailed data and the first summary data to a distributed retrieval server.

[0006] In the present application, the data retrieval device obtains customer behavior flow data, which includes employee identification and latitude and longitude information. Based on the employee identification and the latitude and longitude information, the affiliated institution and administrative region corresponding to the customer behavior in the customer behavior flow data are identified to obtain detailed data, that is, the customer behavior flow data is associated with the region to obtain the customer behavior flow data associated with the region, and then the customer behavior flow data associated with the region, that is, the detailed data, is summarized and counted according to the affiliated institution and the administrative region to obtain the first summary data, which includes the number of visits and the number of visitors of marketing activities under the affiliated institutions and administrative regions of different levels. The customer behavior flow data associated with the region is summarized according to the level of the region, such as the data corresponding to the municipal administrative region can be summarized into the data of the administrative region, and the detailed data and the first summary data can be stored in the distributed retrieval server for access and call during retrieval, and the data is displayed in detail on the map, which improves the efficiency of data retrieval, thereby improving the user experience. The method and device for data retrieval of the present application combine data display with geographical location, which can intuitively reflect regional data differences and improve global data analysis capabilities. In addition, the method and device for data retrieval of the present application can realize the real-time monitoring capability of the whole bank's data, so that decision makers can quickly respond to market reactions and make adjustments, thereby improving the efficiency of digital operations.

[0007] In combination with the first aspect, in certain implementations of the first aspect, the method further includes: obtaining retrieval information, the retrieval information including the employee identification, the longitude and latitude information, the identification of the marketing activity, the affiliated organization, the administrative region and at least one of the time information; based on the retrieval information, displaying retrieval result data corresponding to the retrieval information on a map, the detailed data and / or the first summary data stored in the distributed retrieval server including the retrieval result data.

[0008] In combination with the first aspect, in certain implementations of the first aspect, the above-mentioned identifying the affiliated institution and administrative region corresponding to the customer behavior in the above-mentioned customer behavior flow data based on the above-mentioned employee identification and the above-mentioned longitude and latitude information includes: determining the institution to which the employee corresponding to the above-mentioned employee identification belongs or the institution corresponding to the above-mentioned longitude and latitude information as the affiliated institution corresponding to the customer behavior in the above-mentioned customer behavior flow data; determining the administrative region corresponding to the above-mentioned longitude and latitude information as the administrative region corresponding to the customer behavior in the above-mentioned customer behavior flow data.

[0009] In combination with the first aspect, in certain implementations of the first aspect, the method further includes: aggregating and counting the detailed data according to the employee identification to obtain second summary data, wherein the second summary data includes the number of visits and the number of visitors to marketing activities of different employees; and storing the second summary data in the distributed retrieval server.

[0010] In combination with the first aspect, in certain implementations of the first aspect, the above-mentioned affiliated institutions include a head office, a first-level branch, a second-level branch, a sub-branch and a business hall.

[0011] In combination with the first aspect, in certain implementations of the first aspect, the above-mentioned administrative regions include national-level administrative regions, provincial-level administrative regions, municipal-level administrative regions, and district-level administrative regions.

[0012] In a second aspect, a device for data retrieval is provided, comprising an acquisition module and a processing module, wherein the acquisition module is used to: acquire customer behavior flow data, the customer behavior flow data including employee identification and longitude and latitude information; the processing module is used to: identify the affiliated institution and administrative region corresponding to the customer behavior in the customer behavior flow data based on the employee identification and the longitude and latitude information, and obtain detailed data; summarize and count the detailed data according to the affiliated institution and the administrative region, and obtain first summary data, the first summary data including the number of visits and visitors to marketing activities under different levels of affiliated institutions and administrative regions; and, store the detailed data and the first summary data in a distributed retrieval server.

[0013] In combination with the second aspect, in certain implementations of the second aspect, the processing module is used to: obtain retrieval information, the retrieval information including the employee identification, the longitude and latitude information, the identification of the marketing activity, the affiliated organization, the administrative region and at least one of the time information; based on the retrieval information, display retrieval result data corresponding to the retrieval information on a map, and the detailed data and / or the first summary data stored in the distributed retrieval server include the retrieval result data.

[0014] In combination with the second aspect, in certain implementations of the second aspect, the processing module is used to: determine the organization to which the employee corresponding to the employee identification belongs or the organization corresponding to the longitude and latitude information as the organization to which the customer behavior in the customer behavior flow data corresponds; determine the administrative region corresponding to the longitude and latitude information as the administrative region corresponding to the customer behavior in the customer behavior flow data.

[0015] In combination with the second aspect, in certain implementations of the second aspect, the processing module is used to: summarize and count the detailed data according to the employee identification to obtain second summary data, wherein the second summary data includes the number of visits and visitors to the marketing activities of different employees; and store the second summary data in the distributed retrieval server.

[0016] In combination with the second aspect, in certain implementations of the second aspect, the above-mentioned affiliated institutions include a head office, a first-level branch, a second-level branch, a sub-branch and a business hall.

[0017] In combination with the second aspect, in certain implementations of the second aspect, the above-mentioned administrative regions include national-level administrative regions, provincial-level administrative regions, municipal-level administrative regions, and district-level administrative regions.

[0018] In a third aspect, a processor is provided, comprising: an input circuit, an output circuit and a processing circuit. The processing circuit is used to receive a signal through the input circuit and transmit a signal through the output circuit, so that the processor executes the method in any possible implementation of the first aspect.

[0019] In the specific implementation process, the processor can be a chip, the input circuit can be an input pin, the output circuit can be an output pin, and the processing circuit can be a transistor, a gate circuit, a trigger, and various logic circuits. The input signal received by the input circuit can be, for example, but not limited to, received and input by a receiver, and the signal output by the output circuit can be, for example, but not limited to, output to a transmitter and transmitted by the transmitter, and the input circuit and the output circuit can be the same circuit, which is used as an input circuit and an output circuit at different times. The embodiments of the present application do not limit the specific implementation methods of the processor and various circuits.

[0020] In a fourth aspect, a processing device is provided, comprising a processor and a memory. The processor is used to read instructions stored in the memory, and can receive signals through a receiver and transmit signals through a transmitter to execute the method in any possible implementation of the first aspect.

[0021] Optionally, there are one or more processors and one or more memories.

[0022] Optionally, the memory may be integrated with the processor, or the memory may be provided separately from the processor.

[0023] In the specific implementation process, the memory can be a non-transitory memory, such as a read-only memory (ROM), which can be integrated with the processor on the same chip or can be set on different chips respectively. The embodiments of the present application do not limit the type of memory and the setting method of the memory and the processor.

[0024] The processing device in the fourth aspect mentioned above can be a chip. The processor can be implemented by hardware or by software. When implemented by hardware, the processor can be a logic circuit, an integrated circuit, etc.; when implemented by software, the processor can be a general-purpose processor, which is implemented by reading the software code stored in the memory. The memory can be integrated in the processor or can be located outside the processor and exist independently.

[0025] In a fifth aspect, a computer program product is provided, which includes: a computer program (also referred to as code, or instruction), which, when executed, enables a computer to execute a method in any possible implementation of the first aspect.

[0026] In a sixth aspect, a computer-readable storage medium is provided, which stores a computer program (also referred to as code, or instructions) which, when executed on a computer, enables the computer to execute a method in any possible implementation of the first aspect. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0028] Figure 1 is a schematic flow chart of a method for data retrieval provided in an embodiment of the present application;

[0029] Figure 2 is a schematic diagram of a device for data retrieval provided in an embodiment of the present application;

[0030] Figure 3 It is a schematic diagram of another device for data retrieval provided in an embodiment of the present application. DETAILED DESCRIPTION

[0031] In the technical solution of this application, the collection, storage, use, processing, transmission, provision and disclosure of information such as financial data or user data involved shall comply with the provisions of relevant laws and regulations and shall not violate public order and good morals.

[0032] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments made by ordinary technicians in this field under the enlightenment of the embodiments belong to the scope of protection of the present application.

[0033] For ease of understanding, the relevant terms involved in this application are first explained.

[0034] 1. Flume: A tool / service that can collect data resources such as logs and events, and centrally store these huge amounts of data from various data resources.

[0035] 2. Highly scalable distributed full-text search engine (elastic search, ES): It has powerful syntax support for search and aggregation analysis, and can store and retrieve massive data in near real time.

[0036] The existing method of displaying customer data for marketing activities is to count customer data according to a certain caliber (such as the branch to which the customer belongs, and the branch where the account manager who markets the customer is located) and to aggregate the information in the form of statistical reports to the head office, first-tier branches, second-tier branches, sub-branches, and branches.

[0037] However, the above method can only form a simple data display effect. Through this display effect, the amount of data and the correlation between the data obtained by relevant personnel are very limited, the retrieval efficiency is low, and the user experience is not good.

[0038] In view of this, the present application provides a method and device for data retrieval, by obtaining customer behavior flow data, the customer behavior flow data including employee identification and longitude and latitude information, identifying the affiliated institution and administrative region corresponding to the customer behavior in the customer behavior flow data based on the above employee identification and the above longitude and latitude information, and obtaining detailed data, that is, associating the above customer behavior flow data with the region to obtain the customer behavior flow data associated with the region, and then summarizing and counting the above customer behavior flow data associated with the region, that is, the detailed data, according to the affiliated institution and administrative region, to obtain first summary data, the first summary data including the number of visits and visitors to marketing activities under the affiliated institutions and administrative regions of different levels, summarizing the above customer behavior flow data associated with the region according to the level of the region, such as the data corresponding to the municipal administrative region can be summarized into the data of the municipal administrative region, and the detailed data and the first summary data can be stored in the distributed retrieval server for access and call during retrieval, and the above data can be displayed in detail on the map, thereby improving the efficiency of data retrieval and thus improving the user experience. The data retrieval method and device of the present application combines data display with geographic location, which can intuitively reflect regional data differences and improve global data analysis capabilities. In addition, the data retrieval method and device of the present application can achieve real-time monitoring capabilities for the entire bank's data, allowing decision makers to quickly respond to market reactions and make adjustments, thereby improving the efficiency of digital operations.

[0039] Before introducing the method and device for data retrieval provided in the embodiments of the present application, the following points are explained.

[0040] First, in the embodiments shown below, each term and English abbreviation is provided for the convenience of description and shall not constitute any limitation to the present application. The present application does not exclude the possibility of defining other terms that can achieve the same or similar functions in existing or future protocols.

[0041] Second, in the embodiments shown below, the first, second and various numerical numbers are only used for the convenience of description and are not used to limit the scope of the embodiments of the present application.

[0042] Third, "at least one" means one or more, and "more than one" means two or more. "And / or" describes the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can mean: A exists alone, A and B exist at the same time, and B exists alone, where A and B can be singular or plural. The character " / " generally indicates that the associated objects before and after are in an "or" relationship. "At least one of the following items" or similar expressions refers to any combination of these items, including any combination of single items or plural items. For example, at least one of a, b and c can mean: a, or b, or c, or a and b, or a and c, or b and c, or a, b and c, where a, b, c can be single or multiple.

[0043] In order to make the purpose and technical solution of the present application clearer and more intuitive, the method and device for data retrieval provided by the present application will be described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0044] Figure 1 1 is a schematic flow chart of a method 100 for data retrieval provided in an embodiment of the present application. The method 100 can be executed by any device having a data processing function. For ease of description, the present embodiment of the present application refers to it as a data retrieval device. Figure 1 As shown, the method 100 may include the following steps:

[0045] S101. A data retrieval device obtains customer behavior flow data, where the customer behavior flow data includes employee identification and latitude and longitude information.

[0046] It should be understood that the above-mentioned customer behavior flow data may also include customer identification, marketing activity identification, customer behavior type and time information.

[0047] Exemplarily, the data retrieval device may acquire the above customer behavior flow data through Flume collection.

[0048] It should be understood that the employee identifier may be the employee's position number. The marketing campaign identifier may be the number of the marketing campaign. The customer behavior type may be represented by numbers, and different numbers represent different customer behavior types, such as "1" represents the customer behavior type of accessing a page, "2" represents the customer behavior type of viewing instructions, "3" represents the customer behavior type of signing up, and "4" represents the customer behavior type of identifying a QR code. The latitude and longitude information includes longitude and latitude, and the time information is the time corresponding to when the customer behavior occurs.

[0049] Table 1 shows the customer behavior flow data.

[0050] Table 1

[0051] Customer Logo ID01 Employee identification 23XXXX80 Marketing campaign logo Y1050XXXX1004 Customer behavior type 3 Latitude and longitude information Longitude: 1XX.0XXXX7, Latitude: 3X.6XXXX9 Time Information yyyy-MM-DD HH:mm:ss

[0052] As shown in Table 1, the user with user ID01 signed up for the marketing activity with the marketing activity ID Y1050XXXX1004 at longitude 1XX.0XXXX7 and latitude 3X.6XXXX9 on yyyy-MM-DD HH:mm:ss, and the employee ID of the employee who accepted the registration was 23XXXX80.

[0053] It should be understood that in addition to the customer behavior types shown above, in actual operation, the customer behavior types may also include product purchases or award collection, etc., which is not limited in this application.

[0054] S102. The data retrieval device identifies the organization and administrative region corresponding to the customer behavior in the customer behavior flow data based on the employee identification and the longitude and latitude information to obtain detailed data.

[0055] It should be understood that the above-mentioned affiliated institutions include the head office, first-level branches, second-level branches, sub-branches and business halls. The above-mentioned administrative regions include national administrative regions, provincial administrative regions, municipal administrative regions and district and county administrative regions.

[0056] In one possible implementation, the data retrieval device may determine the organization to which the employee corresponding to the above-mentioned employee identification belongs as the organization corresponding to the customer behavior in the customer behavior flow data, and may determine the administrative region corresponding to the above-mentioned longitude and latitude information as the administrative region corresponding to the customer behavior in the above-mentioned customer behavior flow data.

[0057] Table 2 shows the employee IDs provided in the embodiment of the present application and the organizations to which the employees corresponding to the employee IDs belong.

[0058] Table 2

[0059] Employee identification The organization to which the employee belongs 13XXXX72 A institution 23XXXX80 Institution B 33XXXX56 C institution

[0060] As shown in Table 2, the organization to which the employee with the employee ID 13XXXX72 belongs is Organization A, the organization to which the employee with the employee ID 23XXXX80 belongs is Organization B, and the organization to which the employee with the employee ID 33XXXX56 belongs is Organization C. The organization to which the employee belongs here can also be understood as the organization in which the employee corresponding to the above employee ID works.

[0061] For example, based on the customer behavior flow data shown in Table 1 above, the data retrieval device can refer to Table 2 above to determine that the employee with employee ID 23XXXX80 belongs to Organization B, and determine Organization B as the belonging organization corresponding to the registered customer behavior in the customer behavior flow data. The data retrieval device can locate according to the longitude 1XX.0XXXX7 and the latitude 3X.6XXXX9, determine that the longitude and latitude fall in the first area, and determine the administrative area where the first area is located as the administrative area where the registered customer behavior occurs, that is, the administrative area corresponding to the registered customer behavior.

[0062] In another possible implementation, the data retrieval device may determine the institution corresponding to the above-mentioned longitude and latitude information as the affiliation institution corresponding to the customer behavior in the customer behavior flow data, and may determine the administrative area corresponding to the above-mentioned longitude and latitude information as the administrative area corresponding to the customer behavior in the above-mentioned customer behavior flow data.

[0063] Table 3 shows the longitude and latitude information provided by the embodiment of the present application and the corresponding institutions of the longitude and latitude information.

[0064] Table 3

[0065]

[0066]

[0067] As shown in Table 3, the institution corresponding to the longitude and latitude information of longitude 1XX.0XXXX7 and latitude 3X.6XXXX9 is institution B, the institution corresponding to the longitude and latitude information of longitude 2XX.0XXXX7 and latitude 4X.6XXXX9 is institution C, and the institution corresponding to the longitude and latitude information of longitude 3XX.0XXXX7 and latitude 2X.6XXXX9 is institution E. The institution corresponding to the longitude and latitude information here can also be understood as the institution where the longitude and latitude information falls or is closest.

[0068] For example, based on the customer behavior flow data shown in Table 1 above, the data retrieval device can refer to Table 3 above to determine that the institution corresponding to the longitude and latitude information of longitude 1XX.0XXXX7 and latitude 3X.6XXXX9 is institution B, and determine institution B as the institution corresponding to the registered customer behavior in the customer behavior flow data. Similarly, the data retrieval device can also determine the administrative region where the longitude 1XX.0XXXX7 and latitude 3X.6XXXX9 are located as the administrative region where the registered customer behavior occurs, that is, the administrative region corresponding to the registered customer behavior.

[0069] In another possible implementation, the data retrieval device may determine the organization to which the employee corresponding to the above-mentioned employee identification belongs or the organization corresponding to the above-mentioned longitude and latitude information as the organization to which the customer behavior in the customer behavior flow data belongs, and may determine the administrative region corresponding to the organization to which the customer behavior belongs as the administrative region corresponding to the customer behavior in the above-mentioned customer behavior flow data.

[0070] Exemplarily, the data retrieval device can determine that the organization corresponding to the customer behavior in the customer behavior flow data is organization B based on the above Table 2 or Table 3. For specific details, please refer to the above embodiment. To avoid repetition, they will not be described here.

[0071] After obtaining the above-mentioned institution B, the data retrieval device can locate the institution B and determine the administrative region where the institution B is located, that is, determine the administrative region corresponding to the customer behavior in the above-mentioned customer behavior flow data.

[0072] S103. The data retrieval device summarizes and counts the detailed data according to the affiliation institutions and the administrative regions to obtain first summary data. The first summary data includes the number of visits and the number of visitors of the marketing activities under the affiliation institutions and administrative regions at different levels.

[0073] Table 4 shows the first summary data provided by the embodiment of the present application.

[0074] Table 4

[0075]

[0076]

[0077] As shown in Table 4, the number of visits and visitors to the B institution in the provincial administrative region for the above marketing activities were 100 and 85 respectively, the number of visits and visitors to the A institution in the municipal administrative region for the above marketing activities were 98 and 90 respectively, the number of visits and visitors to the D institution in the district and county administrative region were 76 and 55 respectively, and the number of visits and visitors to the E institution in the district and county administrative region were 34 and 11 respectively.

[0078] It should be understood that the number of visits and the number of visitors of the above-mentioned marketing activities are obtained by the data retrieval device by counting the above-mentioned customer behavior types.

[0079] S104: The data retrieval device stores the detailed data and the first summary data in a distributed retrieval server.

[0080] Exemplarily, the above-mentioned distributed search server may be a highly scalable distributed full-text search engine ES.

[0081] Optionally, the data retrieval device can also summarize and count the above detailed data according to employee identification to obtain second summary data, which includes the number of visits and visitors to marketing activities of different employees, and can store the second summary data in the above distributed retrieval server.

[0082] Table 5 shows the second summary data provided by the embodiment of the present application.

[0083] Table 5

[0084]

[0085]

[0086] As shown in Table 5, in the B institution at the provincial administrative region, the employee with the employee identification of 23XXXX80 handled the above-mentioned marketing activities, and the number of visits and visitors to the marketing activities were 100 and 85 respectively, in the A institution at the municipal administrative region, the employee with the employee identification of 13XXXX72 handled the above-mentioned marketing activities, and the number of visits and visitors to the marketing activities were 98 and 90 respectively, in the D institution at the district and county administrative region, the employee with the employee identification of 43XXXX80 handled the above-mentioned marketing activities, and the number of visits and visitors to the marketing activities were 76 and 55 respectively, and in the E institution at the district and county administrative region, the employee with the employee identification of 53XXXX80 handled the above-mentioned marketing activities, and the number of visits and visitors to the marketing activities were 34 and 11 respectively.

[0087] It should be understood that the above method for data retrieval is described above only by taking one marketing campaign as an example. In actual operation, one administrative district, one affiliated organization or one employee may correspond to one marketing campaign or may correspond to multiple marketing campaigns.

[0088] In an embodiment of the present application, the data retrieval device obtains customer behavior flow data, which includes employee identification and longitude and latitude information, and identifies the affiliated institution and administrative region corresponding to the customer behavior in the customer behavior flow data based on the employee identification and the longitude and latitude information to obtain detailed data, that is, to associate the customer behavior flow data with the region to obtain the customer behavior flow data associated with the region, and then summarize and count the customer behavior flow data associated with the region, that is, the detailed data, according to the affiliated institution and the administrative region, to obtain the first summary data, which includes the visits and the number of visitors to the marketing activities under the affiliated institutions and administrative regions of different levels. In other words, the customer behavior flow data associated with the region is summarized according to the level of the region, such as the data corresponding to the municipal administrative region can be summarized into the data of the provincial administrative region, and the detailed data and the first summary data can be stored in the distributed retrieval server for access and call during retrieval, and the data of the above regional level is displayed in detail on the map, which improves the efficiency of data retrieval and thus improves the user experience. The data retrieval method and device of the present application combines data display with geographic location, which can intuitively reflect regional data differences and improve global data analysis capabilities. In addition, the data retrieval method and device of the present application can achieve real-time monitoring capabilities for the entire bank's data, allowing decision makers to quickly respond to market reactions and make adjustments, thereby improving the efficiency of digital operations.

[0089] Optionally, after storing the above-mentioned detailed data, first summary data and second summary data in the above-mentioned distributed retrieval server, the data retrieval device can display the above-mentioned detailed data, first summary data and second summary data stored in the distributed retrieval server on a map based on the operations of relevant personnel.

[0090] It should be understood that the above map may be a map corresponding to any map application on the retrieval device.

[0091] In one possible implementation, relevant personnel can input the target data type (also referred to as retrieval information) they want to obtain in the above-mentioned data search device, and the data retrieval device can use the input content to display the data corresponding to the target data type (also referred to as retrieval result data) in the above-mentioned distributed retrieval server on a map.

[0092] Exemplarily, when the relevant person inputs an identifier of a marketing campaign, the data retrieval device may access the distributed retrieval server and display the number of visits and the number of visitors of the marketing campaign corresponding to the identifier of the marketing campaign on a map.

[0093] In another possible implementation, relevant personnel can click on any area of ​​the map, and the data retrieval device can detect the above-mentioned click operation, obtain the information of the clicked area, such as longitude and latitude information, administrative area, etc. (that is, the above-mentioned retrieval information), and access the above-mentioned distributed retrieval server based on the information of the clicked area, and display the relevant data of the area corresponding to the above-mentioned click operation on the map (also known as retrieval result data).

[0094] For example, when the relevant personnel clicks on the city-level administrative region in the map, the data retrieval device can access the distributed retrieval server and display the data corresponding to the city-level administrative region on the map. Alternatively, when the relevant personnel zoom in or out on the city-level administrative region on the map, the data retrieval device can display the data corresponding to the district-level administrative region under the city-level administrative region or the provincial-level administrative region above the city-level administrative region in the distributed retrieval server on the map.

[0095] Optionally, when the data retrieval device has not retrieved any data, the data retrieval device may display a certain type of data on its map.

[0096] For example, the data retrieval device may display an employee ID on its map, and the employee corresponding to the employee ID may be the employee with the most visits and visitors to the marketing activities in the above-mentioned distributed retrieval server.

[0097] It should be understood that the data displayed on the above map can be in the form of charts or text, etc., and this application does not limit this.

[0098] Optionally, the data retrieval device may also display the retrieved data in split screen.

[0099] For example, if relevant personnel want to obtain and compare the number of visits to two marketing campaigns, the data retrieval device can access the distributed retrieval server and display the number of visits to the two different marketing campaigns on two maps, respectively, visually showing the difference in the number of visits to the two marketing campaigns.

[0100] It should be understood that the data retrieval device provided in the present application may be a terminal device with an image display function, such as a mobile phone, a tablet (PAD) or a personal computer (PC), etc., and the present application does not limit this.

[0101] In an embodiment of the present application, the data retrieval device can display the data stored in the distributed retrieval server on a map, which can intuitively reflect regional data differences and enhance global data analysis capabilities.

[0102] It should be understood that the sequence numbers of the above processes do not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0103] In order to realize the functions of the method provided in the above embodiment of the present application, the data retrieval device may include a hardware structure and / or a software module, and realize the above functions in the form of a hardware structure, a software module, or a hardware structure plus a software module. Whether one of the above functions is executed in the form of a hardware structure, a software module, or a hardware structure plus a software module depends on the specific application and design constraints of the technical solution.

[0104] Combined with the above Figure 1 , describes in detail the method for data retrieval provided in the embodiment of the present application, and will be combined with Figure 2 and Figure 3 , a device for data retrieval provided in an embodiment of the present application is described in detail.

[0105] Figure 2 An apparatus 200 for data retrieval provided in an embodiment of the present application is shown, comprising: an acquisition module 201 and a processing module 202 .

[0106] Among them, the acquisition module 201 is used to: obtain customer behavior flow data, the above customer behavior flow data includes employee identification and longitude and latitude information; the processing module 202 is used to: based on the above employee identification and the above longitude and latitude information, identify the affiliated organization and administrative region corresponding to the customer behavior in the above customer behavior flow data to obtain detailed data; according to the above affiliated organization and the above administrative region, summarize and count the above detailed data to obtain first summary data, the above first summary data includes the number of visits and visitors to marketing activities under different levels of affiliated organizations and administrative regions; and, store the above detailed data and the above first summary data to a distributed retrieval server.

[0107] Optionally, the processing module 202 is used to: obtain retrieval information, the retrieval information including the above-mentioned employee identification, the above-mentioned longitude and latitude information, the identification of the marketing activity, the above-mentioned affiliated organization, the above-mentioned administrative region and at least one of the time information; based on the above-mentioned retrieval information, display the retrieval result data corresponding to the above-mentioned retrieval information on the map, and the above-mentioned detailed data and / or the above-mentioned first summary data stored in the above-mentioned distributed retrieval server include the retrieval result data.

[0108] Optionally, the processing module 202 is used to: determine the organization to which the employee corresponding to the above-mentioned employee identification belongs or the organization corresponding to the above-mentioned longitude and latitude information as the organization corresponding to the customer behavior in the above-mentioned customer behavior flow data; determine the administrative region corresponding to the above-mentioned longitude and latitude information as the administrative region corresponding to the customer behavior in the above-mentioned customer behavior flow data.

[0109] Optionally, the processing module 202 is used to: summarize and count the detailed data according to the employee identification to obtain second summary data, wherein the second summary data includes the number of visits and the number of visitors of marketing activities of different employees; and store the second summary data in the distributed retrieval server.

[0110] Optionally, the above-mentioned affiliated institutions include the head office, first-level branches, second-level branches, sub-branches and business offices.

[0111] Optionally, the above-mentioned administrative regions include national-level administrative regions, provincial-level administrative regions, municipal-level administrative regions, and district-level administrative regions.

[0112] It should be understood that the device 200 here is embodied in the form of a functional module. The term "module" here may refer to an application specific integrated circuit (ASIC), an electronic circuit, a processor (such as a shared processor, a proprietary processor or a group processor, etc.) and a memory for executing one or more software or firmware programs, a merged logic circuit and / or other suitable components that support the described functions. In an optional example, those skilled in the art may understand that the device 200 may be specifically a data retrieval device in the above-mentioned embodiment, or the function of the data retrieval device in the above-mentioned embodiment may be integrated in the device 200, and the device 200 may be used to execute the various processes and / or steps corresponding to the data retrieval device in the above-mentioned method embodiment, and to avoid repetition, it will not be repeated here. The above-mentioned device 200 has the function of implementing the corresponding steps executed by the data retrieval device in the above-mentioned method; the above-mentioned function may be implemented by hardware, or the corresponding software may be implemented by hardware. The hardware or software includes one or more modules corresponding to the above-mentioned functions.

[0113] In the embodiments of the present application, Figure 2 The device 200 may also be a chip or a chip system, such as a system on chip (SoC).

[0114] Figure 3Another device 300 for data retrieval provided by an embodiment of the present application is shown. The device 300 includes: a processor 301, a memory 302, a communication interface 303 and a bus 304. The memory 302 is used to store instructions, and the processor 301 is used to execute the instructions stored in the memory 302. The processor 301, the memory 302 and the communication interface 303 are connected to each other through the bus 304.

[0115] Among them, the processor 301 is used to: obtain customer behavior flow data, the above customer behavior flow data includes employee identification and longitude and latitude information; based on the above employee identification and the above longitude and latitude information, identify the affiliated organization and administrative region corresponding to the customer behavior in the above customer behavior flow data to obtain detailed data; according to the above affiliated organization and the above administrative region, summarize and count the above detailed data to obtain first summary data, the above first summary data includes the number of visits and visitors to marketing activities under different levels of affiliated organizations and administrative regions; and, store the above detailed data and the above first summary data to a distributed retrieval server.

[0116] Optionally, the processor 301 is used to: obtain retrieval information, the retrieval information including the above-mentioned employee identification, the above-mentioned longitude and latitude information, the identification of the marketing activity, the above-mentioned affiliated organization, the above-mentioned administrative region and at least one of the time information; based on the above-mentioned retrieval information, display the retrieval result data corresponding to the above-mentioned retrieval information on the map, and the above-mentioned detailed data and / or the above-mentioned first summary data stored in the above-mentioned distributed retrieval server include the retrieval result data.

[0117] Optionally, the processor 301 is used to: determine the organization to which the employee corresponding to the above-mentioned employee identification belongs or the organization corresponding to the above-mentioned longitude and latitude information as the organization corresponding to the customer behavior in the above-mentioned customer behavior flow data; determine the administrative area corresponding to the above-mentioned longitude and latitude information as the administrative area corresponding to the customer behavior in the above-mentioned customer behavior flow data.

[0118] Optionally, the processor 301 is used to: summarize and count the above detailed data according to the above employee identification to obtain second summary data, the above second summary data including the number of visits and visitors of marketing activities of different employees; store the above second summary data to the above distributed retrieval server.

[0119] Optionally, the above-mentioned affiliated institutions include the head office, first-level branches, second-level branches, sub-branches and business offices.

[0120] Optionally, the above-mentioned administrative regions include national-level administrative regions, provincial-level administrative regions, municipal-level administrative regions, and district-level administrative regions.

[0121] It should be understood that the device 300 can be specifically a data retrieval device in the above-mentioned embodiment, or the function of the data retrieval device in the above-mentioned embodiment can be integrated in the device 300, and the device 300 can be used to execute the various steps and / or processes corresponding to the data retrieval device in the above-mentioned method embodiment. Optionally, the memory 303 can include a read-only memory and a random access memory, and provide instructions and data to the processor. A part of the memory can also include a non-volatile random access memory. For example, the memory can also store information about the type of device. The processor 301 can be used to execute the instructions stored in the memory, and when the processor executes the instruction, the processor can execute the various steps and / or processes corresponding to the data retrieval device in the above-mentioned method embodiment.

[0122] It should be understood that in the embodiments of the present application, 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. A general-purpose processor may be a microprocessor or the processor may be any conventional processor, etc.

[0123] In the implementation process, each step of the above method can be completed by an integrated logic circuit of hardware in a processor or an instruction in the form of software. The steps of the method disclosed in conjunction with the embodiment of the present application can be directly embodied as a hardware processor for execution, or a combination of hardware and software modules in a processor for execution. The software module can be located in a storage medium mature in the art such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory or an electrically erasable programmable memory, a register, etc. The storage medium is located in a memory, and the processor executes the instructions in the memory, and completes the steps of the above method in conjunction with its hardware. To avoid repetition, it is not described in detail here.

[0124] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0125] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0126] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0127] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0128] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0129] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application can be essentially or partly embodied in the form of a software product that contributes to the prior art. The computer software product is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the various embodiments of the present application. The aforementioned storage media include: various media that can store program codes, such as USB flash drives, mobile hard disks, read-only memories (ROM), random access memories (RAM), magnetic disks or optical disks.

[0130] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

Claims

1. A method for data retrieval, It is characterized in that include: Acquire customer behavior flow data, wherein the customer behavior flow data includes employee identification and latitude and longitude information; Based on the employee identification and the longitude and latitude information, identifying the organization and administrative region corresponding to the customer behavior in the customer behavior flow data, and obtaining detailed data; The detailed data are summarized and counted according to the affiliated institutions and the administrative regions, and the detailed data are summarized and counted according to the employee identifiers to obtain first summary data, wherein the first summary data includes the number of visits and the number of visitors of marketing activities under the affiliated institutions at different levels and the administrative regions at different levels, and the number of visits and the number of visitors of marketing activities of different employees; storing the detailed data and the first summary data in a distributed retrieval server; The step of identifying the organization and administrative region corresponding to the customer behavior in the customer behavior flow data based on the employee identification and the latitude and longitude information includes: Determine the organization to which the employee corresponding to the employee identifier belongs or the organization corresponding to the longitude and latitude information as the organization to which the customer behavior in the customer behavior flow data belongs; The administrative area corresponding to the longitude and latitude information is determined as the administrative area corresponding to the customer behavior in the customer behavior flow data.

2. The method according to claim 1, It is characterized in that The method further comprises: Acquire search information, the search information including at least one of the employee identification, the latitude and longitude information, the identification of the marketing activity, the affiliated organization, the administrative region and time information; Based on the search information, search result data corresponding to the search information is displayed on a map, and the detailed data and / or the first summary data stored in the distributed search server include the search result data.

3. The method according to claim 1, It is characterized in that The affiliated institutions include the head office, first-level branches, second-level branches, sub-branches and business offices.

4. The method according to any one of claims 1 to 3, It is characterized in that The administrative regions include national-level administrative regions, provincial-level administrative regions, municipal-level administrative regions, and district-level administrative regions.

5. A device for data retrieval, It is characterized in that include: An acquisition module, used to acquire customer behavior flow data, wherein the customer behavior flow data includes employee identification and latitude and longitude information; A processing module is used to identify the affiliated institution and administrative region corresponding to the customer behavior in the customer behavior flow data based on the employee identification and the latitude and longitude information to obtain detailed data; summarize and count the detailed data according to the affiliated institution and the administrative region, and summarize and count the detailed data according to the employee identification to obtain first summary data, wherein the first summary data includes the number of visits and the number of visitors of marketing activities under the affiliated institutions of different levels and the administrative regions of different levels and the number of visits and the number of visitors of marketing activities of different employees; and store the detailed data and the first summary data to a distributed retrieval server; The processing module is specifically used to: determine the organization to which the employee corresponding to the employee identification belongs or the organization corresponding to the longitude and latitude information as the organization to which the customer behavior in the customer behavior flow data belongs; The administrative area corresponding to the longitude and latitude information is determined as the administrative area corresponding to the customer behavior in the customer behavior flow data.

6. The device according to claim 5, It is characterized in that The processing module is used for: Acquire search information, the search information including at least one of the employee identification, the latitude and longitude information, the identification of the marketing activity, the affiliated organization, the administrative region and time information; Based on the search information, search result data corresponding to the search information is displayed on a map, and the detailed data and / or the first summary data stored in the distributed search server include the search result data.

7. The device according to claim 5, It is characterized in that The affiliated institutions include the head office, first-level branches, second-level branches, sub-branches and business offices.

8. The device according to any one of claims 5 to 7, It is characterized in that The administrative regions include national-level administrative regions, provincial-level administrative regions, municipal-level administrative regions, and district-level administrative regions.

9. A device for data retrieval, It is characterized in that include: A processor is coupled to a memory, the memory is used to store a computer program, and when the processor calls the computer program, the device executes the method for data retrieval according to any one of claims 1 to 4.

10. A computer-readable storage medium, It is characterized in that Used to store a computer program, the computer program comprising instructions for implementing the method for data retrieval according to any one of claims 1 to 4.

11. A computer program product, It is characterized in that The invention comprises a computer program, which implements the method for data retrieval according to any one of claims 1 to 4 when being executed by a processor.

Citation Information

Patent Citations

  • Search data processing method and apparatus

    CN106126592A

  • Page-turning data query method and device under cross-region multi-activity micro-service architecture

    CN111460240A

  • Geographic position searching method and device, electronic equipment and storage medium

    CN113139032A

  • Energy enterprise information processing method and device, computer equipment and medium

    CN113268639A

  • System and method of geographic data aggregation and analysis

    US20210149930A1