CN108304461A - A kind of method and device of data sharing - Google Patents
A kind of method and device of data sharing Download PDFInfo
- Publication number
- CN108304461A CN108304461A CN201711427978.6A CN201711427978A CN108304461A CN 108304461 A CN108304461 A CN 108304461A CN 201711427978 A CN201711427978 A CN 201711427978A CN 108304461 A CN108304461 A CN 108304461A
- Authority
- CN
- China
- Prior art keywords
- shared
- data
- excel tables
- captured
- program
- 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 41
- 238000013500 data storage Methods 0.000 claims abstract description 23
- 238000004458 analytical method Methods 0.000 claims description 8
- 230000008569 process Effects 0.000 description 7
- 238000012545 processing Methods 0.000 description 5
- 230000009471 action Effects 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 4
- 230000006837 decompression Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000003032 molecular docking Methods 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 241001269238 Data Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000004888 barrier function Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000007726 management method Methods 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
- 239000007787 solid Substances 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/24—Querying
- G06F16/248—Presentation of query results
-
- 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)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of method and device of data sharing, this method, including：Capture program is set for the first system at the first system end in advance, obtains program for second system setting at second system end in advance, pre-sets share directory；Data to be shared are captured from the first system using the capture program；It will be under the data storage to the share directory to be shared of crawl using the capture program；The data to be shared are obtained under the share directory using the acquisition program；The data to be shared are output in the second system using the acquisition program.The present invention provides a kind of method and devices of data sharing, can improve the efficiency of data sharing.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of method and device of data sharing.
Background technology
With the fast development of information technology, more and more data processing systems are developed.In the same enterprise
Also there can be multiple data processing systems, due to manufacturer's difference of these systems etc., there are stern data between system
Barrier cannot achieve data sharing between each system.
In the prior art, the data sharing between different system is generally realized by artificial mode.For example,
Needing realization ERP, ((Enterprise Resource Planning, Enterprise Resources Plan) is between system A and ERP system B
Data sharing.Being obtained out from ERP system A by manual type needs data to be sharing, it would be desirable to which shared data are with artificial
Mode imported into ERP system B.
As can be seen from the above description, needing to complete the data between different system by artificial mode in the prior art
It is shared, it is less efficient.
Invention content
An embodiment of the present invention provides a kind of method and devices of data sharing, can improve the efficiency of data sharing.
On the one hand, an embodiment of the present invention provides a kind of methods of data sharing, including：
Capture program is set for the first system at the first system end in advance, in advance at second system end for described
Second system setting obtains program, pre-sets share directory；
Data to be shared are captured from the first system using the capture program；
It will be under the data storage to the share directory to be shared of crawl using the capture program；
The data to be shared are obtained under the share directory using the acquisition program；
The data to be shared are output in the second system using the acquisition program.
Further,
It utilizes the capture program before capturing data to be shared in the first system described, further comprises：
Excel tables are shared in setting, wherein the shared excel tables include at least one field to be captured；
It is described that data to be shared are captured from the first system using the capture program, including：
Using the capture program, at least one field to be captured is obtained from the shared Excel tables；
Using the capture program, each corresponding number of targets of the field to be captured is captured from the first system
According to；
Using the capture program, by the corresponding target data storage of each field to be captured to described shared
In Excel tables；
Wherein, the data to be shared include：Each corresponding target data of the field to be captured；
It is described to be stored the data to be shared of crawl under the share directory using the capture program, including：
It will be under the shared Excel tables storage to the share directory using the capture program；
It is described that the data to be shared are obtained under the share directory using the acquisition program, including：
The shared Excel tables are obtained under the share directory using the acquisition program；
It is described that the data to be shared are output in the second system using the acquisition program, including：
Go out the corresponding target of each field to be captured from the shared Excel form analysis using the acquisition program
Data；
It each of will be parsed described in the corresponding target data of field capture is output to using the acquisition program
In second system.
Further,
The capture program is utilized described, the corresponding target data of each field capture is stored to described total
After enjoying in Excel tables, further comprise：
It, will respectively to often the capable target data is encrypted in the shared Excel tables using the capture program
Corresponding target ciphertext of often going is saved in the shared Excel tables；
Using the capture program, to preserve the shared Excel tables of the corresponding target ciphertext of every row into
Row encryption, generates the encrypted shared Excel tables；
It is described to be stored the shared Excel tables under the share directory using the capture program, including：
It will be under the encrypted shared Excel tables storage to the share directory using the capture program；
It is described that the shared Excel tables are obtained under the share directory using the acquisition program, including：
The encrypted shared Excel tables are obtained under the share directory using the acquisition program；
It is described using the acquisitions program from the shared Excel form analysis go out it is each described in field to be captured it is corresponding
Target data, including：
The encrypted shared Excel tables are decrypted using the acquisition program；
Each of shared Excel tables after the decryption target ciphertext is solved using the acquisition program
It is close, generate each corresponding target data of the field to be captured.
Further,
It is described to utilize the capture program, each corresponding target of the field to be captured is captured from the first system
Data, including：
Using the capture program, Java timed tasks are established, by the Java timed tasks periodically from described
Each corresponding target data of the field to be captured is captured in the first system；
It is described to utilize the capture program, the corresponding target data storage of each field capture is shared to described
In Excel tables, including：
Using the capture program, by the target data storage of current period crawl to the shared Excel tables
In；
It is described to be stored the shared Excel tables under the share directory using the capture program, including：
Using the capture program, the shared Excel tables storage that the current period generates is shared to described
Under catalogue.
Further,
This method further comprises：
Pre-set backup directory；
After the utilization acquisition program obtains the data to be shared under the share directory, further wrap
It includes：
Using the acquisition program by the data to be shared under the share directory down cut to the backup directory.
On the other hand, an embodiment of the present invention provides a kind of devices of data sharing, including：
It is directed to the handling module of the first system at the first system end；
It is directed to the acquisition module of the second system at second system end；
Preserving module, for preserving share directory；
The handling module, for capturing data to be shared from the first system, by the number to be shared of crawl
According under storage to the share directory；
The acquisition module, for obtaining the data to be shared under the share directory, by the data to be shared
It is output in the second system.
Further,
The preserving module is further used for preserving shared Excel tables, wherein the shared excel tables include
At least one field to be captured；
The handling module, for obtaining at least one field to be captured from the shared Excel tables, from institute
It states and captures the corresponding target data of the field to be captured in the first system, by the corresponding mesh of each field to be captured
It marks in data storage to the shared Excel tables, it will be under the shared Excel tables storage to the share directory, wherein
The data to be shared include：Each corresponding target data of the field to be captured；
The acquisition module is shared for obtaining the shared Excel tables under the share directory from described
Excel form analysis goes out the corresponding target data of each field capture, each of will parse described in field to be captured
Corresponding target data is output in the second system.
Further,
The handling module is further used for arriving the corresponding target data storage of each field to be captured described
It, will respectively to often the capable target data is encrypted in the shared Excel tables after in the shared Excel tables
Corresponding target ciphertext of often going is saved in the shared Excel tables, to preserving the corresponding target ciphertext of every row
The shared Excel tables are encrypted, and generate the encrypted shared Excel tables；
The handling module, for storing the encrypted shared Excel tables under the share directory；
The acquisition module, for obtaining the encrypted shared Excel tables under the share directory, to encryption
The shared Excel tables afterwards are decrypted, to each of shared Excel tables after the decryption target ciphertext
It is decrypted, generates each corresponding target data of the field to be captured.
Further,
The handling module, for establishing Java timed tasks, by the Java timed tasks periodically from described
Each corresponding target data of the field to be captured is captured in the first system, and the target data that current period captures is deposited
It stores up in the shared Excel tables, the shared Excel tables storage that the current period is generated to the shared mesh
Under record.
Further,
The preserving module is further used for preserving backup directory；
The acquisition module, be further used for being obtained under the share directory using the acquisition program described described in
After data to be shared, by the data to be shared under the share directory down cut to the backup directory.
In embodiments of the present invention, it is provided with capture program and obtains program, by capture program automatically from the first system
Middle crawl data to be shared, and store into share directory, by obtaining program ground shared data is obtained from sharing module automatically
And be output in second system, the data sharing between the first system and second system is realized, which participates in without artificial,
It can be automatically performed, improve the efficiency of data sharing.
Description of the drawings
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is the present invention
Some embodiments for those of ordinary skill in the art without creative efforts, can also basis
These attached drawings obtain other attached drawings.
Fig. 1 is a kind of flow chart of the method for data sharing that one embodiment of the invention provides；
Fig. 2 is the flow chart of the method for another data sharing that one embodiment of the invention provides；
Fig. 3 is a kind of schematic diagram of the device for data sharing that one embodiment of the invention provides；
Fig. 4 is the schematic diagram of the device for another data sharing that one embodiment of the invention provides.
Specific implementation mode
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments, based on the embodiments of the present invention, those of ordinary skill in the art
The every other embodiment obtained without making creative work, shall fall within the protection scope of the present invention.
As shown in Figure 1, an embodiment of the present invention provides a kind of method of data sharing, this method may include following step
Suddenly：
Step 101：Capture program is set for the first system at the first system end in advance, in advance at second system end
It is arranged for the second system and obtains program, pre-sets share directory；
Step 102：Data to be shared are captured from the first system using the capture program；
Step 103：It will be under the data storage to the share directory to be shared of crawl using the capture program；
Step 104：The data to be shared are obtained under the share directory using the acquisition program；
Step 105：The data to be shared are output in the second system using the acquisition program.
In embodiments of the present invention, it is provided with capture program and obtains program, by capture program automatically from the first system
Middle crawl data to be shared, and store into share directory, by obtaining program ground shared data is obtained from sharing module automatically
And be output in second system, the data sharing between the first system and second system is realized, which participates in without artificial,
It can be automatically performed, improve the efficiency of data sharing.
In an embodiment of the present invention, number to be shared is captured from the first system using the capture program described
According to before, further comprise：
Excel tables are shared in setting, wherein the shared excel tables include at least one field to be captured；
It is described that data to be shared are captured from the first system using the capture program, including：
Using the capture program, at least one field to be captured is obtained from the shared Excel tables；
Using the capture program, each corresponding number of targets of the field to be captured is captured from the first system
According to；
Using the capture program, by the corresponding target data storage of each field to be captured to described shared
In Excel tables；
Wherein, the data to be shared include：Each corresponding target data of the field to be captured；
It is described to be stored the data to be shared of crawl under the share directory using the capture program, including：
It will be under the shared Excel tables storage to the share directory using the capture program；
It is described that the data to be shared are obtained under the share directory using the acquisition program, including：
The shared Excel tables are obtained under the share directory using the acquisition program；
It is described that the data to be shared are output in the second system using the acquisition program, including：
Go out the corresponding target of each field to be captured from the shared Excel form analysis using the acquisition program
Data；
It each of will be parsed described in the corresponding target data of field capture is output to using the acquisition program
In second system.
In embodiments of the present invention, it is used as carrier by the way of Excel tables, is waited for altogether by Excel tables to carry
Data are enjoyed, without technical details such as Store form, data structure, the type of database of being concerned about data to be shared, are adapted to each
The docking of class business is handled.
Specifically, capture program can will field be captured as keyword, field to be captured is searched for from the first system
Corresponding target data.Capture program is when thinking that shared Excel tables store target data, by taking any field to be captured as an example,
It will be in the corresponding target data storage to the row corresponding to currently field to be captured of currently field to be captured.
In an embodiment of the present invention, described using the capture program, each field to be captured is corresponding
After in target data storage to the shared Excel tables, further comprise：
It, will respectively to often the capable target data is encrypted in the shared Excel tables using the capture program
Corresponding target ciphertext of often going is saved in the shared Excel tables；
Using the capture program, to preserve the shared Excel tables of the corresponding target ciphertext of every row into
Row encryption, generates the encrypted shared Excel tables；
It is described to be stored the shared Excel tables under the share directory using the capture program, including：
It will be under the encrypted shared Excel tables storage to the share directory using the capture program；
It is described that the shared Excel tables are obtained under the share directory using the acquisition program, including：
The encrypted shared Excel tables are obtained under the share directory using the acquisition program；
It is described using the acquisitions program from the shared Excel form analysis go out it is each described in field to be captured it is corresponding
Target data, including：
The encrypted shared Excel tables are decrypted using the acquisition program；
Each of shared Excel tables after the decryption target ciphertext is solved using the acquisition program
It is close, generate each corresponding target data of the field to be captured.
In embodiments of the present invention, it in order to ensure the safety of data to be shared, needs to carry out the data to be shared of crawl
Encryption.Further, in order to increase safety can after every row target data is encrypted, then to entirely share Excel
Table is encrypted.
Specifically, every row target data can be encrypted by SHA (Secure Hash Algorithm), generates check code, deposits
It is placed on the specified row of every row.For example, the target data of line n is encrypted, generates check code, which is stored
In the specified row (such as last row) of line n.Obtaining program can be decrypted according to the decompression algorithm of agreement.
Specifically, it can be encrypted by DES (symmetric encipherment algorithm) algorithms to entirely sharing Excel tables.It obtains
Program can be decrypted according to the decompression algorithm of agreement.
In addition, after to entirely shared Excel tables are encrypted, encrypted Excel tables can be compressed,
Compressed package is generated, and password is arranged to compressed package.The compressed package can be solved according to the decompression password of agreement by obtaining program
It is close.
In an embodiment of the present invention, described to utilize the capture program, it is captured from the first system each described
The corresponding target data of field to be captured, including：
Using the capture program, Java timed tasks are established, by the Java timed tasks periodically from described
Each corresponding target data of the field to be captured is captured in the first system；
It is described to utilize the capture program, the corresponding target data storage of each field capture is shared to described
In Excel tables, including：
Using the capture program, by the target data storage of current period crawl to the shared Excel tables
In；
It is described to be stored the shared Excel tables under the share directory using the capture program, including：
Using the capture program, the shared Excel tables storage that the current period generates is shared to described
Under catalogue.
In embodiments of the present invention, the process of entire data sharing can be periodically.Capture program is fixed according to Java
When task, periodically capture data to be shared from the first system, and obtain program and can be detected according to some cycles and share mesh
In record whether the data to be shared of acquisition in need, if there is then obtaining data to be shared.
In an embodiment of the present invention, this method further comprises：
Pre-set backup directory；
After the utilization acquisition program obtains the data to be shared under the share directory, further wrap
It includes：
Using the acquisition program by the data to be shared under the share directory down cut to the backup directory.
In embodiments of the present invention, obtaining program can be by the data to be shared obtained from share directory down cut
To under backup directory, in this way, it is possible to reduce the data volume under share directory so that be more convenient next time to obtain newly from share directory
Data to be shared can also treat shared data and be backed up, ensure the safety of data to be shared.
As shown in Fig. 2, an embodiment of the present invention provides a kind of method of data sharing, this method may include following step
Suddenly：
Step 201：Capture program is set for the first system at the first system end in advance, is directed in advance at second system end
Second system setting obtains program, pre-sets share directory and backup directory, is arranged and shares Excel tables, wherein shared
Excel tables include at least one field to be captured.
Specifically, which can be located at the FTP (File of the LAN where the first system and second system
Transfer Protocol, File Transfer Protocol) on server.
Specifically, when capture program is arranged, the crawl permission for the first system is assigned for capture program.It is obtained in setting
When program fetch, the permission to second system output data is assigned to obtain program.
For example, the first system and second system are ERP systems.Have for example：The first system is to store up library dot system,
Second system is local grain depot management system.
Step 202：Using capture program, at least one field to be captured is obtained from shared Excel tables.
For example, it is as shown in table 1 to share Excel tables.Wherein, field to be captured is stored in this one kind of row name.Show
The format that the corresponding target data of each field to be captured is stored in shared Excel tables is defined in example.
Table 1
Step 203：Using capture program, the corresponding target data of each field to be captured is captured from the first system.
Step 204：Using capture program, by the corresponding target data storage of each field to be captured to shared Excel tables
In lattice.
For example, in table 1, a row is also set up and are used for storing the corresponding target data of each field to be captured.Such as：
A field to be captured is document action type in table 1, and the corresponding target data of document action type is stored in document operation class
In row where type.
Step 205：Using capture program, respectively to often row target data is encrypted in shared Excel tables, will often go
Corresponding target ciphertext is saved in shared Excel tables.
For example, the corresponding target data of document action type is encrypted, generates document ciphertext, it can be by document
Ciphertext is saved in the row where document action type in shared Excel tables.
Step 206：Using capture program, the shared Excel tables to preserving the corresponding target ciphertext of every row add
It is close, generate encrypted shared Excel tables.
Specifically, entire table is encrypted.
Step 207：It will be under encrypted shared Excel tables storage to share directory using capture program.
Step 208：Encrypted shared Excel tables are obtained under share directory using program is obtained.
Step 209：Using obtain program by encrypted shared Excel tables from share directory down cut to backup directory
In.
Step 210：Encrypted shared Excel tables are decrypted using program is obtained.
Specifically, obtaining program can be decrypted according to the key made an appointment.
Specifically, it is decrypted first to entirely sharing Excel tables.
Step 211：Each target ciphertext in the shared Excel tables after decryption is decrypted using program is obtained,
Generate the corresponding target data of each field to be captured.
Specifically, obtaining program can be decrypted according to the key made an appointment.
Step 212：It is output to second using obtaining program and each of parsing the corresponding target data of field to be captured
In system.
Specifically, after being output in second system, second system can be shown, analyze to these target datas etc.
Reason.
Above-mentioned capture program and acquisition program can be run based on Java timed tasks.Java timed tasks can lead to
Java timers are crossed to realize.
In embodiments of the present invention, the read-write operation of data sharing carries out on backstage, eliminates previous two method, system two
The typing of secondary instruction and the process of data exporting, realize interconnecting between different system, business datum it is shared,
Reduce the overlapping investment and waste of resource while improving working efficiency.It treats shared data to be encrypted, fully ensure
The safety of data to be shared.
Furthermore it is possible to be directed to abnormal conditions, additional exception handling ensure that the accuracy of data transmission and complete
Property.
A kind of method of data sharing provided in an embodiment of the present invention can be realized by following code：
As shown in Figure 3, Figure 4, an embodiment of the present invention provides a kind of devices of data sharing.Device embodiment can pass through
Software realization can also be realized by way of hardware or software and hardware combining.For hardware view, as shown in figure 3, for this
A kind of hardware structure diagram of equipment where a kind of device for data sharing that inventive embodiments provide, in addition to processing shown in Fig. 3
Except device, memory, network interface and nonvolatile memory, the equipment in embodiment where device usually can also include
Other hardware, such as it is responsible for the forwarding chip of processing message.For implemented in software, as shown in figure 4, anticipating as a logic
Device in justice is to be read corresponding computer program instructions in nonvolatile memory by the CPU of equipment where it
Operation is formed in memory.A kind of device of data sharing provided in this embodiment, including：
It is directed to the handling module 401 of the first system at the first system end；
It is directed to the acquisition module 402 of the second system at second system end；
Preserving module 403, for preserving share directory；
The handling module 401, for capturing data to be shared from the first system, by the described to be shared of crawl
Under data storage to the share directory；
The acquisition module 402, for obtaining the data to be shared under the share directory, by the number to be shared
According to being output in the second system.
In an embodiment of the present invention, the preserving module is further used for preserving shared Excel tables, wherein described
Shared excel tables include at least one field to be captured；
The handling module, for obtaining at least one field to be captured from the shared Excel tables, from institute
It states and captures the corresponding target data of the field to be captured in the first system, by the corresponding mesh of each field to be captured
It marks in data storage to the shared Excel tables, it will be under the shared Excel tables storage to the share directory, wherein
The data to be shared include：Each corresponding target data of the field to be captured；
The acquisition module is shared for obtaining the shared Excel tables under the share directory from described
Excel form analysis goes out the corresponding target data of each field capture, each of will parse described in field to be captured
Corresponding target data is output in the second system.
In an embodiment of the present invention, the handling module is further used for each field to be captured described
After in the storage to the shared Excel tables of corresponding target data, respectively to described in often going in the shared Excel tables
Target data is encrypted, and the corresponding target ciphertext that will often go is saved in the shared Excel tables, to preserving every row pair
The shared Excel tables for the target ciphertext answered are encrypted, and generate the encrypted shared Excel tables；
The handling module, for storing the encrypted shared Excel tables under the share directory；
The acquisition module, for obtaining the encrypted shared Excel tables under the share directory, to encryption
The shared Excel tables afterwards are decrypted, to each of shared Excel tables after the decryption target ciphertext
It is decrypted, generates each corresponding target data of the field to be captured.
In an embodiment of the present invention, the handling module passes through Java timings for establishing Java timed tasks
Each corresponding target data of the field to be captured is captured to duty cycle from the first system, and current period is grabbed
The target data taken is stored into the shared Excel tables, the shared Excel tables that the current period is generated
Under lattice storage to the share directory.
In an embodiment of the present invention, the preserving module is further used for preserving backup directory；
The acquisition module, be further used for being obtained under the share directory using the acquisition program described described in
After data to be shared, by the data to be shared under the share directory down cut to the backup directory.
The contents such as the information exchange between each unit, implementation procedure in above-mentioned apparatus, due to implementing with the method for the present invention
Example is based on same design, and particular content can be found in the narration in the method for the present invention embodiment, and details are not described herein again.
An embodiment of the present invention provides a kind of readable mediums, including execute instruction, when the processor of storage control executes
The method that when executing instruction, the storage control executes any one data sharing provided in an embodiment of the present invention.
An embodiment of the present invention provides a kind of storage controls, including：Processor, memory and bus；
The memory is executed instruction for storing, and the processor is connect with the memory by the bus, when
When the storage control operation, the processor executes executing instruction for the memory storage, so that the storage controls
The method that device executes any one data sharing provided in an embodiment of the present invention.
The each embodiment of the present invention at least has the advantages that：
1, in embodiments of the present invention, it is provided with capture program and obtains program, by capture program automatically from the first system
Data to be shared are captured in system, and are stored into share directory, share number with obtaining from sharing module automatically by obtaining program
According to and be output in second system, realize the data sharing between the first system and second system, the process is without artificial ginseng
With can be automatically performed, improve the efficiency of data sharing.
2, in embodiments of the present invention, it is used as carrier by the way of Excel tables, is waited for by Excel tables to carry
Shared data is adapted to without technical details such as Store form, data structure, the type of database of being concerned about data to be shared
The docking of all kinds of business is handled.
3, in embodiments of the present invention, obtaining program can cut the data to be shared obtained under share directory
It switches under backup directory, in this way, it is possible to reduce the data volume under share directory so that next time is more convenient new from share directory acquisition
Data to be shared, shared data can also be treated and backed up, ensure the safety of data to be shared.
4, in embodiments of the present invention, the read-write operation of data sharing carries out on backstage, eliminates previous two method, system
The process of the typing and data exporting that instruct twice, realize interconnecting between different system, business datum it is shared,
Reduce the overlapping investment and waste of resource while improving working efficiency.It treats shared data to be encrypted, fully ensure
The safeties of data to be shared.
It should be noted that herein, such as first and second etc relational terms are used merely to an entity
Or operation is distinguished with another entity or operation, is existed without necessarily requiring or implying between these entities or operation
Any actual relationship or order.Moreover, the terms "include", "comprise" or its any other variant be intended to it is non-
It is exclusive to include, so that the process, method, article or equipment including a series of elements includes not only those elements,
But also include other elements that are not explicitly listed, or further include solid by this process, method, article or equipment
Some elements.In the absence of more restrictions, the element limited by sentence " including a 〃 〃 ", it is not excluded that
There is also other identical factors in the process, method, article or apparatus that includes the element.
One of ordinary skill in the art will appreciate that：Realize that all or part of step of above method embodiment can pass through
The relevant hardware of program instruction is completed, and program above-mentioned can be stored in computer-readable storage medium, the program
When being executed, step including the steps of the foregoing method embodiments is executed；And storage medium above-mentioned includes：ROM, RAM, magnetic disc or light
In the various media that can store program code such as disk.
Finally, it should be noted that：The foregoing is merely presently preferred embodiments of the present invention, 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 all within the spirits and principles of the present invention,
Equivalent replacement, improvement etc., are included within the scope of protection of the present invention.
Claims (10)
1. a kind of method of data sharing, which is characterized in that
Capture program is set for the first system at the first system end in advance, is directed to described second at second system end in advance
System setting obtains program, pre-sets share directory；
Including：
Data to be shared are captured from the first system using the capture program；
It will be under the data storage to the share directory to be shared of crawl using the capture program；
The data to be shared are obtained under the share directory using the acquisition program；
The data to be shared are output in the second system using the acquisition program.
2. according to the method described in claim 1, it is characterized in that,
It utilizes the capture program before capturing data to be shared in the first system described, further comprises：
Excel tables are shared in setting, wherein the shared excel tables include at least one field to be captured；
It is described that data to be shared are captured from the first system using the capture program, including：
Using the capture program, at least one field to be captured is obtained from the shared Excel tables；
Using the capture program, each corresponding target data of the field to be captured is captured from the first system；
Using the capture program, by the corresponding target data storage of each field to be captured to the shared Excel tables
In lattice；
Wherein, the data to be shared include：Each corresponding target data of the field to be captured；
It is described to be stored the data to be shared of crawl under the share directory using the capture program, including：
It will be under the shared Excel tables storage to the share directory using the capture program；
It is described that the data to be shared are obtained under the share directory using the acquisition program, including：
The shared Excel tables are obtained under the share directory using the acquisition program；
It is described that the data to be shared are output in the second system using the acquisition program, including：
Go out the corresponding number of targets of each field to be captured from the shared Excel form analysis using the acquisition program
According to；
The corresponding target data of the field to be captured, which each of will be parsed, using the acquisition program is output to described second
In system.
3. according to the method described in claim 2, it is characterized in that,
The capture program is utilized described, the corresponding target data storage of each field capture is shared to described
After in Excel tables, further comprise：
Using the capture program, respectively to often the capable target data is encrypted in the shared Excel tables, will often go
Corresponding target ciphertext is saved in the shared Excel tables；
Using the capture program, the shared Excel tables to preserving the corresponding target ciphertext of every row add
It is close, generate the encrypted shared Excel tables；
It is described to be stored the shared Excel tables under the share directory using the capture program, including：
It will be under the encrypted shared Excel tables storage to the share directory using the capture program；
It is described that the shared Excel tables are obtained under the share directory using the acquisition program, including：
The encrypted shared Excel tables are obtained under the share directory using the acquisition program；
It is described using the acquisitions program from the shared Excel form analysis go out it is each described in the corresponding target of field to be captured
Data, including：
The encrypted shared Excel tables are decrypted using the acquisition program；
Each of shared Excel tables after the decryption target ciphertext is decrypted using the acquisition program,
Generate each corresponding target data of the field to be captured.
4. according to the method described in claim 2, it is characterized in that,
It is described to utilize the capture program, each corresponding number of targets of the field to be captured is captured from the first system
According to, including：
Using the capture program, Java timed tasks are established, by the Java timed tasks periodically from described first
Each corresponding target data of the field to be captured is captured in system；
It is described to utilize the capture program, the corresponding target data storage of each field capture is shared to described
In Excel tables, including：
It, will be in the target data storage to the shared Excel tables of current period crawl using the capture program；
It is described to be stored the shared Excel tables under the share directory using the capture program, including：
Utilize the capture program, the shared Excel tables storage that the current period is generated to the share directory
Under.
5. method according to any one of claims 1-4, which is characterized in that
Further comprise：
Pre-set backup directory；
After the utilization acquisition program obtains the data to be shared under the share directory, further comprise：
Using the acquisition program by the data to be shared under the share directory down cut to the backup directory.
6. a kind of device of data sharing, which is characterized in that including：
It is directed to the handling module of the first system at the first system end；
It is directed to the acquisition module of the second system at second system end；
Preserving module, for preserving share directory；
The handling module deposits the data to be shared of crawl for capturing data to be shared from the first system
It stores up under the share directory；
The acquisition module exports the data to be shared for obtaining the data to be shared under the share directory
Into the second system.
7. device according to claim 6, which is characterized in that
The preserving module is further used for preserving shared Excel tables, wherein the shared excel tables include at least
One field to be captured；
The handling module, for obtaining at least one field to be captured from the shared Excel tables, from described
The corresponding target data of the field to be captured is captured in one system, by the corresponding number of targets of each field to be captured
According in storage to the shared Excel tables, the shared Excel tables are stored under the share directory, wherein described
Data to be shared include：Each corresponding target data of the field to be captured；
The acquisition module, for obtaining the shared Excel tables under the share directory, from the shared Excel tables
Lattice parse the corresponding target data of each field capture, each of will parse described in the corresponding mesh of field to be captured
Mark data are output in the second system.
8. device according to claim 7, which is characterized in that
The handling module is further used for the corresponding target data storage of each field to be captured described to described
After in shared Excel tables, respectively to often the capable target data is encrypted in the shared Excel tables, will often it go
Corresponding target ciphertext is saved in the shared Excel tables, to preserving described in the corresponding target ciphertext of every row
Shared Excel tables are encrypted, and generate the encrypted shared Excel tables；
The handling module, for storing the encrypted shared Excel tables under the share directory；
The acquisition module, for obtaining the encrypted shared Excel tables under the share directory, to encrypted
The shared Excel tables are decrypted, and are carried out to each of shared Excel tables after the decryption target ciphertext
Decryption generates each corresponding target data of the field to be captured.
9. device according to claim 7, which is characterized in that
The handling module, for establishing Java timed tasks, by the Java timed tasks periodically from described first
Each corresponding target data of the field to be captured is captured in system, and the target data storage that current period captures is arrived
In the shared Excel tables, the shared Excel tables that the current period generates are stored to the share directory
Under.
10. according to any device in claim 6-9, which is characterized in that
The preserving module is further used for preserving backup directory；
The acquisition module, be further used for it is described using the acquisitions program obtained under the share directory described in wait be total to
After enjoying data, by the data to be shared under the share directory down cut to the backup directory.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711427978.6A CN108304461A (en) | 2017-12-26 | 2017-12-26 | A kind of method and device of data sharing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711427978.6A CN108304461A (en) | 2017-12-26 | 2017-12-26 | A kind of method and device of data sharing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108304461A true CN108304461A (en) | 2018-07-20 |
Family
ID=62870687
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711427978.6A Pending CN108304461A (en) | 2017-12-26 | 2017-12-26 | A kind of method and device of data sharing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108304461A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103780685A (en) * | 2014-01-10 | 2014-05-07 | 清华大学 | Method for adaptive data sharing among diversified intelligent equipment |
| CN105589881A (en) * | 2014-10-23 | 2016-05-18 | 大唐软件技术股份有限公司 | Data processing method and device |
| US20160203135A1 (en) * | 2015-01-12 | 2016-07-14 | International Business Machines Corporation | In-memory latch-free index structure |
| CN106354670A (en) * | 2015-07-16 | 2017-01-25 | 阿里巴巴集团控股有限公司 | Method and apparatus for transmitting data in virtual environment |
| CN106874128A (en) * | 2017-01-22 | 2017-06-20 | 广州华多网络科技有限公司 | Data transmission method and device |
| CN107203433A (en) * | 2017-06-13 | 2017-09-26 | 微梦创科网络科技（中国）有限公司 | The multiple inter-program data synchronous method and device of a kind of shared drive |
-
2017
- 2017-12-26 CN CN201711427978.6A patent/CN108304461A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103780685A (en) * | 2014-01-10 | 2014-05-07 | 清华大学 | Method for adaptive data sharing among diversified intelligent equipment |
| CN105589881A (en) * | 2014-10-23 | 2016-05-18 | 大唐软件技术股份有限公司 | Data processing method and device |
| US20160203135A1 (en) * | 2015-01-12 | 2016-07-14 | International Business Machines Corporation | In-memory latch-free index structure |
| CN106354670A (en) * | 2015-07-16 | 2017-01-25 | 阿里巴巴集团控股有限公司 | Method and apparatus for transmitting data in virtual environment |
| CN106874128A (en) * | 2017-01-22 | 2017-06-20 | 广州华多网络科技有限公司 | Data transmission method and device |
| CN107203433A (en) * | 2017-06-13 | 2017-09-26 | 微梦创科网络科技（中国）有限公司 | The multiple inter-program data synchronous method and device of a kind of shared drive |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10824729B2 (en) | Compliance management in a local network | |
| US10917417B2 (en) | Method, apparatus, server, and storage medium for network security joint defense | |
| US11777981B1 (en) | Risk scoring based on compliance verification test results in a local network | |
| CN110224808B (en) | Bank data sharing method and device based on block chain, computer equipment and storage medium | |
| US20100223446A1 (en) | Contextual tracing | |
| CN109064345A (en) | Message treatment method, system and computer readable storage medium | |
| CN107977473B (en) | Logback-based distributed system log retrieval method and system | |
| CN101477386B (en) | Timer implementing method and apparatus | |
| Xia et al. | Performance and availability modeling of ITSystems with data backup and restore | |
| CN110704438B (en) | Method and device for generating bloom filter in blockchain | |
| CN109189749A (en) | File synchronisation method and terminal device | |
| CN113542263B (en) | Firewall policy migration method and device | |
| GB2523761A (en) | Generation of analysis reports using trusted and public distributed file systems | |
| CN109246088A (en) | A kind of big data security system based on financial service management | |
| CN103618762A (en) | System and method for enterprise service bus state pretreatment based on AOP | |
| CN103235811A (en) | Data storage method and device | |
| CN105069029B (en) | A kind of real-time ETL system and method | |
| CN109165210A (en) | A kind of method and device of cluster Hbase Data Migration | |
| CN108399175B (en) | Data storage and query method and device | |
| CN106126419A (en) | The adjustment method of a kind of application program and device | |
| US11231958B2 (en) | Method and control system for controlling and/or monitoring devices | |
| CN105446812A (en) | Multitask scheduling configuration method | |
| CN108664322A (en) | Data processing method and system | |
| CN108304461A (en) | A kind of method and device of data sharing | |
| CN107784093A (en) | A kind of distributed big data processing system |
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: 20180720 |