WO2020147335A1

WO2020147335A1 - Method and system for clustering member data on electronic commerce platform

Info

Publication number: WO2020147335A1
Application number: PCT/CN2019/106863
Authority: WO
Inventors: 范东; 孙迁; 汪金忠
Original assignee: 苏宁云计算有限公司; 苏宁易购集团股份有限公司
Priority date: 2019-01-16
Filing date: 2019-09-20
Publication date: 2020-07-23
Also published as: CA3168300A1; CN111444165A; CN111444165B

Abstract

Provided are a method and system for clustering member data on an electronic commerce platform, capable of reducing consumption of memory and computation resources while ensuring precision of clustered member consumption data, thereby significantly enhancing the efficiency of clustering member consumption data. The method comprises: synchronizing member consumption data in a data warehouse to create a multiple-data model; generating multiple mutually different integer identifiers on the basis of member serial numbers in the data model, and storing mapping relationships between the member serial numbers and the integer identifiers in a dictionary table; generating a bitmap on the basis of one-to-one correspondence relationships between the integer identifiers and multiple latitude consumption fields in the member consumption data; and using the integer identifiers to perform, according to a query command of a user, a bit operation with respect to the multiple latitude consumption fields in the bitmap, and outputting a clustered result. The system comprises the method proposed in the above solution.

Description

Member data circle selection method and system for e-commerce platform

Technical field

The present invention relates to the technical field of data processing, and in particular to a method and system for circle selection of member data for an e-commerce platform.

Background technique

For e-commerce platforms, the analysis result of member consumption data is an important reference for planning promotional activities. In the analysis process of member consumption data, multi-dimensional circle selection of data is a key step to obtain member consumption data; in the prior art, Commonly used data circle selection methods include pre-summarization circle selection method (OLAP-Druid) and distributed memory computing circle selection method (SPARK). For OLAP-Druid circle selection method, it mainly uses HLL algorithm to consume members. Data is calculated and analyzed. The accuracy of the algorithm in deduplication business scenarios is often lost, so there is a problem of inaccurate membership consumption data circle selection results. For the SPARK circle selection method, it obtains the original consumption data of members and uses pull The detailed method puts the original consumption data in the memory of the distributed node for logical calculation, and finally obtains the result of member consumption data circle selection. In practical applications, it is found that due to the huge amount of original consumption data of members, although the latter circle selection method can To ensure the accuracy of the results of member consumption data circle selection, but it needs to consume more computing resources and memory resources, so there are defects of low circle selection efficiency and poor user experience.

Summary of the invention

The purpose of the present invention is to provide a member data circle selection method and system for an e-commerce platform, which can reduce the consumption of memory and computing resources while ensuring the accuracy of member consumption data circle selection results, and significantly improve the circle of member consumption data. Election efficiency.

In order to achieve the above objective, one aspect of the present invention provides a member data circle selection method for an e-commerce platform, including:

Create multiple data models by synchronizing member consumption data from the data warehouse;

Generating a plurality of different integer identifiers based on the member code in the data model, and storing the mapping relationship between the member code and the integer identifier in a dictionary table;

Generating a bitmap in one-to-one correspondence between the integer identifier and the multiple latitude consumption fields of the member consumption data;

Perform bit operations on multiple latitude consumption fields in the bit chart through integer identifiers according to the user's query instructions, and output the circled selection results.

Preferably, after the step of generating a bitmap by one-to-one correspondence between the integer identifier and the multiple latitude consumption fields of the member consumption data, the method further includes:

The field data in the bitmap is regularly supplemented and updated to generate a bitmap corresponding to the current time node.

Specifically, the step of periodically supplementing and updating the field data in the bitmap, and generating a bitmap corresponding to the current time node includes:

Obtain new member consumption data from the data warehouse based on the current time node and synchronize it to the data model;

According to the mapping relationship of the member code in the dictionary table, the corresponding field data in the newly added member consumption data is regularly supplemented into the bit chart according to the mapping relationship to realize the supplement and update of the bit chart.

Preferably, periodically supplementing and updating the field data in the bitmap, and generating the bitmap corresponding to the current time node further includes:

The bitmap is cleaned, and irrelevant latitude field data is removed.

Further, in the step, performing a bit operation on the multiple latitude consumption fields in the bit chart through the integer identifier according to the user's query instruction, and before outputting the circle selection result, it also includes:

Preset a variety of query instructions, and perform bit operations on the cleaned bit chart in advance to obtain pre-circling results matching multiple query instructions;

Store multiple pre-circle selection results in a temporary result table for user inquiries.

Preferably, according to the user's query instruction, the multiple latitude consumption fields in the bit chart are bitwise operated through the integer identifier, and the method of outputting the circled selection result includes:

Receiving a query instruction from a user, and determining that the query instruction is a preset query instruction;

When the judgment result is yes, directly match the corresponding pre-circle selection result output from the temporary result table. When the judgment result is no, perform logic on multiple latitude consumption fields through the integer identifier based on the updated bitmap After calculation, the result of circle selection is output.

Compared with the prior art, the member data circle selection method for e-commerce platforms provided by the present invention has the following beneficial effects:

The member data circle selection method for e-commerce platform provided by the present invention firstly obtains member consumption data from a data warehouse to create a data model. The data model includes member codes, multiple latitude consumption fields, and consumption dates. The codes are converted into integer identifiers one by one, and the mapping relationship between the integer identifier and the member code is stored in the dictionary table, and then the integer identifier, the consumption field and the consumption date are used to construct a bit chart, which is called after obtaining the user's query instruction The integer identifier performs logical bit operations on multiple latitude consumption fields in the bit chart, and finally obtains the circled result.

It can be seen that using the member data circle selection method for e-commerce platforms provided by the present invention, the member code is replaced by an integer identifier and the member consumption data is represented by a bitmap (bitmap table), so as to realize the circle selection of member data only through the bitmap The set bit operation in the table can be obtained, which can significantly improve the operation efficiency while reducing the computing resources and storage resources, and is especially suitable for the circle selection operation of massive member data.

Another aspect of the present invention provides a member data circle selection system for an e-commerce platform, which is applied to the member data circle selection method for an e-commerce platform described in the above technical solution, and the system includes:

The data model creation unit is used to synchronize member consumption data from the data warehouse to create multiple data models;

The dictionary table creation unit generates multiple different integer identifiers based on the member code in the data model, and saves the mapping relationship between the member code and the integer identifier in the dictionary table;

The bitmap generating unit is used to generate a bitmap by one-to-one correspondence between the integer identifier and the multiple latitude consumption fields of the member consumption data;

The query output unit is used to perform bit operations on multiple latitude consumption fields in the bit chart through integer identifiers according to the user's query instructions, and output the circle selection results.

Preferably, it further includes a bitmap updating unit connected to the bitmap generating unit;

The bitmap update unit is used to periodically supplement and update the field data in the bitmap, and generate a bitmap corresponding to the current time node.

Preferably, the bitmap update unit includes:

The data acquisition module is used to acquire new member consumption data from the data warehouse based on the current time node and synchronize it to the data model;

The bit chart update module is used to regularly add the corresponding field data in the newly added member consumption data into the bit chart according to the mapping relationship according to the mapping relationship of the member code in the dictionary table to realize the supplement and update of the bit chart.

Preferably, it further includes a data cleaning unit provided between the bitmap generating unit and the query output unit;

The data cleaning unit is used for cleaning the bitmap to eliminate irrelevant latitude field data.

Preferably, it further includes a pre-circle selection unit and a storage unit, the input end of the pre-circle selection unit is connected to the output end of the data cleaning unit, and the output end of the storage unit is connected to the input end of the query output unit ；

The pre-circle selection unit is used to preset a variety of query instructions, and perform bit operations on the cleaned bit graph in advance to obtain pre-circle selection results that match the multiple query instructions;

The storage unit is used to store various pre-circle selection results in a temporary result table for users to query.

Preferably, the query output unit includes:

The judgment module is used to receive a user's query instruction, and determine that the query instruction is a preset query instruction;

The output module is used to directly output the corresponding pre-circle selection results from the temporary result table when the judgment result is yes. When the judgment result is no, use the integer identifier to add the updated bit map to multiple The latitude consumption field performs logical operations and outputs the result of circle selection.

Compared with the prior art, the beneficial effects of the member data circle selection system for e-commerce platforms provided by the present invention are the same as the beneficial effects of the member data circle selection method for e-commerce platforms provided by the above technical solutions. Do repeat.

BRIEF DESCRIPTION

The drawings described here are used to provide a further understanding of the present invention and constitute a part of the present invention. The exemplary embodiments and descriptions of the present invention are used to explain the present invention, and do not constitute an improper limitation of the present invention. In the drawings:

