CN105867978A - OGG version deployment method and system - Google Patents
OGG version deployment method and system Download PDFInfo
- Publication number
- CN105867978A CN105867978A CN201610222213.8A CN201610222213A CN105867978A CN 105867978 A CN105867978 A CN 105867978A CN 201610222213 A CN201610222213 A CN 201610222213A CN 105867978 A CN105867978 A CN 105867978A
- Authority
- CN
- China
- Prior art keywords
- version
- file
- ogg
- deployment
- basic data
- 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
- 238000000034 method Methods 0.000 title claims abstract description 60
- 238000013515 script Methods 0.000 claims abstract description 84
- 238000012856 packing Methods 0.000 claims abstract description 9
- 230000001360 synchronised effect Effects 0.000 claims description 16
- 238000001514 detection method Methods 0.000 claims description 7
- 241000208340 Araliaceae Species 0.000 claims description 3
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 claims description 3
- 235000003140 Panax quinquefolius Nutrition 0.000 claims description 3
- 235000008434 ginseng Nutrition 0.000 claims description 3
- 238000011017 operating method Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 238000000605 extraction Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000010076 replication Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/65—Updates
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
- Computer Security & Cryptography (AREA)
Abstract
The invention relates to an OGG version deployment method, characterized by comprising the following steps: acquiring by an OGG deployment platform, basic data required for version deployment, and generating a configuration file according to the basic data in the configuration file that includes the basic data required for version deployment; according to the basic data, generating by the OGG deployment platform, link information, a parameter file, SQL (structured query language) scripts and version type, and packing the link information, the parameter file, the SQL scripts and the version type to generate a script file issued to a deployment catalogue; executing by the OGG deployment platform, the script file, and deploying the version according to the script file. Through the use of the method, fewer misopeartions are occur, and OGG version deployment is easier and faster; in addition, an OGG version deployment system is also provided.
Description
Technical field
The present invention relates to database technical field, particularly relate to a kind of OGG version dispositions method and system.
Background technology
OGG (Oracle Golden Gate) software is that a kind of structural data copy backup based on daily record is soft
Part, it is by resolving the online daily record of source database or the increment change of archive log acquisition data, then by these
Change application is in target database, thus it is Tong Bu with target database to realize source database.When OGG is carried out
During version updating, need to carry out version deployment.At present, the exploitation that OGG version is grouped by data integration platform
Personnel generate corresponding document on management platform, and according to different release type manual compilation operation steps,
Then by night shift management personnel morning operate realize version dispose.
But, traditional this method, due to needs management personnel manual compilation operation step, different exploitations
Personnel are different due to custom or familiarity, the deployment document function step not necessarily standardization write, and due to
Need in operation maintenance personnel manual operation, it is easy to leak operating procedure or rudimentary maloperation occurs, thus leading
Cause cannot realize version updating.
Summary of the invention
Based on this, it is necessary to for above-mentioned technical problem, it is provided that a kind of the more convenient of maloperation is less likely to occur
OGG version dispositions method and system efficiently.
A kind of OGG version dispositions method, said method comprising the steps of:
OGG deployment platform obtains the basic data required for version is disposed, according to the base in described configuration file
Plinth data genaration configuration file, comprises version and disposes the basic data of needs in described configuration file;
OGG deployment platform generates link information, Parameter File, SQL script and version according to described basic data
This type, and the packing of described link information, Parameter File, SQL script and release type is generated script literary composition
Part is issued to dispose in catalogue;
OGG deployment platform remotely performs described script file, according to described script file deployment train.
Wherein in an embodiment, described basic data includes: database configuration information, version configuration letter
Breath and synchronous meter configuration information;
Described database configuration information includes database-name, database host address and data base's port;
Described version configuration information includes OGG link information, OGG version number and OGG version date issued;
Described synchronous meter configuration information includes source table table name, source literary name name section, target table name and aiming field
Title.
Wherein in an embodiment, the described step according to script file deployment train, including:
Source database and the target database of correspondence is found, according to described version class according to described link information
Type generates corresponding version deployment program, carries out the start stop operation of process, ginseng by described version deployment program
Number file replacement, def file generated and SQL script perform.
Wherein in an embodiment, the described step according to script file deployment train, also include: holding
Detection automatically is inserted during row version deployment program.
Wherein in an embodiment, described OGG deployment platform obtains the basic data required for version is disposed,
The step of configuration file is generated according to described basic data, including:
Described OGG deployment platform obtains the basic data required for the version deployment of user's input;Obtain user
Configuration file one key of input generates order, generates order according to described basis by described configuration file one key
Data genaration configuration file.
A kind of OGG version deployment system, described system includes:
Configuration file generation module, for obtaining the basic data required for version is disposed, according to described basis
Data genaration configuration file, comprises version and disposes the basic data of needs in described configuration file;
Script file generation module, raw according to the basic data in described configuration file for OGG deployment platform
Become link information, Parameter File, SQL script and release type, and by described link information, Parameter File,
SQL script and release type packing generate script file and are issued to dispose in catalogue;
Version deployment module, remotely performs described script file for OGG deployment platform, according to described script
File deployment train.
Wherein in an embodiment, described basic data includes: database configuration information, version configuration letter
Breath and synchronous meter configuration information;
Described database configuration information includes database-name, database host address and data base's port;
Described version configuration information includes OGG link information, OGG version number and OGG version date issued;
Described synchronous meter configuration information includes source table table name, source literary name name section, target table name and aiming field
Title.
Wherein in an embodiment, described version deployment module is right for finding according to described link information
The source database answered and target database, generate corresponding version deployment program according to described release type, logical
Cross described version deployment program and carry out the start stop operation of process, Parameter File replacement, def file generated and SQL
Script performs.
Wherein in an embodiment, described version deployment module is additionally operable in the mistake performing version deployment program
Journey is inserted detection automatically.
Wherein in an embodiment, described configuration file generation module is for obtaining the version portion of user's input
Basic data required for administration;Configuration file one key obtaining user's input generates order, by described configuration
File one key generates order and generates configuration file according to described basic data.
Above-mentioned OGG version dispositions method and system, by obtaining the basic data required for version is disposed, root
Generate configuration file according to basic data, and then generate link information, ginseng according to the basic data in configuration file
Number file, SQL script and release type, and by described link information, Parameter File, SQL script and version
The packing of this type generates script file and is issued to dispose in catalogue, more remotely execution script file realizes version portion
Administration.As long as the letter required for version is disposed can be automatically generated according to basic data owing to having configured basic data
Breath and file, remotely perform script file and can be achieved with version deployment.Without the manual compilation operation of developer
Step, it is not required that operation maintenance personnel operates at special time, reduces maloperation so that OGG version is disposed
More convenient.
Accompanying drawing explanation
Fig. 1 is the flow chart of OGG version dispositions method in an embodiment;
Fig. 2 is the basic model schematic diagram carrying out GG synchronization;
Fig. 3 is the schematic diagram of OGG version deployment platform in an embodiment;
Fig. 4 is the sequential chart that in an embodiment, OGG version disposes control flow;
Fig. 5 is the structured flowchart of OGG version deployment system in an embodiment.
Detailed description of the invention
In order to make the purpose of the present invention, technical scheme and advantage clearer, below in conjunction with accompanying drawing and reality
Execute example, the present invention is further elaborated.Only should be appreciated that specific embodiment described herein
Only in order to explain the present invention, it is not intended to limit the present invention.
As it is shown in figure 1, in one embodiment, it is provided that a kind of OGG version dispositions method, the method bag
Include following steps:
Step 102, OGG deployment platform obtains the basic data required for version is disposed, according to basic data
Generate configuration file.
In the present embodiment, configuration file comprises the basic data required for version is disposed.
In one embodiment, basic data includes database configuration information, version configuration information and synchronous meter
Configuration information.Wherein, database configuration information includes database-name, database host address and data base
Port;Version configuration information includes OGG link information, OGG version number and OGG version date issued;
Synchronous meter configuration information includes source table table name, source literary name name section, target table name and aiming field title.Its
In, database configuration information can be used for finding corresponding data base, including source database and target database.
OGG link information refers to that source database arrives the link information of target database.OGG version number identifies renewal
Version number.Source table table name, source literary name name section, target table name and target in synchronous meter configuration information
Field name identifies to be needed to do the field name updated in the table name and table replaced.
Step 104, OGG deployment platform generates link information, parameter according to the basic data in configuration file
File, SQL script and release type, and by described link information, Parameter File, SQL script and version
Type packing generates script file and is issued to dispose in catalogue.
In the present embodiment, link information represents the link from which source database to which target database,
Referring to the synchronizing channel from source database to target database, OGG deployment platform is according to database configuration information
Link information can be generated with version configuration information.Parameter File refers to that OGG synchronizes the code used,
OGG deployment platform can generate corresponding Parameter File according to synchronous meter configuration information.SQL script refers to
The command history performed in data base, OGG deployment platform can be according to database configuration information, version configuration letter
Breath and synchronous meter configuration information generate.Release type is used for defining needs execution when carrying out version and disposing
Version deployment program, the corresponding version deployment program to be performed of different release types is different, OGG portion
Administration's platform can generate correspondence accordingly according to database configuration information, version configuration information and synchronous meter configuration information
Release type.
Further, link information, Parameter File, SQL script and release type are led to by OGG deployment platform
Cross specific rule to integrate, generate Shell script and be issued to this script file dispose in catalogue.Institute
Meaning disposes the catalogue that catalogue refers to that script file is stored when carrying out version and disposing, and can be database host
In particular category in, database host here includes source database main frame and target database main frame.
In one embodiment, OGG deployment platform obtains the basic data required for version is disposed, according to base
The step of plinth data genaration configuration file, including: OGG deployment platform obtains the version of user's input and disposes institute
The basic data needed;Configuration file one key obtaining user's input generates order;By configuration file one key
Generate order and generate configuration file according to basic data.In the present embodiment, can by version convert required for
Basic data is entered into OGG and manages platform, and in one simple order of input, then OGG deployment platform leads to
Cross specific rules integration basic data and generate configuration file.Further, according to the basis in configuration file
Data automatically generate link information, Parameter File, SQL script and release type, and generation script literary composition of packing
Part is issued to dispose in catalogue.
Step 106, OGG deployment platform remotely performs script file, according to script file deployment train.
In the present embodiment, the execution of the remote controlled script file of OGG deployment platform, perform script file
During can realize version dispose.
In one embodiment, according to the step of script file deployment train, including: look into according to link information
Find source database and the target database of correspondence, generate corresponding version deployment program according to release type,
The start stop operation of process, Parameter File replacement, def file generated and SQL is carried out by version deployment program
Script performs.In the present embodiment, to realize disposing new version, need to be entered by version deployment program
The start stop operation of journey, Parameter File are replaced, def file generated and SQL script perform, these processed after then
Complete redaction to dispose.
Wherein, needing to start some process and stop in the start stop operation of process, process here is
Refer to OGG synchronization program, including replication log analysis and data pick-up process (local extract process),
Process (data pump process) and the responsible daily record of being responsible for daily record delivery resolve and are applied to the process of data base
(replicat process).Different OGG version needs the process enabling and stopping can be different, according to spy
Definite sequence starts OGG process such that it is able to realize the integrity of synchrodata.New OGG version also needs to
Replace some Parameter Files.Def file refers to that list structure defines file, the such as table name of a table, field name
With field length etc..Perform SQL script can check whether have Long routine and lock in data base, can check
Table or field that new OGG version relies on have existed, it is also possible to carry out data initialization etc..
Further, in one embodiment, according to the step of script file deployment train, also include:
Detection automatically is inserted during performing version deployment program.In the present embodiment, version deployment program comprises
Autotest, the version deployment program corresponding to different release types is different, and version disposes journey
Sequence is carried out by multiple deploying step, is wherein inserted with automatic detecting step.
The OGG version dispositions method that the embodiment of the present invention is provided, by obtaining the base required for version is disposed
Plinth data, generate configuration file according to basic data, and then generate chain according to the basic data in configuration file
Road information, Parameter File, SQL script and release type, and by described link information, Parameter File, SQL
Script and release type packing generate script file and are issued to dispose in catalogue, then it is real remotely to perform script file
Existing version is disposed.As long as due to configured basic data can according to basic data automatically generate version dispose institute
The information needed and file, remotely perform script file and can be achieved with version deployment.Manual without developer
Compilation operation step, it is not required that operation maintenance personnel operates at special time, reduces maloperation so that OGG
Version is disposed more convenient.
In order to more understand the principle of OGG version dispositions method that the embodiment of the present invention provided, below in conjunction with
GG synchronistic model and OGG version deployment platform proposed by the invention are described in detail.
As in figure 2 it is shown, the basic model schematic diagram synchronized for GG (Golden Gate).Source data to be realized
Synchronization between storehouse and target database, GG synchronizes to realize according to following basic step: 1) GG is drawn into
Journey local extract (e process) reads the daily record data of source database in source, generates source trail (source
Follow the tracks of);2) GG delivery process data pump (d process) reads source trail in source and passes through network
Pass data to destination end and generate remote trail (remote tracing);3) GG replicat process (r process)
Read remote trail in destination end and perform at object library, with reality according to certain rule generation SQL statement
Now synchronize.Traditional this mode then needs developer according to different release type compilation operation steps.
As it is shown on figure 3, the OGG version dispositions method that the embodiment of the present invention is provided, same at original GG
On the basis of step basic model, framework goes out OGG version deployment platform.Obtained by OGG version deployment platform
The basic data of typing, according to basic data thus generate configuration file, OGG version deployment platform and then root
Generate corresponding shell script according to the basic data in configuration file, shell script is issued to source and target
In respective directories in end (i.e. step A in Fig. 3 and step C).Meanwhile, source and destination end send day
Will or def file are to OGG version deployment platform (i.e. step B in Fig. 3 and step D).OGG version
This deployment platform remotely performs shell script, realizes the start stop operation of GG process, parameter by shell script
The replacement of file, the generation of def file and the execution of SQL script.Raw by OGG version deployment platform
Become configuration file by issue shell script and remotely perform shell script just can realize GG synchronization, for
Different release types is only configured with different basic datas, it is not necessary to the manual compilation operation of developer
Step.
For further illustrating, in conjunction with a concrete example, the OGG version that the embodiment of the present invention is provided is described
The principle of this dispositions method.As shown in Figure 4, in this embodiment, the process that OGG version is disposed includes:
(1) OGG version deployment platform obtain typing basic data, according to basic data generate link information,
Parameter File, SQL script and release type, and by link information, Parameter File, SQL script and version
Type is integrated generation shell script by ad hoc rule and is issued in source and destination end respective directories.
(2) OGG version deployment platform remotely controls to perform shell script, automatically generates according to release type
Corresponding version deployment program, i.e. operating procedure.
Such as, the operating procedure of generation is as follows:
1:stepinit: link deployment initializes
2:stepcheckdbversion: check db version
3:stepchecktran: control general's affairs
4:stepaddtrandata: add trandata
5:stepchecktrandata: check trandata
6:stepstope: stop e process
7:stepstopd: stop d process
8:stepreplacee: replace e process Parameter File
9:stepreplaced: replace d process Parameter File
10:stepstopr: stop r process
11:stepupdatedef: update def file
12:stepstarte: start e process
13:stepstartd: start d process
14:stepcreateview: create view
15:stepmergeinit: perform initializtion script
16:stepdropview: delete view
17:stepreplacer: replace r process Parameter File
18:stepstartr: start r process
19:stepmontime: monitoring r process-time point
20:stepstopr: stop r process
21:stepdelhdl: delete handlecollisions
22:stepstartr: start r process
23:stepcheckenv: check e, d, r process status
It follows that operating procedure can automatically generate, perform operating procedure and can realize version deployment.Additionally,
Operating procedure also comprises and automatically checks step.Such as check the version number of Parameter File, at alternative parameter
The step of step file performs;Checking process status, mend the 23rd and perform, updating def Files step just has
Automatically detection def version, to guarantee to have substituted for def version.
Shown in Fig. 4, OGG version deployment platform controls remotely to perform the operating procedure that shell script is main
Including: 1) control shell stop OGG extraction and pump program by deployment platform;2) portion is passed through
Administration's hip control very much shell program and return CSN;3) shell stop OGG is controlled by deployment platform
Reproducer;4) parameter obtained by deployment platform and data initialization determines how deployment;5) logical
Cross deployment platform and access target database, and can anonymous block, data (the anonymous block of initialized target end voluntarily
Can automatically close generation SQL script);6) by automatic deployment program, Parameter File is issued to storehouse, source;7) logical
Cross automatic deployment program and parameter is issued to object library;8) control shell program by deployment platform and open OGG
Extraction and pump program;9) control shell program by deployment platform and open OGG reproducer.
As it is shown in figure 5, in one embodiment, a kind of OGG version deployment system, this system are additionally provided
Including:
Configuration file generation module 502, for obtaining the basic data required for version is disposed, according to basis number
According to generating configuration file, this configuration file comprises version and disposes the basic data of needs.
Script file generation module 504, raw according to the basic data in configuration file for OGG deployment platform
Become link information, Parameter File, SQL script and release type, and by described link information, Parameter File,
SQL script and release type packing generate script file and are issued to dispose in catalogue.
Version deployment module 506, remotely performs script file for OGG deployment platform, according to script file
Deployment train.
In one embodiment, basic data includes: database configuration information, version configuration information and synchronization
Table configuration information;Wherein, database configuration information includes database-name, database host address and data
Storehouse port;Version configuration information includes OGG link information, OGG version number and OGG version date issued;
Synchronous meter configuration information includes source table table name, source literary name name section, target table name and aiming field title.
In one embodiment, version deployment module 506 for finding the source number of correspondence according to link information
According to storehouse and target database, generate corresponding version deployment program according to release type, dispose journey by version
Sequence carries out the start stop operation of process, Parameter File replacement, def file generated and SQL script and performs.
In one embodiment, version deployment module 506 is additionally operable to during performing version deployment program
Insert detection automatically.
In one embodiment, configuration file generation module 502 disposes institute for the version obtaining user's input
The basic data needed;Configuration file one key obtaining user's input generates order, by configuration file one key
Generate order and generate configuration file according to basic data.
Each technical characteristic of embodiment described above can combine arbitrarily, for making description succinct, the most right
The all possible combination of each technical characteristic in above-described embodiment is all described, but, if these skills
There is not contradiction in the combination of art feature, is all considered to be the scope that this specification is recorded.
Embodiment described above only have expressed the several embodiments of the present invention, and it describes more concrete and detailed,
But can not therefore be construed as limiting the scope of the patent.It should be pointed out that, for this area
For those of ordinary skill, without departing from the inventive concept of the premise, it is also possible to make some deformation and change
Entering, these broadly fall into protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be with appended power
Profit requires to be as the criterion.
Claims (10)
1. an OGG version dispositions method, it is characterised in that said method comprising the steps of:
OGG deployment platform obtains the basic data required for version is disposed, and generates according to described basic data and joins
Put file, described configuration file comprises version and disposes the basic data of needs;
OGG deployment platform according in described configuration file basic data generate link information, Parameter File,
SQL script and release type, and described link information, Parameter File, SQL script and release type are beaten
Bag generates script file and is issued to dispose in catalogue;
OGG deployment platform remotely performs described script file, according to described script file deployment train.
Method the most according to claim 1, it is characterised in that described basic data includes: data base
Configuration information, version configuration information and synchronous meter configuration information;
Described database configuration information includes database-name, database host address and data base's port;
Described version configuration information includes OGG link information, OGG version number and OGG version date issued;
Described synchronous meter configuration information includes source table table name, source literary name name section, target table name and aiming field
Title.
Method the most according to claim 1, it is characterised in that described according to script file deployment train
Step, including:
Source database and the target database of correspondence is found, according to described version class according to described link information
Type generates corresponding version deployment program, carries out the start stop operation of process, ginseng by described version deployment program
Number file replacement, def file generated and SQL script perform.
Method the most according to claim 3, it is characterised in that described according to script file deployment train
Step, also include: insert detection automatically during version deployment program performing.
Method the most according to claim 1, it is characterised in that described OGG deployment platform obtains version
Basic data required for this deployment, generates the step of configuration file according to described basic data, including:
Described OGG deployment platform obtains the basic data required for the version deployment of user's input;Obtain user
Configuration file one key of input generates order, generates order according to described basis by described configuration file one key
Data genaration configuration file.
6. an OGG version deployment system, it is characterised in that described system includes:
Configuration file generation module, for obtaining the basic data required for version is disposed, according to described basis
Data genaration configuration file, comprises version and disposes the basic data of needs in described configuration file;
Script file generation module, raw according to the basic data in described configuration file for OGG deployment platform
Become link information, Parameter File, SQL script and release type, and by described link information, Parameter File,
SQL script and the packing of version class generate script file and are issued to dispose in catalogue;
Version deployment module, remotely performs described script file for OGG deployment platform, according to described script
File deployment train.
System the most according to claim 6, it is characterised in that described basic data includes: data base
Configuration information, version configuration information and synchronous meter configuration information;
Described database configuration information includes database-name, database host address and data base's port;
Described version configuration information includes OGG link information, OGG version number and OGG version date issued;
Described synchronous meter configuration information includes source table table name, source literary name name section, target table name and aiming field
Title.
System the most according to claim 6, it is characterised in that described version deployment module is used for basis
Described link information finds source database and the target database of correspondence, generates phase according to described release type
The version deployment program answered, carries out the start stop operation of process by described version deployment program, Parameter File replaces
Change, def file generated and SQL script perform.
System the most according to claim 8, it is characterised in that described version deployment module is additionally operable to
Detection automatically is inserted during performing version deployment program.
System the most according to claim 6, it is characterised in that described configuration file generation module is used
Basic data required for the version obtaining user's input is disposed;Obtain configuration file one key of user's input
Generate order, generate order by described configuration file one key and generate configuration file according to described basic data.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610222213.8A CN105867978B (en) | 2016-04-11 | 2016-04-11 | OGG version dispositions method and system |
PCT/CN2017/074559 WO2017177769A1 (en) | 2016-04-11 | 2017-02-23 | Ogg version deployment method and system, server, and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610222213.8A CN105867978B (en) | 2016-04-11 | 2016-04-11 | OGG version dispositions method and system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105867978A true CN105867978A (en) | 2016-08-17 |
CN105867978B CN105867978B (en) | 2018-12-11 |
Family
ID=56637514
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610222213.8A Active CN105867978B (en) | 2016-04-11 | 2016-04-11 | OGG version dispositions method and system |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN105867978B (en) |
WO (1) | WO2017177769A1 (en) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2017177769A1 (en) * | 2016-04-11 | 2017-10-19 | 平安科技(深圳)有限公司 | Ogg version deployment method and system, server, and storage medium |
CN107729019A (en) * | 2017-10-09 | 2018-02-23 | 平安普惠企业管理有限公司 | Method, apparatus, equipment and the computer-readable storage medium of version deployment |
CN108845915A (en) * | 2018-07-02 | 2018-11-20 | 山东浪潮商用系统有限公司 | A kind of database data monitoring method |
CN108958751A (en) * | 2018-06-01 | 2018-12-07 | 优刻得科技股份有限公司 | The method, apparatus of software deployment or maintenance, system and storage medium |
CN109189400A (en) * | 2018-08-07 | 2019-01-11 | 北京趣拿软件科技有限公司 | Program dissemination method and device, storage medium, processor |
CN110162461A (en) * | 2019-04-16 | 2019-08-23 | 平安科技(深圳)有限公司 | Data synchronize verification method, device and computer equipment |
CN111552746A (en) * | 2020-04-30 | 2020-08-18 | 北京思特奇信息技术股份有限公司 | Data synchronization method and device, electronic equipment and storage medium |
Families Citing this family (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109840194B (en) * | 2017-11-28 | 2022-07-08 | 网宿科技股份有限公司 | Method and system for detecting configuration file |
CN109446267B (en) * | 2018-09-25 | 2023-06-02 | 国家电网有限公司客户服务中心 | Cross-database data integration system and method based on 95598 ex-situ double-active disaster recovery model |
CN109901842A (en) * | 2019-01-17 | 2019-06-18 | 深圳壹账通智能科技有限公司 | Application deployment method, apparatus, computer equipment and storage medium |
CN110716914A (en) * | 2019-09-02 | 2020-01-21 | 平安普惠企业管理有限公司 | Database configuration method, system, computer readable storage medium and terminal equipment |
CN110597552B (en) * | 2019-09-04 | 2023-08-18 | 浙江大搜车软件技术有限公司 | Configuration method, device, equipment and storage medium of project continuous integrated pipeline |
CN111026414B (en) * | 2019-12-12 | 2023-09-08 | 杭州安恒信息技术股份有限公司 | HDP platform deployment method based on kubernetes |
CN111290906B (en) * | 2020-01-10 | 2023-07-21 | 安徽科大国创软件科技有限公司 | Java application monitoring method and system based on perception mechanism |
CN111813683B (en) * | 2020-07-14 | 2023-10-03 | 深圳前海移联科技有限公司 | Universal automatic synchronization method for software testing environment |
CN111813439B (en) * | 2020-07-17 | 2024-03-29 | 前海人寿保险股份有限公司 | Distribution material quality control method, device, equipment and computer storage medium |
CN112631868B (en) * | 2020-12-28 | 2023-06-16 | 浙江中控技术股份有限公司 | Performance monitoring method and device of CentOS system |
CN113239005B (en) * | 2021-06-02 | 2022-12-02 | 上海许继电气有限公司 | I and IV area data synchronization method and device for power monitoring system |
CN114553930B (en) * | 2022-01-26 | 2024-04-16 | 石化盈科信息技术有限责任公司 | System integration method, device, computer equipment and storage medium |
CN114816470A (en) * | 2022-03-30 | 2022-07-29 | 海南乾唐视联信息技术有限公司 | Metadata database management method and device, electronic equipment and medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080072217A1 (en) * | 2006-09-14 | 2008-03-20 | International Business Machines Corporation | Method, apparatus, and system for customizing and performing policy in version control |
CN104102511A (en) * | 2014-07-17 | 2014-10-15 | 福建星海通信科技有限公司 | SQL (structured query language) Server based automatic script upgrading system and method |
CN105068886A (en) * | 2015-07-30 | 2015-11-18 | 上海新炬网络信息技术有限公司 | Disaster backup intelligent switching control method based on GoldenGate |
CN105204897A (en) * | 2015-09-14 | 2015-12-30 | 上海新炬网络信息技术有限公司 | Batched MySQL installation and deployment method |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104965735B (en) * | 2015-06-18 | 2018-10-19 | 北京京东尚科信息技术有限公司 | Device for generating upgrading SQL scripts |
CN105867978B (en) * | 2016-04-11 | 2018-12-11 | 平安科技(深圳)有限公司 | OGG version dispositions method and system |
-
2016
- 2016-04-11 CN CN201610222213.8A patent/CN105867978B/en active Active
-
2017
- 2017-02-23 WO PCT/CN2017/074559 patent/WO2017177769A1/en active Application Filing
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080072217A1 (en) * | 2006-09-14 | 2008-03-20 | International Business Machines Corporation | Method, apparatus, and system for customizing and performing policy in version control |
CN104102511A (en) * | 2014-07-17 | 2014-10-15 | 福建星海通信科技有限公司 | SQL (structured query language) Server based automatic script upgrading system and method |
CN105068886A (en) * | 2015-07-30 | 2015-11-18 | 上海新炬网络信息技术有限公司 | Disaster backup intelligent switching control method based on GoldenGate |
CN105204897A (en) * | 2015-09-14 | 2015-12-30 | 上海新炬网络信息技术有限公司 | Batched MySQL installation and deployment method |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2017177769A1 (en) * | 2016-04-11 | 2017-10-19 | 平安科技(深圳)有限公司 | Ogg version deployment method and system, server, and storage medium |
CN107729019A (en) * | 2017-10-09 | 2018-02-23 | 平安普惠企业管理有限公司 | Method, apparatus, equipment and the computer-readable storage medium of version deployment |
CN108958751A (en) * | 2018-06-01 | 2018-12-07 | 优刻得科技股份有限公司 | The method, apparatus of software deployment or maintenance, system and storage medium |
CN108958751B (en) * | 2018-06-01 | 2020-09-04 | 优刻得科技股份有限公司 | Method, device, system and storage medium for software deployment or maintenance |
CN108845915A (en) * | 2018-07-02 | 2018-11-20 | 山东浪潮商用系统有限公司 | A kind of database data monitoring method |
CN109189400A (en) * | 2018-08-07 | 2019-01-11 | 北京趣拿软件科技有限公司 | Program dissemination method and device, storage medium, processor |
CN110162461A (en) * | 2019-04-16 | 2019-08-23 | 平安科技(深圳)有限公司 | Data synchronize verification method, device and computer equipment |
CN110162461B (en) * | 2019-04-16 | 2023-08-15 | 平安科技(深圳)有限公司 | Data synchronization verification method and device and computer equipment |
CN111552746A (en) * | 2020-04-30 | 2020-08-18 | 北京思特奇信息技术股份有限公司 | Data synchronization method and device, electronic equipment and storage medium |
CN111552746B (en) * | 2020-04-30 | 2023-04-28 | 北京思特奇信息技术股份有限公司 | Data synchronization method, device, electronic equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN105867978B (en) | 2018-12-11 |
WO2017177769A1 (en) | 2017-10-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105867978A (en) | OGG version deployment method and system | |
RU2599538C2 (en) | Methods and systems for loading data into temporal data warehouse | |
US10970673B2 (en) | Bill of material synchronization | |
Sanderson et al. | Automatic data organization, storage, and analysis of camera trap pictures | |
US7051020B2 (en) | Intelligent query re-execution | |
EP2610765B1 (en) | Systems and methods for migrating database data | |
US20140222758A1 (en) | Coherent File State Maintained Among Confederated Repositories By Distributed Workspace Apparatuses Backed Up By a File State Ledgerdemain Store | |
US8224832B2 (en) | Computerized document examination for changes | |
CN105354036B (en) | Database manipulation code generating method and device | |
US20090070391A1 (en) | Systems, methods and software programs for data synchronization | |
CN109522290A (en) | A kind of HBase data block restores and data record extraction method | |
CN109189852A (en) | A kind of method that data are synchronous and the device synchronous for data | |
CN107122361A (en) | Data mover system and method | |
CN105279285B (en) | A kind of synchronization system and method for relevant database and non-relational database | |
CN105205053A (en) | Method and system for analyzing database incremental logs | |
CN101548267A (en) | A method and system for managing and organizing software package installations | |
GB2574282A (en) | Data consistency verification method and system minimizing load of original database | |
US6915313B2 (en) | Deploying predefined data warehouse process models | |
JP5412995B2 (en) | Database control apparatus, database control method, and database control program in program model checking | |
EP3822807A1 (en) | Techniques for application undo and redo using sql patchsets or changesets | |
CN110532275A (en) | A kind of implementation method that cross-domain data is synchronous with file update | |
CN108984337A (en) | A kind of restorative procedure of data synchronous abnormality, prosthetic device, medium and calculate equipment | |
CN109343863B (en) | Interface configuration method and system for HDFS (Hadoop distributed File System) permission | |
JP2007193504A (en) | Test case preparation method, test case preparation system and test case preparation program | |
WO2016117007A1 (en) | Database system and database management method |
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 |