CN103581731B - The method and client of acquiring video information, server - Google Patents
The method and client of acquiring video information, server Download PDFInfo
- Publication number
- CN103581731B CN103581731B CN201210249556.5A CN201210249556A CN103581731B CN 103581731 B CN103581731 B CN 103581731B CN 201210249556 A CN201210249556 A CN 201210249556A CN 103581731 B CN103581731 B CN 103581731B
- Authority
- CN
- China
- Prior art keywords
- video
- information
- menu
- played
- list menu
- 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
Links
Landscapes
- Information Transfer Between Computers (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)
Abstract
The invention relates to a kind of method of acquiring video information and client, server.Methods described includes：Client transmission list menu request information, the list menu solicited message carry currently playing video labeling；The response message that the reception server returns according to the list menu solicited message, the response message includes the layout information of the list menu in currently playing video corresponding to the currently playing video labeling, and video information to be played corresponding with the currently playing video labeling；The list menu is laid out according to the layout information, and the video information to be played and the menu item of the list menu are associated, for receiving the video slicing information that the to be played video information of the server in the menu item issues, the corresponding video slicing of the video information to be played in the menu item is played.
Description
Technical field
The application is related to field of internet, more particularly to a kind of method of acquiring video information and client, server.
Background technology
At present, the lifting of network bandwidth causes video ads play-back technology gradually to grow up, video ads play-back technology
It is more directly perceived, true relative to the merchandise display of plane.
The implementation process of video ads play-back technology is that user opens a website client end, from client in the prior art
Commodity interested are searched out in end, click on the video ads of the commodity, broadcasting is watched, and wishes viewing and the business in user
, it is necessary to continue search in the client again during the video ads for other commodity that condition closes, other commodity of correlation are clicked on
Video ads, then play and watched, user need to carry out circulate operation, and then watch the video ads needed.
Solution described above, it is necessary to user need to repeat search, click on step after, just can watch the video of needs
Advertisement, largely repeating step can make user reduce the Experience Degree for watching video ads, produce user and be sick of, and
And waste the time of user；
Furthermore a kind of video ads of commodity are only existed in currently playing video ads, species is relatively single；
In addition, each video ads need administrative staff individually to be safeguarded, when video ads quantity is more, it is unfavorable for tieing up
The progress that nurse makees.
Above-mentioned condition causes existing video ads play-back technology many drawbacks to be present.How to find out can be conveniently and efficiently
User is set to watch video ads, and can expands the species of commodity video ads, facilitates administrative staff to safeguard that video ads are current
Key.
The content of the invention
The purpose of the application there is provided the method and client, server of a kind of acquiring video information, existing to solve
In technology video playback time fix, content it is dull, and video playback flexibility it is inadequate the problem of.
To achieve the above object, this application provides a kind of method of acquiring video information, this method to include：
Client transmission list menu request information, the list menu solicited message carry currently playing video labeling；
The response message that the reception server returns according to the list menu solicited message, the response message include institute
State the layout information of the list menu in currently playing video corresponding to currently playing video labeling, and with it is described currently playing
Video labeling video information to be played accordingly；
The list menu is laid out according to the layout information, and by the video information to be played and the row
The menu item of table menu is associated, for receiving the to be played video letter of the server in the menu item
The video slicing information issued is ceased, plays the corresponding video slicing of the video information to be played in the menu item.
Further, this application provides a kind of method of acquiring video information, this method to include：
Server receives the list menu solicited message that client is sent；
The currently playing video labeling carried according to the list menu solicited message, search the currently playing video mark
The layout information of list menu in currently playing video corresponding to knowledge, and corresponding with the currently playing video labeling wait to broadcast
Put video information；
Response message is sent to the client, and the response message includes the layout information and described to be played regarded
Frequency information, the layout of the list menu is carried out according to the layout information for the client, and wait to broadcast by described
Put video information and the menu item of the list menu is associated, and the institute of the menu item association is obtained from the server
State video slicing corresponding to video information to be played.
Correspondingly, this application provides a kind of client, the client to include：
Transmitting element, for transmission list menu request information, the list menu solicited message carries currently playing regard
Frequency marking is known；
Receiving unit, the response message returned for the reception server according to the list menu solicited message, the sound
Information is answered to include the layout information of the list menu in currently playing video corresponding to the currently playing video labeling, and
Video information to be played corresponding with the currently playing video labeling；
Processing unit, to be played regarded for being laid out the list menu according to the layout information, and by described
Frequency information and the menu item of the list menu are associated, for receiving institute of the server in the menu item
The video slicing information that video information to be played issues is stated, plays the correspondence of the video information to be played in the menu item
Video slicing.
Further, this application provides a kind of server, the server to include：
Receiving unit, for receiving the list menu solicited message of client transmission；
Searching unit, for the currently playing video labeling carried according to the list menu solicited message, described in lookup
The layout information of list menu in currently playing video corresponding to currently playing video labeling, and with the currently playing video
The corresponding video information to be played of mark；
Transmitting element, for sending response message to the client, the response message includes the layout information,
With the video information to be played, the layout for the client according to the layout information progress list menu,
And be associated the video information to be played and the menu item of the list menu, and from described in server acquisition
Video slicing corresponding to the video information to be played of menu item association.
Therefore, the application, which realizes, simply and easily obtains video information, by being regarded in the currently playing commodity of client
Embedded list menu in frequency, receive the menu item that user is clicked in list menu and instruct, switch in other commodity videos, by business
Product are combined with video, improve the flexibility of video playback, simplify the operation of user, meanwhile, the species of commodity video is also enriched,
Improve the interactivity with user.
Brief description of the drawings
Fig. 1 is the application system figure of the embodiment of the present application acquiring video information method；
Fig. 2 is the method flow diagram of the acquiring video information of the embodiment of the present application one；
Fig. 3 is the position view of the list menu of the embodiment of the present application one and menu item；
Fig. 4 is the position view of another list menu of the embodiment of the present application and menu item；
Fig. 5 is the method flow diagram of another acquiring video information of the embodiment of the present application；
Fig. 6 is the method flow that the embodiment of the present application server creates information attribute value table and Video Add-On information table
Figure；
Fig. 7 is the embodiment of the present application client terminal device figure；
Fig. 8 is the embodiment of the present application server unit figure.
Embodiment
Below by drawings and examples, the technical scheme of the embodiment of the present application is described in further detail.
The method of the application acquiring video information, client embedded list menu, connect in currently playing video pictures
The instruction that user touches list menu menu item is received, obtains video slicing corresponding with menu item to server, server will
Video slicing is issued in client, is got so as to realize corresponding to associated video, client corresponding to currently playing video
The instruction of menu item is touched according to user, other is switched to and corresponds in currently playing video interested video, so as to realize
The switching of video, commodity are combined with video, simplify the operation of user, mitigate the access pressures such as the search of commodity associated server
Power, improve the convenience with user mutual.
The application system framework of the application acquiring video information method is introduced first below, as shown in figure 1, the system includes
Client terminal and server.In client-side, it is prepared for playing any video, the interior of certain commodity correlation is related in the video
Hold, such as product placement or introduce the video of dependent merchandise, described to simplify, to introduce phase in the embodiment of the present application
Illustrated exemplified by the video of underlying commodity, but do not form the limitation to the protection domain of the application.User end to server is sent
List menu solicited message, the list menu solicited message carry currently playing video labeling, and server receives client
List menu solicited message after, response message is sent to client, may include to regard currently playing in the response message
Frequency marking know corresponding to list menu in currently playing video layout information, and corresponding with currently playing video labeling treat
Video information is played, client resolution response information, is laid out list menu according to the layout information, and will be to be played
The menu item of video information and list menu is associated；
Client completes the layout of list menu and is associated list menu menu item and video information to be played
Afterwards, the instruction of the request list menu menu item of user's input is received, according to the instruction, user end to server sends and regarded
The video slicing found is back to client by frequency division piece solicited message, server, and client is by the video slicing and user
The menu item association of touch, is stored in local memory, and prepare to play the video slicing.
During the client terminal playing video slicing, the video slicing is as currently playing video, also according to being retouched above
State, the embedded list menu in currently playing video so that user is efficiently switched to when watching current commodity video
In another commodity video.
The client terminal that video information is obtained in the application refers to have communication function, display function, input function
Terminal, such as smart mobile phone, tablet personal computer, television terminal etc.；Wherein, the input of smart mobile phone can pass through touch-screen or keyboard
Deng realization, the input of tablet personal computer can use touch-screen or mouse etc. to realize that the input of television terminal then can be by making
Realized with remote control.
The client can be the application journey for playing video in browser page, nested in broadcasting pictures in television terminal
Sequence, or can be the videoconference client of the advertisement video of independent broadcasting buyer's guide on tablet personal computer and smart mobile phone, example
Such as the various clients for being used to play advertisement video of the prior art.
The server of the application receives the list menu solicited message that client is sent, and preserves list menu in the server
Database and video management database are managed, what is stored in list menu manages database is list menu information, in video
What is stored in management database is video slicing, and server is according to the list menu solicited message of client in list menu management
In database, the layout information for the list menu inquired about in corresponding with currently playing video labeling currently playing video and wait to broadcast
Video information is put, server sends layout information and video information to be played to client, and finally, server is according to client
The video slicing solicited message sent is held in video management database, the video slicing of inquiry, and the video inquired is divided
Piece is sent to client.
What is preserved in list menu manages database is list menu information table, is stored in list menu information table
Information is as shown in table 1：
The list menu information table of table 1
| Field name | Field type | Fields function |
| ad_id | bigint | Current video id corresponding to menu |
| menu_id | bigint | Menu id |
| item_id | bigint | Menu item id |
| image_url | varchar(500) | Menu item picture url |
| video_id | bigint | Video id to be played corresponding to menu item |
| pos_x | bigint | The abscissa of the top left corner apex of menu area |
| pos_y | bigint | The ordinate of the top left corner apex of menu area |
| width | bigint | The width of menu area |
| height | bigint | The height of menu area |
| item_index | bigint | The position that menu item occurs in a menu |
In table 1, menu id (menu_id), menu item id (item_id), menu item picture url (image_url), dish
Ordinate (pos_y), the menu area of the abscissa (pos_x) of the top left corner apex in single region, the top left corner apex of menu area
The position (item_index) that the width (width) in domain, the height (height) of menu area and menu item occur in a menu
For the layout information for determining list menu position；Video information to be played in table 1, i.e. video_id, for for row
The menu item of table menu is associated；
What is preserved in video management database is burst information table, the information stored in burst information table such as institute of table 2
Show：
The burst information table of table 2
| Field name | Field type | Fields function |
| video_id | bigint | Video id to be played corresponding to menu item |
| slice_id | bigint | Burst id |
| url | varchar(500) | The url of burst |
Further, commodity information database is also preserved in the server, and what is preserved in commodity information database is
Information attribute value table and Video Add-On information table, the information stored in information attribute value table are as shown in table 3：
The information attribute value table of table 3
| Field name | Field type | Explanation of field |
| auction_id | bigint | Goods number id |
| propertu_id | bigint | Item property id |
| propertu_name | varchar(10000) | Item property title |
| propertu_value | varchar(10000) | Item property value |
The information stored in Video Add-On information table is as shown in table 4：
The Video Add-On information table of table 4
| Field name | Field type | Explanation of field |
| video_id | bigint | Video id to be played |
| auction_id | bigint | Commodity id |
| propertu_id | bigint | Item property id |
| propertu_name | varchar(10000) | Item property title |
| propertu_value | varchar(10000) | Item property value |
Server inquires about commodity letter according to video information to be played from information attribute value table and Video Add-On information table
Breath, merchandise news is sent to client when client initiates list menu solicited message, or subsequently initiated according to user
Query statement, directly merchandise news is sent to client.
It should be appreciated that list menu management database, video management database and merchandise news number described above
Types of databases can be also established according to storehouse in same server, certainly in different servers.
Corresponding explanation is made that to client, server respectively in following specific embodiment part.
As shown in Fig. 2 it is the method flow diagram of the application acquiring video information.In the present embodiment, executive agent is
Client.In the present embodiment, client can perform following steps：
Step 210, client transmission list menu request information, the list menu solicited message carry currently playing regard
Frequency marking is known；
Specifically, for example, user opens the page of the e-commerce website of user terminal, client is opened by browser
The application program of video is played, plays the video of any buyer's guide in the page.In client, it is prepared for playing any
The video of commodity is introduced, during the video buffer, client is voluntarily to server transmission list menu request information, institute
It is ad_id to state currently playing video labeling, and client utilizes communication module to server transmission list menu request information, in institute
State in list menu solicited message and carry ad_id.
The response message that step 220, client the reception server return according to the list menu solicited message, the sound
Information is answered to include the layout information of the list menu in currently playing video corresponding to the currently playing video labeling, and
Video information to be played corresponding with the currently playing video labeling；
Specifically, after server receives the list menu solicited message that client is sent, according to list menu solicited message
The ad_id of carrying, the list menu inquired about in list menu manages database in currently playing video corresponding with ad_id
Layout information, and video information to be played corresponding with currently playing video labeling, the video information to be played are video_
id；
Server inquires the list menu in currently playing video corresponding with ad_id from list menu information table
Layout information, server also inquired from list menu information table to ad_id corresponding to related video information to be played
Layout information and video_id are carried in response message, response message are sent to client by video_id, server.
The list menu is laid out by step 230, client according to the layout information, and to be played is regarded described
Frequency information and the menu item of the list menu are associated, for receiving institute of the server in the menu item
The video slicing information that video information to be played issues is stated, plays the correspondence of the video information to be played in the menu item
Video slicing.
Specifically, after client receives the response message of server transmission, response message is parsed, obtains layout
Information and video_id, client parse to layout information, determine list menu and menu item in currently playing video
Position and display, as shown in Figure 3 and Figure 4.
As shown in figure 3, in currently playing video pictures, list menu is be disposed across currently playing video pictures upper
Portion, shows four menu items in list menu, and the pattern of each menu item is different；As shown in figure 4, currently playing
In video pictures, list menu is placed vertically on the right side of currently playing video pictures, and four menus are shown in list menu
, the pattern of each menu item is different.It should be appreciated that in the embodiment of the present application only with Fig. 3 and Fig. 4 shown in row
Illustrated exemplified by the position of table menu, in actual applications, be not restricted to this.
After client obtains video_id corresponding with ad_id, the menu item of video_id and list menu is closed
Connection, such as the menu item of list menu in Fig. 3 or Fig. 4, client is that each menu item assigns a video_id, it is necessary to explanation
It is the video_id of the above-mentioned imparting to menu item, is the consistency operation of client, is user not to be shown.
According to described above, client determines the position of list menu in currently playing video, and video_id with
After the menu item of list menu is associated, client receives the instruction of the request list menu menu item of user's input, institute
It can be click or touching instruction to state request instruction, and client receives the request instruction of user's input；
After client receives the instruction of user's input, specify user and wish to want the video for watching the menu item, client to
Server sends the solicited message of video slicing, and it is corresponding that list menu menu item is carried in the video slicing solicited message
Video information to be played, i.e. video_id.
After server receives video_id video slicing solicited message corresponding to the carrying menu item that client is sent,
In burst information table in video management database, video slicing corresponding with video_id is inquired about；
Server is inquired about from burst information table corresponding with video_id according to the video_id that client is sent
Slice_id information and url information, and the slice_id information found and url information are carried in video slicing, send
To client；
It is after the video slicing that client the reception server is sent, video slicing is corresponding with list menu menu item
Video_id is associated, and is stored.
Further, when client receives video slicing and by its video_id corresponding with list menu menu item
After associated, the click or instruction of client executing user input, i.e., the video that current video is switched to server transmission divide
Piece, prepare to play；
Therefore, after by above-mentioned means, the commodity of the related introductory video are embedded in video pictures to be played
Some other commodity video, so as to facilitate user using menu item come select wish watch other associated videos, without
The same video of viewing in set time, meanwhile, embedded some other commodity video, also enrich type of merchandize.
After what client the reception server was sent meets the list menu information of video to be played, parsing list menu letter
Breath, repeat step 210 to step 230 play next video to be played.
Further, server in the response message sent to client except carrying layout information and video_id
Outside, can also carry merchandise news, merchandise news can be server from the information attribute value table in commodity information database and
Obtained in Video Add-On information table.Therefore, client is after resolution response information, obtains merchandise news, the merchandise news with
Menu item in list menu is corresponding, after list menu is laid out by client according to layout information, after obtaining merchandise news,
Merchandise news and each menu item in list menu are associated, in the inquiry menu for user's input that client receives
During the instruction of item, client shows merchandise news corresponding to the menu item, and the merchandise news includes goods number, item property
Information；
Or after the instruction of the inquiry menu item for user's input that client receives, it is defeated to send user to server
The instruction of the inquiry menu item entered, the query statement include video_id corresponding to menu item, and server is according to video_
Id inquires about business corresponding with video_id from the information attribute value table and Video Add-On information table in commodity information database
Product information, the merchandise news includes goods number, information attribute value, and the merchandise news inquired is sent to client
End, the merchandise news that client the reception server inquires according to video_id are corresponding with video_id by the merchandise news
Menu item associates, and shows merchandise news corresponding to menu item.
Further, described video information to be played is video_id in a step 220, in addition the video to be played
Information can also be video slicing, i.e., server is after the list menu solicited message that client is sent is received, in list menu pipe
Inquiry video_id corresponding with ad_id in the list menu information table in database is managed, after inquiring video_id, and according to
Inquiry is for video slicing corresponding to video_id in burst information tables of the video_id in video management database, for visitor
The menu item of video slicing and list menu is associated by family end, and layout information and video slicing are carried and responded by server
In information, response message is sent to client.
Therefore, the method for the acquisition video information provided using the embodiment of the present application, by currently playing in client
Embedded list menu in commodity video, receive the menu item that user is clicked in list menu and instruct, switch to other commodity videos
In, commodity are combined with video, improve the flexibility of video playback, simplify the operation of user, meanwhile, also enrich commodity video
Species, improve the interactivity with user.
Below by drawings and examples, the technical scheme of the embodiment of the present application is described in further detail.
As shown in figure 5, it is the method flow diagram of the application acquiring video information.In the present embodiment, executive agent is
Server.In the present embodiment, server can perform following steps：
Step 510, server receive the list menu solicited message that client is sent；
Specifically, in client, it is prepared for playing any video for introducing commodity, can be in the video buffer process
In, client is voluntarily to server transmission list menu request information, and the currently playing video labeling is ad_id, client
Using communication module to server transmission list menu request information, ad_id is carried in the list menu solicited message；Clothes
Business device receives the list menu solicited message that client is sent, and parses the list menu solicited message and obtains ad_id.
The currently playing video labeling that step 520, server carry according to the list menu solicited message, described in lookup
The layout information of list menu in currently playing video corresponding to currently playing video labeling, and currently playing regarded with described
Frequency marking knows corresponding video information to be played；
Specifically, after server receives the list menu solicited message that client is sent, according to the ad_id of acquisition, arranging
The cloth for being used to determine list menu position corresponding with ad_id is inquired about in list menu information table in table menu management data storehouse
Office's information, and video information to be played corresponding with ad_id, i.e. video_id, in the list menu manages database
A list menu information table has been stored, as shown in table 1, and corresponding information has been stored in list menu information table；
Server inquires the layout for being used to determine list menu position corresponding with ad_id from list menu information table
Information, such as pos_x, pos_y, width, height information, this kind of layout information is used for position and the size for determining list menu,
Such as menu_id information, item_id information, item_index information and image_url information, this kind of layout information is used to determine
The position of any menu item in list menu；
Server also inquires video information to be played corresponding with ad_id, such as video_ from list menu information table
Id, server also carry video_id in response message, for client by video_id and the menu item of list menu
It is associated.
Step 530, server send response message to the client, and the response message includes the layout letter
Breath, and the video information to be played, the cloth of the list menu is carried out according to the layout information for the client
Office, and the video information to be played and the menu item of the list menu are associated, obtain institute from the server
State video slicing corresponding to the video information to be played of menu item association.
Specifically, layout information and video_id are carried in response message according to the inquiry of step 520, server,
Response message is sent to client；
After client receives the response message that the server is sent, what resolution response acquisition of information response message carried
Layout information and video_id；Client parses to layout information, determines the position of list menu and menu item, and shows
Show, as shown in Figure 3 and Figure 4,
It should be appreciated that only carried out in the embodiment of the present application by taking the position of the list menu shown in Fig. 3 and Fig. 4 as an example
Illustrate, in actual applications, do not limit and this；
After client obtains the video_id related to ad_id, the menu item of video_id and list menu is closed
Connection, such as the menu item of list menu in Fig. 3 or Fig. 4, client is that each menu item assigns a video_id, it is necessary to explanation
It is the video_id of the above-mentioned imparting to menu item, is the consistency operation of client, is user not to be shown；Therefore, pass through
After above-mentioned means, some other commodity video of the commodity of the related introductory video is embedded in video pictures to be played,
It is same without being watched within the set time so as to facilitate user using menu item to select to wish the other associated videos watched
Video, meanwhile, embedded some other commodity video, also enrich type of merchandize.
Alternatively, before step 510, server can also carry out creates information attribute value table in commodity information database
With Video Add-On information table step；
Specifically, server receives the establishment information of user's input, according to information is created, is created in commodity information database
Construction company's product attribute information table and Video Add-On information table, what is stored in the information attribute value table is goods number and commodity category
Property information, what is stored in the Video Add-On information table is goods number, advertisement video information to be played, i.e. video_id and business
Product attribute information；Server establishes binary associated groups of the video_id with the corresponding goods number；Compiled according to the commodity
Number, the information attribute value corresponding with goods number is inquired about from the information attribute value table of foundation；By inquiry and commodity
Number corresponding information attribute value to be associated with the binary associated group, establish item property associated group；The commodity category
Property associated group formed one record, be stored in the Video Add-On information table of foundation.
Alternatively, in step 530, in the response message that server is sent to client, merchandise news can be also carried, is had
Body, server is voluntarily inquired about and video_id according to video_id from the Video Add-On information table in commodity information database
The merchandise news matched somebody with somebody, the merchandise news include goods number, information attribute value, and server lookup goes out to be matched with video_id
Merchandise news after, merchandise news is also carried along in response message, send to client；
Or after the instruction of the inquiry menu item for user's input that client receives, it is defeated to send user to server
The instruction of the inquiry menu item entered, the query statement include video_id corresponding to menu item, and server is according to video_
Id inquires about business corresponding with video_id from the information attribute value table and Video Add-On information table in commodity information database
Product information, the merchandise news includes goods number, information attribute value, and the merchandise news inquired is sent to client
End, the merchandise news that client the reception server inquires according to video_id are corresponding with video_id by the merchandise news
Menu item associates, and shows merchandise news corresponding to menu item.
Alternatively, after step 530, server, which can also carry out, receives corresponding to the carrying menu item that client is sent
Video_id video slicing solicited message, according to burst information table of the video slicing solicited message in video management database
The step of middle inquiry video slicing；
Specifically, after client receives click or the touching instruction of user's input, specify user and wish to want to watch the menu
The video of item, user end to server send the solicited message of video slicing, and row are carried in the video slicing solicited message
Video information to be played, i.e. video_id corresponding to table menu menu item；
Server receive client send carry menu item corresponding to video_id video slicing solicited message, regarding
In the burst information table of frequency management database, video slicing corresponding with video_id is inquired about.In the video management database
In stored a burst information table, as shown in table 2；
Server inquires about corresponding with video_id slice_id information and url information according to video_id from table 2, and
The slice_id information found and url information are carried in video slicing, sent to client；
It is after the video slicing that client the reception server is sent, video slicing is corresponding with list menu menu item
Video_id is associated, and plays out.
It should be understood that also need to be embedded in corresponding list menu in video pictures to be played so that user is according to certainly
Oneself demand Switch Video again, therefore, server, will be from list menu information after video slicing information is sent to client
Inquiry meets the ad_id and video_id of video to be played list menu information in table, sends to client；
After what client the reception server was sent meets the list menu information of video to be played, parsing list menu letter
Breath, repeat step 210 to step 230 play next video to be played, and server repeats step 510 to step 530.
Further, described video information to be played is video_id in step 520, the video information to be played
Can also be video slicing, i.e. server manages number after the list menu solicited message that client is sent is received, in list menu
According to inquiring about video_id corresponding with ad_id in the list menu information table in storehouse, after inquiring video_id, and voluntarily basis
Video_id inquires video slicing corresponding with video_id in the burst information table of video management database, for client
The menu item of video slicing and list menu is associated by end, and server carries layout information and video slicing to be believed in response
In breath, response message is sent to client.
Therefore, the method for the acquisition video information provided using the embodiment of the present application, by inquiring about in the server with working as
The corresponding list menu of commodity video of preceding broadcasting, by the currently playing commodity video of list menu value embedded, receive user
The menu item instruction in list menu is clicked on, switches in other commodity videos, commodity is combined with video, video is improved and broadcasts
The flexibility put, simplify the operation of user, meanwhile, the species of commodity video is also enriched, improves the interactivity with user.
Below by drawings and examples, to server in the technical scheme of the embodiment of the present application in commodity information database
The step of middle establishment information attribute value table and Video Add-On information table, is described in further detail.
As shown in fig. 6, it is the application server creates information attribute value table and video in commodity information database
The method flow diagram of additional information table, in the present embodiment, executive agent are server.In the present embodiment, server can be with
Perform following steps：
Step 610, server establish information attribute value table in commodity information database；
Specifically, server establishes information attribute value table in commodity information database, defines the field in table, such as table
Shown in 3,
The information attribute value table is made up of several information attribute value items；Described information attribute value item, bag
Include：Commodity id (goods number), item property id, item property title, item property value.That is, the item property
Information table reflects item property id, item property title, the corresponding relation of item property value.Wherein commodity id and remaining four
Individual field is one-to-many relation, is, and a commodity can correspond to multiple item properties.The item property can be commodity
The possible merchandise news interested of the users such as title, commodity price, commodity brief introduction, the commodity place of production.
Step 620, server establish Video Add-On information table in commodity information database；
Specifically, server establishes information attribute value table in commodity information database, defines the field in table, such as table
Shown in 4,
Video Add-On information table by several Video Add-On groups of information items into；Described Video Add-On item of information, including：
Video_id, commodity id, item property id, item property title, item property value.
Step 630, server are stored in record into information attribute value table；
Specifically, after the completion of information attribute value table is established, the modes such as user's typing, batch importing are received by multiple commodity
In information deposit information attribute value table.
Step 640, server are stored in record into Video Add-On information table；
Specifically, after the completion of Video Add-On information table is established, server is the corresponding record of Video Add-On information table deposit,
Server establishes video_id and auction_id corresponding in information attribute value table in Video Add-On information table, and (commodity are compiled
Number) binary associated group, (video_id, auction_id)；According to auction_id, from information attribute value table inquiry with
Information attribute value corresponding auction_id, that is, inquire about propertu_id information, propertu_name information and
Propertu_value information；The each information attribute value corresponding with auction_id of inquiry is closed with the binary established
Connection group is associated, associate field auction_id, establish item property associated group (video_id, auction_id,
Propertu_id, propertu_name, propertu_value)；The item property associated group is stored in the video
In additional information table, i.e., the synchronizing information that will store in the information stored in information attribute value table and Video Add-On information table；
It should be noted that in the embodiment of the present application, by taking SQL database as an example, commodity category is established in SQL database
Property information table and Video Add-On information table, in actual applications, be not restricted to this, also other kinds of database can be used to create
Construction company's product attribute information table and Video Add-On information table.Such as xml databases, oracle database, mysql different database
System.
For example, the information attribute value table established in xml databases is specially information attribute value file, such as
Properties.xml, the Video Add-On information table of foundation are specially that video is reestablished diplomatic relations message file, such as additional_
infos.xml；
Thus, the process of information attribute value table is established in xml databases, that is, creates properties.xml,
The xml document only includes a node properties, and the node does not include any child node, and particular content is as follows：
<properties>
</properties>
The process of information attribute value file is established in xml databases, that is, creates additional_
Infos.xml, the xml document only includes a node i nfos, and the node does not include any child node, and content is as follows：
<infos>
</infos>
Information is inserted into information attribute value file, can be set about to properties.xml properties nodes
The dynamic one or more property nodes of addition, content are as follows：
Wherein, property nodes include 4 child node auction_id, property_id, property_name,
Property_value, distinguish 4 field commodity id (goods number), item property id, business in corresponding goods property file
Product Property Name, item property value.
The process that record is inserted into Video Add-On message file is as follows：
Server is established in Video Add-On message file corresponding in video_id and information attribute value file
Auction_id (goods number) binary associated group, (video_id, auction_id)；According to atuction_id, from commodity
The inquiry information attribute value corresponding with auction_id in attribute information file, i.e. inquiry propertu_id information,
Propertu_name information and propertu_value information；By each commodity category corresponding with auction_id of inquiry
Property information and establish binary associated group be associated, associate field auction_id, establish item property associated group
(video_id, auction_id, propertu_id, propertu_name, propertu_value)；By the item property
Associated group is stored in the Video Add-On message file, i.e., the information and Video Add-On that will be stored in information attribute value file
The synchronizing information stored in message file；The infos.xml files of one info node are as follows：
List menu management database, video management database are stored in the above embodiments of the present application, in server
And commodity information database, corresponding tables of data is stored again in database, in actual applications, can also be by database purchase
In different servers, client obtains information into different servers.
Correspondingly, disclosed herein as well is a kind of client, it can be realized and be obtained in video information using the client, such as
Shown in Fig. 7, the client includes：Transmitting element 710, receiving unit 720 and processing unit 730；
Transmitting element 710 in the client, for transmission list menu request information, the list menu solicited message
Carry currently playing video labeling；
Receiving unit 720, the response message returned for the reception server according to the list menu solicited message are described
It is included in the layout information of the list menu in currently playing video corresponding to the currently playing video labeling in response message,
The corresponding video information to be played with the currently playing video labeling；
Processing unit 730, for the list menu to be laid out according to the layout information, and will be described to be played
Video information and the menu item of the list menu are associated, for receiving the server according in the menu item
The video slicing information that the video information to be played issues, play pair of the video information to be played in the menu item
The video slicing answered.
Also include merchandise news in the response message, the processing unit is further used for：By the merchandise news
It is associated with the menu item in the list menu；
The instruction of the inquiry menu item inputted according to the user received, shows that commodity corresponding to the menu item are believed
Breath, the merchandise news include goods number and information attribute value.
Alternatively, receiving unit in the client, it is additionally operable to receive in the request list menu that user inputs
The instruction of the menu item；
Transmitting element, it is additionally operable to send video slicing solicited message, the video slicing solicited message to the server
The video information to be played of the middle menu item association carried in the list menu；
Receiving unit, it is further used for receiving the video point that the server is found according to the video information to be played
Piece, the video slicing is corresponding with the video information to be played that the menu item in the list menu associates,
And store.
Alternatively, in the client：Transmitting element, the menu item for being further used to send user's input are looked into
Instruction is ask, the query statement includes the video information to be played of the menu item association；
Receiving unit, further it is used to receive the commodity that the server inquires according to the video information to be played
Information, and merchandise news corresponding to the menu item is shown, the merchandise news includes goods number and information attribute value.
Therefore, the client provided using the embodiment of the present application, by embedding in the currently playing commodity video of client
Enter list menu, receive the menu item that user is clicked in list menu and instruct, switch in other commodity videos, by commodity with regarding
Frequency combines, and improves the flexibility of video playback, simplifies the operation of user, meanwhile, the species of commodity video is also enriched, is improved
With the interactivity of user.
Correspondingly, disclosed herein as well is a kind of server, it can be realized and be obtained in video information using the server, such as
Shown in Fig. 8, the server includes：Receiving unit 810, query unit 820 and transmitting element 830.
Receiving unit 810 in the server, for receiving the list menu solicited message of client transmission；
Query unit 820, for the currently playing video labeling carried according to the list menu solicited message, search institute
State the layout information of the list menu in currently playing video corresponding to currently playing video labeling, and currently playing regarded with described
Frequency marking knows corresponding video information to be played；
Transmitting element 830, for sending response message to the client, the response message includes the layout letter
Breath, and the video information to be played, the cloth of the list menu is carried out according to the layout information for the client
Office, and the video information to be played and the menu item of the list menu are associated, obtain institute from the server
State video slicing corresponding to the video information to be played of menu item association.
Also include merchandise news in the response message, the merchandise news includes goods number and information attribute value.
Alternatively, receiving unit in the server, it is additionally operable to receive the video slicing request letter that the client is sent
Breath；
Query unit in the server, it is additionally operable to the list menu carried according to the video slicing solicited message
In the menu item association the video information to be played, search video slicing；
Transmitting element in the server, it is additionally operable to send the video slicing found to the client.
Alternatively, receiving unit in the server, it is further used for receiving the menu item that the client is sent
Query statement；
Query unit, the video letter to be played that the menu item for being additionally operable to be carried according to the query statement associates
Breath, inquires about merchandise news corresponding to the menu item, the commodity from the Video Add-On information table in commodity information database
Information includes goods number and information attribute value；
Transmitting element, it is further used for sending the merchandise news inquired to the client.
Alternatively, receiving unit in the server, further it is used for the establishment information for receiving user's input；
The server also includes：Unit 840 is established, for according to the establishment information, in the information of goods information data
Information attribute value table and Video Add-On information table, the information attribute value table are created in storehouse includes goods number and commodity
Attribute information, the Video Add-On information table include goods number and video information to be played；
The unit of establishing is further used for establishing the video information to be played and the two of the corresponding goods number
First associated group；
According to the goods number, the item property corresponding with goods number is inquired about from the information attribute value table
Information；
Inquiry information attribute value corresponding with goods number is associated with the binary associated group, established
Item property associated group；
The item property associated group is stored in the Video Add-On information table.
Therefore, the server provided using the embodiment of the present application, by inquiring about in the server and currently playing commodity
The corresponding list menu of video, list menu is clicked on by user in the currently playing commodity video of list menu value embedded, is received
In menu item instruction, switch in other commodity videos, commodity combined with video, improve the flexibility of video playback,
Simplify the operation of user, meanwhile, the species of commodity video is also enriched, improves the interactivity with user.
Professional should further appreciate that, each example described with reference to the embodiments described herein
Unit and algorithm steps, it can be realized with electronic hardware, computer software or the combination of the two, it is hard in order to clearly demonstrate
The interchangeability of part and software, the composition and step of each example are generally described according to function in the above description.
These functions are performed with hardware or software mode actually, application-specific and design constraint depending on technical scheme.
Professional and technical personnel can realize described function using distinct methods to each specific application, but this realization
It is not considered that exceed scope of the present application.
The method that is described with reference to the embodiments described herein can use hardware, computing device the step of algorithm
Software module, or the two combination are implemented.Software module can be placed in random access memory (RAM), internal memory, read-only storage
(ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technical field
In any other form of storage medium well known to interior.
Above-described embodiment, the purpose, technical scheme and beneficial effect of the application are carried out further
Describe in detail, should be understood that the embodiment that the foregoing is only the application, be not used to limit the application
Protection domain, all any modification, equivalent substitution and improvements within spirit herein and principle, done etc., all should include
Within the protection domain of the application.
Claims (12)
- A kind of 1. method of acquiring video information, it is characterised in that methods described includes：Client transmission list menu request information, the list menu solicited message carries currently playing video labeling, described Currently playing video labeling is used for the currently playing video labeling carried for server according to the list menu solicited message, It is stored in the list menu database of server and searches in currently playing video corresponding to the currently playing video labeling The layout information of list menu, and video information to be played corresponding with the currently playing video labeling；The current video For introducing commodity or being related to the commodity；The video information to be played includes other commodity video informations of the commodity, Or/and the commodity video information of other commodity；The response message that the reception server returns according to the list menu solicited message, the response message include the cloth Office's information and the video information to be played；The list menu is laid out according to the layout information, and by the video information to be played and the list dish Single menu item is associated, for receiving under the video information to be played of the server in the menu item The video slicing information of hair, play the corresponding video slicing of the video information to be played in the menu item；Wherein, menu in position of the layout information including the list menu, size layout information and the list menu The location layout information of item.
- 2. the method for acquiring video information according to claim 1, it is characterised in that methods described also includes：Receive the instruction of the menu item in the request list menu of user's input；Video slicing solicited message is sent to the server, is carried in the video slicing solicited message in the list menu The menu item association the video information to be played；Receive the video slicing that the server is found according to the video information to be played, by the video slicing with it is described The video information to be played of menu item association in list menu is corresponding, and stores.
- 3. the method for acquiring video information according to claim 1, it is characterised in that also include business in the response message Product information, after the list menu is laid out, in addition to：The merchandise news and the menu item in the list menu are associated；The instruction of the inquiry menu item inputted according to the user received, shows merchandise news corresponding to the menu item, The merchandise news includes goods number and information attribute value.
- 4. the method for acquiring video information according to claim 3, it is characterised in that methods described also includes：Send and use The query statement of the menu item of family input, the query statement include the video to be played of the menu item association Information；The merchandise news that the server inquires according to the video information to be played is received, and shows that the menu item is corresponding Merchandise news, the merchandise news includes goods number and information attribute value.
- A kind of 5. method of acquiring video information, it is characterised in that methods described includes：Server receives the list menu solicited message that client is sent；The currently playing video labeling carried according to the list menu solicited message, is being stored in the list menu number of server According to the layout information that the list menu in currently playing video corresponding to the currently playing video labeling is searched in storehouse, and with institute Currently playing video labeling video information to be played accordingly is stated, the current video is used to introduce commodity or is related to the business Product, the video information to be played include other commodity video informations of the commodity, or/and the commodity video letter of other commodity Breath；Response message is sent to the client, the response message includes the layout information and the video letter to be played Breath, carries out the layout of the list menu for the client according to the layout information, and to be played is regarded described Frequency information and the menu item of the list menu are associated, and are obtained from the server and treated described in the menu item association Play video slicing corresponding to video information；Wherein, menu in position of the layout information including the list menu, size layout information and the list menu The location layout information of item.
- 6. the method for acquiring video information according to claim 5, it is characterised in that methods described also includes：Receive the video slicing solicited message that the client is sent；The menu item in the list menu carried according to the video slicing solicited message associates described to be played Video information, search video slicing；The video slicing found is sent to the client.
- 7. the method for acquiring video information according to claim 5, it is characterised in that also include business in the response message Product information, the merchandise news include goods number and information attribute value.
- 8. the method for acquiring video information according to claim 7, it is characterised in that methods described also includes：Receive the query statement for the menu item that the client is sent；The video information to be played that the menu item carried according to the query statement associates, from commodity information database In information attribute value table and Video Add-On information table in inquire about merchandise news corresponding to the menu item, the merchandise news Including goods number and information attribute value；The merchandise news inquired is sent to the client.
- 9. the method for acquiring video information according to claim 5, it is characterised in that the row for receiving client and sending Also include before table menu request information：Receive the establishment information of user's input；According to the establishment information, information attribute value table and Video Add-On information table, institute are created in commodity information database Stating information attribute value table includes goods number and information attribute value, and the Video Add-On information table includes goods number With video information to be played.
- 10. the method for acquiring video information according to claim 9, it is characterised in that described to create the Video Add-On Information table is specially：Establish binary associated group of the video information to be played with the corresponding goods number；According to the goods number, the item property letter corresponding with goods number is inquired about from the information attribute value table Breath；The inquiry information attribute value corresponding with the goods number is associated with the binary associated group, Establish item property associated group；The record that the item property associated group is formed in the Video Add-On information table.
- 11. a kind of client, it is characterised in that the client includes：Transmitting element, for transmission list menu request information, the list menu solicited message carries currently playing video mark Know, the currently playing video labeling is used for the currently playing video carried for server according to the list menu solicited message Mark, searches currently playing corresponding to the currently playing video labeling regard in the list menu database for being stored in server The layout information of list menu in frequency, and video information to be played corresponding with the currently playing video labeling；It is described to work as Preceding video is used to introduce commodity or is related to the commodity；The video information to be played includes other commodity videos of the commodity Information, or/and the commodity video information of other commodity；Receiving unit, the response message returned for the reception server according to the list menu solicited message, the response letter Breath includes the layout information and the video information to be played；Processing unit, believe for being laid out the list menu according to the layout information, and by the video to be played Cease and be associated with the menu item of the list menu, treated for receiving the server according in the menu item The video slicing information that video information issues is played, the corresponding of video information to be played played in the menu item regards Frequency division piece；Wherein, menu in position of the layout information including the list menu, size layout information and the list menu The location layout information of item.
- 12. a kind of server, it is characterised in that the server includes：Receiving unit, for receiving the list menu solicited message of client transmission；Searching unit, for the currently playing video labeling carried according to the list menu solicited message, it is being stored in service The list menu in currently playing video corresponding to the currently playing video labeling is searched in the list menu database of device Layout information, and video information to be played corresponding with the currently playing video labeling, the current video are used to introduce business Product are related to the commodity, and the video information to be played includes other commodity video informations of the commodity, or/and other business The commodity video information of product；Transmitting element, for sending response message to the client, the response message includes the layout information, and institute Video information to be played is stated, carries out the layout of the list menu according to the layout information for the client, and The video information to be played and the menu item of the list menu are associated, and the menu is obtained from the server Video slicing corresponding to the video information to be played of item association；Wherein, menu in position of the layout information including the list menu, size layout information and the list menu The location layout information of item.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210249556.5A CN103581731B (en) | 2012-07-18 | 2012-07-18 | The method and client of acquiring video information, server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210249556.5A CN103581731B (en) | 2012-07-18 | 2012-07-18 | The method and client of acquiring video information, server |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103581731A CN103581731A (en) | 2014-02-12 |
| CN103581731B true CN103581731B (en) | 2018-01-19 |
Family
ID=50052498
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210249556.5A Active CN103581731B (en) | 2012-07-18 | 2012-07-18 | The method and client of acquiring video information, server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103581731B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104639599B (en) * | 2014-08-26 | 2019-02-26 | 中国直升机设计研究所 | A kind of system and method for realizing files in batch downloading |
| US9510036B1 (en) * | 2015-10-26 | 2016-11-29 | Google Inc. | Systems and methods for providing content in a content list |
| US20170127150A1 (en) * | 2015-11-04 | 2017-05-04 | Ubitus Inc. | Interactive applications implemented in video streams |
| CN109145232B (en) * | 2018-08-06 | 2022-07-19 | 融信惟康（北京）科技发展有限公司 | Method of processing identification tag, electronic device, and computer-readable storage medium |
| CN109474846A (en) * | 2018-12-07 | 2019-03-15 | 百度在线网络技术（北京）有限公司 | Video ads playback method, device, equipment and computer-readable medium |
| CN115086734A (en) * | 2021-03-12 | 2022-09-20 | 北京字节跳动网络技术有限公司 | Information display method, device, equipment and medium based on video |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2009036664A1 (en) * | 2007-09-18 | 2009-03-26 | Shenzhen Coship Electronics Co., Ltd. | A method and a system for replaying the living broadcast program |
| WO2009116034A2 (en) * | 2008-03-19 | 2009-09-24 | Qoof Ltd. | Video e-commerce |
| CN101681355A (en) * | 2007-05-02 | 2010-03-24 | 谷歌公司 | Animated video overlay |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4661047B2 (en) * | 2003-05-30 | 2011-03-30 | ソニー株式会社 | Information processing apparatus, information processing method, and computer program |
| CN101272475B (en) * | 2007-03-23 | 2010-07-21 | 百视通网络电视技术发展有限责任公司 | Channel switching method under video broadcasting condition suitable for IPTV |
| CN101335855B (en) * | 2008-07-25 | 2012-09-05 | 宝利微电子***控股公司 | Unified electronic program list making method |
| CN102301736A (en) * | 2011-07-06 | 2011-12-28 | 华为技术有限公司 | Method, device and mobile terminal for switching video display contents |
| CN102521765B (en) * | 2011-12-08 | 2016-04-27 | 深圳市同洲电子股份有限公司 | The method, system and device of merchandise news are provided in CHINA RFTCOM Co Ltd |
-
2012
- 2012-07-18 CN CN201210249556.5A patent/CN103581731B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101681355A (en) * | 2007-05-02 | 2010-03-24 | 谷歌公司 | Animated video overlay |
| WO2009036664A1 (en) * | 2007-09-18 | 2009-03-26 | Shenzhen Coship Electronics Co., Ltd. | A method and a system for replaying the living broadcast program |
| WO2009116034A2 (en) * | 2008-03-19 | 2009-09-24 | Qoof Ltd. | Video e-commerce |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103581731A (en) | 2014-02-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103581731B (en) | The method and client of acquiring video information, server | |
| US9672286B2 (en) | Singular, collective and automated creation of a media guide for online content | |
| US20240086478A1 (en) | Trust network effect | |
| US20080059989A1 (en) | Methods and systems for providing media assets over a network | |
| CN104980809A (en) | Barrage processing method and apparatus | |
| US9712879B2 (en) | Information processing apparatus, information processing method, and information processing program | |
| CN103873928A (en) | Method, device and application server for playing video | |
| CN106934053A (en) | A kind of information recommendation method and device | |
| Kayaalp et al. | A collaborative and content based event recommendation system integrated with data collection scrapers and services at a social networking site | |
| JP2005006203A (en) | Information accessing method, information providing device, meta information providing device, information receiver and information accessing method | |
| CN106202282A (en) | Multi-media network shopping guidance system | |
| JP2004348554A (en) | Retrieval keyword information providing device, method, and program for same | |
| JP2002014997A (en) | Method and system for distribution of advertisement information | |
| CN104184824B (en) | Mobile phone newspaper customizes and the device and method of push | |
| Kayaalp et al. | A mash-up application utilizing hybridized filtering techniques for recommending events at a social networking site | |
| JP2002215075A (en) | Advertisement delivery and display method and system | |
| JP2017046287A (en) | Service information distribution system, information distribution server and service information distribution method | |
| JP2002074053A (en) | Business method of electronic content distribution, distribution support system and recording medium with its program recorded on it | |
| JP2005222369A (en) | Information providing device, information providing method, information providing program and recording medium with the program recorded thereon | |
| JP5107124B2 (en) | Information display method, information display device, program, and recording medium | |
| JP5748084B1 (en) | Content distribution method and system | |
| CN102508893A (en) | Video multimedia search service application system and search method | |
| CN102087658A (en) | Information processing apparatus, information processing method, program, and information processing system | |
| JP4866747B2 (en) | Product information distribution system, content distribution server, user terminal, viewing history management server, viewing information search server, product information search server, and product information distribution method | |
| WO2023105994A1 (en) | Information management system, information management device, information management method, and information management program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1193289 Country of ref document: HK |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: GR Ref document number: 1193289 Country of ref document: HK |