Background technology
TV subtitling is compiled and to be broadcast technology and occupy an important position in the technical development of broadcast television industry, makes and playing device is the digitized important component parts of radio, TV and film industries based on the teletext of computer technology.Teletext making and broadcast system based on computer technology roughly experienced simple two dimensional surface captions, possessed several stages such as the two-dimentional picture and text of texture innervation, high-quality two dimension and the complete fusion of 3-D graphic.The application of caption system has covered the every aspect of TV programme, comprises making and the broadcast of the acute program of live news class program, studio interview class program, comprehensive gala evening class program, the live class program of physical culture, finance and economics information class program, meteorological GEOGRAPHIC ATTRIBUTES program and film and television; The existing live post-production that also has of occasion of using, the post of application comprises edit field, studio and broadcasting line.
The caption editing system of TV station generally just supports the single mode that single programme is edited at present, basically all is to compile Dan Yuan by one the programme of some day is edited, and then preserves.If when existing single Yuan of several volume simultaneously programme to be edited, what finally preserve is last content of compiling single Yuan editor, and other content of edit of compiling Dan Yuan can be covered by last content of compiling single Yuan preservation, and therefore, this is not that truly many people edit.Existing edit mode ubiquity editorial efficiency is low, working strength is large, be difficult to adapt to the problems such as needs of TV station.
Summary of the invention
The object of the invention is to the defective for existing caption editing method, a kind of multi-person synergy subtitle editing method based on virtual lock mechanism is provided, thereby solve simultaneously many people technical problem of edit of station synchronization list, the efficient of raising caption editing.
Technical scheme of the present invention is as follows: a kind of multi-person synergy subtitle editing method based on virtual lock mechanism comprises the steps:
The programme that (1) will import database carries out the division of period according to the time started of program;
(2) set up a database lock table that virtual lock is managed;
(3) compile Dan Yuan and at first a period of current programme is locked, namely insert a respective record in the database lock table, then caption editing is carried out in the program of this period;
(4) compile Dan Yuan and finish editor to captions after, the current period is carried out release, will database lock table in corresponding lock record deletion.
Further, aforesaid multi-person synergy subtitle editing method based on virtual lock mechanism, the field of the database lock that sets up in the step (2) table comprises: compiles single Yuan sign FSESSIONID, the time FLOCKTIME that locks, update time FUPDATETIME, programme identify FPLAYLISTID, captions type FPLAYITEMTYPE, the time segment identification FSEGMENTID.
Further, aforesaid multi-person synergy subtitle editing method based on virtual lock mechanism, in step (3), other volumes Dan Yuan locked to other period of current programme, in database lock table, insert other respective record, then the program of its period that locks carried out caption editing;
Perhaps, other are compiled Dan Yuan timing subtitle or manual captions are locked, and insert respective record in database lock table, then the content of its timing subtitle that locks or manual captions are edited.
Further, aforesaid multi-person synergy subtitle editing method based on virtual lock mechanism, in step (3), after having newly organized Dan Yuan that the same period of current programme is forced to lock, lock record current in the database lock table is with deleted, and generate the record of newly organized single Yuan correspondence, then by newly organized Dan Yuan the program of this period is carried out caption editing.
Beneficial effect of the present invention is as follows: captions type involved in the present invention is divided into captions under the program, timing subtitle and manual captions, by programme was divided by the period, realized that a programme can be edited by many people at one time simultaneously, and, by virtual lock locking mechanisms, the caption editing that has guaranteed day part can not conflict mutually, thereby, editorial efficiency and the fail safe of captions have been improved, reduce the working strength of compiling Dan Yuan, satisfied the needs of TV programme record and broadcast technical development.
Embodiment
Below in conjunction with the drawings and specific embodiments the present invention is described in detail.
As shown in Figure 1, the present invention is divided into captions under the program, timing subtitle and manual captions to the captions of the programme of TV station.Wherein, captions are the captions that program is corresponding in the programme under the program, and the time started of captions is the time with respect to program, begin if say program 07:00:00, the captions time started is 00:01:00, and the time started during caption playing is exactly 07:01:00 so; Timing subtitle is absolute time; Manually captions are manual control, manually broadcast as required.Then programme is carried out the division of period according to the time started of program.According to compiling the different of single member and each TV station's working working condition, the division of time period also can be different, and this can configure.For example period a is 08:00:00-12:00:00; Period b is 12:00:00-18:00:00 etc.If it just belongs to the program of certain period so within some periods the time started of a program so, for example the time started of program p is 09:00:00, and its time started is included among the period a as can be known, so program p belongs to period a.Programme is that the mode with file imports, then deposit database (also can otherwise deposit database in) in, every program has individual attribute field to identify period under it in database, when importing programme so, program can compare according to its time started the start and end time of period, if within the period, then this program just belongs to this period, and record slot id in this program recording in database.Among this embodiment the programme of every day be divided into section in morning, morning section, afternoon section, evening section and midnight section.
The present invention adopts database that virtual lock is managed, and sets up a database lock table that virtual lock is managed.The structure of table as shown in Figure 2, field comprises: compiles single Yuan sign FSESSIONID, the time FLOCKTIME that locks, update time FUPDATETIME, programme identify FPLAYLISTID, captions type FPLAYITEMTYPE, the time segment identification FSEGMENTID.
Each just generates a unique sign SESSIONID after compiling single Yuan login system; There is the SEGMENTID of oneself each period; The programme of every day has unique PLAYLISTID.
Before editor, at first to check the situation of lock, if do not lock, just can not edit, can point out to lock.When compiling after the programme PLAYLIST1 period in morning, SEGMENT1 locked of single Yuan 1 pair of some day, compile single Yuan 1 and just can add editor's captions to the program of period in morning, just insert a record this moment in database Lock table, other are compiled single Yuan and can edit the program of this other period of programme, also can edit timing subtitle and manual captions, realize same programme multi-person synergy editor.
The a certain period to programme locks, and is to realize by the locking mechanisms of database, that is to say to insert a respective record in database lock table.For example when compiling the program of Dan Yuan for period a and add captions, so at first check this compile Dan Yuan in the lock table, whether have lock record and programme sign, the time segment identification whether identical with the object of editing, if meet then he just can carry out the editor of captions, thereby realized locking.If no, system can point out him not lock or locked by others.
Owing in particular cases compiling single Yuan 2 and editing compiling single Yuan 1 part of editing possibly, compile so and can force for single Yuan 2 to lock, and notice is compiled the reason that single Yuan 1 pressure locks, compile single Yuan 1 if the authority of compiling single Yuan 2 is not higher than, can force to lock after will obtaining so the agreement of compiling single Yuan 1.If do not permitted within a certain period of time, so just can force to lock.After forcing to add latching operation, system will compiling single Yuan 1 lock record deletion in the database Lock table, generate the lock record of compiling single Yuan 2.After single Yuan 2 of volume forces to lock, to compile single Yuan 1 and just can not edit this part, this has guaranteed the fail safe of caption editing.For example: the period S that the compiles single Yuan 2 couples of programme P editor that locks, when he adds latching operation, system can check the lock table record, if the lock record that has the S of single Yuan 1 couple of P of volume to lock, system can remind single Yuan 2 this period of volume to have single Yuan 1 of volume to lock so, and whether inquiry is forced to lock.If can force to lock, system can insert the lock record of compiling single Yuan 2 to the lock record deletion of compiling single Yuan 1 in the database so, thereby has realized forcing to lock.
When compiling after single Yuan editor finishes, just can manual unlocking, if volume Dan Yuan forget release and leave system, system can be his automatic unlocking so.When a certain period of a certain programme is carried out release, system can identify according to programme, the time segment identification and compile single Yuan sign, find the lock record in the 1ock table, then delete this record, thereby realize release.Other volume Dan Yuan just can lock to this period of this programme so.That is to say in the lock table, single for same program, the lock record of identical period has at most one.
The time hop count of supposing programme is S, and a so same programme can support S+2 people to edit simultaneously at least, S period editor, and one regularly partly editor and a hand-operated divide editor.If according to present method for distinguishing, same programme synchronization can only have a people to edit, if use this method, just can support that many people edit, and editorial efficiency is exactly S+2 times of method for distinguishing.
Realize that the existing software systems support of wanting required for the present invention is as follows:
1. compile single software M5DPLEditor---editing interface and program time-interval displaying etc. are provided, this running software is being compiled on single work station, and common PC is also passable.
2. webmastering software M5DManager---divides configuration to program time-interval.
3. service end software NGSServer---mainly is the read-write of carrying out virtual lock by this service end, and the transmission of message, is deployed on the server.
Method of the present invention is not limited to the embodiment described in the embodiment, and those skilled in the art's technical scheme according to the present invention draws other execution mode, belongs to equally technological innovation scope of the present invention.