CN107798120A - A kind of data transfer device and device - Google Patents
A kind of data transfer device and device Download PDFInfo
- Publication number
- CN107798120A CN107798120A CN201711103217.5A CN201711103217A CN107798120A CN 107798120 A CN107798120 A CN 107798120A CN 201711103217 A CN201711103217 A CN 201711103217A CN 107798120 A CN107798120 A CN 107798120A
- Authority
- CN
- China
- Prior art keywords
- configuration parameter
- parameter
- file
- change
- data
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The invention provides a kind of data transfer device and device, is related to banking system technical field of data processing.Method includes：The table change configuration parameter of user's input is obtained, and configuration parameter generation Parameter File is changed according to the table；The Parameter File includes table change configuration parameter, and the table change configuration parameter includes respectively treating change project；According to the Parameter File, the pending job stream sequence of change project is respectively treated in generation；According to the order pre-set, the pending job stream sequence has been adjusted, the data in database table are changed to target data corresponding to table change configuration parameter.So, in data conversion, operation maintenance personnel input table is only needed to change configuration parameter, and then automatically complete data conversion, a set of new job stream is all developed again without each data conversion, avoid operation maintenance personnel and establish substantial amounts of job stream, and each flow needs operation maintenance personnel to submit operation manually, process is relatively complicated and the problem of easily error.
Description
Technical field
The present invention relates to banking system technical field of data processing, more particularly to a kind of data transfer device and device.
Background technology
In banking system technical field of data processing, data conversion refers to that system is to existing table to meet business demand
When structure or data on stock content are changed, data on stock is carried out in form or content certain and changed to adapt to new industry
A kind of data processing method of business demand.It is the business and technical need for realizing banking system that data conversion, which is mainly,.Industry first
Business aspect, data conversion relate generally to the change of business datum value and increasing newly for type of service.And the change of data value is mainly
Data area is changed, such as after Hong Kong, Macao and Taiwan client progressively increases, the value scope of original client certificate type can be expanded,
By increasing Hong Kong, Macao, Taiwan gulf resident on the basis of original resident identification card come the pass inside, to carry out follow-up maintenance
And statistics.And the newly-increased of type of service mainly increases field newly to original tables of data, such as to the newly-increased association card of the main table of client
Information field, in the case of legacy data table reserved field deficiency, field need to be increased newly to the main table of client to store association card letter
Breath.It is then to realize the optimization of data space and aspect of performance in terms of technical need, dilatation is carried out to table subregion.
Currently, the data transfer method of prior art is mainly realized by writing job stream, that is, is comprised the following steps：
1., by legacy data table data be stored in file；2., handle file data according to demand；3., delete legacy data table, establish new data
Table；4., by after processing file data deposit new data table in.Because the business datum amount and the number of partitions of tables of data respectively have not
Together, therefore data conversion is required for developing a set of new job stream again every time.Due to the data volume of tables of data in banking system
Huge and each flow needs operation maintenance personnel to submit operation manually, it is necessary to operation maintenance personnel establishes substantial amounts of job stream, and process is more numerous
Trivial and easy error.
The content of the invention
Embodiments of the invention provide a kind of data transfer device and device, to solve tables of data in current bank system
Data volume is huge, it is necessary to which operation maintenance personnel establishes substantial amounts of job stream, and each flow needs operation maintenance personnel to submit operation, process manually
It is relatively complicated and the problem of easily malfunction.
To reach above-mentioned purpose, the present invention adopts the following technical scheme that：
A kind of data transfer device, including：
The table change configuration parameter of user's input is obtained, and configuration parameter generation Parameter File is changed according to the table；Institute
Stating Parameter File includes table change configuration parameter, and the table change configuration parameter includes respectively treating change project；
According to the Parameter File, the pending job stream sequence of change project is respectively treated in generation；
According to the order pre-set, the pending job stream sequence is adjusted, the data in database table have been changed to
Target data corresponding to table change configuration parameter.
Specifically, respectively treat that change project includes in the table change configuration parameter：Whether database table name, table structure become
More item, build table statement filename, whether subregion item, partitioned mode, whether parallel item, parallel mode configuration filename, degree of parallelism,
Whether program processing item, program name are needed.
Further, configuration parameter is changed in the table for obtaining user's input, and configuration parameter generation is changed according to the table
After Parameter File, methods described also includes：
Parameter verification strategy according to pre-setting determines the accuracy of the table change configuration parameter in Parameter File；
When the table changes configuration parameter inaccuracy, generation, which reports an error, indicates message.
Specifically, described according to the Parameter File, the pending job stream sequence of change project is respectively treated in generation, including：
According to the Parameter File, generate the UNLOAD job streams that change project is treated for handling, file process job stream,
SPUFI workings and LOAD job streams.
Specifically, the order that the basis is pre-set, has adjusted the pending job stream sequence, by database table
Data are changed to target data corresponding to table change configuration parameter, including：
Adjust successively and performed UNLOAD job stream file process job stream, SPUFI workings and LOAD job streams, with
Data in database table are changed to target data corresponding to table change configuration parameter.
A kind of data conversion device, including：
Parameter File generation unit, the table for obtaining user's input changes configuration parameter, and is matched somebody with somebody according to table change
Put parameter generation Parameter File；The Parameter File includes table change configuration parameter, and the table change configuration parameter includes
Respectively treat change project；
Pending job stream sequence generating unit, for according to the Parameter File, generation respectively treats that change project is waited to hold
Row job stream sequence；
Date Conversion Unit, for according to the order pre-set, the pending job stream sequence having been adjusted, by database
Data in table are changed to target data corresponding to table change configuration parameter.
Specifically, the table in the Parameter File generation unit changes in configuration parameter and respectively treats that change project includes：Number
According to storehouse table name, table structure whether change item, build table statement filename, whether subregion item, partitioned mode, whether parallel item, parallel
Mode configuration filename, degree of parallelism, whether need program processing item, program name.
In addition, described device also includes parameter verification unit, it is used for：
Parameter verification strategy according to pre-setting determines the accuracy of the table change configuration parameter in Parameter File；
When the table changes configuration parameter inaccuracy, generation, which reports an error, indicates message.
In addition, the pending job stream sequence generating unit, is specifically used for：
According to the Parameter File, generate the UNLOAD job streams that change project is treated for handling, file process job stream,
SPUFI workings and LOAD job streams.
In addition, the Date Conversion Unit, is specifically used for：
Adjust successively and performed UNLOAD job stream file process job stream, SPUFI workings and LOAD job streams, with
Data in database table are changed to target data corresponding to table change configuration parameter.
A kind of computer-readable recording medium, is stored thereon with computer program, and the program is realized when being executed by processor
Following steps：
The table change configuration parameter of user's input is obtained, and configuration parameter generation Parameter File is changed according to the table；Institute
Stating Parameter File includes table change configuration parameter, and the table change configuration parameter includes respectively treating change project；
According to the Parameter File, the pending job stream sequence of change project is respectively treated in generation；
According to the order pre-set, the pending job stream sequence is adjusted, the data in database table have been changed to
Target data corresponding to table change configuration parameter.
A kind of computer equipment, including memory, processor and the meter that is stored in storage above and can run on a processor
Calculation machine program, following steps are realized during the computing device described program：
The table change configuration parameter of user's input is obtained, and configuration parameter generation Parameter File is changed according to the table；Institute
Stating Parameter File includes table change configuration parameter, and the table change configuration parameter includes respectively treating change project；
According to the Parameter File, the pending job stream sequence of change project is respectively treated in generation；
According to the order pre-set, the pending job stream sequence is adjusted, the data in database table have been changed to
Target data corresponding to table change configuration parameter.
A kind of data transfer device and device provided in an embodiment of the present invention, the table change configuration of user's input is obtained first
Parameter, and configuration parameter generation Parameter File is changed according to the table；The Parameter File includes table change configuration parameter,
The table change configuration parameter includes respectively treating change project；Afterwards, treating for change project is respectively treated according to the Parameter File, generation
Perform job stream sequence；So that according to the order pre-set, the pending job stream sequence has been adjusted, by database table
Data are changed to target data corresponding to table change configuration parameter.So, during data conversion, it is only necessary to operation maintenance personnel (i.e. user)
Table change configuration parameter is inputted, so as to automatically complete data conversion, is all developed again without each data conversion a set of
New job stream, the data volume for avoiding tables of data in current bank system are huge, it is necessary to which operation maintenance personnel establishes substantial amounts of operation
Stream, and each flow needs operation maintenance personnel to submit operation manually, and process is relatively complicated and the problem of easily error.
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 only this
Some embodiments of invention, for those of ordinary skill in the art, without having to pay creative labor, may be used also
To obtain other accompanying drawings according to these accompanying drawings.
Fig. 1 is a kind of flow chart one of data transfer device provided in an embodiment of the present invention；
Fig. 2 is a kind of flowchart 2 of data transfer device provided in an embodiment of the present invention；
Fig. 3 is a kind of structural representation of data conversion device provided in an embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other under the premise of creative work is not made
Embodiment, belong to the scope of protection of the invention.
As shown in figure 1, the embodiment of the present invention provides a kind of data transfer device, including：
Step 101, the table change configuration parameter for obtaining user's input, and configuration parameter generation parameter is changed according to the table
File.
Wherein, the Parameter File includes table change configuration parameter, and the table change configuration parameter includes respectively waiting to become
More project.
Step 102, according to the Parameter File, the pending job stream sequence of change project is respectively treated in generation.
The order that step 103, basis are pre-set, has adjusted the pending job stream sequence, by the number in database table
Target data corresponding to configuration parameter is changed according to table is changed to.
A kind of data transfer device provided in an embodiment of the present invention, the table change configuration parameter of user's input is obtained first,
And configuration parameter generation Parameter File is changed according to the table；The Parameter File includes table change configuration parameter, described
Table change configuration parameter includes respectively treating change project；Afterwards, the pending of change project is respectively treated according to the Parameter File, generation
Job stream sequence；So that according to the order pre-set, the pending job stream sequence has been adjusted, by the data in database table
It is changed to target data corresponding to table change configuration parameter.So, during data conversion, it is only necessary to which operation maintenance personnel (i.e. user) inputs
Table changes configuration parameter, so as to automatically complete data conversion, is all developed again without each data conversion a set of new
Job stream, the data volume for avoiding tables of data in current bank system is huge, it is necessary to operation maintenance personnel establishes substantial amounts of job stream, and
Each flow needs operation maintenance personnel to submit operation manually, and process is relatively complicated and the problem of easily error.
In order that those skilled in the art is better understood by the present invention, a more detailed embodiment is set forth below,
As shown in Fig. 2 the embodiment of the present invention provides a kind of data transfer device, including：
Step 201, the table change configuration parameter for obtaining user's input, and configuration parameter generation parameter is changed according to the table
File.
Wherein, the Parameter File includes table change configuration parameter, and the table change configuration parameter includes respectively waiting to become
More project.
Specifically, respectively treat that change project can include in the table change configuration parameter：Database table name, table structure are
No change item, build table statement filename, whether subregion item, partitioned mode, whether parallel item, parallel mode configuration filename, simultaneously
Row degree, whether need program processing item, program name.
Herein, user can refer to the banking system operation maintenance personnel in data conversion process, and user can pass through system
Interface come carry out table change configuration parameter input, such as in system interface table change configuration parameter can be with as shown in table 1 below：
Table 1：
Wherein, in parallel mode configuration file, start-stop number section is separated with " Shu ", 50 altogether, as follows：
SYSTEM.SJZH.CONFIG.PRM(CARD001)
0000000000000000000|0000000000030000000
0000000000030000001|0000000000060000000
0000000000060000001|0000000000090000000
……
0000000001200000001|0000000001500000000
In addition, before step 201, operation maintenance personnel may need to be ready to need the new database table after data conversion
DDL sentences (i.e. the definition statement of tables of data), and data on stock documentor and various operation templates, but not only office
It is limited to this.If data list structure does not change, new table DDL sentences need not be prepared.
The parameter verification strategy that step 202, basis are pre-set determines the table change configuration parameter in Parameter File
Accuracy, and the table change configuration parameter inaccuracy when, generation report an error instruction message.
Herein, determine that the accuracy of the table change configuration parameter in Parameter File can in the following way, the above
Exemplified by stating the content shown in table 1：
1. reading Parameter File, judge whether database table has been present, if there is no then reporting an error, table name field is not defeated
Enter also prompting to report an error.Data conversion be based on old table it is existing on the basis of, therefore the table name in parameter need to exist in systems.
2. judge that SYSTEM.DDL.PRM (CARD) and SYSTEM.SJZH.SRC (ZHCARD01) whether there is (i.e. interface
In build table statement filename and program name), in the absence of then reporting an error.
3. judge SYSTEM.SJZH.CONFIG.PRM (CARD001) with the presence or absence of (parallel mode configuration file in interface
Name), in the absence of then reporting an error, if in the presence of judging whether record strip number is equal to 50 (record strip number should be consistent with degree of parallelism), differ
Cause then reports an error.
4. judge that each number section records completely without intersection and covering in SYSTEM.SJZH.CONFIG.PRM (CARD001),
Otherwise report an error.
For example, if number section 1 is 0000000000000000000-0000000000030000000, number section 2 is
0000000000030000002-0000000000060000000, then omit the note that card number is 0000000000030000001
Record, should report an error.
In another example if number section 1 is 0000000000000000000-0000000000030000000, number section 2 is
0000000000020000000-0000000000060000000, then number section intersect, it is possible to create deadlock or to intersect number section weight
Multiple processing.
Step 203, after it is determined that table change configuration parameter in Parameter File is accurate, according to the Parameter File,
Generate the UNLOAD job streams that change project is treated for handling, file process job stream, SPUFI workings and LOAD operations
Stream.
Wherein, UNLOAD refers to the process of database table data on stock being stored in file by way of calling operation.And
LOAD refers to the process of the data in the data on stock file after processing being stored in database table by way of operation calling.And
SPUFI (i.e. SQL Processing Using File Input) is the database access instrument that IBM Corporation provides, and can be held
Row SQL statement.
For the content shown in above-mentioned table 1, the step 203 can be realized in the following way：
1. in above-mentioned table 1, exemplified by database table CARD, to be generated simultaneously according to UNLOAD operations template and Parameter File first
Row degree is 50 UNLOAD job streams, and the table name in template is replaced with into CARD.
2. generating file process job stream, degree of parallelism 50, it is program name ZBCARD01 and parallel side that template, which replaces content,
Formula configuration file start-stop number section.
First operation is 0000000000000000000-0000000000030000000 using number section；
Second operation is 0000000000030000001-0000000000060000000 using number section；
By that analogy, last operation using number section be 0000000001200000001-
0000000001500000000。
3. adjusted SPUFI instruments perform the SQL statement in SYSTEM.DDL.PRM (CARD) delete old table establish new table and
Index.
4. replacing the table name in LOAD operation templates, and generate the LOAD job streams that degree of parallelism is 50.
Step 204, execution UNLOAD job stream file process job stream, SPUFI workings and LOAD have been adjusted successively
Job stream, the data in database table are changed to target data corresponding to table change configuration parameter.
In step 204, UNLOAD job streams, the file process work determined in above-mentioned steps 203 can be carried out successively
Industry stream, SPUFI workings and LOAD job streams, so as to complete data conversion.
The embodiment of the present invention is in data conversion, it is only necessary to operation maintenance personnel (i.e. user) input table change configuration parameter, from
And data conversion can be automatically completed, all develop a set of new job stream again without each data conversion, avoid current
The data volume of tables of data is huge, it is necessary to which operation maintenance personnel establishes substantial amounts of job stream in banking system, and each flow needs O＆M people
Member submits operation manually, and process is relatively complicated and the problem of easily error.
Therefore, by the above embodiment of the present invention as can be seen that with the development of business and customer experience requirement lifting,
Data change request can also continuously emerge, and tighten in face of current hosts resource, the realistic problems such as development amount is big, how be lifted
Efficiency, it is that we need the target of concern emphatically to realize automation and multiplexing, the embodiment of the present invention from this target theory,
Have the following advantages that：
1. easy to implement, operation maintenance personnel need to only complete the differentiation procedure operation of data conversion treatment, there is provided DDL sentences,
Remaining flow is automatically performed by the embodiment of the present invention.
2. development cost can be saved, shorten the construction cycle, except differentiation processing routine and operation, formwork is by this
Inventive embodiments automatic client metaplasia is into (customization refers to be customized to the parameter in template, realizes individual processing difference
Change), reduce development amount.
3. reusable, the differentiation for realizing data conversion by parameter configuration is handled, and is become disposable into reusable, is reduced money
Source takes and management cost.
4. reducing customization risk of error, the embodiment of the present invention realizes formwork customization by parameter, than visitor manually
Familyization is highly efficient accurate.
Corresponding to the embodiment of the method described in above-mentioned Fig. 1 and Fig. 2, as shown in figure 3, the embodiment of the present invention also provides a kind of number
According to conversion equipment, including：
Parameter File generation unit 31, the table for obtaining user's input changes configuration parameter, and is changed according to the table
Configuration parameter generates Parameter File；The Parameter File includes table change configuration parameter, and the table changes configuration parameter bag
Include and respectively treat change project.
Pending job stream sequence generating unit 32, for respectively treating treating for change project according to the Parameter File, generation
Perform job stream sequence.
Date Conversion Unit 33, for according to the order pre-set, the pending job stream sequence having been adjusted, by data
Data in the table of storehouse are changed to target data corresponding to table change configuration parameter.
Specifically, the table in the Parameter File generation unit 31 changes in configuration parameter and respectively treats that change project includes：
Database table name, table structure whether change item, build table statement filename, whether subregion item, partitioned mode, whether parallel item, simultaneously
Line mode configuration filename, degree of parallelism, whether need program processing item, program name.
In addition, as shown in figure 3, described device also includes parameter verification unit 34, it is used for：
Parameter verification strategy according to pre-setting determines the accuracy of the table change configuration parameter in Parameter File.
When the table changes configuration parameter inaccuracy, generation, which reports an error, indicates message.
In addition, the pending job stream sequence generating unit 32, is specifically used for：
According to the Parameter File, generate the UNLOAD job streams that change project is treated for handling, file process job stream,
SPUFI workings and LOAD job streams.
In addition, the Date Conversion Unit 33, is specifically used for：
Adjust successively and performed UNLOAD job stream file process job stream, SPUFI workings and LOAD job streams, with
Data in database table are changed to target data corresponding to table change configuration parameter.
The embodiment of the present invention is in data conversion, it is only necessary to operation maintenance personnel (i.e. user) input table change configuration parameter, from
And data conversion can be automatically completed, all develop a set of new job stream again without each data conversion, avoid current
The data volume of tables of data is huge, it is necessary to which operation maintenance personnel establishes substantial amounts of job stream in banking system, and each flow needs O＆M people
Member submits operation manually, and process is relatively complicated and the problem of easily error.
In addition, the embodiment of the present invention also provides a kind of computer-readable recording medium, computer program is stored thereon with, should
Following steps are realized when program is executed by processor：
The table change configuration parameter of user's input is obtained, and configuration parameter generation Parameter File is changed according to the table；Institute
Stating Parameter File includes table change configuration parameter, and the table change configuration parameter includes respectively treating change project.
According to the Parameter File, the pending job stream sequence of change project is respectively treated in generation.
According to the order pre-set, the pending job stream sequence is adjusted, the data in database table have been changed to
Target data corresponding to table change configuration parameter.
In addition, the embodiment of the present invention also provides a kind of computer equipment, including memory, processor and it is stored in storage
And the computer program that can be run on a processor, following steps are realized during the computing device described program：
The table change configuration parameter of user's input is obtained, and configuration parameter generation Parameter File is changed according to the table；Institute
Stating Parameter File includes table change configuration parameter, and the table change configuration parameter includes respectively treating change project.
According to the Parameter File, the pending job stream sequence of change project is respectively treated in generation.
According to the order pre-set, the pending job stream sequence is adjusted, the data in database table have been changed to
Target data corresponding to table change configuration parameter.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or computer program
Product.Therefore, the present invention can use the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Apply the form of example.Moreover, the present invention can use the computer for wherein including computer usable program code in one or more
The computer program production that usable storage medium is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.)
The form of product.
The present invention is the flow with reference to method according to embodiments of the present invention, equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that can be by every first-class in computer program instructions implementation process figure and/or block diagram
Journey and/or the flow in square frame and flow chart and/or block diagram and/or the combination of square frame.These computer programs can be provided
The processors of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that produced by the instruction of computer or the computing device of other programmable data processing devices for real
The device for the function of being specified in present one flow of flow chart or one square frame of multiple flows and/or block diagram or multiple square frames.
These computer program instructions, which may be alternatively stored in, can guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works so that the instruction being stored in the computer-readable memory, which produces, to be included referring to
Make the manufacture of device, the command device realize in one flow of flow chart or multiple flows and/or one square frame of block diagram or
The function of being specified in multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that counted
Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented processing, so as in computer or
The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in individual square frame or multiple square frames.
Apply specific embodiment in the present invention to be set forth the principle and embodiment of the present invention, above example
Explanation be only intended to help understand the present invention method and its core concept；Meanwhile for those of ordinary skill in the art,
According to the thought of the present invention, there will be changes in specific embodiments and applications, in summary, in this specification
Appearance should not be construed as limiting the invention.
Claims (12)
- A kind of 1. data transfer device, it is characterised in that including：The table change configuration parameter of user's input is obtained, and configuration parameter generation Parameter File is changed according to the table；The ginseng Number file includes table change configuration parameter, and the table change configuration parameter includes respectively treating change project；According to the Parameter File, the pending job stream sequence of change project is respectively treated in generation；According to the order pre-set, the pending job stream sequence is adjusted, the data in database table are changed into table becomes Target data corresponding to more configuration parameter.
- 2. data transfer device according to claim 1, it is characterised in that respectively wait to become in the table change configuration parameter More project includes：Database table name, table structure whether change item, build table statement filename, whether subregion item, partitioned mode, be No parallel item, parallel mode configuration filename, degree of parallelism, whether need program processing item, program name.
- 3. data transfer device according to claim 2, it is characterised in that obtaining the table change configuration ginseng of user's input Number, and according to the table change configuration parameter generation Parameter File after, methods described also includes：Parameter verification strategy according to pre-setting determines the accuracy of the table change configuration parameter in Parameter File；When the table changes configuration parameter inaccuracy, generation, which reports an error, indicates message.
- 4. data transfer device according to claim 3, it is characterised in that described each according to the Parameter File, generation The pending job stream sequence of change project is treated, including：According to the Parameter File, generate the UNLOAD job streams that change project is treated for handling, file process job stream, SPUFI workings and LOAD job streams.
- 5. data transfer device according to claim 4, it is characterised in that the order that the basis is pre-set, adjust The pending job stream sequence, the data in database table are changed to target data corresponding to table change configuration parameter, bag Include：Adjust successively and performed UNLOAD job stream file process job stream, SPUFI workings and LOAD job streams, by number Target data corresponding to table change configuration parameter is changed to according to the data in the table of storehouse.
- A kind of 6. data conversion device, it is characterised in that including：Parameter File generation unit, the table for obtaining user's input changes configuration parameter, and changes configuration ginseng according to the table Number generation Parameter File；The Parameter File includes table change configuration parameter, and the table change configuration parameter includes respectively treating Change project；Pending job stream sequence generating unit, for respectively treating the pending work of change project according to the Parameter File, generation Industry stream sequence；Date Conversion Unit, for according to the order pre-set, the pending job stream sequence having been adjusted, by database table Data be changed to table change configuration parameter corresponding to target data.
- 7. data conversion device according to claim 6, it is characterised in that the table in the Parameter File generation unit becomes Respectively treat that change project includes in more configuration parameter：Whether database table name, table structure change item, build table statement filename, are No subregion item, partitioned mode, whether parallel item, parallel mode configuration filename, degree of parallelism, whether need program processing item, program Name.
- 8. data conversion device according to claim 7, it is characterised in that described device also includes parameter verification unit, For：Parameter verification strategy according to pre-setting determines the accuracy of the table change configuration parameter in Parameter File；When the table changes configuration parameter inaccuracy, generation, which reports an error, indicates message.
- 9. data conversion device according to claim 8, it is characterised in that the pending job stream sequence generation is single Member, it is specifically used for：According to the Parameter File, generate the UNLOAD job streams that change project is treated for handling, file process job stream, SPUFI workings and LOAD job streams.
- 10. data conversion device according to claim 9, it is characterised in that the Date Conversion Unit, be specifically used for：Adjust successively and performed UNLOAD job stream file process job stream, SPUFI workings and LOAD job streams, by number Target data corresponding to table change configuration parameter is changed to according to the data in the table of storehouse.
- 11. a kind of computer-readable recording medium, is stored thereon with computer program, it is characterised in that the program is by processor Following steps are realized during execution：The table change configuration parameter of user's input is obtained, and configuration parameter generation Parameter File is changed according to the table；The ginseng Number file includes table change configuration parameter, and the table change configuration parameter includes respectively treating change project；According to the Parameter File, the pending job stream sequence of change project is respectively treated in generation；According to the order pre-set, the pending job stream sequence is adjusted, the data in database table are changed into table becomes Target data corresponding to more configuration parameter.
- 12. a kind of computer equipment, including memory, processor and the calculating that is stored in storage above and can run on a processor Machine program, it is characterised in that realize following steps during the computing device described program：The table change configuration parameter of user's input is obtained, and configuration parameter generation Parameter File is changed according to the table；The ginseng Number file includes table change configuration parameter, and the table change configuration parameter includes respectively treating change project；According to the Parameter File, the pending job stream sequence of change project is respectively treated in generation；According to the order pre-set, the pending job stream sequence is adjusted, the data in database table are changed into table becomes Target data corresponding to more configuration parameter.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711103217.5A CN107798120B (en) | 2017-11-10 | 2017-11-10 | Data conversion method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711103217.5A CN107798120B (en) | 2017-11-10 | 2017-11-10 | Data conversion method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107798120A true CN107798120A (en) | 2018-03-13 |
| CN107798120B CN107798120B (en) | 2022-01-21 |
Family
ID=61535850
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711103217.5A Active CN107798120B (en) | 2017-11-10 | 2017-11-10 | Data conversion method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107798120B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109472680A (en) * | 2018-10-26 | 2019-03-15 | 中国银行股份有限公司 | A kind of accounting processing method and system |
| CN109739916A (en) * | 2018-12-29 | 2019-05-10 | 中国银行股份有限公司 | Data loading or unloading method and device |
| CN110618988A (en) * | 2019-09-20 | 2019-12-27 | 中国银行股份有限公司 | Data processing method and device based on big data platform |
| CN111949614A (en) * | 2020-08-12 | 2020-11-17 | 中国工商银行股份有限公司 | Bank system file conversion method and device |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090125692A1 (en) * | 2007-10-24 | 2009-05-14 | Masayuki Yamamoto | Backup system and method |
| CN102375891A (en) * | 2011-11-15 | 2012-03-14 | 山东浪潮金融信息系统有限公司 | Implementation tool for unloading and loading incremental data |
| CN103124381A (en) * | 2011-11-18 | 2013-05-29 | 中兴通讯股份有限公司 | Method and system for business configuration |
| CN103135976A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Code automatic generation method and device |
| CN103995854A (en) * | 2014-05-13 | 2014-08-20 | 大唐移动通信设备有限公司 | Equipment cross-version upgrading method and device |
| CN104007984A (en) * | 2014-06-20 | 2014-08-27 | 中国银行股份有限公司 | Data converting method and device |
| CN104331309A (en) * | 2014-10-31 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Management method and system for realizing data loading item shell by configuration |
| US9218370B2 (en) * | 2013-04-19 | 2015-12-22 | International Business Machines Corporation | Processing data loads |
| WO2015199533A1 (en) * | 2014-06-26 | 2015-12-30 | Mimos Berhad | System and method for managing change data in database |
| CN105320680A (en) * | 2014-07-15 | 2016-02-10 | 中国移动通信集团公司 | Data synchronization method and device |
| CN106020801A (en) * | 2016-05-12 | 2016-10-12 | 广州鼎东信息科技有限公司 | Graphic fourth-generation language (4GL) and application generation system thereof |
| CN106156047A (en) * | 2015-03-27 | 2016-11-23 | 中国移动通信集团福建有限公司 | A kind of SNAPSHOT INFO processing method and processing device |
-
2017
- 2017-11-10 CN CN201711103217.5A patent/CN107798120B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090125692A1 (en) * | 2007-10-24 | 2009-05-14 | Masayuki Yamamoto | Backup system and method |
| CN102375891A (en) * | 2011-11-15 | 2012-03-14 | 山东浪潮金融信息系统有限公司 | Implementation tool for unloading and loading incremental data |
| CN103124381A (en) * | 2011-11-18 | 2013-05-29 | 中兴通讯股份有限公司 | Method and system for business configuration |
| CN103135976A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Code automatic generation method and device |
| US9218370B2 (en) * | 2013-04-19 | 2015-12-22 | International Business Machines Corporation | Processing data loads |
| CN103995854A (en) * | 2014-05-13 | 2014-08-20 | 大唐移动通信设备有限公司 | Equipment cross-version upgrading method and device |
| CN104007984A (en) * | 2014-06-20 | 2014-08-27 | 中国银行股份有限公司 | Data converting method and device |
| WO2015199533A1 (en) * | 2014-06-26 | 2015-12-30 | Mimos Berhad | System and method for managing change data in database |
| CN105320680A (en) * | 2014-07-15 | 2016-02-10 | 中国移动通信集团公司 | Data synchronization method and device |
| CN104331309A (en) * | 2014-10-31 | 2015-02-04 | 北京思特奇信息技术股份有限公司 | Management method and system for realizing data loading item shell by configuration |
| CN106156047A (en) * | 2015-03-27 | 2016-11-23 | 中国移动通信集团福建有限公司 | A kind of SNAPSHOT INFO processing method and processing device |
| CN106020801A (en) * | 2016-05-12 | 2016-10-12 | 广州鼎东信息科技有限公司 | Graphic fourth-generation language (4GL) and application generation system thereof |
Non-Patent Citations (4)
| Title |
|---|
| MARY7LX: ""怎么让数据库自动更新"", 《HTTPS://BBS.CSDN.NET/TOPICS/392004651》 * |
| WIVACH RUNGSHAWANG 等: ""Design of underground seismic acquisition system"", 《2017 14TH INTERNATIONAL CONFERENCE ON ELECTRICAL ENGINEERING/ELECTRONICS, COMPUTER, TELECOMMUNICATIONS AND INFORMATION TECHNOLOGY (ECTI-CON)》 * |
| 朱清华: ""数据迁移云服务的设计与实现"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 李娟: ""我国枢纽机场行李中转系统流程优化研究"", 《中国优秀硕士学位论文 经济与管理科学辑》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109472680A (en) * | 2018-10-26 | 2019-03-15 | 中国银行股份有限公司 | A kind of accounting processing method and system |
| CN109739916A (en) * | 2018-12-29 | 2019-05-10 | 中国银行股份有限公司 | Data loading or unloading method and device |
| CN110618988A (en) * | 2019-09-20 | 2019-12-27 | 中国银行股份有限公司 | Data processing method and device based on big data platform |
| CN111949614A (en) * | 2020-08-12 | 2020-11-17 | 中国工商银行股份有限公司 | Bank system file conversion method and device |
| CN111949614B (en) * | 2020-08-12 | 2024-04-02 | 中国工商银行股份有限公司 | Bank system file conversion method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107798120B (en) | 2022-01-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107798120A (en) | A kind of data transfer device and device | |
| CN107967316A (en) | A kind of method of data synchronization, equipment and computer-readable recording medium | |
| US9182963B2 (en) | Computerized migration tool and method | |
| CN107506462A (en) | Data processing method, system, electronic equipment, the storage medium of Enterprise Data | |
| CN110088749A (en) | Automated ontology generates | |
| CN106663037A (en) | Feature processing tradeoff management | |
| CN106575246A (en) | Machine learning service | |
| US9009175B2 (en) | System and method for database migration and validation | |
| CN111651431A (en) | Database service oriented management flow standardization method | |
| CN105989059A (en) | Data record checking method and device | |
| CN110162516A (en) | A kind of method and system that the data based on mass data processing are administered | |
| CN110377621A (en) | A kind of interface processing method and device based on computing engines | |
| CN109885541A (en) | The method and apparatus of information batch processing | |
| CN108255852B (en) | SQL execution method and device | |
| CN108268615A (en) | A kind of data processing method, device and system | |
| CN107729541A (en) | A kind of data processing method, device and computer-readable recording medium | |
| US11061905B2 (en) | Job management in data processing system | |
| CN104424525B (en) | Auxiliary is identified project the method and apparatus of scope | |
| US9563471B2 (en) | Simulation apparatus, simulation method, and program | |
| CN107924502A (en) | Multistage high-effect Business Process Management engine | |
| CN107908697A (en) | The automatic acquiring method and device of host batch processing job result | |
| CN107589946A (en) | A kind of Net silver gas producing formation code automatic generation method and device | |
| CN109582476A (en) | Data processing method, apparatus and system | |
| CN107526648A (en) | A kind of node device that handles is delayed the method and device of machine | |
| CN107133780A (en) | Management method and device in a kind of open task-set |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |