CN102760147A - Method for optimizing competition field database - Google Patents
Method for optimizing competition field database Download PDFInfo
- Publication number
- CN102760147A CN102760147A CN201110454178XA CN201110454178A CN102760147A CN 102760147 A CN102760147 A CN 102760147A CN 201110454178X A CN201110454178X A CN 201110454178XA CN 201110454178 A CN201110454178 A CN 201110454178A CN 102760147 A CN102760147 A CN 102760147A
- Authority
- CN
- China
- Prior art keywords
- schedules
- information
- current
- match database
- 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.)
- Pending
Links
Images
Abstract
The invention discloses a method for optimizing a competition field database, which concretely comprises the steps as follows: a competition database is received; first schedule keywords are extracted according to course information; schedule progress keywords are received; the schedule progress keywords are matched with the first schedule keywords so as to obtain current schedule keywords; corresponding current schedule information is obtained according to the current schedule keywords; current schedule target information corresponding to the current schedule information is obtained according to the current schedule information; and the current schedule information and the current schedule target information are deleted from the competition database, and a current competition database is obtained. The method solves the problem about optimizing database historical data in the big competition database, so that historical data information does not exist in the obtained current competition database, the capacity of the competition database is simplified, the operational performance of a competition system can be improved further, and a more accurate operation effect can be obtained.
Description
Technical field
The present invention relates to the athletic competition data of database and handle, be applied to the data base administration of large-scale game and the data processing of in-situ match, particularly a kind of method of optimizing the in-situ match database.
Background technology
Along with the development of television relay technology, the important component part, the particularly television relay for the timing class 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, simultaneously; Along with the continuous development of athletic competition, various competitive sports more and more reach the robotization to various information managements near scale, particularly are the management of basic information for the game; Along with the continuous increase of match number, various match personal informations are handled in robotization and schedules information becomes the inexorable trend that modernized competitive sports are managed, particularly in large-scale as world-class competitive sports; It is particularly important that above race data management will become, and match database adopts relational database structure more, but in the application process of above database; Along with the passing data volume of competing also will constantly increase; But while most of data wherein will no longer be handled as historical competition data, but consume data resource equally, reduce the arithmetic speed of database; Simultaneously, cause the waste of system's storage resources.
Realize in the process of the present invention that the inventor finding has following defective in the prior art, in the prior art in the database processing process of large-scale game; The relation data storage capacity is along with the passing of match; Data volume constantly increases, but wherein historical competition data is no longer participated in data operation, thereby; Reduce the arithmetic speed of database, cause the waste of system's storage resources.
Summary of the invention
To defective of the prior art, the invention solves the optimization problem of big event wide area information server historical data.
The invention provides a kind of method of optimizing the in-situ match database in order to solve above technical matters, specifically comprise:
Receive match database, said match database comprises a plurality of schedules information and schedules object information, has incidence relation between said schedules information and the said schedules object information;
According to said schedules information extraction first leg key word;
Receive schedules progress key word;
Obtain current schedules key word according to the said first leg key word of said schedules progress keyword matching;
Obtain corresponding current schedules information according to said current schedules key word, and obtain corresponding with it current schedules object information according to said current schedules information;
Said current schedules information of deletion and said current schedules object information are obtained current match database from said match database.
Wherein, said schedules information specifically comprises: competition sessions information and competition sessions temporal information.
Wherein, said first leg key word specifically comprises: competition sessions name information and competition sessions temporal information.
Wherein, said schedules information specifically comprises: the schedules template connects information and schedules Template Information.
Wherein, saidly specifically comprise: according to said schedules information extraction first leg key word and said schedules Template Information according to said schedules information extraction first leg key word step.
Wherein, said a plurality of schedules information specifically comprises: the sequential organization successively of said schedules information.
Wherein, The said current schedules information of obtaining correspondence according to said current schedules key word; And obtain with it corresponding current schedules object information step according to said current schedules information and specifically comprise: obtain corresponding current schedules information according to said current schedules key word, and obtain corresponding with it current schedules object information according to said current schedules information; Obtain historical match database according to said current schedules information and said current schedules object information.
Wherein, saidly also specifically comprise after deletion said current schedules information and said current schedules object information obtained current match database step from said match database: obtain current schedules object information according to said current match database; Obtain current schedules object subtitle file according to said current schedules object information; Broadcast control system is play according to said current schedules object subtitle file.
Wherein, said from said match database deletion said current schedules information and said current schedules object information obtain current match database and also specifically comprise step: from said match database, obtain current connecting relation according to said current schedules information; The incidence relation that from said match database, breaks away from said current schedules information and said current schedules object information according to said current connecting relation obtains current match database.
Wherein, Saidly also specifically comprise after deletion said current schedules information and said current schedules object information obtained current match database step from said match database: related according to said current connecting relation foundation between said match database and current match database, obtain the recovery match database.
Compared with prior art, the embodiment of the invention has the following advantages: according to the schedules information in the match database, mate current schedules information; And the schedules information and the relevant information of above coupling separated, thereby in the current match database that obtains, there is not historical data information from former match database; Simplified the capacity of match database; Thereby, improved the operational performance of tournament system, obtained operation effect more accurately.
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 synoptic diagram of optimizing the method for in-situ match database in the embodiment of the invention 1;
Fig. 2: be the another kind of synoptic diagram of optimizing the method for in-situ match database 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 optimizing the in-situ match database is provided in the embodiment of the invention 1, as shown in Figure 1, may further comprise the steps:
S101: receive match database;
This step specifically comprises: receive match database, said match database comprises a plurality of schedules information and schedules object information, has incidence relation between said schedules information and the said schedules object information;
S102: extract the first leg key word;
This step specifically comprises: according to said schedules information extraction first leg key word;
S103: receive schedules progress key word;
S104: obtain current schedules key word;
This step specifically comprises: obtain current schedules key word according to the said first leg key word of said schedules progress keyword matching;
S105: obtain current schedules object information;
This step specifically comprises: obtain corresponding current schedules information according to said current schedules key word, and obtain corresponding with it current schedules object information according to said current schedules information;
S106: obtain current match database;
This step specifically comprises: said current schedules information of deletion and said current schedules object information are obtained current match database from said match database.
The method of another kind of optimization in-situ match database is provided in the embodiment of the invention 2, as shown in Figure 2, may further comprise the steps:
S201: receive match database;
This step specifically comprises: receive match database, said match database comprises a plurality of schedules information and schedules object information, has incidence relation between said schedules information and the said schedules object information;
Said schedules information specifically comprises: competition sessions information and competition sessions temporal information;
Said schedules information specifically comprises: the schedules template connects information and schedules Template Information;
Said a plurality of schedules information specifically comprises: the sequential organization successively of said schedules information;
S202: according to schedules information extraction first leg key word;
This step specifically comprises: according to said schedules information extraction first leg key word;
Said first leg key word specifically comprises: competition sessions name information and competition sessions temporal information;
Saidly specifically comprise: according to said schedules information extraction first leg key word and said schedules Template Information according to said schedules information extraction first leg key word step;
S203: receive schedules progress key word;
S204: obtain current schedules key word;
This step specifically comprises: obtain current schedules key word according to the said first leg key word of said schedules progress keyword matching;
S205: obtain current schedules object information according to current schedules information;
This step specifically comprises: obtain corresponding current schedules information according to said current schedules key word, and obtain corresponding with it current schedules object information according to said current schedules information;
Saidly obtain corresponding current schedules information, and obtain corresponding with it current schedules object information step according to said current schedules information and specifically comprise according to said current schedules key word:
Obtain corresponding current schedules information according to said current schedules key word, and obtain corresponding with it current schedules object information according to said current schedules information;
Obtain historical match database according to said current schedules information and said current schedules object information;
S206: obtain current match database;
This step specifically comprises: S2061: current schedules object subtitle file is play; S2062: obtain the recovery match database;
Said current schedules information of deletion and said current schedules object information are obtained current match database from said match database;
Said from said match database deletion said current schedules information and said current schedules object information obtain current match database and also specifically comprise step:
From said match database, obtain current connecting relation according to said current schedules information;
The incidence relation that from said match database, breaks away from said current schedules information and said current schedules object information according to said current connecting relation obtains current match database;
Saidly also specifically comprise after deletion said current schedules information and said current schedules object information obtained current match database step from said match database:
Obtain current schedules object information according to said current match database;
Obtain current schedules object subtitle file according to said current schedules object information;
Broadcast control system is play according to said current schedules object subtitle file;
Saidly also specifically comprise after deletion said current schedules information and said current schedules object information obtained current match database step from said match database:
Between said match database and current match database, set up relatedly, obtain the recovery match database according to said current connecting relation.
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. a method of optimizing the in-situ match database is characterized in that, comprising:
Receive match database, said match database comprises a plurality of schedules information and schedules object information, has incidence relation between said schedules information and the said schedules object information;
According to said schedules information extraction first leg key word;
Receive schedules progress key word;
Obtain current schedules key word according to the said first leg key word of said schedules progress keyword matching;
Obtain corresponding current schedules information according to said current schedules key word, and obtain corresponding with it current schedules object information according to said current schedules information;
Said current schedules information of deletion and said current schedules object information are obtained current match database from said match database.
2. the method described in claim 1 is characterized in that, said schedules information specifically comprises: competition sessions information and competition sessions temporal information.
3. the method described in claim 2 is characterized in that, said first leg key word specifically comprises:
Competition sessions name information and competition sessions temporal information.
4. the method described in claim 1 is characterized in that, said schedules information specifically comprises: the schedules template connects information and schedules Template Information.
5. the method described in claim 1 is characterized in that, saidly specifically comprises according to said schedules information extraction first leg key word step: according to said schedules information extraction first leg key word and said schedules Template Information.
6. the method described in claim 1 is characterized in that, said a plurality of schedules information specifically comprise: the sequential organization successively of said schedules information.
7. the method described in claim 6 is characterized in that, saidly obtains corresponding current schedules information according to said current schedules key word, and obtains corresponding with it current schedules object information step according to said current schedules information and specifically comprise:
Obtain corresponding current schedules information according to said current schedules key word, and obtain corresponding with it current schedules object information according to said current schedules information;
Obtain historical match database according to said current schedules information and said current schedules object information.
8. the method described in claim 1 is characterized in that, saidly also specifically comprises after deletion said current schedules information and said current schedules object information obtained current match database step from said match database:
Obtain current schedules object information according to said current match database;
Obtain current schedules object subtitle file according to said current schedules object information;
Broadcast control system is play according to said current schedules object subtitle file.
9. the method described in claim 1 is characterized in that, said from said match database deletion said current schedules information and said current schedules object information obtain current match database and also specifically comprise step:
From said match database, obtain current connecting relation according to said current schedules information;
The incidence relation that from said match database, breaks away from said current schedules information and said current schedules object information according to said current connecting relation obtains current match database.
10. want the method described in 9 like right, it is characterized in that, saidly also specifically comprise after deletion said current schedules information and said current schedules object information obtained current match database step from said match database:
Between said match database and current match database, set up relatedly, obtain the recovery match database according to said current connecting relation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110454178XA CN102760147A (en) | 2011-12-30 | 2011-12-30 | Method for optimizing competition field database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110454178XA CN102760147A (en) | 2011-12-30 | 2011-12-30 | Method for optimizing competition field database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102760147A true CN102760147A (en) | 2012-10-31 |
Family
ID=47054605
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110454178XA Pending CN102760147A (en) | 2011-12-30 | 2011-12-30 | Method for optimizing competition field database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102760147A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106447543A (en) * | 2016-11-04 | 2017-02-22 | 球宝互动（北京）网络科技有限公司 | System for generating agenda of sports event |
| CN111159315A (en) * | 2019-12-31 | 2020-05-15 | 汕头市同行网络科技有限公司 | Association method of football team data and data verification method |
| CN111265882A (en) * | 2019-03-28 | 2020-06-12 | 乐竞文化传媒(上海)有限公司 | KPL (Key performance language) competition schedule generation method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070021055A1 (en) * | 2005-07-22 | 2007-01-25 | Marc Arseneau | System and methods for enhancing the experience of spectators attending a live sporting event, with bi-directional communication capability |
| CN101261703A (en) * | 2008-03-20 | 2008-09-10 | 姚武杰 | Competition management system and method based on network |
| CN101494742A (en) * | 2008-01-24 | 2009-07-29 | 新奥特（北京）视频技术有限公司 | Technology statistical data implement method for basketball live television subtitling system |
| CN102096664A (en) * | 2009-12-09 | 2011-06-15 | 新奥特（北京）视频技术有限公司 | Report generating method |
| CN102118569A (en) * | 2009-12-30 | 2011-07-06 | 新奥特（北京）视频技术有限公司 | Processing method and processing device for public data in caption broadcasting |
-
2011
- 2011-12-30 CN CN201110454178XA patent/CN102760147A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070021055A1 (en) * | 2005-07-22 | 2007-01-25 | Marc Arseneau | System and methods for enhancing the experience of spectators attending a live sporting event, with bi-directional communication capability |
| CN101494742A (en) * | 2008-01-24 | 2009-07-29 | 新奥特（北京）视频技术有限公司 | Technology statistical data implement method for basketball live television subtitling system |
| CN101261703A (en) * | 2008-03-20 | 2008-09-10 | 姚武杰 | Competition management system and method based on network |
| CN102096664A (en) * | 2009-12-09 | 2011-06-15 | 新奥特（北京）视频技术有限公司 | Report generating method |
| CN102118569A (en) * | 2009-12-30 | 2011-07-06 | 新奥特（北京）视频技术有限公司 | Processing method and processing device for public data in caption broadcasting |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106447543A (en) * | 2016-11-04 | 2017-02-22 | 球宝互动（北京）网络科技有限公司 | System for generating agenda of sports event |
| CN111265882A (en) * | 2019-03-28 | 2020-06-12 | 乐竞文化传媒(上海)有限公司 | KPL (Key performance language) competition schedule generation method |
| CN111159315A (en) * | 2019-12-31 | 2020-05-15 | 汕头市同行网络科技有限公司 | Association method of football team data and data verification method |
| CN111159315B (en) * | 2019-12-31 | 2022-02-18 | 汕头市同行网络科技有限公司 | Association method of football team data and data verification method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107644085B (en) | Method and device for generating sports event news | |
| CN103607461A (en) | Information sharing method and cloud server | |
| CN108521588A (en) | A kind of main broadcaster's arrangement method and system based on time slicing, server and storage medium | |
| CN106488256B (en) | data processing method and device | |
| CN104902292A (en) | Television report-based public opinion analysis method and system | |
| CN102760147A (en) | Method for optimizing competition field database | |
| CN104991971A (en) | A video information processing method and device | |
| CN104778252A (en) | Index storage method and index storage device | |
| CN103475532A (en) | Hardware detection method and system thereof | |
| CN103688256A (en) | Method, device and system for determining video quality parameter based on comment | |
| CN102750395A (en) | Game data obtaining method | |
| CN102737083B (en) | Instant competition information editing method and system | |
| CN107544894B (en) | Log processing method and device and server | |
| CN102760148A (en) | Data inquiry method for competition system | |
| CN202068514U (en) | Video-on-demand server | |
| CN102750302A (en) | Method for generating field technology statistics | |
| CN104410873A (en) | Method and device of detecting number of television channel users | |
| CN102752500A (en) | Game site information gathering method | |
| CN103678545A (en) | Network resource clustering method and device | |
| CN102722515A (en) | Method for mining match field information data | |
| CN102750307A (en) | Method for controlling match data forwarding | |
| CN102750305A (en) | Data updating method for field result processing system | |
| CN102760145A (en) | Database terminal configuration method for field score processing system | |
| CN102722510A (en) | Method for sharing heterogeneous databse of field score treatment system | |
| 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20121031 |
|
| RJ01 | Rejection of invention patent application after publication |