CN117251652B - Binary data mask label construction query method and device - Google Patents
Binary data mask label construction query method and device Download PDFInfo
- Publication number
- CN117251652B CN117251652B CN202311204739.XA CN202311204739A CN117251652B CN 117251652 B CN117251652 B CN 117251652B CN 202311204739 A CN202311204739 A CN 202311204739A CN 117251652 B CN117251652 B CN 117251652B
- Authority
- CN
- China
- Prior art keywords
- data
- condition
- mask
- query
- binary
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000010276 construction Methods 0.000 title claims abstract description 28
- 238000012216 screening Methods 0.000 claims abstract description 33
- 230000007717 exclusion Effects 0.000 claims description 10
- 230000008569 process Effects 0.000 claims description 8
- 230000000873 masking effect Effects 0.000 claims description 2
- 238000004590 computer program Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 7
- 230000008901 benefit Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 238000013500 data storage Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 230000006399 behavior Effects 0.000 description 2
- 125000004122 cyclic group Chemical group 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003213 activating effect Effects 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000001010 compromised effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000033764 rhythmic process Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/955—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL]
- G06F16/9554—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL] by using bar codes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9535—Search customisation based on user profiles and personalisation
Abstract
The invention discloses a binary data mask label construction query method and a binary data mask label construction query device, which are used for grouping and defining true/false of grouping values of labels concerned according to data screening requirements to obtain a query request; searching binary bits corresponding to the concerned tag groups according to the query request, and generating a data query condition; generating a concerned bit mask and an x condition mask respectively according to the data query condition; performing binary AND operation on the data and the concerned bit mask to generate operated data; and performing binary exclusive OR operation on the operated data and the x condition mask, searching the data with the operation result of 0, and screening out clients meeting the screening requirement. The scheme of the invention supports business personnel to flexibly screen the label grouping value while using a single column to store the labels of the non-mutually exclusive relation grouping, does not influence the query performance, and has better user experience.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a binary data mask label construction query method and apparatus.
Background
In the prior art, the sound volume of the refined operation is continuously improved, and compared with the process of adding a large amount of resources to promote and shape brand mind, the refined operation has the advantages of reducing the operation cost, improving the marketing efficiency, activating clients in the subdivision field and the like.
The refined operation mainly comprises a plurality of parts such as customer label system maintenance, customer grouping, marketing effect evaluation and the like, wherein the maintenance of the customer label system is a key step of constructing customer portraits so as to find target customer groups and advantage channels for carrying out accurate marketing.
The existing client tag system construction mode is to comb the service type, dimension level and whether the tag grouping of the client tag are in mutual exclusion relation, for example, the tags such as gender, age group and the like are in mutual exclusion relation at the client level, the tags such as signing channel class, interest class and behavior preference class are not in mutual exclusion relation at the client level, and the client possibly meets a plurality of conditions at the same time, so that the tag grouping uniqueness can only be ensured to be continuously overlapped with the tags such as signing channel 1, signing channel 2. Signing channel n and the like, and the method can continuously increase columns of a data table and influence the stability of the data table; or giving up the label management at the client level and constructing a label table with finer granularity, the method can generate excessive unnecessary data redundancy, influence data inquiry and increase storage pressure.
Under the condition of smaller data volume, modes such as continuously increasing labels or constructing label tables with finer granularity and the like cannot cause excessive technological construction difficulty, but when mass data are faced, the existing method can greatly influence the speed and flexibility of label construction, so that business requirements cannot be met rapidly, and finally marketing rhythm and marketing income are compromised.
In the prior art, the following problems and disadvantages mainly exist:
under the condition of massive data, the continuous increase of the tag columns can lead to continuous change of the data table structure, the corresponding efficiency of science and technology cannot keep pace with the speed of service requirement, the timeliness is poor, and the data query efficiency can be influenced by too many data columns.
In order to avoid the defects caused by adding too many columns, a plurality of tables are selected to be split to optimize the query efficiency, but when the method is used, if the labels are in the plurality of tables when a service party selects the labels, the service party still can influence the data query efficiency by carrying out a plurality of association operations or a plurality of queries, and the mode of selecting the labels by the service party becomes more inflexible.
It is desirable to build a more fine-grained tag table without adding too many columns, such as forgoing building behavior preference tags at the customer level, and instead designing preference tags at the transaction pipeline level to maintain mutually exclusive relationships between packets. The tag table is multiplied by the data volume compared with the client-level data, so that the storage pressure is multiplied, and the query efficiency is not guaranteed.
Under the condition of less grouping quantity, the binary data type can be used for storing label grouping, so that the number of columns is reduced, a label table with finer granularity is not required to be built for the label, and the data construction pressure and the query pressure are reduced. However, this method needs to match each group value one by one when inquiring and screening, and the service personnel cannot flexibly screen the required tag value when the number of groups is large.
Simulating the storage tag groupings using strings or arrays can also reduce the number of columns and fine-grained tag tables. Meanwhile, compared with the method for storing binary data types, the method does not need to match each grouping value one by one, and screening is more flexible. However, the intercepting query operation of the character strings and the data sets greatly influences the query performance, so that the user experience is poor.
Disclosure of Invention
The invention provides a binary data mask label construction query method and device, which are used for solving the problems of low query efficiency, inflexibility and low user satisfaction of label table data in the prior art, and supporting business personnel to flexibly screen label grouping values while storing non-mutually exclusive relation grouping labels by using a single column without influencing query performance.
According to an aspect of the present invention, there is provided a binary data mask tag construction query method including the steps of:
according to the screening requirement of the data, true/false of the grouping value is defined for the concerned label grouping to obtain a query request;
Searching binary bits corresponding to the concerned tag groups according to the query request, and generating a data query condition;
generating a concerned bit mask and an x condition mask respectively according to the data query condition;
performing binary AND operation on the data and the concerned bit mask to generate operated data;
And performing binary exclusive OR operation on the operated data and the x condition mask, searching the data with the operation result of 0, and screening out clients meeting the screening requirement.
The true/false of the packet value defined for the tag packet of interest further comprises:
Label packets that are not of interest are defined as ignored.
The searching binary bits corresponding to the concerned tag group according to the query request, generating a data query condition, includes:
according to the query request, searching binary bits corresponding to the concerned tag groups;
At the corresponding position, the true value is defined as 1, the false value is defined as 0, the rest of the packet values are defined as x, and the data query condition is generated.
The generating the concerned bit mask and the x condition mask according to the data query condition includes:
Setting x bits in the data query condition to 0, setting non-x bits to 1, and generating a concerned bit mask;
the x bits in the data query condition are set to 0, the non-x bits are unchanged, and an x condition mask is generated.
Further comprises:
according to the grouping query requirement, converting the grouping condition of the labels in each group into a binary query condition;
Circularly taking out two groups of label groups from the label grouping condition for comparison;
generating a concerned bit mask and an x condition mask according to the extracted label group;
Performing binary AND operation on the obtained two groups of concerned bit masks to obtain a comprehensive mask;
performing binary AND operation on the x condition masks and the comprehensive masks of the two groups of label groups to obtain respective matching results;
and performing binary exclusive OR operation on the two groups of obtained matching results, wherein if the result is 0, the two groups of tag grouping conditions are not mutually exclusive, and if the result is not 0, the two groups of tag grouping conditions are mutually exclusive.
The method further comprises the steps of:
And when the conditions of circularly extracting the label groups are pairwise compared, the condition of non-mutual exclusion is not found, and all the label groups are compared and completed, the cycle is ended.
The method further comprises the steps of:
in the cycle comparison process, if the condition that the two groups of label grouping conditions are not mutually exclusive is found, the cycle is interrupted, and the existence of the condition which is not mutually exclusive is prompted.
According to another aspect of the present invention, there is provided a binary data mask tag construction inquiry apparatus including:
The data query request unit is used for grouping the labels concerned according to the screening requirement of the data to define the true/false of the grouping value so as to obtain a query request;
The data query condition unit is used for searching binary bits corresponding to the concerned tag groups according to the query request and generating data query conditions;
a mask generating unit for generating a concerned bit mask and an x condition mask according to the data query condition, respectively;
The masking operation unit is used for performing binary AND operation on the data and the concerned bit mask to generate operated data;
And the matching operation unit is used for carrying out binary exclusive OR operation on the operated data and the x condition mask, searching the data with the operation result of 0, and screening out clients meeting the screening requirement.
The data query condition unit is specifically used for searching binary bits corresponding to the concerned tag groups according to the query request; at the corresponding position, the true value is defined as 1, the false value is defined as 0, and the rest of the packet values are defined as x, so as to generate a data query condition;
the mask generation unit is specifically configured to set x bits in a data query condition to 0, set non-x bits to 1, and generate a focused bit mask; the x bits in the data query condition are set to 0, the non-x bits are unchanged, and an x condition mask is generated.
The system also comprises a mutually exclusive grouping query unit, a grouping query unit and a query unit, wherein the mutually exclusive grouping query unit is used for converting the grouping condition of the labels in each group into a binary query condition according to the grouping query requirement; circularly taking out two groups of label groups from the label grouping condition for comparison; generating a concerned bit mask and an x condition mask according to the extracted label group; performing binary AND operation on the obtained two groups of concerned bit masks to obtain a comprehensive mask; performing binary AND operation on the x condition masks and the comprehensive masks of the two groups of label groups to obtain respective matching results; and performing binary exclusive OR operation on the two groups of obtained matching results, wherein if the result is 0, the two groups of tag grouping conditions are not mutually exclusive, and if the result is not 0, the two groups of tag grouping conditions are mutually exclusive.
By adopting the technical scheme of the invention, a binary data mask label construction query scheme is provided, true/false of a packet value is defined for the concerned label group according to the screening requirement of data, and a query request is obtained; searching binary bits corresponding to the concerned tag groups according to the query request, and generating a data query condition; generating a concerned bit mask and an x condition mask respectively according to the data query condition; performing binary AND operation on the data and the concerned bit mask to generate operated data; and performing binary exclusive OR operation on the operated data and the x condition mask, searching the data with the operation result of 0, and screening out clients meeting the screening requirement.
The scheme of the invention supports business personnel to flexibly screen the label grouping value while using a single column to store the labels of the non-mutually exclusive relation grouping, does not influence the query performance, and has better user experience. The scheme of the invention supports flexible inquiry and mutual exclusion grouping inquiry of the binary storage type label field, simplifies the operation complexity of analysis by using the label by service personnel, and improves the usability of the binary storage type label. The usability of the binary storage type label is improved, and the binary storage type label is constructed under mass data to be better selected than the modes of adding label columns, constructing a fine granularity label table, constructing character strings/array labels and the like. The method improves the possibility of constructing binary storage type labels, reduces the cost of data storage and query, is more convenient for scientific and technological staff to optimize label system data, finally effectively supports business requirements and improves overall benefits.
The technical scheme of the invention is further described in detail through the drawings and the embodiments.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
FIG. 1 is a schematic flow chart of a binary data mask tag construction query method in an embodiment of the invention;
FIG. 2 is a flow chart of a method for mutually exclusive packet querying based on a binary mask in an embodiment of the invention;
Fig. 3 is a schematic diagram of a binary data mask tag construction query device according to an embodiment of the present invention.
Detailed Description
The preferred embodiments of the present invention will be described below with reference to the accompanying drawings, it being understood that the preferred embodiments described herein are for illustration and explanation of the present invention only, and are not intended to limit the present invention.
The embodiment of the invention provides a method for constructing and inquiring labels based on binary data storage and mask mode, which uses a single column to store labels of non-mutually exclusive relation groups, supports business personnel to flexibly screen label group values, does not influence inquiring performance, and has better user experience.
Fig. 1 is a flowchart of a binary data mask tag construction query method according to an embodiment of the present invention. As shown in fig. 1, the binary data mask tag construction query method flow includes the following steps:
and 101, defining true/false of the packet value for the concerned tag packet according to the screening requirement of the data, and obtaining a query request.
In the embodiment of the invention, true/false of the packet value is defined for the concerned label packet according to the screening requirement, and the label packet which is not concerned is defined to be ignored.
Step 102, searching binary bits corresponding to the concerned tag group according to the query request, and generating a data query condition.
In the embodiment of the invention, according to the defined query request, binary bits corresponding to the concerned tag group are searched, a true value is defined as 1, a false value is defined as 0, and the rest group values are defined as x, so as to generate a data query condition.
For example, the original tags have 10 groups, the screening requirement is subscription channel 1 (bit 1), subscription channel 2 (bit 2), not subscription channel 3 (bit 4), and the rest of channels are not concerned, and the query condition xxxxx0x11 is generated.
And 103, respectively generating a concerned bit mask and an x condition mask according to the data query condition.
In the embodiment of the invention, x bits in the data query condition are set to 0, and non-x bits are set to 1, so as to generate the concerned bit mask. For example, xxxxxx0x11 described above is converted to 0000001011.
The x bits in the data query condition are set to 0, the non-x bits are unchanged, and an x condition mask is generated. For example, xxxx0x11 is converted to 0000000011.
Step 104, performing binary AND operation on the data and the concerned bit mask to generate the operated data.
For example, the source data is client A-0100110111, client B-0000000010, client C-1110011011, and the attention bit mask is computed to obtain client A-0000000011, client B-0000000010, and client C-0000001011.
And 105, performing binary exclusive OR operation on the operated data and the x condition mask, searching the data with the operation result of 0, and screening out clients meeting the screening requirement.
For example, the client A-0000000011, client B-0000000010, client C-0000001011 and the x-condition mask obtained from the previous process are operated to obtain the client A-result value 0, the client B-result value 1, the client C-result value 8, and the client A meets the screening requirement.
In an embodiment of the present invention, as shown in fig. 2, a flowchart of a method for mutually exclusive packet querying based on a binary mask is provided, where,
Grouping condition generation flow: the label grouping screening conditions in each group are converted into binary query conditions according to the grouping query requirements. For example: group 1-subscription channel 1, others ignored; group 2-no subscription channel 1, subscription channel 2, other ignores; group 3-subscription channel 3, others ignore. Group 1-xxxxxxxx 1, group 2-xxxxxxxx 10, group 3-xxxxxxxx 1xx are obtained from the group.
Cycle alignment begins: two groups were cyclically taken out of the grouping conditions for the following comparison.
Generating a packet conditional binary mask: from the fetched packets, a bit mask of interest and an x-condition mask are generated. For example: group 1 attention bit mask-0000000001, group 1 x condition mask-0000000001, group 2 attention bit mask-0000000011, group 2 x condition mask-0000000010.
Attention bit mask logic operation: and performing binary AND operation on the concerned bit mask obtained in the previous process to obtain a new comprehensive mask. For example: the 1 st group attention bit mask-0000000001 and the 2 nd group attention bit mask-0000000011 are operated to obtain the comprehensive mask-0000000001.
X condition comprehensive matching operation: and performing binary AND operation on the x condition masks of the grouping conditions and the comprehensive masks to obtain respective matching results. For example: the 1 st group x condition mask-0000000001, the 2 nd group x condition mask-0000000010, and the comprehensive mask obtained by the previous flow are operated to obtain the 1 st group matching result-0000000001 and the 2 nd group matching result-0000000000.
Matching operation results: and performing binary exclusive OR operation on the matching result obtained in the previous process, wherein if the result is 0, the two sets of conditions are not mutually exclusive, and if the result is not 0, the two sets of conditions are mutually exclusive. For example: the 1 st group matching result-0000000001 and the 2 nd group matching result-0000000000 are operated, and the result is1, so that the two groups of grouping conditions are mutually exclusive.
Cycle alignment is finished: the cyclic comparison has two ending methods, one is that the non-mutual exclusion condition is not found when the cyclic extraction grouping conditions are compared pairwise, and all the grouping is compared and completed, and the cycle is ended; secondly, in the cycle comparison process, if the condition that two groups are not mutually exclusive is found, the cycle is interrupted, and the user is reminded of the existence of the condition of non-mutually exclusive.
In the embodiment of the invention, the labels of the non-mutually exclusive relation groups are stored by using a single column, meanwhile, service personnel are supported to flexibly screen the label group values, the inquiry performance is not influenced, and the user experience is better. The scheme of the invention supports flexible inquiry and mutual exclusion grouping inquiry of the binary storage type label field, simplifies the operation complexity of analysis by using the label by service personnel, and improves the usability of the binary storage type label. The usability of the binary storage type label is improved, and the binary storage type label is constructed under mass data to be better selected than the modes of adding label columns, constructing a fine granularity label table, constructing character strings/array labels and the like. The method improves the possibility of constructing binary storage type labels, reduces the cost of data storage and query, is more convenient for scientific and technological staff to optimize label system data, finally effectively supports business requirements and improves overall benefits.
In order to implement the above-mentioned flow, the technical solution of the present invention further provides a binary data mask tag construction query device, as shown in fig. 3, where the binary data mask tag construction query device includes:
a data query request unit 21, configured to group the tags of interest according to the screening requirement of the data to define true/false of the packet value, and obtain a query request;
a data query condition unit 22, configured to search binary bits corresponding to the tag packet of interest according to the query request, and generate a data query condition;
A mask generating unit 23 for generating a bit mask of interest and an x-condition mask, respectively, according to the data query condition;
A mask operation unit 24 for performing binary and operation on the data and the attention bit mask to generate operated data;
And the matching operation unit 25 is used for performing binary exclusive-or operation on the operated data and the x condition mask, searching the data with the operation result of 0, and screening out clients meeting the screening requirement.
The data query condition unit 22 is specifically configured to search binary bits corresponding to the tag packet of interest according to a query request; at the corresponding position, the true value is defined as 1, the false value is defined as 0, and the rest of the packet values are defined as x, so as to generate a data query condition;
the mask generating unit 23 is specifically configured to set x bits to 0 and non-x bits to 1 in the data query condition, and generate a focused bit mask; the x bits in the data query condition are set to 0, the non-x bits are unchanged, and an x condition mask is generated.
The device further comprises a mutually exclusive grouping query unit 26, which is used for converting the grouping condition of the labels in each group into a binary query condition according to the grouping query requirement; circularly taking out two groups of label groups from the label grouping condition for comparison; generating a concerned bit mask and an x condition mask according to the extracted label group; performing binary AND operation on the obtained two groups of concerned bit masks to obtain a comprehensive mask; performing binary AND operation on the x condition masks and the comprehensive masks of the two groups of label groups to obtain respective matching results; and performing binary exclusive OR operation on the two groups of obtained matching results, wherein if the result is 0, the two groups of tag grouping conditions are not mutually exclusive, and if the result is not 0, the two groups of tag grouping conditions are mutually exclusive.
In summary, the technical scheme of the invention provides a binary data mask label construction query scheme, which is to define true/false of a packet value for a concerned label packet according to the screening requirement of data to obtain a query request; searching binary bits corresponding to the concerned tag groups according to the query request, and generating a data query condition; generating a concerned bit mask and an x condition mask respectively according to the data query condition; performing binary AND operation on the data and the concerned bit mask to generate operated data; and performing binary exclusive OR operation on the operated data and the x condition mask, searching the data with the operation result of 0, and screening out clients meeting the screening requirement.
The scheme of the invention supports business personnel to flexibly screen the label grouping value while using a single column to store the labels of the non-mutually exclusive relation grouping, does not influence the query performance, and has better user experience. The scheme of the invention supports flexible inquiry and mutual exclusion grouping inquiry of the binary storage type label field, simplifies the operation complexity of analysis by using the label by service personnel, and improves the usability of the binary storage type label. The usability of the binary storage type label is improved, and the binary storage type label is constructed under mass data to be better selected than the modes of adding label columns, constructing a fine granularity label table, constructing character strings/array labels and the like. The method improves the possibility of constructing binary storage type labels, reduces the cost of data storage and query, is more convenient for scientific and technological staff to optimize label system data, finally effectively supports business requirements and improves overall benefits.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, magnetic disk storage, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.
Claims (8)
1. A binary data mask tag construction query method, comprising the steps of:
according to the screening requirement of the data, true/false of the grouping value is defined for the concerned label grouping to obtain a query request;
Searching binary bits corresponding to the concerned tag groups according to the query request, and generating a data query condition;
generating a concerned bit mask and an x condition mask respectively according to the data query condition;
performing binary AND operation on the data and the concerned bit mask to generate operated data;
Performing binary exclusive OR operation on the operated data and the x condition mask, searching the data with the operation result of 0, and screening out clients meeting the screening requirement;
Further comprises:
according to the grouping query requirement, converting the grouping condition of the labels in each group into a binary query condition;
Circularly taking out two groups of label groups from the label grouping condition for comparison;
generating a concerned bit mask and an x condition mask according to the extracted label group;
Performing binary AND operation on the obtained two groups of concerned bit masks to obtain a comprehensive mask;
performing binary AND operation on the x condition masks and the comprehensive masks of the two groups of label groups to obtain respective matching results;
and performing binary exclusive OR operation on the two groups of obtained matching results, wherein if the result is 0, the two groups of tag grouping conditions are not mutually exclusive, and if the result is not 0, the two groups of tag grouping conditions are mutually exclusive.
2. The binary data mask tag construction query method according to claim 1, wherein the true/false of the packet value is defined for the tag packet of interest, further comprising:
Label packets that are not of interest are defined as ignored.
3. The binary data mask tag construction query method according to claim 1, wherein the searching binary bits corresponding to the tag group of interest according to the query request, generating the data query condition, includes:
according to the query request, searching binary bits corresponding to the concerned tag groups;
At the corresponding position, the true value is defined as 1, the false value is defined as 0, the rest of the packet values are defined as x, and the data query condition is generated.
4. The binary data mask tag construction query method according to claim 1, wherein the generating the attention bit mask and the x condition mask according to the data query condition, respectively, comprises:
Setting x bits in the data query condition to 0, setting non-x bits to 1, and generating a concerned bit mask;
the x bits in the data query condition are set to 0, the non-x bits are unchanged, and an x condition mask is generated.
5. The binary data mask tag construction query method according to claim 1, further comprising:
And when the conditions of circularly extracting the label groups are pairwise compared, the condition of non-mutual exclusion is not found, and all the label groups are compared and completed, the cycle is ended.
6. The binary data mask tag construction query method according to claim 5, further comprising:
in the cycle comparison process, if the condition that the two groups of label grouping conditions are not mutually exclusive is found, the cycle is interrupted, and the existence of the condition which is not mutually exclusive is prompted.
7. A binary data mask tag construction inquiry apparatus, comprising:
The data query request unit is used for grouping the labels concerned according to the screening requirement of the data to define the true/false of the grouping value so as to obtain a query request;
The data query condition unit is used for searching binary bits corresponding to the concerned tag groups according to the query request and generating data query conditions;
a mask generating unit for generating a concerned bit mask and an x condition mask according to the data query condition, respectively;
The masking operation unit is used for performing binary AND operation on the data and the concerned bit mask to generate operated data;
the matching operation unit is used for carrying out binary exclusive OR operation on the operated data and the x condition mask, searching the data with the operation result of 0, and screening out clients meeting the screening requirement;
the mutual exclusion grouping query unit is used for converting the grouping conditions of the tags in each group into binary query conditions according to the grouping query requirements; circularly taking out two groups of label groups from the label grouping condition for comparison; generating a concerned bit mask and an x condition mask according to the extracted label group; performing binary AND operation on the obtained two groups of concerned bit masks to obtain a comprehensive mask; performing binary AND operation on the x condition masks and the comprehensive masks of the two groups of label groups to obtain respective matching results; and performing binary exclusive OR operation on the two groups of obtained matching results, wherein if the result is 0, the two groups of tag grouping conditions are not mutually exclusive, and if the result is not 0, the two groups of tag grouping conditions are mutually exclusive.
8. The binary data mask tag construction query device according to claim 7, wherein the data query condition unit is specifically configured to search binary bits corresponding to a tag packet of interest according to a query request; at the corresponding position, the true value is defined as 1, the false value is defined as 0, and the rest of the packet values are defined as x, so as to generate a data query condition;
the mask generation unit is specifically configured to set x bits in a data query condition to 0, set non-x bits to 1, and generate a focused bit mask; the x bits in the data query condition are set to 0, the non-x bits are unchanged, and an x condition mask is generated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311204739.XA CN117251652B (en) | 2023-09-18 | 2023-09-18 | Binary data mask label construction query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311204739.XA CN117251652B (en) | 2023-09-18 | 2023-09-18 | Binary data mask label construction query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117251652A CN117251652A (en) | 2023-12-19 |
| CN117251652B true CN117251652B (en) | 2024-04-30 |
Family
ID=89136253
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311204739.XA Active CN117251652B (en) | 2023-09-18 | 2023-09-18 | Binary data mask label construction query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117251652B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107862067A (en) * | 2017-11-17 | 2018-03-30 | 中国银行股份有限公司 | A kind of screening technique and device of bank loan data query |
| CN112184321A (en) * | 2020-10-12 | 2021-01-05 | 郝晨曦 | Method, device and system for quickly screening client data |
| CN113849523A (en) * | 2021-09-28 | 2021-12-28 | 天元大数据信用管理有限公司 | Data query method, equipment and medium |
| CN114328632A (en) * | 2021-12-06 | 2022-04-12 | 大箴(杭州)科技有限公司 | User data analysis method and device based on bitmap and computer equipment |
| CN114490656A (en) * | 2022-01-26 | 2022-05-13 | 阿里云计算有限公司 | Data query method, device, equipment and storage medium |
-
2023
- 2023-09-18 CN CN202311204739.XA patent/CN117251652B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107862067A (en) * | 2017-11-17 | 2018-03-30 | 中国银行股份有限公司 | A kind of screening technique and device of bank loan data query |
| CN112184321A (en) * | 2020-10-12 | 2021-01-05 | 郝晨曦 | Method, device and system for quickly screening client data |
| CN113849523A (en) * | 2021-09-28 | 2021-12-28 | 天元大数据信用管理有限公司 | Data query method, equipment and medium |
| CN114328632A (en) * | 2021-12-06 | 2022-04-12 | 大箴(杭州)科技有限公司 | User data analysis method and device based on bitmap and computer equipment |
| CN114490656A (en) * | 2022-01-26 | 2022-05-13 | 阿里云计算有限公司 | Data query method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117251652A (en) | 2023-12-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106959965B (en) | Information processing method and server | |
| CN108959386A (en) | Distributed globally unique ID generation method, device, equipment and storage medium | |
| EP3767483A1 (en) | Method, device, system, and server for image retrieval, and storage medium | |
| CN105653700A (en) | Video search method and system | |
| CN105630972A (en) | Data processing method and device | |
| CN104685497A (en) | Hardware implementation of the aggregation/group by operation: filter method | |
| CN112347377B (en) | IP address field searching method, service scheduling method, device and electronic equipment | |
| US20180307743A1 (en) | Mapping method and device | |
| CN109657080B (en) | Distributed processing method/system and medium for high-resolution satellite remote sensing data | |
| CN102006174B (en) | Data processing method and device based on online behavior of mobile phone user | |
| CN100579133C (en) | Method for generating ID symbol | |
| CN105808581B (en) | Data clustering method and device and Spark big data platform | |
| CN104484392A (en) | Method and device for generating database query statement | |
| CN114820080A (en) | User grouping method, system, device and medium based on crowd circulation | |
| CN110210506A (en) | Characteristic processing method, apparatus and computer equipment based on big data | |
| CN111339088A (en) | Database division and table division method, device, medium and computer equipment | |
| CN117251652B (en) | Binary data mask label construction query method and device | |
| Wang et al. | Fastsgg: Efficient social graph generation using a degree distribution generation model | |
| CN101635001A (en) | Method and apparatus for extracting information from a database | |
| JP7116786B2 (en) | Cold matching with automatic content recognition | |
| CN115098738A (en) | Service data extraction method and device, storage medium and electronic equipment | |
| CN109992687B (en) | Face data searching method and device, electronic equipment and readable storage medium | |
| CN113656410A (en) | Order storage method and related device | |
| US20180046656A1 (en) | Constructing filterable hierarchy based on multidimensional key | |
| CN112835896A (en) | Real-time database data hotspot balancing method, device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant |