CN106980679A - A kind of information system Domestic Database migration remodeling method and device - Google Patents
A kind of information system Domestic Database migration remodeling method and device Download PDFInfo
- Publication number
- CN106980679A CN106980679A CN201710202494.5A CN201710202494A CN106980679A CN 106980679 A CN106980679 A CN 106980679A CN 201710202494 A CN201710202494 A CN 201710202494A CN 106980679 A CN106980679 A CN 106980679A
- Authority
- CN
- China
- Prior art keywords
- information system
- grammer
- domestic database
- file
- domestic
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
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)
Abstract
The embodiment of the invention discloses a kind of information system Domestic Database migration remodeling method and device, for automation inspection, transformation using the grammer incompatible with Domestic Database in the information system of non-Domestic Database, solve existing hand inspection, rearrange inefficiency that code causes, the easily high technical problem of error, improvement cost.Present invention method includes：Obtain the differential file of Domestic Database and non-Domestic Database product；Detected according to the differential file and export the incompatible item of grammer in preset information system source code file to be rebuilt with Domestic Database.
Description
Technical field
The present invention relates to field of information system, more particularly to a kind of information system Domestic Database migration remodeling method and dress
Put.
Background technology
Implementation with country to basic software " autonomous controllable " policy, " middle under going IOE " national strategy to drive
Part starts to tilt to domestic brand as the basic platform software of information system, the numerous and confused policies of different industries.It is more and more
Government department, company carry out to existing information system carry out Domestic Database migration transform, by former non-Domestic Database
Replace with Domestic Database.
But hand inspection is mainly to the method that Domestic Database migrate transformation at present, code is rearranged, so as to lead
Inefficiency is caused, easily error, improvement cost is high.
The content of the invention
The embodiments of the invention provide a kind of information system Domestic Database migration remodeling method and device, for automating
Check, transform grammer incompatible with Domestic Database in the information system using non-Domestic Database, solve existing people
Work inspection, rearrange inefficiency that code causes, the easily high technical problem of error, improvement cost.
Remodeling method is migrated the embodiments of the invention provide a kind of information system Domestic Database, including：
Obtain the differential file of Domestic Database and non-Domestic Database product；
Detected according to the differential file and export in preset information system source code file to be rebuilt with domestic data
The incompatible item of grammer in storehouse.
Preferably,
With domestic number in being detected according to the differential file and exporting preset information system source code file to be rebuilt
After the incompatible item of the grammer in storehouse, in addition to：
The incompatible item of the grammer is replaced with by corresponding Domestic Database grammer according to the differential file.
Preferably,
With domestic number in being detected according to the differential file and exporting preset information system source code file to be rebuilt
After the incompatible item of the grammer in storehouse, in addition to：
The incompatible item of the grammer is marked in the preset information system source code file to be rebuilt.
Preferably,
After the incompatible item of the grammer to be replaced with to corresponding Domestic Database grammer according to the differential file, also
Including：
The preset information system source code file to be rebuilt generated after being replaced with the incompatible item of the grammer is corresponding
New file and the Domestic Database grammer after the incompatible item of the grammer is replaced is marked in the new file.
Preferably,
With domestic number in being detected according to the differential file and exporting preset information system source code file to be rebuilt
Before the incompatible item of storehouse grammer, in addition to：
Obtain information system source code file to be rebuilt.
The embodiments of the invention provide a kind of information system Domestic Database migration transformation device, including：
First acquisition unit, the differential file for obtaining Domestic Database and non-Domestic Database product；
Detection unit, for preset information system source code file to be rebuilt to be detected and exported according to the differential file
In the incompatible item of grammer with Domestic Database.
Preferably,
Described information system Domestic Database migration transformation device also includes：
First indexing unit, for marking the grammer in the preset information system source code file to be rebuilt
Incompatible item.
Preferably,
Described information system Domestic Database migration transformation device also includes：
Replacement unit, for the incompatible item of the grammer to be replaced with into corresponding Domestic Database according to the differential file
Grammer.
Preferably,
Described information system Domestic Database migration transformation device also includes：
File generated indexing unit, for generating the preset letter to be rebuilt after being replaced with the incompatible item of the grammer
The corresponding new file of breath system source code file simultaneously marks the institute after the incompatible item of the grammer is replaced in the new file
State Domestic Database grammer.
Preferably,
Described information system Domestic Database migration transformation device also includes：
Second acquisition unit, the information system source code file to be rebuilt for obtaining.
As can be seen from the above technical solutions, the embodiment of the present invention has advantages below：
The embodiments of the invention provide a kind of information system Domestic Database migration remodeling method and device, for automating
Check, transform grammer incompatible with Domestic Database in the information system using non-Domestic Database, solve existing people
Work inspection, rearrange inefficiency that code causes, the easily high technical problem of error, improvement cost.
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 accompanying drawing used required 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 migrates the first embodiment of remodeling method for a kind of information system Domestic Database provided in an embodiment of the present invention
Schematic flow sheet；
Fig. 2 migrates the second embodiment of remodeling method for a kind of information system Domestic Database provided in an embodiment of the present invention
Schematic flow sheet；
Fig. 3 is a kind of first embodiment of information system Domestic Database migration transformation device provided in an embodiment of the present invention
Structural representation；
Fig. 4 is a kind of second embodiment of information system Domestic Database migration transformation device provided in an embodiment of the present invention
Structural representation.
Embodiment
The embodiments of the invention provide a kind of information system Domestic Database migration remodeling method and device, for automating
Check, transform grammer incompatible with Domestic Database in the information system using non-Domestic Database, solve existing people
Work inspection, rearrange inefficiency that code causes, the easily high technical problem of error, improvement cost.
To enable goal of the invention, feature, the advantage of the present invention more obvious and understandable, below in conjunction with the present invention
Accompanying drawing in embodiment, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that disclosed below
Embodiment be only a part of embodiment of the invention, and not all embodiment.Based on the embodiment in the present invention, this area
All other embodiment that those of ordinary skill is obtained under the premise of creative work is not made, belongs to protection of the present invention
Scope.
Referring to Fig. 1, the embodiments of the invention provide the first of a kind of information system Domestic Database migration remodeling method
Embodiment, including：
101, obtain the differential file of Domestic Database and non-Domestic Database product.
102, detected according to differential file and export in preset information system source code file to be rebuilt with domestic data
The incompatible item of grammer in storehouse.
In embodiments of the present invention, it is necessary first to obtain the differential file of Domestic Database and non-Domestic Database product,
Then need to be detected and exported according to differential file in preset information system source code file to be rebuilt with Domestic Database
The incompatible item of grammer.
Referring to Fig. 2, the embodiments of the invention provide the second of a kind of information system Domestic Database migration remodeling method
Embodiment, including：
201, obtain information system source code file to be rebuilt.
In embodiments of the present invention, it is necessary first to obtain information system source code file to be rebuilt.
202, obtain the differential file of Domestic Database and non-Domestic Database product；
In embodiments of the present invention, in addition it is also necessary to obtain the differential file of Domestic Database and non-Domestic Database product；Need
It is noted that step 201 and step 202 do not have tandem relation, step 201 and step 202 need are before step 203
Progress；Wherein, domestic middleware includes but is not limited to up to dream, the big general, Basesoft Information Tech. Co., Ltd. in south, non-domestic middleware include but
It is not limited to oracle, SQL Sever, INFORMIX, MySQL, DB2；Differential file is mainly according to Domestic Database and non-state
Difference (incompatibility) of the database in terms of character set, case sensitivity, keyword, reserved word, function, sentence is produced,
The compatible grammer of one-to-one non-Domestic Database and the compatible grammer of Domestic Database are set out respectively, it is as shown in the table：
Form as shown above is the one of which of differential file.
203, detected according to differential file and export in preset information system source code file to be rebuilt with domestic data
The incompatible item of grammer in storehouse.
In embodiments of the present invention, obtaining information system source code file to be rebuilt and obtaining Domestic Database and non-
After the differential file of Domestic Database product, in addition it is also necessary to detected according to differential file and export preset information system to be rebuilt
With the incompatible item of grammer of Domestic Database in source code file.
204, mark the incompatible item of grammer in preset information system source code file to be rebuilt；
In embodiments of the present invention, detected according to differential file and exporting preset information system source code text to be rebuilt
In part with after the incompatible item of grammer of Domestic Database, in addition it is also necessary in preset information system source code file acceptance of the bid to be rebuilt
Remember and the incompatible item of grammer.
205, the incompatible item of grammer is replaced with by corresponding Domestic Database grammer according to differential file；
In embodiments of the present invention, detected according to differential file and exporting preset information system source code text to be rebuilt
In part with after the incompatible item of grammer of Domestic Database, in addition it is also necessary to according to differential file by the incompatible item of grammer replace with correspondence
Domestic Database grammer.
206, generate the preset information system source code file to be rebuilt after being replaced with the incompatible item of grammer corresponding new
File simultaneously marks the Domestic Database grammer after the incompatible item of grammer is replaced in new file；
In embodiments of the present invention, the incompatible item of grammer is being replaced with by corresponding Domestic Database language according to differential file
After method, in addition it is also necessary to generate the preset information system source code file to be rebuilt after being replaced with the incompatible item of grammer corresponding new
File simultaneously marks the Domestic Database grammer after the incompatible item of grammer is replaced in new file.
Referring to Fig. 3, the embodiments of the invention provide the first of a kind of information system Domestic Database migration transformation device
Embodiment, including：
First acquisition unit 301, the differential file for obtaining Domestic Database and non-Domestic Database product；
Detection unit 302, for preset information system source code file to be rebuilt to be detected and exported according to differential file
In the incompatible item of grammer with Domestic Database.
Referring to Fig. 4, the embodiments of the invention provide the second of a kind of information system Domestic Database migration transformation device
Embodiment, including：
Second acquisition unit 401, the information system source code file to be rebuilt for obtaining.
First acquisition unit 402, the differential file for obtaining Domestic Database and non-Domestic Database product；
Detection unit 403, for preset information system source code file to be rebuilt to be detected and exported according to differential file
In the incompatible item of grammer with Domestic Database.
First indexing unit 404, it is not simultaneous for marking grammer in preset information system source code file to be rebuilt
Rong Xiang.
Replacement unit 405, for the incompatible item of grammer to be replaced with into corresponding Domestic Database grammer according to differential file.
File generated indexing unit 406, for generating the preset information system to be rebuilt after being replaced with the incompatible item of grammer
The corresponding new file of system source code file simultaneously marks the Domestic Database grammer after the incompatible item of grammer is replaced in new file.
It is apparent to those skilled in the art that, for convenience and simplicity of description, the system of foregoing description,
The specific work process of device and unit, may be referred to the corresponding process in preceding method embodiment, will not be repeated here.
In several embodiments provided herein, it should be understood that disclosed system, apparatus and method can be with
Realize by another way.For example, device embodiment described above is only schematical, for example, the division of unit,
It is only a kind of division of logic function, there can be other dividing mode when actually realizing, such as multiple units or component can be with
With reference to or be desirably integrated into another system, or some features can be ignored, or not perform.It is another, it is shown or discussed
Coupling each other or direct-coupling or communication connection can be by some interfaces, the INDIRECT COUPLING of device or unit or
Communication connection, can be electrical, machinery or other forms.
The unit illustrated as separating component can be or may not be it is physically separate, it is aobvious as unit
The part shown can be or may not be physical location, you can with positioned at a place, or can also be distributed to multiple
On NE.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs
's.
In addition, each functional unit in each embodiment of the invention can be integrated in a processing unit, can also
That unit is individually physically present, can also two or more units it is integrated in a unit.Above-mentioned integrated list
Member can both be realized in the form of hardware, it would however also be possible to employ the form of SFU software functional unit is realized.
If the integrated unit is realized using in the form of SFU software functional unit and as independent production marketing or used
When, it can be stored in a computer read/write memory medium.Understood based on such, technical scheme is substantially
The part contributed in other words to prior art or all or part of the technical scheme can be in the form of software products
Embody, the computer software product is stored in a storage medium, including some instructions are to cause a computer
Equipment (can be personal computer, server, or network equipment etc.) performs the complete of each embodiment methods described of the invention
Portion or part steps.And foregoing storage medium includes：USB flash disk, mobile hard disk, read-only storage (ROM, Read-Only
Memory), random access memory (RAM, Random Access Memory), magnetic disc or CD etc. are various can store journey
The medium of sequence code.
Described above, the above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although with reference to before
Embodiment is stated the present invention is described in detail, it will be understood by those within the art that：It still can be to preceding
State the technical scheme described in each embodiment to modify, or equivalent substitution is carried out to which part technical characteristic；And these
Modification is replaced, and the essence of appropriate technical solution is departed from the spirit and scope of various embodiments of the present invention technical scheme.
Claims (10)
1. a kind of information system Domestic Database migrates remodeling method, it is characterised in that including：
Obtain the differential file of Domestic Database and non-Domestic Database product；
Detected according to the differential file and export in preset information system source code file to be rebuilt with Domestic Database
The incompatible item of grammer.
2. information system Domestic Database according to claim 1 migrates remodeling method, it is characterised in that according to described
Differential file detects and exports the incompatible item of grammer in preset information system source code file to be rebuilt with Domestic Database
Afterwards, in addition to：
The incompatible item of the grammer is marked in the preset information system source code file to be rebuilt.
3. information system Domestic Database according to claim 2 migrates remodeling method, it is characterised in that according to described
Differential file detects and exports the incompatible item of grammer in preset information system source code file to be rebuilt with Domestic Database
Afterwards, in addition to：
The incompatible item of the grammer is replaced with by corresponding Domestic Database grammer according to the differential file.
4. information system Domestic Database according to claim 3 migrates remodeling method, it is characterised in that according to described
Differential file replaces with the incompatible item of the grammer after corresponding Domestic Database grammer, in addition to：
Generate the preset information system source code file to be rebuilt after being replaced with the incompatible item of the grammer corresponding new
File simultaneously marks the Domestic Database grammer after the incompatible item of the grammer is replaced in the new file.
5. information system Domestic Database according to claim 1 migrates remodeling method, it is characterised in that according to described
Differential file detects and exports the incompatible item in preset information system source code file to be rebuilt with Domestic Database grammer
Before, in addition to：
Obtain information system source code file to be rebuilt.
6. a kind of information system Domestic Database migration transformation device, it is characterised in that including：
First acquisition unit, the differential file for obtaining Domestic Database and non-Domestic Database product；
Detection unit, for detected and exported according to the differential file in preset information system source code file to be rebuilt with
The incompatible item of grammer of Domestic Database.
7. information system Domestic Database migration transformation device according to claim 6, it is characterised in that also include：
First indexing unit, it is not simultaneous for marking the grammer in the preset information system source code file to be rebuilt
Rong Xiang.
8. information system Domestic Database migration transformation device according to claim 6, it is characterised in that also include：
Replacement unit, for the incompatible item of the grammer to be replaced with into corresponding Domestic Database language according to the differential file
Method.
9. information system Domestic Database migration transformation device according to claim 8, it is characterised in that also include：
File generated indexing unit, for generating the preset information system to be rebuilt after being replaced with the incompatible item of the grammer
The corresponding new file of system source code file simultaneously marks the state after the incompatible item of the grammer is replaced in the new file
Produce database syntax.
10. information system Domestic Database migration transformation device according to claim 6, it is characterised in that also include：
Second acquisition unit, the information system source code file to be rebuilt for obtaining.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710202494.5A CN106980679A (en) | 2017-03-30 | 2017-03-30 | A kind of information system Domestic Database migration remodeling method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710202494.5A CN106980679A (en) | 2017-03-30 | 2017-03-30 | A kind of information system Domestic Database migration remodeling method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106980679A true CN106980679A (en) | 2017-07-25 |
Family
ID=59339440
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710202494.5A Pending CN106980679A (en) | 2017-03-30 | 2017-03-30 | A kind of information system Domestic Database migration remodeling method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106980679A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112380186A (en) * | 2020-11-06 | 2021-02-19 | 福建亿榕信息技术有限公司 | Domestic database migration method based on active adaptation |
| CN112800034A (en) * | 2021-03-23 | 2021-05-14 | 杭州沃趣科技股份有限公司 | Database replacement method, device, medium and equipment based on grammar compatible conversion |
| CN113111050A (en) * | 2021-04-27 | 2021-07-13 | 山东福生佳信科技股份有限公司 | Database comparison method and device |
| CN114610385A (en) * | 2022-03-16 | 2022-06-10 | 山东福生佳信科技股份有限公司 | Operating environment adaptation system and method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7665081B1 (en) * | 2006-05-06 | 2010-02-16 | Kaspersky Lab, Zao | System and method for difference-based software updating |
| CN102467529A (en) * | 2010-11-11 | 2012-05-23 | 金蝶软件（中国）有限公司 | Metadata synchronizing method and system |
| CN103019686A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | System spanning two pieces of middleware and compiling method of system |
| CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
| CN104932973A (en) * | 2014-03-21 | 2015-09-23 | 腾讯科技（深圳）有限公司 | Version compatibility test method and apparatus |
-
2017
- 2017-03-30 CN CN201710202494.5A patent/CN106980679A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7665081B1 (en) * | 2006-05-06 | 2010-02-16 | Kaspersky Lab, Zao | System and method for difference-based software updating |
| CN102467529A (en) * | 2010-11-11 | 2012-05-23 | 金蝶软件（中国）有限公司 | Metadata synchronizing method and system |
| CN103019686A (en) * | 2012-11-20 | 2013-04-03 | 北京思特奇信息技术股份有限公司 | System spanning two pieces of middleware and compiling method of system |
| CN103440273A (en) * | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
| CN104932973A (en) * | 2014-03-21 | 2015-09-23 | 腾讯科技（深圳）有限公司 | Version compatibility test method and apparatus |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112380186A (en) * | 2020-11-06 | 2021-02-19 | 福建亿榕信息技术有限公司 | Domestic database migration method based on active adaptation |
| CN112800034A (en) * | 2021-03-23 | 2021-05-14 | 杭州沃趣科技股份有限公司 | Database replacement method, device, medium and equipment based on grammar compatible conversion |
| CN113111050A (en) * | 2021-04-27 | 2021-07-13 | 山东福生佳信科技股份有限公司 | Database comparison method and device |
| CN113111050B (en) * | 2021-04-27 | 2023-07-07 | 山东福生佳信科技股份有限公司 | Database comparison method and device |
| CN114610385A (en) * | 2022-03-16 | 2022-06-10 | 山东福生佳信科技股份有限公司 | Operating environment adaptation system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101504672B (en) | Method and system for dynamically configuring physical data table | |
| CN106980679A (en) | A kind of information system Domestic Database migration remodeling method and device | |
| CN105094707B (en) | A kind of data storage, read method and device | |
| CN111178079B (en) | Triplet extraction method and device | |
| CN106528641B (en) | Data storage method and device and communication gateway machine | |
| CN112463774B (en) | Text data duplication eliminating method, equipment and storage medium | |
| CN108763212A (en) | A kind of address information extraction method and device | |
| CN105205636A (en) | Method and device for calculating material requirement planning (MRP) | |
| CN106021718A (en) | Drawing method and device used for engineering drawing in CATIA (Computer-graphics Aided Three-dimensional Interactive Application) | |
| CN112241458B (en) | Text knowledge structuring processing method, device, equipment and readable storage medium | |
| CN106672022A (en) | Rail transit interlocking table generation method and system | |
| CN106980505A (en) | A kind of domestic middleware migration remodeling method of information system and device | |
| CN105787052A (en) | Data processing model building method and data screening method based on data processing model | |
| CN104750673B (en) | Text matches filter method and device | |
| US11797487B2 (en) | Maintaining stable record identifiers in the presence of updated data records | |
| CN103929499B (en) | A kind of Internet of Things isomery index identification method and system | |
| CN104268709A (en) | Method for designing RFID system by distributed LSM tree | |
| CN102456176B (en) | Method and device for engineering change of bill of material | |
| CN105354149B (en) | A kind of internal storage data lookup method and device | |
| CN104573098B (en) | Extensive object identifying method based on Spark systems | |
| CN107544989A (en) | A kind of presentation file delamination process and device | |
| CN105574124A (en) | Data storage system based on product information | |
| CN105701078A (en) | Document annotation classification method and device | |
| CN108090095A (en) | The method and apparatus that batch rebuilds database | |
| CN104102739B (en) | A kind of method and device for expanding entity storehouse |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170725 |
|
| RJ01 | Rejection of invention patent application after publication |