CN108491218A - A kind of method and apparatus of databases comparison file generated - Google Patents
A kind of method and apparatus of databases comparison file generated Download PDFInfo
- Publication number
- CN108491218A CN108491218A CN201810200557.8A CN201810200557A CN108491218A CN 108491218 A CN108491218 A CN 108491218A CN 201810200557 A CN201810200557 A CN 201810200557A CN 108491218 A CN108491218 A CN 108491218A
- Authority
- CN
- China
- Prior art keywords
- file
- change
- catalogue
- catalogues
- database
- 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
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/65—Updates
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The invention discloses a kind of method and apparatus of databases comparison file generated, this method includes:When database model changes during monitoring field modeling, first, changed content is obtained;Then, temporary log file is automatically generated according to changed content;Finally, after the completion of the field modeling, change file is automatically generated as target change file to corresponding change catalogue according to the temporary log file.It can be seen that, utilize the changed content monitored during field modeling, change file is automatically generated to changing catalogue, instead of the technology of artificial hand-coding SQL scripts, the automation of script generates when realizing data library initialization or version updating upgrading, process is simple and clear, saves manpower, saves the time, to improve the working efficiency of geo-informatization system research and development, optimization.
Description
Technical field
The present invention relates to computer application technology more particularly to a kind of methods and dress of databases comparison file generated
It sets.
Background technology
Currently, entire society is in the information-based epoch, with the fast development of science and technology, government or enterprise etc. are also in therewith
Existing Informatization Development trend, to more and more geo-informatization systems occur.In order to adapt to application scenarios, geo-informatization system is logical
It often needs to optimize, that is, geo-informatization system version updating is more frequent.In first deployment information product or information-based production
When product need version updating to upgrade, corresponding database also faces the problem of initialization or version updating upgrade.
In the prior art, most of geo-informatization system needs to research and develop people in initialization or version updating escalation process
The artificial hand-coding structured query language (English of member:Structured Query Language, abbreviation:SQL) script comes real
The initialization or version updating upgrading of existing database.
Inventor has found that the prior art is by the way of artificial hand-coding SQL scripts, process is cumbersome multiple
It is miscellaneous, for example, when changed content is more in geo-informatization system version updating escalation process, write SQL scripts just have it is prodigious
Workload, labor intensive waste time, and reduce the working efficiency of geo-informatization system research and development, optimization.
Invention content
The technical problem to be solved by the invention is to provide a kind of method and apparatus of databases comparison file generated, generations
For the technology of artificial hand-coding SQL scripts, the automatic metaplasia of script when data library initialization or version updating upgrade is realized
At saving manpower saves the time, to improve the working efficiency of geo-informatization system research and development, optimization.
In a first aspect, an embodiment of the present invention provides a kind of method of databases comparison file generated, this method includes:
If monitoring database model during field modeling to change, changed content is obtained;
Temporary log file is generated according to changed content;
After the completion of the field modeling, change file is generated as target change file according to the temporary log file
To corresponding change catalogue.
Preferably, if there is no the old version information of database, the changed content is initialization content;If there are numbers
According to the old version information in library, the changed content is updated contents;
Accordingly, when the changed content is the initialization content, the change file is initialization files, the change
More catalogue is initialization catalogue;When the changed content is the updated contents, the change file is upgrade file, the change
More catalogue is upgrading catalogue.
Preferably, the format of the temporary log file and the change file is xml;The temporary log file and institute
The data structure for stating change file is model root node, field child node and index child node;The model node includes model
Type identification, the field child node include field type data.
Preferably, further include:
Obtain optimization file;
Using the optimization file and the change file as target change file to the change catalogue, the target becomes
More file includes ddl file and SCRIPT files, and accordingly, the change catalogue includes DDL catalogues and SCRIPT catalogues.
Preferably, the DDL catalogues further include DDL type first level subdirectories, and the DDL types first level subdirectory includes letter
Number record, java script catalogue, storing process catalogue, table structure category, trigger catalogue, view directory and/or self-defined mesh
Record.
Preferably, the DDL catalogues further include type of database two level subdirectory, the type of database two level subdirectory
Including Oracle catalogues and/or SQLServer catalogues.
Preferably, the DDL catalogues further include execution sequential file and/or the SCRIPT catalogues further include preset hold
Row sequential file.
Preferably, further include:
The target change file that parsing executes in the change catalogue completes databases comparison.
Preferably, further include:
The current version information of database after record change.
Second aspect, an embodiment of the present invention provides a kind of devices of databases comparison file generated, which is characterized in that packet
It includes:
First acquisition unit obtains if being changed for database model during monitoring field modeling in change
Hold;
First generation unit, for generating temporary log file according to changed content;
Second generation unit, for after the completion of the field modeling, change text to be generated according to the temporary log file
Part is as target change file to corresponding change catalogue.
Compared with prior art, the present invention has at least the following advantages:
Using the technical solution of the embodiment of the present invention, database model changes during monitoring field modeling
When, first, obtain changed content;Then, temporary log file is automatically generated according to changed content;Finally, it is built in the field
After the completion of mould, change file is automatically generated as target change file to corresponding change mesh according to the temporary log file
Record.It can be seen that using the changed content monitored during field modeling, change file is automatically generated to changing catalogue,
Instead of the technology of artificial hand-coding SQL scripts, script is automatic when realizing data library initialization or version updating upgrading
Metaplasia is at process is simple and clear, saves manpower, saves the time, to improve the work effect of geo-informatization system research and development, optimization
Rate.
Description of the drawings
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments described in application, for those of ordinary skill in the art, without creative efforts,
It can also be obtained according to these attached drawings other attached drawings.
Fig. 1 is the system framework schematic diagram involved by a kind of application scenarios in the embodiment of the present invention;
Fig. 2 is a kind of flow diagram of the method for databases comparison file generated provided in an embodiment of the present invention;
Fig. 3 is the flow diagram of the method for another databases comparison file generated provided in an embodiment of the present invention;
Fig. 4 is a kind of structural schematic diagram of the device of databases comparison file generated provided in an embodiment of the present invention.
Specific implementation mode
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is only this
Invention a part of the embodiment, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art exist
The every other embodiment obtained under the premise of creative work is not made, shall fall within the protection scope of the present invention.
Inventor has found that with the fast development of science and technology, the more and more information of the releases such as government or enterprise
Change product, and these geo-informatization system version updatings are more frequent.In first deployment information product or geo-informatization system
When version updating being needed to upgrade, corresponding database is also required to carry out initialization or version updating upgrading.In the prior art, one
As realized by the way of the artificial hand-coding SQL scripts of research staff database initialization or version updating upgrading, should
Compiling procedure very complicated, when changed content is more in geo-informatization system version updating escalation process, writing SQL scripts will
There are prodigious workload, labor intensive to waste time, reduces the working efficiency of geo-informatization system research and development, optimization.
In order to solve this problem, in embodiments of the present invention, database model is sent out during monitoring field modeling
When changing more, first, changed content is obtained;Then, temporary log file is automatically generated according to changed content;Finally, described
After the completion of field modeling, change file is automatically generated as target change file to corresponding change according to the temporary log file
More catalogue.It can be seen that using the changed content monitored during field modeling, change file is automatically generated to changing mesh
Record, instead of the technology of artificial hand-coding SQL scripts, realize data library initialization or when version updating upgrades script from
Dynamic metaplasia is at process is simple and clear, saves manpower, saves the time, to improve the work effect of geo-informatization system research and development, optimization
Rate.
For example, one of the scene of the embodiment of the present invention can be applied to scene application scenarios as shown in Figure 1
In, which includes server 101 and database 102.Database model is sent out during server 101 monitors field modeling
When changing more, first, changed content is obtained;Then, server 101 automatically generates temporary log file according to changed content;Most
Afterwards, after the completion of the field modeling, server 101 automatically generates change file to corresponding according to the temporary log file
Change catalogue.The parsing of server 101 executes the change that the change file in the change catalogue completes database 101.
It is understood that in above application scene, although by the action description of embodiment of the present invention by processor
101 execute, and still, the present invention is unrestricted in terms of executive agent, as long as performing dynamic disclosed in embodiment of the present invention
Work.
It is understood that above-mentioned scene is only a Sample Scenario provided in an embodiment of the present invention, the embodiment of the present invention
It is not limited to this scene.
Below in conjunction with the accompanying drawings, by embodiment come the method and apparatus of databases comparison in the present invention will be described in detail embodiment
Specific implementation.
Illustrative methods
Referring to Fig. 2, a kind of flow diagram of the method for databases comparison file generated in the embodiment of the present invention is shown.
In the present embodiment, the method for example may comprise steps of:
Step 201:If monitoring database model during field modeling to change, changed content is obtained.
It should be noted that when database model changes during monitoring field modeling, databases comparison can
It can be the following two kinds situation:The first is database circumstance of initialization, and another kind is database version update upgrade case.This
When, it can be by inquiry with the presence or absence of the old version information of database, determination is the alteration of database, specifically, when
When inquiry obtains the old version information there are database, then it represents that be database version update upgrade case at this time;Conversely, working as
When inquiry obtains the old version information there are database, then it represents that be database circumstance of initialization at this time.Correspondingly, in change
Appearance can be divided into initialization content and updated contents two types, can be corresponded to and be determined specifically according to the alteration of database
Changed content, therefore, in some embodiments of the present embodiment, if there is no the old version information of database, the change
More content is initialization content;If there are the old version information of database, the changed content is updated contents;
Usually, the changed content of different types should be stored to corresponding catalogue, therefore, in some of the present embodiment
In embodiment, when the changed content is the initialization content, the change file is initialization files, the change mesh
Record is initialization catalogue;When the changed content is the updated contents, the change file is upgrade file, the change mesh
Record is upgrading catalogue.
Step 202:Temporary log file is generated according to changed content.
Step 203:After the completion of the field modeling, change file is generated as target according to the temporary log file
Change file is to corresponding change catalogue.
It should be noted that the data during record field modeling are generally gone using the file of xml formats, therefore,
In some embodiments of the present embodiment, the format of the temporary log file and the change file is xml.It can certainly
Using the file format of json, html.After generating change file in order to ensure temporary log file, it can be resolvable to can perform
Sentence, need the data structure to temporary log file and change file to there are some specifically to require.For example, in the present embodiment
Some embodiments in, the data structure of the temporary log file and the change file is model root node, field
Node and index child node;The model node includes types of models mark, and the field child node includes field type data.
It should be noted that in addition to changed content will be automatically generated temporary log file in the modeling process of field, then will
Temporary log file automatically generates except change file, can also obtain optimization file, and the optimization file and change file are total to
Include optimization data with target change file, the optimization file is used as, can make finally obtained target change file more
Accurately, reliably.Wherein, the needs executed according to follow-up parsing, are divided into ddl file and SCRIPT files by target change file,
Ddl file includes that the DDL sentences SCRIPT files executed is needed to include initialization or upgrading when initialization either upgrades
When need the data processing script sentence that executes.Increase DDL catalogues in the case where changing catalogue and SCRIPT catalogues, DDL catalogues are used for
Ddl file is stored, SCRIPT catalogues are for storing SCRIPT files.Therefore, in some embodiments of the present embodiment, in step
After rapid 203, such as it can also include the following steps:
Step A:Obtain optimization file;
Step B:It is described using the optimization file and the change file as target change file to the change catalogue
Target change file includes ddl file and SCRIPT files, and accordingly, the change catalogue includes DDL catalogues and SCRIPT mesh
Record.
It should be noted that being executed for the ease of subsequent parsing, and the problems such as in view of safeguarding in follow-up data library, need
To increase DDL type first level subdirectories under DDL catalogues, that is, distinguish ddl file according to DDL types, DDL types are logical
Include often function, java script, storing process, table structure, trigger, view and self-defined etc..Therefore, in the present embodiment
In, the DDL catalogues further include DDL type first level subdirectories, and the DDL types first level subdirectory includes function catalogue, Java
Script catalogue, storing process catalogue, table structure category, trigger catalogue, view directory and/or self-defined catalogue.
It should be noted that under above-mentioned DDL types first level subdirectory, it can also be according to geo-informatization system operating system institute
The type of database of support increases type of database subdirectory newly, when executing completion databases comparison in order to subsequently parse, according to
Different data sources goes under respective directories to search required file.For example, operating system supports oracle database and SQLServer
Database then needs to increase Oracle catalogues and SQLServer catalogues newly under the catalogues such as function catalogue.Therefore, in the present embodiment
In, the DDL catalogues further include type of database two level subdirectory, and the type of database two level subdirectory includes Oracle mesh
Record and/or SQLServer catalogues.
It should be noted that the ddl file stored under DDL catalogues includes a plurality of DDL sentences, it can also create and execute sequence
File is used to specify the sequence that executes of these sentences, similarly, execution sequential file can also be created under SCRIPT catalogues and is used for
The execution sequence of these sentences is specified to execute sequence for specify data processing script sentence.Certainly, it is not carried out sequence text
When part, by the way of random read take execution.Therefore, in the present embodiment, the DDL catalogues further include executing sequential file
And/or the SCRIPT catalogues further include preset execution sequential file.For example, being held with establishment under SCRIPT under DDL catalogues
Row sequential file order.ini.
It should be noted that after step 203 generates target change file, in order to realize the change of database, that is, count
According to library initialization or database version update upgrading, the operation that parsing executes the target change file is carried out.Cause
This, in some embodiments of the present embodiment, such as can also include:Parsing executes the target in the change catalogue
Change file completes databases comparison.
It should also be noted that, after completing databases comparison, the current version letter of database after needing record to change
Breath, so that when database model changes during monitoring field modeling, database can be whether there is by inquiry
Old version information, determination be database be initialization or version updating upgrading.Therefore, in some implementations of the present embodiment
In mode, such as can also include:The current version information of database after record change.
The various embodiments provided through this embodiment, database model becomes during monitoring field modeling
When more, first, changed content is obtained;Then, temporary log file is automatically generated according to changed content;Finally, in the field
After the completion of modeling, change file is automatically generated as target change file to corresponding change mesh according to the temporary log file
Record.It can be seen that using the changed content monitored during field modeling, change file is automatically generated to changing catalogue,
Instead of the technology of artificial hand-coding SQL scripts, script is automatic when realizing data library initialization or version updating upgrading
Metaplasia is at process is simple and clear, saves manpower, saves the time, to improve the work effect of geo-informatization system research and development, optimization
Rate.
Below in conjunction with the accompanying drawings 3, it is described in detail in practical applications by another embodiment, data in the embodiment of the present invention
The specific implementation of the method for library change.
Referring to Fig. 3, the flow signal of the method for another databases comparison file generated in the embodiment of the present invention is shown
Figure.In the present embodiment, the method for example may comprise steps of:
Step 301:If monitoring database model during field modeling to change, changed content is obtained.
Step 302:Temporary log file is generated according to changed content.
Step 303:Judge whether the old version information of database;If it is not, executing step 304;If so, executing step
Rapid 308.
Step 304:Initialization files are generated according to temporary log file.
Step 305:Obtain the first optimization file.
Step 306:First optimization file and initialization files are divided into ddl file and SCRIPT files, become as target
More file corresponds to the DDL catalogues and SCRIPT catalogues deposited under initialization catalogue.
Step 307:Parsing executes under initialization catalogue in DDL catalogues SCRIPT files in ddl file and SCRIPT catalogues
Complete data library initialization.
It should be noted that executing step 312 after step 307.
Step 308:Upgrade file is generated according to temporary log file.
Step 309:Obtain the second optimization file.
Step 310:Second optimization file and upgrade file are divided into ddl file and SCRIPT files, changed as target
File corresponds to the DDL catalogues and SCRIPT catalogues deposited under upgrading catalogue.
Step 311:Parsing executes under upgrading catalogue in DDL catalogues that SCRIPT files are complete in ddl file and SCRIPT catalogues
It updates and upgrades at database version.
Step 312:The current version information of database of record.
The various embodiments provided through this embodiment, database model becomes during monitoring field modeling
When more, first, changed content is obtained;Then, temporary log file is automatically generated according to changed content;Finally, in the field
After the completion of modeling, change file is automatically generated as target change file to corresponding change mesh according to the temporary log file
Record.It can be seen that using the changed content monitored during field modeling, change file is automatically generated to changing catalogue,
Instead of the technology of artificial hand-coding SQL scripts, script is automatic when realizing data library initialization or version updating upgrading
Metaplasia is at process is simple and clear, saves manpower, saves the time, to improve the work effect of geo-informatization system research and development, optimization
Rate.
Example devices
Referring to Fig. 4, a kind of structural schematic diagram of the device of databases comparison file generated in the embodiment of the present invention is shown.
In the present embodiment, described device for example can specifically include:
First acquisition unit 401 obtains change if being changed for database model during monitoring field modeling
Content;
First generation unit 402, for generating temporary log file according to changed content;
Second generation unit 403, for after the completion of the field modeling, being generated and being changed according to the temporary log file
File is as target change file to corresponding change catalogue.
Optionally, if there is no the old version information of database, the changed content is initialization content;If there are numbers
According to the old version information in library, the changed content is updated contents;
Accordingly, when the changed content is the initialization content, the change file is initialization files, the change
More catalogue is initialization catalogue;When the changed content is the updated contents, the change file is upgrade file, the change
More catalogue is upgrading catalogue.
Optionally, the format of the temporary log file and the change file is xml;The temporary log file and institute
The data structure for stating change file is model root node, field child node and index child node;The model node includes model
Type identification, the field child node include field type data.
Optionally, described device further includes:
Second acquisition unit, for obtaining optimization file;
Obtaining unit, for using the optimization file and the change file as target change file to the change mesh
Record, the target change file include ddl file and SCRIPT files, accordingly, the change catalogue include DDL catalogues with
SCRIPT catalogues.
Optionally, the DDL catalogues further include DDL type first level subdirectories, and the DDL types first level subdirectory includes letter
Number record, java script catalogue, storing process catalogue, table structure category, trigger catalogue, view directory and/or self-defined mesh
Record.
Optionally, the DDL catalogues further include type of database two level subdirectory, the type of database two level subdirectory
Including Oracle catalogues and/or SQLServer catalogues.
Optionally, the DDL catalogues further include execution sequential file and/or the SCRIPT catalogues further include preset hold
Row sequential file.
Optionally, described device further includes:
Resolution executing becomes for parsing the target change file completion database executed in the change catalogue
More.
Optionally, described device further includes:
Recording unit is used to record the current version information of database after change.
The device of the various embodiments provided through this embodiment, databases comparison file generated includes that the first acquisition is single
Member, the first generation unit and the second generation unit;Wherein, if first acquisition unit is for monitoring data during field modeling
Library model changes, and obtains changed content;First generation unit is used to generate temporary log file according to changed content;Second
Generation unit is used for after the completion of the field modeling, and generate change file according to the temporary log file changes as target
File is to corresponding change catalogue.It can be seen that using the changed content monitored during field modeling, change is automatically generated
More file, instead of the technology of artificial hand-coding SQL scripts, realizes data library initialization or version updating to catalogue is changed
The automation of script generates when upgrading, and process is simple and clear, saves manpower, saves the time, is ground to improve geo-informatization system
Hair, the working efficiency optimized.
It should be noted that herein, relational terms such as first and second and the like are used merely to a reality
Body or operation are distinguished with another entity or operation, are deposited without necessarily requiring or implying between these entities or operation
In any actual relationship or order or sequence.The terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that the process, method, article or equipment including a series of elements includes not only those elements, and
And further include other elements that are not explicitly listed, or further include for this process, method, article or equipment institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including institute
State in the process, method, article or equipment of element that there is also other identical elements.
The above described is only a preferred embodiment of the present invention, being not intended to limit the present invention in any form.Though
So the present invention has been disclosed as a preferred embodiment, and however, it is not intended to limit the invention.It is any to be familiar with those skilled in the art
Member, without departing from the scope of the technical proposal of the invention, all using the methods and technical content of the disclosure above to the present invention
Technical solution makes many possible changes and modifications, or is revised as the equivalent embodiment of equivalent variations.Therefore, it is every without departing from
The content of technical solution of the present invention, according to the technical essence of the invention any simple modification made to the above embodiment, equivalent
Variation and modification, still fall within technical solution of the present invention protection in the range of.
Claims (10)
1. a kind of method of databases comparison file generated, which is characterized in that including:
If monitoring database model during field modeling to change, changed content is obtained;
Temporary log file is generated according to changed content;
After the completion of the field modeling, change file is generated as target change file to right according to the temporary log file
The change catalogue answered.
2. according to the method described in claim 1, it is characterized in that, if the old version information of database, the change is not present
More content is initialization content;If there are the old version information of database, the changed content is updated contents;
Accordingly, when the changed content is the initialization content, the change file is initialization files, the change mesh
Record is initialization catalogue;When the changed content is the updated contents, the change file is upgrade file, the change mesh
Record is upgrading catalogue.
3. according to the method described in claim 1, it is characterized in that, the format of the temporary log file and the change file
For xml;The temporary log file and the data structure of the change file are model root node, field child node and index
Node;The model node includes types of models mark, and the field child node includes field type data.
4. according to the method described in claim 1, it is characterized in that, further including:
Obtain optimization file;
Using the optimization file and the change file as target change file to the change catalogue, the target change text
Part includes ddl file and SCRIPT files, and accordingly, the change catalogue includes DDL catalogues and SCRIPT catalogues.
5. according to the method described in claim 4, it is characterized in that, the DDL catalogues further include DDL type first level subdirectories,
The DDL types first level subdirectory includes function catalogue, java script catalogue, storing process catalogue, table structure category, trigger
Catalogue, view directory and/or self-defined catalogue.
6. according to the method described in claim 5, it is characterized in that, the DDL catalogues further include type of database two level specific item
Record, the type of database two level subdirectory includes Oracle catalogues and/or SQLServer catalogues.
7. according to the method described in claim 4, it is characterized in that, the DDL catalogues further include executing sequential file and/or institute
State the execution sequential file that SCRIPT catalogues further include preset.
8. according to the method described in claim 1, it is characterized in that, further including:
The target change file that parsing executes in the change catalogue completes databases comparison.
9. according to the method described in claim 8, it is characterized in that, further including:
The current version information of database after record change.
10. a kind of device of databases comparison file generated, which is characterized in that including:
First acquisition unit obtains changed content if being changed for database model during monitoring field modeling;
First generation unit, for generating temporary log file according to changed content;
Second generation unit, for after the completion of the field modeling, generating change file according to the temporary log file and making
For target change file to corresponding change catalogue.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810200557.8A CN108491218B (en) | 2018-03-12 | 2018-03-12 | Method and device for generating database change file |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810200557.8A CN108491218B (en) | 2018-03-12 | 2018-03-12 | Method and device for generating database change file |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108491218A true CN108491218A (en) | 2018-09-04 |
CN108491218B CN108491218B (en) | 2021-09-14 |
Family
ID=63338724
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810200557.8A Active CN108491218B (en) | 2018-03-12 | 2018-03-12 | Method and device for generating database change file |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108491218B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109284297A (en) * | 2018-10-29 | 2019-01-29 | 中译语通科技股份有限公司 | A kind of database intelligent updating method and system |
CN113778997A (en) * | 2021-09-26 | 2021-12-10 | 杭州安恒信息技术股份有限公司 | Database version management method, system and equipment |
CN114860314A (en) * | 2022-07-06 | 2022-08-05 | 深圳华锐分布式技术股份有限公司 | Deployment upgrading method, device, equipment and medium based on database compatibility |
Citations (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101436207A (en) * | 2008-12-16 | 2009-05-20 | 浪潮通信信息系统有限公司 | Data restoring and synchronizing method based on log snapshot |
US20090210852A1 (en) * | 2008-02-19 | 2009-08-20 | International Business Machines Corporation | Automated merging in a software development environment |
CN102289469A (en) * | 2011-07-26 | 2011-12-21 | 国电南瑞科技股份有限公司 | Method for supporting universal database to synchronize data based on physical isolating equipment |
CN102393860A (en) * | 2011-12-06 | 2012-03-28 | 方正国际软件有限公司 | Database data migration system |
CN102929878A (en) * | 2011-08-09 | 2013-02-13 | 阿里巴巴集团控股有限公司 | Method and device for managing database changes |
CN103020262A (en) * | 2012-12-24 | 2013-04-03 | Tcl集团股份有限公司 | Data storage method, system and data storage equipment |
CN104090948A (en) * | 2014-07-02 | 2014-10-08 | 中广核工程有限公司 | Method, device and system for processing mass data of nuclear power station |
US20150032689A1 (en) * | 2013-07-24 | 2015-01-29 | Oracle International Corporation | Data definition language (ddl) expression annotation |
CN105683950A (en) * | 2013-10-29 | 2016-06-15 | 慧与发展有限责任合伙企业 | Validating a query execution |
CN105956084A (en) * | 2016-04-29 | 2016-09-21 | 浪潮(北京)电子信息产业有限公司 | Changed data extracting method and apparatus |
CN106325933A (en) * | 2016-08-24 | 2017-01-11 | 明算科技(北京)股份有限公司 | Method and device for synchronizing batch data |
CN106598620A (en) * | 2016-12-21 | 2017-04-26 | 深圳南北互联网金融服务有限公司 | Code generation method and code generator |
CN106708906A (en) * | 2015-11-18 | 2017-05-24 | 青岛海日安电子有限公司 | Database data migration system |
CN106933604A (en) * | 2015-12-30 | 2017-07-07 | 中移(苏州)软件技术有限公司 | A kind of method for upgrading system and device |
CN106991104A (en) * | 2016-01-21 | 2017-07-28 | 泰康保险集团股份有限公司 | Database script disposes device and database script dispositions method |
CN107092478A (en) * | 2017-02-24 | 2017-08-25 | 中国人民解放军海军大连舰艇学院 | The integrated system and method for a kind of software component library and component development instrument |
-
2018
- 2018-03-12 CN CN201810200557.8A patent/CN108491218B/en active Active
Patent Citations (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20090210852A1 (en) * | 2008-02-19 | 2009-08-20 | International Business Machines Corporation | Automated merging in a software development environment |
CN101436207A (en) * | 2008-12-16 | 2009-05-20 | 浪潮通信信息系统有限公司 | Data restoring and synchronizing method based on log snapshot |
CN102289469A (en) * | 2011-07-26 | 2011-12-21 | 国电南瑞科技股份有限公司 | Method for supporting universal database to synchronize data based on physical isolating equipment |
CN102929878A (en) * | 2011-08-09 | 2013-02-13 | 阿里巴巴集团控股有限公司 | Method and device for managing database changes |
CN102393860A (en) * | 2011-12-06 | 2012-03-28 | 方正国际软件有限公司 | Database data migration system |
CN103020262A (en) * | 2012-12-24 | 2013-04-03 | Tcl集团股份有限公司 | Data storage method, system and data storage equipment |
US20150032689A1 (en) * | 2013-07-24 | 2015-01-29 | Oracle International Corporation | Data definition language (ddl) expression annotation |
CN105683950A (en) * | 2013-10-29 | 2016-06-15 | 慧与发展有限责任合伙企业 | Validating a query execution |
CN104090948A (en) * | 2014-07-02 | 2014-10-08 | 中广核工程有限公司 | Method, device and system for processing mass data of nuclear power station |
CN106708906A (en) * | 2015-11-18 | 2017-05-24 | 青岛海日安电子有限公司 | Database data migration system |
CN106933604A (en) * | 2015-12-30 | 2017-07-07 | 中移(苏州)软件技术有限公司 | A kind of method for upgrading system and device |
CN106991104A (en) * | 2016-01-21 | 2017-07-28 | 泰康保险集团股份有限公司 | Database script disposes device and database script dispositions method |
CN105956084A (en) * | 2016-04-29 | 2016-09-21 | 浪潮(北京)电子信息产业有限公司 | Changed data extracting method and apparatus |
CN106325933A (en) * | 2016-08-24 | 2017-01-11 | 明算科技(北京)股份有限公司 | Method and device for synchronizing batch data |
CN106598620A (en) * | 2016-12-21 | 2017-04-26 | 深圳南北互联网金融服务有限公司 | Code generation method and code generator |
CN107092478A (en) * | 2017-02-24 | 2017-08-25 | 中国人民解放军海军大连舰艇学院 | The integrated system and method for a kind of software component library and component development instrument |
Non-Patent Citations (4)
Title |
---|
DING YUEHUA: "Design of VSS Software Configuration Management Database for WEB Application Project", 《2009 PACIFIC-ASIA CONFERENCE ON CIRCUITS, COMMUNICATIONS AND SYSTEMS》 * |
佚名: "MySQL数据库生产环境维护经验之表对象DDL变更", 《HTTPS://WWW.DOCIN.COM/P-307033096.HTML》 * |
杜晓铭: "基于XML的元数据整合中间件的研究与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
逯文晖: "目录与关系数据库的分层映射数据集成模型", 《计算机工程与设计 》 * |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109284297A (en) * | 2018-10-29 | 2019-01-29 | 中译语通科技股份有限公司 | A kind of database intelligent updating method and system |
CN113778997A (en) * | 2021-09-26 | 2021-12-10 | 杭州安恒信息技术股份有限公司 | Database version management method, system and equipment |
CN113778997B (en) * | 2021-09-26 | 2024-02-02 | 杭州安恒信息技术股份有限公司 | Database version management method, system and equipment |
CN114860314A (en) * | 2022-07-06 | 2022-08-05 | 深圳华锐分布式技术股份有限公司 | Deployment upgrading method, device, equipment and medium based on database compatibility |
Also Published As
Publication number | Publication date |
---|---|
CN108491218B (en) | 2021-09-14 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8010962B2 (en) | Infrastructure for the automation of the assembly of schema maintenance scripts | |
US7774772B2 (en) | Method and apparatus to perform an application software migration | |
US7562357B2 (en) | Relational database schema version management | |
US8255899B2 (en) | Techniques for upgrade dependency management | |
Barmpis et al. | Hawk: Towards a scalable model indexing architecture | |
US7792800B1 (en) | Data repository upgrade process | |
CN103678494A (en) | Method and device for client side and server side data synchronization | |
US11615076B2 (en) | Monolith database to distributed database transformation | |
CN101901265B (en) | Objectification management system of virtual test data | |
US9805136B2 (en) | Virtualizing schema relations over a single database relation | |
US20220334831A1 (en) | Version control system | |
CN112130891B (en) | Method and equipment for continuously deploying database | |
CN108491218A (en) | A kind of method and apparatus of databases comparison file generated | |
US20200089792A1 (en) | Consistency checks between database systems | |
US10394844B2 (en) | Integrating co-deployed databases for data analytics | |
CN114691704A (en) | Metadata synchronization method based on MySQL binlog | |
US20230289331A1 (en) | Model generation service for data retrieval | |
CN113515564A (en) | Data access method, device, equipment and storage medium based on J2EE | |
Ormenisan et al. | Implicit provenance for machine learning artifacts | |
CN110083617B (en) | DDL statement processing method and device, electronic device and medium | |
CN115658815A (en) | CDC (control data center) -based data synchronization method | |
CN111078273B (en) | Information acquisition method and device and storage medium | |
US9916154B2 (en) | File-based transport of table content | |
US11281444B2 (en) | Application update monitoring computer systems | |
WO2021247109A1 (en) | Version control system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |