CN109189810B - Query method, query device, electronic equipment and computer-readable storage medium - Google Patents
Query method, query device, electronic equipment and computer-readable storage medium Download PDFInfo
- Publication number
- CN109189810B CN109189810B CN201810991706.7A CN201810991706A CN109189810B CN 109189810 B CN109189810 B CN 109189810B CN 201810991706 A CN201810991706 A CN 201810991706A CN 109189810 B CN109189810 B CN 109189810B
- Authority
- CN
- China
- Prior art keywords
- path
- query
- user
- preset
- data
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 52
- 230000006399 behavior Effects 0.000 claims description 37
- 230000002776 aggregation Effects 0.000 claims description 4
- 238000004220 aggregation Methods 0.000 claims description 4
- 238000004458 analytical method Methods 0.000 description 19
- 238000010586 diagram Methods 0.000 description 15
- 230000006870 function Effects 0.000 description 7
- 238000004891 communication Methods 0.000 description 6
- 238000004590 computer program Methods 0.000 description 6
- 238000013461 design Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 4
- 238000003672 processing method Methods 0.000 description 4
- 238000007619 statistical method Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000007796 conventional method Methods 0.000 description 2
- 230000002354 daily effect Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004141 dimensional analysis Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
Images
Landscapes
- Data Exchanges In Wide-Area Networks (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The embodiment of the disclosure discloses a query method, a query device, electronic equipment and a computer-readable storage medium, wherein the method comprises the following steps: receiving a query statement; wherein the query condition of the query statement includes at least one or more path fields representing a user access path; the user access path is an access path when a user generates a preset behavior in a preset platform; determining a path identifier of the user access path corresponding to the path field; replacing the path field in the query condition with a path identifier corresponding to the path field, and then querying preset query data by using the query statement; and the preset query data at least comprises user flow data with the path identifier as a query dimension. The embodiment of the disclosure can directly use the path identifier to query the preset query data, saves query time, does not need to establish query data for the query dimension according to the object for the user traffic data, and saves storage space.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a query method, an apparatus, an electronic device, and a computer-readable storage medium.
Background
The traffic analysis platform analyzes the user traffic entering the system platform from multiple dimensions such as access path, terminal, version, channel, user and the like, and helps related personnel or departments to better know the user traffic condition of the service, so that the service is further optimized.
In the prior art, data modeling is performed on user traffic data generated on the previous day or the current day from different dimensions in a fixed time period every day, but the data volume obtained by modeling is large due to the fact that the dimensions used for analyzing the user traffic data are numerous, and the time consumed for query analysis is long.
Disclosure of Invention
The embodiment of the disclosure provides a query method, a query device, electronic equipment and a computer-readable storage medium.
In a first aspect, an embodiment of the present disclosure provides a query method.
Specifically, the query method includes:
receiving a query statement; wherein the query condition of the query statement includes at least one or more path fields representing a user access path; the user access path is an access path when a user generates a preset behavior in a preset platform;
determining a path identifier of the user access path corresponding to the path field;
replacing the path field in the query condition with a path identifier corresponding to the path field, and then querying preset query data by using the query statement; and the preset query data at least comprises user flow data with the path identifier as a query dimension.
With reference to the first aspect, in a first implementation manner of the first aspect, the present disclosure further includes:
acquiring a plurality of user access paths when the user generates the preset behavior in the preset platform;
giving a unique path identifier to each acquired user access path;
and establishing incidence relation data between the path identification and the user access path.
With reference to the first implementation manner of the first aspect, in a second implementation manner of the first aspect, the determining a path identifier of the user access path corresponding to the path field includes:
and obtaining one or more path identifications by matching from the incidence relation data according to the path field.
With reference to the first implementation manner of the first aspect and the second implementation manner of the first aspect, in a third implementation manner of the first aspect, the present disclosure further includes:
acquiring user flow data generated by the preset platform in a preset time period;
and generating preset query data by taking the path identifier as a query dimension aiming at the user traffic data.
In a second aspect, an embodiment of the present disclosure provides an inquiry apparatus, including:
a receiving module configured to receive a query statement; wherein the query condition of the query statement includes at least one or more path fields representing a user access path; the user access path is an access path when a user generates a preset behavior in a preset platform;
a determining module configured to determine a path identifier of the user access path corresponding to the path field;
the query module is configured to replace the path field in the query condition with a path identifier corresponding to the path field and then query preset query data by using the query statement; and the preset query data at least comprises user flow data with the path identifier as a query dimension.
With reference to the second aspect, in a first implementation manner of the second aspect, the present disclosure further includes:
the obtaining module is configured to obtain a plurality of user access paths when the user generates the preset behavior in the preset platform;
the assignment module is configured to assign a unique path identifier to each acquired user access path;
an establishing module configured to establish association relationship data between the path identifier and the user access path.
With reference to the first implementation manner of the second aspect, in a second implementation manner of the second aspect, the determining module of the present disclosure includes:
and the matching sub-module is configured to obtain one or more path identifications from the association relation data according to the path field in a matching mode.
With reference to the first implementation manner of the second aspect and the second implementation manner of the second aspect, in a third implementation manner of the second aspect, the present disclosure further includes:
the acquisition submodule is configured to acquire user traffic data generated by the preset platform within a preset time period;
and the generation sub-module is configured to generate preset query data by taking the path identifier as a query dimension aiming at the user traffic data.
The functions can be realized by hardware, and the functions can also be realized by executing corresponding software by hardware. The hardware or software includes one or more modules corresponding to the above-described functions.
In one possible design, the structure of the querying device includes a memory and a processor, the memory is used for storing one or more computer instructions for supporting the querying device to execute the querying method in the first aspect, and the processor is configured to execute the computer instructions stored in the memory. The querying device may further comprise a communication interface for communicating the querying device with other devices or a communication network.
In a third aspect, an embodiment of the present disclosure provides an electronic device, including a memory and a processor; wherein the memory is configured to store one or more computer instructions, wherein the one or more computer instructions are executed by the processor to implement the method steps of the first aspect.
In a fourth aspect, the disclosed embodiments provide a computer-readable storage medium for storing computer instructions for an inquiry apparatus, which contains computer instructions for executing the inquiry method in the first aspect.
The technical scheme provided by the embodiment of the disclosure can have the following beneficial effects:
when user traffic data are analyzed, at least one or more objects in a user access path are used as query conditions for querying, and after a query statement is received, the query statement is split, the objects are obtained from the query conditions, path identifiers of the access path corresponding to the objects are obtained according to the objects, and then the path identifiers are brought into the query statement to query preset query data comprising the user traffic data. Through the method, the preset query data with the path identification corresponding to the user access path as the query dimension can be pre-established according to the user flow data generated on the system platform, the query statement is split when the user flow is analyzed, the preset query data is queried according to the path identification corresponding to the object in the query condition, and then the preset query data is queried according to the path identification, so that the problem of low reflection speed caused by querying with the object as the dimension in one query is solved, the query time can be saved, the query data does not need to be established according to the object as the query dimension for the user flow data, and the storage space is saved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
Drawings
Other features, objects, and advantages of the present disclosure will become more apparent from the following detailed description of non-limiting embodiments when taken in conjunction with the accompanying drawings. In the drawings:
FIG. 1 illustrates a flow diagram of a query method according to an embodiment of the present disclosure;
FIG. 2 illustrates a flow diagram of establishing an association data portion in a query method according to another embodiment of the disclosure;
FIG. 3 shows a flowchart of step S102 according to the embodiment shown in FIG. 1;
FIG. 4 shows a block diagram of a query device according to an embodiment of the present disclosure;
FIG. 5 is a block diagram illustrating the structure of a data portion for establishing an association relationship in a querying device according to another embodiment of the present disclosure;
FIG. 6 illustrates a block diagram of the determination module 402 according to the embodiment shown in FIG. 4;
FIG. 7 illustrates an application scenario diagram according to an embodiment of the present disclosure;
fig. 8 is a schematic structural diagram of an electronic device suitable for implementing a query method according to an embodiment of the present disclosure.
Detailed Description
Hereinafter, exemplary embodiments of the present disclosure will be described in detail with reference to the accompanying drawings so that those skilled in the art can easily implement them. Also, for the sake of clarity, parts not relevant to the description of the exemplary embodiments are omitted in the drawings.
In the present disclosure, it is to be understood that terms such as "including" or "having," etc., are intended to indicate the presence of the disclosed features, numbers, steps, behaviors, components, parts, or combinations thereof, and are not intended to preclude the possibility that one or more other features, numbers, steps, behaviors, components, parts, or combinations thereof may be present or added.
It should be further noted that the embodiments and features of the embodiments in the present disclosure may be combined with each other without conflict. The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
FIG. 1 shows a flow diagram of a query method according to an embodiment of the present disclosure. As shown in fig. 1, the query method includes the following steps S101 to S103:
in step S101, a query statement is received; wherein the query condition of the query statement includes at least one or more path fields representing a user access path; the user access path is an access path when a user generates a preset behavior in a preset platform;
in step S102, determining a path identifier of the user access path corresponding to the path field;
in step S103, after replacing the path field in the query condition with a path identifier corresponding to the path field, using the query statement to query preset query data; and the preset query data at least comprises user flow data with the path identifier as a query dimension.
When statistical analysis is performed on user traffic data, in order to save time and other resources of an analyst and facilitate the analyst to directly obtain useful information using a query statement, modeling is usually performed on the user traffic data generated within a predetermined time period on a system platform in advance. The process of modeling typically includes: acquiring user traffic data generated in a system platform by a user, wherein the data usually exists in a log form; after the user flow data are obtained, carrying out multi-dimensional modeling on the user flow data according to the actual situation, namely establishing query data by taking various dimensions as main keys; after the query data is built, the query can be made directly using one or more of these dimensions. For example, when modeling user traffic data corresponding to a user access path generated by a user in a system platform, a variety of query data may be established in dimensions of each page, channel, location, content, button, and the like that the user access path may include.
In this embodiment, the preset platform may be an online platform that the user can access, and the preset platform may provide services such as information browsing, commodity display, commodity purchase, and the like for the user. When the user accesses the preset platform, the user traffic data generated by the user can be recorded in a log form. The user access path may be a path taken by the user from entering the preset platform to generating a certain preset behavior, that is, a page element that the user has passed through from entering the preset platform to generating the preset behavior. The preset behavior is a certain operation behavior generated by the user on the system platform, and can be preset according to an actual situation, for example, for an e-commerce operation platform, when statistical analysis is performed on the flow rate of a user order, the preset behavior can be set as an order placing behavior of the user.
In this embodiment, the user access path is formed by one or more access objects, and each access object may be different according to a difference of the preset platform, specifically according to an actual situation of the preset platform. The access object can be a page element in a preset platform, such as a page, a button, a banner advertisement and a menu. For example, a user enters a channel second-level page by clicking a restaurant on a take-away platform home page, and a banner advertisement on the channel second-level page selects a merchant to enter a menu ordering page of the merchant. After the dish is ordered, click the 'selected' button, enter an order page, and click the 'go to pay' button to submit the order. Then the user access path for the user to generate the preset behavior, i.e. to place an order, is: the first page is catering, the banner advertisement of the channel second-level page is displayed, the order page is selected, and the order is submitted.
It should be noted that, in the background implementation process, the access object in the user access path is represented by using one or more different path fields, that is, in the data representation aspect, the user access path is represented by using one or more path fields. For example, the preset platform can be divided into a plurality of levels according to a webpage design scheme, wherein the home page of the preset platform is a first level, the next page from the home page is a second level, and so on; the page elements in each hierarchy may also be partitioned into regions, locations, content, and content types, for example, the access objects in the user access path in the above example may be represented by the following path fields: a corresponding hierarchy field of a home page in the e-commerce platform is P01, an area field corresponding to a food and drink is A-3, and a content field corresponding to the food and drink is A0001; the corresponding hierarchical field of the banner advertisement of the channel secondary page is P02, and the area is B-1; the order page has a corresponding level field P05, a position field E-0-1, an order page submitted order corresponding level field P08, and a position field H-0-1. At the time of querying, the query condition is queried in one or more fields in the user access path. For example, a user access path where the query includes the P01 hierarchical region field a-3, then "P01 _ position _ group ═ a-3'" may be defined after where of the query statement.
In this embodiment, the user access path is given a path identifier in advance. The paths that a user may pass from entering the preset platform to generating the preset behavior are various, and during the period, user traffic data generated by the user accessing the preset platform is recorded in a log form. For each possible path, giving a path identifier in advance, and after obtaining a query statement for the user traffic data, matching one or more path fields representing user access paths in query conditions to obtain corresponding path representations. It should be noted that, in the query condition of the query statement, the field indicating the user access path is not necessarily a plurality of path fields constituting a complete path, but may be a part of the path field of the user access path. For example, for the path of "home dining- > banner advertisement of channel level two page- > order page selected- > order page submitted order" that the user passes through when placing an order on the e-commerce platform, in the query statement, the query may be performed with only "P01 _ position _ group ═ a-3'" as the query condition.
In this embodiment, after the path identifier corresponding to the path field indicating the user access path in the query condition is determined, the field may be replaced with the corresponding path identifier in the query condition, and then the preset query data may be queried.
The preset query data is user flow data which is calculated in advance and has query dimensionality. And in the process of accessing the preset platform by the user, the generated flow data is recorded in a log form. And the system pre-calculates the flow data every predetermined period of time. For example, each morning, user traffic data generated the last day is data modeled. The data modeling process is to pre-calculate the user flow data according to a preset dimension, so that the pre-calculated preset query data is organized by the preset dimension, namely the preset dimension is used as a main key. In this embodiment, the preset query data at least includes user traffic data with the path identifier as the query dimension. It is understood that the analysis of the user traffic data is not limited to the dimension of the access path from the user, but may also be performed through other dimensions, such as the area, city, business district, terminal, version, channel, user data, etc. where the user is located. Therefore, in practical application, other preset query data with other dimensions as main keys are established for the user traffic data. Because the user access path is composed of a plurality of path fields, when the user access path is taken as a dimension to analyze user traffic data, a conventional processing method is to establish preset query data by taking each path field in the user access path as a dimension, that is, if the user access path includes N fields at most, the preset query data of N dimensions needs to be established for the analysis dimension of the user access path. If other dimensions such as a large area, a city, a business district, a terminal, a version, a channel, user data and the like include M, the number of preset query data for establishing a single dimension is N + M, and the number of preset query data for establishing a combined dimension (any two dimensions in N + M are primary keys) is N + M times of 2, the data expansion rate is very large, and the occupied space of the established preset query data is also huge. Considering that a user access path is represented by a plurality of path fields in time, and according to the conventional method, corresponding preset query data needs to be established by taking each path field as a dimension, the data volume is large.
Therefore, the method and the device have the advantages that the multiple path field dimensions of the user access path are subjected to dimension aggregation to form a path identifier, the path identifier is used as the dimension to establish the preset query data, and the path field is no longer used as the dimension to establish the preset query data. However, this method also has a disadvantage that the query speed is very fast if the path field is not involved in the query condition; however, if the path field exists, the query is very slow because preset query data is not pre-established for the path field. Therefore, in the embodiment of the present disclosure, to solve the problem, after the query statement is obtained, the path field representing the user access path in the query condition is replaced with the corresponding path identifier, and the query is performed from the preset query data with the path identifier as the dimension by using the path identifier as the query condition, so that time resources and space resources for establishing the preset query data with each path field in the access path identifier as the dimension are saved, and in the subsequent query process, the query statement is subjected to a two-step mode (the path identifier is determined in the first step, and the query is performed with the path identifier as the query condition in the second step), the query speed is greatly increased, so that the influence of the mode for establishing the preset query data with the path identifier on the query speed can be ignored and is not remembered.
In order to solve the problem of slow query speed, the above embodiment of the present disclosure is implemented by splitting a query statement including a path field in a query condition into two parts, which is described below by way of example:
the received query statement is as follows:
SELECT count(distinct cuid)as user_num，sum(real_total_price)/1000 as real_total_price，count(0)as order_num FROM fact_flow_order_funnel_ex join dim_trace_details_ex on path_id＝id WHERE index_day＝′20180306′and p05_position_id in(′E′，′E′，′E-0′，′E-1′，′E-0′，′E-0-1′，′E-1-1′，′E-1-2′，′E-1-3′)and p02_position_group＝′B-1′and me_position_id in(′H′，′H′，′H-0′，′H-0′，′H-0-1′）and p01_content_id＝′A0001′and p01_position_group＝′A-3′and from_type in(′na-android′，′na-iphone′)
wherein, p05_ position _ id, p02_ position _ id, me _ position _ id, p01_ content _ id, and p01_ position _ group following the query condition where are all path fields;
the embodiment of the disclosure determines the path identifier corresponding to the path field through the following query statement:
then, the embodiment of the present disclosure replaces the path field with the obtained path identifier to obtain the following query statement:
wherein, the path _ id is a path identifier determined according to the path field.
When user traffic data are analyzed, at least one or more objects in a user access path are used as query conditions for querying, and after a query statement is received, the query statement is split, the objects are obtained from the query conditions, path identifiers of the access path corresponding to the objects are obtained according to the objects, and then the path identifiers are brought into the query statement to query preset query data comprising the user traffic data. Through the method, the preset query data with the path identification corresponding to the user access path as the query dimension can be pre-established according to the user flow data generated on the system platform, the query statement is split when the user flow is analyzed, the preset query data is queried according to the path identification corresponding to the object in the query condition, and then the preset query data is queried according to the path identification, so that the problem of low reflection speed caused by querying with the object as the dimension in one query is solved, the query time can be saved, the query data does not need to be established according to the object as the query dimension for the user flow data, and the storage space is saved.
In an optional implementation manner of this embodiment, as shown in fig. 2, the method further includes the following steps S201 to S203:
in step S201, a plurality of user access paths when the user generates the preset behavior in the preset platform are obtained;
in step S202, a unique path identifier is assigned to each of the acquired user access paths;
in step S203, association relationship data between the path identifier and the user access path is established.
In this optional implementation, before analyzing the user traffic data, in order to quickly query the required data in the analysis process, the user traffic data may be pre-calculated. In the process of accessing the preset platform by the user, the flow data generated by the user is usually recorded in a log form, and the log data is very messy and cannot be effectively retrieved without being pre-calculated. After the preset query data are established in advance by one or more analysis dimensions, the preset query data are queried, so that the query speed is increased, and the query effectiveness can be improved. The present embodiment is mainly directed to an analysis dimension of a user access path.
The user access path can be divided according to the architecture of the actual preset platform. For example, since the web page designs of the preset platform all have a hierarchical relationship, the user access paths can be artificially and hierarchically divided. For example, the page or other access object corresponding to the 10 th level P9 does not include any other page that can be clicked or otherwise manipulated to enter the next level, if the maximum level is 10, the home page may be set to the level P0, and if the maximum level is clicked or otherwise manipulated to enter any page, the next level P1 is entered, and so on. If modeling user traffic data corresponding to the user access path according to the prior art needs to be performed from ten levels P0-P9 and page elements included in each level, and if the page elements included in each level can be identified from 4 aspects including the area, position, content and content identification of the page elements, when modeling data for the user access path, in order to query from the path field, preset query data of 4 x 10-40 dimensions needs to be established, that is, 40 different preset query data are established by using 40 path fields as main keys, which makes the time spent on modeling data too long, and the storage space occupied by the 40 different preset query data obtained by modeling is also large, especially when modeling data of a dimension combined with other analysis dimensions, the preset query data is expanded in exponential steps. In the embodiment, a unique path identifier can be given to the user access path in advance, and when data modeling is performed, the preset query data is established by taking the path identifier as a dimension, so that not only can the data modeling time be saved, but also the storage space of the query data can be saved.
In this embodiment, a plurality of user access paths that a user may pass through when the user generates a preset behavior in the preset platform are obtained, and the obtained plurality of user access paths may be all possible paths when the user generates the preset behavior, or may be a part of paths that often occur, which is specifically set according to an actual situation, and are not limited herein. And giving a unique path identifier to each obtained user access path, and storing the path identifier and the corresponding user access path in an associated manner to obtain association relation data.
In an optional implementation manner of this embodiment, the step S102, that is, the step of determining the path identifier of the user access path corresponding to the path field, further includes the following steps:
and obtaining one or more path identifications by matching from the incidence relation data according to the path field.
In this optional implementation, after the association relationship data between the path identifier and the path field in the user access path is pre-established, the path field may be used to perform matching from the association relationship data, so as to obtain the user access path possibly corresponding to the path field. The association data may be stored in the form of a mapping table. A path field may correspond to multiple path identifications because some user access paths are partially cross-registered.
In an optional implementation manner of this embodiment, as shown in fig. 3, the step S102 further includes the following steps S301 to S302:
in step S301, user traffic data generated by a user on the preset platform within a preset time period is acquired;
in step S302, for the user traffic data, preset query data is generated with the path identifier as a query dimension.
In this optional implementation, the user traffic analysis may be performed periodically or may be performed specifically under the trigger of a certain condition. For example, user traffic data generated on the previous day is analyzed at a daily timing. The user traffic data is data generated when the user accesses the preset platform, and includes user data, an operation performed by the user on the preset platform, an accessed page element, and the like. During the period that the user accesses the preset platform, the user flow data is recorded in a log mode. Before analyzing the user traffic data, the user traffic data is first obtained from the log. Because the acquired user traffic data is one-by-one log data, the pre-calculation of one or more query dimensions can be performed on the user traffic data, that is, the user traffic data is organized by taking the query dimensions as main keys to generate preset query data. In the optional implementation manner, the user traffic data is pre-calculated according to the path identifier corresponding to the user access path through which the user generates the preset behavior, and the preset query data with the path identifier as the query dimension is generated, so that the preset query data can be subsequently queried directly by using the path identifier. In this way, the user traffic data can be retrieved by the path identifier, and data support is provided for the analysis of the subsequent user traffic data.
The following are embodiments of the disclosed apparatus that may be used to perform embodiments of the disclosed methods.
Fig. 4 shows a block diagram of a query device according to an embodiment of the present disclosure, which may be implemented as part or all of an electronic device by software, hardware, or a combination of the two. As shown in fig. 4, the querying device includes a receiving module 401, a determining module 402, and a querying module 403:
a receiving module 401 configured to receive a query statement; wherein the query condition of the query statement includes at least one or more path fields representing a user access path; the user access path is an access path when a user generates a preset behavior in a preset platform;
a determining module 402 configured to determine a path identifier of the user access path corresponding to the path field;
the query module 403 is configured to replace the path field in the query condition with a path identifier corresponding to the path field, and then query preset query data by using the query statement; and the preset query data at least comprises user flow data with the path identifier as a query dimension.
In this embodiment, the preset platform may be an online platform that the user can access, and the preset platform may provide services such as information browsing, commodity display, commodity purchase, and the like for the user. When the user accesses the preset platform, the user traffic data generated by the user can be recorded in a log form. The user access path may be a path taken by the user from entering the preset platform to generating a certain preset behavior, that is, a page element that the user has passed through from entering the preset platform to generating the preset behavior. The preset behavior is a certain operation behavior generated by the user on the system platform, and can be preset according to an actual situation, for example, for an e-commerce operation platform, when statistical analysis is performed on the flow rate of a user order, the preset behavior can be set as an order placing behavior of the user.
In this embodiment, the user access path is formed by one or more access objects, and each access object may be different according to a difference of the preset platform, specifically according to an actual situation of the preset platform. The access object can be a page element in a preset platform, such as a page, a button, a banner advertisement and a menu. For example, a user enters a channel second-level page by clicking a restaurant on a take-away platform home page, and a banner advertisement on the channel second-level page selects a merchant to enter a menu ordering page of the merchant. After the dish is ordered, click the 'selected' button, enter an order page, and click the 'go to pay' button to submit the order. Then the user access path for the user to generate the preset behavior, i.e. to place an order, is: the first page is catering, the banner advertisement of the channel second-level page is displayed, the order page is selected, and the order is submitted.
It should be noted that, in the background implementation process, the access object in the user access path is represented by using one or more different path fields, that is, in the data representation aspect, the user access path is represented by using one or more path fields. For example, the preset platform can be divided into a plurality of levels according to a webpage design scheme, wherein the home page of the preset platform is a first level, the next page from the home page is a second level, and so on; the page elements in each hierarchy may also be partitioned into regions, locations, content, and content types, for example, the access objects in the user access path in the above example may be represented by the following path fields: a corresponding hierarchy field of a home page in the e-commerce platform is P01, an area field corresponding to a food and drink is A-3, and a content field corresponding to the food and drink is A0001; the corresponding hierarchical field of the banner advertisement of the channel secondary page is P02, and the area is B-1; the order page has a corresponding level field P05, a position field E-0-1, an order page submitted order corresponding level field P08, and a position field H-0-1. At the time of querying, the query condition is queried in one or more fields in the user access path. For example, a user access path where the query includes the P01 hierarchical region field a-3, then "P01 _ position _ group ═ a-3'" may be defined after where of the query statement.
In this embodiment, the user access path is given a path identifier in advance. The paths that a user may pass from entering the preset platform to generating the preset behavior are various, and during the period, user traffic data generated by the user accessing the preset platform is recorded in a log form. For each possible path, giving a path identifier in advance, and after obtaining a query statement for the user traffic data, matching one or more path fields representing user access paths in query conditions to obtain corresponding path representations. It should be noted that, in the query condition of the query statement, the field indicating the user access path is not necessarily a plurality of path fields constituting a complete path, but may be a part of the path field of the user access path. For example, for the path of "home dining- > banner advertisement of channel level two page- > order page selected- > order page submitted order" that the user passes through when placing an order on the e-commerce platform, in the query statement, the query may be performed with only "P01 _ position _ group ═ a-3'" as the query condition.
In this embodiment, after the path identifier corresponding to the path field indicating the user access path in the query condition is determined, the field may be replaced with the corresponding path identifier in the query condition, and then the preset query data may be queried.
The preset query data is user flow data which is calculated in advance and has query dimensionality. And in the process of accessing the preset platform by the user, the generated flow data is recorded in a log form. And the system pre-calculates the flow data every predetermined period of time. For example, each morning, user traffic data generated the last day is data modeled. The data modeling process is to pre-calculate the user flow data according to a preset dimension, so that the pre-calculated preset query data is organized by the preset dimension, namely the preset dimension is used as a main key. In this embodiment, the preset query data at least includes user traffic data with the path identifier as the query dimension. It is understood that the analysis of the user traffic data is not limited to the dimension of the access path from the user, but may also be performed through other dimensions, such as the area, city, business district, terminal, version, channel, user data, etc. where the user is located. Therefore, in practical application, other preset query data with other dimensions as main keys are established for the user traffic data. Because the user access path is composed of a plurality of path fields, when the user access path is taken as a dimension to analyze user traffic data, a conventional processing method is to establish preset query data by taking each path field in the user access path as a dimension, that is, if the user access path includes N fields at most, the preset query data of N dimensions needs to be established for the analysis dimension of the user access path. If other dimensions such as a large area, a city, a business district, a terminal, a version, a channel, user data and the like include M, the number of preset query data for establishing a single dimension is N + M, and the number of preset query data for establishing a combined dimension (any two dimensions in N + M are primary keys) is N + M times of 2, the data expansion rate is very large, and the occupied space of the established preset query data is also huge. Considering that a user access path is represented by a plurality of path fields in time, and according to the conventional method, corresponding preset query data needs to be established by taking each path field as a dimension, the data volume is large.
Therefore, the method and the device have the advantages that the multiple path field dimensions of the user access path are subjected to dimension aggregation to form a path identifier, the path identifier is used as the dimension to establish the preset query data, and the path field is no longer used as the dimension to establish the preset query data. However, this method also has a disadvantage that the query speed is very fast if the path field is not involved in the query condition; however, if the path field exists, the query is very slow because preset query data is not pre-established for the path field. Therefore, in the embodiment of the present disclosure, to solve the problem, after the query statement is obtained, the path field representing the user access path in the query condition is replaced with the corresponding path identifier, and the query is performed from the preset query data with the path identifier as the dimension by using the path identifier as the query condition, so that time resources and space resources for establishing the preset query data with each path field in the access path identifier as the dimension are saved, and in the subsequent query process, the query statement is subjected to a two-step mode (the path identifier is determined in the first step, and the query is performed with the path identifier as the query condition in the second step), the query speed is greatly increased, so that the influence of the mode for establishing the preset query data with the path identifier on the query speed can be ignored and is not remembered.
In order to solve the problem of slow query speed, the above embodiment of the present disclosure is implemented by splitting a query statement including a path field in a query condition into two parts, which is described below by way of example:
the received query statement is as follows:
SELECT count(distinct cuid)as user_num，sum(real_total_price)/1000 as real_total_price，count(0)as order_num FROM fact_flow_order_funnel_ex join dim_trace_details_ex on path_id＝id WHERE index_day＝′20180306′and p05_position_id in(′E′，′E′，′E-0′，′E-1′，′E-0′，′E-0-1′，′E-1-1′，′E-1-2′，′E-1-3′)and p02_position_group＝′B-1′and me_position_id in(′H′，′H′，′H-0′，′H-0′，′H-0-1′)and p01_content_id＝A0001′and p01_position_group＝′A-3′and from_type in(′na-android′，′na-iphone′)
wherein, p05_ position _ id, p02_ position _ id, me _ position _ id, p01_ content _ id, and p01_ position _ group following the query condition where are all path fields;
the embodiment of the disclosure determines the path identifier corresponding to the path field through the following query statement:
then, the embodiment of the present disclosure replaces the path field with the obtained path identifier to obtain the following query statement:
wherein, the path _ id is a path identifier determined according to the path field.
When user traffic data are analyzed, at least one or more objects in a user access path are used as query conditions for querying, and after a query statement is received, the query statement is split, the objects are obtained from the query conditions, path identifiers of the access path corresponding to the objects are obtained according to the objects, and then the path identifiers are brought into the query statement to query preset query data comprising the user traffic data. Through the method, the preset query data with the path identification corresponding to the user access path as the query dimension can be pre-established according to the user flow data generated on the system platform, the query statement is split when the user flow is analyzed, the preset query data is queried according to the path identification corresponding to the object in the query condition, and then the preset query data is queried according to the path identification, so that the problem of low reflection speed caused by querying with the object as the dimension in one query is solved, the query time can be saved, the query data does not need to be established according to the object as the query dimension for the user flow data, and the storage space is saved.
In an optional implementation manner of this embodiment, as shown in fig. 5, the apparatus further includes an obtaining module 501, an assigning module 502, and an establishing module 503:
an obtaining module 501, configured to obtain a plurality of user access paths when the user generates the preset behavior in the preset platform;
an assignment module 502 configured to assign a unique path identifier to each of the obtained user access paths;
an establishing module 503 configured to establish association relationship data between the path identifier and the user access path.
In this optional implementation, before analyzing the user traffic data, in order to quickly query the required data in the analysis process, the user traffic data may be pre-calculated. In the process of accessing the preset platform by the user, the flow data generated by the user is usually recorded in a log form, and the log data is very messy and cannot be effectively retrieved without being pre-calculated. After the preset query data are established in advance by one or more analysis dimensions, the preset query data are queried, so that the query speed is increased, and the query effectiveness can be improved. The present embodiment is mainly directed to an analysis dimension of a user access path.
The user access path can be divided according to the architecture of the actual preset platform. For example, since the web page designs of the preset platform all have a hierarchical relationship, the user access paths can be artificially and hierarchically divided. For example, the page or other access object corresponding to the 10 th level P9 does not include any other page that can be clicked or otherwise manipulated to enter the next level, if the maximum level is 10, the home page may be set to the level P0, and if the maximum level is clicked or otherwise manipulated to enter any page, the next level P1 is entered, and so on. If modeling user traffic data corresponding to the user access path according to the prior art needs to be performed from ten levels P0-P9 and page elements included in each level, and if the page elements included in each level can be identified from 4 aspects including the area, position, content and content identification of the page elements, when modeling data for the user access path, in order to query from the path field, preset query data of 4 x 10-40 dimensions needs to be established, that is, 40 different preset query data are established by using 40 path fields as main keys, which makes the time spent on modeling data too long, and the storage space occupied by the 40 different preset query data obtained by modeling is also large, especially when modeling data of a dimension combined with other analysis dimensions, the preset query data is expanded in exponential steps. In the embodiment, a unique path identifier can be given to the user access path in advance, and when data modeling is performed, the preset query data is established by taking the path identifier as a dimension, so that not only can the data modeling time be saved, but also the storage space of the query data can be saved.
In this embodiment, a plurality of user access paths that a user may pass through when the user generates a preset behavior in the preset platform are obtained, and the obtained plurality of user access paths may be all possible paths when the user generates the preset behavior, or may be a part of paths that often occur, which is specifically set according to an actual situation, and are not limited herein. And giving a unique path identifier to each obtained user access path, and storing the path identifier and the corresponding user access path in an associated manner to obtain association relation data.
In an optional implementation manner of this embodiment, the determining module 402 further includes a matching sub-module:
and the matching sub-module is configured to obtain one or more path identifications from the association relation data according to the path field in a matching mode.
In this optional implementation, after the association relationship data between the path identifier and the path field in the user access path is pre-established, the path field may be used to perform matching from the association relationship data, so as to obtain the user access path possibly corresponding to the path field. The association data may be stored in the form of a mapping table. A path field may correspond to multiple path identifications because some user access paths are partially cross-registered.
In an optional implementation manner of this embodiment, as shown in fig. 6, the apparatus further includes an obtaining sub-module 601 and a generating sub-module 602:
the obtaining sub-module 601 is configured to obtain user traffic data generated in a preset time period on the preset platform;
a generating sub-module 602, configured to generate preset query data with the path identifier as a query dimension for the user traffic data.
In this optional implementation, the user traffic analysis may be performed periodically or may be performed specifically under the trigger of a certain condition. For example, user traffic data generated on the previous day is analyzed at a daily timing. The user traffic data is data generated when the user accesses the preset platform, and includes user data, an operation performed by the user on the preset platform, an accessed page element, and the like. During the period that the user accesses the preset platform, the user flow data is recorded in a log mode. Before analyzing the user traffic data, the user traffic data is first obtained from the log. Because the acquired user traffic data is one-by-one log data, the pre-calculation of one or more query dimensions can be performed on the user traffic data, that is, the user traffic data is organized by taking the query dimensions as main keys to generate preset query data. In the optional implementation manner, the user traffic data is pre-calculated according to the path identifier corresponding to the user access path through which the user generates the preset behavior, and the preset query data with the path identifier as the query dimension is generated, so that the preset query data can be subsequently queried directly by using the path identifier. In this way, the user traffic data can be retrieved by the path identifier, and data support is provided for the analysis of the subsequent user traffic data.
Fig. 7 is a diagram illustrating an application scenario of the data processing method or the data processing apparatus proposed in the embodiment of the present disclosure. Apache Kylin is an open-source distributed analysis engine providing SQL query interface over Hadoop/Spark and multi-dimensional analysis (OLAP) capability to support very large scale data. The data processing method provided by the embodiment of the disclosure can be applied to the Apache Kylin for processing multidimensional data, for example, when a user behavior is analyzed, an inquiry statement can be sent to the Apache Kylin, the Apache Kylin can process the inquiry statement according to the inquiry statement by the method provided by the embodiment of the disclosure, and then inquire the multidimensional data from hive, so that the inquiry efficiency can be improved.
Fig. 8 is a schematic structural diagram of an electronic device suitable for implementing a query method according to an embodiment of the present disclosure.
As shown in fig. 8, the electronic apparatus 800 includes a Central Processing Unit (CPU)801 that can execute various processes in the embodiment shown in fig. 1 described above according to a program stored in a Read Only Memory (ROM)802 or a program loaded from a storage section 808 into a Random Access Memory (RAM) 803. In the RAM803, various programs and data necessary for the operation of the electronic apparatus 800 are also stored. The CPU801, ROM802, and RAM803 are connected to each other via a bus 804. An input/output (I/O) interface 805 is also connected to bus 804.
The following components are connected to the I/O interface 805: an input portion 806 including a keyboard, a mouse, and the like; an output section 807 including a signal such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 808 including a hard disk and the like; and a communication section 809 including a network interface card such as a LAN card, a modem, or the like. The communication section 809 performs communication processing via a network such as the internet. A drive 810 is also connected to the I/O interface 805 as necessary. A removable medium 811 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 810 as necessary, so that a computer program read out therefrom is mounted on the storage section 808 as necessary.
In particular, according to embodiments of the present disclosure, the method described above with reference to fig. 1 may be implemented as a computer software program. For example, embodiments of the present disclosure include a computer program product comprising a computer program tangibly embodied on a medium readable thereby, the computer program comprising program code for performing the method of fig. 1. In such an embodiment, the computer program may be downloaded and installed from a network via the communication section 809 and/or installed from the removable medium 811.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowcharts or block diagrams may represent a module, a program segment, or a portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units or modules described in the embodiments of the present disclosure may be implemented by software or hardware. The units or modules described may also be provided in a processor, and the names of the units or modules do not in some cases constitute a limitation of the units or modules themselves.
As another aspect, the present disclosure also provides a computer-readable storage medium, which may be the computer-readable storage medium included in the apparatus in the above-described embodiment; or it may be a separate computer readable storage medium not incorporated into the device. The computer readable storage medium stores one or more programs for use by one or more processors in performing the methods described in the present disclosure.
The foregoing description is only exemplary of the preferred embodiments of the disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the invention in the present disclosure is not limited to the specific combination of the above-mentioned features, but also encompasses other embodiments in which any combination of the above-mentioned features or their equivalents is possible without departing from the inventive concept. For example, the above features and (but not limited to) the features disclosed in this disclosure having similar functions are replaced with each other to form the technical solution.
Claims (10)
1. A method for querying user traffic data is characterized by comprising the following steps:
receiving a query statement; wherein the query condition of the query statement includes at least one or more path fields representing a user access path; the user access path is an access path which is passed by a user from entering a preset platform to the occurrence of a preset behavior;
determining a path identifier of the user access path corresponding to the path field;
replacing the path field in the query condition with a path identifier corresponding to the path field, and then querying preset query data by using the query statement; the preset query data at least comprises user traffic data with the path identifier as a query dimension; and the path identifier is obtained by carrying out dimension aggregation according to a plurality of path fields of the user access path.
2. The query method of claim 1, further comprising:
acquiring a plurality of user access paths when the user generates the preset behavior in the preset platform;
giving a unique path identifier to each acquired user access path;
and establishing incidence relation data between the path identification and the user access path.
3. The query method according to claim 2, wherein determining the path identifier of the user access path corresponding to the path field comprises:
and obtaining one or more path identifications by matching from the incidence relation data according to the path field.
4. The query method according to claim 2 or 3, further comprising:
acquiring user flow data generated by the preset platform in a preset time period;
and generating preset query data by taking the path identifier as a query dimension aiming at the user traffic data.
5. An apparatus for querying user traffic data, comprising:
a receiving module configured to receive a query statement; wherein the query condition of the query statement includes at least one or more path fields representing a user access path; the user access path is an access path which is passed by a user from entering a preset platform to the occurrence of a preset behavior;
a determining module configured to determine a path identifier of the user access path corresponding to the path field;
the query module is configured to replace the path field in the query condition with a path identifier corresponding to the path field and then query preset query data by using the query statement; the preset query data at least comprises user traffic data with the path identifier as a query dimension; and the path identifier is obtained by carrying out dimension aggregation according to a plurality of path fields of the user access path.
6. The query device of claim 5, further comprising:
the obtaining module is configured to obtain a plurality of user access paths when the user generates the preset behavior in the preset platform;
the assignment module is configured to assign a unique path identifier to each acquired user access path;
an establishing module configured to establish association relationship data between the path identifier and the user access path.
7. The query device of claim 6, wherein the determining module comprises:
and the matching sub-module is configured to obtain one or more path identifications from the association relation data according to the path field in a matching mode.
8. The query device according to claim 6 or 7, further comprising:
the acquisition submodule is configured to acquire user traffic data generated by the preset platform within a preset time period;
and the generation sub-module is configured to generate preset query data by taking the path identifier as a query dimension aiming at the user traffic data.
9. An electronic device comprising a memory and a processor; wherein,
the memory is configured to store one or more computer instructions, wherein the one or more computer instructions are executed by the processor to implement the method steps of any of claims 1-4.
10. A computer-readable storage medium having stored thereon computer instructions, characterized in that the computer instructions, when executed by a processor, carry out the method steps of any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810991706.7A CN109189810B (en) | 2018-08-28 | 2018-08-28 | Query method, query device, electronic equipment and computer-readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810991706.7A CN109189810B (en) | 2018-08-28 | 2018-08-28 | Query method, query device, electronic equipment and computer-readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109189810A CN109189810A (en) | 2019-01-11 |
| CN109189810B true CN109189810B (en) | 2021-07-02 |
Family
ID=64916910
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810991706.7A Expired - Fee Related CN109189810B (en) | 2018-08-28 | 2018-08-28 | Query method, query device, electronic equipment and computer-readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109189810B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111523072B (en) * | 2020-04-20 | 2023-08-15 | 咪咕文化科技有限公司 | Page access data statistics method and device, electronic equipment and storage medium |
| CN116955415B (en) * | 2023-09-13 | 2024-01-23 | 成都融见软件科技有限公司 | Design hierarchy based data search system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104123346A (en) * | 2014-07-02 | 2014-10-29 | 广东电网公司信息中心 | Structural data searching method |
| CN105354151A (en) * | 2014-08-19 | 2016-02-24 | 阿里巴巴集团控股有限公司 | Cache management method and device |
| CN106844703A (en) * | 2017-02-04 | 2017-06-13 | 中国人民大学 | A kind of internal storage data warehouse query processing implementation method of data base-oriented all-in-one |
| CN107145489A (en) * | 2016-03-01 | 2017-09-08 | 阿里巴巴集团控股有限公司 | A kind of information statistical method and device of the client application based on cloud platform |
| CN107273413A (en) * | 2017-05-04 | 2017-10-20 | 北京小度信息科技有限公司 | Creation method, querying method and the relevant apparatus of middle table |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4616758B2 (en) * | 2005-11-30 | 2011-01-19 | 富士通株式会社 | Presence management method and presence management apparatus |
| US8589395B2 (en) * | 2008-04-15 | 2013-11-19 | Yahoo! Inc. | System and method for trail identification with search results |
| CN104424258B (en) * | 2013-08-28 | 2020-06-16 | 腾讯科技（深圳）有限公司 | Multidimensional data query method, query server, column storage server and system |
| CN103605848A (en) * | 2013-11-19 | 2014-02-26 | 北京国双科技有限公司 | Method and device for analyzing paths |
| CN108351768B (en) * | 2015-09-30 | 2021-04-20 | 伊恩杰里索芙特公司 | Method for implementing a user interface for processing data of an information system while writing a document in a markup language |
| CN108268550A (en) * | 2016-12-30 | 2018-07-10 | 北京国双科技有限公司 | The method for drafting and device of path collection of illustrative plates |
| CN107908677B (en) * | 2017-10-27 | 2019-10-22 | 贝壳找房(北京)科技有限公司 | Cell source of houses methods of exhibiting and device based on intelligent terminal |
| CN107766544B (en) * | 2017-10-31 | 2021-03-26 | 努比亚技术有限公司 | Information management method, terminal and computer readable storage medium |
-
2018
- 2018-08-28 CN CN201810991706.7A patent/CN109189810B/en not_active Expired - Fee Related
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104123346A (en) * | 2014-07-02 | 2014-10-29 | 广东电网公司信息中心 | Structural data searching method |
| CN105354151A (en) * | 2014-08-19 | 2016-02-24 | 阿里巴巴集团控股有限公司 | Cache management method and device |
| CN107145489A (en) * | 2016-03-01 | 2017-09-08 | 阿里巴巴集团控股有限公司 | A kind of information statistical method and device of the client application based on cloud platform |
| CN106844703A (en) * | 2017-02-04 | 2017-06-13 | 中国人民大学 | A kind of internal storage data warehouse query processing implementation method of data base-oriented all-in-one |
| CN107273413A (en) * | 2017-05-04 | 2017-10-20 | 北京小度信息科技有限公司 | Creation method, querying method and the relevant apparatus of middle table |
Non-Patent Citations (2)
| Title |
|---|
| 优化多维度查询效率;Aviva_ye;《https://cnblogs.com/avivaye/p/5250474.html》;20160307;第1-8页 * |
| 聚集索引树：一种解决区块聚集查询问题的方法;张冬冬等;《第十九届全国数据库学术会议》;20060529;第132-134页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109189810A (en) | 2019-01-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111046237B (en) | User behavior data processing method and device, electronic equipment and readable medium | |
| TWI752303B (en) | Method and device for establishing marketing information delivery platform | |
| CN108536867B (en) | Method and apparatus for generating information | |
| JP5986082B2 (en) | Reply to the estimated value of search keywords for all accounts | |
| RU2622850C2 (en) | Method and server for processing product identifiers and machine-readable storage medium | |
| CN104657437B (en) | Promote the monitoring method and device of situation data | |
| CN111598360A (en) | Service policy determination method and device and electronic equipment | |
| CN109189810B (en) | Query method, query device, electronic equipment and computer-readable storage medium | |
| CN111414410A (en) | Data processing method, device, equipment and storage medium | |
| CN109560940B (en) | Charging method and device for content delivery network CDN service | |
| CN113760521B (en) | Virtual resource allocation method and device | |
| CN110928594A (en) | Service development method and platform | |
| CN112287208B (en) | User portrait generation method, device, electronic equipment and storage medium | |
| US11023485B2 (en) | Cube construction for an OLAP system | |
| US12050630B2 (en) | Method, system, and apparatus for rapid geographic search in an actor-based geographic search network | |
| CN113434754A (en) | Method and device for determining recommended API (application program interface) service, electronic equipment and storage medium | |
| CN111143546A (en) | Method and device for obtaining recommendation language and electronic equipment | |
| CN112819555A (en) | Article recommendation method and device | |
| CN112491943A (en) | Data request method, device, storage medium and electronic equipment | |
| CN112131257B (en) | Data query method and device | |
| CN115237940A (en) | Data query method, device and equipment | |
| US20210035167A1 (en) | System and method for recommending digital advertisements and publishers | |
| CN111127077A (en) | Recommendation method and device based on stream computing | |
| CN117972096B (en) | Method and system for processing interaction message of social platform | |
| CN113360765B (en) | Event information processing method and device, electronic equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20210702 |