CN112749200A - Crowd screening method and device - Google Patents

Crowd screening method and device Download PDF

Info

Publication number
CN112749200A
CN112749200A CN202011518720.9A CN202011518720A CN112749200A CN 112749200 A CN112749200 A CN 112749200A CN 202011518720 A CN202011518720 A CN 202011518720A CN 112749200 A CN112749200 A CN 112749200A
Authority
CN
China
Prior art keywords
screening
conditions
condition
crowd
label
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.)
Pending
Application number
CN202011518720.9A
Other languages
Chinese (zh)
Inventor
刘译璟
高体伟
杜晓梦
徐若萱
黄腾
赖太阳
张银虎
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Percent Technology Group Co ltd
Original Assignee
Beijing Percent Technology Group Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Percent Technology Group Co ltd filed Critical Beijing Percent Technology Group Co ltd
Priority to CN202011518720.9A priority Critical patent/CN112749200A/en
Publication of CN112749200A publication Critical patent/CN112749200A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2457Query processing with adaptation to user needs
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2452Query translation
    • G06F16/24522Translation of natural language queries to structured queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results

Abstract

The application discloses a crowd screening method and a device, wherein the method comprises the following steps: obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition; performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query; and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups. According to the technical scheme, the crowd is inquired based on the label condition in the screening condition, and then further screening is carried out based on the filtering condition in the screening condition, so that the time length of the whole crowd screening period can be shortened, and the crowd screening efficiency is improved.

Description

Crowd screening method and device
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and an apparatus for crowd screening.
Background
At present, in many application scenes, groups of people are screened and subdivided based on screening conditions, so that the groups of people meeting the conditions are obtained. For example, in a product recommendation scenario, a target group interested in a certain type of product is screened from the group, so that a corresponding type of product can be recommended to the target group, and accurate recommendation of the product is realized.
Generally, when performing crowd screening, a plurality of target crowds are usually required to be screened according to a plurality of different screening conditions, wherein when performing crowd screening based on a plurality of different screening conditions, crowd screening is usually performed on each screening condition individually, and then a plurality of target crowds corresponding to the plurality of screening conditions one to one are obtained. However, in practical applications, the population screening method can result in a long time of the whole screening period, and the screening efficiency of the population is seriously affected.
Disclosure of Invention
The embodiment of the application provides a crowd screening method and device, which are used for solving the problem that the time of the whole screening period is long when the crowd screening is carried out based on a plurality of screening conditions at present.
In order to solve the above technical problem, the embodiment of the present application is implemented as follows:
in a first aspect, a method for crowd screening is provided, including:
obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query;
and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
In a second aspect, a crowd screening apparatus is provided, comprising:
the system comprises an acquisition unit, a processing unit and a display unit, wherein the acquisition unit is used for acquiring a plurality of screening conditions for population screening, any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
the query unit is used for performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds which are in one-to-one correspondence with the plurality of label conditions, wherein the same label condition corresponds to one crowd query;
and a determining unit configured to determine a plurality of target groups corresponding to the plurality of filtering conditions one-to-one based on the plurality of filtering conditions included in the plurality of filtering conditions and the plurality of first groups.
In a third aspect, an electronic device is provided, which includes:
a processor; and
a memory arranged to store computer executable instructions that, when executed, cause the processor to:
obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query;
and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
In a fourth aspect, a computer-readable storage medium is presented, the computer-readable storage medium storing one or more programs that, when executed by an electronic device comprising a plurality of application programs, cause the electronic device to perform the method of:
obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query;
and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
The embodiment of the application adopts at least one technical scheme which can achieve the following beneficial effects:
when the crowd screening is carried out based on a plurality of screening conditions, firstly, the crowd inquiry can be carried out based on a plurality of label conditions included in the screening conditions to obtain a plurality of first crowds which are in one-to-one correspondence with the plurality of label conditions, wherein the same label condition only carries out the crowd inquiry once; after the plurality of first people groups are obtained through query, a plurality of target people groups corresponding to the plurality of screening conditions one to one can be further obtained based on the plurality of first people groups and the plurality of filtering conditions in the plurality of screening conditions. Because the label conditions in the multiple screening conditions are usually overlapped, when people are screened, people query based on the screening conditions is replaced by people query based on the label conditions, and the same label conditions are used for people query only once, so that the times of people query can be reduced, and the time of people query is further reduced; after the plurality of first groups are obtained, the plurality of first groups can be further screened based on the filtering conditions in the screening conditions, so that a plurality of target groups corresponding to the plurality of screening conditions one to one can be obtained. Therefore, the time length of the whole crowd screening period can be reduced while a plurality of target crowds are obtained, and the crowd screening efficiency is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only some embodiments described in the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without any creative effort.
FIG. 1 is a schematic illustration of a visualization window according to one embodiment of the prior art;
FIG. 2 is a schematic flow chart diagram of a population screening method according to an embodiment of the present application;
FIG. 3 is a schematic illustration of a screening condition visualized by an embodiment of the present application;
FIG. 4 is a schematic illustration of a tag condition template according to an embodiment of the present application;
FIG. 5 is a schematic illustration of a list of crowd conditions according to an embodiment of the present application;
FIG. 6 is a schematic diagram of an embodiment of the present application storing a list of a plurality of first persons;
FIG. 7 is a diagram of a list of people who match a list of people conditions with a list for storing a plurality of first people, according to an embodiment of the present application;
FIG. 8 is a schematic flow chart diagram of a population screening method according to an embodiment of the present application;
FIG. 9 is a schematic structural diagram of an electronic device according to an embodiment of the present application;
fig. 10 is a schematic structural diagram of a crowd screening device according to an embodiment of the present application.
Detailed Description
In order to make those skilled in the art better understand the technical solutions in the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
At present, when people are screened, service personnel who need to screen people can select screening conditions, and then people are screened based on the screening conditions.
In a typical application scenario, the system for crowd screening can provide a visual window for business personnel, the business personnel can select a screening condition in the visual window, the system converts the screening condition selected by the business personnel into an SQL statement, and performs retrieval and query based on the SQL statement, and after a target crowd is queried, the target crowd is saved, so that the purpose of crowd screening is achieved.
Please refer to fig. 1. Fig. 1 is a visual window for crowd management provided by a system for crowd screening to service personnel, a user label is displayed on the left side of the window, the user label comprises a plurality of service columns such as a house property state, a property state and the like, wherein the column in the demographic comprises three options of basic information, a user identity and a mobile phone number attribution, after clicking the option of the basic information, the options of a channel source, a nationality, a gender and the like can be displayed in the middle area of the window, the service personnel can select the options, and obtain three label conditions of 'gender including male', 'year including 80, after 90' and 'whether there is a car and the like' on the right side of the window, in addition, options of a service domain are displayed on the right side of the window, the service personnel can select the service domain to further obtain a screening condition, the system converts the screening condition into an SQL statement, queries the target population based on the SQL statement, and stores the target population after the target population is obtained through query.
Generally, when people are screened, people are usually screened according to a plurality of different screening conditions to obtain a plurality of target people corresponding to the plurality of screening conditions one to one, and people are independently screened among the different screening conditions, however, the people screening method can lead to a long time of the whole screening period and seriously affect the screening efficiency of people.
For example, assuming that there are n screening conditions and n target populations need to be screened, the duration of the whole screening period is: T-T1 + T2+ T3+ … … + tn, wherein T isi(i-1, 2, … …, n) is the length of screening time required for a single target population.
It can be seen from the above formula of T that, when performing crowd screening, the duration of the whole screening period is equal to the sum of the screening durations of the individual target crowds, and when the number n of the target crowds needing to be screened increases, the duration of the whole screening period also increases linearly with the number n of the crowds.
Therefore, the current crowd screening method has the problems of long time of the whole screening period and low crowd screening efficiency.
In view of this, the embodiment of the present application provides a crowd screening method and apparatus, where the method includes: obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition; performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query; and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
Because the label conditions in the multiple screening conditions are usually overlapped, when people are screened, people query based on the screening conditions is replaced by people query based on the label conditions, and the same label conditions are used for people query only once, so that the times of people query can be reduced, and the time of people query is further reduced; after the plurality of first groups are obtained, the plurality of first groups can be further screened based on the filtering conditions in the screening conditions, so that a plurality of target groups corresponding to the plurality of screening conditions one to one can be obtained. Therefore, the time length of the whole crowd screening period can be reduced while a plurality of target crowds are obtained, and the crowd screening efficiency is improved.
The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.
Fig. 2 is a schematic flow chart of a population screening method according to an embodiment of the present application. The execution subject of the present embodiment may be a system for performing crowd screening (hereinafter, referred to as a system), and the method is described below.
S202: the method comprises the steps of obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the screening conditions comprise at least two screening conditions with the same label condition.
In performing crowd screening, the system may obtain a plurality of screening conditions for performing crowd screening, where each screening condition may include a tag condition and a filter condition.
The label condition may be understood as a user label or a user image, and may specifically be a gender, an age, a city, a personal preference, and the like of the user, which are not illustrated one by one herein; the filtering condition may be understood as other conditions except for the user tag when performing crowd filtering, for example, in an application scenario of a typical enterprise operation management, the filtering condition may be a service domain filtering condition, where a service domain is a range division of the enterprise operation management, for example, a national service may be divided into several large areas, or a division may be established in provinces, cities, or a division may be performed in brands, product lines, and the like.
In this embodiment, the plurality of screening conditions includes at least two screening conditions having the same tag condition, for example, it is assumed that the number of the screening conditions is 10, where the tag condition in 3 screening conditions is a, the tag condition in 2 screening conditions is B, the tag condition in 2 screening conditions is C, and the tag conditions in the other 3 screening conditions are different from each other.
In one implementation, when the system acquires a plurality of screening conditions, for any one of the screening conditions, the system may acquire the screening conditions by:
firstly, receiving label conditions and filter conditions selected by a business person in a visual window.
The system comprises a visual window, a system and a service person, wherein the visual window is a window provided by the system, a plurality of label conditions and filter conditions to be selected can be displayed in the window, the service person can select the label conditions and the filter conditions, and after the label conditions and the filter conditions are selected, the system can receive the label conditions and the filter conditions selected by the service person.
In one implementation, in the case that the filtering condition is a business domain condition, the visualization window provided by the system may be the visualization window shown in fig. 1.
Secondly, a screening condition is obtained based on the received label condition and the filtering condition.
After receiving the label condition and the filter condition selected by the service personnel, the system can take the received label condition and the filter condition as a screening condition.
For ease of understanding, reference may be made to fig. 3.
Fig. 3 is a screening condition obtained after a business person selects in the visualization window shown in fig. 1, where "member activity includes high" and "important value member includes yes" displayed in an upper area of fig. 3 are tag conditions included in the screening condition, and a business field "north Zhe area" displayed in a middle area is a filtering condition included in the screening condition.
It should be noted that when a service person selects a service domain, the service scope domain smaller than the authority scope of the service person needs to be selected, and when the system performs crowd screening, the system automatically performs crowd screening by adding filtering conditions according to the service scope domain selected by the service person.
Optionally, for convenience of use, the system may further set the label condition with a high frequency of selection by the service person as the label condition template, so that the service person may directly select the label condition template when selecting the label condition without selecting each label condition one by one. As shown in fig. 4, the content marked by the box in fig. 4 is a label condition template preset by the system, and the service personnel can select a plurality of label conditions in the label condition template at one time by selecting the label condition template.
In this embodiment, after the system obtains one screening condition by the above method, other screening conditions may be obtained by the same method, so as to obtain a plurality of screening conditions.
After obtaining a plurality of screening conditions, the system may store the plurality of screening conditions in a crowd condition list, where for any screening condition, a field corresponding to a tag condition and a field corresponding to a filtering condition in the screening condition may be stored in the crowd condition list, that is, the tag condition and the filtering condition in the screening condition are stored in two fields, and in addition, a feature code (feature _ code) corresponding to the tag condition in the screening condition may also be stored in the crowd condition list.
In this embodiment, different tag conditions correspond to different feature codes, and preferably, the feature codes may be ciphertext obtained by performing MD5 encryption on a character string of the tag condition. Of course, the feature code of the label condition may be determined by other methods as long as it can be ensured that different label conditions correspond to different feature codes.
FIG. 5 is a schematic diagram of a list of crowd conditions according to an embodiment of the present application.
The population condition list shown in fig. 5 stores three filtering conditions, where group _ id is the number of the filtering condition, feature _ code is a feature code corresponding to a tag condition in the filtering condition, tag _ condition is a field of the tag condition, and scope is a field of the filtering condition.
S204: and carrying out crowd inquiry based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds in one-to-one correspondence with the plurality of label conditions, wherein the same label condition corresponds to one crowd inquiry.
In this embodiment, after the system obtains the plurality of screening conditions, the system may not perform the crowd query based on the plurality of screening conditions, but perform the crowd query based on a plurality of tag conditions in the plurality of screening conditions, where the same tag condition performs the crowd query only once, so that the number of times of the crowd query may be reduced, and then the crowd query time may be reduced.
For example, assuming that the number of the screening conditions is n and the number of the label conditions is m (the same plurality of label conditions are regarded as one label condition), the total screening period duration after the population screening is performed based on the existing population screening method is T1+ T2+ T3+ … … + tn, where T is Ti(i-1, 2, … …, n) is the query duration required by a single target crowd, and after the crowd screening is performed based on the method provided by this embodiment, the total crowd query duration is: t1 ═ T1+ T2+ T3+ … … + tm, where T isi(i-1, 2, … …, m) is the length of time required to perform a crowd query based on a single tag condition. Because at least two screening conditions with the same label condition exist in the plurality of screening conditions, that is, m is smaller than n, and the same label condition is used for crowd inquiry only once, T can be determined to be smaller than T, that is, the crowd inquiry duration can be reduced in the embodiment.
In this embodiment, when performing crowd query based on a plurality of tag conditions included in a plurality of screening conditions, in order to ensure that the same tag condition performs crowd query only once, for any tag condition, the following operations may be performed:
first, it is determined whether a crowd query has been performed based on the tag condition.
In this embodiment, after performing crowd query based on any label condition, the label condition may be marked, specifically, the feature code corresponding to the label condition may be marked, and the marking may represent that crowd query has been performed based on the label condition, so that whether crowd query has been performed based on the label condition may be determined by determining whether the feature code of the label condition is marked.
After the determination, if the feature code of the tag condition is marked, it may be said that the crowd query has been performed based on the tag condition, and if the feature code of the tag condition is not marked, it may be said that the crowd query has not been performed based on the tag condition.
Secondly, if the feature code of the label condition is determined to be marked, people can be cancelled from querying based on the label condition, namely the label condition is skipped; if the feature code of the label condition is determined not to be marked, the crowd inquiry can be carried out based on the label condition.
When the crowd query is performed based on the tag condition, the tag condition can be converted into an SQL statement, and then the crowd query is performed in a target database based on the SQL statement, where the target database may be a database such as clickwouse that stores crowd information.
For example, assume that the expression of the tag condition is { "relation": and "," tag ": {" age ": {" in ": below" 20 years ","20 years-29 years ","40 years-49 years "] }," sex ": {" in ": [" male "] } } } which means that the age group contains: and the gender comprises male, the label condition is encrypted by MD5 to obtain a characteristic value f27dae187e2b1d3dd1d31ee427065de9, and the characteristic value can be used as a characteristic code of the label condition. When the tag condition is converted into the SQL statement, the SQL statement obtained by the conversion may be:
select user _ id, scope, "f27dae187e2b1d3dd1d31ee427065de9" as feature _ code from user profile name in ("under 20", "20-29", "40-49") and sex in ("male").
In this embodiment, after performing crowd query on any label condition based on the above method, a plurality of crowds corresponding to a plurality of label conditions one to one may be finally obtained, and for convenience of distinction, the plurality of crowds obtained through query may be referred to as a plurality of first crowds. Each first crowd may include a plurality of users, each user may include information such as a crowd filtering identifier and a feature code of a tag condition corresponding to a crowd to which the user belongs, and the crowd filtering identifier may be understood as a filtering condition.
Optionally, after obtaining the plurality of first persons, the plurality of first persons may also be saved in a list, which may be specifically shown in fig. 6. In fig. 6, the first column (id) is the user number, the second column (user _ id) is the user identifier, the third column (scope) is the user's crowd filter identifier, and the fourth column (feature _ code) is the feature code of the tag condition corresponding to the crowd to which the user belongs. It should be noted that fig. 6 only shows the two first people.
S206: and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
After the system queries and obtains a plurality of first people groups, the plurality of first people groups can be further screened based on a plurality of filtering conditions included in the plurality of screening conditions, and then a plurality of target people groups corresponding to the plurality of screening conditions one to one are obtained.
In this embodiment, the users in each first crowd may include crowd filtering identifiers, and when determining a plurality of target crowd based on a plurality of filtering conditions and a plurality of filtering conditions, a specific implementation manner for any first crowd is as follows:
first, a first screening condition including a label condition corresponding to a first population may be determined based on the label condition.
Since the plurality of first populations correspond to the plurality of label conditions one to one, and each screening condition includes a label condition, for any first population, the screening condition including the label condition corresponding to the first population can be determined by matching the label condition corresponding to the first population with the label condition in the screening condition, and for convenience of distinction, the screening condition may be referred to as a first screening condition hereinafter. In this embodiment, the number of the first filtering conditions may be one, or may be multiple, and when the number of the first filtering conditions is multiple, the tag conditions included in the multiple first filtering conditions are the same.
Next, if the number of the first screening conditions is 1, the first population may be determined as the target population corresponding to the first screening conditions.
If the number of the first screening conditions is multiple, for any first screening condition, the filtering condition in the first screening condition may be matched with the crowd filtering identifier of the user in the first crowd, so as to determine which crowd filtering identifiers of the users in the first crowd are matched with the filtering condition in the first screening condition, where the matching may be understood as that the crowd filtering identifier and the filtering condition are the same, and after the matched crowd is screened, the crowd is the target crowd corresponding to the first screening condition.
In one implementation, when matching the filtering condition in the first filtering condition with the crowd filtering identification of the user in the first crowd, the implementation code may be the following code:
select a.user_id,a.feature_code,b.group_id from feature_userlist a
join biz_group b on
a.feature_code=b.feature_code
where hasAny(a.scope,b.scope)=1
wherein, biz _ group is the crowd condition list shown in fig. 5, feature _ userlist is the list shown in fig. 6, hasAny is the SQL query syntax of clickhouse, and it is determined whether there is an intersection between the two array elements (i.e. whether there is a matched user), and the result is 0 and indicates that there is no intersection, and the result is 1 and indicates that there is an intersection.
Fig. 7 is a crowd detail table obtained by matching the filtering condition in the crowd condition list shown in fig. 5 with the first crowd in the list shown in fig. 6 based on the crowd filtering identifier, and it can be seen from fig. 7 which users are included in the target crowd corresponding to each filtering condition, where the same user may belong to multiple target crowds.
After obtaining a plurality of target people, the embodiment may store the plurality of target people, where a storage result of any target people may include a crowd identifier (i.e., a crowd ID), a user identifier (i.e., a user ID) of a user included in the target people, and a tag condition corresponding to the target people, and the tag condition corresponding to the target people may also be a feature code corresponding to the tag condition.
Based on the technical scheme provided by the embodiment of the application, if the time length required by S206 is U, the whole crowd screenThe duration of the selection period is T2 ═ T1+ T2+ T3+ … … + tm + U, where T isi(i-1, 2, … …, m) is the length of time required to perform a crowd query based on a single tag condition.
Comparing T2 with the time length T required by the existing population screening method described above, it can be seen that, when m is much shorter than n, the time length required by the technical solution provided by the present embodiment is shorter than that required by the existing technical solution. The P is represented as the crowd similarity, and in the case that the crowd similarity is larger, generally in real applications, if the number of people used by the system is larger, the P may be larger, and the time length saved by the technical solution provided by the embodiment is larger.
For facilitating understanding of the technical solutions provided in the embodiments of the present application, refer to fig. 8. Fig. 8 is a schematic flow chart of a crowd screening method according to an embodiment of the present application, which may specifically include the following steps:
s801: the method comprises the steps of obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition.
S802: and storing the plurality of screening conditions into a crowd condition list, wherein the crowd condition list comprises fields corresponding to the label conditions, feature codes and fields corresponding to the filtering conditions.
S803: and aiming at any label condition in the plurality of screening conditions, judging whether the crowd inquiry is carried out based on the label condition.
If yes, the label condition may be skipped, and S803 is executed in a loop, that is, it is continuously determined whether the next label condition has been subjected to the crowd inquiry until all the label conditions have been subjected to the crowd inquiry (this process is not shown in fig. 8); if not, go to S804.
S804: and converting the label condition into an SQL statement, and performing crowd query in a target database based on the SQL statement.
S805: tag the tagged items that have been crowd queried.
S806: and inquiring to obtain a plurality of first crowds corresponding to the plurality of label conditions one by one, wherein the same label condition corresponds to one crowd inquiry.
S807: for any first population, a first screening condition comprising the tag condition is determined based on the tag condition corresponding to the first population.
S808: and if the number of the first screening conditions is 1, determining the first person group as a target person group corresponding to the first screening conditions.
S809: if the number of the first screening conditions is multiple, then aiming at any one first screening condition, screening the crowd with the crowd filtering identification matched with the filtering condition in the first screening condition from the first crowd, and determining the screened crowd as the target crowd corresponding to the first screening condition.
S8010: and determining to obtain a plurality of target crowds which correspond to the screening conditions one by one.
Specific implementation of S801 to S810 can refer to specific implementation of corresponding steps in the embodiment shown in fig. 2, and detailed description is omitted here.
According to the technical scheme provided by the embodiment of the application, when people are screened based on a plurality of screening conditions, people can be inquired based on a plurality of label conditions included in the screening conditions to obtain a plurality of first people which correspond to the plurality of label conditions one by one, wherein the same label conditions are inquired for people only once; after the plurality of first people groups are obtained through query, a plurality of target people groups corresponding to the plurality of screening conditions one to one can be further obtained based on the plurality of first people groups and the plurality of filtering conditions in the plurality of screening conditions. Because the label conditions in the multiple screening conditions are usually overlapped, when people are screened, people query based on the screening conditions is replaced by people query based on the label conditions, and the same label conditions are used for people query only once, so that the times of people query can be reduced, and the time of people query is further reduced; after the plurality of first groups are obtained, the plurality of first groups can be further screened based on the filtering conditions in the screening conditions, so that a plurality of target groups corresponding to the plurality of screening conditions one to one can be obtained. Therefore, the time length of the whole crowd screening period can be reduced while a plurality of target crowds are obtained, and the crowd screening efficiency is improved.
The foregoing description of specific embodiments of the present application has been presented. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing may also be possible or may be advantageous.
Fig. 9 is a schematic structural diagram of an electronic device according to an embodiment of the present application. Referring to fig. 9, at a hardware level, the electronic device includes a processor, and optionally further includes an internal bus, a network interface, and a memory. The Memory may include a Memory, such as a Random-Access Memory (RAM), and may further include a non-volatile Memory, such as at least 1 disk Memory. Of course, the electronic device may also include hardware required for other services.
The processor, the network interface, and the memory may be connected to each other via an internal bus, which may be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus, an EISA (Extended Industry Standard Architecture) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one double-headed arrow is shown in FIG. 9, but this does not indicate only one bus or one type of bus.
And the memory is used for storing programs. In particular, the program may include program code comprising computer operating instructions. The memory may include both memory and non-volatile storage and provides instructions and data to the processor.
The processor reads the corresponding computer program from the nonvolatile memory into the memory and then runs the computer program to form the crowd screening device on a logic level. The processor is used for executing the program stored in the memory and is specifically used for executing the following operations:
obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query;
and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
The method performed by the crowd screening apparatus according to the embodiment of fig. 9 of the present application may be implemented in or by a processor. The processor may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuits of hardware in a processor or instructions in the form of software. The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components. The various methods, steps, and logic blocks disclosed in the embodiments of the present application may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in connection with the embodiments of the present application may be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software modules in the decoding processor. The software module may be located in ram, flash memory, rom, prom, or eprom, registers, etc. storage media as is well known in the art. The storage medium is located in a memory, and a processor reads information in the memory and completes the steps of the method in combination with hardware of the processor.
The electronic device may further execute the methods of fig. 2 and fig. 8, and implement the functions of the crowd screening apparatus in the embodiments shown in fig. 2 and fig. 8, which are not described herein again in this embodiment of the application.
Of course, besides the software implementation, the electronic device of the present application does not exclude other implementations, such as a logic device or a combination of software and hardware, and the like, that is, the execution subject of the following processing flow is not limited to each logic unit, and may also be hardware or a logic device.
Embodiments of the present application also provide a computer-readable storage medium storing one or more programs, where the one or more programs include instructions, which when executed by a portable electronic device including a plurality of application programs, enable the portable electronic device to perform the method of the embodiments shown in fig. 2 and 8, and are specifically configured to:
obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query;
and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
Fig. 10 is a schematic structural diagram of a crowd screening device 100 according to an embodiment of the present application. Referring to fig. 100, in one software implementation, the crowd screening apparatus 100 may include: an obtaining unit 101, an inquiring unit 102 and a determining unit 103, wherein:
an obtaining unit 101, configured to obtain a plurality of screening conditions for population screening, where any screening condition includes a tag condition and a filtering condition, and the plurality of screening conditions includes at least two screening conditions with the same tag condition;
the query unit 102 is configured to perform crowd query based on a plurality of tag conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of tag conditions one to one, where the same tag condition corresponds to one crowd query;
the determining unit 103 determines, based on a plurality of filtering conditions included in the plurality of filtering conditions and the plurality of first populations, a plurality of target populations corresponding to the plurality of filtering conditions one to one.
Optionally, the obtaining unit 101 is configured to, after obtaining a plurality of screening conditions for performing population screening, store the plurality of screening conditions in a population condition list;
wherein, for any one of the plurality of screening conditions, the crowd condition list stores fields and feature codes corresponding to the tag conditions in the screening conditions, and fields corresponding to the filtering conditions in the screening conditions.
Optionally, the querying unit 102, configured to perform a crowd query based on a plurality of tag conditions included in the plurality of screening conditions, including:
for any of the plurality of tag conditions, performing the following:
judging whether crowd inquiry is carried out based on the label condition;
if not, carrying out crowd inquiry based on the label condition to obtain a first crowd corresponding to the label condition;
and if so, canceling the crowd inquiry based on the label condition.
Optionally, the querying unit 102, configured to perform a crowd query based on the tag condition, where the crowd query includes:
converting the label condition into an SQL statement;
and carrying out crowd query in a target database based on the SQL statement.
Optionally, the users in the first population include population filtering identifications;
the determining unit 103 determines, based on a plurality of filtering conditions included in the plurality of filtering conditions and the plurality of first populations, a plurality of target populations corresponding to the plurality of filtering conditions one to one, including:
for any one of the first population groups, performing the following:
determining a first screening condition comprising a label condition based on the label condition corresponding to the first population;
if the number of the first screening conditions is multiple, screening the crowd with the crowd filtering identification matched with the filtering conditions in the first screening conditions from the first crowd according to any one first screening condition; determining the screened population as a target population corresponding to the first screening condition;
and if the number of the first screening conditions is 1, determining the first person group as a target person group corresponding to the first screening conditions.
Optionally, the determining unit 103 stores a plurality of target people groups after obtaining a plurality of target people groups corresponding to the plurality of screening conditions one to one, where a storage result of any target people group includes a people group identifier of the target people group, a user identifier of a user included in the target people group, and a tag condition corresponding to the target people group.
Optionally, the obtaining unit 101 obtains any one of the plurality of screening conditions by:
receiving label conditions and filter conditions selected by business personnel in a visual window;
and acquiring a screening condition based on the received label condition and the filtering condition.
The crowd screening apparatus 100 provided in the embodiment of the present application may further perform the methods shown in fig. 2 and fig. 8, and implement the functions of the crowd screening apparatus in the embodiments shown in fig. 2 and fig. 8, which are not described herein again.
In short, the above description is only a preferred embodiment of the present application, and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions. One typical implementation device is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smartphone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The embodiments in the present application are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.

Claims (10)

1. A method of population screening, comprising:
obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query;
and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
2. The method of claim 1, wherein after obtaining the plurality of screening conditions for population screening, the method further comprises:
saving the plurality of screening conditions to a population condition list;
wherein, for any one of the plurality of screening conditions, the crowd condition list stores fields and feature codes corresponding to the tag conditions in the screening conditions, and fields corresponding to the filtering conditions in the screening conditions.
3. The method of claim 2, wherein conducting a population query based on a plurality of tag conditions included in the plurality of screening conditions comprises:
for any of the plurality of tag conditions, performing the following:
judging whether crowd inquiry is carried out based on the label condition;
if not, carrying out crowd inquiry based on the label condition to obtain a first crowd corresponding to the label condition;
and if so, canceling the crowd inquiry based on the label condition.
4. The method of claim 3, wherein conducting a crowd query based on the tag condition comprises:
converting the label condition into an SQL statement;
and carrying out crowd query in a target database based on the SQL statement.
5. The method of claim 1, wherein users in the first population comprise population filter identifications;
wherein determining a plurality of target groups corresponding to the plurality of screening conditions one-to-one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups of people comprises:
for any one of the first population groups, performing the following:
determining a first screening condition comprising a label condition based on the label condition corresponding to the first population;
if the number of the first screening conditions is multiple, screening the crowd with the crowd filtering identification matched with the filtering conditions in the first screening conditions from the first crowd according to any one first screening condition; determining the screened population as a target population corresponding to the first screening condition;
and if the number of the first screening conditions is 1, determining the first person group as a target person group corresponding to the first screening conditions.
6. The method of claim 1, wherein after obtaining a plurality of target populations corresponding one-to-one to the plurality of screening criteria, the method further comprises:
and storing the target groups, wherein the storage result of any target group comprises the group identification of the target group, the user identification of the user in the target group and the label condition corresponding to the target group.
7. The method of claim 1, wherein any of the plurality of screening conditions is obtained by:
receiving label conditions and filter conditions selected by business personnel in a visual window;
and acquiring a screening condition based on the received label condition and the filtering condition.
8. A crowd screening device, comprising:
the system comprises an acquisition unit, a processing unit and a display unit, wherein the acquisition unit is used for acquiring a plurality of screening conditions for population screening, any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
the query unit is used for performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds which are in one-to-one correspondence with the plurality of label conditions, wherein the same label condition corresponds to one crowd query;
and a determining unit configured to determine a plurality of target groups corresponding to the plurality of filtering conditions one-to-one based on the plurality of filtering conditions included in the plurality of filtering conditions and the plurality of first groups.
9. An electronic device, comprising:
a processor; and
a memory arranged to store computer executable instructions that, when executed, cause the processor to:
obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query;
and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
10. A computer-readable storage medium storing one or more programs which, when executed by an electronic device including a plurality of application programs, cause the electronic device to perform a method of:
obtaining a plurality of screening conditions for population screening, wherein any screening condition comprises a label condition and a filtering condition, and the plurality of screening conditions comprise at least two screening conditions with the same label condition;
performing crowd query based on a plurality of label conditions included in the plurality of screening conditions to obtain a plurality of first crowds corresponding to the plurality of label conditions one to one, wherein the same label condition corresponds to one crowd query;
and determining a plurality of target groups corresponding to the plurality of screening conditions one by one based on the plurality of filtering conditions included in the plurality of screening conditions and the plurality of first groups.
CN202011518720.9A 2020-12-21 2020-12-21 Crowd screening method and device Pending CN112749200A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011518720.9A CN112749200A (en) 2020-12-21 2020-12-21 Crowd screening method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011518720.9A CN112749200A (en) 2020-12-21 2020-12-21 Crowd screening method and device

Publications (1)

Publication Number Publication Date
CN112749200A true CN112749200A (en) 2021-05-04

Family

ID=75648607

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011518720.9A Pending CN112749200A (en) 2020-12-21 2020-12-21 Crowd screening method and device

Country Status (1)

Country Link
CN (1) CN112749200A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20170024431A1 (en) * 2015-07-24 2017-01-26 International Business Machines Corporation Generating and executing query language statements from natural language
CN107391532A (en) * 2017-04-14 2017-11-24 阿里巴巴集团控股有限公司 The method and apparatus of data filtering
CN108304591A (en) * 2018-03-16 2018-07-20 深圳市买买提信息科技有限公司 A kind of method for customizing of label, system and terminal device
CN110609840A (en) * 2019-09-18 2019-12-24 北京思维造物信息科技股份有限公司 User information screening method, device and equipment

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20170024431A1 (en) * 2015-07-24 2017-01-26 International Business Machines Corporation Generating and executing query language statements from natural language
CN107391532A (en) * 2017-04-14 2017-11-24 阿里巴巴集团控股有限公司 The method and apparatus of data filtering
CN108304591A (en) * 2018-03-16 2018-07-20 深圳市买买提信息科技有限公司 A kind of method for customizing of label, system and terminal device
CN110609840A (en) * 2019-09-18 2019-12-24 北京思维造物信息科技股份有限公司 User information screening method, device and equipment

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
西伯利亚大橘猫: "重复的数据处理,并只执行一次", 《HTTPS://BLOG.CSDN.NET/QQ_41508747/ARTICLE/DETAILS/83743692》 *

Similar Documents

Publication Publication Date Title
US11252245B2 (en) Information pushing method and device
CN107967357B (en) Friend pushing method and system and terminal equipment
CN108510311B (en) Method and device for determining marketing scheme and electronic equipment
JP2015204103A (en) Interactive search and recommendation method and device thereof
CN111522927B (en) Entity query method and device based on knowledge graph
CN106156244B (en) Information search navigation method and device
CN108550046B (en) Resource and marketing recommendation method and device and electronic equipment
US9660947B1 (en) Method and apparatus for filtering undesirable content based on anti-tags
CN112463991B (en) Historical behavior data processing method and device, computer equipment and storage medium
CN113704243A (en) Data analysis method, data analysis device, computer device, and storage medium
CN110012049B (en) Information push method, system, server and computer readable storage medium
CN112650890A (en) Graph database-based encrypted currency flow direction tracking method and device
CN110704423B (en) Excitation information acquisition method and device, storage medium and electronic equipment
CN112241489A (en) Information pushing method and device, readable storage medium and computer equipment
TW202242715A (en) Identity recognition method electronic equipment and computer-readable storage medium
CN113077321A (en) Article recommendation method and device, electronic equipment and storage medium
CN111488371A (en) Data query method and device
CN111340575A (en) Resource pushing method and device and electronic equipment
CN110866085A (en) Data feedback method and device
CN108830298B (en) Method and device for determining user feature tag
CN112749200A (en) Crowd screening method and device
CN108268545B (en) Method and device for establishing hierarchical user label library
CN112528096B (en) Enterprise analysis method, storage medium and electronic equipment
CN113918796A (en) Information searching method, device, server and storage medium
CN114443781A (en) Method and device for generating enterprise guarantee map

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20210504

RJ01 Rejection of invention patent application after publication