CN107403012A - A kind of method for interchanging data and device - Google Patents
A kind of method for interchanging data and device Download PDFInfo
- Publication number
- CN107403012A CN107403012A CN201710647142.0A CN201710647142A CN107403012A CN 107403012 A CN107403012 A CN 107403012A CN 201710647142 A CN201710647142 A CN 201710647142A CN 107403012 A CN107403012 A CN 107403012A
- Authority
- CN
- China
- Prior art keywords
- data
- transient target
- source
- storage address
- structural
- 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
- 238000000034 method Methods 0.000 title claims abstract description 38
- 230000001052 transient effect Effects 0.000 claims abstract description 119
- 238000003860 storage Methods 0.000 claims abstract description 111
- 238000013500 data storage Methods 0.000 claims description 17
- 230000008859 change Effects 0.000 claims description 7
- 238000000547 structure data Methods 0.000 claims description 6
- 238000010276 construction Methods 0.000 abstract description 8
- 238000004519 manufacturing process Methods 0.000 description 23
- 238000013523 data management Methods 0.000 description 17
- 230000001360 synchronised effect Effects 0.000 description 17
- 241001269238 Data Species 0.000 description 6
- 238000004891 communication Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 3
- 238000000151 deposition Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000001788 irregular Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a kind of method for interchanging data and device, this method includes：Establishment and object table structure identical transient target table, wherein, object table is located at the data receiver of data exchange；According to the structure of transient target table, at least one structural data to be exchanged in the table of source is stored into temporary directory table, wherein, source epitope is in the data sending terminal of data exchange；For each structural data, the unstructured data associated with structural data is uploaded to data receiver, and obtains the first storage address of unstructured data；For each unstructured data, the first storage address of unstructured data is stored into transient target table, and creates the incidence relation of the first storage address and corresponding construction data；Structural data in transient target table and the first storage address are updated to object table.This programme can lift the usage experience of user.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of method for interchanging data and device.
Background technology
Unstructured data is that data structure is irregular or imperfect, without predefined data model, it has not been convenient to use number
According to storehouse two dimension logical table come the data that show, including the information such as the office documents of various forms, text, picture, audio, video.
In data management processes, it is often necessary to realize the data exchange between two systems, i.e., by the data syn-chronization in a system
Into another system, such as, in Enterprise Resources Plan (Enterprise Resource Planning, ERP) system, need
Realize it is different production modules between business paper exchange, and business paper be typically by structural data and unstructured number
According to composition.
At present, in data exchange between realizing two systems, according to original system and goal systems to unstructured data
Management strategy, formulate corresponding data exchange rule, passing through formulated data exchange rule will be to be exchanged in original system
Data include structural data and unstructured data is synchronized in goal systems.
Method for carrying out data exchange at present, the mode being managed to non-structural data due to different system is not
Together, therefore each time carry out data exchange be required for according to original system and goal systems to the management strategy of unstructured data come
Corresponding data exchange rule is formulated, larger inconvenience is brought to data exchange work, causes user experience poor.
The content of the invention
The embodiments of the invention provide a kind of method for interchanging data and device, the usage experience of user can be lifted.
In a first aspect, the embodiments of the invention provide a kind of method for interchanging data, including：
Establishment and object table structure identical transient target table, wherein, the data that the object table is located at data exchange connect
Receiving end；
According to the structure of the transient target table, by least one structural data storage to be exchanged in the table of source described in
In temporary directory table, wherein, the source epitope is in the data sending terminal of data exchange；
For each structural data, the unstructured data associated with the structural data is uploaded to
The data receiver, and obtain the first storage address of the unstructured data；
For each unstructured data, by the first storage address storage of the unstructured data described in
In transient target table, and create first storage address and the incidence relation of the corresponding structural data；
The structural data in the transient target table and first storage address are updated to the object table.
Alternatively,
The structure according to the transient target table, at least one structural data storage to be exchanged in the table of source is arrived
In the transient target table, including：
Create and the interim source table of source table structure identical；
By at least one structural data storage to be exchanged in the source table into the interim source table；
According to the structure of the interim source table and the transient target table, by structure described in each bar in the interim source table
Change in transient target table described in data Cun Chudao.
Alternatively,
After structural data described in each bar by the interim source table is stored into the transient target table,
Further comprise：
The interim source table is deleted.
Alternatively,
It is described will be before unstructured data associated with the structural data be uploaded to the data receiver, bag
Include：
The second storage address of the unstructured data associated with the structural data is obtained from the source table；
The unstructured data associated with the structural data is downloaded according to second storage address.
Alternatively,
It is updated in the structural data by the transient target table and first storage address described
After object table, further comprise：
The transient target table is deleted.
The second aspect embodiment of the present invention additionally provides a kind of DEU data exchange unit, including：Creating unit, the first synchronous list
Member, uploading unit, the second synchronization unit and updating block；
The creating unit, for establishment and object table structure identical transient target table, wherein, the object table is located at
The data receiver of data exchange；
First synchronization unit, for the structure of the transient target table created according to the creating unit, by source
At least one structural data to be exchanged is stored into the transient target table in table, wherein, the source epitope is handed in data
The data sending terminal changed；
The uploading unit, will be associated with the structural data for for each structural data
Unstructured data is uploaded to the data receiver, and obtains the first storage address of the unstructured data；
Second synchronization unit, for for each unstructured data, the unit of the upload to be obtained
To the first storage address of the unstructured data store into the transient target table, and create first storage
Location and the incidence relation of the corresponding structural data；
The updating block, for by the structural data in the transient target table and first storage address
It is updated to the object table.
Alternatively,
The creating unit, it is further used for creating and the interim source table of source table structure identical；
First synchronization unit, it is described at least one structural data storage to be exchanged in the source table to be arrived
In the interim source table that creating unit creates, and according to the structure of the interim source table and the transient target table, by described in
Structural data described in each bar in the table of interim source is stored into the transient target table.
Alternatively,
The creating unit, it is further used for tie described in each bar in the interim source table in first synchronization unit
After in transient target table described in structure data Cun Chudao, the interim source table is deleted.
Alternatively,
The uploading unit, it is further used for obtaining from the source table associated with the structural data non-structural
Change the second storage address of data, and downloaded according to second storage address associated with the structural data described non-
Structural data.
Alternatively,
The creating unit, it is further used for the structuring number in the transient target table in the updating block
After the object table is updated to first storage address, the transient target table is deleted.
The embodiments of the invention provide a kind of method for interchanging data and device, is needing the data syn-chronization in the table of source to mesh
When marking table, establishment and object table structure identical transient target table will be to be exchanged in the table of source according to the structure of transient target table
Structural data storage is uploaded to object table into transient target table, and by the unstructured data associated with structural data
After the data receiver at place, the first storage address of unstructured data recorded in transient target table, create first and deposit
, will by the way that the data in transient target table are updated into object table completion after the incidence relation for storing up address and corresponding construction data
Structural data and associated unstructured data in the table of source are synchronized to object table.As can be seen here, by creating interim mesh
Mark table, no matter how source table and the structure of object table can realize exchanging for structural data and unstructured data, without
Data exchange rule is customized, so as to improve the usage experience of user.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are the present invention
Some embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
These accompanying drawings obtain other accompanying drawings.
Fig. 1 is a kind of flow chart for method for interchanging data that one embodiment of the invention provides；
Fig. 2 is the flow chart for another method for interchanging data that one embodiment of the invention provides；
Fig. 3 is the schematic diagram of equipment where a kind of DEU data exchange unit that one embodiment of the invention provides；
Fig. 4 is a kind of schematic diagram for DEU data exchange unit that one embodiment of the invention provides；
Fig. 5 is a kind of schematic diagram for DEU data exchange unit that another embodiment of the present invention provides.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
Part of the embodiment of the present invention, rather than whole embodiments, based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment obtained on the premise of creative work is not made, belongs to the scope of protection of the invention.
As shown in figure 1, the embodiments of the invention provide a kind of method for interchanging data, this method may comprise steps of：
Step 101：Establishment and object table structure identical transient target table, wherein, the object table is located at data exchange
Data receiver；
Step 102：According to the structure of the transient target table, at least one structural data to be exchanged in the table of source is deposited
Store up in the temporary directory table, wherein, the source epitope is in the data sending terminal of data exchange；
Step 103：For each structural data, by the unstructured number associated with the structural data
According to being uploaded to the data receiver, and obtain the first storage address of the unstructured data；
Step 104：For each unstructured data, the first storage address of the unstructured data is deposited
Store up in the transient target table, and create first storage address and the incidence relation of the corresponding structural data；
Step 105：The structural data in the transient target table and first storage address are updated to institute
State object table.
The embodiments of the invention provide a kind of method for interchanging data, is needing the data syn-chronization in the table of source to object table
When, create with object table structure identical transient target table, according to the structure of transient target table by structure to be exchanged in the table of source
Change in data Cun Chudao transient target tables, and the unstructured data associated with structural data is uploaded to where object table
Data receiver after, the first storage address of unstructured data recorded in transient target table, create the first storage
Location by the way that the data in transient target table are updated into object table with after the incidence relation of corresponding construction data, being completed source table
In structural data and associated unstructured data be synchronized to object table.As can be seen here, by creating transient target table,
No matter how source table and the structure of object table can realize exchanging for structural data and unstructured data, without customizing number
According to exchange regulation, so as to improve the usage experience of user.
Alternatively, as shown in figure 1,
When step 102 stores structural data to be exchanged into transient target table, create has phase first with source table
Isostructural interim source table, and each bar structural data to be exchanged in the table of source is stored into interim source table；Then basis is faced
Shi Yuanbiao and transient target table structure, by each bar structural data stored in interim source table storage into transient target table.
Because source epitope in the data sending terminal of data exchange, object table is located at the data receiver of data exchange, data
Transmitting terminal and data receiver possibly can not direct communications, it is therefore desirable to can be with data sending terminal and data receiver simultaneously
The current data processing end to be communicated creates interim source table and transient target table so that interim source table has identical with source table
Structure so that transient target table has identical structure with object table.So, the structural data in the table of source is synchronized to temporarily
After in the table of source, according to the corresponding relation of structure between interim source table and transient target table, each bar knot that will be stored in interim source table
In the interim table of structure data Cun Chudao modules.
By creating interim source table and transient target table, no matter where the table of source with data sending terminal and the number where object table
According between receiving terminal whether can direct communication, the data can be improved by the data syn-chronization in the table of source into object table
The applicability of exchange method.
Alternatively, can be by institute after the structural data that will be stored in interim source table is stored into transient target table
The interim source table created is deleted.
Because each structural data to be exchanged in the table of source is synchronized to and faced by the middleware that functions as of interim source table
When object table in, after the structural data stored in interim source table is synchronized into transient target table, interim source table has not had
Other use, now interim source table is deleted, storage resource can be discharged, improve the utilization rate of storage resource.
Alternatively, as shown in figure 1,
Step 103 will be uploaded to where object table with each associated unstructured data of structural data respectively
Data receiver, first have to get the associated unstructured data of each structural data before step 103, specifically
Ground：
For each structural data, the unstructured data associated with the structural data is obtained from the table of source
Second storage address, the unstructured data associated with the structural data is downloaded according to the second storage address got.
Because unstructured data can not be stored directly in tables of data, the general data storage storehouse of unstructured data or clothes
It is engaged on device, therefore, each structural data associates the storage address of one or more unstructured data, user in the table of source
The unstructured data being stored on database or server can be conducted interviews by the storage address of unstructured data.
Certainly, the second storage address that some structural datas in the table of source may not be associated, i.e. these structural datas do not have
Associated unstructured data, the place of corresponding unstructured data is then subsequently uploaded without performing for this type of structured data
Reason.
Because unstructured data is stored on database or server, and data receiver may be right with data sending terminal
Different database and server are answered, therefore is differed surely by the second storage address recorded in the table of source in data receiver
Enough access corresponding unstructured data.Therefore, it is necessary on after according to the second storage address, unstructured data is downloaded
Data receiver is reached, and first storage address of the unstructured data in data receiver is stored into transient target table,
The incidence relation established between the first storage address and corresponding construction data.So, by the structuring number in transient target table
After being synchronized to the first storage address in object table, user can be direct according to the first storage address recorded in object table
Corresponding unstructured data is conducted interviews, ensure that the accessibility of data after exchanging.
Alternatively, as shown in figure 1,
Step 105 stores the structural data of the storage in transient target table and associated with structural data first
After address is updated in object table, transient target table can be deleted.
By the structural data in transient target table and first storage address associated with each structural data
After updating in object table, the new of structural data and the unstructured data associated with structural data in the table of source is deposited
Storage address has been synchronized in object table, and without other use, transient target table is deleted to be discharged transient target table
Memory space, the utilization rate of memory space is lifted, ensure the speed of data exchange.
Below exemplified by the data exchange between two production modules in ERP system, to number provided in an embodiment of the present invention
It is described in further detail according to exchange method, as shown in Fig. 2 this method may comprise steps of：
Step 201：Create and the interim source table of source table structure identical.
In an embodiment of the invention, production modules A, production module B and data management mould are included in ERP system
Block C, produce and tables of data A is stored with modules A, be stored with tables of data B on production module B, periodically need the number in tables of data A
According to being synchronized in tables of data B, now tables of data A is source table, and tables of data B is object table.Due to production modules A and production module B
Possibly can not direct communication, and data management module C can simultaneously to production modules A and production module B conduct interviews, therefore
An interim source table is created on data management module C, the structure of interim source table is identical with tables of data A structure.
For example, include 4 fields in tables of data A altogether, wherein preceding 3 fields are followed successively by name, sex and age, the 4th
Field is associated unstructured data storage address.An interim source table, interim source table are then created on data management module C
Including 3 fields, 3 fields are followed successively by name, sex and age.
Step 202：Structural data to be exchanged in the table of source is stored into interim source table.
In an embodiment of the invention, after the completion of the establishment of interim source table, structure to be exchanged is obtained from tables of data A
Change data, and by the structural data got storage into interim source table.
For example, include 3 structural datas to be exchanged, respectively structural data 1, structuring in tables of data A altogether
Data 2 and structural data 3, wherein, name, sex and age corresponding to structural data 1 are respectively name 1, man and 25, are tied
Name, sex and age corresponding to structure data 2 are respectively name 2, female and 28, name corresponding to structural data 3, sex and
Age is respectively name 2, female and 30.After obtaining 3 structural datas from tables of data A, according to the structure of interim source table, by 3
Bar structural data is stored into interim source table, as shown in table 1 below：
Table 1
| Name | Sex | Age |
| Name 1 | Man | 25 |
| Name 2 | Female | 28 |
| Name 3 | Female | 30 |
Step 203：Create and object table structure identical transient target table.
In an embodiment of the invention, a transient target table is created on data management module C, creates interim mesh
The structure for marking table is identical with tables of data B structure.
For example tables of data B includes 4 fields altogether, first character section is name, second field is associated unstructured
Address data memory, the 3rd field are the age, and the 4th field is sex, then according to tables of data B structure, in data management
Creating one on module C has mutually isostructural transient target table.
Step 204：According to the structure of interim source table and transient target table, the structural data in interim source table is synchronized to
In transient target table.
In an embodiment of the invention, after transient target table is created, according to interim source table and the knot of transient target table
Structure, each bar structural data being stored in interim source table is synchronized in transient target table.
For example, according to the structure of transient target table, structural data 1, the structural data 2 that will be stored in interim source table
It is synchronized to respectively in transient target table with structural data 3.After 3 structural datas are synchronized in transient target table, face
When object table it is as shown in table 2 below：
Table 2
Step 205：Second storage address of the unstructured data associated with structural data recorded according to source token,
Download unstructured data.
In an embodiment of the invention, each structural data to be exchanged there may be associated unstructured
Data, if a structural data has associated unstructured data, the second of associated unstructured data deposits
Storage address is recorded in corresponding field in the table of source.For each structural data in 3 structural datas, according to tables of data
The second storage address recorded in A, respectively from unstructured data corresponding to production modules A download to data management module C.
For example, in tables of data A, structural data 1 records under the 4th field the second storage address 1, structuring number
Being recorded according to 2 under the 4th field has the second storage address 2 and the second storage address 3, and structural data 3 is under the 4th field
It is empty.Unstructured data 1 is then downloaded to data management module C from production modules A according to the second storage address 1, according to second
Storage address 2 downloads unstructured data 2 to data management module C from production modules A, according to the second storage address 3 from life
Unstructured data 3, which is downloaded, in production modules A arrives data management module C.
Step 206：The production module unstructured data of download being uploaded to where object table, and obtain each it is non-
First storage address of structural data.
In an embodiment of the invention, unstructured data is being downloaded to data management module C from production modules A
Afterwards, the production module B respectively uploaded to each unstructured data of download where object table, and return to each non-knot
First storage address of the structure data on production module B is to data management module C.
For example, after unstructured data 1 is uploaded into production module B, unstructured data 1 is returned on production module B
The first storage address 1 to data management module C；After unstructured data 2 is uploaded into production module B, return unstructured
First storage address 2 of the data 2 on production module B is to data management module C；Unstructured data 3 is uploaded to production mould
After block B, first storage address 3 of the unstructured data 3 on production module B is returned to data management module C.
Step 207：First storage address of each bar unstructured data recorded in transient target table, establish and relative
Answer the incidence relation of structural data.
In an embodiment of the invention, after the first storage address of each bar unstructured data is got, according to every
One unstructured data and the incidence relation of corresponding construction data, the first storage address of each bar unstructured data is remembered
Record in transient target table under the associated unstructured data storage address field of corresponding construction data.
For example, because unstructured data 1 is associated with structural data 1, in transient target table, in structural data
The first storage address 1 of unstructured data 1 is recorded under 1 associated unstructured data storage address field；Due to non-knot
Structure data 2 and unstructured data 3 are associated with structural data 2, in transient target table, in the phase of structural data 2
Associate the first storage address 2 and unstructured data 3 that unstructured data 2 is recorded under unstructured data storage address field
The first storage address 3.The transient target table of the first storage address 1, the first storage address 2 and the first storage address 3 has been recorded,
It is as shown in table 3 below：
Table 3
| Name | Associated unstructured data storage address | Age | Sex |
| Name 1 | First storage address 1 | 25 | Man |
| Name 2 | First storage address 1, the first storage address 2 | 28 | Female |
| Name 3 | 30 | Female |
Step 208：Object table is arrived into data renewal in transient target table.
In an embodiment of the invention, transient target is arrived into the first storage address storage of each bar unstructured data
After in table, by the structural data in transient target table and the renewal of corresponding first storage address into tables of data B, completing will
Data to be exchanged in tables of data A is synchronized to tables of data B.
Step 209：Transient target table and interim source table are deleted.
In an embodiment of the invention, arrived by the structural data in transient target table and the renewal of the first storage address
After in object table, transient target table and interim source table have been completed the mission of oneself, by transient target table and interim source table
Delete, to discharge memory space.
As shown in Figure 3, Figure 4, the embodiments of the invention provide a kind of DEU data exchange unit.Device embodiment can be by soft
Part is realized, can also be realized by way of hardware or software and hardware combining.For hardware view, as shown in figure 3, being this hair
A kind of hardware structure diagram of equipment where the DEU data exchange unit that bright embodiment provides, except the processor shown in Fig. 3, internal memory,
Outside network interface and nonvolatile memory, the equipment in embodiment where device can also generally include other hardware,
Such as it is responsible for the forwarding chip of processing message.Exemplified by implemented in software, as shown in figure 4, as the dress on a logical meaning
Put, be to read corresponding computer program instructions in nonvolatile memory in internal memory by the CPU of equipment where it to transport
What row was formed.The DEU data exchange unit that the present embodiment provides, including：Creating unit 401, the first synchronization unit 402, uploading unit
403rd, the second synchronization unit 404 and updating block 405；
Creating unit 401, for establishment and object table structure identical transient target table, wherein, object table is located at data
The data receiver of exchange；
First synchronization unit 402, for the structure of the transient target table created according to creating unit 401, it will be treated in the table of source
At least one structural data exchanged is stored into transient target table, wherein, source epitope is in the data sending terminal of data exchange；
Uploading unit 403, for for each structural data, by the unstructured number associated with structural data
According to being uploaded to data receiver, and obtain the first storage address of unstructured data；
Second synchronization unit 404, for for each unstructured data, the unit 403 of upload being got non-
First storage address of structural data is stored into transient target table, and creates the first storage address and corresponding construction data
Incidence relation；
Updating block 405, for the structural data in transient target table and the first storage address to be updated into object table.
Alternatively, as shown in figure 4,
Creating unit 401, it is further used for creating and the interim source table of source table structure identical；
First synchronization unit 402, at least one structural data storage to be exchanged in the table of source to be arrived into creating unit
In the 401 interim source tables created, and according to the structure of interim source table and transient target table, by each bar structuring in interim source table
In data Cun Chudao transient target tables.
Alternatively, as shown in figure 4,
Creating unit 401, it is further used for depositing each bar structural data in interim source table in the first synchronization unit 402
After storing up in transient target table, interim source table is deleted.
Alternatively, as shown in figure 4,
Uploading unit 403, it is further used for obtaining the unstructured data associated with structural data from the table of source
Second storage address, and the unstructured data associated with structural data is downloaded according to the second storage address.
Alternatively, as shown in figure 5,
Creating unit 401, it is further used for depositing the structural data in transient target table and first in updating block 405
Storage address is updated to after object table, and transient target table is deleted.
The contents such as the information exchange between each unit, implementation procedure in said apparatus, due to implementing with the inventive method
Example is based on same design, and particular content can be found in the narration in the inventive method embodiment, and here is omitted.
The embodiment of the present invention additionally provides a kind of computer-readable recording medium, is stored with execute instruction in the computer-readable recording medium, works as storage
Described in the computing device of controller during execute instruction, the storage control performs the data that above-mentioned each embodiment provides and handed over
Change method.
The embodiment of the present invention additionally provides a kind of storage control, including：Processor, memory and bus；
The memory is used to store execute instruction, and the processor is connected with the memory by the bus, when
During the storage control operation, the execute instruction of memory storage described in the computing device, so that the storage
Controller performs the method for interchanging data that above-mentioned each embodiment provides.
In summary, the method for interchanging data and device that each embodiment of the present invention provides, at least have following beneficial to effect
Fruit：
1st, in embodiments of the present invention, when needing the data syn-chronization in the table of source to object table, create and object table knot
Structure identical transient target table, structural data storage to be exchanged in the table of source is arrived by interim mesh according to the structure of transient target table
Mark in table, and after the unstructured data associated with structural data to be uploaded to the data receiver where object table, general
First storage address of unstructured data recorded in transient target table, create the first storage address and corresponding construction data
Incidence relation after, completed by the way that the data in transient target table are updated into object table by the structural data and phase in the table of source
The unstructured data of association is synchronized to object table.As can be seen here, by creating transient target table, no matter source table and object table
How structure can realize the exchange of structural data and unstructured data, without customizing data exchange rule, so as to
To improve the usage experience of user.
2nd, in embodiments of the present invention, during data syn-chronization is to object table in by source table, the interim source that is created
Table and transient target table exist as middleware, due to the data receiver where the data sending terminal and object table where the table of source
Between may not direct communication, by the data that can be communicated with data sending terminal and data receiver simultaneously
Interim source table and transient target table are created in management end, no matter source table place connects with data sending terminal and the data where object table
Between receiving end whether can direct communication, the data exchange can be improved by the data syn-chronization in the table of source into object table
The applicability of method.
3rd, in embodiments of the present invention, after the data in transient target table are updated into object table, interim source table
The mission of oneself is had been completed with transient target table, now interim source table and transient target table are deleted, storage can be discharged
Resource, improves the utilization rate of storage resource, and ensures the speed of data exchange.
4th, in embodiments of the present invention, because unstructured data is stored on database or server, and data receiver
End may correspond to different databases and server from data sending terminal, therefore pass through in data receiver recorded in the table of source
Second storage address is not necessarily able to access that corresponding unstructured data, therefore, from database corresponding to data sending terminal or
After server downloads unstructured data, the unstructured data of download is uploaded to database corresponding to data receiver or clothes
Business device, and the new storage address of unstructured data is synchronized in object table, such user can record according in object table
The first storage address directly corresponding unstructured data is conducted interviews, ensure that exchange after data accessibility.
It should be noted that herein, such as first and second etc relational terms are used merely to an entity
Or operation makes a distinction with another entity or operation, and not necessarily require or imply and exist between these entities or operation
Any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant be intended to it is non-
It is exclusive to include, so that process, method, article or equipment including a series of elements not only include those key elements,
But also the other element including being not expressly set out, or also include solid by this process, method, article or equipment
Some key elements.In the absence of more restrictions, by sentence " including the key element that a 〃 〃 " is limited, it is not excluded that
Other identical factor in the process including the key element, method, article or equipment also be present.
One of ordinary skill in the art will appreciate that：Realizing all or part of step of above method embodiment can pass through
Programmed instruction related hardware is completed, and foregoing program can be stored in computer-readable storage medium, the program
Upon execution, the step of execution includes above method embodiment；And foregoing storage medium includes：ROM, RAM, magnetic disc or light
Disk etc. is various can be with the medium of store program codes.
It is last it should be noted that：Presently preferred embodiments of the present invention is the foregoing is only, is merely to illustrate the skill of the present invention
Art scheme, is not intended to limit the scope of the present invention.Any modification for being made within the spirit and principles of the invention,
Equivalent substitution, improvement etc., are all contained in protection scope of the present invention.
Claims (10)
- A kind of 1. method for interchanging data, it is characterised in that including：Establishment and object table structure identical transient target table, wherein, the object table is located at the data receiver of data exchange；According to the structure of the transient target table, at least one structural data storage to be exchanged in the table of source is arrived described interim In catalogue listing, wherein, the source epitope is in the data sending terminal of data exchange；For each structural data, the unstructured data associated with the structural data is uploaded to described Data receiver, and obtain the first storage address of the unstructured data；For each unstructured data, the first storage address storage of the unstructured data is arrived described interim In object table, and create first storage address and the incidence relation of the corresponding structural data；The structural data in the transient target table and first storage address are updated to the object table.
- 2. according to the method for claim 1, it is characterised in that the structure according to the transient target table, by source table In at least one structural data to be exchanged store into the transient target table, including：Create and the interim source table of source table structure identical；By at least one structural data storage to be exchanged in the source table into the interim source table；According to the structure of the interim source table and the transient target table, by structuring number described in each bar in the interim source table According to storage into the transient target table.
- 3. according to the method for claim 2, it is characterised in that in structure described in each bar by the interim source table After changing in transient target table described in data Cun Chudao, further comprise：The interim source table is deleted.
- 4. according to the method for claim 1, it is characterised in that it is described will be associated with the structural data non-structural Change data to be uploaded to before the data receiver, including：The second storage address of the unstructured data associated with the structural data is obtained from the source table；The unstructured data associated with the structural data is downloaded according to second storage address.
- 5. according to any described method in Claims 1-4, it is characterised in that described by the transient target table The structural data and first storage address are updated to after the object table, are further comprised：The transient target table is deleted.
- A kind of 6. DEU data exchange unit, it is characterised in that including：It is creating unit, the first synchronization unit, uploading unit, second same Walk unit and updating block；The creating unit, for establishment and object table structure identical transient target table, wherein, the object table is located at data The data receiver of exchange；First synchronization unit, for the structure of the transient target table created according to the creating unit, by the table of source At least one structural data to be exchanged is stored into the transient target table, wherein, the source epitope is in data exchange Data sending terminal；The uploading unit, for for each structural data, by the non-knot associated with the structural data Structure data are uploaded to the data receiver, and obtain the first storage address of the unstructured data；Second synchronization unit, for for each unstructured data, the unit of the upload to be got First storage address of the unstructured data is stored into the transient target table, and create first storage address with The incidence relation of the corresponding structural data；The updating block, for the structural data in the transient target table and first storage address to be updated To the object table.
- 7. device according to claim 6, it is characterised in thatThe creating unit, it is further used for creating and the interim source table of source table structure identical；First synchronization unit, at least one structural data storage to be exchanged in the source table to be arrived into the establishment , will be described interim in the interim source table that unit creates, and according to the structure of the interim source table and the transient target table Structural data storage is into the transient target table described in each bar in the table of source.
- 8. device according to claim 7, it is characterised in thatThe creating unit, it is further used for structuring described in each bar in the interim source table in first synchronization unit After in transient target table described in data Cun Chudao, the interim source table is deleted.
- 9. device according to claim 6, it is characterised in thatThe uploading unit, it is further used for obtaining the unstructured number associated with the structural data from the source table According to the second storage address, and downloaded according to second storage address associated with the structural data described non-structural Change data.
- 10. according to any described device in claim 6 to 9, it is characterised in thatThe creating unit, be further used for the updating block by the structural data in the transient target table and First storage address is updated to after the object table, and the transient target table is deleted.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710647142.0A CN107403012A (en) | 2017-08-01 | 2017-08-01 | A kind of method for interchanging data and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710647142.0A CN107403012A (en) | 2017-08-01 | 2017-08-01 | A kind of method for interchanging data and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107403012A true CN107403012A (en) | 2017-11-28 |
Family
ID=60401288
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710647142.0A Pending CN107403012A (en) | 2017-08-01 | 2017-08-01 | A kind of method for interchanging data and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107403012A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109308336A (en) * | 2018-09-06 | 2019-02-05 | 成都大学 | Data processing method, processing equipment and storage medium |
| CN109614440A (en) * | 2018-10-25 | 2019-04-12 | 深圳壹账通智能科技有限公司 | Method of data synchronization and relevant device based on big data |
| CN109740027A (en) * | 2019-01-28 | 2019-05-10 | 上海达梦数据库有限公司 | Method for interchanging data, device, server and storage medium |
| CN112749163A (en) * | 2020-12-30 | 2021-05-04 | 山东浪潮通软信息科技有限公司 | Data transmission method, device and medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070038400A1 (en) * | 2002-02-20 | 2007-02-15 | Hsu-Tung Lee | Method And System For Assessing Quality Of Spot Welds |
| CN101002207A (en) * | 2004-06-04 | 2007-07-18 | 爱克发公司 | Generalized approach to structured medical reporting |
| CN103595727A (en) * | 2013-11-22 | 2014-02-19 | 中国航天科工集团第二研究院七〇六所 | Cross-domain incremental data exchange model and method based on exchange identification |
| CN105069033A (en) * | 2015-07-22 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Method and device for creating database table model |
| CN106325933A (en) * | 2016-08-24 | 2017-01-11 | 明算科技（北京）股份有限公司 | Method and device for synchronizing batch data |
| CN106612330A (en) * | 2017-01-05 | 2017-05-03 | 广州慧睿思通信息科技有限公司 | System and method supporting distributed multi-file importing |
| CN106682002A (en) * | 2015-11-05 | 2017-05-17 | 中兴通讯股份有限公司 | Database synchronization method and system, source data and target data synchronization device |
-
2017
- 2017-08-01 CN CN201710647142.0A patent/CN107403012A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070038400A1 (en) * | 2002-02-20 | 2007-02-15 | Hsu-Tung Lee | Method And System For Assessing Quality Of Spot Welds |
| CN101002207A (en) * | 2004-06-04 | 2007-07-18 | 爱克发公司 | Generalized approach to structured medical reporting |
| CN103595727A (en) * | 2013-11-22 | 2014-02-19 | 中国航天科工集团第二研究院七〇六所 | Cross-domain incremental data exchange model and method based on exchange identification |
| CN105069033A (en) * | 2015-07-22 | 2015-11-18 | 北京京东尚科信息技术有限公司 | Method and device for creating database table model |
| CN106682002A (en) * | 2015-11-05 | 2017-05-17 | 中兴通讯股份有限公司 | Database synchronization method and system, source data and target data synchronization device |
| CN106325933A (en) * | 2016-08-24 | 2017-01-11 | 明算科技（北京）股份有限公司 | Method and device for synchronizing batch data |
| CN106612330A (en) * | 2017-01-05 | 2017-05-03 | 广州慧睿思通信息科技有限公司 | System and method supporting distributed multi-file importing |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109308336A (en) * | 2018-09-06 | 2019-02-05 | 成都大学 | Data processing method, processing equipment and storage medium |
| CN109614440A (en) * | 2018-10-25 | 2019-04-12 | 深圳壹账通智能科技有限公司 | Method of data synchronization and relevant device based on big data |
| CN109740027A (en) * | 2019-01-28 | 2019-05-10 | 上海达梦数据库有限公司 | Method for interchanging data, device, server and storage medium |
| CN109740027B (en) * | 2019-01-28 | 2020-01-10 | 上海达梦数据库有限公司 | Data exchange method, device, server and storage medium |
| CN112749163A (en) * | 2020-12-30 | 2021-05-04 | 山东浪潮通软信息科技有限公司 | Data transmission method, device and medium |
| CN112749163B (en) * | 2020-12-30 | 2023-08-01 | 浪潮通用软件有限公司 | Data transmission method, device and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103731483B (en) | Virtual file system based on cloud computing | |
| CN107403012A (en) | A kind of method for interchanging data and device | |
| CN104216912B (en) | The implementation method and device of a kind of business form work fluidisation without intrusive mood | |
| CN101605210B (en) | Production and broadcast integrated system of financial data | |
| CN109816321A (en) | A kind of service management, device, equipment and computer readable storage medium | |
| CN104778222B (en) | Media library based on USB storage device is established and update method | |
| US20240020162A1 (en) | Workflow selection | |
| CN105975502A (en) | Method for realizing incremental data extract based on CDC (Change Data Capture) mode | |
| CN106302632A (en) | The method for down loading of a kind of foundation image and management node | |
| CN104423982B (en) | The processing method and processing equipment of request | |
| CN107656729A (en) | Updating device, method and the computer-readable recording medium of List View | |
| CN104376431A (en) | Engineering project management method and system | |
| CN103701653B (en) | The processing method of a kind of interface hot plug configuration data and network configuration server | |
| CN106934023A (en) | A kind of data managing method and device | |
| CN106326062A (en) | Method and device for controlling running state of application program | |
| CN108021621A (en) | Database data acquisition method, application server and computer-readable recording medium | |
| CN107465687A (en) | A kind of implementation method of authority configuration, device and terminal | |
| CN108038195A (en) | A kind of intelligent terminal searches method, apparatus, intelligent terminal and the storage medium of topic | |
| CN109344296A (en) | Realize domain life cycle control method, system, server and the storage medium of the HASH key of Redis | |
| CN103139311A (en) | System, device and method of file sharing | |
| CN105159997B (en) | Report processing method and report processing system | |
| CN105740957A (en) | Tax service reservation method, device and system | |
| CN105574706A (en) | Format and rule management for form data in process editor | |
| CN106384292A (en) | System and method for collecting relation among social network users | |
| CN107943455A (en) | A kind of list rendering system based on JSON data formats |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171128 |