FIG. 1 is a schematic flowchart of a member data circle selection method used on an e-commerce platform in Embodiment 1 of the present invention;

2 is an example diagram of circle selection results obtained by using a member data circle selection method for an e-commerce platform in Embodiment 1 of the present invention;

Figure 3 is an example diagram of bitmap_table_A statistical representation in the first embodiment of the present invention;

4 is an example diagram of the bitmap_table_B statistical representation in the first embodiment of the present invention;

Fig. 5 is a structural block diagram of a member data circle selection system for an e-commerce platform in the second embodiment of the present invention.

Reference mark:

1-Data model creation unit, 2-Dictionary table creation unit;

3-digit chart generation unit, 4-query output unit;

5-digit chart update unit, 6-data cleaning unit;

7-pre-circle selection unit, 8-storage unit;

41-Judgment module, 42-Output module;

51-Data acquisition module, 52-bit chart update module.

detailed description

In order to make the above objectives, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be described clearly and completely in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, but not all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by a person of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

Example one

Referring to FIG. 1, this embodiment provides a method for circle selection of member data for an e-commerce platform, including:

Synchronize member consumption data from the data warehouse to create a multi-data model; generate multiple different integer identifiers based on the member code in the data model, and save the mapping relationship between the member code and the integer identifier in the dictionary table; store the integer The identifier and the multiple latitude consumption fields of the member consumption data generate a bit chart in one-to-one correspondence; according to the user's query instruction, the multiple latitude consumption fields in the bit chart are bit-calculated through the integer identifier to output the circled selection result.

The member data circle selection method for e-commerce platform provided in this embodiment first obtains member consumption data from a data warehouse to create a data model. The data model includes member codes, multiple latitude consumption fields, and consumption dates. The member codes are converted into integer identifiers one by one, and the mapping relationship between the integer identifier and the member code is stored in the dictionary table, and then the integer identifier, consumption field and consumption date are used to construct a bitmap. After obtaining the user's query instruction Call the integer identifier to perform logical bit operations on multiple latitude consumption fields in the bit chart, and finally get the circled result.

It can be seen that using the member data circle selection method for the e-commerce platform provided in this embodiment, the member code is replaced by an integer identifier and the member consumption data is represented by a bitmap table, so that the circle selection of member data is only passed The set bit operation in the bitmap table can be obtained, which can significantly improve the operation efficiency while reducing the computing resources and storage resources. It is especially suitable for the circle selection operation of massive member data.

Please continue to refer to Figure 1. Considering that the member consumption data is constantly updated every day, in order to avoid the lag in the bit chart data, this embodiment corresponds to the integer identifier and the multiple latitude consumption fields of the member consumption data. After generating the bit chart, it also includes: regularly supplementing and updating the field data in the bit chart, and generating a bit chart corresponding to the current time node.

Specifically, the method for periodically supplementing and updating field data in the bitmap in the foregoing embodiment, and generating a bitmap corresponding to the current time node includes:

Obtain new member consumption data from the data warehouse based on the current time node and synchronize it to the data model; according to the mapping relationship of the member code in the dictionary table, the corresponding field data in the newly added member consumption data is added to the bit chart according to the mapping relationship on a regular basis , Realize the supplementary update of the bit chart.

In specific implementation, the updated member consumption data is periodically obtained from the data warehouse, and then the specified complement function is used to perform the complement operation based on the mapping relationship in the dictionary table to realize the supplementary update of the field data in the alignment chart; for convenience To understand the specific process of the supplementary update, the following is an example. First, obtain the updated member consumption data from the data model, and identify the member code in which the consumption data update occurs, and then use the dictionary table to convert the member code to obtain the matching Integer identifier, and then obtain the updated consumption field data of the day (flag=1) corresponding to the integer identifier and store it in the bitmap table, by comparing the consumption field data of the current day (flag=1) with the previous day (flag=2) Data integration of the statistical consumption field data is inserted into the bitmap table as the current (flag=2) statistical consumption field data to complete the supplementary update of the bitmap table. It should be noted that flag=1 only means the consumption field updated on the day Data, flag=2 represents all current consumption field data, which includes the consumption field data updated on the current day and all the consumption field data before the current day. Through the above implementation process, it can be seen that this embodiment does not need to perform repeated calculations on all historical data. It only needs to continuously update the consumption field data in the bitmap table by means of superposition and integration, so as to reduce the amount of calculation and ensure the accuracy of the circled results. Sex.

