CN102750303A - Relation copying method for match field relation data base - Google Patents
Relation copying method for match field relation data base Download PDFInfo
- Publication number
- CN102750303A CN102750303A CN2011104541864A CN201110454186A CN102750303A CN 102750303 A CN102750303 A CN 102750303A CN 2011104541864 A CN2011104541864 A CN 2011104541864A CN 201110454186 A CN201110454186 A CN 201110454186A CN 102750303 A CN102750303 A CN 102750303A
- Authority
- CN
- China
- Prior art keywords
- match
- schedules
- unit
- object unit
- 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.)
- Granted
Links
Images
Abstract
The invention discloses a relation copying method for a match field relation data base. The relation copying method specifically includes: receiving a match data base which comprises a plurality of course units and match object units, wherein an incidence relation exists between the course units and the match object units; obtaining an input course object unit and an output course object unit which are connected with the course units according to the course units; determining a first variable of an incidence relation model according to the input course object unit and determining a second variable of the incidence relation model according to the output course object unit so as to obtain a match relation model; obtaining a match data base relation model according to the incidence relation between the course units of the match data base and a match relation model; and obtaining a copied match data base file according to the match data base relation model and the course object units. By means of the method, the problems of data copying and accurate updating of a multi-field data base are solved, accurate updating of the data base is improved, and flexibility of a data base system is improved.
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 in-situ match relational database concern clone method.
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; Under the situation that need be configured to many schedules site data processing system; Above duplicating of match relational database structure becomes particularly important, when competition field, center database upgrades and adjusts, need the match relational database structure of periphery be duplicated fast especially; But the mode that normally adopts the overall data storehouse to duplicate in the prior art realizes above process; The subject matter of this database update mode is owing to receive the influence of database volume, therefore, and under the bigger situation of database; More than operation is difficult to accomplish accurately through the influence that regular meeting receives the transmission factor.
Realize in the process of the present invention the inventor; Finding has following defective in the prior art; In the prior art when needs to the big event database upgrade, when duplicating because database volume is big, so the accuracy of its transmission depends on the data transmission capabilities of transmission network; Receive the direct influence of transmission factor to a great extent, can't guarantee the accurate copy update of big event database.
Summary of the invention
To defective of the prior art, the problem that the data that the invention solves many spot databases are duplicated and accurately upgraded.
In order to solve the clone method that concerns that above technical matters the invention provides a kind of in-situ match relational database, specifically comprise:
Receive match database, said match database comprises a plurality of schedules unit and schedules object unit, has incidence relation between said schedules unit and the said schedules object unit;
Obtain the input schedules object unit that is attached thereto according to said schedules unit, and the input schedules object unit that is attached thereto;
Confirm first variable of association relation model according to said input schedules object unit, confirm second variable of association relation model to obtain the match relational model according to said output schedules object unit;
Obtain the match database relational model according to incidence relation and said match relational model between the said match database schedules unit;
Obtain to duplicate the match database file according to said match database relational model and said schedules object unit.
Wherein, said schedules unit specifically comprises: competition sessions unit and competition sessions time quantum.
Wherein, said schedules unit specifically comprises: schedules template connection unit and schedules modular unit.
Wherein, Said first variable of confirming association relation model according to said input schedules object unit; Confirm second variable of association relation model according to said output schedules object unit, obtain match relational model step and also specifically comprise: receive the user definition relational model; Confirm first variable of said user definition relational model according to said input schedules object unit, confirm second variable of said user definition relational model to obtain the match relational model according to said output schedules object unit.
Wherein, said user definition relational model specifically comprises: one-one relationship model, many-to-one relationship model and many-to-many relationship model.
Wherein, said schedules object unit specifically comprises: result of the match information, match personal information and fixture information.
Wherein, also specifically comprise after obtaining to duplicate match database file step according to said match database relational model and said schedules object unit: generate and duplicate the match data file according to the said match database file information of duplicating; Generate subtitle file according to the said match data file of duplicating; Broadcast control system is play according to said subtitle file.
Wherein, saidly before generating the subtitle file step, the match data file also specifically comprises: receive captions and broadcast template file according to said duplicating.
Wherein, saidly generate the subtitle file step and also specifically comprise: broadcast template file and the said match data file of duplicating generates subtitle file according to said captions according to the said match data file of duplicating.
Compared with prior art, the embodiment of the invention has the following advantages: through to match relational database data relationship opening relationships data model, when database being duplicated and upgrade; Through the data of relational data model and input block are duplicated; Just can realize copy update,, reduce the transmission capacity of match relational database through description to database to the match relational database; Thereby improved the accurate renewal of database, increased the dirigibility of Database Systems.
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 concerns clone method that is a kind of in-situ match relational database in the embodiment of the invention 1;
Fig. 2: the synoptic diagram that concerns clone method that is another kind of in-situ match relational 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 clone method that concerns of in-situ match relational 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 unit and schedules object unit, has incidence relation between said schedules unit and the said schedules object unit;
S102: obtain input schedules object unit and input schedules object unit;
This step specifically comprises: obtain the input schedules object unit that is attached thereto according to said schedules unit, and the input schedules object unit that is attached thereto;
S103: obtain the match relational model;
This step specifically comprises: confirm first variable of association relation model according to said input schedules object unit, confirm second variable of association relation model to obtain the match relational model according to said output schedules object unit;
S104: obtain the match database relational model;
This step specifically comprises: obtain the match database relational model according to incidence relation and said match relational model between the said match database schedules unit;
S105: obtain to duplicate the match database file;
This step specifically comprises: obtain to duplicate the match database file according to said match database relational model and said schedules object unit.
The clone method that concerns of another kind of in-situ match relational 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 unit and schedules object unit, has incidence relation between said schedules unit and the said schedules object unit;
Said schedules unit specifically comprises: competition sessions unit and competition sessions time quantum;
Said schedules unit specifically comprises: schedules template connection unit and schedules modular unit;
Said schedules object unit specifically comprises: result of the match information, match personal information and fixture information;
S202: obtain input schedules object unit and input schedules object unit;
This step specifically comprises: obtain the input schedules object unit that is attached thereto according to said schedules unit, and the input schedules object unit that is attached thereto;
S203: obtain the match relational model;
This step specifically comprises: confirm first variable of association relation model according to said input schedules object unit, confirm second variable of association relation model to obtain the match relational model according to said output schedules object unit;
Said first variable of confirming association relation model according to said input schedules object unit; Confirm second variable of association relation model according to said output schedules object unit, obtain match relational model step and also specifically comprise: receive the user definition relational model; Confirm first variable of said user definition relational model according to said input schedules object unit, confirm second variable of said user definition relational model to obtain the match relational model according to said output schedules object unit;
Said user definition relational model specifically comprises: one-one relationship model, many-to-one relationship model and many-to-many relationship model;
S204: obtain the match database relational model;
This step specifically comprises: obtain the match database relational model according to incidence relation and said match relational model between the said match database schedules unit;
S205: obtain to duplicate the match database file;
This step specifically comprises: obtain to duplicate the match database file according to said match database relational model and said schedules object unit;
S206: generate and duplicate the match data file;
This step specifically comprises: also specifically comprise after obtaining to duplicate match database file step according to said match database relational model and said schedules object unit: generate and duplicate the match data file according to the said match database file information of duplicating;
S207: receive captions and broadcast template file;
This step specifically comprises: saidly also specifically comprise before the match data file generates the subtitle file step according to said duplicating: receive captions and broadcast template file;
S208: generate subtitle file;
This step specifically comprises: generate subtitle file according to the said match data file of duplicating; Saidly generate the subtitle file step and also specifically comprise: broadcast template file and the said match data file of duplicating generates subtitle file according to said captions according to the said match data file of duplicating;
S209: broadcast control system is play according to 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 (9)
- An in-situ match relational database concern clone method, it is characterized in that, comprising:Receive match database, said match database comprises a plurality of schedules unit and schedules object unit, has incidence relation between said schedules unit and the said schedules object unit;Obtain the input schedules object unit that is attached thereto according to said schedules unit, and the input schedules object unit that is attached thereto;Confirm first variable of association relation model according to said input schedules object unit, confirm second variable of association relation model to obtain the match relational model according to said output schedules object unit;Obtain the match database relational model according to incidence relation and said match relational model between the said match database schedules unit;Obtain to duplicate the match database file according to said match database relational model and said schedules object unit.
- 2. the method described in claim 1 is characterized in that, said schedules unit specifically comprises: competition sessions unit and competition sessions time quantum.
- 3. the method described in claim 1 is characterized in that, said schedules unit specifically comprises: schedules template connection unit and schedules modular unit.
- 4. the method described in claim 1; It is characterized in that; Saidly confirm first variable of association relation model, confirm to obtain second variable of association relation model match relational model step and also specifically comprise according to said output schedules object unit according to said input schedules object unit:Receive the user definition relational model;Confirm first variable of said user definition relational model according to said input schedules object unit, confirm second variable of said user definition relational model to obtain the match relational model according to said output schedules object unit.
- 5. the method described in claim 4 is characterized in that, said user definition relational model specifically comprises: one-one relationship model, many-to-one relationship model and many-to-many relationship model.
- 6. the method described in claim 1 is characterized in that, said schedules object unit specifically comprises: result of the match information, match personal information and fixture information.
- 7. the method described in claim 1 is characterized in that, also specifically comprises after obtaining to duplicate match database file step according to said match database relational model and said schedules object unit:Generate and duplicate the match data file according to the said match database file information of duplicating;Generate subtitle file according to the said match data file of duplicating;Broadcast control system is play according to said subtitle file.
- 8. the method described in claim 7 is characterized in that, saidly also specifically comprises before the match data file generates the subtitle file step according to said duplicating:Receive captions and broadcast template file.
- 9. the method described in claim 8 is characterized in that, saidly generates the subtitle file step and also specifically comprises according to the said match data file of duplicating:Broadcast template file and the said match data file generation subtitle file that duplicates according to said captions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110454186.4A CN102750303B (en) | 2011-12-30 | 2011-12-30 | A kind of relation clone method of in-situ match relational database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110454186.4A CN102750303B (en) | 2011-12-30 | 2011-12-30 | A kind of relation clone method of in-situ match relational database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102750303A true CN102750303A (en) | 2012-10-24 |
| CN102750303B CN102750303B (en) | 2017-12-29 |
Family
ID=47030495
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110454186.4A Expired - Fee Related CN102750303B (en) | 2011-12-30 | 2011-12-30 | A kind of relation clone method of in-situ match relational database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102750303B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104933015A (en) * | 2014-03-18 | 2015-09-23 | 日本电气株式会社 | Relation model determination method and apparatus |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7158994B1 (en) * | 2001-09-28 | 2007-01-02 | Oracle International Corporation | Object-oriented materialized views |
| CN101296322A (en) * | 2007-04-27 | 2008-10-29 | 新奥特硅谷视频技术有限责任公司 | Sports event logging system |
| US20090150413A1 (en) * | 2007-12-06 | 2009-06-11 | Oracle International Corporation | Virtual columns |
| 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 |
| CN102201080A (en) * | 2010-03-24 | 2011-09-28 | 新奥特（北京）视频技术有限公司 | Competition management system for supporting multiple sporting events |
-
2011
- 2011-12-30 CN CN201110454186.4A patent/CN102750303B/en not_active Expired - Fee Related
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7158994B1 (en) * | 2001-09-28 | 2007-01-02 | Oracle International Corporation | Object-oriented materialized views |
| CN101296322A (en) * | 2007-04-27 | 2008-10-29 | 新奥特硅谷视频技术有限责任公司 | Sports event logging system |
| US20090150413A1 (en) * | 2007-12-06 | 2009-06-11 | Oracle International Corporation | Virtual columns |
| 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 |
| CN102201080A (en) * | 2010-03-24 | 2011-09-28 | 新奥特（北京）视频技术有限公司 | Competition management system for supporting multiple sporting events |
Non-Patent Citations (3)
| Title |
|---|
| 布莱拉 等: "《Oracle DataBase 11g DBA手册》", 31 January 2009 * |
| 霍东方: "基于OraclelOg的实体化视图复制研究", 《中国科技论文在线》 * |
| 顾清华 等: "大型综合赛事管理信息系统", 《清华大学学报（自然科学版）》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104933015A (en) * | 2014-03-18 | 2015-09-23 | 日本电气株式会社 | Relation model determination method and apparatus |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102750303B (en) | 2017-12-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102214205B (en) | For the system and method for the logic copy in the Database Systems of cluster | |
| CN102752540A (en) | Automatic categorization method based on face recognition technology | |
| CN111259643B (en) | Method and equipment for generating graphic report | |
| CN103607461A (en) | Information sharing method and cloud server | |
| CN104718548A (en) | Efficient pushdown of joins in a heterogeneous database system involving a large-scale low-power cluster | |
| CN109889397B (en) | Lottery method, block generation method, equipment and storage medium | |
| CN106886535A (en) | A kind of data pick-up method and apparatus for being adapted to multiple data sources | |
| CN106331822A (en) | Method and device for playing multiple videos and electronic equipment | |
| CN109871290A (en) | Allocating stack method for tracing, device and storage medium applied to Java | |
| CN102724445A (en) | Method and system for instant generation of competitive game information | |
| CN103593156A (en) | Three-dimensional panoramic display method and device | |
| KR102602698B1 (en) | Method and device for synchronizing video and a light stick | |
| CN102750303A (en) | Relation copying method for match field relation data base | |
| WO2016078445A1 (en) | Method and device for upgrading multi-mode base station and network management system | |
| CN105047210B (en) | A kind of the striding equipment synchronous method and device of shuffle playlist | |
| CN102760147A (en) | Method for optimizing competition field database | |
| CN102760148A (en) | Data inquiry method for competition system | |
| CN105279181A (en) | Quick updating method and system of electronic map of house | |
| CN106874391B (en) | deadlock processing method and device | |
| CN104753659A (en) | Method, device and system for multiple network element data synchronized load | |
| US7877422B2 (en) | Method and system for processing 1:N relationships between data object nodes | |
| CN102750302A (en) | Method for generating field technology statistics | |
| CN105653205A (en) | User request processing method and system | |
| CN110971923B (en) | Bullet screen connection method, storage medium, system and client | |
| CN102760145A (en) | Database terminal configuration method for field score processing 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: 20171229 Termination date: 20201230 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |