An advertisement monitoring data storage method, device and storage medium

Abstract

The application discloses an advertisement monitoring data storage method and device and a storage medium. The application is provided with a monitoring round parameter, which is used to determine the compression period of the advertisement monitoring data recorded by the advertisement playing device. Meanwhile, the compression period is an integer multiple of the advertisement playing period of the advertisement playing device. Therefore, the compression period is equivalent to determining that several advertisement playing periods of data form a compression data. In this way, in the implementation, the application divides the advertisement monitoring data into data corresponding to multiple compression periods based on the compression period, then compresses each data, and finally uploads the compression data to the monitoring center for storage. Through the above design, the application compresses the data monitored in several playing periods into one data for uploading. Therefore, the amount of data uploaded can be reduced, so that the purpose of reducing the network bandwidth and the cost of the background storage space resources is achieved.

Description

Technical Field

[0001] This invention belongs to the field of advertising monitoring data storage technology, specifically relating to a method, device and storage medium for storing advertising monitoring data. Background Technology

[0002] With the rise of 4G, 5G and IoT technologies, a new generation of multimedia advertising media is gradually entering people's daily lives. Elevators, with their unique usage scenarios, have gained a huge number of users and high passenger flow. At the same time, due to their enclosed interior space, advertising inside them causes far less interference than outdoor advertising. Therefore, community media advertising, represented by elevator TVs, elevator posters, and elevator picture frames, has rapidly emerged and become a major form of advertising.

[0003] Currently, the multimedia equipment in the elevator monitors advertising data and reports each piece of monitoring data to the backend server after each round of advertising. The backend server then stores each piece of monitoring data received, thus completing the recording of the device's advertising playback data. (See [link to relevant documentation]). Figure 3 As shown, assuming a device plays one round of advertisements and detects 10 ad data entries, the device will upload these 10 ad data entries, and the backend server will store them. However, when there are many devices and many ad schemes on each device, the amount of reported monitoring data will be very large. This will cause excessive pressure on the backend storage, and may even fail to meet the incremental business needs of the enterprise. Moreover, the large amount of data places high demands on the software, hardware, and network bandwidth resources of the entire advertising system, thereby increasing storage costs. Therefore, how to provide a method for storing advertising monitoring data that can reduce backend storage space resources and storage costs has become an urgent problem to be solved. Summary of the Invention

[0004] The purpose of this invention is to provide a method, apparatus, and storage medium for storing advertising monitoring data, in order to solve the problem in the prior art that the amount of monitoring data is too large, which requires a large amount of backend storage space resources and high network bandwidth, thus increasing storage costs.

[0005] To achieve the above objectives, the present invention adopts the following technical solution:

[0006] Firstly, a method for storing advertising monitoring data is provided, including:

[0007] The advertising playback device acquires advertising monitoring data and monitoring round parameters, wherein the monitoring round parameters are used to characterize the data compression period of the advertising monitoring data, the data compression period is an integer multiple of the advertising playback period of the advertising playback device, and the advertising playback device is used to play the already deployed advertising scheme within the advertising playback period.

[0008] The advertising playback device divides the advertising monitoring data based on the monitoring cycle parameters to obtain several advertising segmentation data.

[0009] The advertising playback device compresses each advertising segment data to obtain the advertising compressed data corresponding to each advertising segment data. Each advertising compressed data includes the total start time of advertising playback, the total end time of advertising playback, the scheme ID of each advertising scheme in the advertising compressed data, and the playback frequency of each advertising scheme.

[0010] The advertising playback device uploads the compressed advertising data corresponding to each advertising segment to the monitoring center;

[0011] The monitoring center receives compressed data of various advertisements sent by the advertising playback devices;

[0012] The monitoring center decompresses the compressed data of each advertisement to obtain several decompressed advertisement data.

[0013] The monitoring center stores a number of decompressed advertising data to complete the storage of the advertising monitoring data after storage.

[0014] Based on the above disclosure, this invention is configured with a monitoring cycle parameter. This monitoring cycle parameter is used to determine the compression period of the advertising monitoring data recorded by the advertising playback device. Furthermore, this compression period is an integer multiple of the advertising playback period of the advertising playback device. Therefore, the compression period essentially determines how many advertising playback periods' worth of data will be used to compose a single compressed data set. In implementation, this invention divides the advertising monitoring data into data corresponding to multiple compression periods based on the compression period, then compresses each data set, and finally uploads the compressed data to the monitoring center for storage. Through this design, this invention compresses the data monitored within several playback periods into a single data set for uploading, thereby reducing the amount of data uploaded and thus lowering network bandwidth and backend storage space resource costs.

[0015] In one possible design, the advertising monitoring data includes several advertising playback cycle data, wherein any one of the advertising playback cycle data includes the device ID of the advertising playback device and at least one advertising scheme playback data, and each of the at least one advertising scheme playback data includes a scheme ID, an advertising playback start time, and an advertising playback end time.

[0016] Specifically, based on the monitoring round parameters, the advertising monitoring data is divided into several advertising segmentation data, including:

[0017] The advertising playback device divides the advertising monitoring data into several segments based on the monitoring cycle parameter, resulting in a number of advertising segment data. Each segment data includes n advertising playback cycle data, where n is the monitoring cycle parameter.

[0018] Accordingly, the data for each ad segment is compressed, including:

[0019] For any ad segmentation data, the ad playback device counts the total number of scheme IDs for each ad scheme within each ad playback period corresponding to the ad segmentation data, in order to obtain the playback frequency of each ad scheme in the ad segmentation data.

[0020] The advertising playback device determines the total start time and total end time of advertising playback for any given advertising segment based on the start time and end time of advertising playback for each advertising scheme within each advertising playback cycle data corresponding to any given advertising segment.

[0021] The advertising playback device obtains the device ID from any advertising playback period data within any advertising segmentation data, and uses the device ID, the total start time of advertising playback, the total end time of advertising playback, and the playback frequency of each advertising scheme to compose the advertising information of any advertising segmentation data;

[0022] The advertising playback device compresses the advertising information of any of the advertising segment data to obtain the compressed advertising data corresponding to any of the advertising segment data after compression.

[0023] Based on the above disclosure, this invention discloses a specific process for data partitioning. Since it has been stated that the compression period is an integer multiple of the advertising playback period, this is equivalent to partitioning the advertising monitoring data using the compression period as the partition length, resulting in several advertising partition data sets. Simultaneously, during compression processing, for any given advertising partition data set, firstly, the total number of scheme IDs for each advertising scheme is counted, and this total number of scheme IDs is used as the playback frequency of each advertising scheme. Then, based on the playback start and end times of each advertising scheme, the earliest playback start time is determined as the total start time of advertising playback for that advertising partition data set, and the latest playback end time is determined as the total end time of advertising playback for that advertising partition data set. Next, the device ID in that advertising partition data set is extracted, and the extracted data is used as the advertising information for that advertising partition data set. Finally, the advertising information is compressed to obtain compressed advertising data.

[0024] In one possible design, the advertising information of any of the advertising segment data is compressed to obtain compressed advertising data corresponding to any of the advertising segment data, including:

[0025] For any of the advertising segment data, the advertising playback device adds a compression start character and a compression end character to the advertising information of any of the advertising segment data to obtain preprocessed advertising information;

[0026] The advertising playback device compresses the preprocessed advertising information to obtain compressed advertising data corresponding to any of the advertising segmentation data.

[0027] In one possible design, if the advertising playback device is an offline device, the method further includes:

[0028] When the advertising playback device establishes a communication connection with the advertising broadcast control auxiliary device based on the local area network, it transmits the compressed advertising data corresponding to each advertising segment to the advertising broadcast control auxiliary device, so that the advertising broadcast control auxiliary device can upload each compressed advertising data to the monitoring center after receiving each compressed advertising data.

[0029] Based on the above-disclosed information, when the advertising playback device is offline, it can be connected via a local area network using an advertising playback control auxiliary device. This allows the compressed data of each advertisement on the advertising playback device to be uploaded to the monitoring center, thus ensuring the integrity of data storage and preventing data loss.

[0030] In one possible design, after obtaining the compressed ad data corresponding to each ad segment, the method further includes:

[0031] The advertising playback device determines whether the total number of compressed advertising data exceeds the maximum number of uploads.

[0032] If so, the advertising playback device will upload the compressed advertising data corresponding to each advertising segment to the monitoring center.

[0033] In one possible design, several decompressed advertising data items are stored, including:

[0034] The monitoring center determines the playback date for each decompressed ad data based on the total start and end times of ad playback in each decompressed ad data.

[0035] The monitoring center partitions several decompression advertisement data according to the playback date, so that decompression advertisement data belonging to the same playback date is stored in one partition.

[0036] Based on the above-disclosed content, the present invention uses the advertising playback time in the data reported by the device to partition the data, which can not only improve the query performance, availability and maintainability of the monitoring center, but also balance the I / O load of the monitoring center storage, thereby further improving storage performance.

[0037] Secondly, a storage device for advertising monitoring data is provided, taking an advertising playback device as an example, including:

[0038] The data acquisition unit is used to acquire advertising monitoring data and monitoring round parameters, wherein the monitoring round parameters are used to characterize the data compression period of the advertising monitoring data, the data compression period is an integer multiple of the advertising playback period of the advertising playback device, and the advertising playback device plays the already deployed advertising scheme within the advertising playback period.

[0039] A data partitioning unit is used to partition the advertising monitoring data based on the monitoring round parameters to obtain several advertising partition data.

[0040] The data compression unit is used to compress each ad segment data to obtain the ad compressed data corresponding to each ad segment data. Each ad compressed data includes the total start time of ad playback, the total end time of ad playback, the scheme ID of each ad scheme in the ad compressed data, and the playback frequency of each ad scheme.

[0041] The transmission unit is used to upload the compressed advertising data corresponding to each advertising segment to the monitoring center, so that after receiving each compressed advertising data, the monitoring center decompresses each compressed advertising data to obtain several decompressed advertising data, and stores the several decompressed advertising data to complete the storage of the advertising monitoring data after storage.

[0042] Thirdly, another storage device for advertising monitoring data is provided. Taking the device as a monitoring center as an example, it includes:

[0043] The receiving unit is used to receive various compressed advertising data sent by the advertising playback device. Each of the compressed advertising data includes the total start time of advertising playback, the total end time of advertising playback, the scheme ID of each advertising scheme in the compressed advertising data, and the playback frequency of each advertising scheme.

[0044] The decompression unit is used to decompress the compressed data of each advertisement to obtain several decompressed advertisement data.

[0045] The storage unit is used to store a number of decompressed advertising data, so as to complete the storage of the advertising monitoring data after storage.

[0046] Fourthly, a third type of advertising monitoring data storage device is provided. Taking an electronic device as an example, it includes a memory, a processor, and a transceiver that are connected in sequence. The memory is used to store computer programs, the transceiver is used to send and receive messages, and the processor is used to read the computer programs and execute the advertising monitoring data storage method as described in the first aspect or any possible design in the first aspect.

[0047] Fifthly, a storage medium is provided, on which instructions are stored, which, when executed on a computer, perform the method for storing advertising monitoring data as described in the first aspect or any possible design of the first aspect.

[0048] In a sixth aspect, a computer program product containing instructions is provided, which, when executed on a computer, cause the computer to perform the method for storing advertising monitoring data as described in the first aspect or any possible design of the first aspect.

[0049] Beneficial effects:

[0050] (1) The present invention compresses the data monitored in several playback cycles into one data for uploading, thereby reducing the amount of data uploaded, thereby reducing the cost of network bandwidth and background storage space resources.

[0051] (2) The present invention uses the advertising playback time in the data reported by the device to partition the data, which can not only improve the query performance, availability and maintainability of the monitoring center, but also balance the I / O load of the monitoring center storage, thereby further improving the storage performance. Attached Figure Description

[0052] Figure 1 This is a schematic diagram of the architecture of the advertising monitoring data storage system provided in an embodiment of the present invention;

[0053] Figure 2 A flowchart illustrating the steps of the method for storing advertising monitoring data provided in an embodiment of the present invention;

[0054] Figure 3 A schematic diagram illustrating a prior art storage method provided in an embodiment of the present invention;

[0055] Figure 4 This is a schematic diagram of the structure of an advertising playback device provided in an embodiment of the present invention;

[0056] Figure 5 This is a schematic diagram of the structure of a monitoring center provided in an embodiment of the present invention;

[0057] Figure 6 This is a schematic diagram of the structure of an electronic device provided in an embodiment of the present invention. Detailed Implementation

[0058] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the present invention will be briefly introduced below in conjunction with the accompanying drawings and descriptions of the embodiments or the prior art. Obviously, the following description of the structure of the accompanying drawings is only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. It should be noted that the description of these embodiments is for the purpose of helping to understand the present invention, but does not constitute a limitation of the present invention.

[0059] It should be understood that although the terms first, second, etc., may be used herein to describe various units, these units should not be limited by these terms. These terms are only used to distinguish one unit from another. For example, a first unit may be referred to as a second unit, and similarly, a second unit may be referred to as a first unit, without departing from the scope of the exemplary embodiments of the invention.

[0060] It should be understood that the term "and / or" that may appear in this document is merely a description of the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can mean: A exists alone, B exists alone, and A and B exist simultaneously. The term " / and" that may appear in this document describes another relationship between related objects, indicating that two relationships can exist. For example, A / and B can mean: A exists alone, and A and B exist alone. In addition, the character " / " that may appear in this document generally indicates that the related objects before and after it are in an "or" relationship.

[0061] Example:

[0062] See Figure 1 As shown, this application provides a system architecture. For example, the system may include, but is not limited to, a broadcast control platform, advertising broadcast control auxiliary equipment (i.e., mobile phones, computers, or tablets), advertising playback devices, and a monitoring center. The broadcast control platform is communicatively connected to both the advertising playback devices and the advertising broadcast control auxiliary equipment, and is used to send configuration parameters to both devices. These configuration parameters include monitoring round parameters and a maximum number of uploaded items. Furthermore, the monitoring round parameters are used to determine the compression period of the advertising monitoring data recorded by the advertising playback devices. This compression period is an integer multiple of the advertising playback period of the advertising playback devices. Therefore, the compression period essentially determines how many advertising playback periods' worth of data should be used. The system compresses the data into a single compressed dataset. The advertising playback device, based on configuration parameters, divides the advertising monitoring data, compresses the divided data, and uploads the compressed data to the monitoring center for storage. This allows the system to compress the uploaded data according to the configured compression cycle, reducing the amount of data uploaded and thus minimizing bandwidth and backend storage resources. Additionally, the advertising playback control auxiliary device acts as a data relay when the advertising playback device is offline. Its functions include sending configuration parameters to the advertising playback device and uploading the compressed data from the advertising playback device to the monitoring center. This ensures that advertising monitoring data can still be recorded and stored even when the device is offline, guaranteeing data integrity.

[0063] See Figure 2 As shown, the method for storing advertising monitoring data provided in this embodiment can be operated, but is not limited to, on the advertising playback device side and the monitoring center side. The advertising playback device can be, but is not limited to, an elevator TV. It is understood that the aforementioned execution entity does not constitute a limitation on the embodiments of this application. Accordingly, the operation steps of this method can be, but are not limited to, the steps S1 to S7 below.

[0064] S1. The advertising playback device acquires advertising monitoring data and monitoring round parameters, wherein the monitoring round parameters are used to characterize the data compression period of the advertising monitoring data, the data compression period is an integer multiple of the advertising playback period of the advertising playback device, and the advertising playback device is used to play the deployed advertising schemes within the advertising playback period; in specific applications, the advertising monitoring data may include, but is not limited to, several advertising playback period data, wherein, for example, any one of the several advertising playback period data includes the device ID of the advertising playback device and at least one advertising scheme playback data, and each advertising scheme playback data in the at least one advertising scheme playback data includes a scheme ID, an advertising playback start time, and an advertising playback end time; in this embodiment, one advertising playback period is... The duration of one round of advertising playback on an advertising playback device refers to the time it takes for the device to play the advertised ads within that playback cycle. For example, if an advertising playback cycle is 10 minutes and the device has 10 ad campaigns, then all 10 ad campaigns can be played within 10 minutes. Furthermore, the monitoring cycle parameter is set by the user on the broadcast control platform according to actual needs (e.g., 5 times, 10 times, 15 times, or 20 times, etc.), and is sent to the advertising playback device by the broadcast control platform when the device is connected to the network. The following example illustrates the function of the monitoring cycle parameter. Assuming the monitoring cycle parameter is 5 times, which means the compression cycle is 5, it essentially compresses the data recorded in every 5 playback cycles on the advertising playback device into a single data entry. Of course, the meanings corresponding to different monitoring cycle parameters are the same as in the previous example, and will not be repeated here.

[0065] After obtaining the monitoring round parameters, the advertising monitoring data can be compressed based on these parameters, as shown in steps S2 and S3 below.

[0066] S2. The advertising playback device divides the advertising monitoring data based on the monitoring cycle parameter to obtain several advertising segment data. In specific applications, as explained above, the monitoring cycle parameter is essentially used to determine the compression period of the advertising monitoring data, and the compression period is an integer multiple of the advertising playback period. Thus, it is equivalent to dividing the advertising monitoring data according to the compression period. The division process is as follows: the advertising monitoring data is divided into lengths using the monitoring cycle parameter as the division length, so that several advertising segment data are obtained after the division. Each advertising segment data includes n advertising playback period data, and n is the monitoring cycle parameter.

[0067] The following example illustrates step S2:

[0068] Assuming the monitoring round parameter is 5 and the ad monitoring data includes 15 ad playback cycles, then the data is divided using 5 ad playback cycles as the division length. In this way, the ad monitoring data can be divided into 3 ad segment data. Of course, when the monitoring round parameter and the number of ad monitoring data are different, the division principle is the same as the previous example, and will not be repeated here.

[0069] After dividing the advertising monitoring data based on the monitoring round parameters, the data of each advertising segment can be compressed so that the compressed data can be uploaded to the monitoring center for storage. The compression process can be, but is not limited to, the steps shown in step S3 below.

[0070] S3. The advertising playback device compresses each advertising segment data to obtain the compressed advertising data corresponding to each advertising segment data. Each compressed advertising data includes the total start time of advertising playback, the total end time of advertising playback, the scheme ID of each advertising scheme within the compressed advertising data, and the playback frequency of each advertising scheme. In specific applications, advertising information within each advertising segment data can be extracted, and then each advertising information can be compressed to obtain the compressed advertising data for each advertising segment data. In this embodiment, since the compression process for each advertising segment data is the same, the following uses any advertising segment data as an example to specifically illustrate the data compression process, which can be, but is not limited to, the steps S31 to S34 below.

[0071] S31. For any ad segmentation data, count the total number of scheme IDs for each ad scheme within each ad playback period corresponding to the ad segmentation data, so as to obtain the playback frequency of each ad scheme in the ad segmentation data; in specific applications, the number of scheme IDs for each ad scheme in the ad segmentation data is used as the playback frequency of each ad scheme. The above step S31 is illustrated below with an example.

[0072] Assume any ad segment data includes three playback periods, and the device ID of the ad playback device is 909090. The first playback period data includes playback data for three ad campaigns: the first ad campaign is Ad Campaign A (this is the campaign ID), with playback starting at 10:00 AM on October 10, 2022, and ending at 10:03 AM on October 10, 2022. The second ad campaign is Ad Campaign B, with playback starting at 10:03 AM on October 10, 2022. The ad playback time for the first ad campaign is 10:04 AM on October 10, 2022. The playback data for the third ad campaign is as follows: Ad Campaign C, with a start time of 10:04 AM and an end time of 10:05 AM on October 10, 2022. The second playback period includes playback data for three ad campaigns. The playback data for the first ad campaign is as follows: Ad Campaign A, with a start time of 10:05 AM on October 10, 2022 and an end time of 10:08 AM on October 10, 2022. The playback data for the second advertising campaign is as follows: Campaign B, with an ad start time of 10:08 AM on October 10, 2022, and an ad end time of 10:09 AM on October 10, 2022. The playback data for the third advertising campaign is as follows: Campaign C, with an ad start time of 10:09 AM on October 10, 2022, and an ad end time of 10:10 AM on October 10, 2022. The third playback period data includes playback data for all three advertising campaigns. The playback data for the first advertising campaign is as follows: Campaign A, with an ad start time of... The ad playback time for the first ad campaign is 10:10 AM on October 10, 2022, and ends at 10:13 AM on October 10, 2022. The playback data for the second ad campaign is as follows: Ad Campaign B, ad playback started at 10:13 AM on October 10, 2022, and ended at 10:14 AM on October 10, 2022. The playback data for the third ad campaign is as follows: Ad Campaign C, ad playback started at 10:14 AM on October 10, 2022, and ended at 10:15 AM on October 10, 2022.

[0073] Therefore, the total number of each scheme ID in the three playback period data can be counted to determine the playback frequency of each advertising scheme. That is, in the three playback period data, the number of scheme IDs A is 3, the number of scheme IDs B is 3, and the number of scheme IDs C is 3. Therefore, the playback frequency of advertising scheme A is 3 times, the playback frequency of advertising scheme B is 3 times, and the playback frequency of advertising scheme C is 3 times. Of course, the principle for determining the playback frequency of advertising schemes within different numbers of playback period data is the same as the previous example, and will not be repeated here.

[0074] After obtaining the playback frequency of each advertising scheme in any advertising segment data, it is also necessary to determine the total start time and total end time of advertising playback in any advertising segment data. The process of determining the playback time is as shown in step S32 below.

[0075] S32. Based on the ad play start time and ad play end time of each ad scheme within each ad play cycle data corresponding to any ad segmentation data, determine the total ad play start time and total ad play end time of any ad segmentation data; in specific applications, this is equivalent to statistically calculating the ad play start time and ad play end time of all ad schemes within any ad segmentation data, then using the earliest play start time as the total ad play start time, and the latest ad play end time as the total ad play end time; still based on the aforementioned example. Based on the examples above, the earliest start time for the advertisement playback is 10:00 AM on October 10, 2022, and the latest end time is 10:14 AM on October 10, 2022. Therefore, 10:00 AM on October 10, 2022 is taken as the total start time for the advertisement playback, and 10:15 AM on October 10, 2022 is taken as the total end time for the advertisement playback. Of course, if the start time and end time of the advertisement playback are different, the principle for determining the total start time and end time of the advertisement playback is the same as in the examples above, and will not be repeated here.

[0076] After obtaining the aforementioned data, the device ID of the advertising playback device can be combined to form the advertising information for any advertising segmentation data, as shown in step S33 below.

[0077] S33. Obtain the device ID from any ad playback cycle data within any ad segmentation data, and use the device ID, the total start time of ad playback, the total end time of ad playback, and the playback frequency of each ad scheme to form the ad information of any ad segmentation data; In this embodiment, based on the aforementioned example, the ad information of any ad segmentation data includes: device ID is 909090, the playback frequency of ad scheme A is 3 times, the playback frequency of ad scheme B is 3 times, the playback frequency of ad scheme C is 3 times, the total start time of ad playback is 10:00 on October 10, 2022, and the total end time of ad playback is 10:15 on October 10, 2022.

[0078] After obtaining the advertising information of any advertising segment data, compression processing can be performed to obtain its corresponding compressed advertising data. The compression process is shown in step S34 below.

[0079] S34. Compress the advertising information of any of the advertising segment data to obtain compressed advertising data corresponding to any of the advertising segment data after compression. In specific applications, a compression start character and a compression end character are first added to the advertising information of any of the advertising segment data to obtain preprocessed advertising information. Then, the preprocessed advertising information is compressed, and after data compression, the compressed advertising data corresponding to any of the advertising segment data can be obtained. In this embodiment, the compression start character can be, but is not limited to, “^”, and the compression end character can be, but is not limited to, “$”. Of course, the aforementioned two characters can be specifically set according to actual use, and are not limited to the aforementioned examples.

[0080] Thus, based on the aforementioned steps S31 to S34, each ad segment data can be compressed to obtain the compressed ad data for each ad segment.

[0081] In this embodiment, as explained above, the configuration parameters also include the maximum number of uploads. Therefore, after obtaining each compressed data, it can be determined whether the total number of compressed advertising data is greater than the maximum number of uploads. If so, the data can be uploaded directly, i.e., step S4 below is executed. Otherwise, the upload is stopped until the total number of compressed advertising data is greater than the maximum number of uploads.

[0082] S4. The advertising playback device uploads the compressed advertising data corresponding to each advertising segment to the monitoring center. In this embodiment, the compressed advertising data can be uploaded to the monitoring center using a wireless or wired network, but is not limited to this method. After receiving the compressed advertising data, the monitoring center can store the data, as shown in steps S5, S6 and S7 below.

[0083] S5. The monitoring center receives compressed data of various advertisements sent by the advertising playback devices.

[0084] S6. The monitoring center decompresses each compressed advertisement data to obtain several decompressed advertisement data. In specific applications, decompression is equivalent to obtaining the device ID, the ID of each advertisement scheme, the playback frequency, whether the total start time of advertisement playback is empty, and the total end time of advertisement playback from each compressed advertisement data. Furthermore, the decompressed data can be combined as follows: playback time - device ID - scheme ID - frequency. The playback time can be, but is not limited to, the date to which the total start time of playback belongs. Thus, for any compressed advertisement data, the number of advertisement schemes it contains corresponds to the number of decompressed data entries, and the aforementioned decompressed data constitutes the decompressed advertisement data. In this embodiment, the monitoring center also needs to filter the data to remove abnormal data. Abnormal data includes data with empty playback frequency, empty total start time of advertisement playback, empty total end time of advertisement playback, and / or empty device ID. This ensures the accuracy of the data.

[0085] After decompressing each advertisement's compressed data, the data can be stored, as shown in step S7 below.

[0086] S7. The monitoring center stores a number of decompressed advertising data to complete the storage of the advertising monitoring data after storage; in specific applications, a partitioned storage method can be used, but is not limited to, to improve query performance. The storage process is as shown in steps S71 and S72 below.

[0087] S71. Based on the total start time and total end time of each decompressed ad data, determine the playback date of each decompressed ad data. In this embodiment, the playback date of any decompressed ad data may be, but is not limited to, the month corresponding to the date to which the total start time of playback in any decompressed ad data belongs. For example, if the total start time of playback in any decompressed ad data is 10:00 AM on October 10, 2022, then the playback date is October 2022. Of course, the playback dates of other decompressed ad data are also determined using this principle, which will not be elaborated here.

[0088] After obtaining the playback dates of each decompressed advertisement, the data can be stored according to the playback dates, as shown in step S72 below.

[0089] S72. Several decompressed advertisement data are partitioned and stored according to the playback date, so that decompressed advertisement data belonging to the same playback date are stored in one partition; through the aforementioned design, this embodiment uses the advertisement playback time in the device reported data for partitioning, which can not only improve the query performance, availability and maintainability of the monitoring center, but also balance the I / O load of the monitoring center storage, thereby further improving storage performance.

[0090] In addition, as described above, an advertising playback control auxiliary device is also provided in this embodiment, which is used to transmit data when the advertising playback device is offline. Therefore, when the advertising playback device is offline (the reason for offline may be due to network failure or network signal, or the device itself is an offline device), its data storage process is as shown in the following steps.

[0091] S8. When establishing a communication connection between the local area network and the advertising broadcast control auxiliary equipment, the compressed advertising data corresponding to each advertising segment is transmitted to the advertising broadcast control auxiliary equipment, so that the advertising broadcast control auxiliary equipment, after receiving each compressed advertising data, uploads each compressed advertising data to the monitoring center; in specific applications, staff can, but are not limited to, carry the advertising broadcast control auxiliary equipment to the area where the advertising playback equipment is installed, and then manually connect it. In this way, the upload of the compressed advertising data can be completed based on the advertising broadcast control auxiliary equipment, thereby ensuring the integrity of the data record.

[0092] Furthermore, when the advertising playback device detects the network, it will transmit data. Therefore, in order to avoid duplicate data transmission, this embodiment also includes a deduplication step, as shown in step S9 below.

[0093] S9. After receiving any compressed advertising data transmitted by the advertising broadcast control auxiliary device, the monitoring center parses the compressed advertising data to determine whether there is compressed advertising data with target data in the storage database based on the scheme ID, device ID, and playback time (i.e., total start time and total end time of playback) in the compressed advertising data. The target data includes the scheme ID, device ID, and playback time in the compressed advertising data. If so, the compressed advertising data is discarded; otherwise, it is stored. Through the aforementioned design, the problem of duplicate data transmission can be avoided, thereby further reducing the storage space resources required by the backend. In this embodiment, a batch number can be set for each compressed data upload, and then data deduplication can be performed in combination with the batch number.

[0094] Thus, through the aforementioned design, in Figure 3 Based on this, traditional storage methods require uploading 10 data entries, while this application, if calculated based on a monitoring cycle of 2 (i.e., including 2 advertising playback periods), from... Figure 3 As can be seen from this, each ad playback cycle contains 5 data entries, so only 1 data entry needs to be uploaded, thus significantly reducing the amount of data uploaded.

[0095] Therefore, through the advertising monitoring data storage method described in detail in steps S1 to S9 above, on the one hand, the present invention compresses the data monitored within several playback cycles into a single data entry for uploading, thereby reducing the amount of data uploaded and thus achieving the goal of reducing network bandwidth and backend storage space resource costs; on the other hand, the present invention uses the advertising playback time in the device-reported data for partitioning, which not only improves the query performance, availability, and maintainability of the monitoring center, but also balances the I / O load of the monitoring center's storage, thereby further improving storage performance.

[0096] like Figure 4 As shown, the second aspect of this embodiment provides a hardware device for implementing the method for storing advertising monitoring data described in the first aspect of the embodiment. Taking an advertising playback device as an example, the device includes:

[0097] The data acquisition unit is used to acquire advertising monitoring data and monitoring round parameters, wherein the monitoring round parameters are used to characterize the data compression period of the advertising monitoring data, the data compression period is an integer multiple of the advertising playback period of the advertising playback device, and the advertising playback device is used to play the deployed advertising scheme within the advertising playback period.

[0098] The data segmentation unit is used to segment the advertising monitoring data based on the monitoring round parameters to obtain several advertising segmentation data.

[0099] The data compression unit is used to compress each ad segment data to obtain the ad compressed data corresponding to each ad segment data. Each ad compressed data includes the total start time of ad playback, the total end time of ad playback, the scheme ID of each ad scheme in the ad compressed data, and the playback frequency of each ad scheme.

[0100] The transmission unit is used to upload the compressed advertising data corresponding to each advertising segment to the monitoring center, so that after receiving each compressed advertising data, the monitoring center decompresses each compressed advertising data to obtain several decompressed advertising data, and stores the several decompressed advertising data to complete the storage of the advertising monitoring data after storage.

[0101] The working process, working details and technical effects of the device provided in this embodiment can be found in the first aspect of the embodiment, and will not be repeated here.

[0102] like Figure 5 As shown, the third aspect of this embodiment provides another hardware device for implementing the advertising monitoring data storage method described in the first aspect of the embodiment. Taking the device as a monitoring center as an example, it includes:

[0103] The receiving unit is used to receive various compressed advertising data sent by the advertising playback device. Each of the compressed advertising data includes the total start time of advertising playback, the total end time of advertising playback, the scheme ID of each advertising scheme in the compressed advertising data, and the playback frequency of each advertising scheme.

[0104] The decompression unit is used to decompress the compressed data of each advertisement to obtain several decompressed advertisement data.

[0105] The storage unit is used to store a number of decompressed advertising data, so as to complete the storage of the advertising monitoring data after storage.

[0106] The working process, working details and technical effects of the device provided in this embodiment can be found in the first aspect of the embodiment, and will not be repeated here.

[0107] like Figure 6 As shown, the fourth aspect of this embodiment provides a third type of advertising monitoring data storage device. Taking an electronic device as an example, it includes: a memory, a processor, and a transceiver that are connected in sequence. The memory is used to store a computer program, the transceiver is used to send and receive messages, and the processor is used to read the computer program and execute the advertising monitoring data storage method as described in the first aspect of the embodiment.

[0108] For specific examples, the memory may include, but is not limited to, random access memory (RAM), read-only memory (ROM), flash memory, first-in-first-out (FIFO) memory, and / or first-in-last-out (FILO) memory, etc.; specifically, the processor may include one or more processing cores, such as a 4-core processor, an 8-core processor, etc. The processor may be implemented using at least one hardware form of DSP (Digital Signal Processing), FPGA (Field-Programmable Gate Array), PLA (Programmable Logic Array). The processor may also include a main processor and a coprocessor. The main processor is used to process data in the wake-up state, also known as the CPU (Central Processing Unit); the coprocessor is a low-power processor used to process data in the standby state.

[0109] In some embodiments, the processor may integrate a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content to be displayed on the screen. For example, the processor may not be limited to microprocessors of the STM32F105 series, reduced instruction set computer (RISC) microprocessors, x86 architecture processors, or processors with integrated embedded neural network processing units (NPUs). The transceiver may be, but is not limited to, a Wi-Fi transceiver, a Bluetooth transceiver, a General Packet Radio Service (GPRS) transceiver, a ZigBee (a low-power LAN protocol based on the IEEE 802.15.4 standard) transceiver, a 3G transceiver, a 4G transceiver, and / or a 5G transceiver. Furthermore, the device may also include, but is not limited to, a power module, a display screen, and other necessary components.

[0110] The working process, working details and technical effects of the electronic device provided in this embodiment can be found in the first aspect of the embodiment, and will not be repeated here.

[0111] The fifth aspect of this embodiment provides a storage medium that stores instructions for a storage method for storing advertising monitoring data as described in the first aspect of the embodiment. That is, the storage medium stores instructions that, when executed on a computer, perform the storage method for storing advertising monitoring data as described in the first aspect.

[0112] The storage medium refers to a carrier for storing data, which may include, but is not limited to, floppy disks, optical disks, hard disks, flash memory, USB flash drives, and / or memory sticks. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices.

[0113] The working process, working details, and technical effects of the storage medium provided in this embodiment can be found in the first aspect of the embodiment, and will not be repeated here.

[0114] The sixth aspect of this embodiment provides a computer program product containing instructions that, when executed on a computer, cause the computer to perform the method for storing advertising monitoring data as described in the first aspect of this embodiment, wherein the computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device.

[0115] Finally, it should be noted that the above description is merely a preferred embodiment of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A method for storing advertising monitoring data, characterized in that, Used in advertising display devices, including: Acquire advertising monitoring data and monitoring round parameters, wherein the monitoring round parameters are used to characterize the data compression period of the advertising monitoring data, the data compression period is an integer multiple of the advertising playback period of the advertising playback device, and the advertising playback device is used to play the deployed advertising scheme within the advertising playback period; Based on the monitoring round parameters, the advertising monitoring data is divided into several advertising segmentation data. Each ad segment is compressed to obtain the compressed ad data corresponding to each ad segment. Each compressed ad data includes the total start time of ad playback, the total end time of ad playback, the scheme ID of each ad scheme within the compressed ad data, and the playback frequency of each ad scheme. The compressed advertising data corresponding to each advertising segment is uploaded to the monitoring center. After receiving each compressed advertising data, the monitoring center decompresses each compressed advertising data to obtain several decompressed advertising data. The decompressed advertising data is then stored to complete the storage of the advertising monitoring data. The advertising monitoring data includes several advertising playback cycle data, wherein any one of the advertising playback cycle data includes the device ID of the advertising playback device and at least one advertising scheme playback data, and each of the at least one advertising scheme playback data includes a scheme ID, an advertising playback start time, and an advertising playback end time. Specifically, based on the monitoring round parameters, the advertising monitoring data is divided into several advertising segmentation data, including: Using the monitoring round parameter as the division length, the advertising monitoring data is divided into lengths to obtain several advertising division data. Each advertising division data includes n advertising playback cycle data, and n is the monitoring round parameter. Accordingly, the data for each ad segment is compressed, including: For any ad segmentation data, the total number of scheme IDs for each ad scheme within each ad playback period corresponding to the ad segmentation data is counted to obtain the playback frequency of each ad scheme in the ad segmentation data. Based on the ad play start time and ad play end time of each ad scheme within each ad play cycle data corresponding to any ad segmentation data, the total ad play start time and total ad play end time of any ad segmentation data are determined. Specifically, the ad play start time and ad play end time of all ad schemes within any ad segmentation data are counted. Then, the earliest play start time is taken as the total ad play start time, and the latest ad play end time is taken as the total ad play end time. Obtain the device ID from any ad playback period data within any ad segmentation data, and use the device ID, the total start time of ad playback, the total end time of ad playback, and the playback frequency of each ad scheme to compose the ad information of any ad segmentation data; The advertising information of any of the advertising segment data is compressed to obtain the compressed advertising data corresponding to any of the advertising segment data.

2. The method according to claim 1, wherein the advertising information of any of the advertising segmentation data is compressed to obtain compressed advertising data corresponding to any of the advertising segmentation data after compression, comprising: For the advertising information of any of the advertising segment data, add compression start characters and compression end characters to the advertising information of any of the advertising segment data to obtain preprocessed advertising information; The preprocessed advertising information is compressed to obtain the compressed advertising data corresponding to any of the advertising segment data.

3. The method according to claim 1, characterized in that, If the advertising playback device is an offline device, the method further includes: When establishing a communication connection with the advertising broadcast control auxiliary equipment based on the local area network, the compressed data of each advertising segment is transmitted to the advertising broadcast control auxiliary equipment, so that the advertising broadcast control auxiliary equipment can upload each compressed data of each advertisement to the monitoring center after receiving the compressed data of each advertisement.

4. The method according to claim 1, characterized in that, After obtaining the compressed ad data corresponding to each ad segment, the method further includes: Determine if the total number of compressed ad data items exceeds the maximum number of uploads. If so, the compressed ad data corresponding to each ad segment will be uploaded to the monitoring center.

5. A storage device for advertising monitoring data, characterized in that, The method for storing advertising monitoring data according to any one of claims 1 to 4, wherein the apparatus comprises: The data acquisition unit is used to acquire advertising monitoring data and monitoring round parameters, wherein the monitoring round parameters are used to characterize the data compression period of the advertising monitoring data, the data compression period is an integer multiple of the advertising playback period of the advertising playback device, and the advertising playback device is used to play the deployed advertising scheme within the advertising playback period. A data partitioning unit is used to partition the advertising monitoring data based on the monitoring round parameters to obtain several advertising partition data. The data compression unit is used to compress each ad segment data to obtain the ad compressed data corresponding to each ad segment data. Each ad compressed data includes the total start time of ad playback, the total end time of ad playback, the scheme ID of each ad scheme in the ad compressed data, and the playback frequency of each ad scheme. The transmission unit is used to upload the compressed advertising data corresponding to each advertising segment to the monitoring center, so that after receiving each compressed advertising data, the monitoring center decompresses each compressed advertising data to obtain several decompressed advertising data, and stores the several decompressed advertising data to complete the storage of the advertising monitoring data after storage.

6. A storage medium, characterized in that, The storage medium stores instructions that, when executed on a computer, perform the method for storing advertising monitoring data as described in any one of claims 1 to 4.

Images