Optionally, please refer to FIG. 1. In the above embodiment, in the step, the field data in the bitmap is regularly supplemented and updated, and after the bitmap corresponding to the current time node is generated, it also includes: cleaning the bitmap, Eliminate irrelevant latitude field data.

In specific implementation, this step is equivalent to creating a CUBE model, which reduces the data base after group by after excluding field data of irrelevant dimensions in the bit chart, which can improve query efficiency and speed up circle selection.

In order to further speed up the circle selection speed, this embodiment performs bit operations on multiple latitude consumption fields in the bit chart through integer identifiers according to the user's query instructions. Before outputting the circle selection results, it also includes:

Pre-set a variety of query instructions, perform bit operations on the cleaned bit chart in advance to obtain pre-circle selection results matching multiple query instructions; store multiple pre-circle selection results in a temporary result table for user inquiries.

In specific implementation, considering the huge amount of field data in the bitmap, if real-time calculations are used, the output of the circled selection results will be delayed to a certain extent. In view of this, this embodiment pre-stores commonly used query instructions to make The system can perform bit operations on the cleaned bit map in advance according to these query instructions to obtain the corresponding pre-circle selection results, and store these pre-circle selection results in the temporary result table so that they can be directly called when the user queries.

Further, in the above-mentioned embodiment, the step of performing bit operations on the multiple latitude consumption fields in the bit chart through the integer identifier according to the user's query instruction, and the method of outputting the circle selection result includes:

Receive the user's query instruction, and determine whether the query instruction is a pre-stored query instruction; when the judgment result is yes, directly match the corresponding pre-circle selection result output from the temporary result table, and when the judgment result is no, it will be updated based on the supplement The bitmap of, performs logical operations on multiple latitude consumption fields through integer identifiers, and outputs the result of circle selection. It can be seen that by setting the above two calculation modes, when the query instruction sent by the user matches the pre-stored query instruction, the pre-circle selection result output can be directly called from the temporary result table, and the calculation waiting time can be reduced at this time. When the query command sent by the user cannot match the query command sent by the user, the updated bit chart can be logically calculated based on the query command to output the circled selection result, that is, the circled selection result can be output through real-time calculation and expanded. The user's query range is improved, and the user-defined multi-dimensional circle selection function is supported.

For ease of understanding, this embodiment takes the circle selection process of new and old member consumption data as an example. As shown in Figure 2, the member consumption data with the date of 0826 and 0827 is obtained from the data warehouse to create a data model. The model includes multiple latitudes of consumption fields such as membership code, shopping channel, shopping category, and shopping date. By calling the mapping relationship in the dictionary table, the membership code is converted into an integer identifier that is convenient for bitmap table operations. It is represented by the letters A, B, C, and D. After cleaning the bitmap chart, the consumption data bitmap_table_A of new and old members of different shopping channels are calculated. The statistical dimensions include shopping channels (online or offline) + tags ( flag = 1 or flag = 2) + shopping date (0826 or 0827), there will be two statistical information per day, one is the bitmap table collection of the members of the day (flag=1), and the other is the current (flag=2) members The bitmap table collection, secondly, you need to count the consumption data bitmap_table_B of new and old members whose latitude is shopping category + shopping channel + label (flag=1 or flag=2) + shopping date (0826 or 0827), and the daily statistical information is also available There are two, one is the bitmap table set of the members of the day (flag=1), and the other is the bitmap table set of the current (flag=2) members. Then circle the following three scenarios according to the query command func():

Scenario 1: The shopping date occurs on the bitmap_table_A corresponding to the new buyer on the 0827 line, as shown in Figure 3. The circle selection process is actually to perform the rb_andnot_cardinality bitmap operation on the bitmap set {A, D} and the bitmap set {A, C}. The circled result is {D}, and the number of new buyers counted is 1.

Scenario 2: The shopping date occurs at 0827. The bitmap_table_B corresponding to the new buyer of the online air conditioner is shown in Figure 4. The statistical shopping date occurs at 0827 for the new buyer of the online air conditioner. In fact, the bitmap collection {C,A} and the bitmap collection {C} Performing rb_andnot_cardinality bitwise operation, the circled result is {A}, and the number of new buyers counted is 1. In the same way, the online ice wash new buyer whose shopping date occurs at 0827 is actually a collection of bitmaps{ D} and the empty set of bitmap do rb_andnot_cardinality bit operation, the result of circle selection is {D}, and the number of new buyers counted is 1.

