CN106599167A - System and method capable of supporting incremental upgrading of database - Google Patents
System and method capable of supporting incremental upgrading of database Download PDFInfo
- Publication number
- CN106599167A CN106599167A CN201611129545.8A CN201611129545A CN106599167A CN 106599167 A CN106599167 A CN 106599167A CN 201611129545 A CN201611129545 A CN 201611129545A CN 106599167 A CN106599167 A CN 106599167A
- Authority
- CN
- China
- Prior art keywords
- sql
- files
- execution
- file
- version
- 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
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000012216 screening Methods 0.000 claims abstract description 29
- 230000001174 ascending effect Effects 0.000 claims description 3
- 238000001914 filtration Methods 0.000 claims description 3
- 230000008569 process Effects 0.000 description 9
- 230000008859 change Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000001133 acceleration Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 230000000739 chaotic effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 239000004744 fabric Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004899 motility Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 239000007858 starting material Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- 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/23—Updating
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (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 invention discloses a method and system capable of supporting incremental upgrading of a database. The method comprises the steps of analyzing version information of an SQL file executed in the database; analyzing SQL files in a specified folder and obtaining the version information of all SQL files in the specified folder; screening out the SQLs different from the SQL file executed in the database in version information from all SQL files in the specified folder as pre-executed SQL files; and executing the pre-executed SQL files and recording execution information of the SQL files in the pre-executed SQL files. Before an additional SQL file is executed, the version information of the additional SQL file is compared with that of the SQL file executed in the database, and if the version information of the additional SQL file does not exist in the SQL file executed in the database, the additional SQL file is the pre-executed SQL file and is executed, or else, the SQL file is not executed, so that reasonable and effective management on the version information of the database is achieved, the incrementally executed SQL files and SQL file execution results are recorded, and the files which are specifically executed by each module can be obtained according to recorded information.
Description
Technical field
The present invention relates to database management technology field, more particularly to a kind of system for supporting increment upgrade database and
Method.
Background technology
With the continuous progressive and development of computer technology, hardware and software is also fast-developing in respective field, mutually
Support, mutually promote, it is nonsynchronous to be upgraded many times due to the renewal of hardware and software.For example, a computer exists
During use, what its hardware was to determine, with the continuous development of computer software, in order to optimize its performance, hardware is played as far as possible
Performance, improve the utilization ratio of equipment, typically can carry out system upgrade using new algorithm, raising equipment operating efficiency.
And during Software Development and upgrading, the Version Control always comparison to data base is chaotic
Controlled state, such as, in the escalation process of certain data base, upgrades to certain part of data base, and other
Again the other parts of data base are upgraded in database upgrade so that whole data base in each escalation process,
Database version information before there is the upgrading of all versions and after upgrading so that very not square for the management of data base
Just, and if when follow-up data storehouse also needs to upgrading, so many database version information data base upgrading very not
It is convenient.
The content of the invention
It is an object of the invention to provide a kind of system and method for supporting increment upgrade database, clearly can manage out
Send out and the database version information in escalation process, improve data base administration development efficiency.
To solve above-mentioned technical problem, a kind of method for supporting increment upgrade database is embodiments provided, wrapped
Include：
The version information of the SQL files performed in analyzing data base；
SQL files in parsing specified folder, and obtain the version information of SQL files in the specified folder；
Filter out in the SQL files in the specified folder with the SQL FileVersions letter that performed in the data base
The different SQL files of breath, as pre-execution SQL file；
The pre-execution SQL file is performed, and records the SQL file execution informations of the pre-execution SQL file.
Wherein, the version information includes system version number, module title and module SQL version number.
Wherein, the SQL files execution information includes system version number, module SQL version number, module title, SQL files
Name, execution time and execution user's letter.
Wherein, the name format of the SQL files is system version number _ module release number _ module title .SQL.
Wherein, it is literary with the SQL that performed in the data base in the SQL files filtered out in the specified folder
The different SQL files of part version information, as pre-execution SQL file, including：
Filter out in the SQL files in the specified folder, with the not homology of the SQL files that performed in the data base
System version number, or disparate modules SQL version numbers, or the SQL files of disparate modules title are used as pre-execution SQL file.
Wherein, it is described to perform the pre-execution SQL file, including：
According to the version number of the pre-execution SQL file, the ascending execution pre-execution SQL file.
In addition, the embodiment of the present invention additionally provides a kind of system for supporting increment upgrade database, including：
Analytical equipment, the version information of the SQL files for performing that the analytical equipment is used in analytical database；
Resolver, the resolver obtain described specifying for parsing to the SQL files in specified folder
The version information of the SQL files in file；
Screening plant, the screening plant are connected with the analytical equipment, the resolver, for filtering out the finger
Different from the version information of the SQL files for performing in data base SQL files in file are determined as pre-execution SQL
File；
Recording equipment is performed, the execution recording equipment is connected with the screening plant, for performing pre-execution SQL
File, and record the SQL file execution informations of the pre-execution SQL file.
Wherein, the version information includes system version number, module title and module SQL version number.
Wherein, the SQL files execution information includes system version number, module SQL version number, module title, SQL files
Name, execution time and execution user profile.
Wherein, the name format of the SQL files is system version number _ module release number _ module title .SQL.
The system and method for the support increment upgrade database provided by the embodiment of the present invention, compared with prior art, tool
Have the advantage that：
The method for supporting increment upgrade database provided in an embodiment of the present invention, including：
The version information of the SQL files performed in analyzing data base；
SQL files in parsing specified folder, and obtain the version information of SQL files in the specified folder；
Filter out in the SQL files in the specified folder with the SQL FileVersions letter that performed in the data base
The different SQL files of breath, as pre-execution SQL file；
The pre-execution SQL file is performed, and records the SQL file execution informations of the pre-execution SQL file.
The system for supporting increment upgrade database provided in an embodiment of the present invention, including：
Analytical equipment, the version information of the SQL files for performing that the analytical equipment is used in analytical database；
Resolver, the resolver obtain described specifying for parsing to the SQL files in specified folder
The version information of the SQL files in file；
Screening plant, the screening plant are connected with the analytical equipment, the resolver, for filtering out the finger
Different from the version information of the SQL files for performing in data base SQL files in file are determined as pre-execution SQL
File；
Recording equipment is performed, the execution recording equipment is connected with the screening plant, for performing pre-execution SQL
File, and record the SQL file execution informations of the pre-execution SQL file.
The system and method for supporting increment upgrade database, by, before newly-increased SQL files are performed, comparing number
According to the version information of the SQL files performed in storehouse, if non-existent version letter in the SQL files performed in data base
Breath, the SQL files are performed for pre-execution SQL file, otherwise do not perform, and realize to the reasonable effective of database version information
Manage, the SQL files that recording increment is performed, SQL file implementing results, and each module can be obtained according to record information and specifically hold
Which file is gone.
Description of the drawings
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
Accompanying drawing to be used needed for having technology description is briefly described, it should be apparent that, drawings in the following description are the present invention
Some embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can be with basis
These accompanying drawings obtain other accompanying drawings.
Fig. 1 is a kind of step of specific embodiment of the method for supporting increment upgrade database provided in an embodiment of the present invention
Rapid schematic flow sheet；
Fig. 2 is a kind of structure of specific embodiment of system for supporting increment upgrade database provided in an embodiment of the present invention
Schematic diagram.
Specific embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation is described, it is clear that described embodiment is only a part of embodiment of the invention, rather than the embodiment of whole.It is based on
Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under the premise of creative work is not made
Embodiment, belongs to the scope of protection of the invention.
Fig. 1-2 is refer to, Fig. 1 is that one kind of the method for supporting increment upgrade database provided in an embodiment of the present invention is concrete
The step of embodiment schematic flow sheet；Fig. 2 is that the system for supporting increment upgrade database provided in an embodiment of the present invention is a kind of
The structural representation of specific embodiment.
In a kind of specific embodiment, the method for supporting increment upgrade database, as shown in figure 1, including：
Step 1, the version information of the SQL files performed in analyzing data base；
Step 2, parses the SQL files in specified folder, and obtains the version of SQL files in the specified folder
Information；
Step 3, filter out in the SQL files in the specified folder with the SQL files that performed in the data base
The different SQL files of version information, as pre-execution SQL file；
Step 4, performs the pre-execution SQL file, and records the SQL file execution informations of the pre-execution SQL file.
It is pointed out that the analysis process of the version information of the SQL files for performing in data base in the present invention, with
SQL files in parsing specified folder, and to obtain the process of the version information of SQL files in the specified folder be simultaneously
What row were independent of each other, therefore upon execution without the problem of consideration tandem.
In the step 2 of the present invention, the SQL files in specified folder are parsed, and is obtained in the specified folder
The version information of SQL files, refers to and parses all of SQL files in specified folder, so will not just repeat to hold
The SQL files of executed in row data base, only carry out newly-increased SQL files.
Sql like language, is the abbreviation of SQL (Structured Query Language).Sql like language is one
Data base querying and programming language are planted, for accessing data and inquiry, updating and administrative relationships Database Systems；Simultaneously
And the extension name of database script file.
Sql like language is senior deproceduring programming language, it is allowed to which user works in high level data structure.It does not require
User specifies the deposit method to data, it is not required that user understands specific data location mode, so having entirely different
The disparate databases system of fabric can use identical SQL as data input and the interface for managing.
Sql like language sentence can be with nesting, and this makes him have great motility and powerful function.
In the present invention, database upgrade is carried out using the file that sql like language is compiled.
It is pointed out that in the present invention, the SQL files of increase are to be placed on specified folder before being performed
In.
By, before increased SQL files are performed, the SQL files of increase being parsed, increased SQL files are obtained
Version information, be so that only carry out newly-increased SQL files, the SQL files of the increase in specified file to be screened, screen
Go out the newly-increased SQL files different from the SQL files performed in data base.By by the SQL of the parsing in specified folder
The version information of the SQL files in the version information of file and the data base for performing is compared, if holding in data base
Non-existent version information in the SQL files gone, then the SQL files be performed for pre-execution SQL file, otherwise do not perform.
Be thus increase SQL files in, only carry out newly-increased SQL files, realize to the reasonable of database version information
Effectively manage.Simultaneously because the SQL files that recording increment is performed in the process of implementation, SQL file implementing results, the energy root for being just
Obtain which file is each module specifically perform according to record information.
In the present invention, the version information of the SQL files generally comprises system version number, module title and module SQL
Version number.
In a kind of specific embodiment, the SQL files execution information include system version number, module SQL version number,
Module title, SQL filenames, execution time and execution user profile.
SQL files execution information, can also be used as data base in addition to the implementation status for recording newly-increased SQL files
The middle SQL files for performing, the so part in the SQL document screening comparison procedure of the increase of next time as data base,
So that the updating and management of whole data base is more perfect.
It is pointed out that the system version number in version information, module title and module SQL version number are generally used,
Can also be using the other information in version information, the present invention is not especially limited to this, only because system version number, module
SQL version numbers have corresponding numeral, such as from 1.0 system upgrades to 1.1 systems during, have the change of system version number
Change, reduce the difficulty and process of screening, improve the updating speed of data base and rise stage efficiency, and while typically upgrading
Except the upgrading of system also has the upgrading of some of which module, upgrading of authentication module such as therein etc. in journey.
In a kind of specific embodiment, the name format of the SQL files is system version number _ module release number _ mould
Block name SQL.System version number in the name format of SQL files and module release number are placed on into front, as version number is
Numeral, can accelerate to compare speed and breakneck acceleration.
It is pointed out that in the present invention the name format of SQL files can also be other forms, such as module version
This number _ system version number _ module title .SQL, or module title _ module release number _ system version .SQL, can be with
It is the name format for adding other version informations, it is of the invention that this is not especially limited.
For from increase SQL files in filter out newly-increased SQL files, in a kind of specific embodiment, the sieve
Select different from the SQL file version informations performed in data base SQL in the SQL files in the specified folder
File, as pre-execution SQL file, including：
Filter out in the SQL files in the specified folder, with the not homology of the SQL files that performed in the data base
System version number, or disparate modules SQL version numbers, or the SQL files of disparate modules title are used as pre-execution SQL file.
Reality, during comparing, screening newly-increased SQL files, can separately individually carry out system version number, mould
The comparison of block SQL version numbers, or the two is put together, will system version number, module SQL version number merge into version
This number is processed.Upgraded in units of module during due to being usually most, thus can directly be carried out version number
Relatively, due to being all digital, treatment effeciency is all very high.
Certainly, in the present invention, or first the SQL files of increase are sorted out, that is, is categorized as correspondence different
SQL files under module, so only need to carry out the comparison of version number, without the comparison for increasing module type every time,
Screening efficiency can be improved.
Due to can all there are many SQL files in each escalation process, and during upgrading, may go out
The SQL files now upgraded are not fully identical, and for example, the system version number of original modules A is 1.0, and module SQL version number is
1.0, newly-increased SQL files have 1.1_1.0_ modules As .SQL, also have 1.0_1.1_ modules As .SQL, also 1.1_1.1_ modules
A.SQL, if not having certain execution order, is likely to result in so that upgrading
Speed is slow, or even causes situation about normally cannot upgrade.Therefore it is in a kind of specific embodiment, described to perform the pre-execution
SQL files, including：
According to the version number of the pre-execution SQL file, the ascending execution pre-execution SQL file.
Here version number refers to module release number and system version number, can be module release number _ system version group
The version number that the version number, or system version number _ module release number combination for closing formation is formed, or other forms
Version number, the present invention are not especially limited to this.
For example, system version number is 1.1, and module release number is 1.2, and the version number after combination can be 1.1_1.2, also may be used
Being 1.2_1.1.And if the version number of other SQL files, can be the rear module version number according to first system version number
Mode, according to being performed from small to large, or first module release number, the mode of rear system version number, according to from little
To the execution for carrying out greatly SQL files.
In addition, the embodiment of the present invention additionally provides a kind of system for supporting increment upgrade database, as shown in Fig. 2
Including：
Analytical equipment 10, the version information of the SQL files for performing that the analytical equipment 10 is used in analytical database；
Resolver 20, the resolver 20 obtain described for parsing to the SQL files in specified folder
The version information of the SQL files in specified folder；
Screening plant 30, the screening plant 30 are connected with the analytical equipment 10, the resolver 20, for screening
Go out SQL file conducts different from the version information of the SQL files for performing in the data base in the specified folder
Pre-execution SQL file；
Recording equipment 40 is performed, the execution recording equipment 40 is connected with the screening plant 30, described pre- for performing
SQL files are performed, and records the SQL file execution informations of the pre-execution SQL file.
In the present invention, the version information of the SQL files for performing in data base, the execution for both having prestored including system
SQL files version information (version information of the SQL files of starter system), also record in recording equipment 40 including performing
The SQL file execution informations of the pre-execution SQL file after each database upgrade.
Parsed by the SQL files in the specified folder by increase, the SQL files in acquisition specified folder
Version information, then with using 10 analytical database of analytical equipment in the version information of the SQL files for performing contrasted,
Find out in the SQL files in specified folder with data base in the SQL files for performing the diverse SQL of version information
File, these files are exactly the newly-increased SQL files of this database upgrade, then as pre-execution SQL file, in this secondary data
It is performed during qurush level, implementation procedure is performed recording equipment 40 and records so that this pre-execution SQL file conduct
The SQL files for performing in next data base.The reasonable effective management to database version information is realized, recording increment is held
Capable SQL files, SQL file implementing results, and can obtain which file is each module specifically perform according to record information.
In the present invention, the version information generally comprises system version number, module title and module SQL version number.
And in order to ensure the normal upgrading of next data base, the effective management to increment SQL files is realized, perform record dress
Put 40 to perform this newly-increased SQL file as pre-execution file, and record whole implementation procedure and result, be next time
The upgrading of data base provides reference, and the SQL files execution information includes system version number, module SQL version number, module name
Title, SQL filenames, execution time and execution user profile.
It is pointed out that in the present invention version information and SQL files execution information include but is not limited to it is above-mentioned interior
Hold, for example, database upgrade is carried out to the junior unit in a certain module, it is possible to which the title of this junior unit or code name are added
Version information, and for the name of version number, except can carry out it is self-defined in addition to, such as last time is from 1.0 edition upgradings to 1.1
Version, and this is from 1.1 edition upgradings to 1.2 versions.Can also be other definition modes, such as process of the user to upgrading
In version information be controlled, carry out the name of version number using other version names, even system according to the time from
Version information is defined, such as the time is in November, 2011 after last time upgrading, then the version information after upgrading is 2011.11, and this
Secondary update time is 2 months 2013, then the version information after current upgrading is 2013.02.
Therefore, the present invention is not specifically limited to the naming method of system version number and module release number, and the two
Naming method can be with identical, it is also possible to different.
And during this database upgrade, except will perform in the SQL files of increase and data base one by one
SQL files contrasted outside, other contrasts and screening mode can also be used, for example, be to reduce screening time, be improved
Screening efficiency, the version information of SQL files newest in data base is analyzed, minimum in the SQL files that then will increase
The version information of SQL files avoid invalid contrast and screening in contrast, so, improve screening efficiency.
A newest SQL file version informations logging modle can be increased in the present system even, carried out in upgrading every time
After database upgrade, the version information of the pre-execution SQL file for performing is recorded and replaced in the data base of last time most
The version information of new SQL files, so, the SQL files of increase only need to enter with newest SQL file version informations logging modle
Row contrast, you can rapid screening goes out newly-increased SQL files, it is possible to increase screening efficiency.
The present invention is not specifically limited to the screening mode of screening plant 30, can typically be selected to improve screening efficiency
Mode.
In a kind of specific embodiment, the name format of the SQL files is system version number _ module release number _ mould
Block name SQL.Unification is fixed by the name format by SQL files, is easy to the management of SQL files, and can be using automatic
Sortord, such as using version information arrangement mode from big to small, automatically by the version of executed SQL files in data base
Information is placed on the position for most starting.
Further, according to version information in each item list the SQL files of newest version, so carry out contrast sieve
Choosing is to only need to be contrasted with the version information of very limited amount of SQL files (at most compare i.e. with each in version information
Can), improve screening efficiency.
In the present invention, the name format of SQL files can also be other name sides in addition to for above-mentioned mode
Formula, or other version information projects are to increase, the present invention is not especially limited to this.
In sum, the system and method for supporting increment upgrade database provided in an embodiment of the present invention, by performing
Before newly-increased SQL files, the version information of the SQL files performed in comparing data base, if performing in data base
SQL files in non-existent version information, the SQL files are performed for pre-execution SQL file, otherwise do not perform, realize
Reasonable effective management to database version information, the SQL files that recording increment is performed, SQL file implementing results, and can basis
Record information obtains which file is each module specifically perform.
Above the system and method for supporting increment upgrade database provided by the present invention are described in detail.Herein
In apply specific case the principle and embodiment of the present invention be set forth, the explanation of above example is only intended to side
Assistant solves the method for the present invention and its core concept.It should be pointed out that for those skilled in the art, not
On the premise of departing from the principle of the invention, some improvement and modification can also be carried out to the present invention, these improve and modification also falls into
In the protection domain of the claims in the present invention.
Claims (10)
1. a kind of method for supporting increment upgrade database, it is characterised in that include：
The version information of the SQL files performed in analyzing data base；
SQL files in parsing specified folder, and obtain the version information of SQL files in the specified folder；
Filter out in the SQL files in the specified folder with the SQL file version informations that performed in the data base not
Same SQL files, as pre-execution SQL file；
The pre-execution SQL file is performed, and records the SQL file execution informations of the pre-execution SQL file.
2. the method for supporting increment upgrade database as claimed in claim 1, it is characterised in that the version information includes system
Version number, module title and module SQL version number.
3. the system for supporting increment upgrade database as claimed in claim 1, it is characterised in that the SQL files execution information
Including system version number, module SQL version number, module title, SQL filenames, execution time and execution user profile.
4. the system that increment upgrade database is supported as described in claim 1-3 any one, it is characterised in that the SQL is literary
The name format of part is system version number _ module release number _ module title .SQL.
5. the method for supporting increment upgrade database as claimed in claim 4, it is characterised in that described to filter out the specified text
The SQL file different from the SQL file version informations performed in the data base in SQL files in part folder, as holding in advance
Row SQL files, including：
Filter out in the SQL files in the specified folder, with the SQL file different system versions that performed in the data base
This number, or disparate modules SQL version numbers, or the SQL files of disparate modules title are used as pre-execution SQL file.
6. the method for supporting as claimed in claim 5 increment upgrade database, it is characterised in that the execution pre-execution
SQL files, including：
According to the version number of the pre-execution SQL file, the ascending execution pre-execution SQL file.
7. a kind of system for supporting increment upgrade database, it is characterised in that include：
Analytical equipment, the version information of the SQL files for performing that the analytical equipment is used in analytical database；
Resolver, the resolver obtain the specified file for parsing to the SQL files in specified folder
The version information of the SQL files in folder；
Screening plant, the screening plant are connected with the analytical equipment, the resolver, for filtering out the specified text
In part folder, the SQL file different from the version information of the SQL files for performing in the data base is used as pre-execution SQL text
Part；
Recording equipment is performed, the execution recording equipment is connected with the screening plant, for performing the pre-execution SQL text
Part, and record the SQL file execution informations of the pre-execution SQL file.
8. the system for supporting increment upgrade database as claimed in claim 7, it is characterised in that the version information includes system
Version number, module title and module SQL version number.
9. the system for supporting increment upgrade database as claimed in claim 7, it is characterised in that the SQL files execution information
Including system version number, module SQL version number, module title, SQL filenames, execution time and execution user profile.
10. the system for supporting increment upgrade database as claimed in claim 9, it is characterised in that the title lattice of the SQL files
Formula is system version number _ module release number _ module title .SQL.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611129545.8A CN106599167B (en) | 2016-12-09 | 2016-12-09 | System and method for supporting increment updating of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611129545.8A CN106599167B (en) | 2016-12-09 | 2016-12-09 | System and method for supporting increment updating of database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106599167A true CN106599167A (en) | 2017-04-26 |
| CN106599167B CN106599167B (en) | 2020-11-20 |
Family
ID=58598218
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611129545.8A Active CN106599167B (en) | 2016-12-09 | 2016-12-09 | System and method for supporting increment updating of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106599167B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107357907A (en) * | 2017-07-17 | 2017-11-17 | 郑州云海信息技术有限公司 | A kind of database upgrade method and device for supporting cross-version |
| CN109947457A (en) * | 2018-12-29 | 2019-06-28 | 上海寰创通信科技股份有限公司 | A kind of database upgrade method |
| CN110865828A (en) * | 2018-08-28 | 2020-03-06 | 成都鼎桥通信技术有限公司 | Data upgrading method, device, equipment and computer readable storage medium |
| CN111459887A (en) * | 2020-03-30 | 2020-07-28 | 北京百度网讯科技有限公司 | Resource screening method and device, electronic equipment and storage medium |
| CN112486530A (en) * | 2020-11-20 | 2021-03-12 | 杭州电魂网络科技股份有限公司 | Game database storage table upgrading method and system |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1971556A (en) * | 2005-11-26 | 2007-05-30 | 华为技术有限公司 | System and method to realize database upgrading in background management system |
| CN103294724A (en) * | 2012-03-05 | 2013-09-11 | 百度在线网络技术（北京）有限公司 | Method for managing database structures and system for method |
| WO2014060230A1 (en) * | 2012-10-15 | 2014-04-24 | Here Global B.V. | Map update scripts with tree edit operations |
| CN104426924A (en) * | 2013-08-21 | 2015-03-18 | 腾讯科技（深圳）有限公司 | Method, apparatus, client, server and system for updating application software |
| CN104899066A (en) * | 2015-06-19 | 2015-09-09 | 青岛海信移动通信技术股份有限公司 | Method and device for continuous upgrading |
| CN105373631A (en) * | 2015-12-18 | 2016-03-02 | 河南思维自动化设备股份有限公司 | SQLSever-based automatic upgrading method for database structure |
| US20160188316A1 (en) * | 2014-12-31 | 2016-06-30 | Guangzhou Ucweb Computer Technology Co., Ltd. | Method and apparatus for software update management |
| CN106201614A (en) * | 2016-07-11 | 2016-12-07 | 天津中兴智联科技有限公司 | A kind of universal method and system that multiple similar software can be carried out chain type upgrading |
-
2016
- 2016-12-09 CN CN201611129545.8A patent/CN106599167B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1971556A (en) * | 2005-11-26 | 2007-05-30 | 华为技术有限公司 | System and method to realize database upgrading in background management system |
| CN103294724A (en) * | 2012-03-05 | 2013-09-11 | 百度在线网络技术（北京）有限公司 | Method for managing database structures and system for method |
| WO2014060230A1 (en) * | 2012-10-15 | 2014-04-24 | Here Global B.V. | Map update scripts with tree edit operations |
| CN104426924A (en) * | 2013-08-21 | 2015-03-18 | 腾讯科技（深圳）有限公司 | Method, apparatus, client, server and system for updating application software |
| US20160188316A1 (en) * | 2014-12-31 | 2016-06-30 | Guangzhou Ucweb Computer Technology Co., Ltd. | Method and apparatus for software update management |
| CN104899066A (en) * | 2015-06-19 | 2015-09-09 | 青岛海信移动通信技术股份有限公司 | Method and device for continuous upgrading |
| CN105373631A (en) * | 2015-12-18 | 2016-03-02 | 河南思维自动化设备股份有限公司 | SQLSever-based automatic upgrading method for database structure |
| CN106201614A (en) * | 2016-07-11 | 2016-12-07 | 天津中兴智联科技有限公司 | A kind of universal method and system that multiple similar software can be carried out chain type upgrading |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107357907A (en) * | 2017-07-17 | 2017-11-17 | 郑州云海信息技术有限公司 | A kind of database upgrade method and device for supporting cross-version |
| CN110865828A (en) * | 2018-08-28 | 2020-03-06 | 成都鼎桥通信技术有限公司 | Data upgrading method, device, equipment and computer readable storage medium |
| CN109947457A (en) * | 2018-12-29 | 2019-06-28 | 上海寰创通信科技股份有限公司 | A kind of database upgrade method |
| CN111459887A (en) * | 2020-03-30 | 2020-07-28 | 北京百度网讯科技有限公司 | Resource screening method and device, electronic equipment and storage medium |
| CN111459887B (en) * | 2020-03-30 | 2023-08-11 | 北京百度网讯科技有限公司 | Resource screening method and device, electronic equipment and storage medium |
| CN112486530A (en) * | 2020-11-20 | 2021-03-12 | 杭州电魂网络科技股份有限公司 | Game database storage table upgrading method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106599167B (en) | 2020-11-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106599167A (en) | System and method capable of supporting incremental upgrading of database | |
| US8869111B2 (en) | Method and system for generating test cases for a software application | |
| US20080306986A1 (en) | Migration of Legacy Applications | |
| US20060251073A1 (en) | Methods and apparatus for transferring data | |
| WO2012034440A1 (en) | Method and device for generating database upgrading script | |
| CN109947433A (en) | A kind of generation method of small routine, update method and device | |
| US8607217B2 (en) | Incremental upgrade of entity-relationship systems | |
| CN104133772A (en) | Automatic test data generation method | |
| CN103823797A (en) | FTP (file transfer protocol) based real-time industry database data synchronization system | |
| EP1587246A2 (en) | Framework for template-based retrieval of information from managed entities in a communication network | |
| CN104915262A (en) | Calibration system and method based on EXCEL data structure | |
| CN101221564A (en) | Universal independent data acquisition method | |
| US20200012661A1 (en) | Synchronizing resource type and property structures | |
| CN104679500A (en) | Automatic generation realizing method and device for entity classes | |
| US10963227B2 (en) | Technique for transforming a standard messaging component to a customized component | |
| WO2002046909A1 (en) | Automatically deploy and upgrade an application based on markup language application definition | |
| US9934216B2 (en) | Schema validation for metadata builder | |
| CN115510361A (en) | Data chart page generation method based on visual configuration and related equipment | |
| CN105630997A (en) | Data parallel processing method, device and equipment | |
| CN105740997A (en) | Method and device for controlling task flow, and database management system | |
| CN113792026A (en) | Deployment method and device of database script and computer readable storage medium | |
| US20080022258A1 (en) | Custom database system and method of building and operating the same | |
| US8631393B2 (en) | Custom database system and method of building and operating the same | |
| CN112817931A (en) | Method and device for generating incremental version file | |
| CN108647018A (en) | Can live preview code generating 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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20201102 Address after: 215100 No. 1 Guanpu Road, Guoxiang Street, Wuzhong Economic Development Zone, Suzhou City, Jiangsu Province Applicant after: SUZHOU LANGCHAO INTELLIGENT TECHNOLOGY Co.,Ltd. Address before: 450018 Henan province Zheng Dong New District of Zhengzhou City Xinyi Road No. 278 16 floor room 1601 Applicant before: ZHENGZHOU YUNHAI INFORMATION TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |