CN102739966A - Method and apparatus for editing program in remote centralized control system - Google Patents
Method and apparatus for editing program in remote centralized control system Download PDFInfo
- Publication number
- CN102739966A CN102739966A CN2011100803783A CN201110080378A CN102739966A CN 102739966 A CN102739966 A CN 102739966A CN 2011100803783 A CN2011100803783 A CN 2011100803783A CN 201110080378 A CN201110080378 A CN 201110080378A CN 102739966 A CN102739966 A CN 102739966A
- Authority
- CN
- China
- Prior art keywords
- programme
- database
- data
- control system
- reading device
- 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.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and an apparatus for editing a program in a remote centralized control system. The system comprises: uploading data through terminals to a centralized control center, processing the data by the centralized control center, and then sending the processed data to each terminal. The system is characterized that a data processing process of the centralized control center comprises: reading the data by a program material reading device; editing the program and generating the program; and outputting the program by a program output device. A data base adapter is connected between a program processing device and a data base of the remote centralized control system. Through the above method, editing of the program can be realized in the remote centralized control system, and meanwhile, a plurality of the materials' invocation patterns are performed, and newly uploaded data are identified and edited. Furthermore, disposing the data base adapter between the program processing device and the data base of the remote centralized control system realizes a function of bidirectional mapping and provides possibility for bidirectional data interaction. Through the remote centralized control data base, the program is managed, and thus, the program needed is sent to each terminal client.
Description
Technical field
The present invention relates to the programme editor's in a kind of remote control system method and system, particularly in the remote control system, to each terminal concentrate the programme editor and the treatment system that issues, store, examine in.
Background technology
Video media and advertising business be development rapidly in recent years; Some specific occasions particularly: like square, station, airport etc.; Various video terminals are seen everywhere; But most terminal all is the local video playback terminal, and control terminal and the memory device that is connected with video terminal promptly arranged in this locality, can only carry out Broadcast Control to the media content of this locality storage.
The pattern of this local Broadcast Control, on the one hand a large amount of wastes resource, and brought the difficulty of disposing; On the other hand for some media files, operator or administrative department can hope can how synchronous broadcast and control, this pattern obviously can't satisfy the demands.
Internet development is that remote transmission and broadcast provide possibility, through central server and the video terminal that spreads all over the world, realizes strange land transmission and remote playing, arises at the historic moment, and has brought new problem and challenge also.How to realize long-range Play Control, can further reduce resource consumption, realize strange land playback terminal unattended operation normal operation, and make mistakes and handle automatically; How the content of remote playing is operated, improve reliability and practicality, press for the introducing new technology and solve above problem.
To obtain corresponding nonlinear video file at each terminal; Just need carry out the editor of non-linear programme; The application of non-linear programme editing system is simple relatively for each terminal, but comparatively frequent, based on the configuration cost of editing saving system; Each terminal use is difficult to realize rational cost performance, thereby can not realizes the editing saving processing.For traditional volume single system, can only support local operation and visit, can not be implemented in and call on the different system platforms and the control that distributes.And see from the mode of operation of traditional volume single system, also be difficult to satisfy the requirement that multi-point cooperative calls, in traditional volume single system; System wants earlier all uplink datas to be verified; Guarantee that each material all is in upstate, carry out artificial layout again, need each material all to be present in the local data base simultaneously; So that call at any time; Media file has the big characteristics in the space of broadcast, and carrying out long-range Broadcast Control often needs the very long transmission time, uses for actual terminal and has brought difficulty.
In realizing process of the present invention, the inventor finds to exist at least in the prior art following problem:
Existing program is compiled single system can't realize calling the function that the strange land resource is compiled unitary call; Two-way database material mapping function can't be provided; Can't effectively guarantee to compile the unified management of monofile and issue, thereby can not effectively utilize terminal resource, it is multiplexing to carry out multi-platform programme.
Summary of the invention
Method for the programme editor in the purpose that reaches the programme editor in the remote control system, a kind of remote control system; Comprise: data upload to collection control center through the terminal; After data processing is carried out at collection control center; Again deal with data is issued to each terminal; It is characterized in that collection control center carries out comprising in the data processing method: programme material reading device reading of data, carry out the programme editor, and generate the step of programme, programme output device output programme; Wherein programme material reading device read data packet is drawn together reading new material tabulation, and said programme reading device read data packet is drawn together: online mode reads, offline mode reads; Wherein, said offline mode reads and comprises: read the material tabulation from database adapter; Online mode reads and comprises: extract material from this locality, from collection control central database, extract material; Extracting material from this locality comprises: from new material database, extract the material tabulation, read new material tabulation and comprise: from the material management module of collection control center, receive material information; Saidly read the tabulation of new material and comprise, at first, from the material management module of collection control center, receive material information; Afterwards, with available data storehouse material tabulation contrast, if new material is put into new material tabulation; Between remote control system database and programme processing unit, be provided with, database adapter, said database adapter can provide based on macaronic at least Database Mapping information table; In to the programme edit operation, comprise: the programme material is inserted, increases, deletes, revises editor; The programme that generates comprises, below three category informations: programme attribute information, material attribute information, task description information, wherein; The programme attribute information comprises: programme title, rise time, modification time, operator's attribute, output time; The material attribute information comprises: material entity file information, material uplink time, material user information; Task description information comprises: photos and sending messages, abnormal conditions record under each terminal identification information, the task in programme output programme process, at first, will generate programme and send in the remote control system database, in the programme storage unit; Afterwards, will generate programme sends in the remote control system audit module.
The present invention also provides the programme editor's in a kind of remote control system device, and this device comprises:
Programme material reading device, programme processing unit, programme output device; Between programme processing unit and remote control system database, connect database adapter; Programme material reading device; Can read new material tabulation operation, programme material reading device comprises: online mode reading device, offline mode reading device; The online mode reading device can extract material or from collection control central database, extract material from this locality; Database adapter; Can provide based on macaronic at least Database Mapping information table; And between programme material reading device and the collection control central database two-way mapping service being provided; And upgrade automatically, the programme processing unit can carry out the programme material and insert, increases, deletes, revises editor, in the programme output device, comprises programme attribute information, material attribute information, task description information; Can send in the remote control system database generating programme, in the programme storage unit; And will generate programme simultaneously and send in the remote control system audit module.
Compared with prior art, the embodiment of the invention has the following advantages:
The method that provides through the embodiment of the invention; In the remote control system, realize the editor of programme, in this simultaneously, carried out the multiple invocation pattern of material; Discern and edit newly uploading data; And between editing saving device and remote control database, set up database adapter, and realize two-way mapping function, to two-way data interaction possibility is provided.Carry out the programme management through unified remote control database, thereby each terminal client is issued required programme.
Description of drawings
Fig. 1 is the programme editor's in a kind of remote control system among the present invention method sketch map;
Fig. 2 is the programme editor's in a kind of remote control system among the present invention method flow diagram;
Fig. 3 is the programme editor's in a kind of remote control system among the present invention method sketch map;
Fig. 4 is remote control system of the present invention and programme editing device allocation plan;
Fig. 5 is a remote control system database relation structure diagram of the present invention;
Embodiment
Below in conjunction with accompanying drawing and embodiment, specific embodiments of the invention is done further to describe in detail:
Embodiment one:
Programme editor's in this flow process of the present invention a kind of remote control as shown in Figure 1 system method; Comprise: data upload to collection control center through the terminal; After data processing is carried out at collection control center, again deal with data is issued to each terminal, it is characterized in that; Collection control center carries out specifically may further comprise the steps in the data processing method: 1. programme material reading device reading of data; 2. carry out the programme editor and generate programme; 3. programme output device output programme.
Above step is to accomplish programme editor's basic operation method, in 1. programme material reading device reading of data process, two kinds of data is handled; Primary sources are to compile single and data that upload especially by each terminal promptly for newly uploading data, and this kind data are not present in the database of remote control system before this; Therefore will carry out " material management " module earlier data are handled and stored, the identification information that layout is new calls thereby be implemented in the programme editing process; Secondary sources are original data in the database, and the various information of data Already in the database, does not need to carry out again through " material management " module the division of identification information again; This type of information can directly read from database, also can have " error message " simultaneously, i.e. actual discovery the in invoked procedure; This information does not exist in fact; For this category information, only give the sign of error message, do not provide further processing.
Embodiment two:
The another kind of performance of the programme editor's in this flow process of the present invention a kind of remote control as shown in Figure 2 system method:
At first; If material is new material, programme material reading device gives corresponding to the new material information that comes from " material management " module, and prompting can appear in the new material prompting tabulation of programme material editing interface; Also can appear in the programme material editing interface through the form of prompting frame; With " new material " information of prompting, put into new material tabulation storehouse, so that in compiling single process, call.
Afterwards, begin to carry out the layout of material, because in the middle of remote control system database and programme editing device, set up database adapter; Because this centralized control system database is a SQL database, therefore select the SQL database adapter for use; This adapter provides SQL database, and the mapping relations information of application program (writing through C Plus Plus) data structure in data structure and the programme editing device is therefore under the not online situation of database; Through the mapping table information in the database adapter, still can carry out record, thereby present embodiment two kinds of modes to the programme editor are provided to the material information in the database; Be online editing and off-line editing, under the situation of off-line editing, material edited through the map information of database adapter; If with the preliminary judgement online editing, can select two kinds of query paths that material is called, if this material is present in the new material tabulation; System will preferentially call from new material database, singly is that material in the database is handled if this time compile, and directly accessing database is operated; Simultaneously, because the reason of database adapter, simultaneously; This operation also can be to operate based on database fully, calls, resets and delete for material information relevant in the database.After extracting desired data; Carry out the programme editor; Needs according to terminal client generate new programme; Comprised three category informations in this programme: i.e. programme attribute information, material attribute information, task description information also are the setting form in the database during information of same of putting down in writing in the programme, and wherein the database relation model is seen shown in Figure 5; Wherein the tables of data definition is as follows:
1) .Task shows, and has defined the association attributes of task:
2) .Resource shows, and has defined the association attributes of resource.Resource comprises three types: material, programme, catalogue:
3) .Material shows, and has defined the association attributes of material (entity file), and file type comprises video file, audio file and programme.
4) .Site shows, and has defined the association attributes on website (airport)
5) .RRRelation table, the correlation between the record resource.Relation is " quoting " between programme and the material, and the relation between catalogue and programme, catalogue and the material is " comprising ".
6) .RSRelation table, the relations of distribution between record resource and the website
7) .User shows, and has defined user's association attributes.
8) .UserRole table, the recording user character types.
9) .Group table has defined the association attributes that the user organizes, the corresponding definite website (airport) of group.
10) .UGRelation table, the corresponding relation between recording user and the group.
11) .Log table, the register system operation information.
And, put into the remote control database with the programme that is generated, can send in the auditing module simultaneously.
Embodiment three:
Programme editor's in this flow process of the present invention a kind of remote control as shown in Figure 3 system device comprises: programme material reading device; The programme processing unit; The programme output device; Wherein between programme processing unit and remote control system database, connect database adapter, said programme material reading device can read new material tabulation operation; Programme material reading device comprises: online mode reading device, offline mode reading device; Database adapter can provide based on macaronic at least Database Mapping information table, and between programme material reading device and the collection control central database two-way mapping service being provided; And upgrade automatically, the programme processing unit can carry out the programme material and insert, increases, deletes, revises editor.
The above only is a preferred implementation of the present invention; Should be understood that for those skilled in the art; Under the prerequisite that does not break away from the principle of the invention, can also make some improvement and retouching, these improvement and retouching also should be regarded as protection scope of the present invention.
Claims (21)
1. the programme editor's in the remote control system method; Comprise: data upload to collection control center through the terminal, after data processing is carried out at collection control center, again deal with data are issued to each terminal; It is characterized in that collection control center carries out may further comprise the steps in the data processing method:
Programme material reading device reading of data;
Carry out the programme editor, and generate programme;
Programme output device output programme.
2. the method described in claim 1: it is characterized in that: said programme material reading device read data packet is drawn together:
Read new material tabulation.
3. the method described in claim 1: it is characterized in that: said programme reading device read data packet is drawn together: online mode reads, offline mode reads.
4. the method described in claim 3: it is characterized in that: said offline mode reads and comprises:
Read the material tabulation from database adapter.
5. the method described in claim 3: it is characterized in that: said online mode reads and comprises:
Extract material from this locality, from collection control central database, extract material.
6. the method described in claim 5: it is characterized in that: the said material that extracts from this locality comprises:
From new material database, extract the material tabulation.
7. the method described in claim 2 is characterized in that: saidly read new material tabulation and comprise:
From the material management module of collection control center, receive material information;
With available data storehouse material tabulation contrast, if new material is put into new material tabulation.
8. the method described in claim 4 is characterized in that, said database adapter can provide based on macaronic at least Database Mapping information table.
9. the method described in claim 1 is characterized in that, saidly carries out the programme editor and comprises: the programme material is inserted, increases, deletes, revises editor.
10. the method described in claim 1 is characterized in that, said programme comprises:
Programme attribute information, material attribute information, task description information.
11. the method described in claim 10 is characterized in that:
Said programme attribute information comprises: programme title, rise time, modification time, operator's attribute, output time;
Said material attribute information comprises: material entity file information, material uplink time, material user information;
Said task description information comprises: photos and sending messages, abnormal conditions record under each terminal identification information, the task.
12. the method described in claim 1 is characterized in that, said programme output device output programme comprises:
To generate programme and send in the remote control system database, in the programme storage unit;
And will generate programme simultaneously and send in the remote control system audit module.
13. the programme editor's in the remote control system device is characterized in that, comprising:
Programme material reading device;
The programme processing unit;
The programme output device.
14. the device described in claim 13 is characterized in that,
Between programme processing unit and remote control system database, connect database adapter.
15. the device described in claim 14 or 13 is characterized in that, said programme material reading device can read new material tabulation operation.
16. the device described in claim 13 is characterized in that, said programme material reading device comprises: online mode reading device, offline mode reading device.
17. the device described in claim 16 is characterized in that, said online mode reading device can extract material or from collection control central database, extract material from this locality.
18. the device described in claim 14; It is characterized in that said database adapter can provide based on macaronic at least Database Mapping information table; And between programme material reading device and the collection control central database two-way mapping service being provided, and upgrade automatically.
19. the device described in claim 13 is characterized in that, said programme processing unit can carry out the programme material and insert, increases, deletes, revises editor.
20. the device described in claim 13 is characterized in that, said programme output device comprises programme attribute information, material attribute information, task description information in this device.
21. the device described in claim 13 is characterized in that, said programme output device can send in the remote control system database generating programme, in the programme storage unit; And will generate programme simultaneously and send in the remote control system audit module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011100803783A CN102739966A (en) | 2011-03-31 | 2011-03-31 | Method and apparatus for editing program in remote centralized control system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011100803783A CN102739966A (en) | 2011-03-31 | 2011-03-31 | Method and apparatus for editing program in remote centralized control system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102739966A true CN102739966A (en) | 2012-10-17 |
Family
ID=46994667
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011100803783A Pending CN102739966A (en) | 2011-03-31 | 2011-03-31 | Method and apparatus for editing program in remote centralized control system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102739966A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103475903A (en) * | 2012-06-07 | 2013-12-25 | 新奥特（北京）视频技术有限公司 | Method and device for generating audio-video program list and program package |
| CN103491385A (en) * | 2013-09-04 | 2014-01-01 | 航天数字传媒有限公司 | Changing method of satellite user terminal storage programs |
| CN103702236A (en) * | 2013-12-17 | 2014-04-02 | 北京九华互联科技有限公司 | Broadcast control authority control method |
| CN110602510A (en) * | 2018-06-13 | 2019-12-20 | 阿里巴巴集团控股有限公司 | Information control method, device and system in cross-screen interactive live broadcast |
| CN111428077A (en) * | 2020-05-14 | 2020-07-17 | 湖南芒果听见科技有限公司 | Information processing method and terminal thereof |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101102418A (en) * | 2007-07-23 | 2008-01-09 | 安徽天虹数码技术有限公司 | A storage device and storage method for TV program form of TV studio |
| CN101448091A (en) * | 2007-11-27 | 2009-06-03 | 北大方正集团有限公司 | Method and system for automatically replacing materials |
| WO2009137206A2 (en) * | 2008-05-06 | 2009-11-12 | Microsoft Corporation | Media content programming, delivery, and consumption |
| CN101588372A (en) * | 2009-04-24 | 2009-11-25 | 中国电信股份有限公司 | Remote playing method and system to media content |
| CN101626376A (en) * | 2009-08-04 | 2010-01-13 | 中国联合网络通信集团有限公司 | Set-top box (STB) file uploading methods, STB file uploading device and STB file uploading system based on internet protocol television (IPTV) |
-
2011
- 2011-03-31 CN CN2011100803783A patent/CN102739966A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101102418A (en) * | 2007-07-23 | 2008-01-09 | 安徽天虹数码技术有限公司 | A storage device and storage method for TV program form of TV studio |
| CN101448091A (en) * | 2007-11-27 | 2009-06-03 | 北大方正集团有限公司 | Method and system for automatically replacing materials |
| WO2009137206A2 (en) * | 2008-05-06 | 2009-11-12 | Microsoft Corporation | Media content programming, delivery, and consumption |
| CN101588372A (en) * | 2009-04-24 | 2009-11-25 | 中国电信股份有限公司 | Remote playing method and system to media content |
| CN101626376A (en) * | 2009-08-04 | 2010-01-13 | 中国联合网络通信集团有限公司 | Set-top box (STB) file uploading methods, STB file uploading device and STB file uploading system based on internet protocol television (IPTV) |
Non-Patent Citations (1)
| Title |
|---|
| 冯治广: "ADO.NET离线操作数据库的研究与实现", 《科技资讯》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103475903A (en) * | 2012-06-07 | 2013-12-25 | 新奥特（北京）视频技术有限公司 | Method and device for generating audio-video program list and program package |
| CN103475903B (en) * | 2012-06-07 | 2018-05-04 | 新奥特（北京）视频技术有限公司 | A kind of generation method and device of audio/video program list and program bag |
| CN103491385A (en) * | 2013-09-04 | 2014-01-01 | 航天数字传媒有限公司 | Changing method of satellite user terminal storage programs |
| CN103491385B (en) * | 2013-09-04 | 2016-09-14 | 航天数字传媒有限公司 | A kind of satellite user terminal storage column purpose change method |
| CN103702236A (en) * | 2013-12-17 | 2014-04-02 | 北京九华互联科技有限公司 | Broadcast control authority control method |
| CN103702236B (en) * | 2013-12-17 | 2017-09-22 | 北京九华互联科技有限公司 | A kind of broadcast control authority control method |
| CN110602510A (en) * | 2018-06-13 | 2019-12-20 | 阿里巴巴集团控股有限公司 | Information control method, device and system in cross-screen interactive live broadcast |
| CN110602510B (en) * | 2018-06-13 | 2021-11-30 | 阿里巴巴集团控股有限公司 | Information control method, device and system in cross-screen interactive live broadcast |
| CN111428077A (en) * | 2020-05-14 | 2020-07-17 | 湖南芒果听见科技有限公司 | Information processing method and terminal thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104123227A (en) | Method for automatically generating testing cases | |
| CN101561826B (en) | Method and application for sharing and cooperating online non-structural file based on node granularity semantics | |
| CN102739966A (en) | Method and apparatus for editing program in remote centralized control system | |
| CN104683453A (en) | Family affection sharing system of photos, videos and congratulation cards based on cloud platform | |
| CN112967027A (en) | Cloud platform multi-tenant based 5G message service platform and method | |
| CN104615710A (en) | Electronic map frame data updating method | |
| CN106354857A (en) | News tag management system | |
| CN103530080A (en) | Automation display method and system | |
| CN101656839B (en) | Unattended operation method for producing and broadcasting automatic caption list | |
| CN101656838B (en) | Broadcasting-line automation caption producing and broadcasting system of television broadcast station | |
| CN102637210A (en) | Management platform of electronic files | |
| CN102097015A (en) | Operation instruction processing system and method | |
| CN102624770A (en) | Information extraction method and extraction information network storage management system based on cloud calculation | |
| CN102254023A (en) | Method and device for editing webpage | |
| CN114255010A (en) | Electronic file archival management and knowledge service collaborative implementation method in electronic government platform | |
| CN114168117A (en) | Credit low-code development tool based on designer and storage device | |
| WO2024011829A1 (en) | Comprehensive intelligent platform data management method and system based on spatio-temporal system | |
| CN108874495A (en) | Theme resource conversion method and device and electronic equipment | |
| CN106503958A (en) | A kind of smart office system and method based on Internet of Things | |
| CN103135991B (en) | The customization implementation method of embedded device web interface | |
| CN108874856A (en) | A kind of page generates system, method and server | |
| CN104463682A (en) | Manuscript collection and gathering system and method | |
| CN107357887A (en) | The generation method of report of tracing to the source based on Quick Response Code | |
| CN107395667A (en) | Multicast data transmission method based on data management service platform CIS interfaces | |
| CN112835664A (en) | Automatic configuration system for marketing landing page |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20121017 |
|
| RJ01 | Rejection of invention patent application after publication |