CN101266606B - On-line data migration method based on Oracle database - Google Patents
On-line data migration method based on Oracle database Download PDFInfo
- Publication number
- CN101266606B CN101266606B CN2007100886811A CN200710088681A CN101266606B CN 101266606 B CN101266606 B CN 101266606B CN 2007100886811 A CN2007100886811 A CN 2007100886811A CN 200710088681 A CN200710088681 A CN 200710088681A CN 101266606 B CN101266606 B CN 101266606B
- Authority
- CN
- China
- Prior art keywords
- source
- trigger
- data
- log
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Images
Abstract
The invention discloses a method for realizing online data migration based on Oracle database, mainly comprising: prebuilt mv,trigger+procedure and trigger+sql*loader+ programs. The three modes comprise using operation log, total refreshment log and incremental refreshment log, and migration change to complete the data migration. By using the prebuilt mv and trigger+procedure programs according to the invention, the cross-platform, and cross-version data migration can be realized; by using the trigger+sql*loader+ program, the conversion among databases of different character sets can be realized by the text file or communication among processes, thereby realizing cross-character set data migration.
Description
Technical field
The present invention relates to the database application technology, relate in particular to the application technology of oracle database.
Background technology
Along with the speed that data base management system (DBMS) and operating system platform update is constantly accelerated, the Database Engineer often need carry out data migtation between two different databases or between two kinds of different operating systems platforms.Data migtation is meant moves to another machine with data from a machine, perhaps data are moved to another database from a database, and these data (comprising organization definition) can be moved normally after transfer.
In the prior art, data migration method commonly used mainly comprises: derivation/importing (expdp/impdp) mode, the insert/ that adopt derivation/importing (export/import) or Oracle10g version to provide
*+ append
*/ into...from db_link+nologging, standby migration pattern, the mode of utilizing data migtation that stream and related tool carry out and combining based on the cross-platform data file conversion of table space transmission and Oracle10g.But the stop time that these above-mentioned migration patterns have is long, have be difficult to confirm to begin fully synchronously the time the SCN point, have then can not be cross-platform, cross-version and stride character set and carry out data migtation.
Summary of the invention
Existing above-mentioned technological deficiency when carrying out data migtation based on oracle database the invention provides and can realize cross-platform, cross-version and efficient online data moving method fast.
According to one aspect of the present invention, a kind of employing prebuilt mv is provided, and (materialized view: Materialized View) mode is carried out the method for data migtation.This method is meant on create good table in advance sets up Materialized View, and when this Materialized View was deleted, the table of originally having created still kept, and the data of coming synchronously simultaneously also are retained.This method adopts the single object of table object as data migtation, and refreshes mv to this table object with a major key.At first on the table of source, create the mv daily record, and on target database, create the same object table of structure; On object table, adopt the prebuilt mode to create mv then, and refresh fully; Adopt the incremental refreshment mode in the constructive process afterwards, the daily record that when needs carry out the database switching, only need refresh increment, deletion mv and reservation object table.The data migtation that this method realized can adopt the following step:
(1) according to predetermined amount of capacity table object is carried out classification, will show as big above the table object of said predetermined volumes, the table object that will be lower than said predetermined volumes is as little table;
(2) said big table is shown as the source, on source database, created materialized view log;
(3) on target database, create the identical object table of showing with said source of structure, and on said object table, adopt the prebuilt mode to create Materialized View;
(4) synchronization log is refreshed fully;
(5) said synchronization log is carried out incremental refreshment;
(6) establishment can realize the program code that auto-increment refreshes;
(7) handle all big tables successively by above-mentioned steps (2)-(6);
(8) to adopting insert/
*+ append
*The little table that/into...from db_link handles is put the script of insertinto in order;
(9) the described insertinto script of operation carries out data migtation to said little table; And
(10) migration is switched.
More specifically; Moving when switching, comprising following sequence of operations: stop source database all activities, wait for the last batch of daily record accomplish incremental refreshment, operation little table script and the little table data of insertinto, wait for all big tables accomplish refresh, mvlog and the mv in the object table in the table of deletion source and keep object table and data, establishment and object table have the object (like the sequence of self-propagation) of dependence.
According to another aspect of the present invention, provide a kind of mode (trigger+procedure) of using establishment trigger and constructive process to combine to carry out the method for data migtation.This method adopts the single object of table object as data migtation, and requires this table object that a major key is arranged.At first utilize this table of recording trigger DML (DataManipulation Language: daily record DML), synchronous through user-defined process and this DML daily record then.In view of this method has mainly remedied the shortcoming that is difficult to refresh big table when employing prebuiltmv mode is carried out data migtation, the following step mainly is used for refreshing fully big table:
(1) according to predetermined amount of capacity table object is carried out classification, will show as big above the table object of said predetermined volumes, the table object that will be lower than said predetermined volumes is as little table;
(2) said big table is shown as the source, on the table of said source, created the trigger of DML;
(3) on target database, create and the identical object table of said source list structure;
(4) after said trigger is started working, be written in data to the said object table of said target database in the table of said source in batches;
(5) on said target database, create user-defined process;
(6) refresh the synchronization log that produces by said trigger fully;
(7) said synchronization log is carried out incremental refreshment; And
(8) migration is switched.
More specifically, when moving switching, comprise following sequence of operations: accomplish the operation that refreshes, deletes trigger and this process and scheduling of daily record, the synchronous refresh of completion object table through user-defined process.
According to another aspect of the present invention, a kind of establishment trigger and self defining programm are provided and have used sql
*Loader instrument (the trigger+sql that combines
*The loader+ program) carries out the method for data migtation.This method mainly utilizes text or process communication to carry out intermediate conversion, through sql
*Loader is written into data, and according to the self-defining process analysis synchronization log of Database Engineer.It is pointed out that and utilize sql
*The loader instrument can successfully import to some data of depositing with text file format in the oracle database, is a kind of data migtation means very convenient and commonly used of between disparate databases, carrying out.This method can be carried out data migtation through following step:
(1) according to predetermined amount of capacity table object is carried out classification, will show as big above the table object of said predetermined volumes, the table object that will be lower than said predetermined volumes is as little table;
(2) said big table is shown as the source, on the table of said source, created the trigger of DML;
(3) on target database, create and the identical object table of said source list structure;
(4) after said trigger is started working, be written in data to the said object table of said target database in the table of said source in batches;
(5) utilize two processes to connect the database of kinds of characters collection respectively in the middle layer;
(6) refresh the synchronization log that produces by said trigger fully;
(7) said synchronization log is carried out incremental refreshment; And
(8) migration is switched.
More specifically, the little table in the step (1) is written into and comprises dual mode: utilize select or program to generate text, through Sql
*Loader is written into; The script that directly generates insert into is carried out to text then.
More specifically, synchronization log can adopt two kinds of schemes in the step (6), and the one, on the source, directly generate the DML statement according to daily record, adopt text mode to send to target and carry out; The one, utilize two processes in the middle layer, connect the database of kinds of characters collection respectively, one of them process is used to analyze daily record, and another process is used for synchronization log.
More specifically, the switching of the migration in the step (8) comprises intact last synchronously daily record, stops synchronization program.
Adopt among the present invention prebuilt mv mode, trigger+Procedure mode and trigger+sql based on oracle database
*The moving method that the loader+ program mode (PM) is carried out all can be realized cross-platform and the data migtation integration across database version, and can accomplish the reorganization optimization of data, wherein trigger+Sql
*The loader+ program mode (PM) can also realize striding the data migtation of character set, very big has improved efficiency of data migration, has reduced shutdown switching time.
Description of drawings
The reader with reference to advantages after the embodiment of the present invention, will become apparent various aspects of the present invention.Wherein,
Fig. 1 shows the method for several kinds of data migtations commonly used in the prior art;
Fig. 2 shows three kinds of modes that realize online data migtation among the present invention;
Fig. 3 shows among the present invention the online data moving method based on prebuilt mv mode;
Fig. 4 shows among the present invention the online data moving method based on the trigger+procedure mode; And
Fig. 5 shows among the present invention based on trigger+sql
*The online data moving method of loader+ program mode (PM).
Embodiment
With reference to the accompanying drawings, specific embodiments of the invention is done further to describe in detail.
Fig. 1 shows the method for several kinds of data migtations commonly used in the prior art, and wherein, the mode that can carry out the online data migration comprises standby, stream and related tool; Need the long mode that can accomplish data migtation stop time to comprise expdp/impdp, employing instruction insert/ under exp/imp or the Oracle10g version
*+ append
*The dblink mode of/into...from db_link+nologging and table space transmission.With reference to Fig. 1, above-mentioned several kinds of data migration methods commonly used according to whether supporting online migration can be divided into following flow process and carry out:
(1) data migtation prepares 100;
(2) the whether judgement 102 of online migration;
(3), then carry out to shut down and safeguard 104 if do not carry out online migration;
(4) migration pattern of using always, like derivation/importing, dblink, table space transmission etc. 106;
(5) if carry out online migration, then adopt standby, stream and related tool etc. 108;
(6) migration switches 110; And
(7) after executing 106 or 110, accomplish data migtation 112.
Fig. 2 shows three kinds of modes that realize online data migtation among the present invention, that is, and and prebuilt mv mode, trigger+procedure mode, trigger+sql
*The loader+ program mode (PM).Above-mentioned three kinds of modes are the DML Operation Log of record source table all, and through refreshing synchronization log and incremental refreshment synchronization log fully, to realize the data migtation of the table object of different capabilities in the source database.More specifically, prebuilt mv mode and trigger+procedure mode can realize cross-platform and data migtation cross-version, and trigger+sql
*The loader+ program mode (PM) can not only realize cross-platform and data migtation cross-version, but also the communication between text capable of using or process realizes striding the data migtation of character set.With reference to figure 2, the present invention realizes that the several method of online data migtation can have following flow process to come common expression:
(1) data migtation prepares 200;
(2) the online data migration 202;
(3) based on the data migtation 204 of cross-platform, the cross-version of oracle database;
(4) based on cross-platform, the cross-version of oracle database, stride the data migtation 206 of character set;
(5), can adopt prebuilt mv mode 208 or adopt trigger+procedure mode 210 if carry out 204 data migtation;
(6) if carry out 206 data migtation, can adopt trigger+sql
*Loader+ program mode (PM) 212;
(7) when the method for carrying out 208,210 or 212 realizes data migtation, log 214;
(8) refresh synchronization log 216 fully;
(9) the incremental refreshment synchronization log 218;
(10) migration switches 220; And
(11) accomplish data migtation 222.
Fig. 3, Fig. 4 and Fig. 5 are respectively the concrete realization flows of above-mentioned three kinds of data migtation modes, below it are done to set forth successively.
Fig. 3 shows among the present invention the online data moving method based on prebuilt mv mode.This method is the single object of table object as data migtation, and accomplishes data migtation through following concrete steps:
(1) data migtation prepares 300;
(2) with the single object 302 of table object as migration;
(3) whether the table capacity greater than the judgement 304 of 100M, carries out classification according to amount of capacity to table object, and the table object of the above capacity of 100M is called big table, and the table object of the following capacity of 100M is called little table;
(4) adopt insert into mode migration data 306;
(5) script 308 of arrangement insert into;
(6) operation insert into script moves the data 310 in the little table;
(7) on source database, create the mv daily record, with the DML operation 312 of record source table, the instruction of creating the mv daily record is:
create?materialized?view?log?on?table_name；
(8) refresh synchronization log 314 fully, its concrete execution command is:
exec?dbms_mview.refresh(‘table_name’，method＝>’Complete’)；
(9) the incremental refreshment synchronization log 316, and its concrete execution command is:
exec?dbms_mview.refresh(‘table_name’)
declare?jobid?number；
begin
sys.dbms_job.submit(job＝>jobid，
what＝>’dbms_mview.refresh(“table_name”)；’，
next_date＝>sysdate，
interval＝>’sysdate+1/1440’)；
commit；
end；
And
(10) migration switching 318 and completion data migtation 320.
Wherein step migration switches 318, it comprises all activities of stopping source database, wait for the last batch of daily record accomplish incremental refreshment, operation little table script and the little table data of insertinto, wait for all big tables accomplish refresh, mvlog and the mv in the object table in the table of deletion source and keep object table and data, establishment and object table have the object (like the sequence of self-propagation) of dependence.
Fig. 4 shows among the present invention the online data moving method based on the trigger+procedure mode.This method adopts the DML daily record of recording trigger source table; Adopt user-defined process synchronization log to accomplish data migtation; When the self-defining process of trigger and this is used in combination; The user can write the business demand of oneself during the course according to the needs of oneself, also can the table in a plurality of databases be flushed in the object table data migtation thereby become more flexible.This method can realize through following concrete steps:
(1) data migtation prepares 400;
(2) with the single object 402 of table object as migration;
(3) whether the his-and-hers watches capacity greater than the judgement 404 of 100M, carries out classification according to amount of capacity to table object, and the table object of the above capacity of 100M is called big table, and the table object of the following capacity of 100M is called little table;
(4) adopt insert into mode migration data 406;
(5) script 408 of arrangement insertinto;
(6) operation insert into script moves the data 410 in the little table;
(7) on source database, create log sheet 412, more specifically, the establishment of log sheet can be expressed as:
create?table?REP_TABLE_LOGS
(
REP_KEY NUMBER?not?null，
DML_TYPE VARCHAR2(1)not?null，
DML_TIME DATE?default?sysdate?not?null，
REP_FLAG NUMBER?default?O?not?null
)；
(8) trigger 414 of establishment DML on the table of source;
(9) judge whether trigger starts working 416;
(10) be written in batches in data to the target database of source table 418;
(11) on target database, create procedure, fully the synchronization log 420 of refresh trigger generation;
(12) the incremental refreshment synchronization log 422; And
(13) migration switching 424 and completion data migtation 426.
Fig. 5 shows among the present invention based on trigger+sql
*The online data moving method of loader+ program mode (PM).This method utilizes the communication between text or process to carry out intermediate conversion, accomplishes migration with the data that realize the kinds of characters collection.This moving method also can adopt following step to implement:
(1) data migtation prepares 500;
(2) with the single object 502 of table object as migration;
(3) whether the his-and-hers watches capacity judges 504 greater than 100M, according to predetermined amount of capacity table object is carried out classification, will show as big above the table object of said predetermined volumes, and the table object that will be lower than said predetermined volumes is as little table;
(4) utilize select or program to generate text 506;
(5) pass through sql
*Loader is written into data 508;
(6) create self defining programm, play the database 510 that two processes connect the kinds of characters collection respectively;
(7) on source database, create log sheet 512;
(8) trigger 514 of establishment DML on the table of source;
(9) judge whether trigger starts working 516;
(10) be written in batches in data to the target database of source table 518;
(11) utilize two processes in the middle layer, connect the database of kinds of characters collection respectively, analyze and synchronization log 520;
(12) the incremental refreshment synchronization log 522; And
(13) migration switching 524 and completion data migtation 526.
More specifically, the two kinds of schemes of The data in step (3) in the little table of migration, the one, utilize select or program to generate text, and pass through sql
*The loader instrument is written into data; The one, the script that directly generates insertinto is to text and execution.
More specifically, synchronization log another kind of scheme also capable of using realizes in step (11),, on source database, according to daily record, directly generates the DML statement that is, and adopts the mode of text to send to the target database execution.
In the preceding text, illustrate and describe embodiment of the present invention.But those skilled in the art can understand, and under situation without departing from the spirit and scope of the present invention, can also specific embodiments of the invention do various changes and replacement.These changes and replacement all drop in claims of the present invention institute restricted portion.
Claims (14)
1. the online data moving method based on oracle database is characterized in that, this method adopts the following step to realize:
(1) according to predetermined amount of capacity table object is carried out classification, will show as big above the table object of said predetermined volumes, the table object that will be lower than said predetermined volumes is as little table;
(2) said big table is shown as the source, on source database, created materialized view log;
(3) on target database, create the identical object table of showing with said source of structure, and on said object table, adopt the prebuilt mode to create Materialized View;
(4) synchronization log is refreshed fully;
(5) said synchronization log is carried out incremental refreshment;
(6) establishment can realize the program code that auto-increment refreshes;
(7) handle all big tables successively by above-mentioned steps (2)-(6);
(8) to adopting insert/
*+ append
*The little table that/into...from db_link handles is put the script of insert in order;
(9) the described insert into script of operation carries out data migtation to said little table; And
(10) migration is switched.
2. the method for claim 1 is characterized in that, when execution in step (3), the structure of said source table remains unchanged after said log creation is accomplished and before duplicating of migration data accomplished.
3. the method for claim 1 is characterized in that, said only refreshing fully when for the first time synchronous said daily record carried out.
4. the online data moving method based on oracle database is characterized in that, this method adopts the following step to realize:
(1) according to predetermined amount of capacity table object is carried out classification, will show as big above the table object of said predetermined volumes, the table object that will be lower than said predetermined volumes is as little table;
(2) said big table is shown as the source, on the table of said source, created the trigger of DML;
(3) on target database, create and the identical object table of said source list structure;
(4) after said trigger is started working, be written in data to the said object table of said target database in the table of said source in batches;
(5) on said target database, create user-defined process;
(6) refresh the synchronization log that produces by said trigger fully;
(7) said synchronization log is carried out incremental refreshment; And
(8) migration is switched,
Wherein, create the Operation Log of the said DML that said user-defined process can be synchronously produces by said trigger.
5. method as claimed in claim 4 is characterized in that, when execution in step (1), to being lower than the table object of said predetermined volumes, adopts insert/
*+ append
*/ into...from db_link carries out data migtation.
6. method as claimed in claim 4 is characterized in that, the REP_KEY of said daily record is used to deposit the major key of said source table, and field type depends on the field type of said source table.
7. method as claimed in claim 4 is characterized in that, when execution in step (3), the structure of said source table remains unchanged after said trigger is created completion and before duplicating of migration data accomplished.
8. method as claimed in claim 4 is characterized in that, said trigger can write down the Operation Log of the DML of said source table.
9. the online data moving method based on oracle database is characterized in that, this method adopts the following step to realize:
(1) according to predetermined amount of capacity table object is carried out classification, will show as big above the table object of said predetermined volumes, the table object that will be lower than said predetermined volumes is as little table;
(2) said big table is shown as the source, on the table of said source, created the trigger of DML;
(3) on target database, create and the identical object table of said source list structure;
(4) after said trigger is started working, be written in data to the said object table of said target database in the table of said source in batches;
(5) utilize two processes to connect the database of kinds of characters collection respectively in the middle layer;
(6) refresh the synchronization log that produces by said trigger fully;
(7) said synchronization log is carried out incremental refreshment; And
(8) migration is switched.
10. method as claimed in claim 9 is characterized in that, when execution in step (1), to the table object less than said predetermined volumes, utilizes select instruction or program code to generate text, through Sql
*Loader is written into.
11. method as claimed in claim 9 is characterized in that, when execution in step (1), to the table object less than said predetermined volumes, the script that directly generates insert into is to text and carry out.
12. like claim 10 or 11 described methods, it is characterized in that, when execution in step (5); Utilize user-defined program; Create said two processes, and said two processes are connected to the database of kinds of characters collection respectively, to stride the data migtation of character set.
13. method as claimed in claim 9 is characterized in that, said trigger can write down the DML Operation Log of said source table.
14. method as claimed in claim 9 is characterized in that, two processes comprise first process and second process described in the step (5), and said first process is used to analyze daily record, and said second process is used for synchronization log.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007100886811A CN101266606B (en) | 2007-03-15 | 2007-03-15 | On-line data migration method based on Oracle database |
| HK08113829.2A HK1120887A1 (en) | 2007-03-15 | 2008-12-19 | Method for on-line data migration based on oracle database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007100886811A CN101266606B (en) | 2007-03-15 | 2007-03-15 | On-line data migration method based on Oracle database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101266606A CN101266606A (en) | 2008-09-17 |
| CN101266606B true CN101266606B (en) | 2012-06-20 |
Family
ID=39989029
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2007100886811A Expired - Fee Related CN101266606B (en) | 2007-03-15 | 2007-03-15 | On-line data migration method based on Oracle database |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN101266606B (en) |
| HK (1) | HK1120887A1 (en) |
Families Citing this family (34)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101382949B (en) * | 2008-10-28 | 2011-09-07 | 阿里巴巴集团控股有限公司 | Management method for database table and apparatus |
| CN102043801A (en) * | 2009-10-16 | 2011-05-04 | 无锡华润上华半导体有限公司 | Inter-database data interaction method and system, database of transmitter and database of receiver |
| CN101674495B (en) * | 2009-10-20 | 2015-06-03 | 中兴通讯股份有限公司 | Method and device for preprocessing data disaster tolerance |
| CN101706803B (en) * | 2009-11-27 | 2012-07-04 | 天津工业大学 | Method for migrating production data of weaving workshop |
| CN102737319A (en) * | 2011-04-08 | 2012-10-17 | 中兴通讯股份有限公司 | Method and system for marketing analysis based on business database |
| TR201112086A2 (en) | 2011-12-06 | 2012-05-21 | Krea İçeri̇k Hi̇zmetleri̇ Ve Prodüksi̇yon Anoni̇m Şi̇rketi̇ | Fast data transfer method and system from source database to target database. |
| CN103514180A (en) * | 2012-06-21 | 2014-01-15 | 中兴通讯股份有限公司 | Data providing method and device |
| CN103914458A (en) * | 2012-12-29 | 2014-07-09 | 中国移动通信集团河北有限公司 | Mass data migration method and device |
| US10776244B2 (en) | 2013-07-09 | 2020-09-15 | Oracle International Corporation | Consolidation planning services for systems migration |
| US11157664B2 (en) | 2013-07-09 | 2021-10-26 | Oracle International Corporation | Database modeling and analysis |
| US9805070B2 (en) * | 2013-07-09 | 2017-10-31 | Oracle International Corporation | Dynamic migration script management |
| US9747311B2 (en) | 2013-07-09 | 2017-08-29 | Oracle International Corporation | Solution to generate a scriptset for an automated database migration |
| US9996562B2 (en) | 2013-07-09 | 2018-06-12 | Oracle International Corporation | Automated database migration architecture |
| CN103455557B (en) * | 2013-08-08 | 2016-06-29 | 上海新炬网络技术有限公司 | A kind of structural data synchronous method based on daily record |
| CN103559272A (en) * | 2013-11-05 | 2014-02-05 | 北京国双科技有限公司 | Method and device for importing data into dimension table |
| CN104462344B (en) * | 2014-12-04 | 2018-04-03 | 北京国双科技有限公司 | In the processing method and processing device of destination server structure ETL system |
| GB2533086A (en) * | 2014-12-08 | 2016-06-15 | Ibm | Controlling a multi-database system |
| CN104536994A (en) * | 2014-12-11 | 2015-04-22 | 北京京东尚科信息技术有限公司 | Universal data migration method and device |
| CN105868204B (en) * | 2015-01-21 | 2019-06-21 | 中移信息技术有限公司 | A kind of method and device for converting Oracle scripting language SQL |
| CN104573056A (en) * | 2015-01-22 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Database large data volume online migration method based on oracle |
| CN104573122B (en) * | 2015-02-09 | 2017-10-13 | 浪潮电子信息产业股份有限公司 | It is a kind of from AIX platforms to the oracle database Migration tools of K UX platform migrations |
| CN107357791B (en) * | 2016-05-10 | 2021-10-15 | 中兴通讯股份有限公司 | Data sharing method and device |
| US11036696B2 (en) | 2016-06-07 | 2021-06-15 | Oracle International Corporation | Resource allocation for database provisioning |
| CN106095969A (en) * | 2016-06-17 | 2016-11-09 | 浪潮(北京)电子信息产业有限公司 | A kind of method of data syn-chronization, device, system and data base |
| CN106776688A (en) * | 2016-11-10 | 2017-05-31 | 国云科技股份有限公司 | A kind of cross-platform physical migration network system realization of oracle database |
| CN107247727A (en) * | 2017-04-28 | 2017-10-13 | 北京五八信息技术有限公司 | Data migration method and equipment |
| CN107992512A (en) * | 2017-10-20 | 2018-05-04 | 中国建设银行股份有限公司上海市分行 | A kind of method of Data Migration, system and computer-readable recording medium |
| CN108897773B (en) * | 2018-05-31 | 2019-12-27 | 湖南格凡安信科技有限公司 | Transparent online database anonymization data parallel migration method |
| CN110647421B (en) * | 2018-06-27 | 2022-11-25 | 阿里巴巴集团控股有限公司 | Database processing method, device and system and electronic equipment |
| CN109189761A (en) * | 2018-08-31 | 2019-01-11 | 中国农业银行股份有限公司 | A kind of data migration method and device |
| CN109284281A (en) * | 2018-09-10 | 2019-01-29 | 北京百度网讯科技有限公司 | Method and apparatus for migrating data |
| CN109165260A (en) * | 2018-09-25 | 2019-01-08 | 安徽信息工程学院 | Method of data transfer based on ORACLE data basd link |
| US11256671B2 (en) | 2019-09-13 | 2022-02-22 | Oracle International Corporation | Integrated transition control center |
| CN113297182B (en) * | 2021-06-16 | 2024-01-30 | 中国农业银行股份有限公司 | Data migration method, device, storage medium and program product |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1477546A (en) * | 2002-08-19 | 2004-02-25 | 万达信息股份有限公司 | Method for duplicating data of identical data table between two data bases |
-
2007
- 2007-03-15 CN CN2007100886811A patent/CN101266606B/en not_active Expired - Fee Related
-
2008
- 2008-12-19 HK HK08113829.2A patent/HK1120887A1/en not_active IP Right Cessation
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1477546A (en) * | 2002-08-19 | 2004-02-25 | 万达信息股份有限公司 | Method for duplicating data of identical data table between two data bases |
Non-Patent Citations (2)
| Title |
|---|
| JP特开2003-140932A 2003.05.16 |
| 温力.oracle数据库的数据迁移方法.计算机世界.2000,3,4. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101266606A (en) | 2008-09-17 |
| HK1120887A1 (en) | 2009-04-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101266606B (en) | On-line data migration method based on Oracle database | |
| US20190317944A1 (en) | Methods and apparatus for integrated management of structured data from various sources and having various formats | |
| CN102508706B (en) | Multi-source data integrating platform and establishing method thereof | |
| US7953891B2 (en) | Systems and methods for scheduling data flow execution based on an arbitrary graph describing the desired data flow | |
| US7912811B2 (en) | Computer-based system and computer program product for collaborative editing of documents | |
| CN101017546A (en) | Method and device for categorical data batch processing | |
| CN102073540B (en) | Distributed affair submitting method and device thereof | |
| US8996458B2 (en) | High volume, high speed adaptive data replication | |
| CN108537503A (en) | software development management system | |
| US20050278152A1 (en) | Systems and methods for distributing a workplan for data flow execution based on an arbitrary graph describing the desired data flow | |
| CN109656911A (en) | Distributed variable-frequencypump Database Systems and its data processing method | |
| CA2439923A1 (en) | System and method for maintaining large-grained database concurrency with a log monitor incorporating dynamically redefinable business logic | |
| CN101980207B (en) | Method and system for implementing database access | |
| CN101794247A (en) | Real-time database failure recovery method under nested transaction model | |
| CN109299180B (en) | ETL operating system of data warehouse | |
| US7707181B2 (en) | System and method of distributing replication commands | |
| CN103914458A (en) | Mass data migration method and device | |
| CN102306200A (en) | Device and method for concurrently applying incremental data manipulation statements | |
| CN104317957A (en) | Open platform and system for processing reports and report processing method | |
| EP2722774A1 (en) | Long term archiving of data in a MES system | |
| CN1549128A (en) | Databank back-up method | |
| CN113961546A (en) | Real-time query library design method supporting online analysis statistics | |
| CN1983270A (en) | Database schema for content managed data and its setting method and sytem | |
| Zhou et al. | An ETL strategy for real-time data warehouse | |
| Li et al. | Hadoop-Based University Ideological and Political Big Data Platform Design and Behavior Pattern Mining |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1120887 Country of ref document: HK |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: GR Ref document number: 1120887 Country of ref document: HK |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20200424 Address after: Building 8, No. 16, Zhuantang science and technology economic block, Xihu District, Hangzhou City, Zhejiang Province Patentee after: ALIYUN COMPUTING Co.,Ltd. Address before: English genus Patentee before: Alibaba Group Holding Ltd. |
|
| TR01 | Transfer of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20120620 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |