CN102118580B - Method and device for broadcasting subtitle through data grouping and dynamic replacement - Google Patents
Method and device for broadcasting subtitle through data grouping and dynamic replacement Download PDFInfo
- Publication number
- CN102118580B CN102118580B CN200910244312.6A CN200910244312A CN102118580B CN 102118580 B CN102118580 B CN 102118580B CN 200910244312 A CN200910244312 A CN 200910244312A CN 102118580 B CN102118580 B CN 102118580B
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- content
- captions
- field
- 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.)
- Expired - Fee Related
Links
Landscapes
- Television Systems (AREA)
- Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)
Abstract
The invention provides a method and device for broadcasting a subtitle through data grouping and dynamic replacement. The method comprises the following steps of: detecting a selected field in a database table to obtain corresponding field content; receiving the selection of a user to the field content, and marking data records with the selected field content in the database table; querying the data records with the selected field content through SQL (Structured Query Language) sentences, and generating a first data table for the group of data records; and extracting data from the first data table as the content of subtitle pixels to broadcast subtitles. According to the method and device provided by the invention, the user does not need to compile different SQL sentences to query data every time, so that convenience is provided for the user during operation, the work load is reduced, and the extraction speed of data is increased.
Description
Technical field
The present invention relates to broadcasting television technology field, particularly relate to subtitle broadcasting method and device that a kind of packet dynamically replaces.
Background technology
Along with the development of video and multimedia technology, captions are produced on television program making field and are more and more popularized, fabrication techniques index is also more and more higher, and purposes is more and more extensive, and it is that the program credits making of TV station and the captions of film and television play make that captions make most widely used.
Be directed to some special series, as competitive sports, party on-the-spot broadcasting etc., higher to the requirement of real-time of caption playing, therefore, need can to switch rapidly between each captions, keep synchronous with the content of video playback.General way is all make subtitle template in advance, described subtitle template comprises captions pel and broadcasts pattern, play the dynamic attribute (as wide in font, font size, word etc. text attribute, the identical renderer property such as character face, limit, shadow) that pattern comprises captions and the dynamic effect entering, stop, go out.Captions pel represents the caption content that will broadcast, and as words such as libretto, dialogue, commentary, news, in addition, also comprise icon, station symbol, animation etc., the quarry of broadcasting title is in data center, and data center goes out from data base querying.Each data and captions pel are carried out mapping and are configured by editorial staff in advance, and when program is play, according to Play Control information, data replace the content of the captions pel in subtitle template, realize the broadcast of captions.
Because the data in database are generally provided by third party, data are comparatively various, and store and do not have rule, when data required for subtitle editing and playing side obtains, at every turn all will by different inquiry mode, and as called different SQL statement.Such as, when user's extraction has the data of different grouping content, according to athletic order coming on the stage, first to introduce sportsman's data of A team, then write the SQL query statement about A team for team participating in competition's field, when introducing sportsman's data of B team, then again write the SQL query statement about B team for team participating in competition's field.Repeatedly write, repeatedly inquire about, add the workload of operating personnel, and the speed that data are extracted is lower.
In a word, the technical problem needing those skilled in the art urgently to solve is exactly: how can obtain the data required for user fast from database, user friendly operation.
Summary of the invention
Technical problem to be solved by this invention is to provide the subtitle broadcasting method and device that a kind of packet dynamically replaces, and can obtain the data required for user fast, easily, user friendly operation from database.
In order to solve the problem, the invention discloses the subtitle broadcasting method that a kind of packet is dynamically replaced, comprising:
Field of choosing in database table is detected, obtains corresponding field contents;
Receive user to the selection of field contents, and the data record in database table with selected field contents is marked;
Be there is by SQL statement inquiry the data record of described mark, generate the first tables of data for this group data record;
From the first tables of data, extract data carry out caption playing as the content of captions pel.
Further, be detected as described in: the field contents of merging into choosing content in field identical is shown.
Preferably, described data of extracting from the first tables of data carry out caption playing as the content of captions pel, comprising:
Configure the mapping relations of the first tables of data and captions pel;
From the first tables of data, obtain corresponding data according to described mapping relations, the content of replacing captions pel carries out the broadcast of captions.
Preferably, described data of extracting from the first tables of data carry out caption playing as the content of captions pel, comprising:
Create the second tables of data, and configure the mapping relations of the second tables of data and captions pel; Wherein, the content of described second tables of data is empty, and its ranks number is not more than the ranks number of the first tables of data;
According to user, by the data chosen, the second tables of data is inserted to the selection of the first tables of data;
From the second tables of data, obtain corresponding data according to described mapping relations, the content of replacing captions pel carries out the broadcast of captions.
Further, described method also comprises:
Delete described mark, and re-start mark according to the selection again of user to field contents.
Concrete, according to the selecting sequence of user, the row/chosen or column data are filled from the first row or first row of the second tables of data.
In addition, the invention also discloses the caption playing device that a kind of packet is dynamically replaced, comprising:
Field detecting unit, for detecting the field of choosing in database table, obtains corresponding field contents;
Data markers unit, for receiving the selection of user to field contents, and marks the data record in database table with selected field contents;
Mark query unit, for being had the data record of described mark by SQL statement inquiry, generates the first tables of data for this group data record;
Caption playing unit, carries out caption playing for extracting data from the first tables of data as the content of captions pel.
Further, be detected as described in: the field contents of merging into choosing content in field identical is shown.
Preferably, described caption playing unit comprises:
First configuration subelement, for configuring the mapping relations of the first tables of data and captions pel;
First broadcasts subelement, and for obtaining corresponding data according to described mapping relations from the first tables of data, the content of replacing captions pel carries out the broadcast of captions.
Or described caption playing unit comprises:
Second configuration subelement, for creating the second tables of data, and configures the mapping relations of the second tables of data and captions pel; Wherein, the content of described second tables of data is empty, and its ranks number is not more than the ranks number of the first tables of data;
Data stuffing subelement, for inserting second tables of data to the selection of the first tables of data by the data chosen according to user;
Second broadcasts subelement, and for obtaining corresponding data according to described mapping relations from the second tables of data, the content of replacing captions pel carries out the broadcast of captions.
Further, described device also comprises:
Tag delete unit, for deleting described mark, then data markers unit re-starts mark according to the selection again of user to field contents.
Compared with prior art, the present invention has the following advantages:
The present invention selects for user by representing various content to the detection of field contents, and marks the data record with this content according to the selection of user; There is according to SQL statement inquiry the data group of described mark, generate the first tables of data, further, from the first tables of data, extract data carry out caption playing as the content of captions pel.Various field contents is represented by good user interface by the present invention, as the form of drop-down list, when user chooses a content, just label is stamped to the data record with this content, when then extracting data at every turn, call identical SQL statement, search the markd data of tool.User carries out data query without the need to writing different SQL statement at every turn, facilitates the operation of user, decreases workload, improve the extraction rate of data.
Further, the present invention is by configuring the mapping relations of captions pel and the second tables of data, broadcasting personnel only need to click data in the first tables of data, then selected data will be filled in the second tables of data automatically, the real-time broadcast of captions is realized according to mapping relations, broadcast content is had to the program of ambiguity, the dynamic replacement achieving captions is broadcasted, and real-time is high, flexibility is strong.
Accompanying drawing explanation
Fig. 1 is the flow chart of the subtitle broadcasting method embodiment one that a kind of packet of the present invention is dynamically replaced;
Fig. 2 is the flow chart of the subtitle broadcasting method embodiment two that a kind of packet of the present invention is dynamically replaced;
Fig. 3 is the structure chart of the caption playing device embodiment that a kind of packet of the present invention is dynamically replaced.
Embodiment
For enabling above-mentioned purpose of the present invention, feature and advantage become apparent more, and below in conjunction with the drawings and specific embodiments, the present invention is further detailed explanation.
With reference to Fig. 1, show the flow chart of the subtitle broadcasting method embodiment one that a kind of packet of the present invention is dynamically replaced, comprising:
Step 101, detects the field of choosing in database table, obtains corresponding field contents;
In relational database, database table is the set of two-dimensional array, is used for representing the relation between storage data object.It is made up of the row of longitudinal direction and the row of transverse direction, such as one about in the database table of author information, the information of certain particular type of all authors that what each row comprised is, the name of such as each author, often row then contains all information of certain particular author: name, age, address etc.For specific database table, the number of row is generally prior fixing, can be identified between each row by row name, the corresponding field of each row name.And row number can at any time, dynamic change, data line as a data record, often work often can according to certain (or certain is several) row in data identify, be called Candidate Key.
Captions quarry in the embodiment of the present invention is in database table, these data are provided by third party, because the data volume in database table is more, and storage order is random, therefore need to split by group it, thus subtitle editing and playing can be reached extract easily the data (the first tables of data) required for oneself.
Row data in database table are divided into each field, then a field by choosing user carries out content packet.Preferably, be detected as described in: the field contents of merging into choosing content in field identical is shown.
As follows, be a database table, it comprises 7 row (7 fields) 5 row (5 recording).The content of data is have recorded in unit lattice.
Database table:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 |
| A1 | A2 | A3 | A4 | A5 | A6 | A7 |
| B 1 | B2 | B3 | B4 | A5 | B6 | B7 |
| C1 | B2 | C3 | C | C5 | C | C |
| D1 | A2 | D | D | A5 | D | D |
| E1 | B2 | E | E | C5 | E | E |
If user selects field 2, then detect the data content in the 2nd row, to find out data content be A2 and data content is two groups of B2, shows " A2 " and " B2 " to user.
If user selects field 5, then detect the data content in the 5th row, to find out data content be A5 and data content is two groups of C5, shows " A5 " and " B5 " to user.
Step 102, receives user to the selection of field contents, and marks the data record in database table with selected field contents;
According to above-mentioned steps, on a user interface, by the form of drop-down list for user provides content choice, as the above-mentioned field 2 selected according to user, the drop-down list of two options with " A2 " and " B2 " can be shown.Then by the selection of user to " A2 " or " B2 ", the data record chosen is marked.In the present embodiment, suppose that user selects " B2 ".
Wherein, described mark can be: in database table, add tag field, adds mark in the tag field in described data group, described in be marked with multiple labeling form, do not limit, this sentences " * " for example is described.Embodiment of the present invention mark is as follows:
Database table after mark:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 | Tag field |
| A1 | A2 | A3 | A4 | A5 | A6 | A7 | |
| B1 | B2 | B3 | B4 | A5 | B6 | B7 | * |
| C1 | B2 | C3 | C4 | C5 | C6 | C7 | * |
| D1 | A2 | D3 | D4 | A5 | D6 | D7 | |
| E1 | B2 | E3 | E4 | C5 | E6 | E7 | * |
Step 103, is had the data record of described mark, generates the first tables of data for this group data record by SQL statement inquiry;
SQL (SQL, Structured Query Language) is a kind of data base querying and programming language, for access data and inquiry, renewal and administrative relationships Database Systems.The replacement operation of caption playing replaces by some external data the subtitle template (captions pel+broadcast pattern) designed in advance, so, for the place of concentrated storage external data, is exactly data center.In order to data in the heart in simple and effectively management data, be designed to the form of logic list.By calling SQL statement, from database, inquire the markd data group of tool, as the first tables of data (data center of caption broadcasting system).
The embodiment of the present invention only needs the markd data record of inquiry tool, by inquiring about the mark " * " in database table, obtains the 2nd, 3,5 row data, this group data genaration first tables of data, as follows:
First tables of data:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 |
| B1 | B2 | B3 | B4 | A5 | B6 | B7 |
| C1 | B2 | C3 | C4 | C5 | C6 | C7 |
| E1 | B2 | E3 | E4 | C5 | E6 | E7 |
Step 104, extracts data and carries out caption playing as the content of captions pel from the first tables of data.
The content sources of caption playing, in described first tables of data, when user selects captions material, directly by extracting data from the tables of data after grouping, can carry out captions broadcasting.
Further, in a preferred embodiment of the invention, described step 104 comprises following sub-step:
Steps A 1, configures the mapping relations of the first tables of data and captions pel;
Following mapping relations can be configured: captions pel 1 to 7 is corresponding with the data of unit lattice in the 1st row in the first tables of data successively, captions pel 8 to 14 is corresponding with the data of unit in the 2nd row in the first tables of data successively, and captions pel 15 to 21 is corresponding with the data of unit in the 3rd row in the first tables of data successively.
Steps A 2, obtains corresponding data according to described mapping relations from the first tables of data, and the content of replacing captions pel carries out the broadcast of captions.
When caption playing, read the data in the first tables of data according to the mapping relations of configuration in steps A 1, such as, when captions pel 1 to captions pel 21 broadcasts, broadcasting title content is:
B1 B2 B3 B4 A5 B6 B7
C1 B2 C3 C4 C5 C6 C7
E1 B2 E3 E4 C5 E6 E7
When the content that user needs broadcast field 2 is A1 time, direct selection selects " A1 " from the drop-down list of user interface, then corresponding, system marks the 1st row in database table and the 4th row data automatically, by the markd data record of SQL statement inquiry tool, first tables of data obtained, data therefrom carries out captions broadcasting.
Then when captions pel 1 to 14 broadcasts, accordingly, broadcasting title content is:
A1 A2 A3 A4 A5 A6 A7
D1 A2 D3 D4 A5 D6 D7
The embodiment of the present invention, content detection is carried out to the field of choosing of database table, by good user interface (UI, User Interface) each field contents carried out represent and select for user, present various data contents in this field, when user chooses a content as utilized the form of drop-down list, just label is stamped to the data record with this content, when then extracting data at every turn, call identical SQL statement, search the markd data of tool.User carries out data query without the need to writing different SQL statement at every turn, facilitates the operation of user, improves the extraction rate of data.
With reference to Fig. 2, show the flow chart of the subtitle broadcasting method embodiment two that a kind of packet of the present invention is dynamically replaced, the preferred embodiment of the present invention, be applied to the uncertain caption playing of caption content in on-the-spot broadcasting especially.In the broadcast of TV programme, on-the-spot broadcasting is that the one that TV station often adopts broadcasts form, it has ageing strong, the feature such as sound picture has both, on-the-spot sense of participation strong, spectators' attention rate is high, social influence is large, the event transfer that it can be paid close attention to spectators in the very first time, to spectators, shortens spectators and on-the-spot distance occurs event.Some grave news events, large-scale competitive sports and large-scale variety show etc. all will be broadcast live.
The present embodiment comprises:
Step 201, receives user to the selection of field in database table;
In the present embodiment, database table is the database table of Chinese National Championships 100 meter butterfly:
| Name | Sex | Achievement | Age | Delegation | Date of birth |
| XU Yanwei | Female | 00:58.68 | 24 | Shanghai | 1984-6-14 |
| Shi Feng | Man | 00:51.68 | 20 | Shanghai | 1988-11-6 |
| Wang Dong | Man | 00:51.96 | 22 | Shandong | 1986-2-4 |
| Yafei Zhou | Female | 00:57.68 | 24 | PLA | 1984-1-17 |
| Zhou Jiawei | Man | 00:51.36 | 22 | Guangdong | 1986-8-23 |
| Deng Biying | Female | 00:58.94 | 17 | Hubei | 1991-1-6 |
This database table comprises 6 row 6 row, 36 cells (solid box), is the title of field in dotted line frame, comprises " name ", " sex ", " achievement ", " age ", " delegation " and " date of birth " 6 fields.User can select one of them field to carry out field detection, as 4 kinds of contents detected according to " age " field: 17,20,22,24.In addition, can also detect, as according to the age according to preset field classification: be less than 20 years old, within 20 to 25 years old, more than 25 years old, divide into groups.The field that in the embodiment of the present invention, user chooses is " sex " field.
Step 202, detects the field of choosing in database table, obtains corresponding field contents;
Carry out content detection with " sex " field, find out two groups that data content is " man " and " female ".Further, on a user interface, a point group selection can be provided by the form of drop-down list for user, show the drop-down list of two options with " man " and " female ".
Step 203, receives user to the selection of field contents, and marks the data record in database table with selected field contents;
In the present embodiment, suppose that studio personnel need to be introduced with the sportsman of woman's group, then the option selected is " female ", marks in tag field to corresponding data record:
| Name | Sex | Achievement | Age | Delegation | Date of birth | Tag field |
| XU Yanwei | Female | 00:58.68 | 24 | Shanghai | 1984-6-14 | * |
| Shi Feng | Man | 00:51.68 | 20 | Shanghai | 1988-11-6 | |
| Wang Dong | Man | 00:51.96 | 22 | Shandong | 1986-2-4 | |
| Yafei Zhou | Female | 00:57.68 | 24 | PLA | 1984-1-17 | * |
| Zhou Jiacheng | Man | 00:51.36 | 22 | Guangdong | 1986-8-23 | |
| Deng Biying | Female | 00:58.94 | 17 | Hubei | 1991-1-6 | * |
Being appreciated that when carrying out being introduced each team member of man's group, in drop-down list, selecting option " man ", 2,3,5 row data record are marked.
Step 204, is had the data record of described mark, generates the first tables of data for this group data record by SQL statement inquiry;
Described first tables of data is designated as V
0, by inquiring about mark " * ", obtain V
0as follows:
| Name | Sex | Achievement | Age | Delegation | Date of birth |
| XU Yanwei | Female | 00:58.68 | 24 | Shanghai | 1984-6-14 |
| Yafei Zhou | Female | 00:57.68 | 24 | PLA | 1984-1-17 |
| Deng Biying | Female | 00:58.94 | 17 | Hubei | 1991-1-6 |
Step 205, creates the second tables of data, and configures the mapping relations of the second tables of data and captions pel; Wherein, the content of described second tables of data is empty, and its ranks number is not more than the ranks number of the first tables of data;
For caption playing side, some data content is unpredictable, as the achievement of sports tournament.Caption playing side cannot know that captions pel is corresponding with which data in the first tables of data (data center) in advance, therefore, need to set up the second tables of data, carry out mapping establishing put with captions pel, the data content in its second tables of data derives from the first tables of data.
Further, described mapping relations are: each captions pel is corresponding with the data in the unit lattice of the second tables of data.
Newly-built second tables of data, it has 3 row, 6 row, 18 cells, and unit lattice identify with ranks number, is labeled as " A line number row number ".As: the cell of the first row first row is A11, and the cell of the first row secondary series is A12, and the cell of the second row first row is A21, etc.Second tables of data is as follows:
| A11 | A12 | A13 | A14 | A15 | A16 |
| A21 | A22 | A23 | A24 | A25 | A26 |
| A31 | A32 | A33 | A34 | A35 | A36 |
Wherein, the content of unit lattice is empty, " A** " just as the title of cell in order to mark, digitized representation cell in bracket and the mapping relations of captions pel, as A11 to A16 is corresponding with captions pel 1 to captions pel 6, A21 to A26 is corresponding with captions pel 7 to captions pel 12, and A31 to A36 is corresponding with captions pel 13 to captions pel 18, and namely each captions pel carries out mapping relations configuration by line number and row number with the second tables of data.
The data chosen are inserted the second tables of data according to user to the selection of the first tables of data by step 206;
Because the broadcast content of captions is uncertain, the data therefore needing broadcast personnel to select needs to broadcast from the first tables of data according to the broadcast situation of program, are filled into and have in the second tables of data of configuration relation with captions pel.Second tables of data is designated as V
1, when according to broadcast personnel according to the broadcast situation of program, from V
0during middle selection data, V
1middle just have data content, and due to data from V
0, so V
0v
1a subset.
Such as, when giving out an award to player, need the personal information introducing sportsman Deng Biying, then corresponding from V
0select the data of the 3rd row, be filled into V
1in, as follows:
| Deng Biying | Female | 00:58.94 | 17 | Hubei | 1991-1-6 |
Step 207, obtains corresponding data according to described mapping relations from the second tables of data, and the content of replacing captions pel carries out the broadcast of captions.
When broadcasting title, according to above-mentioned mapping relations, V
1in table, corresponding data replace the content of captions pel 1 to captions pel 6, broadcast, because other cells do not insert data content, therefore do not do caption playing.General, in subtitle template, captions pel also has corresponding broadcast pattern, as font, color, position, stunt etc., in the present embodiment, there is different settings the position of each pel, and captions pel 1,7 and 13 is yellow regular script overstriking, other captions pels are the yellow Song typeface, then caption playing is as follows:
The green lustrous and transparent female 00:58.94 17 Hubei 1991-1-6 of Deng
Accordingly, when introducing the achievement of front three motion according to rank, then from V
0in select the data of the 3rd row, the 1st row and the 2nd row successively, be filled into V
1in.
It should be noted that, according to the selecting sequence of user, the row/chosen or column data are filled from the first row or first row of the second tables of data.
As follows:
| Deng Biying | Female | 00:58.94 | 17 | Hubei | 1991-1-6 |
| XU Yanwei | Female | 00:58.68 | 24 | Shanghai | 1984-6-14 |
| Yafei Zhou | Female | 00:57.68 | 24 | PLA | 1984-1-17 |
Then caption playing is as follows:
The green lustrous and transparent female 00:58.94 17 Hubei 1991-1-6 of Deng
XU Yanwei female 00:58.68 24 Shanghai 1984-6-14
Yafei Zhou female 00:57.68 24 PLA 1984-1-17
Further, column selection can also be carried out.Such as when introducing athletic age and delegation, broadcast personnel can be instant from V
0select the 1st row, the 4th row and the 5th row, be filled into V successively in order
1in, as follows:
| XU Yanwei | 24 | Shanghai |
| Yafei Zhou | 24 | PLA |
| Deng Biying | 17 | Hubei |
Then caption playing is as follows:
Green lustrous and transparent 17 Hubei of Deng
XU Yanwei 24 Shanghai
Yafei Zhou 24 PLA
The embodiment of the present invention, by configuring the mapping relations of captions pel and the second tables of data in advance, broadcasting personnel only need to click data in the first tables of data, then selected data will be filled in the second tables of data automatically, the real-time broadcast of captions is realized according to mapping relations, broadcast content is had to the program of ambiguity, the dynamic replacement achieving captions is broadcasted.Broadcast rapidly, real-time is high, flexibility is strong, and decrease the workload of broadcast personnel.
With reference to Fig. 3, show the structure chart of the caption playing device embodiment that a kind of packet of the present invention is dynamically replaced, comprising:
Field detecting unit 301, for detecting the field of choosing in database table, obtains corresponding field contents;
Data markers unit 302, for receiving the selection of user to field contents, and marks the data record in database table with selected field contents;
Mark query unit 303, for being had the data record of described mark by SQL statement inquiry, generates the first tables of data for this group data record;
Caption playing unit 304, carries out caption playing for extracting data from the first tables of data as the content of captions pel.
Preferably, be detected as described in: merge into a field contents by what choose content in field identical, and different field contents is shown.
In a preferred embodiment of the invention, described caption playing unit comprises:
First configuration subelement, for configuring the mapping relations of the first tables of data and captions pel;
First broadcasts subelement, and for obtaining corresponding data according to described mapping relations from the first tables of data, the content of replacing captions pel carries out the broadcast of captions.
In another embodiment of the present invention, described caption playing unit comprises:
Second configuration subelement, for creating the second tables of data, and configures the mapping relations of the second tables of data and captions pel; Wherein, the content of described second tables of data is empty, and its ranks number is not more than the ranks number of the first tables of data;
Data stuffing subelement, for inserting second tables of data to the selection of the first tables of data by the data chosen according to user;
Second broadcasts subelement, and for obtaining corresponding data according to described mapping relations from the second tables of data, the content of replacing captions pel carries out the broadcast of captions.
Wherein, the row/chosen or column data are filled according to the selecting sequence of user by described data stuffing subelement from the first row or first row of the second tables of data.
Concrete, described mapping relations are: the data in the unit lattice of each captions pel and the first tables of data or the second tables of data are corresponding.
Further, described device also comprises:
Tag delete unit, for deleting described mark, then data markers unit re-starts mark according to the selection again of user to field contents.
Each embodiment in this specification all adopts the mode of going forward one by one to describe, and what each embodiment stressed is the difference with other embodiments, between each embodiment identical similar part mutually see.For device embodiment, due to itself and embodiment of the method basic simlarity, so description is fairly simple, relevant part illustrates see the part of embodiment of the method.
The subtitle broadcasting method above a kind of packet provided by the present invention dynamically replaced and device, be described in detail, apply specific case herein to set forth principle of the present invention and execution mode, the explanation of above embodiment just understands method of the present invention and core concept thereof for helping; Meanwhile, for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (10)
1. the subtitle broadcasting method dynamically replaced of packet, is characterized in that, comprising:
Field of choosing in database table is detected, obtains corresponding field contents;
Receive user to the selection of field contents, and the data record in database table with selected field contents is marked;
Be there is by SQL statement inquiry the data record of described mark, generate for described first tables of data with the data record of described mark;
From the first tables of data, extract data carry out caption playing as the content of captions pel.
2. method according to claim 1, is characterized in that,
Describedly to be detected as: the field contents of merging into choosing content in field identical is shown.
3. method according to claim 2, is characterized in that, described data of extracting from the first tables of data carry out caption playing as the content of captions pel, comprising:
Configure the mapping relations of the first tables of data and captions pel;
From the first tables of data, obtain corresponding data according to described mapping relations, the content of replacing captions pel carries out the broadcast of captions.
4. method according to claim 2, is characterized in that, described data of extracting from the first tables of data carry out caption playing as the content of captions pel, comprising:
Create the second tables of data, and configure the mapping relations of the second tables of data and captions pel; Wherein, the content of described second tables of data is empty, and its ranks number is not more than the ranks number of the first tables of data;
According to user, by the data chosen, the second tables of data is inserted to the selection of the first tables of data;
From the second tables of data, obtain corresponding data according to described mapping relations, the content of replacing captions pel carries out the broadcast of captions.
5. the method according to claim 3 or 4, is characterized in that, also comprises:
Delete described mark, and re-start mark according to the selection again of user to field contents.
6. method according to claim 4, is characterized in that,
According to the selecting sequence of user, the row/chosen or column data are filled from the first row or first row of the second tables of data.
7. the caption playing device dynamically replaced of packet, is characterized in that, comprising:
Field detecting unit, for detecting the field of choosing in database table, obtains corresponding field contents;
Data markers unit, for receiving the selection of user to field contents, and marks the data record in database table with selected field contents;
Mark query unit, for being had the data record of described mark by SQL statement inquiry, generates for described first tables of data with the data record of described mark;
Caption playing unit, carries out caption playing for extracting data from the first tables of data as the content of captions pel.
8. device according to claim 7, is characterized in that,
Describedly to be detected as: the field contents of merging into choosing content in field identical is shown.
9. device according to claim 8, is characterized in that,
Described caption playing unit comprises:
First configuration subelement, for configuring the mapping relations of the first tables of data and captions pel;
First broadcasts subelement, and for obtaining corresponding data according to described mapping relations from the first tables of data, the content of replacing captions pel carries out the broadcast of captions;
Or described caption playing unit comprises:
Second configuration subelement, for creating the second tables of data, and configures the mapping relations of the second tables of data and captions pel; Wherein, the content of described second tables of data is empty, and its ranks number is not more than the ranks number of the first tables of data;
Data stuffing subelement, for inserting second tables of data to the selection of the first tables of data by the data chosen according to user;
Second broadcasts subelement, and for obtaining corresponding data according to described mapping relations from the second tables of data, the content of replacing captions pel carries out the broadcast of captions.
10. device according to claim 7, is characterized in that, also comprises:
Tag delete unit, for deleting described mark, then data markers unit re-starts mark according to the selection again of user to field contents.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910244312.6A CN102118580B (en) | 2009-12-30 | 2009-12-30 | Method and device for broadcasting subtitle through data grouping and dynamic replacement |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910244312.6A CN102118580B (en) | 2009-12-30 | 2009-12-30 | Method and device for broadcasting subtitle through data grouping and dynamic replacement |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102118580A CN102118580A (en) | 2011-07-06 |
| CN102118580B true CN102118580B (en) | 2015-02-18 |
Family
ID=44217156
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910244312.6A Expired - Fee Related CN102118580B (en) | 2009-12-30 | 2009-12-30 | Method and device for broadcasting subtitle through data grouping and dynamic replacement |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102118580B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102752233B (en) * | 2012-03-12 | 2018-05-04 | 新奥特（北京）视频技术有限公司 | A kind of method and system of competitive sports remote information prompting |
| CN106470363B (en) * | 2015-08-18 | 2019-09-13 | 阿里巴巴集团控股有限公司 | Compare the method and device of race into row written broadcasting live |
| CN107861981B (en) * | 2017-09-28 | 2020-09-01 | 北京奇艺世纪科技有限公司 | Data processing method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1417798A (en) * | 2002-12-02 | 2003-05-14 | 北京贝尔科技发展有限公司 | Caption using method in non-linear edit system |
| CN101021857A (en) * | 2006-10-20 | 2007-08-22 | 鲍东山 | Video searching system based on content analysis |
| CN101472093A (en) * | 2007-12-27 | 2009-07-01 | 新奥特（北京）视频技术有限公司 | Method and system for implementing configurable replacement of television graphics context subtitling |
| CN101674423A (en) * | 2008-09-10 | 2010-03-17 | 新奥特（北京）视频技术有限公司 | Method for generating caption broadcasting list driven by on-line program |
-
2009
- 2009-12-30 CN CN200910244312.6A patent/CN102118580B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1417798A (en) * | 2002-12-02 | 2003-05-14 | 北京贝尔科技发展有限公司 | Caption using method in non-linear edit system |
| CN101021857A (en) * | 2006-10-20 | 2007-08-22 | 鲍东山 | Video searching system based on content analysis |
| CN101472093A (en) * | 2007-12-27 | 2009-07-01 | 新奥特（北京）视频技术有限公司 | Method and system for implementing configurable replacement of television graphics context subtitling |
| CN101674423A (en) * | 2008-09-10 | 2010-03-17 | 新奥特（北京）视频技术有限公司 | Method for generating caption broadcasting list driven by on-line program |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102118580A (en) | 2011-07-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101753913B (en) | Method and device for inserting hyperlinks in video, and processor | |
| CN103052953B (en) | Messaging device, information processing method | |
| CN101472093B (en) | Method and system for implementing configurable replacement of television graphics context subtitling | |
| CN1531695A (en) | Method for navigation by computation groups, receiver for carrying out said method and graphical interface for presenting said method | |
| CN101196915A (en) | Electronic map device and its implementing method | |
| CN102917258A (en) | Video playing method, terminal and system based on video contents | |
| CN103425690A (en) | Picture information labeling and displaying method based on cascading style sheets | |
| CN102065234B (en) | Caption producing and broadcasting method and system based on distributive type caption processing system | |
| CN101901484A (en) | Document image segmentation system | |
| CN101388042B (en) | Method and device for establishing file characteristic library index | |
| CN102118580B (en) | Method and device for broadcasting subtitle through data grouping and dynamic replacement | |
| CN102420855B (en) | Method and system for displaying and playing by light-emitting diode (LED) terminal as well as server | |
| CN104185088A (en) | Video processing method and device | |
| CN103473220B (en) | The automatic merogenesis of documentary film content based on subtitle file and the automatic generation method of subhead thereof | |
| CN102118643A (en) | Network subtitle playing system and method | |
| CN102103586B (en) | Multi-language bidirectionally mixed-arranged caption edition system | |
| CN104244111B (en) | The method and apparatus of the media attributes of marking video | |
| CN102118578A (en) | Multi-language multi-special effect caption broadcasting method | |
| CN102082926B (en) | Making method and device of scene subtitles | |
| CN102082918B (en) | Caption machine for diversified caption rolling play | |
| CN102724425B (en) | A kind of method that teletext template is broadcasted | |
| CN109005470B (en) | Method, system and device for synthesizing subtitles on line | |
| CN102026033A (en) | Method for displaying Myanmar by set-top box (STB) | |
| CN102122524A (en) | System for quickly generating edited list in image-text packaging application | |
| CN102082928B (en) | Method and device for associating title properties |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20150218 Termination date: 20161230 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |