Disclosure of Invention
The application provides a method, a device, a medium and equipment for determining video playing time delay, which are used for solving the problem that the accuracy of video playing time delay obtained by calculation in the prior art is low.
In a first aspect, an embodiment of the present application provides a method for determining a video playing time delay, including:
aiming at each selective play identifier of a specified user, determining a selective play timestamp and a play start timestamp corresponding to the selective play identifier, wherein the selective play identifier is generated according to the corresponding selective play video operation of the specified user within a preset time period, and the selective play identifiers corresponding to the videos which are selected to be played each time are different;
and determining the time length corresponding to the difference value of the playing start timestamp and the playing selection timestamp as the video playing time delay corresponding to the playing selection identifier, wherein the video playing time delay is the time length required by the appointed user to select the video corresponding to the playing selection identifier to watch the video corresponding to the playing selection identifier.
Optionally, determining a selective playing time stamp and a play start time stamp corresponding to the selective playing identifier specifically includes:
extracting entries which simultaneously comprise the user identification of the specified user and the selective playing identification from a pre-stored video playing fingerprint table, wherein each entry in the video playing fingerprint table comprises a user identification, a selective playing timestamp and a playing starting timestamp;
and taking the selective playing time stamp in the extracted table entry as the selective playing time stamp corresponding to the selective playing identifier, and taking the play starting time stamp in the extracted table entry as the play starting time stamp corresponding to the selective playing identifier.
Optionally, the video playing fingerprint table is pre-stored in the following manner:
acquiring a stored user service record in a preset time period;
extracting the user service record with the service type being the video type from the user service records as a reference service record;
dividing the reference service records carrying the same selective playing identifier into a group;
aiming at each group of reference service records, extracting a first reference service record carrying a selective playing video operation identifier and a second reference service record carrying a starting playing video operation identifier in the group of reference service records;
and taking the timestamp in the first service reference service record as a selective playing timestamp corresponding to the selective playing identifier corresponding to the group of reference service records, and taking the timestamp in the second reference service record as a playing starting timestamp corresponding to the selective playing identifier corresponding to the group of reference service records.
And storing the user identifier of the user corresponding to the group of reference service records, the selective playing identifier corresponding to the group of reference service records, the selective playing timestamp and the playing start timestamp corresponding to the selective playing identifier corresponding to the group of reference service records into the video playing fingerprint table as an entry.
Optionally, the extracting the first reference service record and the second reference service record specifically includes:
extracting a first Uniform Resource Locator (URL) used for indicating that a video is selected to be played and a second URL used for indicating that the video is started to be played in the group of reference service records;
and taking the reference service record to which the first URL belongs as a first reference service record, and taking the reference service record to which the second URL belongs as a second reference service record.
Optionally, after determining the video playing delay corresponding to the selective playing identifier, the method further includes:
and deleting the list item to which the selected playing identifier belongs in the video playing fingerprint list.
In a second aspect, an embodiment of the present application provides an apparatus for determining a video playing time delay, including:
the device comprises a first determining module, a second determining module and a playing starting module, wherein the first determining module is used for determining a selective playing time stamp and a playing starting time stamp corresponding to each selective playing identifier of an appointed user, the selective playing identifiers are generated according to the corresponding selective playing video operation of the appointed user within a preset time period, and the selective playing identifiers corresponding to the videos selected to be played each time are different;
and the second determining module is used for determining the time length corresponding to the difference value between the play starting timestamp and the play selecting timestamp as the video play time delay corresponding to the play selecting identifier, wherein the video play time delay is the time length required by the appointed user to select the video corresponding to the play selecting identifier to be played until the video corresponding to the play selecting identifier is watched.
Optionally, the first determining module is specifically configured to:
extracting entries which simultaneously comprise the user identification of the specified user and the selective playing identification from a pre-stored video playing fingerprint table, wherein each entry in the video playing fingerprint table comprises a user identification, a selective playing timestamp and a playing starting timestamp;
and taking the selective playing time stamp in the extracted table entry as the selective playing time stamp corresponding to the selective playing identifier, and taking the play starting time stamp in the extracted table entry as the play starting time stamp corresponding to the selective playing identifier.
Optionally, the apparatus for determining video playing delay provided in this embodiment of the present application further includes:
the storage module is used for pre-storing the video playing fingerprint table in the following way:
acquiring a stored user service record in a preset time period;
extracting the user service record with the service type being the video type from the user service records as a reference service record;
dividing the reference service records carrying the same selective playing identifier into a group;
aiming at each group of reference service records, extracting a first reference service record carrying a selective playing video operation identifier and a second reference service record carrying a starting playing video operation identifier in the group of reference service records;
and taking the timestamp in the first service reference service record as a selective playing timestamp corresponding to the selective playing identifier corresponding to the group of reference service records, and taking the timestamp in the second reference service record as a playing starting timestamp corresponding to the selective playing identifier corresponding to the group of reference service records.
And storing the user identifier of the user corresponding to the group of reference service records, the selective playing identifier corresponding to the group of reference service records, the selective playing timestamp and the playing start timestamp corresponding to the selective playing identifier corresponding to the group of reference service records into the video playing fingerprint table as an entry.
Optionally, when the storage module extracts the first reference service record and the second reference service record, the storage module is specifically configured to:
extracting a first Uniform Resource Locator (URL) used for indicating that a video is selected to be played and a second URL used for indicating that the video is started to be played in the group of reference service records;
and taking the reference service record to which the first URL belongs as a first reference service record, and taking the reference service record to which the second URL belongs as a second reference service record.
Optionally, the apparatus for determining video playing delay provided in this embodiment of the present application further includes:
and the deleting module is used for deleting the table entry to which the selected playing identifier belongs in the video playing fingerprint table after the second determining module determines the video playing time delay corresponding to the selected playing identifier.
In a third aspect, an embodiment of the present application provides a computer storage medium, where an executable program is stored in the computer storage medium, and the executable program is executed by a processor to implement the steps of the method for determining video playback delay.
In a fourth aspect, an embodiment of the present application provides a computing device, which includes a memory, a processor, and a computer program stored on the memory, where the processor implements the steps of the method for determining video playback delay when executing the program.
By utilizing the method, the device, the medium and the equipment for determining the video playing time delay, the following beneficial effects are achieved: after the user selects the playing video, the video playing time delay is calculated according to the selected playing time stamp corresponding to the selected playing identification and the playing starting time stamp, a more simple and convenient video playing time delay calculation mode is provided, system resources are saved, and parameters for calculating the video playing time delay are not required to be set by technical staff experience in the calculation process of the video playing time delay, so that the video playing time delay with higher accuracy can be obtained.
Detailed Description
The method, apparatus, medium, and device for determining video playback delay provided by the present application are described in more detail below with reference to the accompanying drawings and embodiments.
An embodiment of the present application provides a method for determining video playing delay, as shown in fig. 1, including:
step 101, determining a selective playing time stamp and a play starting time stamp corresponding to each selective playing identifier of a designated user, wherein the selective playing identifiers are generated according to the corresponding selective playing video operation of the designated user within a preset time period, and the selective playing identifiers corresponding to the videos selected to be played each time are different.
Specifically, a user may select a video to be watched from an application program having a video playing function of the mobile terminal, and the user may click the video to be watched and send a URL (hereinafter referred to as a URL indicating a video to be selectively played) requesting to watch the video to the network side, where the selective playing operation in the URL is the selective playing operation of the user, and the URL carries a selective playing identifier for the user to watch the video this time. The designated user may be any user who has viewed the video, and is not limited herein. The URL is called as Uniform Resource Locator in English, and Chinese is called as Uniform Resource Locator in Chinese.
In a mobile communication network, recording user service records of users who have performed service operations; the user service record includes a network accessed by a user, a cell, a reporting timestamp of the service record, a service type, device information held by the user, URL information generated by the user accessing the network, a user identifier, and the like, wherein the service type may include types of video, music, navigation, and the like, and in the case that the service type is a video type, the URL information generated by the user accessing the network includes: specifically, after the user clicks the video to be played, the device held by the user sends the URL for indicating the video to be played to the network side, and after the device held by the user receives a certain flow response of the video buffer sent by the network side, the device held by the user sends the URL for indicating the video to be played to the network side, so that the network side sends the video data of the response to the device held by the user and plays the video.
According to the method, the user service record corresponding to the video playing operation is extracted aiming at the video playing operation corresponding to the user in the preset time period, and the video identifier selected to be played is extracted from the extracted user service record; and determining the selective playing time stamp and the starting playing time stamp corresponding to the extracted selective playing identifier.
In specific implementation, for the same selective play identifier, extracting a user service record carrying the selective play operation identifier and a user service record carrying the play start operation identifier from the user service record corresponding to the selective play identifier, taking a timestamp in the user service record carrying the selective play operation identifier as a selective play timestamp, and taking a timestamp in the user service record carrying the play start operation identifier as a play start timestamp.
It should be noted that the selective playing identifiers corresponding to different videos are different, and the selective playing identifier corresponding to each selective playing of the same video is also different.
And 102, determining the duration corresponding to the difference value between the play starting timestamp and the play selecting timestamp as the video play delay corresponding to the play selecting identifier, wherein the video play delay is the duration required by the appointed user to select to play the video corresponding to the play selecting identifier and watch the video corresponding to the play selecting identifier.
Specifically, the duration corresponding to the difference between the play start timestamp corresponding to the play selection identifier and the play selection timestamp is used as the duration required by the specified user from the time of selecting to play the video corresponding to the video play identifier to the time of viewing the video corresponding to the video play identifier, that is, the video play delay corresponding to the play selection identifier.
According to the embodiment of the application, after the user selects the playing video, the video playing time delay is calculated according to the selected playing time stamp corresponding to the selected playing identification and the playing starting time stamp, a more convenient video playing time delay calculation mode is provided, system resources are saved, and parameters for calculating the video playing time delay are set without experience of technicians in the calculation process of the video playing time delay, so that the video playing time delay with higher accuracy can be obtained.
It should be noted that, the mobile communication network operator may use the video playing delay as the user experience for evaluating the user using the mobile communication network, and the more accurate the video playing delay is, the more accurate the user experience evaluation result is.
Optionally, according to the content provided in fig. 2, determining a selective play timestamp and a play start timestamp corresponding to the selective play identifier:
step 201, extracting entries including both the user identifier of the specified user and the selected play identifier from a pre-stored video play fingerprint table, where each entry in the video play fingerprint table includes a user identifier, a selected play timestamp, and a play start timestamp.
Specifically, a video playing fingerprint table is pre-stored, and each entry in the table includes a user identifier, a play selection timestamp, and a play start timestamp, where the user identifier may be a mobile phone number of a user or other identifiers for uniquely identifying a user identity. One entry in the video play fingerprint table can be uniquely determined according to the user identifier and the selected play identifier.
In specific implementation, a table entry that includes both the user identifier of the specified user and the selected play identifier in step 101 is extracted from the video play fingerprint table.
Step 202, using the selective playing time stamp in the extracted entry as the selective playing time stamp corresponding to the selective playing identifier, and using the playing start time stamp in the extracted entry as the playing start time stamp corresponding to the selective playing identifier.
Specifically, the selective playing timestamp in the extracted entry is used as the selective playing timestamp corresponding to the selective playing identifier in step 101, and the play start timestamp in the extracted entry is used as the play start timestamp corresponding to the selective playing identifier in step 101.
According to the embodiment of the application, the play starting timestamp and the play selecting timestamp corresponding to the play selecting identification can be rapidly acquired from the pre-stored video play fingerprint table, so that the play starting timestamp and the play selecting timestamp corresponding to the play selecting identification are prevented from being searched in a large number of user service records in a traversing manner, and the speed of video play time delay is increased.
Optionally, after determining the video playing delay corresponding to the selective playing identifier in the embodiment provided in fig. 1, the method further includes: and adding the video playing time delay corresponding to the selected playing identifier to the table entry of the selected playing identifier in the video playing index table. Therefore, the corresponding video playing time delay can be conveniently checked, for example, the video playing time delay corresponding to the selected playing identifier can be checked from the video playing fingerprint table according to the selected playing identifier.
Optionally, according to the content provided in fig. 3, the video playing fingerprint table is stored in advance:
step 301, obtaining a stored user service record in a preset time period.
In specific implementation, a user accesses a network through a mobile communication network, a user service record is generated, the user service record can be mirrored to a convergence and distribution processing server through the light splitting device, the user service record is obtained from the convergence and distribution processing server, and the user service record is obtained from the convergence and distribution processing server.
Step 302, extracting the user service record with the service type being the video type from the user service records as a reference service record.
Specifically, the user service related to the embodiment of the present application is a video service, and therefore, the user service record with the service type being a video type is extracted from the stored user service records within the preset time period and is used as a reference service record, so as to obtain a video playing fingerprint table in the following.
And 303, dividing the reference service records carrying the same selective play identifier into a group.
Specifically, after the user selects to play the video, the equipment held by the user sends a URL for indicating that the video is selected to be played to the network side, and then if the video needs to be played before the video starts to be played, the equipment held by the user automatically sends an advertisement playing URL and an advertisement playing ending URL to the network side, and after the advertisement is played and the video sent by the network side is received and buffered to a certain flow response, the URL for indicating that the video starts to be played is automatically sent to the network side; if the advertisement does not need to be played before the video starts to be played, the equipment held by the user automatically sends the URL for indicating the video starts to be played to the network side after receiving the response that the video sent by the network side is buffered to a certain flow. After the user selects to play the video at this time, the URLs generated aiming at the selective playing operation all carry the same selective playing identification, and as the user service records comprise the URLs, the same selective playing identification can correspond to a plurality of reference service records. In this step, the reference service records carrying the same selective play identifier are divided into a group, so as to obtain a reference service record group corresponding to each selective play identifier.
Step 304, for each group of reference service records, extracting a first reference service record carrying the selected playing video operation identifier and a second reference service record carrying the starting playing video operation identifier in the group of reference service records.
Specifically, for each group of reference service records, the reference service record carrying the selective playing operation identifier in the group of reference service records is extracted as a first reference service record, and the reference service record carrying the start playing operation identifier in the group of reference service records is extracted as a second reference service record.
More specifically, a URL indicating that a video is selected to be played in the set of reference service records may be extracted as a first URL, and a URL indicating that the video starts to be played may be extracted as a second URL; and taking the reference service record to which the first URL belongs as a first reference service record, and taking the reference service record to which the second URL belongs as a second reference service record. The URL of the video to be played is selected to carry a play-selecting operation identifier, for example, the content of the field ac in the URL is launch, that is, the operation corresponding to the URL is a video to be played selectively; the URL where the video starts to be played carries the play start operation identifier, for example, the content of the field ac in the URL is play, that is, the operation corresponding to the URL is the video play start operation.
Step 305, using the timestamp in the first reference service record as the selective playing timestamp corresponding to the selective playing identifier corresponding to the group of reference service records, and using the timestamp in the second reference service record as the playing start timestamp corresponding to the selective playing identifier corresponding to the group of reference service records.
Step 306, storing the user identifier of the user corresponding to the group of reference service records, the selective playing identifier corresponding to the group of reference service records, the selective playing timestamp and the playing start timestamp corresponding to the selective playing identifier corresponding to the group of reference service records as a table entry in the video playing fingerprint table.
Specifically, a table entry is generated for each group of reference services, and the obtained table entry generated for each group of reference service records is stored in the video playing fingerprint table. For example, a video playing fingerprint table is described, as shown in table one, the video playing fingerprint table includes a user identifier, a play selection timestamp, and a play start timestamp.
Watch 1
| User identification
|
Selection playing identifier
|
Selective play time stamp
|
Start playing time stamp
|
| MSISDN1
|
UUID1
|
T11
|
T12
|
| MSISDN2
|
UUID2
|
T21
|
T22 |
In table one, the MSISDN is specifically a mobile phone number of a user, and the user identifier may also be other identifiers used for uniquely identifying the user, which is not limited herein.
In specific implementation, a convergence distribution processing server can extract key fields of user service records, and the extracted key fields form new user service records and send the new user service records to a distributed database; generating a video playing fingerprint table by the distributed database according to the new user service record; the distributed database sends the generated video playing fingerprint table to the application server, and the application server executes the step of determining the video playing time delay provided in fig. 1. The key fields comprise service types, user identifications, playing selection identifications, URLs for selecting videos to be played, URLs for starting to play videos, timestamps in service records to which the URLs for selecting videos to be played belong and timestamps in service records to which the URLs for starting to play videos belong. Of course, each of the embodiments provided in the embodiments of the present application may also be executed by an application server, and an execution subject of the embodiments of the present application is not limited herein.
It should be noted that the user identifier, the selective play timestamp, and the play start timestamp in any entry in the generated video play fingerprint table are all not empty, and if there is an entry in which at least one of the user identifier, the selective play timestamp, and the play start timestamp is empty, the entry is deleted.
After the method for determining video playing time delay according to the embodiment of the present application is introduced, a device for determining video playing time delay according to the embodiment of the present application is introduced next.
An embodiment of the present application provides a device for determining video playing time delay, as shown in fig. 4, including:
a first determining module 401, configured to determine, for each selective play identifier of an appointed user, a selective play timestamp and a play start timestamp corresponding to the selective play identifier, where the selective play identifier is generated according to a selective play video operation corresponding to the appointed user within a preset time period, and the selective play identifiers corresponding to videos that are selectively played each time are different;
a second determining module 402, configured to determine a duration corresponding to a difference between the play start timestamp and the play selection timestamp as a video play delay corresponding to the play selection identifier, where the video play delay is a duration required by the specified user to select to play the video corresponding to the play selection identifier and view the video corresponding to the play selection identifier.
Optionally, the first determining module 401 is specifically configured to:
extracting entries which simultaneously comprise the user identification of the specified user and the selective playing identification from a pre-stored video playing fingerprint table, wherein each entry in the video playing fingerprint table comprises a user identification, a selective playing timestamp and a playing starting timestamp;
and taking the selective playing time stamp in the extracted table entry as the selective playing time stamp corresponding to the selective playing identifier, and taking the play starting time stamp in the extracted table entry as the play starting time stamp corresponding to the selective playing identifier.
Optionally, the apparatus for determining video playing delay provided in this embodiment of the present application further includes:
a storage module 403, configured to store the video playing fingerprint table in advance in the following manner:
acquiring a stored user service record in a preset time period;
extracting the user service record with the service type being the video type from the user service records as a reference service record;
dividing the reference service records carrying the same selective playing identifier into a group;
aiming at each group of reference service records, extracting a first reference service record carrying a selective playing video operation identifier and a second reference service record carrying a starting playing video operation identifier in the group of reference service records;
and taking the timestamp in the first service reference service record as a selective playing timestamp corresponding to the selective playing identifier corresponding to the group of reference service records, and taking the timestamp in the second reference service record as a playing starting timestamp corresponding to the selective playing identifier corresponding to the group of reference service records.
And storing the user identifier of the user corresponding to the group of reference service records, the selective playing identifier corresponding to the group of reference service records, the selective playing timestamp and the playing start timestamp corresponding to the selective playing identifier corresponding to the group of reference service records into the video playing fingerprint table as an entry.
Optionally, when the storage module 403 extracts the first reference service record and the second reference service record, it is specifically configured to:
extracting a first Uniform Resource Locator (URL) used for indicating that a video is selected to be played and a second URL used for indicating that the video is started to be played in the group of reference service records;
and taking the reference service record to which the first URL belongs as a first reference service record, and taking the reference service record to which the second URL belongs as a second reference service record.
Optionally, the apparatus for determining video playing delay provided in this embodiment of the present application further includes:
a deleting module 404, configured to delete the entry to which the selected playing identifier belongs in the video playing fingerprint table after the second determining module determines that the video playing delay corresponding to the selected playing identifier is delayed.
After the method and the apparatus for determining video playing latency according to the embodiments of the present application are introduced, a computer storage medium for determining video playing latency according to the embodiments of the present application is introduced next.
The embodiment of the application provides a computer storage medium, wherein an executable program is stored in the computer storage medium, and the executable program is executed by a processor to implement the steps of the method for determining the video playing time delay. Optionally, the computer storage media is non-volatile computer storage media.
Having described the method, apparatus, and medium for determining video playback delay according to embodiments of the present application, a computing device for determining video playback delay according to embodiments of the present application is described next.
The embodiment of the present application provides a computing device, which includes a memory, a processor, and a computer program stored on the memory, where the processor implements the steps of any method for determining video playing time delay in the foregoing embodiments when executing the program.
An embodiment of the present application provides a computing device, configured to execute the method for determining video playing delay in the foregoing embodiment, as shown in fig. 5, which is a schematic diagram of a hardware structure of the computing device in the implementation of the present application, where the computing device may specifically be a desktop computer, a portable computer, a smart phone, a tablet computer, and the like. Specifically, the computing device may include a memory 501, a processor 502 and a computer program stored on the memory, wherein the processor executes the program to implement the steps of any one of the above-mentioned methods for determining video playback latency. Memory 501 may include Read Only Memory (ROM) and Random Access Memory (RAM), among other things, and provides processor 502 with program instructions and data stored in memory 501.
Further, the computing device described in this embodiment of the present application may further include an input device 503, an output device 504, and the like. The input device 503 may include a keyboard, a mouse, a touch screen, etc.; the output device 504 may include a Display device such as a Liquid Crystal Display (LCD), a Cathode Ray Tube (CRT), a touch screen, or the like. The memory 501, the processor 502, the input device 503 and the output device 504 may be connected by a bus or other means, and fig. 5 illustrates the connection by a bus as an example.
The processor 502 calls the program instructions stored in the memory 501 and executes the method for determining the video playing time delay provided by the above embodiment according to the obtained program instructions.
By utilizing the method, the device, the medium and the equipment for determining the video playing time delay, the following beneficial effects are achieved: after the user selects the playing video, the video playing time delay is calculated according to the selected playing time stamp corresponding to the selected playing identification and the playing starting time stamp, a more simple and convenient video playing time delay calculation mode is provided, system resources are saved, and parameters for calculating the video playing time delay are not required to be set by technical staff experience in the calculation process of the video playing time delay, so that the video playing time delay with higher accuracy can be obtained.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While the preferred embodiments of the present application have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all alterations and modifications as fall within the scope of the application.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.