CN112000841B

CN112000841B - Electronic tag data processing method and device, electronic equipment and storage medium

Info

Publication number: CN112000841B
Application number: CN202010746558.XA
Authority: CN
Inventors: 邵帅
Original assignee: Beijing Dajia Internet Information Technology Co Ltd
Current assignee: Beijing Dajia Internet Information Technology Co Ltd
Priority date: 2020-07-29
Filing date: 2020-07-29
Publication date: 2023-09-26
Anticipated expiration: 2040-07-29
Also published as: CN112000841A

Abstract

The disclosure relates to a processing method, a processing device, electronic equipment and a storage medium of electronic tag data, wherein the processing method comprises the following steps: acquiring related data of interactive operation of the electronic tag of the video data; updating the first data table and the second data table in real time according to the quantity of the related data; reading correction data from the first data table according to the period; obtaining an aggregation result according to the correction data; and covering corresponding count data items in the second data table according to the aggregation result. The method and the device update the first data table and the second data table in real time according to the related data, and ensure the real-time property of the data in the first data table and the second data table. When the electronic tag data with a specific condition is required to be displayed, the corresponding data content can be directly read from the counting data items of the second data table, so that the electronic tag data is prevented from being obtained by online calculation, and the time consumption for obtaining the electronic tag data is shortened.

Description

Electronic tag data processing method and device, electronic equipment and storage medium

Technical Field

The disclosure relates to the technical field of computers, and in particular relates to a processing method and device of electronic tag data, electronic equipment and a storage medium.

Background

In the field of short video application, the number of interactive operations of the electronic tags of the short video works in a certain dimension or a certain dimension can reflect the attention degree of the electronic tags to a certain extent, and the electronic tags with high attention degree are beneficial to increasing the click rate of users on video data. For example, the electronic tags of the short video works have a higher praise number, representing users having a higher degree of attention and acceptance for the electronic tags of the short video works.

In the related art, the number of interactive operations of the electronic tag of the short video work is generally counted in the following ways. In the first mode, the number of interactive operations of the electronic tags of the short video works is counted for the whole time, and the counting mode can only reflect the historical attention of the electronic tags and is not beneficial to picking out the recent hot-spot electronic tags. In the second mode, the number of the interactive operations of the electronic tags of the short video works in one or more days is counted regularly, but the counting result is relatively lagged, which is not beneficial to tracking tag hotspots. And thirdly, counting the number of the interactive operations of the electronic tags of the short video works in real time, wherein the counting time is long under the condition that the number of the interactive operations of some hot spot electronic tags is too large.

In short, the existing method for counting the number of interactive operations of the electronic tag of the short video work cannot meet the requirements of real-time performance and short time consumption at the same time.

Disclosure of Invention

The disclosure provides a processing method, a device, electronic equipment and a storage medium for electronic tag data, which at least solve the problem that the method for counting the number of interactive operations of electronic tags of short video works in the related art cannot meet the requirements of real-time performance and short time consumption at the same time. The technical scheme of the present disclosure is as follows:

according to a first aspect of an embodiment of the present disclosure, there is provided a method for processing electronic tag data, including: acquiring related data of interactive operation of an electronic tag of video data, wherein the related data comprises operation time of the interactive operation, identification information of the electronic tag and identification information of the video data; according to the quantity of the related data, updating a preset first data table and a preset second data table in real time, wherein each data row of the first data table comprises a video data item, a label data item, a time data item and a counting data item, and each data row of the second data table comprises a video data item and/or a label data item and a counting data item; reading correction data from the first data table according to a preset period, wherein the correction data represents the data content of each data item in a data row of which the data content accords with a preset condition; adding the data contents of the count data items of the data lines with the same data contents of the video data items in the correction data, and/or adding the data contents of the count data items of the data lines with the same data contents of the tag data items to obtain an aggregation result; and covering corresponding count data items in the second data table according to the aggregation result.

Optionally, the overlaying the corresponding count data item in the second data table according to the aggregation result includes: the data row with the same data content of the video data items in the second data table and the data content of the video data items in the aggregation result and/or the data row with the same data content of the tag data items in the second data table and the data content of the tag data items in the aggregation result are used as the data row to be modified of the second data table; and storing the data content of the count data items in the aggregation result into the count data items of the data row to be corrected so as to cover the data content of the count data items of the data row to be corrected.

Optionally, the updating the preset first data table in real time according to the number of the related data includes: searching a first target data row in the first data table according to the related data and a preset time corresponding relation, wherein the time corresponding relation represents the corresponding relation between the operation time and a time data item of the first target data row; and updating the count data items of the first target data row in real time according to the acquired quantity of the related data, wherein the count data items of the first target data row represent the accumulated quantity of the interactive operation aiming at the video data and the electronic tag.

Optionally, the searching the first target data row in the first data table according to the correlation data and the preset time correspondence includes: mapping the operation time into time stamp information according to the time corresponding relation; and searching the first target data row in the first data table according to the timestamp information, the identification information of the electronic tag and the identification information of the video data.

Optionally, the searching the first target data row in the first data table according to the timestamp information, the identification information of the electronic tag and the identification information of the video data includes: and searching each data row of the first data table to obtain the first target data row with the same data content of the video data item, the same data content of the tag data item, the same identification information of the electronic tag and the same data content of the time data item as the time stamp information, wherein the data content of the video data item is the same as the identification information of the video data.

Optionally, the updating, in real time, the count data item of the first target data row according to the acquired quantity of the related data includes: and increasing the data content of the count data item of the first target data row according to the acquired quantity of the related data.

Optionally, the updating the preset second data table in real time according to the number of the related data includes: and after the counting data items of the first target data row are successfully updated in real time according to the acquired quantity of the related data, updating the second data table in real time according to the quantity of the related data.

Optionally, the updating the second data table in real time includes: searching a second target data row in the second data table according to the related data; and updating the count data items of the second target data row in real time according to the acquired quantity of the related data, wherein the count data items of the second target data row represent the accumulated quantity of the interaction operations aiming at the video data and/or the electronic tag.

Optionally, the searching the second data table for the second target data row according to the related data includes: and searching each data row of the second data table to obtain the second target data row with the same data content of the video data item as the identification information of the video data, and/or searching each data row of the second data table to obtain the second target data row with the same data content of the tag data item as the identification information of the electronic tag.

Optionally, said updating, in real time, the count data item of the second target data line according to the acquired number of the related data includes: and increasing the data content of the count data item of the second target data row according to the acquired quantity of the related data.

Optionally, the method further comprises: and generating and displaying prompt information after the failure of updating the count data items of the first target data row in real time according to the acquired quantity of the related data.

Optionally, the method further comprises: acquiring data display request information, wherein the data display request information comprises at least one of identification information of a target video, identification information of a target tag and target time information; and reading and returning the data content of the count data item from the corresponding data row in the first data table or the second data table according to the data display request information.

According to a second aspect of the embodiments of the present disclosure, there is provided a processing apparatus for electronic tag data, including: the electronic tag comprises an acquisition module and a processing module, wherein the acquisition module is configured to acquire related data of interactive operation of an electronic tag of video data, and the related data comprises operation time of the interactive operation, identification information of the electronic tag and identification information of the video data; the updating module is configured to update a preset first data table and a preset second data table in real time according to the quantity of the related data, wherein each data row of the first data table comprises a video data item, a tag data item, a time data item and a count data item, and each data row of the second data table comprises a video data item and/or a tag data item and a count data item; the reading module is configured to read correction data from the first data table according to a preset period, wherein the correction data represents the data content of each data item in a data row of which the data content of the time data item meets a preset condition; the aggregation module is configured to add the data contents of the count data items of the data lines with the same data contents of the video data items in the correction data and/or add the data contents of the count data items of the data lines with the same data contents of the tag data items to obtain an aggregation result; and the coverage module is configured to cover the corresponding count data items in the second data table according to the aggregation result.

Optionally, the covering module includes: a data row to be corrected determining module configured to use a data row, in which the data content of the video data item in the second data table is the same as the data content of the video data item in the aggregation result, and/or a data row, in which the data content of the tag data item in the second data table is the same as the data content of the tag data item in the aggregation result, as a data row to be corrected of the second data table; and the data content storing module is configured to store the data content of the count data items in the aggregation result into the count data items of the data row to be corrected so as to cover the data content of the count data items of the data row to be corrected.

Optionally, the updating module includes: the first target data row searching module is configured to search a first target data row in the first data table according to the related data and a preset time corresponding relation, wherein the time corresponding relation represents a corresponding relation between the operation time and time data items of the first target data row; and the first target data line updating module is configured to update counting data items of the first target data line in real time according to the acquired quantity of the related data, wherein the counting data items of the first target data line represent the accumulated quantity of the interactive operation aiming at the video data and the electronic tag.

Optionally, the first target data line searching module is configured to map the operation time into timestamp information according to the time corresponding relation; and searching the first target data row in the first data table according to the timestamp information, the identification information of the electronic tag and the identification information of the video data.

Optionally, the first target data row searching module is configured to search for the first target data row, in which the data content of the video data item is the same as the identification information of the video data, the data content of the tag data item is the same as the identification information of the electronic tag, and the data content of the time data item is the same as the time stamp information, in each data row of the first data table.

Optionally, the first target data line updating module is configured to increase the data content of the count data item of the first target data line according to the acquired quantity of the related data.

Optionally, the updating module is configured to update the second data table in real time according to the amount of the related data after the first target data line updating module succeeds in updating the count data item of the first target data line in real time according to the amount of the related data.

Optionally, the updating module further includes: the second target data row searching module is configured to search out a second target data row in the second data table according to the related data; and the second target data line updating module is configured to update counting data items of the second target data line in real time according to the acquired quantity of the related data, wherein the counting data items of the second target data line represent the accumulated quantity of the interactive operation aiming at the video data and/or the electronic tag.

Optionally, the second target data row searching module is configured to search for the second target data row with the same data content of the video data item as the identification information of the video data in each data row of the second data table, and/or search for the second target data row with the same data content of the tag data item as the identification information of the electronic tag in each data row of the second data table.

Optionally, the second target data line updating module is configured to increase the data content of the count data item of the second target data line according to the acquired number of related data.

Optionally, the apparatus further comprises: the prompt module is configured to generate and display prompt information after the first target data line updating module fails to update the count data items of the first target data line in real time according to the acquired quantity of the related data.

Optionally, the apparatus further comprises: a request information acquisition module configured to acquire data display request information including at least one of identification information of a target video, identification information of a target tag, and target time information; and the request data reading module is configured to read and return the data content of the count data item from the corresponding data row in the first data table or the second data table according to the data display request information.

According to a third aspect of embodiments of the present disclosure, there is provided an electronic device, comprising: a processor; a memory for storing the processor-executable instructions; wherein the processor is configured to execute the instructions to implement the method for processing electronic tag data according to the first aspect.

According to a fourth aspect of embodiments of the present disclosure, there is provided a storage medium, which when executed by a processor of an electronic device, causes the electronic device to perform the method of processing electronic tag data according to the first aspect.

According to a fifth aspect of embodiments of the present disclosure, there is provided a computer program product comprising readable program code executable by a processor of an electronic device to perform the method of processing electronic tag data according to the first aspect described above.

The technical scheme provided by the embodiment of the disclosure at least brings the following beneficial effects:

in an embodiment of the disclosure, related data for performing interactive operation on an electronic tag of video data is acquired, and a first data table and a second data table are updated in real time according to the number of the related data. And reading correction data from the first data table according to a preset period, adding the data contents of the count data items of the data lines with the same data contents of the video data items in the correction data, and/or adding the data contents of the count data items of the data lines with the same data contents of the tag data items to obtain an aggregation result, and further covering the corresponding count data items in the second data table according to the aggregation result.

On one hand, the embodiment of the disclosure can update the first data table and the second data table in real time according to the quantity of the related data, so that the real-time property of the data in the first data table and the second data table is ensured. On the other hand, the correction data are read from the first data table according to the preset period, an aggregation result is obtained based on the correction data, and the count data items in the second data table are covered according to the aggregation result so as to correct the second data table. When the electronic tag data of specific conditions (such as specific video data, specific electronic tags and the like) are required to be displayed, the corresponding data content can be directly read from the count data items of the second data table, so that the electronic tag data can be prevented from being obtained through online calculation, and the time consumption for obtaining the electronic tag data is shortened.

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

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the disclosure and together with the description, serve to explain the principles of the disclosure and do not constitute an undue limitation on the disclosure.

Fig. 1 is a flowchart illustrating a method of processing electronic tag data according to an exemplary embodiment.

FIG. 2a is a flowchart illustrating steps for updating a first data table in real time, according to an exemplary embodiment.

FIG. 2b is a flowchart illustrating steps for updating a second data table in real time, according to an exemplary embodiment.

FIG. 3 is a flow diagram illustrating updating a first data table and a second data table in real time according to an exemplary embodiment.

FIG. 4 is a flow diagram illustrating a corrective action performed on a second data table, according to an exemplary embodiment.

Fig. 5 is a block diagram illustrating a processing apparatus of electronic tag data according to an exemplary embodiment.

Fig. 6 is a block diagram of an electronic device for processing electronic tag data, according to an exemplary embodiment.

Fig. 7 is a block diagram of an electronic device for processing electronic label data, according to an example embodiment.

Detailed Description

In order to enable those skilled in the art to better understand the technical solutions of the present disclosure, the technical solutions of the embodiments of the present disclosure will be clearly and completely described below with reference to the accompanying drawings.

It should be noted that the terms "first," "second," and the like in the description and claims of the present disclosure and in the foregoing figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the disclosure described herein may be capable of operation in sequences other than those illustrated or described herein. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with some aspects of the present disclosure as detailed in the accompanying claims.

Fig. 1 is a flowchart illustrating a method of processing electronic tag data according to an exemplary embodiment, and as shown in fig. 1, the method of processing electronic tag data may be applied to a server, and the method of processing electronic tag data may include the following steps.

In step S11, related data for interactive operation with respect to the electronic tag of the video data is acquired.

In the embodiments of the present disclosure, the relevant data of the interactive operation may be understood as data generated by a user performing the interactive operation on an electronic tag of video data at a client, for example, in the short video application field, the user performs a praise operation on a certain electronic tag of a certain short video work, and generates the relevant data in response to the praise operation. The relevant data may include, but is not limited to: the operation time of the interactive operation, the identification information of the electronic tag, the identification information of the video data, and the like. In addition, the related data may further include identification information of the interaction, identification information of the user, and the like, and the content, format, and the like of the related data are not particularly limited in the embodiments of the present disclosure.

In step S12, the preset first data table and second data table are updated in real time according to the number of related data.

In the embodiment of the present disclosure, the interaction operation is taken as an example of the praise operation, and the interaction operation is other operations, such as the sharing operation, the reply operation, and the like, may refer to the execution process of the praise operation. For praise operations of electronic tags for short video works, multiple data tables may be created in advance, which may include one first data table and multiple second data tables. Wherein each data row of the first data table may contain a video data item, a tag data item, a time data item, and a count data item. Each data row of the second data table may contain video data items and/or tag data items, as well as count data items.

In practical application, the first data table can be updated in real time according to the related data, and then the plurality of second data tables can be updated in real time according to the related data.

In step S13, correction data is read from the first data table at a preset period.

In the embodiment of the present disclosure, the correction data within a certain time range may be read from the first data table according to a preset period. The correction data may be understood as the data content of each data item in the data row of the time data item in the first data table, which accords with the preset condition, for example, the correction data is the data content of the time data item in the first data table, which accords with the data content of the video data item in the data row within the last 24 hours, the data content of the tag data item, and the data content of the count data item. The preset condition may be set according to actual conditions, and the embodiment of the present disclosure does not specifically limit the content of the preset condition or the like.

In step S14, the data contents of the count data items of the data lines of the video data items of the correction data, the data contents of which are identical, are added, and/or the data contents of the count data items of the data lines of the tag data items, the data contents of which are identical, are added, to obtain an aggregation result.

In the embodiment of the present disclosure, for example, the data content N01 of the count data item of the data line H01 of the video data item and the data content N02 of the count data item of the data line H02 of the video data item of V01 in the correction data are added, and/or the data content N03 of the count data item of the data line H03 of the data item of the flag in the correction data and the data content N04 of the count data item of the data line H04 of the flag data item of L01 are added, resulting in an aggregation result. That is, the aggregate result is the sum of the data content of one or more count data items.

In step S15, the corresponding count data item in the second data table is overlaid according to the aggregation result.

In an embodiment of the present disclosure, the purpose of overlaying the aggregation result on the corresponding count data items in the second data table is that the data content of some or some count data items in the second data table may be inaccurate, and therefore, overlaying the aggregation result on the corresponding count data items in the second data table realizes correction of the data content of the inaccurate count data items in the second data table.

In an exemplary embodiment of the present disclosure, to ensure that data in the first data table is accurate, after each real-time update of the first data table, it needs to be determined whether the real-time update operation is successful, if the real-time update operation fails, an error prompt message is generated to remind that the real-time update operation fails, and the first data table may be updated again in real time until the real-time update operation is successful. If the real-time updating operation is successful, the next step, namely updating the second data table in real time, can be executed.

In an exemplary embodiment of the present disclosure, the performing of the step S12 may include the following two aspects:

and (I) updating the first data table in real time according to the quantity of the related data.

As shown in fig. 2a, when updating the first data table in real time, the following steps may be performed:

in step S201, a first target data row is searched in a first data table according to the correlation data and a preset time correspondence.

The preset time correspondence represents a correspondence between an operation time of the interactive operation and a time data item of the first target data line. In practical application, the operation time of the interactive operation in the related data can be mapped into the time stamp information according to the time corresponding relation. For example, the operation time is 16:33, the operation time may be mapped to timestamp information 16:00, for example, the operating time is 15:01, the operation time can be mapped to time stamp information 15:00. the time stamp information may be understood as the data content of the time data item in the first data table. Then, a first target data row is searched in a first data table according to the timestamp information, the identification information of the electronic tag and the identification information of the video data. When the first target data row is searched, the first target data row with the same data content of the video data item as the identification information of the video data, the same data content of the tag data item as the identification information of the electronic tag and the same data content of the time data item as the time stamp information can be searched in each data row of the first data table.

It should be noted that, in the process of searching the first target data row, if the first target data row is not searched in the first data table, the first target data row may be created in the first data table according to the identification information of the video data in the related data, the identification information of the electronic tag, and the mapped timestamp.

In step S202, the count data item of the first target data line is updated in real time in accordance with the acquired number of related data.

After the first target data line is searched, the data content of the count data item of the first target data line can be increased according to the acquired quantity of the related data. The count data item of the first target data line represents a cumulative number of interactive operations for the video data and the electronic tag. For example, the number of acquired related data is m, the data content of the count data item of the first target data line is n, and the count data item of the first target data line is updated in real time, namely, the sum of m and n is added as the updated data content of the count data item of the first target data line.

And (II) updating the second data table in real time according to the quantity of the related data.

One of the preconditions for updating the second data table in real time is that the count data items of the first target data row are successfully updated in real time. That is, after the count data items of the first target data line are successfully updated in real time in accordance with the acquired number of related data, the second data table is updated in real time in accordance with the number of related data.

As shown in fig. 2b, when updating the second data table in real time, it may be performed as follows:

in step S211, a second target data row is searched in the second data table according to the related data.

Since the data rows of the second data table may contain video data items, tag data items, video data items and tag data items. Therefore, when searching the second target data row, the second target data row with the same data content of the video data item as the identification information of the video data can be searched in each data row of the second data table, and/or the second target data row with the same data content of the tag data item as the identification information of the electronic tag can be searched in each data row of the second data table.

In step S212, the count data items of the second target data line are updated in real time in accordance with the acquired number of related data.

The execution of the real-time updating of the count data items of the second target data row is similar to the execution of the real-time updating of the count data items of the first target data row. The data content of the count data item of the second target data line may be increased in accordance with the acquired number of related data. The count data item of the second target data line represents a cumulative number of interactions for the video data and/or the electronic label. For example, the number of acquired related data is m, the data content of the count data item of the second target data row is p, and the sum of m and p is taken as the updated data content of the count data item of the second target data row after the count data item of the second target data row is updated in real time.

In practical applications, there may be multiple second data tables, for example, there are three second data tables, and the three second data tables are respectively table 2, table 3 and table 4, which are all full-scale time data tables. Each data row in table 2 may include three columns of data items, which are a video data item, a tag data item, and a count data item, respectively. Each data row in table 3 may contain two columns of data items, a tag data item and a count data item, respectively. Each data row in table 4 may contain two columns of data items, a video data item and a count data item, respectively. In updating the three second data tables in real time, it is possible to search the second target data rows in tables 2, 3 and 4 for the count data items, respectively, and to increase the data contents of the count data items of the second target data rows in tables 2, 3 and 4.

As shown in fig. 3, fig. 3 shows a flow diagram of updating the first data table and the second data table in real time. Still taking the example that the user performs the praise operation on a certain electronic tag of a certain short video work as an example, the user generates relevant data after performing the praise operation. The server can acquire the related data, update the first data table in real time according to the quantity of the related data, then judge whether the real-time update operation is successful, and if the real-time update of the first data table is successful, continuously update the second data table in real time according to the quantity of the related data to generate and display prompt information of the success of the real-time update of the second data table. If the first data table is failed to be updated in real time, generating and displaying prompt information of the failure to update the first data table in real time, and re-refining the first data table in real time until the real-time update is successful.

It should be noted that, updating the second target data line in the second data table in real time does not need to determine whether it is successful, because the subsequent step may perform the correction operation on the second data table. As shown in fig. 4, fig. 4 shows a schematic flow chart of the correction operation on the second data table. Since the data content of the count data items in the first data table is accurate (the real-time update is successful), the data content of the count data items in the second data table may be erroneous (whether the real-time update is successful is not judged), in order to correct the second data table, a timing task may be established, which may perform the following steps every one minute, for example: 1) Reading correction data from the first data table, wherein the correction data can be the data contents of the video data item, the tag data item and the count data item, the data contents of the time data item being within the last 72 hours; 2) And obtaining an aggregation result of the count data items according to the correction data, and covering the aggregation result with the corresponding count data items in the second data table.

When the corresponding count data items in the second data table are covered according to the aggregation result, the data line to be corrected can be screened out from the second data table, and then the data content of the count data items in the aggregation result is stored into the count data items of the data line to be corrected in the second data table, so as to cover the data content of the count data items of the data line to be corrected. In practical application, the execution process of screening the data row to be corrected may be to use the data row with the same data content of the video data item in the second data table as the data row with the same data content of the video data item in the aggregation result, and/or the data row with the same data content of the tag data item in the second data table as the data row to be corrected of the second data table.

It should be noted that after the second data table is updated in real time, whether the real-time update is successful may also be determined, and if the real-time update fails, the rollback operation may be performed on the data updated in real time, without executing the correction operation.

In one exemplary embodiment of the present disclosure, data presentation request information may be acquired, which may include at least one of identification information of a target video, identification information of a target tag, and target time information. And reading and returning the data content of the count data item from the corresponding data row in the first data table or the second data table according to the data display request information.

In the embodiment of the disclosure, related data for performing interactive operation on the electronic tag of the video data is obtained, and the first data table and the second data table are updated in real time according to the number of the related data. And reading correction data from the first data table according to a preset period, adding the data contents of the count data items of the data lines with the same data contents of the video data items in the correction data, and/or adding the data contents of the count data items of the data lines with the same data contents of the tag data items to obtain an aggregation result, and further covering the corresponding count data items in the second data table according to the aggregation result.

When the number of the interactive operations of the electronic tags for displaying the short video works is displayed, the period for reading the correction data from the first data table can be flexibly adjusted, and the shorter the period is, the higher the data accuracy in the second data table is; the longer the period, the fewer the number of corrections to the second data table.

According to the embodiment of the disclosure, the first data table is redundant, the second data table is corrected according to the correction data in the first data table, and the consistency of the data content of the counting data items of the first data table and the data content of the counting data items of the second data table under different dimensionalities (video data items, label data items and time data items) can be ensured. In addition, when the second data table is updated in real time, whether the second data table is successful or not is not required to be judged, the rollback operation is avoided, the steps of judging and rollback are reduced on the premise that the data consistency is ensured, the development difficulty is reduced, the processing flow is simplified, and meanwhile, the system performance is improved.

According to the embodiment of the disclosure, when the corresponding data content is displayed according to the data display request information, the correction data can be read from the first data table, and the aggregation result of the correction data is covered on the corresponding count data item in the second data table, so that the corresponding data content is read from the second data table, the workload of online calculation of the data content is reduced, and the user experience of data display is improved.

According to the embodiment of the disclosure, whether the first data table is successfully updated in real time is judged, so that the accuracy of the data content in the first data table is ensured, a precise data base is provided for data display, and the accuracy of the data display is improved.

In the embodiment of the disclosure, the time granularity of the data content of the time data item of the first data table can be adjusted according to practical situations, for example, the time granularity is adjusted to be 10 minutes, so as to improve the compatibility of different display requirements.

Fig. 5 is a block diagram illustrating a processing apparatus of electronic tag data according to an exemplary embodiment. The device may comprise the following modules.

An acquisition module 51 configured to acquire related data of an interactive operation with respect to an electronic tag of video data, the related data including an operation time of the interactive operation, identification information of the electronic tag, and identification information of the video data;

An updating module 52 configured to update, in real time, a preset first data table and a second data table according to the amount of the related data, wherein each data row of the first data table contains a video data item, a tag data item, a time data item and a count data item, and each data row of the second data table contains a video data item and/or a tag data item and a count data item;

a reading module 53 configured to read correction data from the first data table according to a preset period, where the correction data represents data contents of each data item in a data row whose data contents of the time data item meet a preset condition;

an aggregation module 54, configured to add the data contents of the count data items of the data lines with the same data contents of the video data items in the correction data, and/or add the data contents of the count data items of the data lines with the same data contents of the tag data items, so as to obtain an aggregation result;

and an overlay module 55 configured to overlay the corresponding count data items in the second data table according to the aggregation result.

In one exemplary embodiment of the present disclosure, the overlay module 55 includes:

A data row to be corrected determining module configured to use a data row, in which the data content of the video data item in the second data table is the same as the data content of the video data item in the aggregation result, and/or a data row, in which the data content of the tag data item in the second data table is the same as the data content of the tag data item in the aggregation result, as a data row to be corrected of the second data table;

and the data content storing module is configured to store the data content of the count data items in the aggregation result into the count data items of the data row to be corrected so as to cover the data content of the count data items of the data row to be corrected.

In one exemplary embodiment of the present disclosure, the update module 52 includes:

the first target data row searching module is configured to search a first target data row in the first data table according to the related data and a preset time corresponding relation, wherein the time corresponding relation represents a corresponding relation between the operation time and time data items of the first target data row;

and the first target data line updating module is configured to update counting data items of the first target data line in real time according to the acquired quantity of the related data, wherein the counting data items of the first target data line represent the accumulated quantity of the interactive operation aiming at the video data and the electronic tag.

In an exemplary embodiment of the present disclosure, the first target data line search module is configured to map the operation time to timestamp information according to the time correspondence; and searching the first target data row in the first data table according to the timestamp information, the identification information of the electronic tag and the identification information of the video data.

In an exemplary embodiment of the disclosure, the first target data row searching module is configured to search for the first target data row, in which the data content of the video data item is the same as the identification information of the video data, the data content of the tag data item is the same as the identification information of the electronic tag, and the data content of the time data item is the same as the time stamp information, in each data row of the first data table.

In an exemplary embodiment of the present disclosure, the first target data line updating module is configured to increase the data content of the count data item of the first target data line according to the acquired number of the related data.

In an exemplary embodiment of the present disclosure, the updating module 52 is configured to update the second data table in real time according to the amount of the relevant data after the first target data line updating module succeeds in updating the count data item of the first target data line in real time according to the acquired amount of the relevant data.

In an exemplary embodiment of the present disclosure, the update module 52 further includes:

the second target data row searching module is configured to search out a second target data row in the second data table according to the related data;

and the second target data line updating module is configured to update counting data items of the second target data line in real time according to the acquired quantity of the related data, wherein the counting data items of the second target data line represent the accumulated quantity of the interactive operation aiming at the video data and/or the electronic tag.

In an exemplary embodiment of the present disclosure, the second target data row searching module is configured to search for the second target data row with the same data content of the video data item as the identification information of the video data in each data row of the second data table, and/or search for the second target data row with the same data content of the tag data item as the identification information of the electronic tag in each data row of the second data table.

In an exemplary embodiment of the present disclosure, the second target data line updating module is configured to increase the data content of the count data item of the second target data line according to the acquired number of the related data.

In an exemplary embodiment of the present disclosure, the apparatus further comprises:

the prompt module is configured to generate and display prompt information after the first target data line updating module fails to update the count data items of the first target data line in real time according to the acquired quantity of the related data.

a request information acquisition module configured to acquire data display request information including at least one of identification information of a target video, identification information of a target tag, and target time information;

and the request data reading module is configured to read and return the data content of the count data item from the corresponding data row in the first data table or the second data table according to the data display request information.

The specific manner in which the various modules perform the operations in the apparatus of the above embodiments have been described in detail in connection with the embodiments of the method, and will not be described in detail herein.

Fig. 6 is a block diagram illustrating an electronic device 600 for processing electronic label data according to an exemplary embodiment. For example, the electronic device 600 may be a mobile phone, a computer, a digital broadcast terminal, a messaging device, a game console, a tablet device, a medical device, an exercise device, a personal digital assistant, and the like.

Referring to fig. 6, an electronic device 600 may include one or more of the following components: a processing component 602, a memory 604, a power component 606, a multimedia component 608, an audio component 610, an input/output (I/O) interface 612, a sensor component 614, and a communication component 616.

The processing component 602 generally controls overall operation of the electronic device 600, such as operations associated with display, telephone calls, data communications, camera operations, and recording operations. The processing component 602 may include one or more processors 620 to execute instructions to perform all or part of the steps of the method of processing electronic tag data described above. Further, the processing component 602 can include one or more modules that facilitate interaction between the processing component 602 and other components. For example, the processing component 602 may include a multimedia module to facilitate interaction between the multimedia component 608 and the processing component 602.

The memory 604 is configured to store various types of data to support operations at the electronic device 600. Examples of such data include instructions for any application or method operating on the electronic device 600, contact data, phonebook data, messages, images, videos, and so forth. The memory 604 may be implemented by any type or combination of volatile or nonvolatile memory devices such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disk.

The power supply component 606 provides power to the various components of the electronic device 600. The power supply components 606 can include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power for the electronic device 600.

The multimedia component 608 includes a screen between the electronic device 600 and the user that provides an output interface. In some embodiments, the screen may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive input signals from a user. The touch panel includes one or more touch sensors to sense touches, swipes, and gestures on the touch panel. The touch sensor may sense not only the boundary of a touch or slide action, but also the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 608 includes a front camera and/or a rear camera. When the electronic device 600 is in an operational mode, such as a shooting mode or a video mode, the front camera and/or the rear camera may receive external multimedia data. Each front camera and rear camera may be a fixed optical lens system or have focal length and optical zoom capabilities.

The audio component 610 is configured to output and/or input audio signals. For example, the audio component 610 includes a Microphone (MIC) configured to receive external audio signals when the electronic device 600 is in an operational mode, such as a call mode, a recording mode, and a voice recognition mode. The received audio signals may be further stored in the memory 604 or transmitted via the communication component 616. In some embodiments, audio component 610 further includes a speaker for outputting audio signals.