Scenario 3: How many of the new online air-conditioning buyers whose shopping date occurs at 0827 are online new buyers. In fact, bitmap_table_A and bitmap_table_B are used as rb_and_cardinality operations, that is, bitmap collection {A} and bitmap collection {A, C} Performing the rb_andnot_cardinality bit operation, the result of the circle selection is an empty set, and the number of new buyers counted is 0; similarly, how many new buyers are online ice wash new buyers whose shopping date occurs at 0827, in fact, it is Perform the rb_andnot_cardinality bitmap operation on the bitmap set {D} and the bitmap set {A, C}, the circled result is {D}, and the number of new buyers counted is 1.

Example 2

1 and 5, this embodiment provides a member data circle selection system for an e-commerce platform, including:

Data model creation unit 1, used to synchronize member consumption data from the data warehouse to create multiple data models;

The dictionary table creation unit 2 generates multiple different integer identifiers based on the member code in the data model, and saves the mapping relationship between the member code and the integer identifier in the dictionary table;

The bitmap generating unit 3 is used to generate a bitmap by one-to-one correspondence between the integer identifier and the multiple latitude consumption fields of the member consumption data;

The query output unit 4 is configured to perform bit operations on multiple latitude consumption fields in the bit chart through integer identifiers according to the user's query instructions, and output the circle selection results.

Preferably, it further includes a bitmap updating unit 6 connected to the bitmap generating unit 3, and the bitmap updating unit 6 is configured to periodically supplement and update the field data in the bitmap to generate a bitmap corresponding to the current time node.

Preferably, the bitmap updating unit 6 includes:

The data acquisition module 51 is used to acquire new member consumption data from the data warehouse based on the current time node, and synchronize it to the data model;

The bitmap update module 52 is used to periodically add the corresponding field data in the newly added member consumption data to the bitmap according to the mapping relationship according to the mapping relationship of the member code in the dictionary table, so as to realize the supplement and update of the bitmap.

Preferably, it further includes a data cleaning unit 6 provided between the bitmap generating unit 3 and the query output unit 4;

The data cleaning unit 6 is used to clean the bit chart, and eliminate irrelevant latitude field data.

Preferably, it further includes a pre-circle selection unit 7 and a storage unit 8. The input end of the pre-circle selection unit 7 is connected to the output end of the data cleaning unit 6, and the output end of the storage unit 8 is connected to the input end of the query output unit 4;

The pre-circle selection unit 7 is used to preset a variety of query instructions, and perform bit operations on the cleaned bit chart in advance to obtain pre-circle selection results that match the multiple query instructions;

The storage unit 8 is used to store various pre-circle selection results in a temporary result table for users to query.

Preferably, the query output unit 4 includes:

The judgment module 41 is used to receive a user's query instruction, and determine that the query instruction is a preset query instruction;

The output module 42 is used to directly output the matching pre-circle selection result from the temporary result table when the judgment result is yes, and when the judgment result is no, add the updated bit map based on the number of integer identifiers. After performing logical operations on each latitude consumption field, the circled selection result is output.

Compared with the prior art, the beneficial effects of the member data circle selection system for e-commerce platforms provided by the embodiment of the present invention are the same as the beneficial effects of the member data circle selection method for e-commerce platforms provided in the first embodiment. I will not repeat them here.

Those of ordinary skill in the art can understand that all or part of the steps in the above-mentioned inventive method can be implemented by a program instructing relevant hardware. The above-mentioned program can be stored in a computer readable storage medium. When the program is executed, it includes For each step of the method in the foregoing embodiment, the storage medium may be: ROM/RAM, magnetic disk, optical disk, memory card, etc.

The above are only the specific embodiments of the present invention, but the scope of protection of the present invention is not limited to this. Any person skilled in the art can easily think of changes or replacements within the technical scope disclosed by the present invention. It should be covered by the protection scope of the present invention. Therefore, the protection scope of the present invention should be subject to the protection scope of the claims.

Claims

A member data circle selection method for e-commerce platforms, characterized in that it includes:

Create multiple data models by synchronizing member consumption data from the data warehouse;

Generating a plurality of different integer identifiers based on the member code in the data model, and storing the mapping relationship between the member code and the integer identifier in a dictionary table;

Generating a bitmap in one-to-one correspondence between the integer identifier and the multiple latitude consumption fields of the member consumption data;

Perform bit operations on multiple latitude consumption fields in the bit chart through integer identifiers according to the user's query instructions, and output the circled selection results.
The method according to claim 1, wherein after the step of generating a bitmap by one-to-one correspondence between the integer identifier and the multiple latitude consumption fields of the member consumption data, the method further comprises:

The field data in the bitmap is regularly supplemented and updated to generate a bitmap corresponding to the current time node.
The method according to claim 2, wherein the step of periodically supplementing and updating field data in the bitmap, and generating a bitmap corresponding to the current time node comprises:

Obtain new member consumption data from the data warehouse based on the current time node and synchronize it to the data model;

According to the mapping relationship of the member code in the dictionary table, the corresponding field data in the newly added member consumption data is regularly supplemented into the bit chart according to the mapping relationship to realize the supplement and update of the bit chart.
The method according to claim 2, wherein in the step, periodically supplementing and updating the field data in the bitmap, and generating a bitmap corresponding to the current time node further comprises:

The bitmap is cleaned, and irrelevant latitude field data is removed.
The method according to claim 4, wherein the step of performing bit operations on the multiple latitude consumption fields in the bitmap through the integer identifier according to the user's query instruction, and before outputting the circled selection result, further comprises:

Preset a variety of query instructions, and perform bit operations on the cleaned bit chart in advance to obtain pre-circling results matching multiple query instructions;

Store multiple pre-circle selection results in a temporary result table for user inquiries.
The method according to claim 5, wherein the step of performing bit operations on multiple latitude consumption fields in the bitmap through integer identifiers according to the user's query instruction, and the method of outputting the circled selection results comprises:

Receiving a query instruction from a user, and determining that the query instruction is a preset query instruction;

When the judgment result is yes, directly match the corresponding pre-circle selection result output from the temporary result table, and when the judgment result is no, logically perform logic on multiple latitude consumption fields through the integer identifier based on the updated bitmap After calculation, the result of circle selection is output.
A member data circle selection system for an e-commerce platform is characterized in that it includes:

The data model creation unit is used to synchronize member consumption data from the data warehouse to create multiple data models;

The dictionary table creation unit generates multiple different integer identifiers based on the member code in the data model, and saves the mapping relationship between the member code and the integer identifier in the dictionary table;

A bitmap generating unit for generating a bitmap by one-to-one correspondence between the integer identifier and multiple latitude consumption fields of the member consumption data;

The query output unit is used to perform bit operations on multiple latitude consumption fields in the bit chart through integer identifiers according to the user's query instructions, and output the circle selection results.
The system according to claim 7, characterized in that it further comprises a bitmap updating unit connected to said bitmap generating unit;

The bitmap updating unit is used to periodically supplement and update the field data in the bitmap to generate a bitmap corresponding to the current time node.
The system according to claim 8, wherein the bitmap update unit comprises:

The data acquisition module is used to acquire new member consumption data from the data warehouse based on the current time node and synchronize it to the data model;

The bit chart update module is used to regularly add the corresponding field data in the newly added member consumption data into the bit chart according to the mapping relationship according to the mapping relationship of the member code in the dictionary table to realize the supplement and update of the bit chart.
8. The system according to claim 8, further comprising a data cleaning unit provided between the bitmap generating unit and the query output unit;

The data cleaning unit is used for cleaning the bitmap to eliminate irrelevant latitude field data.
The system according to claim 10, further comprising a pre-circle selection unit and a storage unit, the input end of the pre-circle selection unit is connected to the output end of the data cleaning unit, and the output end of the storage unit Connected to the input end of the query output unit;

The pre-circle selection unit is used to preset a variety of query instructions, and perform bit operations on the cleaned bit graph in advance to obtain pre-circle selection results that match the multiple query instructions;

The storage unit is used to store various pre-circle selection results in a temporary result table for users to query.
The system according to claim 11, wherein the query output unit comprises:

The judgment module is used to receive a user's query instruction, and determine that the query instruction is a preset query instruction;

The output module is used to directly output the corresponding pre-circle selection results from the temporary result table when the judgment result is yes, and when the judgment result is no, use the integer identifier to fill in the updated bit map to multiple The latitude consumption field performs logical operations and outputs the result of circle selection.