CN113434742A - Account screening method and device, storage medium and electronic device - Google Patents
Account screening method and device, storage medium and electronic device Download PDFInfo
- Publication number
- CN113434742A CN113434742A CN202110721977.2A CN202110721977A CN113434742A CN 113434742 A CN113434742 A CN 113434742A CN 202110721977 A CN202110721977 A CN 202110721977A CN 113434742 A CN113434742 A CN 113434742A
- Authority
- CN
- China
- Prior art keywords
- target
- account
- attribute
- label
- query
- 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
Links
- 238000012216 screening Methods 0.000 title claims abstract description 85
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000004590 computer program Methods 0.000 claims description 12
- 238000012937 correction Methods 0.000 claims description 7
- 230000004044 response Effects 0.000 claims description 6
- 238000006243 chemical reaction Methods 0.000 claims description 5
- 230000001186 cumulative effect Effects 0.000 claims description 5
- 238000012790 confirmation Methods 0.000 claims description 4
- 238000005516 engineering process Methods 0.000 abstract description 6
- 230000000875 corresponding effect Effects 0.000 description 37
- 230000000694 effects Effects 0.000 description 10
- 230000005540 biological transmission Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 3
- 238000001914 filtration Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
Images
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/903—Querying
- G06F16/9035—Filtering based on additional data, e.g. user or group profiles
-
- 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/903—Querying
- G06F16/90335—Query processing
-
- 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/903—Querying
- G06F16/9038—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for screening account numbers, a storage medium and an electronic device, wherein the method comprises the following steps: displaying a plurality of label attribute types on a screening interface, wherein each label attribute type comprises one or more user label attributes; acquiring one or more target tag attributes selected by a target account from a plurality of tag attribute types, and acquiring an attribute value corresponding to each target tag attribute in the one or more target tag attributes and a query relation of the one or more target tag attributes; inquiring accounts meeting the target inquiry condition on a database to obtain an account list; and displaying the account list to the target account on the screening interface. By adopting the technical scheme, the problems that the screening efficiency of the account is low and the like in the related technology are solved.
Description
Technical Field
The invention relates to the field of communication, in particular to a method and a device for screening accounts, a storage medium and an electronic device.
Background
With the popularization of the internet, social news, hot spots and folk custom activities can be quickly spread to the sight of the public. Therefore, operators need to rapidly promote corresponding activities to specific users according to actual conditions, so that the app activity is improved, and the user retention rate is guaranteed.
At present, the existing attribute information in the push user tables of different user groups is simply filtered and screened, for various specific conditions of combination, operators need to put forward requirements for product managers, the product managers plan functional schemes, research and development personnel evaluate working hours to develop, quality departments check and accept functions, operation and maintenance personnel arrange functional online, and the operators log in a system to trigger push operation. In the above scenario, the selection of the user group is limited by the structural design of the user table, and for various specific combined situations, the implementation time period is long, and although the push to the specific user group can be implemented, the preemption and flexible response of the operator to the real-time hot event are affected.
Aiming at the problems of low screening efficiency of account numbers and the like in the related technology, no effective solution is provided.
Disclosure of Invention
The embodiment of the invention provides an account screening method and device, a storage medium and an electronic device, and aims to at least solve the problems of low account screening efficiency and the like in the related technology.
According to an embodiment of the present invention, a method for screening account numbers is provided, including: displaying a plurality of label attribute types on a screening interface, wherein each label attribute type comprises one or more user label attributes; acquiring one or more target tag attributes selected by a target account from the plurality of tag attribute types, and acquiring an attribute value corresponding to each target tag attribute in the one or more target tag attributes and a query relation of the one or more target tag attributes; querying an account meeting a target query condition on a database to obtain an account list, wherein the target query condition is constructed by the one or more target tag attributes, an attribute value corresponding to each target tag attribute, and the query relationship; and displaying the account list to the target account on the screening interface, wherein the account list is used for pushing target pushing information indicated by the target account.
In an exemplary embodiment, the querying, on the database, an account number that meets the target query condition includes: sending a query request to the database, wherein the query request is used for requesting to query an account meeting the target query condition; receiving a primary account list returned by the database in response to the query request, wherein accounts meeting the target query condition are recorded in the primary account list; inquiring target user information corresponding to each account recorded in the initial account list; and recording the account and the target user information with the corresponding relation to obtain the account list.
In an exemplary embodiment, the sending a query request to the database includes: performing syntactic analysis on the target query condition according to a data format provided by the database to obtain an analysis result; carrying out format conversion on the target query condition according to the analysis result to obtain the query request; and sending the query request to a data interface provided by the database, wherein the data format provided by the database is a data format which can be identified by the data interface provided by the database.
In an exemplary embodiment, before querying the account satisfying the target query condition on the database, the method further includes: splicing the one or more target label attributes and the attribute value corresponding to each target label attribute to obtain one or more key value pairs; and connecting the one or more key-value pairs by using the query relation to obtain the target query condition.
In an exemplary embodiment, after the displaying the account list to the target account on the screening interface, the method further includes: under the condition that the confirmation operation of the target account on the account list is detected, acquiring the target push information indicated by the target account; and pushing the target pushing information to the account recorded in the account list.
In an exemplary embodiment, after the displaying the account list to the target account on the screening interface, the method further includes: under the condition that the withdrawing operation of the target account on the account list is detected, the target query condition is displayed to the target account; executing the editing operation indicated by the target account on the target query condition to obtain a corrected query condition; inquiring the account numbers meeting the correction inquiry condition on the database to obtain a correction account number list; and displaying the revised account list to the target account on the screening interface.
In an exemplary embodiment, the presenting the plurality of tag attribute types on the filtering interface includes: displaying a terminal basic label type, an intelligent device label type, a user basic label type and a user active label type on the screening interface; displaying a system label attribute, a version label attribute, a region label attribute and a channel package label attribute in the terminal basic label type; displaying a first binding time tag attribute, a last binding time tag attribute, a number of bound netwares tag attribute, a type of bound netwares tag attribute, whether a custom scene tag attribute is defined and a trigger custom scene number tag attribute in the intelligent equipment tag type; displaying an age label attribute, a gender label attribute, a receiving address label attribute and a user source label attribute in the user basic label type; and displaying a life cycle state label attribute, a continuous active week number label attribute, a continuous inactive week number label attribute, a cumulative active week number label attribute, a user category label attribute, a first active date label attribute and a last active date label attribute in the user active label type.
According to another embodiment of the present invention, there is provided an account screening apparatus, including: the display module is used for displaying a plurality of label attribute types on the screening interface, wherein each label attribute type comprises one or more user label attributes; a first obtaining module, configured to obtain one or more target tag attributes selected by a target account from the multiple tag attribute types, and obtain an attribute value corresponding to each of the one or more target tag attributes, and a query relationship between the one or more target tag attributes; the first query module is used for querying accounts meeting target query conditions on a database to obtain an account list, wherein the target query conditions are constructed by the one or more target tag attributes, attribute values corresponding to each target tag attribute and the query relationship; the first display module is configured to display the account list to the target account on the screening interface, where the account list is used to push target push information indicated by the target account.
According to another aspect of the embodiment of the present invention, there is further provided a computer-readable storage medium, in which a computer program is stored, where the computer program is configured to execute the screening method for the account when running.
According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor executes the account screening method through the computer program.
In the embodiment of the invention, a plurality of label attribute types are displayed on a screening interface, wherein each label attribute type comprises one or more user label attributes; acquiring one or more target tag attributes selected by a target account from a plurality of tag attribute types, and acquiring an attribute value corresponding to each target tag attribute in the one or more target tag attributes and a query relation of the one or more target tag attributes; inquiring an account number meeting a target inquiry condition on a database to obtain an account number list, wherein the target inquiry condition is constructed by one or more target label attributes, an attribute value corresponding to each target label attribute and an inquiry relation; displaying an account list to the target account on the screening interface, wherein the account list is used for pushing target push information indicated by the target account, that is, the operator may select a plurality of tag attribute types displayed on the screening interface and one or more user tag attributes under each tag attribute type using the target account to obtain one or more target tag attributes, and obtaining attribute values corresponding to each target tag attribute and query relations of one or more target tag attributes, inquiring account numbers which meet target inquiry conditions constructed by one or more target label attributes, attribute values corresponding to each target label attribute and inquiry relations through a database to obtain an account number list, therefore, the account numbers used for pushing the target pushing information indicated by the target account numbers are conveniently and quickly screened out from the account numbers in the big data. By adopting the technical scheme, the problems that the screening efficiency of the account is low and the like in the related technology are solved, and the technical effect of improving the screening efficiency of the account is realized.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the invention and not to limit the invention. In the drawings:
fig. 1 is a block diagram of a hardware structure of a computer terminal of a method for screening account numbers according to an embodiment of the present invention;
fig. 2 is a flowchart of a screening method of an account according to an embodiment of the present invention;
fig. 3 is a schematic diagram of a screening method of an account according to an embodiment of the present invention;
fig. 4 is a block diagram of a screening apparatus for account numbers according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, 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 invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The method provided by the embodiment of the invention can be executed in a computer terminal, a computer terminal or a similar arithmetic device. Taking an example of the method running on a computer terminal, fig. 1 is a hardware structure block diagram of a computer terminal of the account screening method according to the embodiment of the present invention. As shown in fig. 1, the computer terminal may include one or more (only one shown in fig. 1) processors 102 (the processors 102 may include, but are not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA) and a memory 104 for storing data, and in an exemplary embodiment, may also include a transmission device 106 for communication functions and an input-output device 108. It will be understood by those skilled in the art that the structure shown in fig. 1 is only an illustration and is not intended to limit the structure of the computer terminal. For example, the computer terminal may also include more or fewer components than shown in FIG. 1, or have a different configuration with equivalent functionality to that shown in FIG. 1 or with more functionality than that shown in FIG. 1.
The memory 104 may be used to store a computer program, for example, a software program and a module of an application software, such as a computer program corresponding to the account screening method in the embodiment of the present invention, and the processor 102 executes various functional applications and data processing by running the computer program stored in the memory 104, so as to implement the method described above. The memory 104 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory located remotely from the processor 102, which may be connected to a computer terminal over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission device 106 is used for receiving or transmitting data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the computer terminal. In one example, the transmission device 106 includes a Network adapter (NIC), which can be connected to other Network devices through a base station so as to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is used for communicating with the internet in a wireless manner.
In this embodiment, an account screening method is provided, which is applied to the computer terminal, and fig. 2 is a flowchart of the account screening method according to the embodiment of the present invention, where the flowchart includes the following steps:
step S202, a plurality of label attribute types are displayed on a screening interface, wherein each label attribute type comprises one or more user label attributes;
step S204, one or more target tag attributes selected by a target account are obtained from the plurality of tag attribute types, and an attribute value corresponding to each target tag attribute in the one or more target tag attributes and a query relation of the one or more target tag attributes are obtained;
step S206, inquiring an account number meeting target inquiry conditions on a database to obtain an account number list, wherein the target inquiry conditions are constructed by the one or more target label attributes, the attribute value corresponding to each target label attribute and the inquiry relation;
step S208, displaying the account list to the target account on the screening interface, where the account list is used to push target push information indicated by the target account.
Through the steps, an operator can select a plurality of label attribute types displayed on a screening interface and one or more user label attributes under each label attribute type by using the target account to obtain one or more target label attributes, obtain an attribute value corresponding to each target label attribute and a query relation of the one or more target label attributes, and query accounts meeting a target query condition constructed by the one or more target label attributes, the attribute value corresponding to each target label attribute and the query relation through a database to obtain an account list, so that the account used for pushing target push information indicated by the target account is conveniently and quickly screened from the accounts in the big data. By adopting the technical scheme, the problems that the screening efficiency of the account is low and the like in the related technology are solved, and the technical effect of improving the screening efficiency of the account is realized.
In the technical solution provided in step S202, a client for pushing activity information for a user may be provided for an operator, but not limited to, and a screening interface is displayed on the client, and the operator may operate on the screening interface, so as to screen out an account needing to push activity information.
Optionally, in this embodiment, the user tag attribute used for generating the query condition may be, but is not limited to be, divided into multiple tag attribute types for classified display, so that an operator can quickly and conveniently find the required user tag attribute according to the classification.
In an exemplary embodiment, the plurality of tag attribute types may be presented on the screening interface by, but are not limited to: displaying a terminal basic label type, an intelligent device label type, a user basic label type and a user active label type on the screening interface; displaying a system label attribute, a version label attribute, a region label attribute and a channel package label attribute in the terminal basic label type; displaying a first binding time tag attribute, a last binding time tag attribute, a number of bound netwares tag attribute, a type of bound netwares tag attribute, whether a custom scene tag attribute is defined and a trigger custom scene number tag attribute in the intelligent equipment tag type; displaying an age label attribute, a gender label attribute, a receiving address label attribute and a user source label attribute in the user basic label type; and displaying a life cycle state label attribute, a continuous active week number label attribute, a continuous inactive week number label attribute, a cumulative active week number label attribute, a user category label attribute, a first active date label attribute and a last active date label attribute in the user active label type.
Optionally, in this embodiment, the feature attributes of the users are divided into four major categories: the system comprises a terminal basic label, an intelligent device label, a user basic label and a user active label. Wherein, terminal basis label includes: system, version, region, and channel package. The smart device tag includes: the method comprises the steps of first binding time, last binding time, the number of network binding devices, the types of the network binding devices (which can be classified according to industry), whether to define a scene or not and the number of times of triggering the defined scene. The user base tag includes: age, gender, shipping address, and user source. The user activity tags include: lifecycle status, consecutive active weeks, consecutive inactive weeks, cumulative active weeks, user category, first active date, and last active date.
In the technical solution provided in step S204, the operator may screen the user tag attributes and set attribute values meeting the conditions on the screening interface according to actual conditions, and perform combination of query relationships to form a selection condition for a specific user group.
Optionally, in this embodiment, the query relationship may include, but is not limited to: and, or, an unequal logical relationship.
In the technical solution provided in step S206, the account list may include, but is not limited to, an account and/or characteristic information of the account. The account number may include, but is not limited to: an account of the user, an account of the device, an account of the client, and so on. Such as: user identification, user name, device identification, client identification, and the like.
Optionally, in this embodiment, the database may include, but is not limited to: big data platforms, cloud platforms, and the like.
In an exemplary embodiment, the account number list may be obtained by, but not limited to, querying the database for account numbers that satisfy the target query condition in the following manner: sending a query request to the database, wherein the query request is used for requesting to query an account meeting the target query condition; receiving a primary account list returned by the database in response to the query request, wherein accounts meeting the target query condition are recorded in the primary account list; inquiring target user information corresponding to each account recorded in the initial account list; and recording the account and the target user information with the corresponding relation to obtain the account list.
Optionally, in this embodiment, the information returned by the database may include, but is not limited to, only accounts of users meeting the target query condition, the target user information corresponding to each account may be queried from other databases or data platforms according to the accounts recorded in the initial account list, and the obtained account list records the accounts and the target user information having a corresponding relationship, so that an operator can browse the accounts meeting the condition from the account list and can also browse the user information of each account.
In an exemplary embodiment, the query request may be sent to the database in, but is not limited to, the following manner: performing syntactic analysis on the target query condition according to a data format provided by the database to obtain an analysis result; carrying out format conversion on the target query condition according to the analysis result to obtain the query request; and sending the query request to a data interface provided by the database, wherein the data format provided by the database is a data format which can be identified by the data interface provided by the database.
Optionally, in this embodiment, the target query condition is sent to the database in a data format recognizable by a data interface provided by the database through parsing, format conversion, and the like, so that the validity of data transmission is ensured.
In an exemplary embodiment, before querying the account satisfying the target query condition on the database to obtain the account list, the target query condition may also be constructed, but is not limited to, by the following means: splicing the one or more target label attributes and the attribute value corresponding to each target label attribute to obtain one or more key value pairs; and connecting the one or more key-value pairs by using the query relation to obtain the target query condition.
Optionally, in this embodiment, the target query condition is constructed by one or more target tag attributes, an attribute value corresponding to each target tag attribute, and a query relationship. Such as: the target label attribute comprises A, B and C, wherein the attribute value of A is M, the attribute value of B is N, the attribute value of C is P, and the query relationship is the relationship of OR among the three. The constructed target query condition may be, but is not limited to, a-M or B-N or C-P.
In the technical solution provided in step S208, the account list is displayed to the target account on the screening interface, and the operator can browse the account list by using the target account and push the target push message indicated by the account list to the account in the account list.
Optionally, in this embodiment, the target push information may include, but is not limited to: activity messages, recommendation purchase messages, news messages, hot topics, and the like.
In an exemplary embodiment, after the list of accounts is presented to the target account on the screening interface, the activity message may also be pushed to the screened user by, but not limited to: under the condition that the confirmation operation of the target account on the account list is detected, acquiring the target push information indicated by the target account; and pushing the target pushing information to the account recorded in the account list.
Optionally, in this embodiment, the operator may, but not limited to, select a target push message to be pushed using the target account, and the target push message may, but not limited to, be pushed to a client corresponding to an account recorded in the account list.
In an exemplary embodiment, after the account list is presented to the target account on the screening interface, the target screening condition may also be modified by, but not limited to, using the target account by: under the condition that the withdrawing operation of the target account on the account list is detected, the target query condition is displayed to the target account; executing the editing operation indicated by the target account on the target query condition to obtain a corrected query condition; inquiring the account numbers meeting the correction inquiry condition on the database to obtain a correction account number list; and displaying the revised account list to the target account on the screening interface.
Optionally, in this embodiment, if an operator finds a problem in the process of browsing the account list, a withdrawal operation may be performed on the account list, and after the withdrawal operation performed on the account list by the target account is detected, the target query condition is redisplayed for the target account to modify and edit the target account. And editing the target query condition by the target account to obtain a corrected query condition, and re-querying the account list required by the operator in the database by using the corrected query condition.
In order to better understand the process of the account screening method, an implementation method flow of the account screening process is described below with reference to an optional embodiment, but the technical solution of the embodiment of the present invention is not limited thereto.
In this embodiment, an account screening method is provided, and fig. 3 is a schematic diagram of an account screening method according to an embodiment of the present invention, as shown in fig. 3, the method may include, but is not limited to, the following steps:
step 1: an operator logs in the system, enters a corresponding operation menu and opens a management platform interface (namely the screening interface);
step 2: operators can screen displayed label attributes on a management platform interface and set attribute values meeting conditions according to actual conditions, and the corresponding relation between the attributes and the attribute values is combined with or without to form selection conditions (namely the target query conditions) for selecting a specific user group;
and step 3: storing the selection condition;
and 4, step 4: the background service analyzes and combines the grammar of the original selection condition and changes the data format to form the information (namely the query request) which can be identified by the big data interface;
and 5: the background service requests a user ID list from the big data interface;
step 6: the big data service returns a user ID list (namely the account list) meeting the conditions;
and 7: the background service temporarily stores the user ID list, and displays the user ID list on a management platform interface after counting and supplementing user information;
and 8: operators can look up basic information of users meeting the conditions on the interface;
and step 9: after the operator looks up the information without errors, the operator can directly click an operation management platform interface to confirm the information of the pushed user;
step 10: the management platform interface sends a pushing request to the background service;
step 11: the background service sends the user ID list temporarily stored before to a message center to trigger pushing;
step 12: the message center pushes messages to the appointed users;
step 13: the app acquires information and then feeds back the information to the message center;
step 14: the message center collects app feedback conditions and asynchronously returns the pushing result to the background service;
step 15: the management platform interface displays the pushing result on the interface through the background service response result;
step 16: and the operator checks the pushing result.
Through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (such as a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
Fig. 4 is a block diagram of a screening apparatus for account numbers according to an embodiment of the present invention; as shown in fig. 4, includes:
a presentation module 42, configured to present multiple tag attribute types on the filtering interface, where each tag attribute type includes one or more user tag attributes;
a first obtaining module 44, configured to obtain one or more target tag attributes selected by a target account from the multiple tag attribute types, and obtain an attribute value corresponding to each target tag attribute in the one or more target tag attributes, and a query relationship of the one or more target tag attributes;
a first query module 46, configured to query an account satisfying a target query condition on a database to obtain an account list, where the target query condition is constructed by the one or more target tag attributes, an attribute value corresponding to each target tag attribute, and the query relationship;
a first displaying module 48, configured to display the account list to the target account on the screening interface, where the account list is used to push target push information indicated by the target account.
Through the embodiment, an operator can select a plurality of label attribute types displayed on a screening interface and one or more user label attributes under each label attribute type by using the target account to obtain one or more target label attributes, obtain the attribute value corresponding to each target label attribute and the query relationship of one or more target label attributes, and query the account satisfying the target query condition constructed by one or more target label attributes, the attribute value corresponding to each target label attribute and the query relationship through the database to obtain the account list, so that the account for pushing the target push information indicated by the target account can be conveniently and quickly screened from the accounts in the big data. By adopting the technical scheme, the problems that the screening efficiency of the account is low and the like in the related technology are solved, and the technical effect of improving the screening efficiency of the account is realized.
In an exemplary embodiment, the first query module includes: a sending unit, configured to send a query request to the database, where the query request is used to request to query an account satisfying the target query condition; a receiving unit, configured to receive a primary account list returned by the database in response to the query request, where an account meeting the target query condition is recorded in the primary account list; the query unit is used for querying target user information corresponding to each account recorded in the initial account list; and the recording unit is used for recording the account and the target user information which have the corresponding relation to obtain the account list.
In an exemplary embodiment, the sending unit is further configured to: performing syntactic analysis on the target query condition according to a data format provided by the database to obtain an analysis result; carrying out format conversion on the target query condition according to the analysis result to obtain the query request; and sending the query request to a data interface provided by the database, wherein the data format provided by the database is a data format which can be identified by the data interface provided by the database.
In one exemplary embodiment, the apparatus further comprises: the splicing module is used for splicing the one or more target label attributes and the attribute value corresponding to each target label attribute to obtain one or more key value pairs before the account satisfying the target query condition is queried on the database to obtain an account list; and the connection module is used for connecting the one or more key value pairs by using the query relation to obtain the target query condition.
In one exemplary embodiment, the apparatus further comprises: the second obtaining module is configured to obtain the target push information indicated by the target account when a confirmation operation performed on the account list by the target account is detected after the account list is displayed on the target account on the screening interface; and the pushing module is used for pushing the target pushing information to the account numbers recorded in the account number list.
In one exemplary embodiment, the apparatus further comprises: the second display module is used for displaying the account list to the target account on the screening interface, and then displaying the target query condition to the target account under the condition that the withdrawal operation of the target account on the account list is detected; the execution module is used for executing the editing operation indicated by the target account on the target query condition to obtain a corrected query condition; the second query module is used for querying the account numbers meeting the correction query conditions on the database to obtain a corrected account number list; and the third display module is used for displaying the corrected account list to the target account on the screening interface.
In an exemplary embodiment, the display module includes: the first display unit is used for displaying a terminal basic label type, an intelligent device label type, a user basic label type and a user active label type on the screening interface; the second display unit is used for displaying a system label attribute, a version label attribute, a region label attribute and a channel package label attribute in the terminal basic label type; displaying a first binding time tag attribute, a last binding time tag attribute, a number of bound netwares tag attribute, a type of bound netwares tag attribute, whether a custom scene tag attribute is defined and a trigger custom scene number tag attribute in the intelligent equipment tag type; displaying an age label attribute, a gender label attribute, a receiving address label attribute and a user source label attribute in the user basic label type; and displaying a life cycle state label attribute, a continuous active week number label attribute, a continuous inactive week number label attribute, a cumulative active week number label attribute, a user category label attribute, a first active date label attribute and a last active date label attribute in the user active label type.
An embodiment of the present invention further provides a storage medium including a stored program, wherein the program executes any one of the methods described above.
Alternatively, in the present embodiment, the storage medium may be configured to store program codes for performing the following steps:
s1, displaying a plurality of label attribute types on the screening interface, wherein each label attribute type comprises one or more user label attributes;
s2, obtaining one or more target tag attributes selected by the target account from the multiple tag attribute types, and obtaining an attribute value corresponding to each target tag attribute in the one or more target tag attributes, and a query relationship of the one or more target tag attributes;
s3, querying an account satisfying a target query condition on a database to obtain an account list, wherein the target query condition is constructed by the one or more target tag attributes, an attribute value corresponding to each target tag attribute, and the query relationship;
s4, displaying the account list to the target account on the screening interface, wherein the account list is used for pushing target pushing information indicated by the target account.
Embodiments of the present invention also provide an electronic device comprising a memory having a computer program stored therein and a processor arranged to run the computer program to perform the steps of any of the above method embodiments.
Optionally, the electronic apparatus may further include a transmission device and an input/output device, wherein the transmission device is connected to the processor, and the input/output device is connected to the processor.
Optionally, in this embodiment, the processor may be configured to execute the following steps by a computer program:
s1, displaying a plurality of label attribute types on the screening interface, wherein each label attribute type comprises one or more user label attributes;
s2, obtaining one or more target tag attributes selected by the target account from the multiple tag attribute types, and obtaining an attribute value corresponding to each target tag attribute in the one or more target tag attributes, and a query relationship of the one or more target tag attributes;
s3, querying an account satisfying a target query condition on a database to obtain an account list, wherein the target query condition is constructed by the one or more target tag attributes, an attribute value corresponding to each target tag attribute, and the query relationship;
s4, displaying the account list to the target account on the screening interface, wherein the account list is used for pushing target pushing information indicated by the target account.
Optionally, in this embodiment, the storage medium may include, but is not limited to: various media capable of storing program codes, such as a usb disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk.
Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments and optional implementation manners, and this embodiment is not described herein again.
It will be apparent to those skilled in the art that the modules or steps of the present invention described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different than that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. An account screening method is characterized by comprising the following steps:
displaying a plurality of label attribute types on a screening interface, wherein each label attribute type comprises one or more user label attributes;
acquiring one or more target tag attributes selected by a target account from the plurality of tag attribute types, and acquiring an attribute value corresponding to each target tag attribute in the one or more target tag attributes and a query relation of the one or more target tag attributes;
querying an account meeting a target query condition on a database to obtain an account list, wherein the target query condition is constructed by the one or more target tag attributes, an attribute value corresponding to each target tag attribute, and the query relationship;
and displaying the account list to the target account on the screening interface, wherein the account list is used for pushing target pushing information indicated by the target account.
2. The account screening method according to claim 1, wherein the querying accounts satisfying the target query condition on the database includes:
sending a query request to the database, wherein the query request is used for requesting to query an account meeting the target query condition;
receiving a primary account list returned by the database in response to the query request, wherein accounts meeting the target query condition are recorded in the primary account list;
inquiring target user information corresponding to each account recorded in the initial account list;
and recording the account and the target user information with the corresponding relation to obtain the account list.
3. The account screening method according to claim 2, wherein the sending of the query request to the database includes:
performing syntactic analysis on the target query condition according to a data format provided by the database to obtain an analysis result;
carrying out format conversion on the target query condition according to the analysis result to obtain the query request;
and sending the query request to a data interface provided by the database, wherein the data format provided by the database is a data format which can be identified by the data interface provided by the database.
4. The account screening method according to claim 1, wherein before querying the database for accounts satisfying the target query condition, the method further comprises:
splicing the one or more target label attributes and the attribute value corresponding to each target label attribute to obtain one or more key value pairs;
and connecting the one or more key-value pairs by using the query relation to obtain the target query condition.
5. The account screening method according to claim 1, wherein after the displaying the account list to the target account on the screening interface, the method further comprises:
under the condition that the confirmation operation of the target account on the account list is detected, acquiring the target push information indicated by the target account;
and pushing the target pushing information to the account recorded in the account list.
6. The account screening method according to claim 5, wherein after the displaying the account list to the target account on the screening interface, the method further comprises:
under the condition that the withdrawing operation of the target account on the account list is detected, the target query condition is displayed to the target account;
executing the editing operation indicated by the target account on the target query condition to obtain a corrected query condition;
inquiring the account numbers meeting the correction inquiry condition on the database to obtain a correction account number list;
and displaying the revised account list to the target account on the screening interface.
7. The account screening method according to claim 1, wherein the displaying of the plurality of tag attribute types on the screening interface includes:
displaying a terminal basic label type, an intelligent device label type, a user basic label type and a user active label type on the screening interface;
displaying a system label attribute, a version label attribute, a region label attribute and a channel package label attribute in the terminal basic label type; displaying a first binding time tag attribute, a last binding time tag attribute, a number of bound netwares tag attribute, a type of bound netwares tag attribute, whether a custom scene tag attribute is defined and a trigger custom scene number tag attribute in the intelligent equipment tag type; displaying an age label attribute, a gender label attribute, a receiving address label attribute and a user source label attribute in the user basic label type; and displaying a life cycle state label attribute, a continuous active week number label attribute, a continuous inactive week number label attribute, a cumulative active week number label attribute, a user category label attribute, a first active date label attribute and a last active date label attribute in the user active label type.
8. An account screening device, comprising:
the display module is used for displaying a plurality of label attribute types on the screening interface, wherein each label attribute type comprises one or more user label attributes;
a first obtaining module, configured to obtain one or more target tag attributes selected by a target account from the multiple tag attribute types, and obtain an attribute value corresponding to each of the one or more target tag attributes, and a query relationship between the one or more target tag attributes;
the first query module is used for querying accounts meeting target query conditions on a database to obtain an account list, wherein the target query conditions are constructed by the one or more target tag attributes, attribute values corresponding to each target tag attribute and the query relationship;
the first display module is configured to display the account list to the target account on the screening interface, where the account list is used to push target push information indicated by the target account.
9. A computer-readable storage medium, comprising a stored program, wherein the program is operable to perform the method of any one of claims 1 to 7.
10. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to execute the method of any of claims 1 to 7 by means of the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110721977.2A CN113434742A (en) | 2021-06-28 | 2021-06-28 | Account screening method and device, storage medium and electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110721977.2A CN113434742A (en) | 2021-06-28 | 2021-06-28 | Account screening method and device, storage medium and electronic device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113434742A true CN113434742A (en) | 2021-09-24 |
Family
ID=77757353
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110721977.2A Pending CN113434742A (en) | 2021-06-28 | 2021-06-28 | Account screening method and device, storage medium and electronic device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113434742A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114358814A (en) * | 2021-11-29 | 2022-04-15 | 国网北京市电力公司 | Data processing method and device, electronic equipment and computer readable storage medium |
| CN115085968A (en) * | 2022-04-29 | 2022-09-20 | 麒麟软件有限公司 | Login authentication method based on custom tag under Linux |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080301093A1 (en) * | 2007-06-01 | 2008-12-04 | Google Inc. | Determining Search Query Statistical Data for an Advertising Campaign Based on User-Selected Criteria |
| CN102968454A (en) * | 2012-10-26 | 2013-03-13 | 北京百度网讯科技有限公司 | Method and equipment for obtaining search results of popularization object |
| CN106997357A (en) * | 2016-01-22 | 2017-08-01 | 腾讯科技（深圳）有限公司 | A kind of message treatment method, apparatus and system |
| CN108009216A (en) * | 2017-11-17 | 2018-05-08 | 无锡雅座在线科技股份有限公司 | The processing method of destination object, device and system, storage medium, processor |
| CN111400599A (en) * | 2020-03-17 | 2020-07-10 | 苏宁金融科技(南京)有限公司 | User group portrait generation method, device and system |
| CN111506775A (en) * | 2019-01-29 | 2020-08-07 | 阿里巴巴集团控股有限公司 | Label processing method and device, electronic equipment and readable storage medium |
| CN112286927A (en) * | 2019-07-25 | 2021-01-29 | 北京中关村科金技术有限公司 | Method, device and storage medium for inquiring user data |
| CN112507211A (en) * | 2020-11-18 | 2021-03-16 | 青岛海尔科技有限公司 | Message pushing method and device, storage medium and electronic device |
-
2021
- 2021-06-28 CN CN202110721977.2A patent/CN113434742A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080301093A1 (en) * | 2007-06-01 | 2008-12-04 | Google Inc. | Determining Search Query Statistical Data for an Advertising Campaign Based on User-Selected Criteria |
| CN102968454A (en) * | 2012-10-26 | 2013-03-13 | 北京百度网讯科技有限公司 | Method and equipment for obtaining search results of popularization object |
| CN106997357A (en) * | 2016-01-22 | 2017-08-01 | 腾讯科技（深圳）有限公司 | A kind of message treatment method, apparatus and system |
| CN108009216A (en) * | 2017-11-17 | 2018-05-08 | 无锡雅座在线科技股份有限公司 | The processing method of destination object, device and system, storage medium, processor |
| CN111506775A (en) * | 2019-01-29 | 2020-08-07 | 阿里巴巴集团控股有限公司 | Label processing method and device, electronic equipment and readable storage medium |
| CN112286927A (en) * | 2019-07-25 | 2021-01-29 | 北京中关村科金技术有限公司 | Method, device and storage medium for inquiring user data |
| CN111400599A (en) * | 2020-03-17 | 2020-07-10 | 苏宁金融科技(南京)有限公司 | User group portrait generation method, device and system |
| CN112507211A (en) * | 2020-11-18 | 2021-03-16 | 青岛海尔科技有限公司 | Message pushing method and device, storage medium and electronic device |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114358814A (en) * | 2021-11-29 | 2022-04-15 | 国网北京市电力公司 | Data processing method and device, electronic equipment and computer readable storage medium |
| CN115085968A (en) * | 2022-04-29 | 2022-09-20 | 麒麟软件有限公司 | Login authentication method based on custom tag under Linux |
| CN115085968B (en) * | 2022-04-29 | 2023-08-04 | 麒麟软件有限公司 | Login authentication method based on custom tag under Linux |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108255847B (en) | Page generation method and device | |
| CN109818848B (en) | Session display method and device, storage medium and electronic device | |
| CN109657216B (en) | Contract generation method, device, equipment and storage medium | |
| CN101853437A (en) | The system and/or the method for end to end services workflow management, business event management and/or BAM | |
| CN113434742A (en) | Account screening method and device, storage medium and electronic device | |
| CN111367760B (en) | Log collection method and device, computer equipment and storage medium | |
| CN113505265B (en) | Data query method and device, electronic equipment, storage medium and program product | |
| CN112017007A (en) | User behavior data processing method and device, computer equipment and storage medium | |
| CN104869048A (en) | Grouping processing method, device and system of MicroBlog data | |
| CN111784318A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN110941634A (en) | Data processing method and device, storage medium and electronic device | |
| CN111212112A (en) | Information processing method and device | |
| CN115629848A (en) | Business processing method and device, electronic equipment and storage medium | |
| CN109120783A (en) | Information acquisition method and device, mobile terminal and computer readable storage medium | |
| CN115204251A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN112711623A (en) | Data pull-through method and device, storage medium and electronic device | |
| CN111415209A (en) | Information distribution method and device | |
| CN111325484A (en) | Big data asset management system | |
| CN110750563A (en) | Multi-model data processing method, system, device, electronic equipment and storage medium | |
| CN113434504B (en) | Method and device for storing death medical evidence table, storage medium and electronic device | |
| CN113485693B (en) | Interface configuration method, device, equipment and storage medium | |
| CN113434612B (en) | Data statistics method and device, storage medium and electronic device | |
| CN115481932B (en) | ERP system database trigger generation method, storage medium and electronic device | |
| CN113065888B (en) | Method, device and storage medium for recommending business opportunity based on action behavior | |
| CN112200605B (en) | Marketing strategy configuration method, execution method, terminal device and storage 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210924 |