CN102722513A - Method for separating match field data - Google Patents
Method for separating match field data Download PDFInfo
- Publication number
- CN102722513A CN102722513A CN2011104542301A CN201110454230A CN102722513A CN 102722513 A CN102722513 A CN 102722513A CN 2011104542301 A CN2011104542301 A CN 2011104542301A CN 201110454230 A CN201110454230 A CN 201110454230A CN 102722513 A CN102722513 A CN 102722513A
- Authority
- CN
- China
- Prior art keywords
- unit
- user
- match
- relation
- concern
- 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
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 method for separating match field data, and the method comprises the following specific steps of: receiving a plurality of match schedule relation units; selecting a user match relation unit from the plurality of match schedule relation units; acquiring a user correlative relation of a match schedule relation unit related to the user match relation unit according to the user match relation unit; separating the user match relation unit with other match correlative units to acquire a separation relation unit; receiving a user basic match unit; determining an input unit of the separation relation unit according to the user basic match unit; acquiring a user output unit according to the separation relation unit and the input unit; acquiring user output data; and outputting the user output data. By utilizing the method, the problem that an original database system has safety hidden dangers because local field data treatment in a large database is influenced by correlative data is solved, the treatment capacity of a field database is shortened, the data treatment speed of the field data is increased, and system operation resources are saved, so that the system has better flexibility.
Description
Technical field
The making and the competition data that the present invention relates to the nemo of athletic competition generate, and are applied to the on-site data processing of large-scale athletic competition, particularly a kind of method of in-situ match data separating.
Background technology
Along with the development of television relay technology, the important component part, the particularly television relay for large-scale game that have live type of program of more competitive sports progressively to become TV programme have obtained significant progress in recent years; Its development not only relates in the television production field, and relates to widely in distributed network and the mobile storage field, in large-scale competitive sports, can adopt large-scale relation data database data usually; For making data have better dirigibility, therefore, set up a large amount of incidence relations in relational database inside; But in above method, because the match relational database has bigger data capacity, when compete in the scene; The safety of field data can receive the influence of other associated datas simultaneously; Meanwhile, in live type competitive sports are relayed, require on-the-spot competition data to have higher accuracy; Therefore, database set-up mode of the prior art is unfavorable for the data demand that competitive sports are live.
Realize in the process of the present invention the inventor; Finding has following defective in the prior art, and the medium-and-large-sized competitive sports of prior art have large-scale relational database system, and the scene match is being carried out in the relaying process; The peripheral data item related with it; Can have influence on the stability of live data, simultaneously, local data manipulation brings hidden danger also can for whole large-scale relational database system safety; Be unfavorable for the timely processing of system, simultaneously large-scale relational database system safety generation come unsafe factor mass data.
Summary of the invention
To defective of the prior art, the invention solves in the large database local on-site data processing and receive the associated data influence, and make former Database Systems have the problem of potential safety hazard.
In order to solve the method that above technical matters the invention provides a kind of in-situ match data separating, specifically comprise:
Receive a plurality of schedules and concern the unit, said schedules concern that the unit is made up of input block and output unit;
Concern that from said a plurality of schedules choosing the user the unit competes and concern the unit;
Compete according to said user and to concern that the unit obtains user's incidence relation that the schedules related with this unit concern the unit;
Separate said customer relationship unit and other match associative cell acquisition separation relation unit;
Receive the user unit of competing basically;
Confirm the input block of said separation relation unit according to the said user unit of competing basically;
And obtain user's output unit according to said separation relation unit and said input block;
Recover the incidence relation of said separation relation unit and other match associative cells according to said user's incidence relation, and, obtain user's output data according to the incidence relation after recovering;
Export said user's output data.
Wherein, said schedules concern that the unit specifically comprises: middle match unit and total match unit.
Wherein, said input block specifically comprises: games results information, match history information.
Wherein, a plurality of schedules of said reception concern that unit step also specifically comprises: receive match database, said match database is a relevant database; Obtain schedules information summary sheet according to said match database; Confirm that according to said schedules information remittance table said schedules concern the unit.
Wherein, the said reception user unit step of competing basically specifically comprises: receive the basic match database of user; Obtain the user unit of competing basically according to the basic match database of said user.
Wherein, The said match according to said user concerns after the unit obtains user's incidence relation step that the schedules related with this unit concern the unit and also specifically comprise: obtain user's incidence relation file according to said user's incidence relation, said user's incidence relation file comprises specifically that the user competes and concerns unit information.
Wherein, also specifically comprise after the said user's output data of the said output step: obtain subtitle file according to said user's output data; Broadcast control system is play according to said subtitle file.
Wherein, also specifically comprise after the said user's output data of the said output step: receive subtitle template; Play said subtitle file according to said subtitle template.
Wherein, also specifically comprise after the said user's output data of the said output step: generate output database according to said output data.
Wherein, said according to also specifically comprising after the said output data generation output database step: as to receive match index condition; According to the said generation output database of said match index condition index, obtain indexed results; Produce subtitle file according to said indexed results, broadcast control system broadcasts according to said subtitle file.
Compared with prior art, the embodiment of the invention has the following advantages: through to match the reading of database relation, spot database and related information are separated with former Database Systems; Under the situation of data separating, spot database is carried out operational processes; The incidence relation recovery spot database of being put down in writing when before processing finishes the back basis, separating is related with former Database Systems, thereby has dwindled the volume of spot database, owing in the in-situ match data handling procedure, separate with former Database Systems; Therefore can not receive the influence of former Database Systems; Guaranteed in-situ match safeness of Data Bank and dirigibility, handled capacity, guaranteed the data integrity of former Database Systems simultaneously thereby dwindled spot database; When not increasing input; Increased the data processing speed of field data, practiced thrift system's calculation resources, made system have better dirigibility.
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: the synoptic diagram that is a kind of method of in-situ match data separating in the embodiment of the invention 1;
Fig. 2: the synoptic diagram that is the method for another kind of in-situ match data separating in the embodiment of the invention 2.
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.
A kind of method of in-situ match data separating is provided in the embodiment of the invention 1, as shown in Figure 1, may further comprise the steps:
S101: receive a plurality of schedules and concern the unit;
This step specifically comprises: receive a plurality of schedules and concern the unit, said schedules concern that the unit is made up of input block and output unit;
S102: choose the user and compete and concern the unit;
This step specifically comprises: concern that from said a plurality of schedules choosing the user the unit competes and concern the unit;
S103: obtain user's incidence relation that schedules concern the unit;
This step specifically comprises: competing according to said user concerns that the unit obtains user's incidence relation that the schedules related with this unit concern the unit;
S104: obtain the separation relation unit;
This step specifically comprises: separate said customer relationship unit and other match associative cell acquisition separation relation unit;
S105: receive the user unit of competing basically;
S106: the input block of confirming the separation relation unit;
This step specifically comprises: confirm the input block of said separation relation unit according to the said user unit of competing basically;
S107: obtain user's output unit;
This step specifically comprises: and obtain user's output unit according to said separation relation unit and said input block;
S108: obtain user's output data;
This step specifically comprises: recover the incidence relation of said separation relation unit and other match associative cells according to said user's incidence relation, and according to the incidence relation after recovering, obtain user's output data;
S109: export said user's output data.
The method of another kind of in-situ match data separating is provided in the embodiment of the invention 2, as shown in Figure 2, may further comprise the steps:
S201: receive a plurality of schedules and concern the unit;
This step specifically comprises: receive a plurality of schedules and concern the unit, said schedules concern that the unit is made up of input block and output unit;
Said schedules concern that the unit specifically comprises: middle match unit and total match unit;
Said input block specifically comprises: games results information, match history information;
The a plurality of schedules of said reception concern that unit step also specifically comprises: receive match database, said match database is a relevant database; Obtain schedules information summary sheet according to said match database; Confirm that according to said schedules information remittance table said schedules concern the unit;
S202: choose the user and compete and concern the unit;
This step specifically comprises: concern that from said a plurality of schedules choosing the user the unit competes and concern the unit;
S203: obtain user's incidence relation that schedules concern the unit;
This step specifically comprises: competing according to said user concerns that the unit obtains user's incidence relation that the schedules related with this unit concern the unit;
S204: obtain user's incidence relation file;
This step specifically comprises: the said match according to said user concerns after the unit obtains user's incidence relation step that the schedules related with this unit concern the unit and also specifically comprise: obtain user's incidence relation file according to said user's incidence relation, said user's incidence relation file comprises specifically that the user competes and concerns unit information;
S205: obtain the separation relation unit;
This step specifically comprises: separate said customer relationship unit and other match associative cell acquisition separation relation unit;
S206: receive the user unit of competing basically;
This step specifically comprises: the said reception user unit step of competing basically specifically comprises: receive the basic match database of user; Obtain the user unit of competing basically according to the basic match database of said user;
S207: the input block of confirming the separation relation unit;
This step specifically comprises: confirm the input block of said separation relation unit according to the said user unit of competing basically;
S208: obtain user's output unit;
This step specifically comprises: and obtain user's output unit according to said separation relation unit and said input block;
S209: obtain user's output data;
This step specifically comprises: recover the incidence relation of said separation relation unit and other match associative cells according to said user's incidence relation, and according to the incidence relation after recovering, obtain user's output data;
S210: export said user's output data;
This step specifically comprises: also specifically comprise after the said user's output data of the said output step: receive subtitle template; Play said subtitle file according to said subtitle template;
Also specifically comprise after the said user's output data of the said output step: generate output database according to said output data;
Said according to also specifically comprising after the said output data generation output database step:
Receive match index condition;
According to the said generation output database of said match index condition index, obtain indexed results;
Produce subtitle file according to said indexed results, broadcast control system broadcasts according to said subtitle file;
S211: obtain subtitle file and play;
This step specifically comprises: also specifically comprise after the said user's output data of the said output step: obtain subtitle file according to said user's output data; Broadcast control system is play according to said subtitle file.
Through the description of above embodiment, 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 synoptic diagram 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. the method for an in-situ match data separating is characterized in that, comprising:
Receive a plurality of schedules and concern the unit, said schedules concern that the unit is made up of input block and output unit;
Concern that from said a plurality of schedules choosing the user the unit competes and concern the unit;
Compete according to said user and to concern that the unit obtains user's incidence relation that the schedules related with this unit concern the unit;
Separate said customer relationship unit and other match associative cell acquisition separation relation unit;
Receive the user unit of competing basically;
Confirm the input block of said separation relation unit according to the said user unit of competing basically;
And obtain user's output unit according to said separation relation unit and said input block;
Recover the incidence relation of said separation relation unit and other match associative cells according to said user's incidence relation, and, obtain user's output data according to the incidence relation after recovering;
Export said user's output data.
2. the method described in claim 1 is characterized in that, said schedules concern that the unit specifically comprises: middle match unit and total match unit.
3. the method described in claim 1 or 2 is characterized in that, said input block specifically comprises: games results information, match history information.
4. the method described in claim 1 is characterized in that, a plurality of schedules of said reception concern that unit step also specifically comprises:
Receive match database, said match database is a relevant database;
Obtain schedules information summary sheet according to said match database;
Confirm that according to said schedules information remittance table said schedules concern the unit.
5. the method described in claim 1 is characterized in that, the said reception user unit step of competing basically specifically comprises:
Receive the basic match database of user;
Obtain the user unit of competing basically according to the basic match database of said user.
6. the method described in claim 1; It is characterized in that; The said match according to said user concerns after the unit obtains user's incidence relation step that the schedules related with this unit concern the unit and also specifically comprise: obtain user's incidence relation file according to said user's incidence relation, said user's incidence relation file comprises specifically that the user competes and concerns unit information.
7. the method described in claim 1 is characterized in that, also specifically comprises after the said user's output data of the said output step:
Obtain subtitle file according to said user's output data;
Broadcast control system is play according to said subtitle file.
8. the method described in claim 7 is characterized in that, also specifically comprises after the said user's output data of the said output step:
Receive subtitle template;
Play said subtitle file according to said subtitle template.
9. the method described in claim 1 is characterized in that, also specifically comprises after the said user's output data of the said output step:
Generate output database according to said output data.
10. the method described in claim 9 is characterized in that, and is said according to also specifically comprising after the said output data generation output database step:
Receive match index condition;
According to the said generation output database of said match index condition index, obtain indexed results;
Produce subtitle file according to said indexed results, broadcast control system broadcasts according to said 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 true CN102722513A (en) | 2012-10-10 |
| CN102722513B 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) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102752553A (en) * | 2011-10-19 | 2012-10-24 | 新奥特（北京）视频技术有限公司 | Method and system for dynamic call and generation of data base in grading system |
Citations (5)
| 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 |
| US20090292681A1 (en) * | 2008-05-23 | 2009-11-26 | Matthew Scott Wood | Presentation of an extracted artifact based on an indexing technique |
| CN102118569A (en) * | 2009-12-30 | 2011-07-06 | 新奥特（北京）视频技术有限公司 | Processing method and processing device for public data in caption broadcasting |
-
2011
- 2011-12-30 CN CN201110454230.1A patent/CN102722513B/en not_active Expired - Fee Related
Patent Citations (5)
| 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 |
| US20090292681A1 (en) * | 2008-05-23 | 2009-11-26 | Matthew Scott Wood | Presentation of an extracted artifact based on an indexing technique |
| CN102118569A (en) * | 2009-12-30 | 2011-07-06 | 新奥特（北京）视频技术有限公司 | Processing method and processing device for public data in caption broadcasting |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102752553A (en) * | 2011-10-19 | 2012-10-24 | 新奥特（北京）视频技术有限公司 | Method and system for dynamic call and generation of data base in grading system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102722513B (en) | 2017-12-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109413484B (en) | Bullet screen display method and device and storage medium | |
| CN104168433A (en) | Media content processing method and system | |
| CN107729578B (en) | Music recommendation method and device | |
| CN110727868A (en) | Object recommendation method, device and computer-readable storage medium | |
| CN108521588A (en) | A kind of main broadcaster's arrangement method and system based on time slicing, server and storage medium | |
| Moyano Loyola et al. | Stars on the run: escaping from stellar clusters | |
| CN103761337A (en) | Method and system for processing unstructured data | |
| CN102402536A (en) | Method and equipment for extracting key frame from video | |
| CN104657509A (en) | Method and system for recommending tourist destinations based on historical photo information | |
| CN103702213A (en) | Video file playing method and electronic equipment | |
| CN102722513A (en) | Method for separating match field data | |
| CN102724445A (en) | Method and system for instant generation of competitive game information | |
| CN108717826A (en) | Object methods of exhibiting and device | |
| CN102760147A (en) | Method for optimizing competition field database | |
| CN105117468A (en) | Network data processing method and apparatus | |
| CN105912544A (en) | Method and device for matching video content, server, and video playing system | |
| CN104217016A (en) | Method and device for calculating search keywords of webpage | |
| CN114390133A (en) | Recording method and device and electronic equipment | |
| CN104915408A (en) | Method and device for displaying socialized search results | |
| CN102760148A (en) | Data inquiry method for competition system | |
| CN110263175B (en) | Information classification method and device and electronic equipment | |
| CN112825143A (en) | Deep convolutional neural network compression method, device, storage medium and equipment | |
| CN102752553B (en) | The dynamic call generation method and system of database in a kind of scoring system | |
| CN105574038A (en) | Text content recognition rate test method and device based on anti-recognition rendering | |
| CN102752541A (en) | Method for generating game site captions |
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 |