CN102752553B - The dynamic call generation method and system of database in a kind of scoring system - Google Patents
The dynamic call generation method and system of database in a kind of scoring system Download PDFInfo
- Publication number
- CN102752553B CN102752553B CN201110318199.9A CN201110318199A CN102752553B CN 102752553 B CN102752553 B CN 102752553B CN 201110318199 A CN201110318199 A CN 201110318199A CN 102752553 B CN102752553 B CN 102752553B
- Authority
- CN
- China
- Prior art keywords
- project
- data
- competition
- marking
- database
- 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
Abstract
The invention discloses a kind of dynamic call generation method of database in scoring system, including：Receive competition data project and marking data items；Establish competition data project incidence relation corresponding with the marking data items；According to the incidence relation, the competition data project and marking data project team are dressed up into competition data project data library file；According to the competition data project database file generated subtitle file, the present invention solves in scoring system and database structure is adjusted into Mobile state by server of giving a mark, and needed for generating the problem of data, different scoring systems, which need not be directed to, to be needed to establish the processing that different databases is used to carry out marking data, therefore without original database scale is expanded, improve the stability of system, reduce the operating cost of system.
Description
Technical field
Relay the present invention relates to athletic competition, in live marking class program making field, counted applied to athletic competition scene
The calling of divided data and processing, the dynamic call generation method and system of database in more particularly to a kind of scoring system.
Background technology
With the development of television relay technology, live telecast class program becomes the important component of TV programme, especially
Be for give a mark class television relay obtained significant progress in recent years, its development is directed not only in TV domain, and
Widely be related in distributed network and mobile field of storage, athletic competition or marking class program it is live during, lead to
It is normal to need to carry out field data scene processing immediately, since different marking class programs is regular there are different marking,
Need to be directed to the different scoring system of different contest show customizations in the prior art, for meeting wanting for different athletic competitions
Ask, in the prior art in order to make the data processing of the above more flexible, also generally select the number for setting up " maximization " in systems
The problem of according to library structure, being chosen wherein according to the actual needs of user, but using above method is, for needing
Compared with the marking class program of small data quantity, it would be desirable to large-scale database file is run, for meeting wanting for live scoring system
To ask, not only cause the waste of system resource, the used time adds the input cost of TV programme, meanwhile, for relaying live class
Program is in order to ensure the high reliability relayed live, and therefore, the data processing for scene is also same while needing flexible
When ensure it is reliable.
In inventor realizes process of the present invention, discovery has following defect in the prior art, in the prior art field data
The generation of library structure project needs particularly to be customized with renewal, needs different database knots for different score programs
Structure, therefore, to the limited flexibility of database structure project adjustment, meanwhile, large-scale Database Systems are such as built, due to usual
Only local data bank is applied, this improves the operating cost of system, causes the waste of system resource.
The content of the invention
For in the prior art the defects of, the present invention is solved in scoring system by server of giving a mark to database structure
Adjusted into Mobile state, and needed for generation the problem of data.
In order to solve dynamic call generation side of the above technical problem the present invention provides database in a kind of scoring system
Method, including：
Receive competition data project and marking data items；
Establish competition data project incidence relation corresponding with the marking data items；
According to the incidence relation, the competition data project and marking data project team are dressed up into competition data item number
According to library file；
According to the competition data project database file generated subtitle file.
Meanwhile the present invention also provides a kind of dynamic call generation system of database in scoring system, including, receive single
Member, associates and establishes unit, database generation unit, data generating unit of giving a mark, subtitle file generation unit, wherein,
The receiving unit, for receiving competition data project and marking data items；
Unit is established in the association, for establishing competition data project association corresponding with the marking data items
Relation；
The database generation unit, for according to the incidence relation, by the competition data project and marking data
Project is assembled into competition data project data library file；
The subtitle file generation unit, for according to the competition data project database file generated subtitle file.
Compared with prior art, the embodiment of the present invention has the following advantages：Graded by being read in marking server end
According to file, competition data project is read in, establishes and associates with marking data docuterm, and according to this data correlation in the database
Establish and associate with source data item mesh, so as to be extended former data structure, therefore, there is no need to need for different scoring systems
The processing that different databases is used to carry out marking data is established, simultaneously as targetedly having carried out data field
Expand, therefore without original database scale is expanded, improve the stability of system, reduce the operating cost of system.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is attached drawing needed in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, without having to pay creative labor, may be used also
To obtain other attached drawings according to these attached drawings.
Fig. 1：It is a kind of scoring system structure composition figure in the embodiment of the present invention；
Fig. 2：It is a kind of flow chart of the dynamic call generation method of database in scoring system in the embodiment of the present invention；
Fig. 3：It is a kind of schematic diagram of the dynamic call generation system of database in scoring system in the embodiment of the present invention.
Embodiment
Below in conjunction with the attached drawing in the embodiment of the present invention, the technical solution in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is part of the embodiment of the present invention, instead of all the embodiments.Based on the present invention
In embodiment, the every other implementation that those of ordinary skill in the art are obtained without creative efforts
Example, belongs to the scope of protection of the invention.
A kind of dynamic call generation method of database in scoring system is provided in the embodiment of the present invention 1, such as Fig. 1 institutes
Show, in the present embodiment scoring system, include at least：The network switch, marking input terminal, server and database, it is described to beat
Divided data end, server and the database are connected with the network switch, and the marking data end receives basis and grades
Marking data are received according to project, the database includes input data library file of giving a mark, the marking input data library file
Include the marking data items, as shown in Fig. 2, specifically including：
S101：Receive competition data project and marking data items；
This step is specially：Life match data, the competition data project are received from the scoring device end of scoring system
Content and be elementary item in database, as basic data items information in server of giving a mark by unified call,
Such as：Player information, player's numbering and player are than essential information of grading, it is necessary to which explanation, this marking data items is in system
It is already present in middle database, and competition data project is that do not have in original database, and according to various matches and the needs of information,
Need what is additionally added, since the title of a variety of match inning information usually occurring in existing match, such as：10 into 8 or 6
Into 3, this type of information is not easy to add at any time in the database, and such as adds the service efficiency that can also influence database at any time.
S102：Establish marking data correlation；
This step is specially：Establish competition data project incidence relation corresponding with the marking data items；Root
Incidence relation is established according to the marking data project information in original database and the field in the competition data project information of reception, from
And determine the competition data project of external reception and the data relationship of available data project.
S103：Generate database file；
This step is specially：According to the incidence relation, the competition data project and marking data project team are dressed up
Competition data project data library file；In this step according to acquired relation in step s 102 will give a mark data items and
Marking data items in existing database are spliced into new database file.
S104：Generate subtitle file；
This step is specially：According to the competition data project database file generated subtitle file.
The dynamic call generation method of database in another scoring system is provided in the embodiment of the present invention 2, it is described to beat
Subsystem includes：The network switch, marking input terminal, server and database, the marking data terminal, server and described
Database is connected with the network switch, and the marking data end is received receives marking data, institute according to marking data items
Stating database includes input data library file of giving a mark, and the marking input data library file includes the marking data item
Mesh, the network switch specifically include：Cable network interchanger and/or wireless network switch, specifically include：
S201：Receive competition data project and marking data items；Competition data project specifically includes described in this step：
Player information and earlier rounds project；Player information is included at least in the marking data items.
S202：Establish competition data project incidence relation corresponding with the marking data items；This step also has
Body includes：According to the player information and the player information in the marking data items, earlier rounds data item is established
Mesh associates.
S203：According to the incidence relation, the competition data project and marking data project team are dressed up into competition data
Project data library file；Can also further step it specifically include；Receive score statistical function；According to it is described marking data items and
The score statistical function obtains score statistical result；The marking data items are added according to the score statistical result and are obtained
Marking data items must be counted；The association of earlier rounds data items is established according to described, by the competition data project and marking
Data items are assembled into competition data project data library file.
Application for real data may have various ways, can by way of calculating unified synthesis respectively logarithm
Generated according to storehouse, than being closed such as by the statistics and competition data that are obtained to input data, by input data
Into rear acquisition.
S204：According to the marking data generation subtitle file.
Also specifically included after above step：Subtitle broadcasting is carried out according to the subtitle file in broadcast control system.
A kind of dynamic call generation system of database in scoring system is provided in the embodiment of the present invention 3, such as Fig. 3 institutes
Show, the scoring system includes：The network switch, marking input terminal, server and database, the marking data terminal, clothes
Business device and the database are connected with the network switch, and the marking data end receives to be received according to marking data items and beats
Divided data, the database include input data library file of giving a mark, and the marking input data library file includes described beat
Divided data project, the network switch specifically include：Cable network interchanger and/or wireless network switch.
Specifically include, receiving unit 301, unit 302, database generation unit 303, subtitle file generation list are established in association
Member 304, wherein,
The receiving unit 301, for receiving competition data project and marking data items；The competition data project tool
Body includes：Player information and earlier rounds project；Player information is included at least in the marking data items.
Unit 302 is established in the association, corresponding with the marking data items for establishing the competition data project
Incidence relation；The association establishes unit 302 and also specifically includes earlier rounds associative cell 3021, wherein, the earlier rounds
Associative cell 3021, for according to the player information and the player information in the marking data items, establishing match
Round data items associate.
The database generation unit 303, for according to the incidence relation, by the competition data project and grading
Competition data project data library file is assembled into according to project；
The database generation unit 303 further includes statistics synthesis unit 3031, the statistics synthesis unit
3031, for receiving score statistical function；Score statistics is obtained according to the marking data items and the score statistical function
As a result；The marking data items are added according to the score statistical result and obtain statistics marking data items；According to described
The association of earlier rounds data items is established, the competition data project and marking data project team are dressed up into competition data item number
According to library file.
The subtitle file generation unit 304, for according to competition data project database file generated subtitle text
Part.
At the same time the system further include, broadcast unit 305, the broadcast unit, in broadcast control system according to the word
Curtain file carries out subtitle broadcasting.
Through the above description of the embodiments, those skilled in the art can be understood that the present invention can lead to
Hardware realization is crossed, the mode of necessary general hardware platform can also be added by software to realize.Based on such understanding, this hair
Bright technical solution can be embodied in the form of software product, which can be stored in a non-volatile memories
In medium (can be CD-ROM, USB flash disk, mobile hard disk etc.), including some instructions are used so that a computer equipment (can be
Personal computer, server, or network equipment etc.) perform method described in each embodiment of the present invention.
It will be appreciated by those skilled in the art that attached drawing is the schematic diagram of a preferred embodiment, module or stream in attached drawing
Journey is not necessarily implemented necessary to the present invention.
It will be appreciated by those skilled in the art that the module in device in embodiment can describe be divided according to embodiment
It is distributed in the device of embodiment, respective change can also be carried out and be disposed other than in one or more devices of the present embodiment.On
The module for stating embodiment can be merged into a module, can also be further split into multiple submodule.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
Disclosed above is only several specific embodiments of the present invention, and still, the present invention is not limited to this, any ability
What the technical staff in domain can think change should all fall into protection scope of the present invention.
Claims (10)
- A kind of 1. dynamic call generation method of database in scoring system, it is characterised in that including：Receive competition data project and marking data items；Establish competition data project incidence relation corresponding with the marking data items；According to the incidence relation, the competition data project and marking data project team are dressed up into competition data project database File；According to the competition data project database file generated subtitle file.
- 2. method as described in claim 1, it is characterised in that the competition data project specifically includes：Player information and Earlier rounds project；Player information is included at least in the marking data items.
- 3. method as described in claim 2, it is characterised in that described to establish the competition data project and grade with described According to being specifically included in the corresponding incidence relation step of project：Player information in the competition data project and the player information in the marking data items, establish match wheel Secondary data item association.
- 4. method as described in claim 3, it is characterised in that it is described according to the incidence relation, by the competition data Project and marking data project team dress up competition data project database Files step and specifically include；Receive score statistical function；Score statistical result is obtained according to the marking data items and the score statistical function；The marking data items are added according to the score statistical result and obtain statistics marking data items；The association of earlier rounds data items is established according to described, the competition data project and marking data project team are dressed up into ratio Match data items database file.
- 5. method as described in claim 1, it is characterised in that described to be given birth to according to the competition data project data library file Also specifically included after into subtitle file step：Subtitle broadcasting is carried out according to the subtitle file in broadcast control system.
- 6. the dynamic call generation system of database in a kind of scoring system, it is characterised in that including receiving unit, association is built Vertical unit, database generation unit, subtitle file generation unit, wherein,The receiving unit, for receiving competition data project and marking data items；Unit is established in the association, is closed for establishing competition data project association corresponding with the marking data items System；The database generation unit, for according to the incidence relation, by the competition data project and marking data items It is assembled into competition data project data library file；The subtitle file generation unit, for according to the competition data project database file generated subtitle file.
- 7. system as described in claim 6, it is characterised in that the competition data project specifically includes：Player information and Earlier rounds project；Player information is included at least in the marking data items.
- 8. system as described in claim 7, it is characterised in that the association establishes unit and also specifically includes earlier rounds pass Receipts or other documents in duplicate member, wherein,The earlier rounds associative cell, for the player information in the competition data project and the marking data item Player information in mesh, establishes the association of earlier rounds data items.
- 9. system as described in claim 8, it is characterised in that the database generation unit further includes statistics synthesis Unit, the statistics synthesis unit, for receiving score statistical function；According to the marking data items and the score Statistical function obtains score statistical result；The marking data items are added to obtain to count according to the score statistical result and are beaten Divided data project；The association of earlier rounds data items is established according to described, by the competition data project and marking data items It is assembled into competition data project data library file.
- 10. system as described in claim 6, it is characterised in that further include, broadcast unit, the broadcast unit, for Subtitle broadcasting is carried out according to the subtitle file in broadcast control system.
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 CN102752553A (en) | 2012-10-24 |
| CN102752553B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104301632B (en) * | 2014-06-16 | 2018-06-22 | 大连三通科技发展有限公司 | Game of golf subtitle quick Fabrication system and method |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101296322A (en) * | 2007-04-27 | 2008-10-29 | 新奥特硅谷视频技术有限责任公司 | Sports event logging system |
| CN102088566B (en) * | 2009-12-03 | 2015-09-23 | 新奥特（北京）视频技术有限公司 | A kind of stunt broadcasting method of television graphics context subtitling and device |
| CN102724445A (en) * | 2011-09-28 | 2012-10-10 | 新奥特（北京）视频技术有限公司 | Method and system for instant generation of competitive game information |
| CN102722513B (en) * | 2011-12-30 | 2017-12-12 | 新奥特（北京）视频技术有限公司 | A kind of method of in-situ match data separating |
-
2011
- 2011-10-19 CN CN201110318199.9A patent/CN102752553B/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102752553A (en) | 2012-10-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105100830B (en) | A kind of device and method for being switched fast video source based on video aggregation service | |
| CN103458275A (en) | Real-time interaction digital television information recommendation system and method | |
| CN105501258B (en) | A kind of method for sending information and device | |
| CN108769824A (en) | A kind of video mixed flow method, apparatus, system, equipment and medium | |
| CN110099284A (en) | A kind of generation method fast made a speech, device and server | |
| CN105045578A (en) | Method and apparatus for audio synthesis | |
| CN104883627A (en) | Plot movie and television, and broadcasting device and method thereof | |
| CN108933743A (en) | A kind of method for allocating network flow and device based on DSP | |
| CN110225376B (en) | Interactive video production method and device for advertisement putting | |
| CN106604136A (en) | TV program ratings accurate calculation method and TV program ratings accurate calculation structural system | |
| CN102752553B (en) | The dynamic call generation method and system of database in a kind of scoring system | |
| CN105871989A (en) | Live broadcast video obtaining method and device | |
| CN102724445A (en) | Method and system for instant generation of competitive game information | |
| CN107231440A (en) | A kind of intellectualized LED cloud screen control system and control method | |
| CN104796467A (en) | Method for calculating limitation range of QoS (quality of service) optimal combined services with QoS correlations | |
| CN102737083B (en) | Instant competition information editing method and system | |
| US20190313156A1 (en) | Asynchronous Video Conversation Systems and Methods | |
| CN106131656A (en) | A kind of system and method for quasi real time sectional drawing between net cast | |
| CN109040038A (en) | Determination method, apparatus, equipment and the storage medium of Caton factor | |
| CN102722513B (en) | A kind of method of in-situ match data separating | |
| CN102750303B (en) | A kind of relation clone method of in-situ match relational database | |
| CN109831675B (en) | Activity processing method of live broadcast platform, server and readable storage medium | |
| CN102760147A (en) | Method for optimizing competition field database | |
| CN102743853B (en) | A kind of method and system of athletic competition score generation backup | |
| CN102760148A (en) | Data inquiry method for competition system |
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 |
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 |
|
| TR01 | Transfer of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20180504 Termination date: 20201019 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |