CN102752553A - Method and system for dynamic call and generation of data base in grading system - Google Patents
Method and system for dynamic call and generation of data base in grading system Download PDFInfo
- Publication number
- CN102752553A CN102752553A CN2011103181999A CN201110318199A CN102752553A CN 102752553 A CN102752553 A CN 102752553A CN 2011103181999 A CN2011103181999 A CN 2011103181999A CN 201110318199 A CN201110318199 A CN 201110318199A CN 102752553 A CN102752553 A CN 102752553A
- Authority
- CN
- China
- Prior art keywords
- data
- project
- marking
- competition
- data items
- 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.)
- Granted
Links
Images
Abstract
The invention discloses a method and a system for dynamic call and generation of a data base in a grading system. The method comprises the steps of receiving a match data project and a grading data project; establishing corresponding incidence relation of the match data project and the grading data project; packaging the match data project and the grading data project into a data base file of the match data project according to the incidence relation; and generating a subtitle file according to the data base file of the match data project. According to the method and the system, a grading server performs dynamic adjustment of a data base structure and required data are generated. Different data bases are not required to be established for processing grading data according to different grading systems, so that the scale of an original data base is not enlarged, the stability of the system is improved, and the operation cost of the system is reduced.
Description
Technical field
The present invention relates to that athletic competition is relayed, in the live marking type program making field, be applied to calling and handling of the on-the-spot data of scoring of athletic competition, database dynamic is called the generation method and system in the particularly a kind of marking system.
Background technology
Along with the development of television relay technology, live telecast class program becomes the important component part of TV programme, and particularly the television relay for the marking class has obtained significant progress in recent years; Its development not only relates in the TV domain, and relates to widely in distributed network and the mobile storage field, in the live process of athletic competition or marking type program; Usually need carry out site instant to field data and handle, because there is different marking rules in different marking class programs, therefore; Need be directed to the different marking system of different contest show customization in the prior art, be used to satisfy the requirement of different athletic competitions, in the prior art in order to make above data processing more flexible; Also be chosen in the system database structure of setting up " maximization " usually, choose therein, but adopt the problem of above method to be according to user's actual needs; In need marking class program than small data quantity, needs are moved large-scale database file, be used to satisfy the requirement of on-the-spot marking system; Not only caused resource waste; Time spent has increased the input cost of TV programme, simultaneously, and for the high reliability of type of relaying live program in order to guarantee to relay live; Therefore, the data processing for the scene also will guarantee reliably at needs flexibly simultaneously simultaneously.
Realize in the process of the present invention that the inventor finding has following defective in the prior art, the generation of spot database structure item need be carried out special customization with renewal in the prior art; Need different database structures to different score programs, therefore, limited to the flexibility of data library structure project adjustment; Simultaneously, as make up large-scale Database Systems, owing to only local data bank is used usually; Therefore, improve the operating cost of system, caused resource waste.
Summary of the invention
To defective of the prior art, the invention solves in the marking system and the data library structure is dynamically adjusted, and generate the problem of desired data through the marking server.
The invention provides in a kind of marking system database dynamic and call the generation method in order to solve above technical problem, comprising:
Receive competition data project and marking data items;
Set up said competition data project and the corresponding incidence relation of said marking data items;
According to said incidence relation, said competition data project is dressed up competition data project data library file with marking data project team;
Generate subtitle file according to said competition data project data library file.
Simultaneously, the present invention also provides in a kind of marking system database dynamic to call generation system, comprise, and receiving element, the unit is set up in association, the database generation unit, the marking data generating unit, the subtitle file generation unit, wherein,
Said receiving element is used to receive competition data project and marking data items;
The unit is set up in said association, is used to set up said competition data project and the corresponding incidence relation of said marking data items;
Said database generation unit is used for according to said incidence relation, and said competition data project is dressed up competition data project data library file with marking data project team;
Said subtitle file generation unit is used for generating subtitle file according to said competition data project data library file.
Compared with prior art, the embodiment of the invention has the following advantages: through reading the marking data file at the marking server end, read in the competition data project; With marking data docuterm set up related, and be associated in the database according to these data related with the foundation of source data item order, thereby former data structure is expanded; Therefore; Need need not set up be used to the to give a mark processing of data of different databases to different marking systems, simultaneously, owing to carried out the expansion of data field targetedly; Therefore do not enlarge former database scale, improved system stability, reduced the operating cost of system.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art; To do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below; Obviously, the accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills; Under the prerequisite of not paying creative work property, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1: be a kind of marking system configuration composition diagram in the embodiment of the invention;
Fig. 2: be in the embodiment of the invention in a kind of system that gives a mark database dynamic call the flow chart of generation method;
Fig. 3: be in the embodiment of the invention in a kind of system that gives a mark database dynamic call the sketch map of generation system.
Embodiment
To combine the accompanying drawing in the embodiment of the invention below, the technical scheme in the embodiment of the invention is carried out clear, intactly description, obvious described embodiment is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills are not making the every other embodiment that is obtained under the creative work prerequisite, all belong to the scope of the present invention's protection.
Provide in a kind of marking system database dynamic to call the generation method in the embodiment of the invention 1; As shown in Figure 2, the system that gives a mark in the present embodiment comprises at least: the network switch, marking input, server and database; Said marking data terminal, server and said database are connected with the said network switch; Said marking data termination is received according to the marking data items and is received the marking data, comprises marking input database file in the said database, comprises said marking data items in the said marking input database file; As shown in Figure 1, specifically comprise:
S101: receive competition data project and marking data items;
This step is specially: from the marking system marking device termination receive on-the-spot competition data, the content of described competition data project be the elementary item in the database, called by unified in the marking server as basic data items information; As: essential information that player information, player number and player's ratio grades; Need to prove that this marking data items is already present in the database in system, and the competition data project is not have in the former database; And according to the needs of various matches and information; The extra interpolation of needs, because the title of multiple match inning information can appear in the existing match usually, such as: 10 advance 8 or 6 advances 3; This type of information is not easy to add at any time in database, and as adding the service efficiency that also can influence database at any time.
S102: it is related to set up the marking data;
This step is specially: set up said competition data project and the corresponding incidence relation of said marking data items; Field according in the competition data project information of marking data project information in the former database and reception is set up incidence relation, thereby confirms the outside competition data project that receives and the data relationship of available data project.
S103: generate database file;
This step is specially: according to said incidence relation, said competition data project is dressed up competition data project data library file with marking data project team; The marking data items that in this step, will give a mark in data items and the available data storehouse according to the relation in step S102, obtained is spliced into new database file.
S104: generate subtitle file;
This step is specially: generate subtitle file according to said competition data project data library file.
Provide in the another kind of marking system database dynamic to call the generation method in the embodiment of the invention 2; Comprise in the said marking system: the network switch, marking input, server and database; Said marking data terminal, server and said database are connected with the said network switch; Said marking data termination is received according to the marking data items and is received the marking data, comprises marking input database file in the said database, comprises said marking data items in the said marking input database file; The said network switch specifically comprises: cable network switch and/or wireless network switch specifically comprise:
S201: receive competition data project and marking data items; The competition data project specifically comprises described in this step: player information and earlier rounds project; At least comprise player information in the said marking data items.
S202: set up said competition data project and the corresponding incidence relation of said marking data items; This step also specifically comprises: according to the said player information in said player information and the said marking data items, it is related to set up the earlier rounds data items.
S203:, said competition data project is dressed up competition data project data library file with marking data project team according to said incidence relation; Also further step specifically comprises; Receive the score statistical function; Obtain the score statistics according to said marking data items and said score statistical function; According to said score statistics said marking data items is appended acquisition statistics marking data items; Related according to the said earlier rounds data items of setting up, said competition data project is dressed up competition data project data library file with marking data project team.
Can there be multiple mode in application for real data, can generate database through calculating unified synthetic mode respectively, such as statistics that can be through obtaining to the input data, through the input data, and competition data synthesize the back acquisition.
S204: generate subtitle file according to said marking data.
After above step, also specifically comprise: in broadcast control system, carry out captions and play according to said subtitle file.
Provide in a kind of marking system database dynamic to call generation system in the embodiment of the invention 3; As shown in Figure 3; Comprise in the said marking system: the network switch, marking input, server and database; Said marking data terminal, server and said database are connected with the said network switch, and said marking data termination is received according to the marking data items and received the marking data, comprise marking input database file in the said database; Comprise said marking data items in the said marking input database file, the said network switch specifically comprises: cable network switch and/or wireless network switch.
Specifically comprise, receiving element 301, unit 302 is set up in association, database generation unit 303, subtitle file generation unit 304, wherein,
Said receiving element 301 is used to receive competition data project and marking data items; Said competition data project specifically comprises: player information and earlier rounds project; At least comprise player information in the said marking data items.
Unit 302 is set up in said association, is used to set up said competition data project and the corresponding incidence relation of said marking data items; Said association is set up unit 302 and is also specifically comprised earlier rounds associative cell 3021; Wherein, Said earlier rounds associative cell 3021 is used for the said player information according to said player information and said marking data items, and it is related to set up the earlier rounds data items.
Said database generation unit 303 is used for according to said incidence relation, and said competition data project is dressed up competition data project data library file with marking data project team;
Said database generation unit 303 also comprises statistics synthesis unit 3031, and said statistics synthesis unit 3031 is used to receive the score statistical function; Obtain the score statistics according to said marking data items and said score statistical function; According to said score statistics said marking data items is appended acquisition statistics marking data items; Related according to the said earlier rounds data items of setting up, said competition data project is dressed up competition data project data library file with marking data project team.
Said subtitle file generation unit 304 is used for generating subtitle file according to said competition data project data library file.
Native system also comprises simultaneously, broadcast unit 305, and said broadcast unit is used for carrying out captions at broadcast control system according to said subtitle file and plays.
Through the description of above execution mode, those skilled in the art can be well understood to the present invention and can realize through hardware, also can realize by the mode that software adds necessary general hardware platform.Based on such understanding; Technical scheme of the present invention can be come out with the embodied of software product, this software product can be stored in a non-volatile memory medium (can be CD-ROM, USB flash disk; Portable hard drive etc.) in; Comprise some instructions with so that computer equipment (can be personal computer, server, the perhaps network equipment etc.) carry out the described method of each embodiment of the present invention.
It will be appreciated by those skilled in the art that accompanying drawing is the sketch map of a preferred embodiment, module in the accompanying drawing or flow process might not be that embodiment of the present invention is necessary.
It will be appreciated by those skilled in the art that the module in the device among the embodiment can be distributed in the device of embodiment according to the embodiment description, also can carry out respective change and be arranged in the one or more devices that are different from present embodiment.The module of the foregoing description can be merged into a module, also can further split into a plurality of submodules.
The invention described above embodiment sequence number is not represented the quality of embodiment just to description.
More than disclosedly be merely several specific embodiment of the present invention, still, the present invention is not limited thereto, any those skilled in the art can think variation all should fall into protection scope of the present invention.
Claims (10)
1. database dynamic is called the generation method in the marking system, it is characterized in that, comprising:
Receive competition data project and marking data items;
Set up said competition data project and the corresponding incidence relation of said marking data items;
According to said incidence relation, said competition data project is dressed up competition data project data library file with marking data project team;
Generate subtitle file according to said competition data project data library file.
2. the method described in claim 1 is characterized in that, said competition data project specifically comprises: player information and earlier rounds project; At least comprise player information in the said marking data items.
3. the method described in claim 2 is characterized in that, said foundation in the said competition data project incidence relation step corresponding with said marking data items specifically comprises:
According to the said player information in said player information and the said marking data items, it is related to set up the earlier rounds data items.
4. the method described in claim 3 is characterized in that, and is said according to said incidence relation, said competition data project dressed up competition data project data library file step with marking data project team specifically comprise;
Receive the score statistical function;
Obtain the score statistics according to said marking data items and said score statistical function;
According to said score statistics said marking data items is appended acquisition statistics marking data items;
Related according to the said earlier rounds data items of setting up, said competition data project is dressed up competition data project data library file with marking data project team.
5. the method described in claim 1 is characterized in that, and is said according to also specifically comprising after the said competition data project data library file generation subtitle file step:
In broadcast control system, carrying out captions according to said subtitle file plays.
6. database dynamic is called generation system in the marking system, it is characterized in that, comprise, and receiving element, the unit is set up in association, the database generation unit, the subtitle file generation unit, wherein,
Said receiving element is used to receive competition data project and marking data items;
The unit is set up in said association, is used to set up said competition data project and the corresponding incidence relation of said marking data items;
Said database generation unit is used for according to said incidence relation, and said competition data project is dressed up competition data project data library file with marking data project team;
Said subtitle file generation unit is used for generating subtitle file according to said competition data project data library file.
7. the system described in claim 6 is characterized in that, said competition data project specifically comprises: player information and earlier rounds project;
At least comprise player information in the said marking data items.
8. the system described in claim 7 is characterized in that, said association is set up the unit and also specifically comprised the earlier rounds associative cell, wherein,
Said earlier rounds associative cell is used for the said player information according to said player information and said marking data items, and it is related to set up the earlier rounds data items.
9. the system described in claim 6 is characterized in that, said database generation unit also comprises the statistics synthesis unit, and said statistics synthesis unit is used to receive the score statistical function; Obtain the score statistics according to said marking data items and said score statistical function; According to said score statistics said marking data items is appended acquisition statistics marking data items; Related according to the said earlier rounds data items of setting up, said competition data project is dressed up competition data project data library file with marking data project team.
10. the system described in claim 6 is characterized in that, also comprise, and broadcast unit, said broadcast unit is used for carrying out captions at broadcast control system according to said subtitle file and plays.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110318199.9A CN102752553B (en) | 2011-10-19 | 2011-10-19 | The dynamic call generation method and system of database in a kind of scoring system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110318199.9A CN102752553B (en) | 2011-10-19 | 2011-10-19 | The dynamic call generation method and system of database in a kind of scoring system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102752553A true CN102752553A (en) | 2012-10-24 |
| CN102752553B CN102752553B (en) | 2018-05-04 |
Family
ID=47032434
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110318199.9A Expired - Fee Related CN102752553B (en) | 2011-10-19 | 2011-10-19 | The dynamic call generation method and system of database in a kind of scoring system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102752553B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104301632A (en) * | 2014-06-16 | 2015-01-21 | 大连三通科技发展有限公司 | Rapid manufacturing system and method for golf game caption |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101296322A (en) * | 2007-04-27 | 2008-10-29 | 新奥特硅谷视频技术有限责任公司 | Sports event logging system |
| CN102088566A (en) * | 2009-12-03 | 2011-06-08 | 新奥特（北京）视频技术有限公司 | Method and device for playing television graphic and text subtitles with special effects |
| CN102098454A (en) * | 2009-12-09 | 2011-06-15 | 新奥特（北京）视频技术有限公司 | Real-time caption broadcasting system and method |
| CN102196193A (en) * | 2010-03-15 | 2011-09-21 | 新奥特（北京）视频技术有限公司 | Method for realizing caption broadcasting of various ball games |
| CN102722513A (en) * | 2011-12-30 | 2012-10-10 | 新奥特（北京）视频技术有限公司 | Method for separating match field data |
| CN102724445A (en) * | 2011-09-28 | 2012-10-10 | 新奥特（北京）视频技术有限公司 | Method and system for instant generation of competitive game information |
-
2011
- 2011-10-19 CN CN201110318199.9A patent/CN102752553B/en not_active Expired - Fee Related
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101296322A (en) * | 2007-04-27 | 2008-10-29 | 新奥特硅谷视频技术有限责任公司 | Sports event logging system |
| CN102088566A (en) * | 2009-12-03 | 2011-06-08 | 新奥特（北京）视频技术有限公司 | Method and device for playing television graphic and text subtitles with special effects |
| CN102098454A (en) * | 2009-12-09 | 2011-06-15 | 新奥特（北京）视频技术有限公司 | Real-time caption broadcasting system and method |
| CN102196193A (en) * | 2010-03-15 | 2011-09-21 | 新奥特（北京）视频技术有限公司 | Method for realizing caption broadcasting of various ball games |
| CN102724445A (en) * | 2011-09-28 | 2012-10-10 | 新奥特（北京）视频技术有限公司 | Method and system for instant generation of competitive game information |
| CN102722513A (en) * | 2011-12-30 | 2012-10-10 | 新奥特（北京）视频技术有限公司 | Method for separating match field data |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104301632A (en) * | 2014-06-16 | 2015-01-21 | 大连三通科技发展有限公司 | Rapid manufacturing system and method for golf game caption |
| WO2015192746A1 (en) * | 2014-06-16 | 2015-12-23 | 潘重光 | Rapid caption generation system and method for golf game |
| CN104301632B (en) * | 2014-06-16 | 2018-06-22 | 大连三通科技发展有限公司 | Game of golf subtitle quick Fabrication system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102752553B (en) | 2018-05-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103607461A (en) | Information sharing method and cloud server | |
| CN105653167A (en) | Online live broadcast-based information display method and client | |
| CN103096172A (en) | Method and device for displaying recommended programs | |
| CN102800065A (en) | Augmented reality equipment and method based on two-dimensional code identification and tracking | |
| CN106331822A (en) | Method and device for playing multiple videos and electronic equipment | |
| CN106331869A (en) | Video-based picture re-editing method and device | |
| CN102724445A (en) | Method and system for instant generation of competitive game information | |
| CN109147016A (en) | The dynamic effect screen generating method of one kind, device, electronic equipment and storage medium | |
| CN103310001A (en) | Method and device for setting video list | |
| CN105005612B (en) | A kind of acquisition methods and mobile terminal of music file | |
| CN102737083A (en) | Instant competition information editing method and system | |
| CN102752553A (en) | Method and system for dynamic call and generation of data base in grading system | |
| CN104572794A (en) | Method and system for showing network information in a user-friendly manner | |
| CN105047210B (en) | A kind of the striding equipment synchronous method and device of shuffle playlist | |
| CN102750308A (en) | Method for realizing output of multi-language competition data | |
| CN109658525A (en) | Method and device for clearing redundant data in 3D model and electronic equipment | |
| CN102750302A (en) | Method for generating field technology statistics | |
| CN102122524B (en) | System for quickly generating edited list in image-text packaging application | |
| CN108900866A (en) | It is a kind of based on the multi-stage data live broadcast system for melting media service platform | |
| CN106331553A (en) | Video storage method and device and electronic equipment | |
| KR20150059219A (en) | Method for providing music contents and music contents providing system performing thereof | |
| CN102760147A (en) | Method for optimizing competition field database | |
| CN102752530A (en) | Method and system for pushing broadcast control data dynamically in grading system | |
| Albarran | The media and the communication industries: a 21st. century perspective | |
| CN102722508A (en) | Method and system capable of extracting technical statistics from field database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20190321 Address after: 100195 No. 621, 6th floor, No. 1 Building, 131 North West Fourth Ring Road, Haidian District, Beijing Patentee after: Beijing Xinaote Intelligent Sports Innovation Development Co., Ltd. Address before: 100195 new technology building, 49 Wukesong Road, Haidian District, Beijing Patentee before: China Digital Video (Beijing) Limited |
|
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20180504 Termination date: 20201019 |