CN107025249A - A kind of method of quick support synchronizing multiple databases exploitation - Google Patents
A kind of method of quick support synchronizing multiple databases exploitation Download PDFInfo
- Publication number
- CN107025249A CN107025249A CN201610075024.2A CN201610075024A CN107025249A CN 107025249 A CN107025249 A CN 107025249A CN 201610075024 A CN201610075024 A CN 201610075024A CN 107025249 A CN107025249 A CN 107025249A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- initialization
- middleware
- creates
- 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/217—Database tuning
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
A kind of method of quick support synchronizing multiple databases exploitation disclosed by the invention, comprises the following steps：Step S1, creates the database information middleware of an initialization information for including Universal Database；Step S2, creates database source information；Step S3, database source information is imported in database information middleware, and the initialization that the database source information of importing is converted to multiple database is created script file by database information middleware；Step S4, database information middleware, which will be initialized, creates script file export, and creates the other kinds of database of script file establishment using derived initialization.Design data personnel only need to be absorbed in the design and change of a certain types of database in project development process, it is again that can be achieved quickly to realize the support to other types database by the method for the present invention, effectively reduce the input of manpower and materials, the construction cycle of software product is shortened, development efficiency is improved.
Description
Technical field
The present invention relates to database design technique field, more particularly to a kind of quick support synchronizing multiple databases
The method of exploitation.
Background technology
As computer industry development is maked rapid progress, software product demand constantly increases.As software company,
How efficiently to complete the research and development and upgrading of a product becomes more and more important, and database is used as exhausted big portion
How the essential part of component software product, quickly realize the design of database module and escalate into
The technical problem for having to solve for all software companys.
Data base management system experienced the development evolvement of more than 30 years, form the situation let a hundred schools contend already.
Database species is various, common relevant database have ORACLE, DB2, SQL SERVER, SYBASE,
MYSQL, up to dream, GBASE etc..In software development process, it is often necessary to determined according to the selection of client
The database of support, some software products need to support the database of several of the types simultaneously, do not have also at present
There is the method for preferably quick support multi-data synchronous to solve the problem of multiple database is supported, result in the need for
Put into substantial amounts of manpower and materials so that the life cycle extension of software product, inefficiency.
Therefore, applicant carried out beneficial exploration and trial, result of the above problems is have found,
Technical scheme described below is produced under this background.
Therefore, applicant carried out beneficial exploration and trial, result of the above problems is have found,
Technical scheme described below is produced under this background.
The content of the invention
The technical problems to be solved by the invention：For multiple database during existing Software Development
During support the problem of inefficiency, and provide a kind of method of quick support synchronizing multiple databases exploitation.
Technical problem solved by the invention can be realized using following technical scheme：
A kind of method of quick support synchronizing multiple databases exploitation, comprises the following steps：
Step S1, creates the database information middleware of an initialization information for including Universal Database；
Step S2, creates database source information；
Step S3, the database that will be created in the database source information steps for importing S1 created in step S2
In information middleware, the database source information of importing is converted to multiple database by database information middleware
Initialization creates script file；
Step S4, database information middleware will change the initialization wound of the multiple database of formation in step S3
Script file export is built, and script file is created using derived initialization and creates other kinds of database.
In a preferred embodiment of the invention, in step sl, the database information middleware bag
The initialization information of the Universal Database contained include table name, field name, field type, field length,
Whether major key and whether self-propagation.
In a preferred embodiment of the invention, the database source information for database design ER figure,
Database initializtion script file, the table built using the newly-built pattern of database client or direct volume
One kind in the database information middleware write.
In a preferred embodiment of the invention, in step s3, the multiple database include ORACLE,
DB2, SQL SERVER, SYBASE, MYSQL, SQLITE, FIREBIRD, up to dream, GBASE and number
According to the data dictionary in the High-level design document of storehouse.
As a result of technical scheme as above, the beneficial effects of the present invention are：By creating a number
According to storehouse information middleware, the database schema that any one database is designed or has been built up can be converted to
Database information middleware, then the initial of other types database is output as by database information middleware
Change and create script file.Design data personnel only need to be absorbed in a certain number of types in project development process
According to the design and change in storehouse, then the method for passing through the present invention is that can be achieved quickly to realize to other types data
The support in storehouse, effectively reduces the input of manpower and materials, shortens the construction cycle of software product, improves
Development efficiency.
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 reality
The accompanying drawing used required for applying in example or description of the prior art is briefly described, it should be apparent that, below
Accompanying drawing in description is only some embodiments of the present invention, for those of ordinary skill in the art,
On the premise of not paying creative work, other accompanying drawings can also be obtained according to these accompanying drawings.
Fig. 1 is the principle schematic of the present invention.
Fig. 2 is the schematic diagram of the specific embodiment of the present invention.
Embodiment
In order that the technical means, the inventive features, the objects and the advantages of the present invention are readily apparent from
Solution, with reference to being specifically illustrating, is expanded on further the present invention.
Referring to Fig. 1, the method that a kind of quick support synchronizing multiple databases of the invention are developed, including with
Lower step：
Step S1, creates the database information middleware of an initialization information for including Universal Database,
The initialization information of Universal Database include table name, field name, field type, field length, whether
Major key and whether the information such as self-propagation；
Step S2, creates database source information, and database source information designs ER figures, database for database
Initializtion script file, the table built using the newly-built pattern of database client or the number directly write
According to one kind in the information middleware of storehouse；
Step S3, the database that will be created in the database source information steps for importing S1 created in step S2
In information middleware, the database source information of importing is converted to multiple database by database information middleware
Initialization create script file, multiple database include ORACLE, DB2, SQL SERVER, SYBASE, MYSQL,
SQLITE, FIREBIRD, up to data dictionary in dream, GBASE and database High-level design document etc.；
Step S4, database information middleware will change the initialization wound of the multiple database of formation in step S3
Script file export is built, and script file is created using derived initialization and creates other kinds of database.
The present invention by create a database information middleware, any one database can be designed or
The database schema built up is converted to database information middleware, then defeated by database information middleware
Go out and create script file for the initialization of other types database.
Referring to Fig. 2, the specific embodiment of the present invention is given in figure, the specific embodiment is by MYSQL
The initialization that database is converted into up to dream database creates script file, and uses up to the initial of dream database
Change to create script file and create and reach dream database, it comprises the following steps：
Step 1, using MYSQL client connection servers；
Step 2, using the newly-built Mode S CHEMA1 of client；
Step 3, newly-built table TABLE1, TABLE2... in Mode S CHEMA1；
Step 4, configuration database source information is SCHEMA1；
Step 5, the table information in SCHEMA1 is read；
Step 6, database source information is saved as into database information middleware；
Step 7, reading database information middleware；
Step 8, the initialization exported as up to dream database creates script file；
Step 9, create script file using the initialization up to dream database and create and reach dream database；
The general principle and principal character and advantages of the present invention of the present invention has been shown and described above.One's own profession
The technical staff of industry is it should be appreciated that the present invention is not limited to the above embodiments, above-described embodiment and explanation
Merely illustrating the principles of the invention described in book, without departing from the spirit and scope of the present invention,
Various changes and modifications of the present invention are possible, and these changes and improvements both fall within claimed invention model
In enclosing.The scope of the present invention is defined by the appended claims and its equivalents.
Claims (4)
1. a kind of method of quick support synchronizing multiple databases exploitation, it is characterised in that comprise the following steps：
Step S1, creates the database information middleware of an initialization information for including Universal Database；
Step S2, creates database source information；
Step S3, the database that will be created in the database source information steps for importing S1 created in step S2
In information middleware, the database source information of importing is converted to multiple database by database information middleware
Initialization creates script file；
Step S4, database information middleware will change the initialization wound of the multiple database of formation in step S3
Script file export is built, and script file is created using derived initialization and creates other kinds of database.
2. the quick method for supporting synchronizing multiple databases exploitation as claimed in claim 1, it is characterised in that
In step sl, the initialization information for the Universal Database that the database information middleware is included includes table
Name, field name, field type, field length, whether major key and whether self-propagation.
3. the quick method for supporting synchronizing multiple databases exploitation as claimed in claim 1, it is characterised in that
The database source information designs ER figures, database initializtion script file, using database for database
One kind in the newly-built pattern of the client table built or the database information middleware directly write.
4. the quick method for supporting synchronizing multiple databases exploitation as claimed in claim 1, it is characterised in that
In step s3, the multiple database include ORACLE, DB2, SQL SERVER, SYBASE, MYSQL,
SQLITE, FIREBIRD, up to the data dictionary in dream, GBASE and database High-level design document.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610075024.2A CN107025249A (en) | 2016-02-02 | 2016-02-02 | A kind of method of quick support synchronizing multiple databases exploitation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610075024.2A CN107025249A (en) | 2016-02-02 | 2016-02-02 | A kind of method of quick support synchronizing multiple databases exploitation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107025249A true CN107025249A (en) | 2017-08-08 |
Family
ID=59524642
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610075024.2A Pending CN107025249A (en) | 2016-02-02 | 2016-02-02 | A kind of method of quick support synchronizing multiple databases exploitation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107025249A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108132849A (en) * | 2018-01-08 | 2018-06-08 | 中国联合网络通信集团有限公司 | Operational order treating method and apparatus |
| CN108427699A (en) * | 2017-09-22 | 2018-08-21 | 平安科技（深圳）有限公司 | The method, apparatus and storage medium of fast initialization system database |
| CN110177125A (en) * | 2018-05-15 | 2019-08-27 | 广东电网有限责任公司 | A kind of middleware platform moving method and system |
| CN115391457A (en) * | 2022-08-23 | 2022-11-25 | 昆仑数智科技有限责任公司 | Cross-database data synchronization method and device and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101697166A (en) * | 2009-10-28 | 2010-04-21 | 浪潮电子信息产业股份有限公司 | Method for accelerating data integration of heterogeneous platform |
| CN101789021A (en) * | 2010-02-24 | 2010-07-28 | 浪潮通信信息***有限公司 | Universal configurable database data migration method |
| CN102508929A (en) * | 2011-12-01 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing data migration of heterogeneous database |
| CN103218402A (en) * | 2013-03-19 | 2013-07-24 | 上海宝信软件股份有限公司 | General database data structure, data migratory system and method thereof |
| US20140012885A1 (en) * | 2009-07-10 | 2014-01-09 | Robert Mack | Method and apparatus for converting heterogeneous databases into standardized homogeneous databases |
| CN103809944A (en) * | 2012-11-08 | 2014-05-21 | 镇江华扬信息科技有限公司 | Web database development component processing method based on JDBC |
-
2016
- 2016-02-02 CN CN201610075024.2A patent/CN107025249A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140012885A1 (en) * | 2009-07-10 | 2014-01-09 | Robert Mack | Method and apparatus for converting heterogeneous databases into standardized homogeneous databases |
| CN101697166A (en) * | 2009-10-28 | 2010-04-21 | 浪潮电子信息产业股份有限公司 | Method for accelerating data integration of heterogeneous platform |
| CN101789021A (en) * | 2010-02-24 | 2010-07-28 | 浪潮通信信息***有限公司 | Universal configurable database data migration method |
| CN102508929A (en) * | 2011-12-01 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing data migration of heterogeneous database |
| CN103809944A (en) * | 2012-11-08 | 2014-05-21 | 镇江华扬信息科技有限公司 | Web database development component processing method based on JDBC |
| CN103218402A (en) * | 2013-03-19 | 2013-07-24 | 上海宝信软件股份有限公司 | General database data structure, data migratory system and method thereof |
Non-Patent Citations (1)
| Title |
|---|
| PENG1987LPL: "powerDesigner将db2转换成oracle的步骤", 《百度文库》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108427699A (en) * | 2017-09-22 | 2018-08-21 | 平安科技（深圳）有限公司 | The method, apparatus and storage medium of fast initialization system database |
| CN108132849A (en) * | 2018-01-08 | 2018-06-08 | 中国联合网络通信集团有限公司 | Operational order treating method and apparatus |
| CN110177125A (en) * | 2018-05-15 | 2019-08-27 | 广东电网有限责任公司 | A kind of middleware platform moving method and system |
| CN110177125B (en) * | 2018-05-15 | 2021-08-31 | 广东电网有限责任公司 | Middleware platform migration method |
| CN115391457A (en) * | 2022-08-23 | 2022-11-25 | 昆仑数智科技有限责任公司 | Cross-database data synchronization method and device and storage medium |
| CN115391457B (en) * | 2022-08-23 | 2023-09-12 | 昆仑数智科技有限责任公司 | Cross-database data synchronization method, device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11366856B2 (en) | System and method for updating target schema of graph model | |
| CN108037916B (en) | Web-based graphical service modeling method | |
| EP3751426A1 (en) | System and method for migration of a legacy datastore | |
| Li | Transforming relational database into HBase: A case study | |
| CN104965735B (en) | Device for generating upgrading SQL scripts | |
| CN107025249A (en) | A kind of method of quick support synchronizing multiple databases exploitation | |
| US20160055233A1 (en) | Pre-join tags for entity-relationship modeling of databases | |
| US20140025684A1 (en) | Indexing and searching a data collection | |
| CN103309806B (en) | The device and method of a kind of quick development and testing | |
| CN104504001B (en) | Towards the vernier building method of magnanimity distributed relational database | |
| CN103678556A (en) | Method for processing column-oriented database and processing equipment | |
| CN104572895A (en) | MPP (Massively Parallel Processor) database and Hadoop cluster data intercommunication method, tool and realization method | |
| US20180004813A1 (en) | Querying across a composite join of multiple database tables using a search engine index | |
| CN102607576B (en) | A kind of differential data generation method of map of navigation electronic and device | |
| CN105808653A (en) | User label system-based data processing method and device | |
| CN106815366A (en) | A kind of method and system of Mass production data | |
| CN103488738A (en) | Method and system for automatically realizing JAVA object and data table SQL (structured query language) file | |
| US20070043689A1 (en) | Lightweight generic report generation tool | |
| CN107590288A (en) | Method and apparatus for extracting webpage picture and text block | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| US20150193854A1 (en) | Automated compilation of graph input for the hipergraph solver | |
| CN108073584B (en) | Data processing method and server | |
| Raj et al. | Implementation of ETL process using Pig and Hadoop | |
| CN106569784A (en) | Display page generation method and system | |
| CN105488147A (en) | Persistence method based on SQL (Structured Query Language) template |
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 | ||
| CB02 | Change of applicant information |
Address after: 200436 Room 601, Lane 299, Lane 299, JIANGCHANG West Road, Jingan District, Shanghai Applicant after: Geer software Limited by Share Ltd Address before: 200070 Room 601, Lane 299, Lane 299, JIANGCHANG West Road, Zhabei District, Shanghai Applicant before: Geer Software Co., Ltd., Shanghai |
|
| CB02 | Change of applicant information | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170808 |
|
| RJ01 | Rejection of invention patent application after publication |