A data query method, apparatus, device, and storage medium

By generating a target industry mapping table, the problem of low query efficiency caused by large amounts of data in existing technologies is solved, achieving efficient querying and optimization of computing resources, thus improving the user experience for business personnel.

CN116662624BActive Publication Date: 2026-11-17BEIJING BAIDU NETCOM SCI & TECH CO LTD
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202310558822.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-05-17
Publication Date
2026-11-17
Estimated Expiration
2043-05-17

AI Technical Summary

Technical Problem

Existing technologies suffer from low query efficiency, prolonged response time, wasted computing resources, and poor user experience when querying traffic data for industry categories due to the massive amount of data.

Method used

By pre-processing the original mapping table with roll-up to generate the target industry mapping table, the data of the industry to be queried can be obtained directly from the target industry mapping table, avoiding roll-up processing during the query process.

Benefits of technology

It improved data query efficiency, reduced response time, enhanced the user experience, and avoided wasting computing resources.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116662624B_ABST
    Figure CN116662624B_ABST
Patent Text Reader

Abstract

This disclosure provides a data query method, apparatus, device, and storage medium, relating to the field of computer technology, and particularly to the field of data query technology. The specific implementation involves: receiving a data query request from a terminal; retrieving industry data for the industry to be queried from a target industry mapping table based on industry keywords carried in the query request; and sending the industry data to the terminal. This method not only effectively improves data query efficiency but also effectively avoids wasting computing resources.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This disclosure relates to the field of computer technology, and more particularly to the field of data query technology, specifically to a data query method, apparatus, device, and storage medium. Background Technology

[0002] Currently, to understand the business situation of different industry categories, business personnel can query industry data corresponding to those categories from the database. This allows them to perform subsequent business analysis, adjustments, or processing for each industry. Summary of the Invention

[0003] This disclosure provides a data query method, apparatus, device, and storage medium.

[0004] According to a first aspect of this disclosure, a data query method is provided, comprising:

[0005] Receives a data query request from the terminal; the data query request carries industry keywords; the industry keywords include the industry category of the industry to be queried;

[0006] Based on industry keywords, industry data for the industry to be queried is obtained from the target industry mapping table. The target industry mapping table is obtained by pre-rolling up the first and second original mapping tables. The first original mapping table includes multiple original mapping relationships, including the mapping relationship between search terms and the first category. The first category is the industry category to which the industry corresponding to the search term belongs. The second original mapping table includes the mapping relationship between search terms and industry data. The target industry mapping table includes the mapping relationship between industry categories and industry data.

[0007] Send industry data for the industry to be queried to the terminal.

[0008] According to a second aspect of this disclosure, a data query apparatus is provided, comprising:

[0009] The receiving module is used to receive data query requests from the terminal; the data query request carries industry keywords; the industry keywords include the industry category of the industry to be queried;

[0010] The acquisition module is used to retrieve industry data for the industry to be queried from the target industry mapping table based on industry keywords. The target industry mapping table is obtained by pre-rolling up the first and second original mapping tables. The first original mapping table includes multiple original mapping relationships, including the mapping relationship between search terms and the first category, where the first category is the industry category to which the industry corresponding to the search term belongs. The second original mapping table includes the mapping relationship between search terms and industry data. The target industry mapping table includes the mapping relationship between industry categories and industry data.

[0011] The sending module is used to send industry data of the industry to be queried to the terminal.

[0012] According to a third aspect of this disclosure, an electronic device is provided, comprising:

[0013] At least one processor; and

[0014] The memory is communicatively connected to the at least one processor; wherein,

[0015] The memory stores instructions that can be executed by at least one processor, such that the at least one processor is able to perform any of the methods in the first aspect.

[0016] According to a fourth aspect of this disclosure, a non-transitory computer-readable storage medium is provided storing computer instructions, wherein the computer instructions are used to cause a computer to perform any of the methods in the first aspect.

[0017] According to a fifth aspect of this disclosure, a computer program product is provided, comprising a computer program that, when executed by a processor, implements any of the methods in the first aspect.

[0018] It should be understood that the description in this section is not intended to identify key or essential features of the embodiments of this disclosure, nor is it intended to limit the scope of this disclosure. Other features of this disclosure will become readily apparent from the following description. Attached Figure Description

[0019] The accompanying drawings are provided to better understand this solution and do not constitute a limitation of this disclosure. Wherein:

[0020] Figure 1 This is a diagram illustrating the data query process for traffic data in a related art, as shown in an embodiment of this disclosure;

[0021] Figure 2 This is an application scenario diagram illustrating a data query method according to an embodiment of this disclosure;

[0022] Figure 3 This is an interactive flowchart illustrating a data query method according to an embodiment of this disclosure;

[0023] Figure 4 This is a terminal interface diagram shown in an embodiment of the present disclosure;

[0024] Figure 5 This is a terminal interface diagram shown in an embodiment of the present disclosure;

[0025] Figure 6 This is an example diagram of a target industry mapping table shown in an embodiment of this disclosure;

[0026] Figure 7 This is a flowchart illustrating a method for determining a target industry mapping table according to an embodiment of the present disclosure;

[0027] Figure 8 This is a schematic diagram illustrating a process for determining a second industry mapping table according to an embodiment of this disclosure;

[0028] Figure 9 This is a schematic diagram illustrating another process for determining a second industry mapping table, as shown in an embodiment of this disclosure.

[0029] Figure 10 This is a flowchart illustrating another method for determining a target industry mapping table according to an embodiment of this disclosure;

[0030] Figure 11 This is a flowchart illustrating a data query method according to an embodiment of this disclosure;

[0031] Figure 12 This is a structural block diagram of a data query device shown in an embodiment of the present disclosure;

[0032] Figure 13 This is a block diagram of an electronic device illustrated in an embodiment of this disclosure. Detailed Implementation

[0033] The exemplary embodiments of this disclosure are described below with reference to the accompanying drawings, including various details of the embodiments to aid understanding, and should be considered merely exemplary. Therefore, those skilled in the art will recognize that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of this disclosure. Similarly, for clarity and brevity, descriptions of well-known functions and structures are omitted in the following description.

[0034] The collection, storage, use, processing, transmission, provision, and disclosure of user personal information involved in the technical solution disclosed herein comply with the provisions of relevant laws and regulations and do not violate public order and good morals.

[0035] First, the application scenarios involved in the embodiments of this disclosure are described. The data query method provided in the embodiments of this disclosure can be applied to industry data query scenarios, specifically to traffic data query scenarios. In the embodiments of this disclosure, traffic data can be used to characterize users' attention to the corresponding industry.

[0036] In some embodiments, the data query method provided in this disclosure can be applied to traffic insight projects. A traffic insight project refers to a project where business personnel query traffic data for any industry. The traffic data for any industry can characterize user attention to that industry. Therefore, business personnel can intuitively and clearly understand people's attention to that industry through the queried traffic data, thereby enabling them to conduct subsequent business analysis, adjustments, or processing within that industry.

[0037] It should be noted that industries can be categorized into four levels—Level 1, Level 2, Level 3, and above—based on their business scope. Taking a four-level system as an example, Level 1 industries cover the broadest range of business activities, while Level 4 industries cover the narrowest. Furthermore, industries within the same level can be divided into different categories based on their business attributes. For instance, Level 1 industries can be divided into two categories: "Computer" and "Pharmaceuticals."

[0038] In some embodiments, traffic data may be determined based on the number of times a user searches for industry-related search terms. It should be understood that traffic data for any industry will increase as the number of times a user searches for industry-related search terms increases. Specifically, when a user uses industry-related search terms in a browser or application to look up information related to that industry, the traffic data for that industry will increase accordingly.

[0039] Accordingly, the business unit can analyze user search activity to generate source data, such as the first source data, which includes search terms, geographic information (province, city), and traffic data; and source data, such as the second source data, which includes search terms and industry categories. The industry categories are determined based on the industries involved in the search terms. Then, the first and second source data are correlated according to the search terms to obtain target source data, which includes geographic information (province, city), traffic data, and industry categories. This target source data is then stored in the data terminal.

[0040] For business personnel across various industries, it's typically necessary to determine the traffic data for different industry categories within different industry tiers (Level 1, Level 2, Level 3, or Level 4) or different industry categories within different geographical tiers (National, Provincial, or City) from the target source data stored on the business side's data platform. It's important to note that when a search term involves two or more industries, the traffic data for any industry category within any higher industry tier cannot be obtained simply by adding the traffic data for industry categories included in the next lower industry tier.

[0041] For example, suppose the search term Q with a traffic data of 10 corresponds to two industries, and these two industries belong to industry category D and industry category E under the fourth-level industry classification, respectively. Both D and E belong to industry category C under the third-level industry classification. Therefore, the search term Q can correspond to two sets of industry correspondences: A <- B <- C <- D and A <- B <- C <- E, where A is the industry category of the first-level industry to which D and E belong, and B is the industry category of the second-level industry to which D and E belong. When determining the traffic data of the search term Q in each industry, the traffic data of the industries corresponding to industry category D and industry category E under the fourth-level industry classification can be directly set to 10. However, the traffic data of the search term Q in industry category C under the third-level industry classification cannot be obtained simply by adding the traffic data of industry category D and industry category E (i.e., the traffic data of industry category C under the third-level industry classification is not 10 + 10). Instead, it must undergo deduplication processing to determine the traffic data of the search term Q in industry category C under the third-level industry classification.

[0042] Therefore, in related technologies, when a business user intends to query traffic data corresponding to a specific industry category within a fourth-level industry, it can directly obtain the data from the target source. However, when a business user intends to query traffic data corresponding to a specific industry category within a higher industry level (e.g., a first-level or second-level industry), a series of deduplication and aggregation operations need to be performed on the business side to obtain the total traffic data corresponding to that industry. For example, assuming a business user intends to find traffic data corresponding to a specific industry category under a first-level industry, the specific operation process is as follows: Figure 1As shown: Business personnel can input industry keywords in business terminal 101. After receiving the industry keywords, business terminal 101 can obtain the industry categories and corresponding traffic data that match the industry keywords from data terminal 102. After obtaining the industry categories and corresponding traffic data that match the industry keywords, business terminal 101 can perform roll-up processing (including data deduplication and aggregation) on the traffic data corresponding to the obtained industry categories to obtain the total traffic data corresponding to the industry category. The total traffic data corresponding to the industry category is the traffic data corresponding to the industry category. Business personnel can perform subsequent analysis and processing based on this total traffic data.

[0043] However, the aforementioned related technologies have the following drawbacks:

[0044] (1) When storing industry categories and corresponding traffic data for various industries of the business party, all industry categories and corresponding traffic data are stored directly, resulting in a huge amount of data stored on the data end. Subsequently, when querying the corresponding industry category and traffic data on this data end using industry keywords, due to the huge amount of data stored on the data end, a large amount of data needs to be scanned, resulting in slow query efficiency. For example, suppose that when querying the traffic data of a certain industry category under the national first-level industry in the database using industry keywords, assuming that the industry category includes 200 second-level industry categories, and each second-level industry category includes 200 third-level industry categories, and the country includes about 300 prefecture-level cities, then the query would need to scan about 200*200*300=12 million rows of data, which is too slow.

[0045] (2) When performing data queries, the business side needs to perform roll-up processing on the traffic data corresponding to the obtained industry categories, which increases the processing content of the business side and prolongs the response time. This not only further reduces query efficiency but also reduces the user experience for business personnel. For example, suppose that when querying the traffic data of industry category T1 under the first-level industry of a certain city on a certain day, it is necessary to first query multiple rows of data records of industry category T1 in all first-level industries of that city on that day, then load the multiple rows of data records into memory, and perform deduplication according to (search term, first-level industry). That is, at least two data records with the same search term and first-level industry category are deduplicated to obtain the deduplicated data records. The traffic data included in the deduplicated data records also need to be summed to obtain the traffic data of industry category T1 under the first-level industry of that city on that day. Complex logic processing increases the response time of the business side, and when data of the same granularity is queried frequently, the above steps need to be repeated each time to obtain the corresponding traffic data, thus wasting computing resources.

[0046] Based on this, this disclosure provides a data query method. Upon receiving a data query request from a terminal, the method can retrieve industry data for the industry to be queried from a target industry mapping table based on the industry category of the industry to be queried included in the industry keywords carried in the data query request. Since the target industry mapping table is obtained by pre-rolling up the first and second original mapping tables, the industry data for the industry to be queried can be directly retrieved from the target industry mapping table obtained after the roll-up process during data querying, without needing to perform roll-up processing on the data during the query process. Therefore, this not only effectively improves data query efficiency and reduces data query response time, thereby improving the user experience, but also effectively avoids wasting computing resources. Furthermore, during data storage, only the target industry mapping table obtained after the roll-up process needs to be stored, without needing to store the large amounts of data in the first and second original mapping tables. Therefore, this effectively reduces data redundancy and further improves data query efficiency.

[0047] Figure 2 This is an application scenario diagram illustrating a data query method according to an embodiment of this disclosure. For example... Figure 2 As shown, this application scenario may include a terminal 201 and a server 202.

[0048] In this embodiment, terminal 201 can be a business terminal used to provide data query functions for business personnel. In one embodiment, terminal 201 can be a terminal including a display, such as at least one of devices including smartphones, smartwatches, desktop computers, laptops, virtual reality terminals, augmented reality terminals, wireless terminals, and laptop computers. In one embodiment, terminal 201 has communication functions and can access wired or wireless networks. Terminal 201 can refer to one of multiple terminals; this disclosure uses terminal 201 as an example only. Those skilled in the art will understand that the number of terminals can be more or less.

[0049] In this embodiment, terminal 201 is used to respond to a business user's query operation for industry query information by generating a data query request carrying industry keywords based on the industry query information. The industry query information refers to the information entered by the business user. The industry keywords are generated based on the industry query information entered by the business user. After generating the data query request, terminal 201 can send the data query request to server 202 to trigger server 202 to execute the subsequent data query process. Then, in response to server 202, it returns industry data for the queried industry and displays the industry data for the business user to view.

[0050] Server 202 can be a data endpoint used to store the target industry mapping table and retrieve industry data for the industry to be queried from the target industry mapping table. The target industry mapping table is obtained by pre-rolling up a first original mapping table and a second original mapping table. The first original mapping table includes multiple original mapping relationships; these relationships include the mapping between search terms and a first category; the first category is the industry category to which the search term belongs. The second original mapping table includes the mapping between search terms and industry data; the target industry mapping table includes the mapping between industry categories and industry data.

[0051] In some embodiments, server 202 is an independent physical server, a server cluster consisting of multiple physical servers, a distributed file system, or at least one of the following cloud servers providing basic cloud computing services: cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, content delivery networks, and big data or artificial intelligence platforms. This disclosure does not limit the specific implementation. In some embodiments, the number of servers 202 may be more or fewer, and this disclosure does not limit the specific implementation. Of course, server 202 may also include other functions to provide more comprehensive and diversified services.

[0052] In this embodiment of the disclosure, server 202 is used to receive a data query request from terminal 201, obtain industry data of the industry to be queried from the target industry mapping table according to the industry keywords carried in the data query request, and send the industry data of the industry to be queried to terminal 201.

[0053] In some embodiments, the display of terminal 201 receives industry query information input by a business user and, in response to the user's query operation, generates industry keywords including the industry query information to generate a data query request carrying those industry keywords. This data query request is then sent to server 202. Upon receiving the data query request, server 202 can retrieve the corresponding industry data from a target industry mapping table based on the industry category of the industry to be queried included in the industry keywords carried in the data query request, and send the industry data to terminal 201. After receiving the industry data, terminal 201 can display it on its display for the business user to view.

[0054] The following is based on Figure 2 The application scenarios shown illustrate the data query method provided in this disclosure.

[0055] Figure 3 An interactive flowchart of a data query method provided in an embodiment of this disclosure is illustrated as an example. Figure 3 As shown, the method includes:

[0056] S301, in response to a query operation for industry query information, the terminal sends a data query request to the server.

[0057] The data query request is used to request industry data that matches industry keywords. In some embodiments, the data query request carries industry keywords. The industry keywords include the industry category of the industry to be queried.

[0058] In this embodiment, industry keywords are generated based on industry query information; that is, industry keywords include industry query information. In some embodiments, industry keywords can be directly generated based on the content of the industry query information. It should be understood that in this embodiment, the content of the industry query information includes at least one of industry category, industry level, geographic information, and time information. In other embodiments, industry keywords can be generated based on the content of the industry query information and the information category corresponding to that industry query information. It should be understood that in this embodiment, the content of the industry query information includes at least one of industry category, geographic information, and time information.

[0059] In this embodiment of the disclosure, the number of industry levels can be one or more. For example, with four levels, the industry levels can include first-level, second-level, third-level, and fourth-level industries. Similarly, with five levels, the industry levels can include first-level, second-level, third-level, fourth-level, and fifth-level industries. This embodiment of the disclosure does not limit the number of industry levels; the following description uses a four-level industry level as an example.

[0060] In this embodiment of the disclosure, the geographical information may include one or more of the following: province information, city information, township information, and region information. This embodiment of the disclosure does not limit the geographical information.

[0061] In this embodiment of the disclosure, the time information may include one or more of year information, month information, and date information. This embodiment of the disclosure does not limit the time information.

[0062] In this embodiment of the disclosure, any industry level may include one or more industry categories. Taking the industry categories under a first-level industry as an example, they may include multiple industry categories such as computer, pharmaceutical, energy, and media. Taking the industry categories under a second-level industry as an example, they may include multiple industry categories such as computer sales, pharmaceutical sales, and pharmaceutical manufacturing. This embodiment of the disclosure does not limit the number of industry categories under any industry level.

[0063] In one alternative implementation, business personnel can input industry query information on the terminal and perform a query operation based on that information. In response to the business personnel's query operation, the terminal generates a data query request carrying industry keywords and sends the request to the server.

[0064] In some embodiments, business personnel can input industry query information, including the industry category of the industry to be queried, on the terminal and perform a query operation on the industry category of the industry to be queried. In response to the business personnel's query operation on the industry category of the industry to be queried, the terminal generates industry keywords including the industry category of the industry to be queried, so as to generate a data query request carrying the industry keywords, and sends the data query request to the server.

[0065] For example, in one embodiment, suppose a business person intends to query industry data for the pharmaceutical industry, the business person can... Figure 4 Enter the industry query information, including the industry category "pharmaceuticals" (the industry to be queried), into the search input box 401, and click the query control 402. In response to the business user's query operation involving the industry category "pharmaceuticals," the terminal generates industry keywords including the industry category "pharmaceuticals," then generates a data query request carrying those keywords, and sends the data query request to the server.

[0066] In one optional implementation, the industry query information entered by the business personnel may also include at least one of industry level, geographical information, and time information. Correspondingly, the generated industry keywords may also include at least one of industry level, geographical information, and time information.

[0067] In some embodiments, taking industry query information including industry category, industry level, geographic information, and time information as an example, business personnel can... Figure 4 The search input box 401 shows input of industry query information including industry level, industry category of the industry to be queried (hereinafter referred to as industry category), geographical information, and time information, and a query operation is performed on the industry query information. In response to the query operation of the business personnel on the industry query information, the terminal first generates industry keywords including the industry level, industry category of the industry to be queried (hereinafter referred to as industry category), geographical information, and time information, to generate a data query request carrying the industry keywords, and sends the data query request to the server.

[0068] For example, in one embodiment, suppose a business user intends to query industry data for the pharmaceutical industry nationwide as of October 1, 2022, within the primary industry category. The business user can... Figure 4The search input box 401 shows an industry query, including industry level, industry category (pharmaceutical industry), geographic information, and time information. The industry level is a first-level industry, the industry category (pharmaceutical industry) is pharmaceutical, the geographic information is nationwide, and the time information is October 1, 2022. In response to the business personnel's query operation regarding the above industry query information (including industry level, industry category, geographic information, and time information), the terminal generates industry keywords including the industry level, industry category, geographic information, and time information, and generates a data query request carrying these industry keywords, which is then sent to the server.

[0069] In one optional implementation, before executing S301, the developer can pre-set the information categories for industry keywords. After setting, the terminal can display the corresponding information input box based on the pre-set information categories for industry keywords, so that business personnel can enter the corresponding industry keywords in the information input box.

[0070] In some embodiments, developers can set the information categories of industry keywords by setting the primary key index value. For example, assuming the index value for the first-level industry is trade1, the index value for the second-level industry is trade2, the index value for the third-level industry is trade3, the index value for the fourth-level industry is trade4, the index value for province information is province, the index value for city information is city, and the index value for time information is date, developers can set the primary key index value to (date, trade1, trade2, trade3, trade4, province, city), meaning the information categories of industry keywords include time information, first-level industry, second-level industry, third-level industry, fourth-level industry, province information, and city information.

[0071] After setting the information categories for industry keywords using the above method, the terminal can display the information input boxes corresponding to each industry keyword information category on the screen, namely, time input box, first-level industry input box, second-level industry input box, third-level industry input box, fourth-level industry input box, province input box, and city input box. For example, as shown... Figure 5 The image shows a display interface for a monitor. The time input box can be... Figure 5 The "Time Input Box 501" shown can be a first-level industry input box. Figure 5 The "Level 1 Industry Input Box 502" shown can be a Level 2 Industry Input Box. Figure 5 The "Level 2 Industry Input Box 503" shown can be a Level 3 Industry Input Box. Figure 5 The "Level 3 Industry Input Box 504" shown can be used in the Level 4 Industry Input Box. Figure 5 The “Level 4 Industry Input Box 505” shown can be used as the province input box. Figure 5 The “Province Input Box 506” shown can be used as the city input box. Figure 5 The "City Input Box 507" is shown. Accordingly, business personnel can enter the corresponding industry query information in the information input boxes corresponding to the information categories of each industry keyword and trigger the query operation. Then, in response to the query operation for the industry query information, the terminal generates industry keywords including the industry query information, generates a data query request carrying those industry keywords, and sends the data query request to the server.

[0072] For example, in one embodiment, suppose a business user intends to query industry data for primary-level pharmaceuticals nationwide as of October 1, 2022. The business user can... Figure 5 Enter "20221001" in the time input box 501, "Pharmaceuticals" in the first-level industry input box 502, "ALL" (or leave it blank) in the second-level industry input box 503, "ALL" (or leave it blank) in the third-level industry input box 504, "ALL" (or leave it blank) in the fourth-level industry input box 505, "ALL" (or leave it blank) in the province input box 506, and "ALL" (or leave it blank) in the city input box 507. After entering the information, the business personnel can click the query control 508. The terminal responds to the business personnel's query operation for industry information by generating industry keywords that include the query information. Optionally, the generated industry keywords can be "Time = 20221001, First-level industry = Pharmaceuticals, Second-level industry = ALL, Third-level industry = ALL, Fourth-level industry = ALL, Province = ALL, City = ALL". After generating the above industry keywords, a data query request can be generated based on the industry keywords and sent to the server.

[0073] In another embodiment, assuming a business user intends to query industry data for secondary industry pharmaceutical sales in Hebei Province as of October 1, 2022, the business user can... Figure 5Enter "20221001" in the time input box 501, "Pharmaceuticals" in the first-level industry input box 502, "Pharmaceutical Sales" in the second-level industry input box 503, "ALL" (or leave it blank) in the third-level industry input box 504, "ALL" (or leave it blank) in the fourth-level industry input box 505, "Hebei" (or leave it blank) in the province input box 506, and "ALL" (or leave it blank) in the city input box 507. After entering the information, the business personnel can click the query control. The terminal responds to the business personnel's query operation for industry information by generating industry keywords that include the query information. Optionally, the generated industry keywords can be "Time = 20221001, First-level industry = Pharmaceuticals, Second-level industry = Pharmaceutical Sales, Third-level industry = ALL, Fourth-level industry = ALL, Province = Hebei, City = ALL". After generating the above industry keywords, a data query request can be generated based on the industry keywords and sent to the server.

[0074] The above technical solution enables business personnel to quickly and conveniently input industry keywords they intend to search for through the information input boxes corresponding to the information categories of various industry keywords displayed on the terminal. This effectively improves the efficiency of business personnel in inputting industry keywords during the information query process, thereby enhancing their user experience.

[0075] S302, the server receives a data query request.

[0076] S303, the server retrieves industry data for the industry to be queried from the target industry mapping table based on industry keywords.

[0077] The target industry mapping table is obtained by pre-rolling up the first and second original industry mapping tables. The first original mapping table includes multiple original mapping relationships, including the mapping relationship between search terms and the first category, where the first category is the industry category to which the search term belongs. The second original mapping table includes the mapping relationship between search terms and industry data. The target industry mapping table includes the mapping relationship between industry categories and industry data. The specific roll-up process is as follows: Figure 7 and Figure 10 A detailed introduction will not be provided here.

[0078] In this embodiment of the disclosure, industry data can be at least one of traffic data, sales revenue, and sales volume. Traffic data represents user interest in the corresponding industry. Sales revenue refers to the sales revenue of products in the corresponding industry. Sales volume refers to the sales quantity of products in the corresponding industry. This embodiment of the disclosure does not limit the industry data; the following description uses traffic data as an example to illustrate the solution.

[0079] In one optional implementation, after receiving a data query request from a terminal, the server can first obtain the industry keywords carried in the data query request. Then, based on the industry keywords, it can retrieve the industry data corresponding to those keywords from the target industry mapping table.

[0080] For example, in one embodiment, suppose the industry keyword carried in the data query request is "industry level is first-level industry, industry category is pharmaceuticals, geographical information is nationwide, and time information is October 1, 2022". After obtaining the industry keyword, the server can determine the data record under the first-level industry with the industry category of pharmaceuticals, geographical information of nationwide, and time information of 20221001 from the target industry mapping table, and use the industry data included in the data record as the industry data corresponding to the industry keyword. The industry data corresponding to the industry keyword is the industry data of the industry to be queried.

[0081] In one optional implementation, after obtaining the industry keywords carried in the data query request, the server can convert the industry keywords into the corresponding database language. Then, based on the database language corresponding to the industry keywords, it retrieves the industry data corresponding to that database language from the target industry mapping table.

[0082] In this embodiment of the disclosure, the database language may include, but is not limited to, SQL. This embodiment of the disclosure does not limit the database language; the following description uses SQL as an example.

[0083] In some embodiments, after obtaining industry keywords carried in a data query request, the server can first determine the index value corresponding to the industry keywords in the data query request based on a pre-set correspondence between industry keywords and index values. Then, based on the industry keywords and their corresponding index values, the server converts the industry keywords into corresponding SQL language. Finally, based on the SQL language corresponding to the industry keywords, the server retrieves the industry data corresponding to the SQL language from the target industry mapping table. The SQL language may include the industry keywords and their corresponding index values.

[0084] Assumption Figure 6 A pre-stored target industry mapping table. For example... Figure 6As shown, the target industry mapping table includes eight index values: province, city, trade1, trade2, trade3, trade4, pv, and date. Here, province represents the province, city represents the city, trade1 represents the primary industry, trade2 represents the secondary industry, trade3 represents the tertiary industry, trade4 represents the quaternary industry, pv represents industry data (traffic data), and date represents the time.

[0085] For example, in one embodiment, assuming the server obtains the industry keywords "Time = 20221001, First-level industry = Pharmaceuticals, Second-level industry = ALL, Third-level industry = ALL, Fourth-level industry = ALL, Province = ALL, City = ALL", the server can first determine the index values ​​corresponding to the industry keywords "Time = 20221001, First-level industry = Pharmaceuticals, Second-level industry = ALL, Third-level industry = ALL, Fourth-level industry = ALL, Province = ALL, City = ALL" based on the correspondence between the industry keywords and their respective index values. Specifically, the index value for time is "date", the index value for first-level industry is "trade1", the index value for second-level industry is "trade2", the index value for third-level industry is "trade3", the index value for fourth-level industry is "trade4", the index value for province is "province", and the index value for city is "city". Then, according to the index values ​​corresponding to the industry keywords, the industry keywords are added to the SQL language template to obtain the SQL language corresponding to the industry keywords. For example, assuming the SQL template is "select pv from table where province=XX'and city='XX'and trade1='XX'and"trade2='XX'and trade3='XX'and trade4='XX'and date='XX'", then the SQL corresponding to the industry keyword is "select pv from table where province='ALL'and city='ALL'and trade1='Pharmaceuticals'and"trade2='ALL'andtrade3='ALL'and trade4='ALL'and date='20221001'". After obtaining the SQL corresponding to the industry keyword, the server can determine the data record matching the SQL from the target industry mapping table based on the SQL, and use the industry data (i.e., PV) included in the data record as the industry data corresponding to the industry keyword, i.e., the industry data of the industry to be queried.

[0086] In another embodiment, assuming the server obtains the industry keywords "Time = 20221001, First-level industry = Pharmaceuticals, Second-level industry = Pharmaceutical sales, Third-level industry = ALL, Fourth-level industry = ALL, Province = Hebei, City = ALL", the server can first determine the index values ​​corresponding to the industry keywords "Time = 20221001, First-level industry = Pharmaceuticals, Second-level industry = Pharmaceutical sales, Third-level industry = ALL, Fourth-level industry = ALL, Province = Hebei, City = ALL" based on the correspondence between the industry keywords and their respective index values. Specifically, the index value for time is "date", the index value for first-level industry is "trade1", the index value for second-level industry is "trade2", the index value for third-level industry is "trade3", the index value for fourth-level industry is "trade4", the index value for province is "province", and the index value for city is "city". Then, according to the index values ​​corresponding to the industry keywords, the server adds the industry keywords to the SQL language template to obtain the corresponding SQL language. The server can determine the data record that matches the SQL language from the target industry mapping table based on the SQL language, and use the industry data included in the data record as the industry data corresponding to the industry keyword, that is, the industry data of the industry to be queried.

[0087] In an optional implementation, the original mapping relationship, in addition to including the mapping relationship between the search term and the first category, may also include the mapping relationship between the first category and the industry level to which the first category belongs. Correspondingly, the target industry mapping table, in addition to the mapping relationship between industry categories and industry data, may also include the mapping relationship between the industry level to which the industry category belongs and the industry data. For example, Figure 6 The trade1 shown can represent a first-level industry, trade2 can represent a second-level industry, trade3 can represent a third-level industry, and trade4 can represent a fourth-level industry.

[0088] Through the above technical solution, after the server converts industry keywords into the corresponding database language, it can quickly match them from the target industry mapping table according to the database language. Compared with the existing technology that requires scanning hundreds of thousands or even millions of data records, the technical solution provided by this disclosure only needs to hit one mapping relationship to obtain the industry data corresponding to the industry keyword, thus effectively improving the data query efficiency.

[0089] S304, the server sends the acquired industry data to the terminal.

[0090] S305, terminal display of industry data.

[0091] After obtaining the industry data corresponding to the industry keywords via S303, the industry data can be sent to the terminal. Upon receiving the industry data, the terminal can display it on a monitor for business personnel to view.

[0092] Through the above technical solution, after receiving a data query request from the terminal, the server can retrieve the industry data of the industry to be queried from the target industry mapping table based on the industry category of the industry to be queried included in the industry keywords carried in the data query request. Since the target industry mapping table is obtained by pre-rolling up the first and second original mapping tables, the industry data of the industry to be queried can be directly retrieved from the target industry mapping table obtained after roll-up processing during data querying, without needing to roll up the data included in the original industry mapping table during the data query process. Therefore, it can not only effectively improve data query efficiency and reduce data query response time, thereby improving the user experience, but also effectively avoid the waste of computing resources. In addition, when storing data, only the target industry mapping table obtained after roll-up processing needs to be stored, instead of storing the massive original industry mapping table. Therefore, it can effectively reduce data redundancy issues and further improve data query efficiency.

[0093] In this embodiment of the disclosure, during execution Figure 3 Before the data query method shown, the first and second original mapping tables can be pre-processed by rolling up to obtain the target industry mapping table. The following will describe in detail the process of determining the target industry mapping table using two methods.

[0094] Method 1

[0095] Figure 7 An exemplary flowchart of a method for determining a target industry mapping table provided by an embodiment of this disclosure is shown, such as... Figure 7 As shown, the method includes:

[0096] S701, the server generates an industry-level mapping table corresponding to each of the multiple original mapping relationships included in the first original mapping table.

[0097] The first original mapping table contains multiple original mapping relationships. For example, Figure 7 The first original mapping table shown contains a total of 5 original mapping relationships. Among them, there are three original mapping relationships corresponding to the search term word1, and two original mapping relationships corresponding to the search term word2. It should be noted that each original mapping relationship is represented by a row of data records in the first original mapping table.

[0098] The original mapping relationship includes the mapping relationship between search terms and the first category. Here, the search term is the search term used by the user when searching for data, and the first category is the industry category to which the search term belongs. For example, taking the search term "word1" as an example, the industry categories to which "word1" belongs are tradeD1, tradeD2, and tradeD3, and these industry categories all belong to the fourth-level industry category. The original mapping relationship corresponding to "word1" can be represented as "word1-tradeA-tradeB-tradeC-tradeD1", "word1-tradeA-tradeB-tradeC-tradeD2", and "word1-tradeA-tradeB-tradeC-tradeD3". Furthermore, the original mapping relationship can also include the mapping relationship between the first category and the industry level to which the first category belongs. For example, Figure 7 The tradeA shown can represent the industry category of the first-level industry to which the fourth-level industry belongs, the tradeB can represent the industry category of the second-level industry to which the fourth-level industry belongs, and the tradeC can represent the industry category of the third-level industry to which the fourth-level industry belongs.

[0099] The industry hierarchy mapping table includes the original mapping relationships and the corresponding progressive mapping relationships. The original mapping relationships include the mapping between search terms and the first category, and the mapping between the first category and the industry hierarchy to which the first category belongs. The progressive mapping relationships include the mapping between search terms, the second category, and the industry hierarchy to which the second category belongs. The second category includes the first category; that is, the first category belongs to the second category, and the industry hierarchy to which the second category belongs is higher than the industry hierarchy to which the first category belongs.

[0100] For example, taking the original mapping relationship as "word1-tradeA-tradeB-tradeC-tradeD1", the first category (i.e., the industry category to which the search term belongs) is the industry category of the fourth-level industry. Then the second category includes the industry categories of the third-level industry, the industry categories of the second-level industry, and the industry categories of the first-level industry. Therefore, the progressive mapping relationship includes the mapping relationship between the search term and the industry category of the third-level industry "word1-tradeA-tradeB-tradeC", the mapping relationship between the search term and the industry category of the second-level industry "word1-tradeA-tradeB", and the mapping relationship between the search term and the industry category of the first-level industry "word1-tradeA".

[0101] In one optional implementation, when executing S701, the server can determine the second category corresponding to the first category based on the first category in the original mapping relationship, and then generate a progressive mapping relationship corresponding to the original mapping relationship based on the search terms in the original mapping relationship, the second category corresponding to the first category, and the industry level to which the second category belongs. The original mapping relationship and the progressive mapping relationship corresponding to the original mapping relationship are then merged to obtain the industry level mapping table corresponding to the original mapping relationship.

[0102] In some embodiments, for each original mapping relationship, the server can first determine the first category in the original mapping relationship, that is, the industry category corresponding to the lowest industry level in the various industry levels of the original mapping relationship. After determining the first category, the server can determine the second category corresponding to the first category, that is, the industry category corresponding to each industry level other than the lowest industry level in the various industry levels of the original mapping relationship. Then, based on the search terms in the original mapping relationship, the second category, and the industry level to which the second category belongs, a corresponding progressive mapping relationship is generated, and the original mapping relationship and the generated progressive mapping relationship are merged to obtain an industry level mapping table.

[0103] For example, in one embodiment, taking the original mapping relationship as "word1-tradeA-tradeB-tradeC-tradeD1" as an example, the first category in this original mapping relationship is the industry category tradeD1 of the fourth-level industry, and the second category includes the industry category tradeC of the third-level industry, the industry category tradeB of the second-level industry, and the industry category tradeA of the first-level industry. Therefore, based on the search terms and the second category in this original mapping relationship, corresponding progressive mapping relationships can be generated, namely "word1-tradeA-tradeB-tradeC", "word1-tradeA-tradeB", and "word1-tradeA". After generating the progressive mapping relationships, the original mapping relationship "word1-tradeA-tradeB-tradeC-tradeD1" and the progressive mapping relationships "word1-tradeA-tradeB-tradeC", "word1-tradeA-tradeB", and "word1-tradeA" can be merged to obtain an industry hierarchy mapping table.

[0104] Similarly, the above processing can be performed on each original mapping relationship in the first original mapping table to obtain the industry-level mapping table corresponding to each original mapping relationship. For example, combining... Figure 7 As shown, it is possible to... Figure 7The five original mapping relationships included in the first original mapping table shown are all processed as described above to obtain the industry-level mapping table 1 corresponding to the first original mapping relationship, the industry-level mapping table 2 corresponding to the second original mapping relationship, the industry-level mapping table 3 corresponding to the third original mapping relationship, the industry-level mapping table 4 corresponding to the fourth original mapping relationship, and the industry-level mapping table 5 corresponding to the fifth original mapping relationship.

[0105] In an optional implementation, based on the above-mentioned progressive mapping relationship, which may also include the mapping relationship between the second category and the industry level to which the second category belongs, the industry level mapping table may include the mapping relationship between search terms, industry categories, and the industry level to which the industry categories belong.

[0106] The above technical solution can quickly and efficiently generate industry-level mapping tables corresponding to each original mapping relationship, thus laying the groundwork for generating the first industry mapping table and the target industry mapping table, and indirectly achieving the beneficial effect of reducing the complexity of data roll-up operations.

[0107] S702, the server performs deduplication on the industry-level mapping tables corresponding to multiple original mapping relationships to obtain the first industry mapping table.

[0108] In one optional implementation, after obtaining the industry-level mapping table corresponding to each original mapping relationship in S701, the industry-level mapping tables corresponding to each original mapping relationship can be merged to obtain a merged industry-level mapping table. Then, the merged industry-level mapping table is deduplicated, that is, among at least two mapping relationships with completely identical industry keywords and industry categories, only one mapping relationship is retained. After deduplication is completed, the first industry mapping table is obtained.

[0109] In another optional implementation, after obtaining the industry-level mapping table corresponding to each original mapping relationship through S701, the mapping relationships in each industry-level mapping table can be directly deduplicated. That is, among at least two mapping relationships with completely identical industry keywords and industry categories, only one mapping relationship is retained. After deduplication, the deduplicated industry-level mapping tables can be merged to obtain the first industry mapping table.

[0110] Exemplarily, in one embodiment, to [do something] Figure 7Taking the deduplication of industry-level mapping tables 1 and 2 as an example, industry-level mapping table 1 includes the original mapping relationship 1 and progressive mapping relationship 1, progressive mapping relationship 2, and progressive mapping relationship 3. Industry-level mapping table 2 includes the original mapping relationship 2 and progressive mapping relationship a, progressive mapping relationship b, and progressive mapping relationship c. Among them, progressive mapping relationships 1 and a contain the exact same industry keywords and industry categories; progressive mapping relationships 2 and b contain the exact same industry keywords and industry categories; and progressive mapping relationships 3 and c contain the exact same industry keywords and industry categories. Therefore, deduplication can be performed on progressive mapping relationships 1 and a, progressive mapping relationships 2 and b, and progressive mapping relationships 3 and c.

[0111] Similarly, it is possible to... Figure 7 The industry-level mapping tables 1-5 shown above are subjected to the above deduplication process to obtain the first industry mapping table.

[0112] In one optional implementation, based on the S701 industry hierarchy mapping table which includes the mapping relationship between search terms, industry categories, and the industry hierarchy to which the industry categories belong, the first industry mapping table may include the mapping relationship between search terms, industry categories, and the industry hierarchy to which the industry categories belong.

[0113] Based on the above technical solution and the industry-level mapping tables corresponding to each original mapping relationship, the first industry mapping table can be generated quickly and efficiently with only one deduplication operation, which has the beneficial effect of reducing the complexity of data roll-up operations.

[0114] S703, the server generates a second industry mapping table based on the first industry mapping table and the second original mapping table.

[0115] The second original mapping table includes the mapping relationship between search terms and industry data. The second industry mapping table includes the mapping relationship between industry categories and industry data.

[0116] Furthermore, based on the mapping relationship between the first industry mapping table in S702, which includes search terms, industry categories, and the industry levels to which the industry categories belong, the second industry mapping table can include the mapping relationship between industry categories, the industry levels to which the industry categories belong, and industry data.

[0117] In one optional implementation, the server can generate an associated mapping relationship based on any two mapping relationships with the same search term in the first industry mapping table and the second original mapping table, thus obtaining multiple associated mapping relationships; then, based on the multiple associated mapping relationships, a second industry mapping table is generated. The associated mapping relationships include industry categories, the industry hierarchy to which the industry category belongs, and the mapping relationships between industry data.

[0118] In some embodiments, any two mapping relationships with the same search term can be determined first from the first industry mapping table and the second original mapping table. The industry category and industry data in these two mapping relationships are then associated to obtain an associated mapping relationship. At this time, the associated mapping relationship only includes the industry category, the industry level to which the industry category belongs, and the mapping relationship between the industry data. After obtaining multiple associated mapping relationships, the generated multiple associated mapping relationships can be merged to obtain the second industry mapping table.

[0119] Exemplarily, in one embodiment, such as Figure 8 As shown, the first industry mapping table includes 11 mapping relationships, denoted by 1-11. The second original mapping table includes 2 mapping relationships, denoted by a and b. We can first determine any two mapping relationships with the same search term in the first industry mapping table and the second original mapping table, and then associate the industry categories and industry data in these two mapping relationships to obtain an associated mapping relationship. For example, associating the industry categories and industry data included in 1 of the first industry mapping table with the same search term and 'a' of the second original mapping table generates associated mapping relationship 1a; associating the industry categories and industry data included in 2 of the first industry mapping table with the same search term and 'a' of the second original mapping table generates associated mapping relationship 2a… and so on. After obtaining multiple associated mapping relationships, we can merge these multiple associated mapping relationships to obtain the second industry mapping table including 1a-11b.

[0120] The above technical solution allows for the direct association of industry categories and industry data between any two mapping relationships, resulting in multiple associated mapping relationships. This allows for the direct generation of a second industry mapping table based on these multiple associated mapping relationships, thus enabling faster and more efficient generation of the second industry mapping table and reducing the complexity of generating it.

[0121] In other embodiments, any two mapping relationships with the same search term can be first determined in the first industry mapping table and the second original mapping table. The search terms, industry categories, and industry data included in these two mapping relationships are then merged to obtain a single associated mapping relationship. This associated mapping relationship includes the search terms, industry categories, the industry level to which the industry category belongs, and the mapping relationships between industry data. After obtaining multiple associated mapping relationships, these relationships can be merged to obtain an intermediate industry mapping table. Then, the industry keywords included in the intermediate industry mapping table are deleted to obtain a second industry mapping table.

[0122] Exemplarily, in one embodiment, such as Figure 9 As shown, the first industry mapping table includes 11 mapping relationships, denoted by 1-11. The second original mapping table includes 2 mapping relationships, denoted by a and b. We can first identify any two mapping relationships with the same search term in the first and second original mapping tables, and then merge the search term, industry category, and industry data included in these two mapping relationships to obtain a related mapping relationship. For example, we can associate the search term, industry category, and industry data included in '1' in the first industry mapping table and 'a' in the second original mapping table to generate related mapping relationship 1a; we can associate the search term, industry category, and industry data included in '2' in the first industry mapping table and 'a' in the second original mapping table to obtain related mapping relationship 2a… and so on. After obtaining multiple related mapping relationships, we can merge these multiple related mapping relationships to obtain an intermediate industry mapping table including 1a-11b. Then, we can delete the industry keywords included in the intermediate industry mapping table to obtain the second industry mapping table.

[0123] In one optional implementation, the second original mapping table further includes a mapping relationship between query information and industry data; the query information includes at least one of geographic information and time information; wherein, the geographic information is the geographical location of the user when performing the data search, and the time information is the timestamp of the user's data search.

[0124] For example, in some embodiments, taking the query information including geographic information as an example, the second original mapping table includes the mapping relationship between search terms, geographic information, and industry data. In one embodiment, based on the query information including geographic information, the generated second industry mapping table may also include the mapping relationship between geographic information and industry data, that is, the second industry mapping table includes industry category, the industry level to which the industry category belongs, and the mapping relationship between geographic information and industry data.

[0125] In some embodiments, taking the example that the query information includes time information, the second original mapping table includes the mapping relationship between search terms, time information, and industry data. In one embodiment, based on the query information including time information, the generated second industry mapping table may also include the mapping relationship between time information and industry data, that is, the second industry mapping table includes industry category, the industry level to which the industry category belongs, and the mapping relationship between time information and industry data.

[0126] In other embodiments, taking the example that the query information includes time information and geographic information, the second original mapping table includes the mapping relationship between search terms, time information, geographic information, and industry data. In one embodiment, based on the query information including geographic information and time information, the generated second industry mapping table may also include the mapping relationship between time information, geographic information, and industry data; that is, the second industry mapping table includes the mapping relationship between industry category, the industry level to which the industry category belongs, time information, geographic information, and industry data.

[0127] The more information included in the second original mapping table, the more information is included in the generated second industry mapping table. Consequently, the target industry mapping table generated later can also include more information, thereby helping users to query industry data with more granularity and thus effectively improving the user experience.

[0128] S704, aggregate the industry data in the second industry mapping table to obtain the target industry mapping table.

[0129] In one alternative implementation, industry data corresponding to at least two mapping relationships with the same industry category in the second industry mapping table can be merged to obtain the target industry mapping table.

[0130] In one alternative implementation, the second original mapping table may further include query information; the query information may include at least one of geographic information and time information; correspondingly, the second industry mapping table may also include query information.

[0131] In some embodiments, if the query information includes geographic information, that is, the second original mapping table includes the mapping relationship between search terms, geographic information and industry data; correspondingly, the second industry mapping table includes the mapping relationship between industry category, industry level to which the industry category belongs, geographic information and industry data, then the industry data corresponding to at least two mapping relationships in the second industry mapping table that are the same in terms of industry category and geographic information can be merged to obtain the target industry mapping table.

[0132] In some other embodiments, if the query information includes time information, that is, the second original mapping table includes the mapping relationship between search terms, time information and industry data; correspondingly, the second industry mapping table includes the mapping relationship between industry category, industry level to which the industry category belongs, time information and industry data, then the industry data corresponding to at least two mapping relationships with the same industry category and time information in the second industry mapping table can be merged to obtain the target industry mapping table.

[0133] In other embodiments, if the query information includes geographic information and time information, that is, the second original mapping table includes the mapping relationship between search terms, geographic information, time information and industry data; correspondingly, the second industry mapping table includes the mapping relationship between industry category, industry level to which the industry category belongs, geographic information, time information and industry data, then the industry data corresponding to at least two mapping relationships in the second industry mapping table that are the same in terms of industry category, geographic information and time information can be merged to obtain the target industry mapping table.

[0134] In this embodiment of the disclosure, industry data can be numerical data such as traffic data, sales amount, and sales quantity, or non-numerical data such as performance data; this embodiment of the disclosure does not limit the type of data. When the industry data is numerical data, the merging of industry data described above can involve adding the industry data from at least two mapping relationships. When the industry data is non-numerical data, the merging of industry data described above can involve merging at least two mapping relationships into one mapping relationship.

[0135] The method described above for determining the target industry mapping table only requires one deduplication and aggregation operation during the data roll-up process. Therefore, compared with the data roll-up methods in related technologies, it can roll up the data more quickly and efficiently to obtain the target industry mapping table. This not only effectively reduces the complexity of the data roll-up operation but also effectively improves the efficiency of data query.

[0136] Method 2

[0137] Figure 10 An exemplary flowchart of another method for determining a target industry mapping table provided by an embodiment of this disclosure is shown, such as... Figure 10 As shown, taking an industry hierarchy including first-level, second-level, third-level, and fourth-level industries as an example, the method includes:

[0138] S1001, the server generates an original association mapping table based on the first original mapping table and the second original mapping table.

[0139] In one optional implementation, the second original mapping table may include mapping relationships between search terms and industry data. The server can associate any two mapping relationships with the same search terms in the first industry mapping table and the second original mapping table to obtain an original association mapping relationship. After obtaining multiple original association mapping relationships, the server can generate an original association mapping table based on these relationships. The original association mapping relationships include mapping relationships between industry keywords, industry levels, and industry data.

[0140] Exemplarily, in one embodiment, it can be Figure 10 The first and second original mapping tables are associated with any two mapping relationships that have the same search terms (word1 and word2) to obtain the original association mapping table.

[0141] In another alternative implementation, the second original mapping table may include mapping relationships between search terms, geographic information, and industry data. Correspondingly, the generated original association mapping table may include mapping relationships between industry keywords, geographic information, industry levels, and industry data.

[0142] In another alternative implementation, the second original mapping table may include mapping relationships between search terms, geographic information, time information, and industry data. Correspondingly, the generated original association mapping table may include mapping relationships between industry keywords, geographic information, time information, industry levels, and industry data.

[0143] S1002. Based on the industry categories of the fourth-level industries included in the original association mapping table and the corresponding industry data, determine the fourth-level industry mapping table.

[0144] After generating the original association mapping table via S1001, the industry keywords in the original association mapping table can be deleted to obtain an initial four-level industry mapping table that includes the mapping relationship between industry categories and industry data. Then, the industry data corresponding to at least two mapping relationships in the initial four-level industry mapping table where the industry categories of the first-level, second-level, third-level, and fourth-level industries are all the same are added together to obtain a four-level industry mapping table that includes the industry data corresponding to each industry category in the fourth-level industry.

[0145] For example, in one embodiment, the first step can be to... Figure 10The industry keywords (word1 and word2) in the original association mapping table are deleted to obtain an initial four-level industry mapping table that includes the mapping relationship between industry categories and industry data. Then, the industry data corresponding to at least two mapping relationships in the initial four-level industry mapping table where the industry categories of the first-level industry (tradeA), the second-level industry (tradeB), the third-level industry (tradeC), and the fourth-level industry (tradeD1, tradeD2, and tradeD3) are all the same are added together to obtain the fourth-level industry mapping table.

[0146] S1003. Based on the industry categories of the third-level industries included in the original association mapping table and the corresponding industry data, determine the third-level industry mapping table.

[0147] After generating the original association mapping table via S1001, the industry categories of the fourth-level industries included in the original association mapping table can be deleted (i.e., retaining industry keywords, first-level industry categories, second-level industry categories, and third-level industry categories) to obtain the initial third-level industry mapping table. After obtaining the initial third-level industry mapping table, the mapping relationships in the initial third-level industry mapping table can be deduplicated. That is, among at least two mapping relationships with identical industry keywords and industry categories, only one mapping relationship is retained. After deduplication, an intermediate third-level industry mapping table is obtained. The intermediate third-level industry mapping table is then aggregated according to first-level, second-level, and third-level industries. That is, the industry data corresponding to at least two mapping relationships in the intermediate third-level industry mapping table where the first-level, second-level, and third-level industry categories are all the same are added together, and industry keywords are deleted, resulting in a third-level industry mapping table that includes the industry data corresponding to each industry category in the third-level industries.

[0148] For example, in one embodiment, the first step can be to... Figure 10 The original association mapping table includes four-level industry categories (tradeD1, tradeD2, and tradeD3), which are then removed to obtain an initial three-level industry mapping table. Next, duplicate mapping relationships in the initial three-level industry mapping table are removed to obtain an intermediate three-level industry mapping table. Finally, the industry data corresponding to at least two mapping relationships in the intermediate three-level industry mapping table where the first-level industry category (tradeA), the second-level industry category (tradeB), and the third-level industry category (tradeC) are identical are added together, and industry keywords (word1 and word2) are removed to obtain the final three-level industry mapping table.

[0149] S1004. Based on the industry categories of the secondary industries included in the original association mapping table and the corresponding industry data, determine the secondary industry mapping table;

[0150] After generating the original association mapping table via S1001, the industry categories of the fourth-level and third-level industries included in the original association mapping table can be deleted (i.e., industry keywords, first-level industry categories, and second-level industry categories are retained), resulting in an initial second-level industry mapping table. After obtaining the initial second-level industry mapping table, the mapping relationships in the initial second-level industry mapping table can be deduplicated. After deduplication, an intermediate second-level industry mapping table is obtained. This intermediate second-level industry mapping table is then aggregated according to first-level and second-level industries. That is, the industry data corresponding to at least two mapping relationships in the intermediate second-level industry mapping table where the first-level and second-level industry categories are the same are added together, and industry keywords are removed, resulting in a second-level industry mapping table that includes the industry data corresponding to each industry category in the second-level industries.

[0151] For example, in one embodiment, the first step can be to... Figure 10 The original association mapping table shown includes industry categories of the fourth-level industry (tradeD1, tradeD2, and tradeD3) and the industry category of the third-level industry (tradeC). These are then removed to obtain the initial second-level industry mapping table. Next, duplicate mapping relationships in the initial second-level industry mapping table are removed to obtain the intermediate second-level industry mapping table. Finally, the industry data corresponding to at least two mapping relationships in the intermediate second-level industry mapping table where the first-level industry category (tradeA) and the second-level industry category (tradeB) are identical are added together, and the industry keywords (word1 and word2) are removed to obtain the second-level industry mapping table.

[0152] S1005. Based on the industry categories of the primary industries included in the original association mapping table and the corresponding industry data, determine the primary industry mapping table.

[0153] After generating the original association mapping table via S1001, the industry categories of the fourth-level, third-level, and second-level industries included in the original association mapping table can be deleted (i.e., industry keywords and first-level industry categories are retained) to obtain the initial first-level industry mapping table. After obtaining the initial first-level industry mapping table, the mapping relationships in the initial first-level industry mapping table can be deduplicated. After deduplication, an intermediate first-level industry mapping table is obtained. The intermediate first-level industry mapping table is aggregated according to the first-level industry, that is, the industry data corresponding to at least two mapping relationships with the same first-level industry industry category in the intermediate first-level industry mapping table are added together and the industry keywords are deleted to obtain a first-level industry mapping table that includes the industry data corresponding to each industry category in the first-level industry.

[0154] For example, in one embodiment, the first step can be to... Figure 10The original association mapping table shown includes industry categories for fourth-level industries (tradeD1, tradeD2, and tradeD3), third-level industries (tradeC), and second-level industries (tradeB). These are then removed to obtain the initial first-level industry mapping table. Next, duplicate mapping relationships in the initial first-level industry mapping table are removed to obtain an intermediate first-level industry mapping table. Finally, the industry data corresponding to at least two mapping relationships with the same first-level industry category (tradeA) in the intermediate first-level industry mapping table are added together, and industry keywords (word1 and word2) are removed to obtain the first-level industry mapping table.

[0155] In this embodiment, the execution order of S1002-S1005 is not sequential; that is, the fourth-level industry mapping table, the third-level industry mapping table, the second-level industry mapping table, and the first-level industry mapping table can be determined simultaneously according to the above steps. Alternatively, the first-level industry mapping table can be determined first, followed by the second-level, third-level, and fourth-level industry mapping tables. This embodiment does not limit the execution order of S1002-S1005.

[0156] S1006, Generate the target industry mapping table based on the fourth-level industry mapping table, the third-level industry mapping table, the second-level industry mapping table, and the first-level industry mapping table.

[0157] After obtaining the fourth-level, third-level, second-level, and first-level industry mapping tables through the above method, these tables can be merged to obtain the target industry mapping table.

[0158] Exemplarily, in one embodiment, it can be Figure 10 The four-level, three-level, two-level, and one-level industry mapping tables shown are merged to obtain... Figure 10 The target industry mapping table is shown.

[0159] Both methods described above allow for pre-processing of the first and second original mapping tables to obtain the target industry mapping table, which is then stored without needing to store the original industry mapping tables. This effectively reduces data redundancy and improves data query efficiency. Furthermore, when querying industry data through the target industry mapping table, the corresponding industry data for the industry keywords can be directly retrieved. Compared to existing technologies that require data roll-up processing on the business side during the query process, this reduces response time, significantly improves query efficiency, and ultimately enhances the user experience for business personnel.

[0160] Based on the same inventive concept, this disclosure provides a flowchart illustrating another data query method, such as... Figure 11 As shown, the method includes:

[0161] S1101, receives a data query request from the terminal.

[0162] S1102, Based on industry keywords, retrieve industry data for the industry to be queried from the target industry mapping table.

[0163] Specifically, you can refer to Figure 3 The steps for S303 are not detailed here.

[0164] S1103, send the industry data of the industry to be queried to the terminal.

[0165] The above method embodiments can be executed by a data query device, which can be used to implement the functional modules or units described in the embodiments of this disclosure. For example... Figure 12 As shown, this embodiment of the disclosure provides a data query device 1200, including:

[0166] The receiving module 1201 is used to receive data query requests from the terminal; the data query request carries industry keywords; the industry keywords include the industry category of the industry to be queried.

[0167] The acquisition module 1202 is used to obtain industry data of the industry to be queried from the target industry mapping table based on industry keywords. The target industry mapping table is obtained by pre-rolling up the first original mapping table and the second original mapping table. The first original mapping table includes multiple original mapping relationships. The original mapping relationships include the mapping relationship between search terms and the first category. The first category is the industry category to which the industry corresponding to the search term belongs. The second original mapping table includes the mapping relationship between search terms and industry data. The target industry mapping table includes the mapping relationship between industry categories and industry data.

[0168] The sending module 1203 is used to send industry data of the industry to be queried to the terminal.

[0169] The aforementioned data query device, upon receiving a data query request from a terminal, can retrieve industry data for the industry to be queried from the target industry mapping table based on the industry category of the industry included in the industry keywords carried in the query request. Since the target industry mapping table is obtained by pre-rolling up the first and second original mapping tables, the industry data for the industry to be queried can be directly retrieved from the target industry mapping table obtained after the roll-up process during data querying, without needing to perform roll-up processing on the data during the query process. Therefore, this not only effectively improves data query efficiency and reduces data query response time, thereby enhancing the user experience, but also effectively avoids wasting computing resources. Furthermore, during data storage, only the target industry mapping table obtained after the roll-up process needs to be stored, without needing to store the massive amounts of data in the first and second original mapping tables. This effectively reduces data redundancy and further improves data query efficiency.

[0170] Optionally, the original mapping relationship also includes the mapping relationship between the first category and the industry level to which the first category belongs; the target industry mapping table also includes the mapping relationship between the industry level to which the industry category belongs and the industry data;

[0171] The data query device 1200 also includes a processing module; the processing module includes:

[0172] The generation module is used to generate an industry-level mapping table corresponding to each of the multiple original mapping relationships included in the first original mapping table. The industry-level mapping table includes the original mapping relationship and the corresponding progressive mapping relationship. The progressive mapping relationship includes the mapping relationship between the search term, the second category, and the industry level to which the second category belongs. The second category includes the first category. The industry level to which the second category belongs is higher than the industry level to which the first category belongs.

[0173] The deduplication module is used to deduplicatize the industry-level mapping tables corresponding to multiple original mapping relationships to obtain the first industry mapping table.

[0174] The merging module is used to generate a second industry mapping table based on the first industry mapping table and the second original mapping table. The second industry mapping table includes industry categories, the industry level to which the industry category belongs, and the mapping relationship between industry data.

[0175] The determination module is used to aggregate industry data in the second industry mapping table to obtain the target industry mapping table.

[0176] Optionally, the generation module is used for:

[0177] Based on the first category in the original mapping relationship, determine the second category corresponding to the first category;

[0178] Based on the search terms in the original mapping relationship, the second category corresponding to the first category, and the industry level to which the second category belongs, generate a progressive mapping relationship corresponding to the original mapping relationship;

[0179] Merge the original mapping relationship and the corresponding progressive mapping relationship to obtain the industry-level mapping table corresponding to the original mapping relationship.

[0180] Optional, merge module, used for:

[0181] Based on any two mapping relationships with the same search term in the first industry mapping table and the second original mapping table, generate one associated mapping relationship, resulting in multiple associated mapping relationships; the associated mapping relationship includes industry category, industry level to which the industry category belongs, and mapping relationship between industry data;

[0182] A second industry mapping table is generated based on multiple related mapping relationships.

[0183] Optional, determine the module, used for:

[0184] Merge the industry data corresponding to at least two mapping relationships with the same industry category in the second industry mapping table to obtain the target industry mapping table.

[0185] Optionally, the second original mapping table also includes the mapping relationship between query information and industry data; the query information includes at least one of geographic information and time information; the second industry mapping table also includes the mapping relationship between query information and industry data, and the target industry mapping table also includes the mapping relationship between query information and industry data; the geographic information is the geographical location of the user when performing the data search; the time information is the timestamp when the user performs the data search.

[0186] The determination module is used for:

[0187] Merge the industry data corresponding to at least two mapping relationships with the same industry category and query information in the second industry mapping table to obtain the target industry mapping table.

[0188] Optionally, industry data may include at least one of traffic data, sales revenue, and sales volume; traffic data is used to represent user attention to the corresponding industry; sales revenue refers to the sales revenue of products in the corresponding industry; and sales volume refers to the sales volume of products in the corresponding industry.

[0189] Optionally, industry keywords may also include at least one of the following: industry level, geographic information, and time information.

[0190] Figure 13A schematic block diagram of an example electronic device 1300 that can be used to implement embodiments of the present disclosure is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as personal digital processors, cellular phones, smartphones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the present disclosure described and / or claimed herein.

[0191] like Figure 13 As shown, the electronic device 1300 includes a computing unit 1301, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 1302 or a computer program loaded from a storage unit 1308 into a random access memory (RAM) 1303. The RAM 1303 may also store various programs and data required for the operation of the electronic device 1300. The computing unit 1301, ROM 1302, and RAM 1303 are interconnected via a bus 1304. An input / output (I / O) interface 1305 is also connected to the bus 1304.

[0192] Multiple components in electronic device 1300 are connected to I / O interface 1305, including: input unit 1306, such as keyboard, mouse, etc.; output unit 1307, such as various types of monitors, speakers, etc.; storage unit 1308, such as disk, optical disk, etc.; and communication unit 1309, such as network card, modem, wireless transceiver, etc. Communication unit 1309 allows electronic device 1300 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0193] The computing unit 1301 can be a variety of general-purpose and / or special-purpose processing components with processing and computing capabilities. Examples of computing units 1301 include, but are not limited to, a central processing unit, a graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. The computing unit 1301 performs the various methods and processes described above, such as the data matching method. For example, in one embodiment, the data matching method can be implemented as a computer software program tangibly included in a machine-readable medium, such as storage unit 1308. In one embodiment, part or all of the computer program can be loaded and / or installed on the electronic device 1300 via ROM 1302 and / or communication unit 1309. When the computer program is loaded into RAM 1303 and executed by the computing unit 1301, one or more steps of the data matching method described above can be performed. Alternatively, in other embodiments, the computing unit 1301 may be configured to perform a data matching method by any other suitable means (e.g., by means of firmware).

[0194] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard parts (ASSPs), systems-on-chip (SoCs), complex programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include implementations in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor, capable of receiving data and instructions from a storage system, at least one input device, and at least one output device, and transmitting data and instructions to the storage system, the at least one input device, and the at least one output device.

[0195] The program code used to implement the methods of this disclosure may be written in any combination of one or more programming languages. This program code may be provided to a processor or controller of a general-purpose computer, special-purpose computer, or other programmable data processing apparatus, such that when executed by the processor or controller, the program code causes the functions / operations specified in the flowcharts and / or block diagrams to be implemented. The program code may be executed entirely on a machine, partially on a machine, as a standalone software package partially on a machine and partially on a remote machine, or entirely on a remote machine or server.

[0196] In the context of this disclosure, a machine-readable medium can be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, apparatus, or device. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can be, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory, read-only memory, erasable programmable read-only memory (EPROM or flash memory), optical fibers, compact disc read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0197] To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device for displaying information to the user, such as a cathode ray tube (CRT) or liquid crystal display (LCD) monitor; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user provides input to the computer. Other types of devices can also be used to provide interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including sound input, voice input, or tactile input).

[0198] The systems and technologies described herein can be implemented in computing systems that include backend components (e.g., as a data server), or computing systems that include middleware components (e.g., an application server), or computing systems that include frontend components (e.g., a user computer with a graphical user interface or web browser through which a user can interact with implementations of the systems and technologies described herein), or any combination of such backend, middleware, or frontend components. The components of the system can be interconnected via digital data communication of any form or medium (e.g., a communication network). Examples of communication networks include local area networks (LANs), wide area networks (WANs), and the Internet.

[0199] Computer systems can include clients and servers. Clients and servers are generally located far apart and typically interact via communication networks. Client-server relationships are created by computer programs running on the respective computers and having a client-server relationship with each other. Servers can be cloud servers, servers in distributed systems, or servers incorporating blockchain technology.

[0200] It should be understood that the various forms of processes shown above can be used to reorder, add, or delete steps. For example, the steps described in this disclosure can be executed in parallel, sequentially, or in different orders, as long as the desired result of the technical solution of this disclosure can be achieved, and this is not limited herein.

[0201] The specific embodiments described above do not constitute a limitation on the scope of protection of this disclosure. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this disclosure should be included within the scope of protection of this disclosure.

Claims

1. A data query method, comprising: Receive data query requests from the terminal; The data query request carries industry keywords; the industry keywords include the industry category of the industry to be queried. Based on the industry keywords, industry data of the industry to be queried is obtained from the target industry mapping table; the target industry mapping table is obtained by pre-rolling up the first original mapping table and the second original mapping table. Send the industry data of the industry to be queried to the terminal; The target industry mapping table is obtained by performing a roll-up process on the first and second original mapping tables, including: For each of the multiple original mapping relationships included in the first original mapping table, an industry-level mapping table corresponding to the original mapping relationship is generated. The original mapping relationship includes the mapping relationship between a search term and a first category, and also includes the mapping relationship between the first category and the industry level to which the first category belongs, where the first category is the industry category to which the search term belongs. The industry-level mapping table includes the original mapping relationship and the corresponding progressive mapping relationship. The progressive mapping relationship includes the mapping relationship between the search term, a second category, and the industry level to which the second category belongs. The second category includes the first category; the industry level to which the second category belongs is higher than the industry level to which the first category belongs. The industry-level mapping tables corresponding to the multiple original mapping relationships are deduplicated to obtain the first industry mapping table; A second industry mapping table is generated based on the first industry mapping table and the second original mapping table; the second original mapping table includes the mapping relationship between search terms and industry data; the second industry mapping table includes industry categories, the industry level to which the industry category belongs, and the mapping relationship between industry data. The industry data in the second industry mapping table is aggregated to obtain the target industry mapping table; the target industry mapping table includes the mapping relationship between industry categories and industry data, and also includes the mapping relationship between the industry level to which the industry category belongs and the industry data.

2. The method of claim 1, wherein, The step of generating an industry-level mapping table corresponding to each of the multiple original mapping relationships included in the first original mapping table includes: Based on the first category in the original mapping relationship, determine the second category corresponding to the first category; Based on the search terms in the original mapping relationship, the second category corresponding to the first category, and the industry level to which the second category belongs, a progressive mapping relationship is generated corresponding to the original mapping relationship. The original mapping relationship and the corresponding progressive mapping relationship are merged to obtain the industry-level mapping table corresponding to the original mapping relationship.

3. The method of claim 1, wherein, The step of generating a second industry mapping table based on the first industry mapping table and the second original mapping table includes: Based on any two mapping relationships with the same search term in the first industry mapping table and the second original mapping table, generate one associated mapping relationship, and obtain multiple associated mapping relationships; the associated mapping relationship includes the industry category, the industry level to which the industry category belongs, and the mapping relationship between industry data; based on the multiple associated mapping relationships, generate the second industry mapping table.

4. The method of any one of claims 1-3, wherein, The aggregation of industry data in the second industry mapping table to obtain the target industry mapping table includes: The industry data corresponding to at least two mapping relationships with the same industry category in the second industry mapping table are merged to obtain the target industry mapping table.

5. The method according to any one of claims 1-3, wherein, The second original mapping table also includes a mapping relationship between query information and industry data; the query information includes at least one of geographic information and time information; the second industry mapping table also includes a mapping relationship between the query information and industry data, and the target industry mapping table also includes a mapping relationship between the query information and industry data; the geographic information is the geographical location of the user when performing the data search; the time information is the timestamp of the user when performing the data search; The aggregation of industry data in the second industry mapping table to obtain the target industry mapping table includes: The industry data corresponding to at least two mapping relationships with the same industry category and query information in the second industry mapping table are merged to obtain the target industry mapping table.

6. The method according to any one of claims 1-3, wherein, The industry data includes at least one of traffic data, sales amount, and sales quantity; the traffic data is used to represent users' attention to the corresponding industry; the sales amount refers to the sales amount of products in the corresponding industry; and the sales quantity refers to the sales quantity of products in the corresponding industry.

7. The method according to claim 5, wherein, The industry keywords also include at least one of the following: industry level, geographical information, and time information.

8. A data query device, comprising: The receiving module is used to receive data query requests from the terminal; The data query request carries industry keywords; the industry keywords include the industry category of the industry to be queried. The acquisition module is used to acquire industry data of the industry to be queried from the target industry mapping table based on the industry keywords; The sending module is used to send the industry data of the industry to be queried to the terminal; The processing module includes: A generation module is used to generate an industry-level mapping table corresponding to each of the multiple original mapping relationships included in the first original mapping table; the original mapping relationship includes the mapping relationship between a search term and a first category, and the original mapping relationship also includes the mapping relationship between the first category and the industry level to which the first category belongs, where the first category is the industry category to which the industry corresponding to the search term belongs; the industry-level mapping table includes the original mapping relationship and the corresponding progressive mapping relationship; the progressive mapping relationship includes the mapping relationship between the search term, a second category, and the industry level to which the second category belongs; the second category includes the first category; the industry level to which the second category belongs is higher than the industry level to which the first category belongs; The deduplication module is used to deduplicatize the industry-level mapping tables corresponding to the multiple original mapping relationships to obtain the first industry mapping table. The merging module is used to generate a second industry mapping table based on the first industry mapping table and the second original mapping table; the second original mapping table includes the mapping relationship between search terms and industry data; the second industry mapping table includes industry categories, the industry level to which the industry category belongs, and the mapping relationship between industry data. The determining module is used to aggregate the industry data in the second industry mapping table to obtain the target industry mapping table; the target industry mapping table includes the mapping relationship between industry categories and industry data, and also includes the mapping relationship between the industry level to which the industry category belongs and the industry data.

9. The apparatus according to claim 8, wherein, The generation module is used for: Based on the first category in the original mapping relationship, determine the second category corresponding to the first category; Based on the search terms in the original mapping relationship, the second category corresponding to the first category, and the industry level to which the second category belongs, a progressive mapping relationship is generated corresponding to the original mapping relationship. The original mapping relationship and the corresponding progressive mapping relationship are merged to obtain the industry-level mapping table corresponding to the original mapping relationship.

10. The apparatus according to claim 8, wherein, The merging module is used for: Based on any two mapping relationships with the same search term in the first industry mapping table and the second original mapping table, generate one associated mapping relationship, resulting in multiple associated mapping relationships; the associated mapping relationship includes industry category, industry level to which the industry category belongs, and mapping relationship between industry data; Based on the multiple associated mapping relationships, a second industry mapping table is generated.

11. The apparatus according to any one of claims 8-10, wherein, The determining module is used for: The industry data corresponding to at least two mapping relationships with the same industry category in the second industry mapping table are merged to obtain the target industry mapping table.

12. The apparatus according to any one of claims 8-10, wherein, The second original mapping table also includes a mapping relationship between query information and industry data; the query information includes at least one of geographic information and time information; the second industry mapping table also includes a mapping relationship between the query information and industry data, and the target industry mapping table also includes a mapping relationship between the query information and industry data; the geographic information is the geographical location of the user when performing the data search; the time information is the timestamp of the user when performing the data search; The determining module is used for: The industry data corresponding to at least two mapping relationships with the same industry category and query information in the second industry mapping table are merged to obtain the target industry mapping table.

13. The apparatus according to any one of claims 8-10, wherein, The industry data includes at least one of traffic data, sales amount, and sales quantity; the traffic data is used to represent users' attention to the corresponding industry; the sales amount refers to the sales amount of products in the corresponding industry; and the sales quantity refers to the sales quantity of products in the corresponding industry.

14. The apparatus according to claim 13, wherein, The industry keywords also include at least one of the following: industry level, geographical information, and time information.

15. An electronic device comprising: At least one processor; as well as A memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-7.

16. A non-transitory computer-readable storage medium storing computer instructions, wherein, The computer instructions are used to cause the electronic device to perform the method according to any one of claims 1-7.

17. A computer program product comprising a computer program that, when executed by a processor, implements the method of any one of claims 1-7.

Citation Information

Patent Citations

  • Multi-source data association query method and device and electronic equipment

    CN115344612A