CN106815317A - A kind of data copy method and system based on disparate databases - Google Patents
A kind of data copy method and system based on disparate databases Download PDFInfo
- Publication number
- CN106815317A CN106815317A CN201611208680.1A CN201611208680A CN106815317A CN 106815317 A CN106815317 A CN 106815317A CN 201611208680 A CN201611208680 A CN 201611208680A CN 106815317 A CN106815317 A CN 106815317A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- target
- source
- configuration file
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses a kind of data copy method based on disparate databases and system, and the method includes：Receive the configuration-direct of user, generation is on by the configuration file of the data duplication in source database to target database, wherein, the source database and the target database are single database or are distributed data base, the configuration file at least includes the database information of the source database and the target database, and screening conditions；The configuration file is parsed, according to the analysis result to the screening conditions, is instructed using target developing language generation data base querying；The target data is read from the source database using data base querying instruction, and the target data is copied into the target database, the target data is that what is filtered out from the source database meet the original data set of the screening conditions, is used to solve to carry out between existing disparate databases to there are problems that during data duplication ineffective.
Description
Technical field
The present invention relates to data processing field, more particularly to a kind of data copy method based on disparate databases and it is
System.
Background technology
It is a complexity, the operation system including heterogeneous database to pay the financial sectors such as clearance, is often had from a number
The data of some tables to the demand of another or multiple database are shifted according to storehouse batch, for such data transfer requirements, one
As be all that one application module of exploitation is realized, development environment and development language based on system, such as system based on java are used
Jdbc API Access databases；The system of C/C++, the primary API Access database provided using each database engine are such as provided.
Often there are new data transfer requirements, it is necessary to increase such application module., be present the duplication of labour in this pattern, open
Hair inefficiency, the uneven problem of code quality.
The content of the invention
The embodiment of the present invention provides a kind of data copy method and system based on different pieces of information, is used to solve different pieces of information
Carry out there are problems that during data duplication between storehouse ineffective.
The inventive method includes a kind of data copy method based on disparate databases, and the method includes：
The configuration-direct of user is received, generation is on literary by the configuration of the data duplication in source database to target database
Part, wherein, the source database and the target database are single database or are distributed data base, the configuration file
At least include the database information of the source database and the target database, and screening conditions；
The configuration file is parsed, according to the analysis result to the screening conditions, using target developing language generation number
Instructed according to library inquiry；
The target data is read from the source database using data base querying instruction, and by the number of targets
According to copying to the target database, the target data be filtered out from the source database meet the screening conditions
Original data set.
Based on same inventive concept, the embodiment of the present invention further provides a kind of data based on disparate databases and answers
System processed, the system includes：
Transmit-Receive Unit, the configuration-direct for receiving user；
Generation unit, for generating on by the configuration file of the data duplication in source database to target database, its
In, the source database and the target database are single database or are distributed data base, and the configuration file is at least
Database information including the source database and the target database, and screening conditions；
Resolution unit, for parsing the configuration file；
The generation unit, is additionally operable to according to the analysis result to the screening conditions, using target developing language generation
Data base querying is instructed；
Copied cells, for reading the target data from the source database using data base querying instruction,
And the target data is copied into the target database, the target data is the symbol filtered out from the source database
Close the original data set of the screening conditions.
The embodiment of the present invention can configure the number of itself by providing a kind of data copy system, user in this system
According to copy demand, then system will automatically generate configuration file, so triggering following data duplication process, specifically, number
Configuration file is parsed according to dubbing system, source database and target database can be found according to analysis result, then using unification
The instruction of target developing language generation data base querying, obtained from member's database during target data copies to target database,
It can be seen that, this method is because the unified database developing language for providing, it is possible to suitable for the database of various engines, and
And data copy system go for source database and target database be single storehouse or distributed data base various scenes,
Such as one-to-one, one-to-many, many-to-one scene, therefore, personalized customization demand is met well, with high availability.
Brief description of the drawings
Technical scheme in order to illustrate more clearly the embodiments of the present invention, below will be to that will make needed for embodiment description
Accompanying drawing is briefly introduced, it should be apparent that, drawings in the following description are only some embodiments of the present invention, for this
For the those of ordinary skill in field, on the premise of not paying creative work, other can also be obtained according to these accompanying drawings
Accompanying drawing.
Fig. 1 a~Fig. 1 d are data duplication schematic diagram of a scenario provided in an embodiment of the present invention；
Fig. 2 is a kind of data copy method schematic flow sheet based on disparate databases provided in an embodiment of the present invention；
Fig. 3 is the schematic flow sheet of the data copy method of database provided in an embodiment of the present invention；
Fig. 4 is that the multithreading clone method of database provided in an embodiment of the present invention realizes schematic diagram；
Fig. 5 is a kind of data copy system configuration diagram based on disparate databases provided in an embodiment of the present invention.
Specific embodiment
In order that the object, technical solutions and advantages of the present invention are clearer, below in conjunction with accompanying drawing the present invention is made into
One step ground is described in detail, it is clear that described embodiment is only some embodiments of the invention, rather than whole implementation
Example.Based on the embodiment in the present invention, what those of ordinary skill in the art were obtained under the premise of creative work is not made
All other embodiment, belongs to the scope of protection of the invention.
It should be noted that the source database and target database in the embodiment of the present invention can be single storehouse, or
Target database, so data copy method provided in an embodiment of the present invention goes for following several scenes, i.e., one-to-one,
The scene such as many-one, one-to-many, multi-to-multi, respectively as shown in Fig. 1 a~Fig. 1 d, wherein, Fig. 1 a represent source Ku Weidan storehouses, target
The situation in storehouse Shi Dan storehouses；Fig. 1 b represent source Ku Weidan storehouses, the feelings of the distributed data base that object library is made up of three databases
Shape, wherein three databases can be different types of database；Fig. 1 c represent that source storehouse is configured with three situations of database, its
In, three types of database can be different；Fig. 1 d represent that source storehouse is configured with three databases, and object library also provided three
The situation of individual database, the configuration of distributed data base is mainly and is obtained by user configuring in configuration file XML file.
Based on application scenarios as above, the embodiment of the present invention provides a kind of data copy method stream based on disparate databases
Journey schematic diagram, shown in Figure 2, specifically implementation method includes：
Step S101, receives the configuration-direct of user, and generation is on by the data duplication in source database to target data
The configuration file in storehouse, wherein, the source database and the target database are single database or are distributed data base, institute
Stating configuration file at least includes the database information of the source database and the target database, and screening conditions.
Step S102, parses the configuration file, according to the analysis result to the screening conditions, using target developing language
Speech generation data base querying instruction.
Step S103, the target data is read using data base querying instruction from the source database, and will
The target data copies to the target database, the target data be filtered out from the source database meet institute
State the original data set of screening conditions.
It should be noted that in order to adapt to the transfer of the data between disparate databases, and autgmentability considers, it is necessary to design
Consistent api interface accesses different databases, and the database engine difference of bottom is hidden.The embodiment of the present invention is based on C++
Exploitation, C++ provides the programming mechanism of good object-oriented, and by good design, user is with consistent calling interface
Database is accessed, the main interface and class of abstract unified database access interface are described below：
The general application by carrying out data duplication of the above method is performed, and in above-mentioned steps, configuration file is generally referred to as
XML configuration file, mainly user are above configured according to the demand of itself in the application, and the then application receives user in figure
Mode of operation on shape interactive interface instrument by dragging, drawing, dragging, choosing generates configuration-direct；Generated according to the configuration-direct
On by the XML configuration file of the data duplication in source database to target database.Wherein, XML configuration file is the present invention
Core configuration file in embodiment, it defines all rules and demand of data duplication task.The XML configuration file includes
Following several parts：1st, the relevant information of source database and target database, 2, the copy rule of target data, 3, sieve
The screening conditions of target data are selected, it is specific as follows：
Wherein, the information of Part I source database, including following content：(1) transfer mode (mode)：Source data
Storehouse is common single storehouse (normal) or distributed data base (blw)；(2) type of database (engine_type)：Such as
MYSQL DB2 etc.；(3) Database Identification (id)：Source database name (4) database address (ip)：Where source database
Ip addresses；(5) database port (port)：Port numbers where source database.The XML configuration file master of user configuring generation
If being represented in following form：
In addition, specifically including following content in remainder such as data copy rule and screening conditions：(1) transfer mode
(mode)：Target client database is common single storehouse (normal) or distributed data base (blw).(2) transition rule mark
(id)：For identifying transition rule.(3) type of database (engine_type)：Such as MYSQL DB2.(4) intercalation model
(insert_ode>：During insertion target database, such as major key conflict, how to process, ERROR representation programs report an error and exit,
IGNORE is represented and is ignored this record, and REPLACE represents the former record of replacement.(4) stroke count (commit_count) is submitted to：Number of targets
Submitted to when inserting how many according to storehouse.(6) source literary name section (src_fields)：Represent which field reads from source table.(7) object table
Field (dst_fields):Expression is inserted into which field of object table.(8) routing mode (type):What represent according to side
Formula determines route, and 0 mark is route according to the true and false of conditional expression evaluation, and 1 represents according to script function calculating route mesh
Mark the information such as address, port, the user name of database.
An example given below illustrates the representation of the above-mentioned configuration information of correspondence in configuration file：
After user completes the configuration above-mentioned configuration file of generation, using the process for beginning to perform data duplication, data
Reproduction process is the important component in the embodiment of the present invention, specifically, for an original number in the target data
According to object, the data routing iinformation on the original data object in the analysis result of the configuration file is determined, it is described
The information of the target database that data routing iinformation is inserted into comprising the original data object and the position of the target database
Put mark；
According to the data routing iinformation, the target database is filtered, determining needs insertion described original
The first object database collection of data object；
The station location marker of the target database in the data routing iinformation, the original data object is inserted
Enter in the first object database collection the corresponding position of station location marker described in each target database.
Because support that target database is configurable to one or more databases in the embodiment of the present invention, and user matches somebody with somebody
Put and insert that under what conditions which target database just constitutes data route.Wherein, data route is supported with the shape of expression formula
The form of formula or lua scripts is represented.
Type one, sets route in the form of expression formula
Setting route by expression formula needs to be configured in XML file, and the following is an example, the example shows when record
When the value of id fields is less than 10, the record is inserted into the target database identified with dest1, and object table is tbl_test_
new1；When the value of the id fields of record is more than 10, the record is inserted into the target database identified with dest2, object table
It is tbl_test_new2；It is specific as follows：
Type two, Lua script settings route
By specifying lua scripts in XML file, then in lua script edits route test rule, show the following is one
Example, it is the same that the example plays a part of with the effect of a upper example, is all that the value that will work as the id fields for recording is less than
When 10, the record is inserted into the target database identified with dest1, and object table is tbl_test_new1；When the id fields of record
Value be more than 10 when, the record be inserted into dest2 identify target database, object table is tbl_test_new2, specifically
It is as follows：
Further, expression formula or lua script setting filter conditions can also be utilized, is route according to the data and believed
Breath, filters to the target database, and determining needs the first object data base set for inserting the original data object
Close, such as, filtered in the form of expression formula, following present an example, represented in example only as the id of source database record
When field is less than 6, the record can just be inserted into target database, otherwise be not inserted into.
In addition, following example is illustrated being filtered by lua script settings, the effect that its effect is filtered with above-mentioned expression formula
It is similar.
Preferably, after user completes the configuration above-mentioned configuration file of generation, using the mistake for beginning to perform data duplication
Journey, before data duplication is performed, first parses to configuration file, according to the analysis result of the configuration file, determines institute
Whether the table structure for stating source database and the target database is identical；
When the target database is differed with the table structure of the source database, to the target in the source database
Data are changed, and the target data after conversion is inserted into the target database.
Generally, the definition of the source literary name section and target literary name section during data duplication is same or analogous, but can also be existed
The field of object table can not be directly from the certain field direct access of source table, it is necessary to do certain deformation.Such as from source table certain
Individual field interception, or formed by certain several field combination of source table.
Following XML fragment defines control and the deformation relationship of source table data field and object table data field.It is interior below
Appearance is configured with field insertion rule, and the id fields of source table are inserted into the id fields of object table, and the name fields of source table are inserted into mesh
Mark the name fields of table, the up_date fields of source table are inserted into the up_date fields of object table, preceding 15 words of source table resv
The content of section is inserted into the mchnt_cd fields of object table, specific as follows：
Further, also include：First record strip of the acquired original data object from the source database of statistics
Number, and the second record strip number of the data object write to the target data place is counted, and in the second record strip number
Reported an error when unequal with the first record strip number.
That is, can all be proofreaded to the result for replicating after data duplication is completed every time, it is to avoid during data duplication
The problem lost, when detection finds the record strip number of data duplication, then illustrates, prompting secondary data duplication occurs
Mistake, after user receives the notice that reports an error, can re-start data duplication.
For the above-mentioned data duplication process that more describes in a systematic way, the embodiment of the present invention is further with flow shown in Fig. 3
Figure is described in detail, and comprises the following steps that：
Step 201, after user completes configuration, obtains the XML configuration file of generation, and it is parsed.
Step 202, according to the analysis result of XML configuration file, finds target database to be copied, and get source
The information of database and the information of target database, and screening conditions and source database table information, and target database
Table information.
Step 203, the screening conditions in XML configuration file generate data and look into unified database access interface
Ask instruction, such as SELECT statement.
Step 204, performs data query instruction and obtains each target data from source database successively；
Step 205, travels through all of target database, performs the number of targets to be copied that filter function finds condition satisfaction
According to storehouse.
Step 206, judges whether the data needs deformation process, if desired, then performs step 207, otherwise performs step
Rapid 208；
Step 207, deformation process is carried out to the data according to mapping function or deformation function, obtains the number after deformation
According to.
Step 208, is inserted into target database to be copied, then by the target data after deformation or the target data
It is back to the reproduction process that step 204 performs next target data.
In view of when the pressure of multi-to-multi contextual data dubbing system it is larger, therefore can with each source database correspondence one
Thread, performs multi-threading parallel process ground process, the efficiency of data duplication can be so improved, as shown in figure 4, source database 1
A thread into each corresponding data dubbing systems of source database N, for example, thread 1 is performed answering the data in source database 1
The process of target database 1 to target database N is made, the like, after each thread is performed both by completing, just complete source
Target data in database copies to the process of target database, it is seen then that data copy system provided in an embodiment of the present invention
Extending transversely multimachine deployment can be carried out, there is performance higher, the embodiment of the present invention realizes multimachine deployment, operation, in every machine
Can be performed in multi-process mode again on device, with performance higher.
Based on identical technology design, the embodiment of the present invention also provides a kind of data duplication system based on disparate databases
System, the executable above method embodiment of the system, the system can individually it is integrated on one server, multiple can be integrated in
On server.Data copy system provided in an embodiment of the present invention as shown in figure 5, including：Transmit-Receive Unit 401, generation unit
402nd, resolution unit 403, copied cells 404, wherein：
Transmit-Receive Unit 401, the configuration-direct for receiving user；
Generation unit 402, for generating on by the configuration file of the data duplication in source database to target database,
Wherein, the source database and the target database are single database or are distributed data base, and the configuration file is extremely
Include the database information of the source database and the target database, and screening conditions less；
Resolution unit 403, for parsing the configuration file；
The generation unit 402, is additionally operable to, according to the analysis result to the screening conditions, be given birth to using target developing language
Into data base querying instruction；
Copied cells 404, for reading the number of targets from the source database using data base querying instruction
According to, and the target data is copied into the target database, the target data is to be filtered out from the source database
The original data set for meeting the screening conditions.
Further, the copied cells 404 specifically for：
For an original data object in the target data, the pass in the analysis result of the configuration file is determined
In the data routing iinformation of the original data object, the data routing iinformation is inserted into comprising the original data object
The station location marker of the information of target database and the target database；
According to the data routing iinformation, the target database is filtered, determining needs insertion described original
The first object database collection of data object；
The station location marker of the target database in the data routing iinformation, the original data object is inserted
Enter in the first object database collection the corresponding position of station location marker described in each target database.
Further, the Transmit-Receive Unit 401, specifically for receive user on graphical interaction interface tool by dragging,
The mode of operation generation configuration-direct draw, drag, chosen；
The generation unit 402, specifically for being generated on the data in source database are answered according to the configuration-direct
Make the configuration file of target database.
Further, the copied cells 404 is additionally operable to：According to the analysis result of the configuration file, the source is determined
Whether the table structure of database and the target database is identical；When the target database and the table structure of the source database
When differing, the target data in the source database is changed, the target data after conversion is inserted into the target
Database.
Further, the system also includes：Check and correction unit 405, for counting acquired original from the source database
First record strip number of beginning data object, and count the second record strip of the data object write to the target data place
Number, and reported an error when the second record strip number is unequal with the first record strip number.
In sum, the embodiment of the present invention can be matched somebody with somebody by providing a kind of data copy system, user in this system
Put the data copy demand of itself, then system will automatically generate configuration file, so triggering following data duplication process,
Specifically, data copy system parsing configuration file, can find source database and target database, then according to analysis result
Instructed using unified target developing language generation data base querying, target data is obtained from member's database and copies to number of targets
According in storehouse, it is seen then that this method is because the unified database developing language for providing, it is possible to suitable for the number of various engines
According to storehouse, and data copy system goes for source database and target database is each of single storehouse or distributed data base
Scene, such as one-to-one, one-to-many, many-to-one scene are planted, therefore, personalized customization demand is met well, can with height
The property used.
The present invention is the flow with reference to method according to embodiments of the present invention, equipment (system) and computer program product
Figure and/or block diagram are described.It should be understood that every first-class during flow chart and/or block diagram can be realized by computer program instructions
The combination of flow and/or square frame in journey and/or square frame and flow chart and/or block diagram.These computer programs can be provided
The processor of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that produced for reality by the instruction of computer or the computing device of other programmable data processing devices
The device of the function of being specified in present one flow of flow chart or multiple one square frame of flow and/or block diagram or multiple square frames.
These computer program instructions may be alternatively stored in can guide computer or other programmable data processing devices with spy
In determining the computer-readable memory that mode works so that instruction of the storage in the computer-readable memory is produced and include finger
Make the manufacture of device, the command device realize in one flow of flow chart or multiple one square frame of flow and/or block diagram or
The function of being specified in multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that in meter
Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented treatment, so as in computer or
The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in individual square frame or multiple square frames.
, but those skilled in the art once know basic creation although preferred embodiments of the present invention have been described
Property concept, then can make other change and modification to these embodiments.So, appended claims are intended to be construed to include excellent
Select embodiment and fall into having altered and changing for the scope of the invention.
Obviously, those skilled in the art can carry out various changes and modification without deviating from essence of the invention to the present invention
God and scope.So, if these modifications of the invention and modification belong to the scope of the claims in the present invention and its equivalent technologies
Within, then the present invention is also intended to comprising these changes and modification.
Claims (10)
1. a kind of data copy method based on disparate databases, it is characterised in that the method includes：
Receive the configuration-direct of user, generation on by the configuration file of the data duplication in source database to target database,
Wherein, the source database and the target database are single database or are distributed data base, and the configuration file is extremely
Include the database information of the source database and the target database, and screening conditions less；
The configuration file is parsed, according to the analysis result to the screening conditions, using target developing language generation database
Query statement；
The target data is read from the source database using data base querying instruction, and the target data is answered
Make the target database, the target data is that what is filtered out from the source database meet the original of the screening conditions
Beginning data acquisition system.
2. the method for claim 1, it is characterised in that described that the target data is copied into the target data
Storehouse, including：
For an original data object in the target data, determine in the analysis result of the configuration file on institute
State the data routing iinformation of original data object, the target that the data routing iinformation is inserted into comprising the original data object
The station location marker of the information of database and the target database；
According to the data routing iinformation, the target database is filtered, determining needs to insert the initial data
The first object database collection of object；
The station location marker of the target database in the data routing iinformation, the original data object is inserted into
The corresponding position of station location marker described in each target database in the first object database collection.
3. the method for claim 1, it is characterised in that the configuration-direct of the reception user, generation is on by source number
According to the configuration file of the data duplication in storehouse to target database, including：
Receive mode of operation of the user by dragging, drawing, dragging, choosing on graphical interaction interface tool and generate configuration-direct；
According to configuration-direct generation on by the configuration file of the data duplication in source database to target database.
4. the method for claim 1, it is characterised in that described that the target data is copied into the target data
Storehouse, also includes：
According to the analysis result of the configuration file, determine the source database and the target database table structure whether phase
Together；
When the target database is differed with the table structure of the source database, to the target data in the source database
Changed, the target data after conversion is inserted into the target database.
5. method according to claim 1, it is characterised in that also include：
First record strip number of the acquired original data object from the source database of statistics, and count to the number of targets
Second record strip number of the data object write according to place, and in the second record strip number and the first record strip number not phase
Deng when report an error.
6. a kind of data copy system based on disparate databases, it is characterised in that the system includes：
Transmit-Receive Unit, the configuration-direct for receiving user；
Generation unit, for generating on by the configuration file of the data duplication in source database to target database, wherein, institute
State source database and the target database is single database or is distributed data base, the configuration file at least includes institute
State the database information of source database and the target database, and screening conditions；
Resolution unit, for parsing the configuration file；
The generation unit, is additionally operable to according to the analysis result to the screening conditions, using target developing language generation data
Library inquiry is instructed；
Copied cells, for reading the target data from the source database using data base querying instruction, and will
The target data copies to the target database, the target data be filtered out from the source database meet institute
State the original data set of screening conditions.
7. system as claimed in claim 6, it is characterised in that the copied cells specifically for：
For an original data object in the target data, determine in the analysis result of the configuration file on institute
State the data routing iinformation of original data object, the target that the data routing iinformation is inserted into comprising the original data object
The station location marker of the information of database and the target database；
According to the data routing iinformation, the target database is filtered, determining needs to insert the initial data
The first object database collection of object；
The station location marker of the target database in the data routing iinformation, the original data object is inserted into
The corresponding position of station location marker described in each target database in the first object database collection.
8. system as claimed in claim 6, it is characterised in that the Transmit-Receive Unit, hands over specifically for receiving user in figure
Mode of operation on mutual interface tool by dragging, drawing, dragging, choosing generates configuration-direct；
The generation unit, specifically for according to configuration-direct generation on by the data duplication in source database to target
The configuration file of database.
9. system as claimed in claim 6, it is characterised in that the copied cells is additionally operable to：
According to the analysis result of the configuration file, determine the source database and the target database table structure whether phase
Together；When the target database is differed with the table structure of the source database, to the target data in the source database
Changed, the target data after conversion is inserted into the target database.
10. system according to claim 6, it is characterised in that also include：
Check and correction unit, for counting the first record strip number of original data object acquired from the source database, and unites
The second record strip number of the data object write to the target data place is counted, and in the second record strip number and described the
One record strip number reports an error when unequal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611208680.1A CN106815317A (en) | 2016-12-23 | 2016-12-23 | A kind of data copy method and system based on disparate databases |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611208680.1A CN106815317A (en) | 2016-12-23 | 2016-12-23 | A kind of data copy method and system based on disparate databases |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106815317A true CN106815317A (en) | 2017-06-09 |
Family
ID=59109977
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611208680.1A Pending CN106815317A (en) | 2016-12-23 | 2016-12-23 | A kind of data copy method and system based on disparate databases |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106815317A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107577802A (en) * | 2017-09-25 | 2018-01-12 | 山东浪潮商用系统有限公司 | A kind of data base management method and device |
| CN108933828A (en) * | 2018-07-04 | 2018-12-04 | 中国银行股份有限公司 | A kind of data synchronizer and method |
| CN109614434A (en) * | 2018-12-14 | 2019-04-12 | 万翼科技有限公司 | Data lead-in method, device and computer readable storage medium |
| CN110287204A (en) * | 2019-05-22 | 2019-09-27 | 平安普惠企业管理有限公司 | Document method for updating edition, device, equipment and readable storage medium storing program for executing |
| CN113778563A (en) * | 2021-09-27 | 2021-12-10 | 中国银行股份有限公司 | Method and device for loading text file of bank peripheral system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1904883A (en) * | 2005-07-28 | 2007-01-31 | 中兴通讯股份有限公司 | Via platform database copying configurating method |
| CN101706803A (en) * | 2009-11-27 | 2010-05-12 | 天津工业大学 | Method for migrating production data of weaving workshop |
| CN101789021A (en) * | 2010-02-24 | 2010-07-28 | 浪潮通信信息系统有限公司 | Universal configurable database data migration method |
| US20150074052A1 (en) * | 2012-10-30 | 2015-03-12 | Vekatachary Srinivasan | Method and system of stateless data replication in a distributed database system |
| CN105205117A (en) * | 2015-09-09 | 2015-12-30 | 郑州悉知信息科技股份有限公司 | Data table migrating method and device |
| CN105701147A (en) * | 2015-12-30 | 2016-06-22 | 中国银联股份有限公司 | Configurable data transfer management device |
-
2016
- 2016-12-23 CN CN201611208680.1A patent/CN106815317A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1904883A (en) * | 2005-07-28 | 2007-01-31 | 中兴通讯股份有限公司 | Via platform database copying configurating method |
| CN101706803A (en) * | 2009-11-27 | 2010-05-12 | 天津工业大学 | Method for migrating production data of weaving workshop |
| CN101789021A (en) * | 2010-02-24 | 2010-07-28 | 浪潮通信信息系统有限公司 | Universal configurable database data migration method |
| US20150074052A1 (en) * | 2012-10-30 | 2015-03-12 | Vekatachary Srinivasan | Method and system of stateless data replication in a distributed database system |
| CN105205117A (en) * | 2015-09-09 | 2015-12-30 | 郑州悉知信息科技股份有限公司 | Data table migrating method and device |
| CN105701147A (en) * | 2015-12-30 | 2016-06-22 | 中国银联股份有限公司 | Configurable data transfer management device |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107577802A (en) * | 2017-09-25 | 2018-01-12 | 山东浪潮商用系统有限公司 | A kind of data base management method and device |
| CN108933828A (en) * | 2018-07-04 | 2018-12-04 | 中国银行股份有限公司 | A kind of data synchronizer and method |
| CN109614434A (en) * | 2018-12-14 | 2019-04-12 | 万翼科技有限公司 | Data lead-in method, device and computer readable storage medium |
| CN110287204A (en) * | 2019-05-22 | 2019-09-27 | 平安普惠企业管理有限公司 | Document method for updating edition, device, equipment and readable storage medium storing program for executing |
| CN113778563A (en) * | 2021-09-27 | 2021-12-10 | 中国银行股份有限公司 | Method and device for loading text file of bank peripheral system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106815317A (en) | A kind of data copy method and system based on disparate databases | |
| CN106326363B (en) | A kind of matching process and device based on regular expression | |
| CN102232212A (en) | Mapping instances of a dataset within a data management system | |
| US8429574B2 (en) | Dual-pattern coloring technique for mask design | |
| CN106557854A (en) | A kind of methods of exhibiting and device of operation flow | |
| CN110275861A (en) | Date storage method and device, storage medium, electronic device | |
| US10846057B2 (en) | System and method for automatic software application creation | |
| CN109241318A (en) | Picture recommendation method, device, computer equipment and storage medium | |
| JP2014199569A (en) | Source program analysis system, source program analysis method, and program | |
| CN112948039A (en) | Page display method, device, equipment and storage medium | |
| CN110633078B (en) | Method and device for automatically generating feature calculation codes | |
| CN113268227A (en) | Zero-code visualization software development platform and development method | |
| CN110377576A (en) | Create method and apparatus, the log analysis method of log template | |
| CN110046155A (en) | The update of property data base, data characteristics determination method, device and equipment | |
| CN109359027A (en) | Monkey test method, device, electronic equipment and computer readable storage medium | |
| CN105843605B (en) | A kind of data mapping method and device | |
| US7181708B1 (en) | Coverage metric and coverage computation for verification based on design partitions | |
| CN112732242A (en) | Wide table processing script generation method and device | |
| CN115617594B (en) | Method, apparatus, storage medium, and program product for generating incentive information | |
| CN107291749A (en) | A kind of determination method and device of data target incidence relation | |
| US9182946B2 (en) | Method of generating a computer architecture representation in a reusable syntax and grammar | |
| CN109614416A (en) | A kind of invoice management method and device based on data statistic analysis | |
| CN112256978B (en) | Data processing method, device and medium based on data model | |
| US7539554B2 (en) | Tape out template system and method | |
| US9003358B2 (en) | Method of taking a computer architecture respresentation and generating manufacturing methods capable of manufacturing a computer systems contained in a specification |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170609 |
|
| RJ01 | Rejection of invention patent application after publication |