CN102722513B - A kind of method of in-situ match data separating - Google Patents
A kind of method of in-situ match data separating Download PDFInfo
- Publication number
- CN102722513B CN102722513B CN201110454230.1A CN201110454230A CN102722513B CN 102722513 B CN102722513 B CN 102722513B CN 201110454230 A CN201110454230 A CN 201110454230A CN 102722513 B CN102722513 B CN 102722513B
- Authority
- CN
- China
- Prior art keywords
- user
- unit
- relation
- match
- 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
Landscapes
- Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of method of in-situ match data separating, specifically include：Receive multiple schedules relation units；User's match relation unit is chosen from multiple schedules relation units；The user-association relation of the schedules relation unit associated with the unit is obtained according to user's match relation unit；Separate customer relationship unit and obtain separation relation unit with other match associative cells；User is received to compete substantially unit；Unit of being competed substantially according to user determines the input block of the separation relation unit；And user's output unit is obtained according to separation relation unit and the input block；Obtain user's output data；Export user's output data.The present invention solves local site data processing in large database to be influenceed by associated data, and former Database Systems are made the problem of potential safety hazard to be present, reduce spot database processing capacity, add the data processing speed of field data, system operations resource has been saved, has made system that there is more preferable flexibility.
Description
Technical field
The present invention relates to the making of the nemo of athletic competition and competition data to generate, applied to large-scale sports ratio
The on-site data processing of match, more particularly to a kind of method of in-situ match data separating.
Background technology
With the development of television relay technology, there is the weight that more sports event live broadcast class programs progressively turn into TV programme
Part is wanted, the television relay especially for large-scale game has obtained significant progress in recent years, and its development not only relates to
And in television production field, and be widely related in distributed network and mobile field of storage, in Large Physical Games
Large-scale relational database data would generally be used, to make data that there is more preferable flexibility, therefore, inside relational database
Substantial amounts of incidence relation is established, but in above method, because match relational database has larger data capacity, when existing
During the match of field, the safety of field data can be influenceed by other associated datas simultaneously, at the same time, in the physical culture match of live class
During thing is relayed, it is desirable to which life match data have higher accuracy, and therefore, database set-up mode of the prior art is unfavorable
In the data demand of sports event live broadcast.
In inventor realizes process of the present invention, discovery has following defect in the prior art, in the prior art big sport
Race has Large-scale Relational Database system, in relaying process is carried out to life match, periphery data item associated with it, and meeting
The stability of live data is had influence on, meanwhile, local data manipulation can also give overall Large-scale Relational Database system safety
Hidden danger is brought, is unfavorable for timely processing of the system to mass data, while Large-scale Relational Database system safety generation is come uneasy
Total factor.
The content of the invention
For in the prior art the defects of, the present invention solves local site data processing in large database and associated
Data influence, and former Database Systems the problem of potential safety hazard is present.
In order to solve above technical problem the invention provides a kind of method of in-situ match data separating, specifically include：
Multiple schedules relation units are received, the schedules relation unit is made up of input block and output unit；
User's match relation unit is chosen from the multiple schedules relation unit；
The user-association relation of the schedules relation unit associated with the unit is obtained according to user match relation unit；
Separate the customer relationship unit and obtain separation relation unit with other match associative cells；
User is received to compete substantially unit；
The input block of the separation relation unit is determined according to user unit of competing substantially；
And user's output unit is obtained according to the separation relation unit and the input block；
Recover the incidence relation of the separation relation unit and other match associative cells according to the user-association relation,
And according to the incidence relation after recovery, obtain user's output data；
Export the user's output data.
Wherein, the schedules relation unit specifically includes：Centre match unit and unit of always competing.
Wherein, the input block specifically includes：Games results information, match history information.
Wherein, the multiple schedules relation unit steps of reception also specifically include：Receive match database, the games played
It is relevant database according to storehouse；Scheduling information summary sheet is obtained according to the match database；According to scheduling information remittance table
Determine the schedules relation unit.
Wherein, the reception user unit step of competing substantially specifically includes：Receive the basic match database of user；According to
The basic match database of the user obtains user and competed substantially unit.
Wherein, the user that the schedules relation unit associated with the unit is obtained according to user match relation unit
Also specifically included after incidence relation step：According to the user-association Relation acquisition user-association relational file, the user is closed
Connection relational file specifically includes user's match relation unit information.
Wherein, also specifically included after the output user's output data step：Obtained according to the user's output data
Take subtitle file；Broadcast control system plays out according to the subtitle file.
Wherein, also specifically included after the output user's output data step：Receive subtitle template；According to the word
Curtain template plays the subtitle file.
Wherein, also specifically included after the output user's output data step：Generated according to the output data defeated
Go out database.
Wherein, also specifically included after the generation output database step according to the output data：Receive match index
Condition；Output database index is generated according to the match index condition, obtains indexed results；According to the indexed results
Subtitle file is produced, broadcast control system is broadcasted according to the subtitle file.
Compared with prior art, the embodiment of the present invention has advantages below：, will by the reading to database relation of competing
Spot database and related information are separated with former Database Systems, and spot database is operated in the case of data separating
Processing, described incidence relation restoring scene database and former Database Systems when being separated before basis after processing terminates
Association, so as to reduce the volume of spot database, due to dividing in in-situ match data handling procedure with former Database Systems
From, therefore will not be influenceed by former Database Systems, security and the flexibility of in-situ match database are ensure that, so as to contract
Small spot database processing capacity, while the data integrity of former Database Systems is ensure that, while input is not increased,
The data processing speed of field data is added, has saved system operations resource, makes system that there is more preferable flexibility.
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 the required accompanying drawing used 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 accompanying drawings according to these accompanying drawings.
Fig. 1：It is a kind of schematic diagram of the method for in-situ match data separating in the embodiment of the present invention 1；
Fig. 2：It is the schematic diagram of the method for another in-situ match data separating in the embodiment of the present invention 2.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme 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, rather than whole embodiments.Based on the present invention
In embodiment, the every other implementation that those of ordinary skill in the art are obtained under the premise of creative work is not made
Example, belongs to the scope of protection of the invention.
A kind of method of in-situ match data separating is provided in the embodiment of the present invention 1, as shown in figure 1, including following step
Suddenly：
S101：Receive multiple schedules relation units；
This step specifically includes：Multiple schedules relation units are received, the schedules relation unit is by input block and output
Unit forms；
S102：Choose user's match relation unit；
This step specifically includes：User's match relation unit is chosen from the multiple schedules relation unit；
S103：Obtain the user-association relation of schedules relation unit；
This step specifically includes：The schedules relation unit associated with the unit is obtained according to user match relation unit
User-association relation；
S104：Obtain separation relation unit；
This step specifically includes：Separate the customer relationship unit and obtain separation relation list with other match associative cells
Member；
S105：User is received to compete substantially unit；
S106：Determine the input block of separation relation unit；
This step specifically includes：The input list of the separation relation unit is determined according to user unit of competing substantially
Member；
S107：Obtain user's output unit；
This step specifically includes：And user's output unit is obtained according to the separation relation unit and the input block；
S108：Obtain user's output data；
This step specifically includes：Recover the separation relation unit according to the user-association relation to associate with other matches
The incidence relation of unit, and according to the incidence relation after recovery, obtain user's output data；
S109：Export the user's output data.
The method that another in-situ match data separating is provided in the embodiment of the present invention 2, as shown in Fig. 2 including following
Step：
S201：Receive multiple schedules relation units；
This step specifically includes：Multiple schedules relation units are received, the schedules relation unit is by input block and output
Unit forms；
The schedules relation unit specifically includes：Centre match unit and unit of always competing；
The input block specifically includes：Games results information, match history information；
The multiple schedules relation unit steps of reception also specifically include：Receive match database, the match database
For relevant database；Scheduling information summary sheet is obtained according to the match database；Determined according to scheduling information remittance table
The schedules relation unit；
S202：Choose user's match relation unit；
This step specifically includes：User's match relation unit is chosen from the multiple schedules relation unit；
S203：Obtain the user-association relation of schedules relation unit；
This step specifically includes：The schedules relation unit associated with the unit is obtained according to user match relation unit
User-association relation；
S204：Obtain user-association relational file；
This step specifically includes：It is described that the schedules relation associated with the unit is obtained according to user match relation unit
Also specifically included after the user-association relationship step of unit：According to the user-association Relation acquisition user-association relational file,
The user-association relational file specifically includes user's match relation unit information；
S205：Obtain separation relation unit；
This step specifically includes：Separate the customer relationship unit and obtain separation relation list with other match associative cells
Member；
S206：User is received to compete substantially unit；
This step specifically includes：The reception user unit step of competing substantially specifically includes：User is received to compete substantially
Database；User is obtained according to the basic match database of the user to compete substantially unit；
S207：Determine the input block of separation relation unit；
This step specifically includes：The input list of the separation relation unit is determined according to user unit of competing substantially
Member；
S208：Obtain user's output unit；
This step specifically includes：And user's output unit is obtained according to the separation relation unit and the input block；
S209：Obtain user's output data；
This step specifically includes：Recover the separation relation unit according to the user-association relation to associate with other matches
The incidence relation of unit, and according to the incidence relation after recovery, obtain user's output data；
S210：Export the user's output data；
This step specifically includes：Also specifically included after the output user's output data step：Receive subtitle template；
The subtitle file is played according to the subtitle template；
Also specifically included after the output user's output data step：Output data is generated according to the output data
Storehouse；
Also specifically included after the generation output database step according to the output data：
Receive match index condition；
Output database index is generated according to the match index condition, obtains indexed results；
Subtitle file is produced according to the indexed results, broadcast control system is broadcasted according to the subtitle file；
S211：Obtain subtitle file and play out；
This step specifically includes：Also specifically included after the output user's output data step：According to the user
Output data obtains subtitle file；Broadcast control system plays out according to the subtitle file.
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 scheme can be embodied in the form of software product, and the software product 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 causing 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 accompanying drawing is the schematic diagram of a preferred embodiment, module or stream in accompanying 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. method of in-situ match data separating, it is characterised in that including：Multiple schedules relation units are received, the schedules relation unit is made up of input block and output unit；User's match relation unit is chosen from the multiple schedules relation unit；The user-association relation of the schedules relation unit associated with the unit is obtained according to user match relation unit；Separate customer relationship unit and obtain separation relation unit with other match associative cells；User is received to compete substantially unit；The input block of the separation relation unit is determined according to user unit of competing substantially；And user's output unit is obtained according to the separation relation unit and the input block；Recover the incidence relation of the separation relation unit and other match associative cells, and root according to the user-association relation According to the incidence relation after recovery, user's output data is obtained；Export the user's output data.
- 2. method as described in claim 1, it is characterised in that the schedules relation unit specifically includes：Centre match is single Member and unit of always competing.
- 3. the method as described in claim 1 or 2, it is characterised in that the input block specifically includes：Games results are believed Breath, match history information.
- 4. method as described in claim 1, it is characterised in that the multiple schedules relation unit steps of reception are also specifically wrapped Include：Match database is received, the match database is relevant database；Scheduling information summary sheet is obtained according to the match database；The schedules relation unit is determined according to the scheduling information remittance table.
- 5. method as described in claim 1, it is characterised in that the reception user unit step of competing substantially is specifically wrapped Include：Receive the basic match database of user；User is obtained according to the basic match database of the user to compete substantially unit.
- 6. method as described in claim 1, it is characterised in that described that relation unit acquisition is competed with being somebody's turn to do according to the user Also specifically included after the user-association relationship step of the schedules relation unit of unit association：According to the user-association Relation acquisition User-association relational file, the user-association relational file specifically include user's match relation unit information.
- 7. method as described in claim 1, it is characterised in that also specific after the output user's output data step Including：Subtitle file is obtained according to the user's output data；Broadcast control system plays out according to the subtitle file.
- 8. method as described in claim 7, it is characterised in that also specific after the output user's output data step Including：Receive subtitle template；The subtitle file is played according to the subtitle template.
- 9. method as described in claim 1, it is characterised in that also specific after the output user's output data step Including：Output database is generated according to the output data.
- 10. method as described in claim 9, it is characterised in that described that output database is generated according to the output data Also specifically included after step：Receive match index condition；Output database index is generated according to the match index condition, obtains indexed results；Subtitle file is produced according to the indexed results, broadcast control system is broadcasted according to the subtitle file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110454230.1A CN102722513B (en) | 2011-12-30 | 2011-12-30 | A kind of method of in-situ match data separating |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110454230.1A CN102722513B (en) | 2011-12-30 | 2011-12-30 | A kind of method of in-situ match data separating |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102722513A CN102722513A (en) | 2012-10-10 |
| CN102722513B true CN102722513B (en) | 2017-12-12 |
Family
ID=46948277
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110454230.1A Expired - Fee Related CN102722513B (en) | 2011-12-30 | 2011-12-30 | A kind of method of in-situ match data separating |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102722513B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102752553B (en) * | 2011-10-19 | 2018-05-04 | 新奥特（北京）视频技术有限公司 | The dynamic call generation method and system of database in a kind of scoring system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101261703A (en) * | 2008-03-20 | 2008-09-10 | 姚武杰 | Competition management system and method based on network |
| CN101268639A (en) * | 2005-07-22 | 2008-09-17 | 袋鼠传媒股份有限公司 | System and methods for enhancing the experience of spectators atttending a live sporting event |
| CN101296322A (en) * | 2007-04-27 | 2008-10-29 | 新奥特硅谷视频技术有限责任公司 | Sports event logging system |
| CN102118569A (en) * | 2009-12-30 | 2011-07-06 | 新奥特（北京）视频技术有限公司 | Processing method and processing device for public data in caption broadcasting |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8521732B2 (en) * | 2008-05-23 | 2013-08-27 | Solera Networks, Inc. | Presentation of an extracted artifact based on an indexing technique |
-
2011
- 2011-12-30 CN CN201110454230.1A patent/CN102722513B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101268639A (en) * | 2005-07-22 | 2008-09-17 | 袋鼠传媒股份有限公司 | System and methods for enhancing the experience of spectators atttending a live sporting event |
| CN101296322A (en) * | 2007-04-27 | 2008-10-29 | 新奥特硅谷视频技术有限责任公司 | Sports event logging system |
| CN101261703A (en) * | 2008-03-20 | 2008-09-10 | 姚武杰 | Competition management system and method based on network |
| CN102118569A (en) * | 2009-12-30 | 2011-07-06 | 新奥特（北京）视频技术有限公司 | Processing method and processing device for public data in caption broadcasting |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102722513A (en) | 2012-10-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107644085B (en) | Method and device for generating sports event news | |
| CN106162223B (en) | News video segmentation method and device | |
| CN106454431B (en) | TV programme suggesting method and system | |
| CN102547433A (en) | Method and device for interactive comments based on play time points | |
| CN107682717A (en) | Service recommendation method, device, equipment and storage medium | |
| CN105528432B (en) | A kind of digital resource hot spot generation method and device | |
| CN102402536A (en) | Method and equipment for extracting key frame from video | |
| CN102722513B (en) | A kind of method of in-situ match data separating | |
| CN112749834A (en) | Method for predicting suitable habitat of ginkgo fruit forest based on climate and soil factors | |
| CN106375835A (en) | Streaming media playing method and device | |
| Lie et al. | SM entertainment and soo man lee | |
| JP2019213038A (en) | Video information providing system | |
| CN102752233A (en) | Method and system for carrying out remote information prompting on sports competitions | |
| CN102760147A (en) | Method for optimizing competition field database | |
| CN105049940B (en) | A kind of method for counting theme temperature, the method for pushing and device of program | |
| CN102750303B (en) | A kind of relation clone method of in-situ match relational database | |
| CN107577808A (en) | A kind of method, apparatus, server and the medium of multistage list page sequence | |
| CN102752553B (en) | The dynamic call generation method and system of database in a kind of scoring system | |
| CN102752529B (en) | A kind of synchronism output method and system of in-situ match data acquisition | |
| CN102752541B (en) | A kind of generation method of in-situ match subtitle | |
| CN102722510B (en) | A kind of method that the heterogeneous database of on-site score processing system is shared | |
| CN104735125A (en) | Entertainment data synchronous method of in-car entertainment system | |
| CN102743853B (en) | A kind of method and system of athletic competition score generation backup | |
| Wang et al. | Divergent abiotic stressors drive grassland community assembly of tibet and Mongolia Plateau | |
| CN102737085B (en) | A kind of method of competition data structure optimization |
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 | ||
| 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: 20171212 Termination date: 20171230 |