CN109982143B - Method, device, medium and equipment for determining video playing time delay - Google Patents

Method, device, medium and equipment for determining video playing time delay Download PDF

Info

Publication number
CN109982143B
CN109982143B CN201711462192.8A CN201711462192A CN109982143B CN 109982143 B CN109982143 B CN 109982143B CN 201711462192 A CN201711462192 A CN 201711462192A CN 109982143 B CN109982143 B CN 109982143B
Authority
CN
China
Prior art keywords
playing
video
selective
identifier
reference service
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201711462192.8A
Other languages
Chinese (zh)
Other versions
CN109982143A (en
Inventor
耶旭立
曾强
刘立宇
康萌
赵亚云
张昊程
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Mobile Communications Group Co Ltd
China Mobile Group Shanxi Co Ltd
Original Assignee
China Mobile Communications Group Co Ltd
China Mobile Group Shanxi Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Mobile Communications Group Co Ltd, China Mobile Group Shanxi Co Ltd filed Critical China Mobile Communications Group Co Ltd
Priority to CN201711462192.8A priority Critical patent/CN109982143B/en
Publication of CN109982143A publication Critical patent/CN109982143A/en
Application granted granted Critical
Publication of CN109982143B publication Critical patent/CN109982143B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04NPICTORIAL COMMUNICATION, e.g. TELEVISION
    • H04N21/00Selective content distribution, e.g. interactive television or video on demand [VOD]
    • H04N21/40Client devices specifically adapted for the reception of or interaction with content, e.g. set-top-box [STB]; Operations thereof
    • H04N21/43Processing of content or additional data, e.g. demultiplexing additional data from a digital video stream; Elementary client operations, e.g. monitoring of home network or synchronising decoder's clock; Client middleware
    • H04N21/442Monitoring of processes or resources, e.g. detecting the failure of a recording device, monitoring the downstream bandwidth, the number of times a movie has been viewed, the storage space available from the internal hard disk
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04NPICTORIAL COMMUNICATION, e.g. TELEVISION
    • H04N21/00Selective content distribution, e.g. interactive television or video on demand [VOD]
    • H04N21/40Client devices specifically adapted for the reception of or interaction with content, e.g. set-top-box [STB]; Operations thereof
    • H04N21/43Processing of content or additional data, e.g. demultiplexing additional data from a digital video stream; Elementary client operations, e.g. monitoring of home network or synchronising decoder's clock; Client middleware
    • H04N21/442Monitoring of processes or resources, e.g. detecting the failure of a recording device, monitoring the downstream bandwidth, the number of times a movie has been viewed, the storage space available from the internal hard disk
    • H04N21/44213Monitoring of end-user related data
    • H04N21/44222Analytics of user selections, e.g. selection of programs or purchase activity
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04NPICTORIAL COMMUNICATION, e.g. TELEVISION
    • H04N21/00Selective content distribution, e.g. interactive television or video on demand [VOD]
    • H04N21/40Client devices specifically adapted for the reception of or interaction with content, e.g. set-top-box [STB]; Operations thereof
    • H04N21/45Management operations performed by the client for facilitating the reception of or the interaction with the content or administrating data related to the end-user or to the client device itself, e.g. learning user preferences for recommending movies, resolving scheduling conflicts
    • H04N21/4508Management of client data or end-user data

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Multimedia (AREA)
  • Signal Processing (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Social Psychology (AREA)
  • Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)

Abstract

The application provides a method, a device, a medium and equipment for determining video playing time delay, wherein the method comprises the following steps: 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. By the implementation mode for determining the video playing time delay, the video playing time delay with higher accuracy can be obtained.

Description

Method, device, medium and equipment for determining video playing time delay
Technical Field
The present application relates to the field of video playing technologies, and in particular, to a method, an apparatus, a medium, and a device for determining a video playing time delay.
Background
At present, more and more users watch videos through a mobile communication network, wherein a certain time delay is required from the time when a user clicks a video to be played to the time when the user formally starts to play the video, which is called video playing time delay, and the greater the video playing time delay is, the worse the experience of watching the video by the user is. Therefore, the mobile communication network operator may determine the video playing time delay of the user watching the video, and improve the experience of the user watching the video by reducing the video playing time delay as much as possible.
A common method for determining video playing delay of a user watching a video is as follows:
acquiring a signaling generated when a user watches a video; extracting a video watching request sent to a network side by a user from the signaling; extracting domain name resolution signaling and TCP connection signaling corresponding to the video viewing request from the extracted signaling; determining domain name resolution duration according to the domain name resolution signaling, and determining network connection duration according to the TCP connection signaling; determining the buffering time required by the video buffering to a set size according to the information such as the video downloading rate, the video code rate and the like; and taking the sum of the domain name resolution time, the network connection time and the buffering time as the video playing time delay.
The inventor finds that, because the calculation of the buffering duration needs to be based on the video code rate, and under many conditions, the video code rate is not carried in a signaling generated by a user watching a video, so that a technician needs to set the video code rate according to experience, an error between the artificially set video code rate and the actual video code rate is relatively large, and at this time, the problem that the accuracy of the finally calculated video playing delay is relatively low occurs.
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.
Drawings
Fig. 1 is a schematic flowchart of a method for determining video playing latency according to an embodiment of the present application;
fig. 2 is a schematic flowchart of a method for determining a selective play timestamp and a play start timestamp corresponding to a selective play identifier according to an embodiment of the present application;
fig. 3 is a schematic flowchart of a method for pre-storing the video playing fingerprint table according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an apparatus for determining video playing delay according to an embodiment of the present application;
fig. 5 is a schematic hardware structure diagram of a computing device according to an embodiment of the present application.
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.

Claims (8)

1. A method for determining video playback latency, comprising:
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;
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 be played and watch the video corresponding to the playing selection identifier;
the 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;
taking the selective playing time stamp in the extracted list item as the selective playing time stamp corresponding to the selective playing identifier, and taking the play starting time stamp in the extracted list item as the play starting time stamp corresponding to the selective playing identifier;
further, the video playing fingerprint table is pre-stored 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;
taking the timestamp in the first reference service record as a selective playing timestamp corresponding to a 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.
2. The method according to claim 1, wherein extracting the first reference service record and the second reference service record specifically comprises:
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 uniform resource locator 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.
3. The method according to any of claims 1-2, wherein after determining the video playing delay corresponding to the selected playing identifier, further comprising:
and deleting the list item to which the selected playing identifier belongs in the video playing fingerprint list.
4. An apparatus for determining video playback latency, comprising:
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;
a second determining module, 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;
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;
taking the selective playing time stamp in the extracted list item as the selective playing time stamp corresponding to the selective playing identifier, and taking the play starting time stamp in the extracted list item as the play starting time stamp corresponding to the selective playing identifier;
further, the method also comprises the following steps:
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;
taking the timestamp in the first reference service record as a selective playing timestamp corresponding to a 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.
5. The apparatus according to claim 4, wherein the storage module, when extracting the first reference service record and the second reference service record, 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 uniform resource locator 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.
6. The apparatus of any of claims 4-5, further comprising:
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.
7. A computer storage medium, characterized in that it stores an executable program which is executed by a processor to implement the steps of the method according to any one of claims 1 to 3.
8. A computing device comprising a memory, a processor and a computer program stored on the memory, the processor implementing the steps of the method of any of claims 1 to 3 when executing the program.
CN201711462192.8A 2017-12-28 2017-12-28 Method, device, medium and equipment for determining video playing time delay Active CN109982143B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711462192.8A CN109982143B (en) 2017-12-28 2017-12-28 Method, device, medium and equipment for determining video playing time delay

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711462192.8A CN109982143B (en) 2017-12-28 2017-12-28 Method, device, medium and equipment for determining video playing time delay

Publications (2)

Publication Number Publication Date
CN109982143A CN109982143A (en) 2019-07-05
CN109982143B true CN109982143B (en) 2021-04-23

Family

ID=67074871

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711462192.8A Active CN109982143B (en) 2017-12-28 2017-12-28 Method, device, medium and equipment for determining video playing time delay

Country Status (1)

Country Link
CN (1) CN109982143B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114554237B (en) * 2022-02-18 2023-12-26 北京有竹居网络技术有限公司 Information processing method, device and equipment

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101021888A (en) * 2007-03-20 2007-08-22 陆小潮 Monitoring device and method for digital multimedia content playing
CN203151681U (en) * 2013-01-21 2013-08-21 北京十分科技有限公司 Detection system for remote media playing signal time delay
CN103905881A (en) * 2014-03-13 2014-07-02 北京奇艺世纪科技有限公司 Video data and audio data synchronized playing method and device and equipment
CN103905879A (en) * 2014-03-13 2014-07-02 北京奇艺世纪科技有限公司 Video data and audio data synchronized playing method and device and equipment
CN106469388A (en) * 2015-08-18 2017-03-01 阿里巴巴集团控股有限公司 The implementation method of user comment and device
CN106792069A (en) * 2015-11-19 2017-05-31 北京国双科技有限公司 Method for broadcasting multimedia file and device
CN106899843A (en) * 2016-03-24 2017-06-27 ***通信集团设计院有限公司 A kind of video service quality appraisal procedure and device

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8149530B1 (en) * 2006-04-12 2012-04-03 Winview, Inc. Methodology for equalizing systemic latencies in television reception in connection with games of skill played in connection with live television programming
US8990673B2 (en) * 2008-05-30 2015-03-24 Nbcuniversal Media, Llc System and method for providing digital content

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101021888A (en) * 2007-03-20 2007-08-22 陆小潮 Monitoring device and method for digital multimedia content playing
CN203151681U (en) * 2013-01-21 2013-08-21 北京十分科技有限公司 Detection system for remote media playing signal time delay
CN103905881A (en) * 2014-03-13 2014-07-02 北京奇艺世纪科技有限公司 Video data and audio data synchronized playing method and device and equipment
CN103905879A (en) * 2014-03-13 2014-07-02 北京奇艺世纪科技有限公司 Video data and audio data synchronized playing method and device and equipment
CN106469388A (en) * 2015-08-18 2017-03-01 阿里巴巴集团控股有限公司 The implementation method of user comment and device
CN106792069A (en) * 2015-11-19 2017-05-31 北京国双科技有限公司 Method for broadcasting multimedia file and device
CN106899843A (en) * 2016-03-24 2017-06-27 ***通信集团设计院有限公司 A kind of video service quality appraisal procedure and device

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
《多媒体通信中的音视频同步问题研究》;刘可钊;《中国优秀硕士学位论文全文数据库》;20070615;全文 *

Also Published As

Publication number Publication date
CN109982143A (en) 2019-07-05

Similar Documents

Publication Publication Date Title
CN107679211B (en) Method and device for pushing information
CN108683952B (en) Video content segment pushing method and device based on interactive video
CN107885873B (en) Method and apparatus for outputting information
CN109309596B (en) Pressure testing method and device and server
CN111339171B (en) Data query method, device and equipment
CN109766176B (en) Scanning progress calculation method and device based on large-scale network space detection
CN105915956A (en) Video content recommendation method, device, server and system
CN109862100B (en) Method and device for pushing information
CN103997662A (en) Program pushing method and system
US20170169062A1 (en) Method and electronic device for recommending video
CN110674345A (en) Video searching method and device and server
CN109862376B (en) Live content delivery system, method and device, list server and storage medium
CN104853251A (en) Online collection method and device for multimedia data
CN111382182A (en) Data processing method and device, electronic equipment and storage medium
CN111970150A (en) Log information processing method, device, server and storage medium
CN109657164B (en) Method, device and storage medium for publishing message
CN109982143B (en) Method, device, medium and equipment for determining video playing time delay
CN113220684A (en) Data packet storage and query method, device, system and storage medium
CN104917754A (en) Video data sending and receiving methods, servers and clients
CN110909072B (en) Data table establishment method, device and equipment
CN109189810B (en) Query method, query device, electronic equipment and computer-readable storage medium
CN113473240B (en) Data processing method and device for live broadcasting room, electronic equipment and storage medium
CN106469166A (en) A kind of information processing method and device
CN110781191B (en) Processing method of layout data and server
CN112764988A (en) Data segmentation acquisition method and device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant