CN107992512A - A kind of method of Data Migration, system and computer-readable recording medium - Google Patents
A kind of method of Data Migration, system and computer-readable recording medium Download PDFInfo
- Publication number
- CN107992512A CN107992512A CN201710986010.0A CN201710986010A CN107992512A CN 107992512 A CN107992512 A CN 107992512A CN 201710986010 A CN201710986010 A CN 201710986010A CN 107992512 A CN107992512 A CN 107992512A
- Authority
- CN
- China
- Prior art keywords
- data
- script
- migration
- data migration
- generation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Abstract
This application involves a kind of data migration method, system and computer-readable recording medium.The data migration method includes:The definite data for needing to migrate;The data migrated as needed, generation migration script and comparison script;Perform migration script and carry out Data Migration;And perform and compare script progress comparing.This method can also include:Before the data that definite needs migrate, carry out standby host and build, to match with production environment;And recover Backup Data on standby host.This method can also include:Under comparing unanimous circumstances, according to the data after migration, script is deleted in generation.The application realizes that mass data is migrated in the case where ensuring to produce daily stable operation using the method that standby host recovery scheme and dynamic generation perform script are combined.
Description
Technical field
This application involves FIELD Data management and processing, relate more specifically to Data Transference Technology.
Background technology
With the continuous expansion of banking, the data storage of bank is being skyrocketed through, Data Migration work into
To ensure the important component of banking system safety and stability.And conventional data migration method cannot meet migration for the time
With the requirement of subsequent treatment.
Therefore, this area needs improved technology to ensure migrating data exactly.
The content of the invention
This application provides a kind of data migration method, including:The definite data for needing to migrate;The number migrated as needed
According to generation migration script and comparison script;Perform migration script and carry out Data Migration;And perform and compare script progress data ratio
It is right.
According on one side, the data migration method further includes:Before the data that definite needs migrate, standby host is carried out
Build, to match with production environment.
According on one side, the data migration method further includes:Before the data that definite needs migrate, on standby host
Recover Backup Data.
According on one side, the data migration method further includes:Under comparing unanimous circumstances, after migration
Data, generation delete script.
According on one side, the migration script and the comparison script are by program dynamic generation.
According on one side, the deletion script is by program dynamic generation.
According on one side, the Data Migration is cross-platform and integration across database version Data Migration.
According on one side, the data migration method further includes:Perform index and constraint reconstruct script.
It is described to migrate script, the comparison script, the deletion script, the index and constrain heavy according to one side
Structure script is write by the interrelated relation between system parameter table and tables of data.
Present invention also provides a kind of system for Data Migration, including:The dress of the data migrated for determining needs
Put;For the data migrated as needed, generation migration script and the device for comparing script;For performing migration script into line number
According to the device of migration;And for performing the device for comparing script and carrying out comparing.
Present invention also provides a kind of computer-readable recording medium, the computer-readable recording medium storage is used to hold
The computer executable instructions of the following operation of row:The definite data for needing to migrate;The data migrated as needed, generation migration foot
Sheet and comparison script;Perform migration script and carry out Data Migration;And perform and compare script progress comparing.
The application overcomes original backup logic and recovery scheme of importing and exporting with storing migration scheme each shortcoming,
Solve and mass data is moved into another platform exactly from a platform in the case where ensuring to produce daily stable operation
On, realize the cross-platform and Data Migration of integration across database version and can reliably and effectively complete Data Migration.
Brief description of the drawings
Include in this and form the attached drawing of this specification part and show the exemplary embodiment of the application, and with the above
The content of the invention and embodiment given below provided is used for explaining together the feature of the application.
Fig. 1 is the indicative flowchart according to the data migration method of one embodiment of the application;And
Fig. 2 is the exemplary computer system block diagram according to one embodiment of the application.
Embodiment
It will be described in detail with reference to the accompanying drawings various embodiments.In place of possible, same reference numerals will pass through attached drawing and be used to refer to
For same or like part.To particular example and realize that made reference is for explanatory purposes, and to be not intended to limit the application
Or the scope of claim.
Wording " exemplary " is used herein to mean that " be used as example, example or show ".Here depicted as " example
Property " any realization be not necessarily to be construed as preferred or advantageous over other realize.
As the big data epoch arrive, there are the demand that mass data is migrated between disparate databases for all conglomeraties.Bank
Business is related to old data conversion and moves to the mass data migration work of new storehouse data.In bank management system, branch is comprehensive
Data management platform (hereinafter referred to as ODSB) basis as branch's data management is closed, houses always to push away and point (always pushes away divided data example
Such as can be the information management class system by head office's unitized overall development, after each branch promotes and reaches the standard grade, by head office daily by specific
The data that are issued to each branch of lower several channels, head office is stored in the source of data) and branch's characteristic all data, storage
Data involve a wide range of knowledge and data volume is big.This brings greater risk to daily system operation and O&M, it is therefore desirable to flows part
Water number is according on the server (abbreviation historic data server) for moving to new special storage history pipelined data.Since ODSB is every
Need the plenty of time to run day to criticize, and to provide business department daily data query function, therefore the time window of Data Migration has
Limit, and it is all different to migrate past database server and database version.
ODSB uses oracle database at present, and usually used migrating data mode is introduced into exported logic backup
With recovering and storing (Storage) migration.But both modes are not all suitable for current ODSB big data quantities migration work
Make.The requirement for the time can not be met with recovering by importing and exporting backup logic.For the Data Migration of 10T or so, importing is led
Go out backup logic needs the substantial amounts of time with recovering, and downtime is from network transmission is exported to new storehouse, along with importing
Time.It is time-consuming too long for the migrating data magnitude of ODSB, the stable operation of daily production can be influenced.And store migration then
It cannot meet the work of the cross-platform and Data Migration of integration across database version.It is all same that storage migration pattern, which requires the old and new's database,
Platform, and be identical database version.And the database after migrating is in the division such as raw device and data file and original
It is consistent.In historical data transition process time window, limited and database server and database version are all changed
In the case of, can not be by the way of storage migrates.Conventional data migration method cannot meet migration for the time and
The requirement of subsequent treatment.Therefore need to realize Data Migration using improved technology.
The application overcomes original backup logic and recovery scheme of importing and exporting with storing migration scheme each shortcoming,
The method that is combined using standby host recovery scheme and dynamic generation perform script is provided to realize that mass data migrates, Neng Gou
Ensure to realize Data Migration in the case of producing daily stable operation.
The application can realize Data Migration in the case where ensuring to produce daily stable operation in the following way.
The application carries out the extraction of historical data using standby host recovery scheme.On the one hand standby host recovery scheme has isolated production
Storehouse, does not influence the operation of storage facility located at processing plant, standby host processing historical data, does not conflict, processing policy-flexible is various with production completely.It is another
Aspect demonstrates the effective period of availability, restorability and data recovery that history backs up from side again.At the same time can be across flat
Platform carries out Data Migration.
The application ensures the accuracy of Data Migration using dynamic generation perform script.The application can to mass data into
Row migration.In one example, ODSB historical datas migrate, and a partition tables up to ten thousand need to be migrated, and thousands of a tables carry out table
Subregion shifts and verification, and a partition tables up to ten thousand are purged and index restructuring, in order to ensure that the script of rows up to ten thousand is accurate, disappear
Except the mistake that human factor triggers, the mode of dynamic generation perform script is employed, develops Data Migration script Core Generator,
Data check script Core Generator, data dump script Core Generator, index and constraint reconstruct script Core Generator.
In order to complete these script Core Generators, relevant system parameters table and tables of data can be combed early period, including need
The table name of processing, zone name, index name, major key name etc., wherein system parameter table can be for example all_part_key_ respectively
columns、all_tab_columns、dba_segments、dba_table、dba_constraints、dba_indexes、
dba_tab_partitions、dba_part_tables、dba_part_indexes.Then, by these system parameter tables and
Interrelated between tables of data write out needed for script Core Generator.In script Core Generator compiling procedure, different feet
The system parameter table and tables of data that this Core Generator uses are different, and the content generated as needed determines the system used
Parameter list and tables of data, incidence relation is looked for further according to the field of different system parameter table and tables of data.Such as index and
Constraint writing for script Core Generator of reconstruct uses dba_constraints, dba_indexes, dba_part_indexes
Parameter list and partial data table.
For example, subregion is deleted in generation, rebuilds major key, is constrained, and the key step for indexing shell script is as follows:
1st, Odsbptabledtl tables of data houses the table inventory for preparing deletion, user, zone name.
2nd, removed by the owner in odsbptabledtl tables of data, tablename, patname fields generation subregion
Sentence.
3rd, determine whether migration table has index according to owner and table_name fields in dba_index parameter lists.
If the 4, do not indexed, need not handle.If indexing, in dba_constraints tables, according to
Owner and table_name fields carry out the constraint of inquiry table, by constraint set DISABLE.
5th, dba_index and dba_part_indexes parameter lists are associated according to owner with table_name fields, really
Whether the index for determining migration table exists in dba_part_indexes, if it is present need not handle;If it does not,
Then the index is deleted and rebuild after subregion is deleted.
6th, finally by the constraint set ENABLE of the 4th step.
All tables of data and parameter list are associated according to owner and table_name2 field.
Code can be as follows:
For example, Data Migration script Core Generator is responsible for generating Data Migration script, and major function is by each flowing water
Flowing water in table specified time section passes through in the migration script Autonomic Migration Framework of generation to historic data server.Data detection script
Core Generator is responsible for generating comparing script, and major function is each in automatic comparison production environment and historic data server
Whether the Flow Record number in the specified time section of corresponding flowing water table is consistent.Data dump script Core Generator is responsible for generating data
Script is removed, major function is the automatic stream removed in production environment upstream water meter specified time section after comparing is errorless
Water number evidence.Index and constraint reconstruct script Core Generator are responsible for generation index and constraint reconstruct script, the flowing water table of production environment
Original index and constraint can fail after part pipelined data is deleted, and it is automatic right to index and constrain reconstruct script major function
The reconstruct work that each flowing water table is indexed and constrains.Whole script commands, ensure that by these instrument dynamic generations
The accuracy and high efficiency that cross-platform mass data migration is implemented, reduce carry out large-scale data to production system to greatest extent
The risk of cleaning.
The application can meet that the time window of ODSB migrations will using standby host recovery scheme and dynamic generation perform script
Ask, can also meet to work to cross-platform and integration across database version Data Migration.
With reference to figure 1, schematic flow Figure 100 of the data migration method of one embodiment according to the application is shown.
It is appreciated that the flow chart 100 of the Data Migration is only as an example, not a limit.
Flow chart 100 starts at S101.
Optionally, at S103, flow chart 100 can include the preparation operation for carrying out Data Migration.For example, can be into
Row standby host is built, to match with production environment, for example, be consistent with production environment, including storage, operating system etc..
Production environment for example can be the database environment that storage always pushes away divided data and branch's characteristic data, i.e. ODSB databases, own
The inquiry of information can obtain corresponding data by the environment.
Optionally, at S105, flow chart 100 can include having checked whether newest DB BackupIf
Newest DB Backup, then at S107, recover Backup Data on standby host.If without newest DB Backup,
At S109, DB Backup is carried out.Then advance at S107, recover backup on standby host.
At S111, flow chart 100 can include checking whether standby host database can normally startIf standby host data
Storehouse can normally start, then at S113, carry out spreadsheet analysis, determine to need the data (for example, flowing water table inventory) migrated.
If standby host database cannot normally start, S107 is returned.
At S115, flow chart 100 can include the data (for example, flowing water table inventory) migrated as needed, and generation is moved
Move script and compare script.Alternatively, migrate script and comparison script can be by programming automatic generation, can also be by artificial
Or other modes create.Compared to the script of manual creation, the script of programming automatic generation is in terms of security and accuracy
There are more guarantees.
At S117, flow chart 100 can include performing migration script, carry out Data Migration.
At S119, flow chart 100 can include comparing script, carry out comparing.
At S121, flow chart 100 can include comparing the data after migrating and whether creation data is consistentCompare object
Can be the historic data server and creation data after migration.Creation data can be stored in production environment i.e. ODSB data
Data in storehouse, such as the transaction record that individual client is all.If compared unanimously with creation data, in S125, according to moving
Script is deleted in data (for example, flowing water table inventory) after shifting, generation.Alternatively, delete script can by programming automatic generation,
It can also be created by artificial or other modes.Compared to the script of manual creation, the script of programming automatic generation is in safety
Property and accuracy in terms of have more guarantees.If compared with creation data it is inconsistent, at S123, search variance data, with
After return to S117.
At S127, flow chart 100 can include performing deleting procedure script.
At S128, flow chart 100 can include performing index and constraint reconstruct script.
At S129, flow chart 100 terminates.
It is appreciated that it is only optional preparation process that above-mentioned standby host, which is built and recovers Backup Data on standby host,
It is not meant in data migration operation to be required for carrying out above-mentioned preparation process every time.Preparation process can be to avoid in production ring
Border is operated, and does not influence the operation of storage facility located at processing plant completely, standby host processing historical data, does not conflict with production environment, processing strategy
It is versatile and flexible.In addition, preparation process demonstrates the effective period of availability, restorability and data recovery that history backs up.Should
Work as understanding, only as an example, not a limit, those skilled in the art are further contemplated that other more similar approach to above-described embodiment
To realize cross-platform Data Migration.Such implementation should not be interpreted to cause departing from scope of the present application.
With reference to figure 2, a kind of exemplary computer system 200 is shown.Computer system 200 can include logical process
Device 202, such as perform core.Although illustrate a logic processor 202, in other embodiments, computer system 200
There can be multiple logic processors, for example, the multiple execution cores of each processor substrate, and/or multiple processor substrates, wherein
Each processor substrate can have multiple execution cores.As shown in the figure, various computer-readable recording mediums 210 can pass through one
Various system components are coupled to logic processor 202 by bar or multiple pieces of system bus interconnection, the system bus.System bus can
If be dry type bus structures in any types, including memory bus or Memory Controller, peripheral bus and
Use the local bus of any of various bus architectures.In the exemplary embodiment, it is computer-readable
Storage medium 210 can include such as random access memory (RAM) 204, storage device 206 (for example, electromechanical hard drives,
Solid-state hard drives etc.), firmware 208 (for example, quick flashing RAM or ROM) and removable memory device 218 be (such as CD-
ROM, floppy disk, DVD, flash drive, External memory equipment etc.).It will be appreciated by the person skilled in the art that it can use
Other types of computer-readable recording medium, such as cassette, flash card and/or digital video disc.Computer-readable storage
Medium 210 can provide the instruction 222 that computer can perform, data structure, program module and for computer system 200
Other data non-volatile and volatile storage.Basic input/output (BIOS) 220 --- it includes such as opening
The basic routine of the transinformation between the unit of computer system 200 is helped during dynamic --- firmware can be stored in
In 208.Substantial amounts of program can be stored in firmware 208, storage device 206, RAM 204 and/or removable memory device 218
On, and can be performed by logic processor 202, logic processor 202 includes operating system and/or application program.Order and letter
Breath can be received by input equipment 216 by computer system 200, input equipment 216 can include but is not limited to keyboard and
Sensing equipment.Other input equipments can include microphone, control stick, game paddle, scanner etc..These and other input
Equipment is connected to logic processor 202 often through the serial port interface for being coupled to system bus, but can also
Connected by other interfaces, such as parallel port, game port or Universal Serial Bus (USB).Display or other types
Display device system bus, such as video adapter can also be connected to via interface, it can be graphics processing unit 212
A part or be connected to graphics processing unit 212.Except display, computer typically comprises other periphery outputs and sets
It is standby, such as loudspeaker and printer (not shown).The exemplary system of Fig. 2 can also include host adapter, minicom
System interface (SCSI) bus and the External memory equipment for being connected to SCSI bus.Computer system 200 can use
Operated in the networked environment of the logical connection of one or more remote computers (such as, some remote computer).Remote computation
Machine can be other computer, server, router, network PC, peer device or other common network nodes, Yi Jidian
It can include multiple or all units in the unit above with respect to the description of computer system 200 type.When in LAN or WAN
In use, computer system 200 can be connected to LAN or WAN by network interface card 214 in networked environment.Network interface card (NIC)
214 (it can be internal or exterior) may be connected to system bus.In networked environment, relative to computer system
200 program modules described or their some parts can be stored in remote memory storage device.It will be appreciated that
Network connection described herein is exemplary, and can use the other means for establishing communication link between the computers.
In one or more exemplary embodiments, described function and process can hardware, software, firmware,
Or any combination thereof in realize.If realized in software, each function can be used as the instruction of one or more bars or code to deposit
Storage is transmitted on a computer-readable medium or by it.Computer-readable medium includes computer storage media and communication media
Both, it includes any medium for facilitating computer program to shift from one place to another.Storage medium can be calculated
Any usable medium that machine accesses.It is non-limiting as example, such computer-readable medium may include RAM, ROM,
EEPROM, CD-ROM or other optical disc storage, disk storage or other magnetic storage apparatus can be used to carrying or store instruction
Or desirable program code and any other medium that can be accessed by a computer of data structure form.For firmware and/or software
Realize, these methods can be realized with the module (for example, program, function etc.) for performing functions described herein.It is tangible
Any machine readable media that ground embodies instruction can be used for realizing method system described herein.For example, software code can
It is stored in the memory of the memory of such as movement station etc, and by such as desktop computer, laptop computer, service
The processors such as device computer, the microprocessor for moving equipment perform.Memory can be realized inside processor or outside processor
Portion.As it is used herein, term " memory " refer to any kind of long-term, short-term, volatibility, it is non-volatile or other
Memory, and it is not limited to the Jie of any certain types of memory or certain number of memory or memory storage on it
The type of matter.
Foregoing description and diagram are only provided as illustrated examples.Any of claim element of singulative is drawn
State, such as should not be construed as the element being defined to odd number using the citation of article " one ", " certain " or "the".Technical staff for
Every kind of application-specific can realize described structure with different modes, but such implementation should not be interpreted to cause
Departing from scope of the present application.
It is to make any person skilled in the art all can make or use to provide being previously described for the disclosed embodiments
The application.The various modifications of these embodiments will be apparent for a person skilled in the art, and it is defined herein
General Principle can be applied to other embodiments without departing from spirit herein or scope.Thus, the application is not intended to
Embodiments shown herein is defined in, but should be awarded and appended claims and principle disclosed herein and novelty
The consistent broadest scope of feature.
Claims (11)
1. a kind of data migration method, including:
The definite data for needing to migrate;
The data migrated as needed, generation migration script and comparison script;
Perform migration script and carry out Data Migration;And
Perform and compare script progress comparing.
2. data migration method according to claim 1, it is characterised in that the data migration method further includes:True
Before needing the data that migrate calmly, carry out standby host and build, to match with production environment.
3. data migration method according to claim 1, it is characterised in that the data migration method further includes:True
Before needing the data that migrate calmly, recover Backup Data on standby host.
4. data migration method according to claim 1, it is characterised in that the data migration method further includes:In number
According to comparing under unanimous circumstances, according to the data after migration, script is deleted in generation.
5. data migration method according to claim 1, it is characterised in that the migration script and the comparison script are
Pass through program dynamic generation.
6. data migration method according to claim 4, it is characterised in that the deletion script is raw by program dynamic
Into.
7. data migration method according to claim 1, it is characterised in that the Data Migration is cross-platform and across data
The Data Migration of storehouse version.
8. data migration method according to claim 6, it is characterised in that the data migration method further includes:Perform
Index and constraint reconstruct script.
9. data migration method according to claim 8, it is characterised in that the migration script, the comparison script, institute
Stating and deleting script, the index and constraint reconstruct script is compiled by the interrelated relation between system parameter table and tables of data
Write.
10. a kind of system for Data Migration, including:
The device of the data migrated for determining needs;
For the data migrated as needed, generation migration script and the device for comparing script;
The device of Data Migration is carried out for performing migration script;And
For performing the device for comparing script and carrying out comparing.
11. a kind of computer-readable recording medium, the computer-readable recording medium storage is based on performing and operating below
Calculation machine executable instruction:
The definite data for needing to migrate;
The data migrated as needed, generation migration script and comparison script;
Perform migration script and carry out Data Migration;And
Perform and compare script progress comparing.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710986010.0A CN107992512A (en) | 2017-10-20 | 2017-10-20 | A kind of method of Data Migration, system and computer-readable recording medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710986010.0A CN107992512A (en) | 2017-10-20 | 2017-10-20 | A kind of method of Data Migration, system and computer-readable recording medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107992512A true CN107992512A (en) | 2018-05-04 |
Family
ID=62029989
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710986010.0A Pending CN107992512A (en) | 2017-10-20 | 2017-10-20 | A kind of method of Data Migration, system and computer-readable recording medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107992512A (en) |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109614386A (en) * | 2018-09-28 | 2019-04-12 | 阿里巴巴集团控股有限公司 | Data processing method, device, server and computer readable storage medium |
CN110209652A (en) * | 2019-05-20 | 2019-09-06 | 平安科技(深圳)有限公司 | Tables of data moving method, device, computer equipment and storage medium |
CN110597669A (en) * | 2019-09-20 | 2019-12-20 | 中国银行股份有限公司 | Bank historical data parameterized backup recovery method and device |
CN111367890A (en) * | 2020-03-13 | 2020-07-03 | 深圳壹账通智能科技有限公司 | Data migration method and device, computer equipment and readable storage medium |
CN111666266A (en) * | 2020-06-09 | 2020-09-15 | 金蝶软件(中国)有限公司 | Data migration method and related equipment |
CN111680023A (en) * | 2020-06-08 | 2020-09-18 | 中国银行股份有限公司 | Migration data checking method and device |
CN111752928A (en) * | 2020-06-30 | 2020-10-09 | 武汉虹信技术服务有限责任公司 | Database object migration method and system |
CN111858470A (en) * | 2020-07-24 | 2020-10-30 | 成都成信高科信息技术有限公司 | Time window migration strategy |
WO2020238858A1 (en) * | 2019-05-30 | 2020-12-03 | 深圳前海微众银行股份有限公司 | Data migration method and apparatus, and computer-readable storage medium |
US11650833B1 (en) | 2020-01-15 | 2023-05-16 | State Farm Mutual Automobile Insurance Company | Systems and methods for automatically generating guided user interfaces (GUIs) for tracking and migrating legacy networked resources within an enterprise during a technical migration |
CN116821100A (en) * | 2023-07-20 | 2023-09-29 | 广州云臻数据科技有限公司 | Database high-fidelity migration method based on binary collaboration |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6546404B1 (en) * | 2000-01-29 | 2003-04-08 | International Business Machines Corporation | Data migration tool |
CN101266606A (en) * | 2007-03-15 | 2008-09-17 | 阿里巴巴公司 | On-line data migration method based on Oracle database |
CN103530290A (en) * | 2012-07-03 | 2014-01-22 | 深圳市腾讯计算机系统有限公司 | Method and system for data migration among databases |
CN105393250A (en) * | 2013-07-09 | 2016-03-09 | 甲骨文国际公司 | Dynamic migration script management |
CN105868343A (en) * | 2016-03-28 | 2016-08-17 | 上海携程商务有限公司 | Database migration method and system |
CN105956191A (en) * | 2016-06-13 | 2016-09-21 | 浪潮(北京)电子信息产业有限公司 | Data migration method and system |
CN107046810A (en) * | 2015-12-03 | 2017-08-15 | 华为技术有限公司 | A kind of virtual machine backup information moving method, device and system |
-
2017
- 2017-10-20 CN CN201710986010.0A patent/CN107992512A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6546404B1 (en) * | 2000-01-29 | 2003-04-08 | International Business Machines Corporation | Data migration tool |
CN101266606A (en) * | 2007-03-15 | 2008-09-17 | 阿里巴巴公司 | On-line data migration method based on Oracle database |
CN103530290A (en) * | 2012-07-03 | 2014-01-22 | 深圳市腾讯计算机系统有限公司 | Method and system for data migration among databases |
CN105393250A (en) * | 2013-07-09 | 2016-03-09 | 甲骨文国际公司 | Dynamic migration script management |
CN107046810A (en) * | 2015-12-03 | 2017-08-15 | 华为技术有限公司 | A kind of virtual machine backup information moving method, device and system |
CN105868343A (en) * | 2016-03-28 | 2016-08-17 | 上海携程商务有限公司 | Database migration method and system |
CN105956191A (en) * | 2016-06-13 | 2016-09-21 | 浪潮(北京)电子信息产业有限公司 | Data migration method and system |
Cited By (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109614386A (en) * | 2018-09-28 | 2019-04-12 | 阿里巴巴集团控股有限公司 | Data processing method, device, server and computer readable storage medium |
CN109614386B (en) * | 2018-09-28 | 2023-09-22 | 创新先进技术有限公司 | Data processing method, device, server and computer readable storage medium |
CN110209652A (en) * | 2019-05-20 | 2019-09-06 | 平安科技(深圳)有限公司 | Tables of data moving method, device, computer equipment and storage medium |
CN110209652B (en) * | 2019-05-20 | 2024-02-02 | 平安科技(深圳)有限公司 | Data table migration method, device, computer equipment and storage medium |
WO2020238858A1 (en) * | 2019-05-30 | 2020-12-03 | 深圳前海微众银行股份有限公司 | Data migration method and apparatus, and computer-readable storage medium |
CN110597669A (en) * | 2019-09-20 | 2019-12-20 | 中国银行股份有限公司 | Bank historical data parameterized backup recovery method and device |
CN110597669B (en) * | 2019-09-20 | 2022-10-11 | 中国银行股份有限公司 | Bank historical data parameterized backup recovery method and device |
US11650833B1 (en) | 2020-01-15 | 2023-05-16 | State Farm Mutual Automobile Insurance Company | Systems and methods for automatically generating guided user interfaces (GUIs) for tracking and migrating legacy networked resources within an enterprise during a technical migration |
CN111367890A (en) * | 2020-03-13 | 2020-07-03 | 深圳壹账通智能科技有限公司 | Data migration method and device, computer equipment and readable storage medium |
CN111680023A (en) * | 2020-06-08 | 2020-09-18 | 中国银行股份有限公司 | Migration data checking method and device |
CN111666266A (en) * | 2020-06-09 | 2020-09-15 | 金蝶软件(中国)有限公司 | Data migration method and related equipment |
CN111752928A (en) * | 2020-06-30 | 2020-10-09 | 武汉虹信技术服务有限责任公司 | Database object migration method and system |
CN111858470A (en) * | 2020-07-24 | 2020-10-30 | 成都成信高科信息技术有限公司 | Time window migration strategy |
CN116821100A (en) * | 2023-07-20 | 2023-09-29 | 广州云臻数据科技有限公司 | Database high-fidelity migration method based on binary collaboration |
CN116821100B (en) * | 2023-07-20 | 2023-12-22 | 广州云臻数据科技有限公司 | Database high-fidelity migration method based on binary collaboration |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107992512A (en) | A kind of method of Data Migration, system and computer-readable recording medium | |
US10423403B1 (en) | Utilizing a machine learning model to predict metrics for an application development process | |
Smith et al. | The machine learning bazaar: Harnessing the ml ecosystem for effective system development | |
Szárnyas et al. | IncQuery-D: A distributed incremental model query framework in the cloud | |
Dijkman et al. | Aligning business process models | |
Xue et al. | Interactive ontology matching based on partial reference alignment | |
Hildebrandt et al. | Large-scale data pollution with Apache Spark | |
CN110442847B (en) | Code similarity detection method and device based on code warehouse process management | |
EP3872626A1 (en) | Utilizing artificial intelligence and machine learning models to reverse engineer an application from application artifacts | |
Gharibi et al. | Automated management of deep learning experiments | |
WO2020072228A1 (en) | Multi-step query execution in sql server | |
JP5412995B2 (en) | Database control apparatus, database control method, and database control program in program model checking | |
CN106445529A (en) | Backup method and system for configuration information of continuous integration server | |
EP3822807A1 (en) | Techniques for application undo and redo using sql patchsets or changesets | |
Kuo et al. | Design and construction of a big data analytics framework for health applications | |
Shahid et al. | Impact of avoiding non-functional requirements in software development stage | |
Jin et al. | CLX: Towards verifiable PBE data transformation | |
Haigh | How Charles Bachman invented the DBMS, a foundation of our digital world | |
Cassidy et al. | Version Control for RDF Triple Stores. | |
JP6408205B2 (en) | A model for managing product configuration changes | |
Kumar et al. | User Story Clustering using K-Means Algorithm in Agile Requirement Engineering | |
Li et al. | Research and application of computer aided design system for product innovation | |
CN104391945B (en) | The treating method and apparatus of database file data directory | |
Babur et al. | Towards Distributed Model Analytics with Apache Spark. | |
CN107741963A (en) | Across company-data merging method and device, electronic equipment, computer-readable storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WD01 | Invention patent application deemed withdrawn after publication | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20180504 |