The I/O interface 612 provides an interface between the processing component 602 and peripheral interface modules, which may be a keyboard, click wheel, buttons, etc. These buttons may include, but are not limited to: homepage button, volume button, start button, and lock button.

The sensor assembly 614 includes one or more sensors for providing status assessment of various aspects of the electronic device 600. For example, the sensor assembly 614 may detect an on/off state of the electronic device 600, a relative positioning of the components, such as a display and keypad of the electronic device 600, the sensor assembly 614 may also detect a change in position of the electronic device 600 or a component of the electronic device 600, the presence or absence of a user's contact with the electronic device 600, an orientation or acceleration/deceleration of the electronic device 600, and a change in temperature of the electronic device 600. The sensor assembly 614 may include a proximity sensor configured to detect the presence of nearby objects in the absence of any physical contact. The sensor assembly 614 may also include a light sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 614 may also include an acceleration sensor, a gyroscopic sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.

The communication component 616 is configured to facilitate communication between the electronic device 600 and other devices, either wired or wireless. The electronic device 600 may access a wireless network based on a communication standard, such as WiFi, an operator network (e.g., 2G, 3G, 4G, or 5G), or a combination thereof. In one exemplary embodiment, the communication component 616 receives broadcast signals or broadcast-related information from an external broadcast management system via a broadcast channel. In one exemplary embodiment, the communication component 616 further includes a Near Field Communication (NFC) module to facilitate short range communications. For example, the NFC module may be implemented based on Radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, ultra Wideband (UWB) technology, bluetooth (BT) technology, and other technologies.

In an exemplary embodiment, the electronic device 600 may be implemented by one or more Application Specific Integrated Circuits (ASICs), digital Signal Processors (DSPs), digital Signal Processing Devices (DSPDs), programmable Logic Devices (PLDs), field Programmable Gate Arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic elements for performing the above-described methods of processing electronic tag data.

In an exemplary embodiment, a storage medium is also provided, such as a memory 604 including instructions executable by the processor 620 of the electronic device 600 to perform the above-described method of processing electronic tag data. Alternatively, the storage medium may be a non-transitory computer readable storage medium, which may be, for example, ROM, random Access Memory (RAM), CD-ROM, magnetic tape, floppy disk, optical data storage device, and the like.

In an exemplary embodiment, a computer program product is also provided, which comprises readable program code executable by the processor 620 of the electronic device 600 to perform the above-described method of processing electronic label data. Alternatively, the program code may be stored in a storage medium of the electronic device 600, which may be a non-transitory computer readable storage medium, such as ROM, random Access Memory (RAM), CD-ROM, magnetic tape, floppy disk, optical data storage device, etc.

Fig. 7 is a block diagram illustrating an electronic device 700 for processing electronic label data, according to an example embodiment. For example, the electronic device 700 may be provided as a server. Referring to fig. 7, electronic device 700 includes a processing component 722 that further includes one or more processors and memory resources represented by memory 732 for storing instructions, such as application programs, executable by processing component 722. The application programs stored in memory 732 may include one or more modules that each correspond to a set of instructions. Further, the processing component 722 is configured to execute instructions to perform the processing method of electronic tag data described above.

The electronic device 700 may also include a power supply component 726 configured to perform power management of the electronic device 700, a wired or wireless network interface 750 configured to connect the electronic device 700 to a network, and an input output (I/O) interface 758. The electronic device 700 may operate based on an operating system stored in memory 732, such as Windows Server, mac OS XTM, unixTM, linuxTM, freeBSDTM, or the like.

Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any adaptations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.

It is to be understood that the present disclosure is not limited to the precise arrangements and instrumentalities shown in the drawings, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. The processing method of the electronic tag data is characterized by comprising the following steps:

acquiring related data of interactive operation of an electronic tag of video data, wherein the related data comprises operation time of the interactive operation, identification information of the electronic tag and identification information of the video data;

according to the quantity of the related data, updating a preset first data table and a preset second data table in real time, wherein each data row of the first data table comprises a video data item, a label data item, a time data item and a counting data item, and each data row of the second data table comprises a video data item and/or a label data item and a counting data item;

reading correction data from the first data table according to a preset period, wherein the correction data represents the data content of each data item in a data row of which the data content accords with a preset condition;

adding the data contents of the count data items of the data lines with the same data contents of the video data items in the correction data, and/or adding the data contents of the count data items of the data lines with the same data contents of the tag data items to obtain an aggregation result;

And covering corresponding count data items in the second data table according to the aggregation result.

2. The method of claim 1, wherein said overwriting a corresponding count data item in said second data table according to said aggregation result comprises:

the data row with the same data content of the video data items in the second data table and the data content of the video data items in the aggregation result and/or the data row with the same data content of the tag data items in the second data table and the data content of the tag data items in the aggregation result are used as the data row to be modified of the second data table;

and storing the data content of the count data items in the aggregation result into the count data items of the data row to be corrected so as to cover the data content of the count data items of the data row to be corrected.

3. The method of claim 1, wherein updating the preset first data table in real time according to the amount of the related data comprises:

searching a first target data row in the first data table according to the related data and a preset time corresponding relation, wherein the time corresponding relation represents the corresponding relation between the operation time and a time data item of the first target data row;

And updating the count data items of the first target data row in real time according to the acquired quantity of the related data, wherein the count data items of the first target data row represent the accumulated quantity of the interactive operation aiming at the video data and the electronic tag.

4. The method of claim 3, wherein the searching the first data table for the first target data row according to the correlation data and the preset time correspondence relationship includes:

mapping the operation time into time stamp information according to the time corresponding relation;

and searching the first target data row in the first data table according to the timestamp information, the identification information of the electronic tag and the identification information of the video data.

5. The method of claim 4, wherein the searching the first data table for the first target data row based on the timestamp information, the identification information of the electronic tag, and the identification information of the video data, comprises:

and searching each data row of the first data table to obtain the first target data row with the same data content of the video data item, the same data content of the tag data item, the same identification information of the electronic tag and the same data content of the time data item as the time stamp information, wherein the data content of the video data item is the same as the identification information of the video data.

6. A method according to claim 3, wherein said updating in real time the count data items of the first target data line according to the acquired amount of the related data comprises:

and increasing the data content of the count data item of the first target data row according to the acquired quantity of the related data.

7. A method according to claim 3, wherein updating the predetermined second data table in real time according to the amount of the related data comprises:

and after the counting data items of the first target data row are successfully updated in real time according to the acquired quantity of the related data, updating the second data table in real time according to the quantity of the related data.

8. The method of claim 7, wherein the updating the second data table in real time comprises:

searching a second target data row in the second data table according to the related data;

and updating the count data items of the second target data row in real time according to the acquired quantity of the related data, wherein the count data items of the second target data row represent the accumulated quantity of the interaction operations aiming at the video data and/or the electronic tag.

9. The method of claim 8, wherein the searching the second data table for the second target data row based on the related data comprises:

and searching each data row of the second data table to obtain the second target data row with the same data content of the video data item as the identification information of the video data, and/or searching each data row of the second data table to obtain the second target data row with the same data content of the tag data item as the identification information of the electronic tag.

10. The method of claim 8, wherein updating the count data item of the second target data row in real time according to the acquired amount of the related data comprises:

and increasing the data content of the count data item of the second target data row according to the acquired quantity of the related data.

11. A method according to claim 3, characterized in that the method further comprises:

and generating and displaying prompt information after the failure of updating the count data items of the first target data row in real time according to the acquired quantity of the related data.

12. The method according to any one of claims 1 to 11, further comprising:

acquiring data display request information, wherein the data display request information comprises at least one of identification information of a target video, identification information of a target tag and target time information;

and reading and returning the data content of the count data item from the corresponding data row in the first data table or the second data table according to the data display request information.

13. An electronic tag data processing apparatus, comprising:

the electronic tag comprises an acquisition module and a processing module, wherein the acquisition module is configured to acquire related data of interactive operation of an electronic tag of video data, and the related data comprises operation time of the interactive operation, identification information of the electronic tag and identification information of the video data;

the updating module is configured to update a preset first data table and a preset second data table in real time according to the quantity of the related data, wherein each data row of the first data table comprises a video data item, a tag data item, a time data item and a count data item, and each data row of the second data table comprises a video data item and/or a tag data item and a count data item;

The reading module is configured to read correction data from the first data table according to a preset period, wherein the correction data represents the data content of each data item in a data row of which the data content of the time data item meets a preset condition;

the aggregation module is configured to add the data contents of the count data items of the data lines with the same data contents of the video data items in the correction data and/or add the data contents of the count data items of the data lines with the same data contents of the tag data items to obtain an aggregation result;

and the coverage module is configured to cover the corresponding count data items in the second data table according to the aggregation result.

14. The apparatus of claim 13, wherein the overlay module comprises:

15. The apparatus of claim 13, wherein the update module comprises:

16. The apparatus of claim 15, wherein the first target data line search module is configured to map the operation time to timestamp information according to the time correspondence; and searching the first target data row in the first data table according to the timestamp information, the identification information of the electronic tag and the identification information of the video data.

17. The apparatus according to claim 16, wherein the first target data row search module is configured to search for the first target data row in which the data content of the video data item is the same as the identification information of the video data, the data content of the tag data item is the same as the identification information of the electronic tag, and the data content of the time data item is the same as the time stamp information in each data row of the first data table.

18. The apparatus of claim 15, wherein the first target data line update module is configured to increment the data content of the count data item of the first target data line by the amount of the related data acquired.

19. The apparatus of claim 15, wherein the updating module is configured to update the second data table in real time according to the amount of the relevant data after the first target data line updating module succeeds in updating the count data item of the first target data line in real time according to the acquired amount of the relevant data.

20. The apparatus of claim 19, wherein the update module further comprises:

21. The apparatus according to claim 20, wherein the second target data row searching module is configured to search for the second target data row with the same data content of the video data item as the identification information of the video data in each data row of the second data table, and/or search for the second target data row with the same data content of the tag data item as the identification information of the electronic tag in each data row of the second data table.

22. The apparatus of claim 20, wherein the second target data line update module is configured to increment the data content of the count data item of the second target data line by the amount of the related data acquired.

23. The apparatus of claim 15, wherein the apparatus further comprises:

24. The apparatus according to any one of claims 13 to 23, further comprising:

25. An electronic device, comprising:

a processor;

a memory for storing the processor-executable instructions;

wherein the processor is configured to execute the instructions to implement the method of processing electronic label data according to any one of claims 1 to 12.

26. A storage medium, characterized in that instructions in the storage medium, when executed by a processor of an electronic device, enable the electronic device to perform the method of processing electronic label data according to any one of claims 1 to 12.