CN1971556A - System and method to realize database upgrading in background management system - Google Patents
System and method to realize database upgrading in background management system Download PDFInfo
- Publication number
- CN1971556A CN1971556A CNA2005101018592A CN200510101859A CN1971556A CN 1971556 A CN1971556 A CN 1971556A CN A2005101018592 A CNA2005101018592 A CN A2005101018592A CN 200510101859 A CN200510101859 A CN 200510101859A CN 1971556 A CN1971556 A CN 1971556A
- Authority
- CN
- China
- Prior art keywords
- database
- version
- upgrading
- data
- sql script
- 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
Images
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/211—Schema design and management
- G06F16/213—Schema design and management with details for schema evolution support
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The invention relates to a system to upgrade the database in the background management system that includes: vision recognition subsystem, vision upgrading subsystem and description/knowledge system, the vision recognition subsystem generates and maintains the description/knowledge of various vision databases; the vision upgrading subsystem uses said description/knowledge to upgrade the database; the description/knowledge system consists of several describing files, and is the input of the vision upgrading subsystem, and is the output of the vision recognition subsystem. The invention also relates to a corresponding database upgrading method, it includes: the vision recognition subsystem generates and maintains the steps of description/knowledge of various vision databases, and the vision subsystem uses said description/knowledge to upgrade the database. The invention can be used in the embedded communication system, it can upgrade intelligentizely and automatically, recognize the original vision and the present vision automatically, and the database in the background management system can be upgraded smoothly with the software vision.
Description
Technical field
The present invention relates to a kind of system and method for database upgrade, relate in particular to a kind of system and method for fulfillment database upgrading in background management system.
Background technology
Software product is stopping all there be possibility of edition upgrading before the exploitation fully, and because of various reasons, requirement is upgraded to highest version by lowest version.Generally all be to adopt a kind of like this architecture of AM/BAM in embedded communication system, the foreground is the embedded system main frame, and the backstage is a Win NT/2000 management system, uses relational database and preserve host data in background management system.When the background management system software release upgrade, the database of the respective version that is necessary to upgrade makes things convenient for edition upgrading.
Existing database upgrade is after the background management system software release upgrade is installed, and creates database again, and all need be in background management system client manual configuration again with professional tables of data data relevant or that need to customize.Owing to can not upgrade with the software version corresponding database of background management system thereupon, but will create database again, so the business datum that disposes in the original version lost thereupon also, this has brought a lot of inconvenience for the foreground host data configuration.So there is following shortcoming in prior art:
1. under the more situation of business datum table, reset Configuration Data and to expend great amount of manpower;
2. the configuration data of reduction original version mismatches the rate height, and some tables of data leakiness is joined, thereby has increased the difficulty of development﹠ testing personnel positioning problems;
3. the time cost that spent of resetting Configuration Data is long, is unfavorable for quick customer in response demand;
4. do not accomplish the seamless upgrade of database with backstage management system software version.
Summary of the invention
Technical matters to be solved by this invention is to provide a kind of system and method that is applied to the upgrading of fulfillment database in background management system in the embedded communication system, it can realize intellectuality and automatic updating, do not need the people to participate in, can discern source version and purpose version automatically, the database of realization background management system is smooth upgrade with software release upgrade.
For solving the problems of the technologies described above, the technical solution adopted in the present invention is: the system that a kind of fulfillment database upgrading in background management system is provided, it comprises version recognition subsystem, edition upgrading subsystem and description/knowledge system, the description/knowledge in wherein said version recognition subsystem generation and existing each edition data storehouse of maintenance software; Described edition upgrading subsystem utilizes described description/knowledge that database is upgraded; Described description/knowledge system is made up of some description document, is the input of edition upgrading subsystem, the output of version recognition subsystem.
Further improvement in the technical proposal is: described description document comprises upgrading SQL script file between DDF, database version description document, database version identification file, database table description document and database version.
Described description document also comprises pre-service SQL script file and aftertreatment SQL script file.
For solving above-mentioned another technical matters, the technical solution adopted in the present invention is: a kind of method of fulfillment database upgrading in background management system is provided, and it may further comprise the steps: the description/knowledge in generation of version recognition subsystem and existing each edition data storehouse of maintenance software; The edition upgrading subsystem utilizes foregoing description/knowledge that database is upgraded.
Further improvement in the technical proposal is: described version recognition subsystem produces and the description/knowledge in existing each edition data storehouse of maintenance software may further comprise the steps:
A) the version recognition subsystem reads the database information that all need upgrade data from DDF;
B) the version recognition subsystem generates the database version description document;
C) the version recognition subsystem generates database version identification file;
E) the version recognition subsystem generates upgrading SQL script file between database version;
F) the version recognition subsystem generates the database table description document;
G) whether the upgrading relation constitutes directed acyclic graph between the version in the version recognition subsystem inspection database version description document, if constitute directed acyclic graph, then compares difference in version, and the output detailed report if do not constitute, then finishes version identification.
Described step c) and e) between also comprise step d), be whether table in the version recognition subsystem judgment data storehouse exists constraint, if there is constraint, then the version recognition subsystem generates the pre-service SQL script file and the aftertreatment SQL script file of database version, if there is not the then direct execution in step e of constraint).
Further improvement in the technical proposal is: described edition upgrading subsystem utilizes foregoing description/knowledge that database is upgraded and may further comprise the steps:
H) the edition upgrading subsystem reads the database information that all need upgrade data from DDF;
I) the edition upgrading subsystem is from the database version description document, all version informations of reading database;
I) the edition upgrading subsystem is discerned file according to database version, and reading database version feature information is according to the source version and the purpose version of version feature information Recognition database;
K) the edition upgrading subsystem is from the database version description document, and the upgrading relation between the reading database version is analyzed the shortest upgrading path that obtains from the source version to the purpose version;
L) the edition upgrading subsystem is carried out the upgrading SQL script file between version along the shortest upgrading path from the source version to the purpose version, adjusts the list structure and the data in edition data storehouse, source;
M) the edition upgrading subsystem reads the importing data mode of all tables from the database table description document, according to importing data mode, the data of each table is imported purpose edition data storehouse by edition data storehouse, source.
Described step m) further comprise step n), if promptly should have constraint by table, then before importing data, carry out the pre-service SQL script file of this table, after importing data, carry out the aftertreatment SQL script file of this table.
Step k) the shortest upgrading path of described analysis from the source version to the purpose version adopts and asks the directed acyclic graph certain source point to the algorithm of all the other each summit shortest paths.
The invention has the beneficial effects as follows: because the present invention adopts version recognition subsystem, edition upgrading subsystem and description/knowledge system in conjunction with the database upgrade that is implemented in the background management system, therefore it can realize intellectuality and automatic updating, do not need the people to participate in, can discern source version and purpose version automatically, the database of realization background management system is smooth upgrade with software release upgrade, should have good expandability based on the database upgrade method system of describing that makes; In addition, the present invention can be integrated in the mounting disc of Backend Administration Module software, and the upgrading Installation Options is provided, upgrade data when Backend Administration Module software is installed, and the inspection work of most consistance correctness of database upgrade is finished by system, thereby reduces exploitation/maintainer's work; Moreover, because the shortest upgrading path of analysis of the present invention from the source version to the purpose version adopts is to ask the directed acyclic graph certain source point to the algorithm of all the other each summit shortest paths, therefore in the database upgrade process, can determine upgrading path and strategy from the source version to the purpose version, when the lowest version from background management system software was upgraded to highest version, it can be sought a upgrading path the shortest database is upgraded.
Description of drawings
Fig. 1 is the system architecture diagram of the present invention's fulfillment database upgrading in background management system.
Fig. 2 is the version recognition subsystem work synoptic diagram of system shown in Figure 1.
Fig. 3 is the edition upgrading subsystem work synoptic diagram of system shown in Figure 1.
Fig. 4 is that the present invention analyzes the directed acyclic graph that algorithm adopted of source version to the purpose version upgrade path.
Embodiment
See also Fig. 1, the system of the present invention's fulfillment database upgrading in background management system comprises version recognition subsystem, edition upgrading subsystem and description/knowledge system, wherein description/the knowledge in generation of version recognition subsystem and existing each edition data storehouse of maintenance software; The edition upgrading subsystem utilizes foregoing description/knowledge that database is upgraded; Description/knowledge system is made up of some description document, it is the input of edition upgrading subsystem, the output of version recognition subsystem, description document comprises: upgrading SQL script file between DDF, database version description document, database version identification file, pre-service SQL script file, aftertreatment SQL script file, database table description document and database version.Wherein:
1) DDF
General introduction: describe the data of database that to upgrade in the escalation process.Whole edition upgrading system just uses this DDF.
2) database version description document
General introduction: all versions of descriptive data base and the relation of the upgrading between version.Each database that will upgrade has this database version description document.
3) database version identification file
General introduction: preserve the database information of this version, comprise all table information in the database,, be used to discern each version as list structure definition (essential, all tables), field implication (optional, host service table), field enumerated value implication (optional, host service table).Each version of database has this database version identification file.
4) pre-service SQL script file
General introduction: pre-service SQL script file is divided into: database pre-service SQL script file, table pre-service SQL script file.Each database of each version has a database pre-service SQL script file at most, and it is carried out before database imports data, and any special processing that need carry out before database imports data can be write the SQL script in this document.Each table of each database of each version has a table pre-service SQL script file at most, and it is carried out before importing these table data, and any special processing that need carry out before importing these table data can be write the SQL script in this document.
5) aftertreatment SQL script file
General introduction: aftertreatment SQL script file is divided into: database aftertreatment SQL script file, table aftertreatment SQL script file.Each database of each version has a database aftertreatment SQL script file at most, and it is carried out after database imports data, and any special processing that need carry out after database imports data can be write the SQL script in this document.Each table of each database of each version has a table aftertreatment SQL script file at most, and it is carried out after importing these table data, and any special processing that need carry out after these table data of importing can be write the SQL script in this document.
6) upgrading SQL script file between database version
General introduction: be used to write the upgrade script that the relative source of purpose version version changes.If the relative source of purpose version version has increased table, should write the script of establishment table.If the relative source of purpose version version has reduced table, should write the script of delete list.If between two versions, certain list structure (comprising Field Definition, the enumerated value definition) changes, and should write upgrade script for it, is responsible for adjustment form structure and data, makes it consistent with redaction.
7) database table description document
General introduction: describe in the escalation process importing data mode of all tables in the database.Each database that will upgrade has this database table description document.
Table in the database roughly is divided into: a, the default data is arranged, can not revise/delete the default data or increase new data; B, the default data is arranged, can not revise/delete the default data but may increase new data; C, the default data is arranged, may revise/delete the default data but can not increase new data; D, the default data is arranged, may revise/delete the default data or increase new data; E, do not have the default data, may increase new data.Correspondingly, the importing data mode is divided into: the 0 (default data that keeps redaction fully, be fit to type a), 1 (imports the data in the early version fully, be fit to type d and e), 2 (self-defined SQL script mode relatively flexibly, can be fit to type b and C and special circumstances that some may also not considered).
The method of the present invention's fulfillment database upgrading in background management system comprises that the version recognition subsystem produces and the step of the description/knowledge in existing each edition data storehouse of maintenance software and the step that the edition upgrading subsystem utilizes foregoing description/knowledge that database is upgraded.
See also Fig. 2, the version recognition subsystem of the present invention system of fulfillment database upgrading in background management system is output with description/knowledge system, correctness, the consistance being responsible for generating description document and checking description document.The version recognition subsystem produces and the description/knowledge in existing each edition data storehouse of maintenance software may further comprise the steps:
A) the version recognition subsystem reads the database information that all need upgrade data from DDF;
B) the version recognition subsystem generates the database version description document;
C) the version recognition subsystem generates database version identification file;
D) whether the table in the version recognition subsystem judgment data storehouse exists constraint, and as if there being constraint, then the version recognition subsystem generates the pre-service SQL script file and the aftertreatment SQL script file of database version, if there is not the then direct execution in step e of constraint);
E) the version recognition subsystem generates upgrading SQL script file between database version;
F) the version recognition subsystem generates the database table description document;
G) whether the upgrading relation constitutes directed acyclic graph between the version in the version recognition subsystem inspection database version description document, if constitute directed acyclic graph, then compares difference in version, and the output detailed report if do not constitute, then finishes version identification.
See also Fig. 3, the description document that the edition upgrading subsystem of the present invention system of fulfillment database upgrading in background management system utilizes the version recognition subsystem to generate is upgraded to database, and the edition upgrading subsystem utilizes foregoing description/knowledge that database is upgraded and may further comprise the steps:
H) the edition upgrading subsystem reads the database information that all need upgrade data from DDF;
I) the edition upgrading subsystem is from the database version description document, all version informations of reading database;
J) the edition upgrading subsystem is discerned file according to database version, and reading database version feature information is according to the source version and the purpose version of version feature information Recognition database;
K) the edition upgrading subsystem is from the database version description document, and the upgrading relation between the reading database version is analyzed the shortest upgrading path that obtains from the source version to the purpose version;
L) the edition upgrading subsystem is carried out the upgrading SQL script file between version along the shortest upgrading path from the source version to the purpose version, adjusts the list structure and the data in edition data storehouse, source;
M) the edition upgrading subsystem is from the database table description document, read the importing data mode of all tables, according to importing data mode, the data of each table are imported purpose edition data storehouse by edition data storehouse, source, if should have constraint by table, then before importing data, carry out the pre-service SQL script file of this table, after importing data, carry out the aftertreatment SQL script file of this table.
Step k wherein) the shortest upgrading path of described analysis from the source version to the purpose version adopts and asks the directed acyclic graph certain source point to the algorithm of all the other each summit shortest paths.Seeing also Fig. 4, is directed acyclic graph of the present invention, and wherein V1, V2, V3, V4, V5, V6 constitute the version of existing software.Vi (i=1,2,3, the 4...) vertex set in the formation directed acyclic graph.Representing can be upgraded to another version from a version with oriented arc connection between the summit, according to the description in the technical scheme, promptly is to have the upgrading relation between two versions.For example, be upgraded to V6 from version V1 following several upgrading pathes arranged:
1)?V1?V2?V3?V4?V5?V6
2)?V1?V2?V3?V5?V6
3)?V1?V2?V3?V6
4)?V1?V3?V4?V5?V6
5)?V1?V3?V5?V6
6)?V1?V3?V6
Can analyze shortest path according to above-mentioned directed acyclic graph shortest path first is V1 V3 V6, is the shortest path that database version V1 is upgraded to V6.
Claims (16)
1, a kind of system of fulfillment database upgrading in background management system, it is characterized in that: it comprises version recognition subsystem, edition upgrading subsystem and description/knowledge system, the description/knowledge in wherein said version recognition subsystem generation and existing each edition data storehouse of maintenance software; Described edition upgrading subsystem utilizes described description/knowledge that database is upgraded; Described description/knowledge system is made up of some description document, is the input of edition upgrading subsystem, the output of version recognition subsystem.
2. the system of fulfillment database upgrading in background management system as claimed in claim 1 is characterized in that: described description document comprises upgrading SQL script file between DDF, database version description document, database version identification file, database table description document and database version.
3. the system of fulfillment database upgrading in background management system as claimed in claim 2, it is characterized in that: described description document also comprises pre-service SQL script file and aftertreatment SQL script file.
4. the system of fulfillment database upgrading in background management system as claimed in claim 3, it is characterized in that: described pre-service SQL script file comprises database pre-service SQL script file and table pre-service SQL script file, each database of each version has this database pre-service SQL script file at most, it is carried out before database imports data, the any special processing that need before database imports data, carry out, can in this document, write the SQL script, each table of each database of each version has a table pre-service SQL script file at most, it is carried out before importing these table data, the any special processing that need carry out before importing these table data can be write the SQL script in this document.
5. the system of fulfillment database upgrading in background management system as claimed in claim 3, it is characterized in that: described aftertreatment SQL script file comprises database aftertreatment SQL script file and table aftertreatment SQL script file, each database of each version has a database aftertreatment SQL script file at most, it is carried out after database imports data, the any special processing that need after database imports data, carry out, can in this document, write the SQL script, each table of each database of each version has a table aftertreatment SQL script file at most, it is carried out after importing these table data, the any special processing that need carry out after these table data of importing can be write the SQL script in this document.
6. the system of fulfillment database upgrading in background management system as claimed in claim 1, it is characterized in that: described DDF is used to describe the data of database that escalation process will be upgraded, this DDF of whole edition upgrading system's use.
7. the system of fulfillment database upgrading in background management system as claimed in claim 1, it is characterized in that: described database version description document is used for all versions and the relation of the upgrading between version of descriptive data base, and each database that will upgrade has this database version description document.
8. the system of fulfillment database upgrading in background management system as claimed in claim 1, it is characterized in that: described database version identification file is used to preserve the database information of this version, comprise all table information in the database, each version of database has this database version identification file.
9. the system of fulfillment database upgrading in background management system as claimed in claim 1 is characterized in that: upgrading SQL script file is used to write the upgrade script that the relative source of purpose version version changes between described database version.
10. the system of fulfillment database upgrading in background management system as claimed in claim 1, it is characterized in that: described database table description document is used for describing escalation process, the importing data mode of all tables in the database, each database that will upgrade have this database table description document.
11. the method for a fulfillment database upgrading in background management system is characterized in that may further comprise the steps:
Description/the knowledge in generation of version recognition subsystem and existing each edition data storehouse of maintenance software;
The edition upgrading subsystem utilizes foregoing description/knowledge that database is upgraded.
12. the method for fulfillment database upgrading in background management system as claimed in claim 11 is characterized in that: described version recognition subsystem produces and the description/knowledge in existing each edition data storehouse of maintenance software may further comprise the steps:
A) the version recognition subsystem reads the database information that all need upgrade data from DDF;
B) the version recognition subsystem generates the database version description document;
C) the version recognition subsystem generates database version identification file;
E) the version recognition subsystem generates upgrading SQL script file between database version;
F) the version recognition subsystem generates the database table description document;
G) whether the upgrading relation constitutes directed acyclic graph between the version in the version recognition subsystem inspection database version description document, if constitute directed acyclic graph, then compares difference in version, and the output detailed report if do not constitute, then finishes version identification.
13. the method for fulfillment database upgrading in background management system as claimed in claim 12, it is characterized in that: described step c) and e) between also comprise step d), be whether table in the version recognition subsystem judgment data storehouse exists constraint, if there is constraint, then the version recognition subsystem generates the pre-service SQL script file and the aftertreatment SQL script file of database version, if there is not the then direct execution in step e of constraint).
14. the method for fulfillment database upgrading in background management system as claimed in claim 11, it is characterized in that: described edition upgrading subsystem utilizes foregoing description/knowledge that database is upgraded and may further comprise the steps:
H) the edition upgrading subsystem reads the database information that all need upgrade data from DDF;
I) the edition upgrading subsystem is from the database version description document, all version informations of reading database;
J) the edition upgrading subsystem is discerned file according to database version, and reading database version feature information is according to the source version and the purpose version of version feature information Recognition database;
K) the edition upgrading subsystem is from the database version description document, and the upgrading relation between the reading database version is analyzed the shortest upgrading path that obtains from the source version to the purpose version;
1) the edition upgrading subsystem is carried out the upgrading SQL script file between version along the shortest upgrading path from the source version to the purpose version, adjusts the list structure and the data in edition data storehouse, source;
M) the edition upgrading subsystem reads the importing data mode of all tables from the database table description document, according to importing data mode, the data of each table is imported purpose edition data storehouse by edition data storehouse, source.
15. the method for fulfillment database upgrading in background management system as claimed in claim 14, it is characterized in that: described step m) further comprise step n), if promptly should have constraint by table, then before importing data, carry out the pre-service SQL script file of this table, after importing data, carry out the aftertreatment SQL script file of this table.
16. the method for fulfillment database upgrading in background management system as claimed in claim 14 is characterized in that: step k) the shortest upgrading path of described analysis from the source version to the purpose version adopts and asks the directed acyclic graph certain source point to the algorithm of all the other each summit shortest paths.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005101018592A CN100426291C (en) | 2005-11-26 | 2005-11-26 | System and method to realize database upgrading in background management system |
| PCT/CN2006/003103 WO2007059698A1 (en) | 2005-11-26 | 2006-11-17 | System and method for realizing database upgrading in background management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005101018592A CN100426291C (en) | 2005-11-26 | 2005-11-26 | System and method to realize database upgrading in background management system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1971556A true CN1971556A (en) | 2007-05-30 |
| CN100426291C CN100426291C (en) | 2008-10-15 |
Family
ID=38066916
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2005101018592A Active CN100426291C (en) | 2005-11-26 | 2005-11-26 | System and method to realize database upgrading in background management system |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN100426291C (en) |
| WO (1) | WO2007059698A1 (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012083613A1 (en) * | 2010-12-20 | 2012-06-28 | 中兴通讯股份有限公司 | Multiversion upgrade method and apparatus for user self-defined performance indicator |
| CN103019660A (en) * | 2011-09-20 | 2013-04-03 | 佳都新太科技股份有限公司 | Realization of web application data source delay binding |
| CN103324716A (en) * | 2013-06-25 | 2013-09-25 | 四川九洲电器集团有限责任公司 | Application database updating method based on Android system |
| CN103810100A (en) * | 2013-12-02 | 2014-05-21 | 中标软件有限公司 | Software evolutionary trend analysis system and method |
| CN104572644A (en) * | 2013-10-10 | 2015-04-29 | 北京大学 | Database updating device and database updating method |
| CN104881455A (en) * | 2015-05-20 | 2015-09-02 | 深圳市酷开网络科技有限公司 | Structural difference processing method and system based on MYSQL |
| CN106325902A (en) * | 2015-06-24 | 2017-01-11 | 中兴通讯股份有限公司 | Database software upgrading detection method and apparatus |
| CN106599167A (en) * | 2016-12-09 | 2017-04-26 | 郑州云海信息技术有限公司 | System and method capable of supporting incremental upgrading of database |
| CN107357907A (en) * | 2017-07-17 | 2017-11-17 | 郑州云海信息技术有限公司 | A kind of database upgrade method and device for supporting cross-version |
| CN107861737A (en) * | 2017-11-06 | 2018-03-30 | 国云科技股份有限公司 | A kind of database version moving method of large scale system |
| CN108268275A (en) * | 2017-06-12 | 2018-07-10 | 平安普惠企业管理有限公司 | Software version control method and software version control device |
| CN110865829A (en) * | 2018-08-28 | 2020-03-06 | 北京京东金融科技控股有限公司 | Database upgrading method, system, device and storage medium |
| CN111506779A (en) * | 2020-04-20 | 2020-08-07 | 东云睿连(武汉)计算技术有限公司 | Object version and associated information management method and system facing data processing |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110618829B (en) * | 2019-09-20 | 2023-04-28 | 中国银行股份有限公司 | Service data checking method and system for upgrading database system |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH09130426A (en) * | 1995-11-06 | 1997-05-16 | Nippon Telegr & Teleph Corp <Ntt> | Information providing system |
| JP4573126B2 (en) * | 2003-09-24 | 2010-11-04 | ソニー株式会社 | Database schema update method, communication terminal device, update information provision method, update information provision device, database schema update program, and update information provision program |
| US7562357B2 (en) * | 2004-03-08 | 2009-07-14 | Microsoft Corporation | Relational database schema version management |
| CN1280761C (en) * | 2004-05-18 | 2006-10-18 | 中兴通讯股份有限公司 | Method for realizing relation-database automatic upgrading in communication apparatus |
| CN100556211C (en) * | 2004-06-22 | 2009-10-28 | 中兴通讯股份有限公司 | A kind of upgrade method of mobile communication network management system |
-
2005
- 2005-11-26 CN CNB2005101018592A patent/CN100426291C/en active Active
-
2006
- 2006-11-17 WO PCT/CN2006/003103 patent/WO2007059698A1/en active Application Filing
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012083613A1 (en) * | 2010-12-20 | 2012-06-28 | 中兴通讯股份有限公司 | Multiversion upgrade method and apparatus for user self-defined performance indicator |
| CN103019660A (en) * | 2011-09-20 | 2013-04-03 | 佳都新太科技股份有限公司 | Realization of web application data source delay binding |
| CN103324716A (en) * | 2013-06-25 | 2013-09-25 | 四川九洲电器集团有限责任公司 | Application database updating method based on Android system |
| CN103324716B (en) * | 2013-06-25 | 2016-08-10 | 四川九洲电器集团有限责任公司 | A kind of application database update method based on Android system |
| CN104572644B (en) * | 2013-10-10 | 2018-05-22 | 北京大学 | Database update device and database update method |
| CN104572644A (en) * | 2013-10-10 | 2015-04-29 | 北京大学 | Database updating device and database updating method |
| CN103810100A (en) * | 2013-12-02 | 2014-05-21 | 中标软件有限公司 | Software evolutionary trend analysis system and method |
| CN104881455A (en) * | 2015-05-20 | 2015-09-02 | 深圳市酷开网络科技有限公司 | Structural difference processing method and system based on MYSQL |
| CN104881455B (en) * | 2015-05-20 | 2019-01-29 | 深圳市酷开网络科技有限公司 | A kind of architectural difference processing method and system based on MYSQL |
| CN106325902A (en) * | 2015-06-24 | 2017-01-11 | 中兴通讯股份有限公司 | Database software upgrading detection method and apparatus |
| CN106325902B (en) * | 2015-06-24 | 2020-09-15 | 中兴通讯股份有限公司 | Database software upgrade detection method and device |
| CN106599167A (en) * | 2016-12-09 | 2017-04-26 | 郑州云海信息技术有限公司 | System and method capable of supporting incremental upgrading of database |
| CN108268275A (en) * | 2017-06-12 | 2018-07-10 | 平安普惠企业管理有限公司 | Software version control method and software version control device |
| CN107357907A (en) * | 2017-07-17 | 2017-11-17 | 郑州云海信息技术有限公司 | A kind of database upgrade method and device for supporting cross-version |
| CN107861737A (en) * | 2017-11-06 | 2018-03-30 | 国云科技股份有限公司 | A kind of database version moving method of large scale system |
| CN110865829A (en) * | 2018-08-28 | 2020-03-06 | 北京京东金融科技控股有限公司 | Database upgrading method, system, device and storage medium |
| CN110865829B (en) * | 2018-08-28 | 2024-04-16 | 京东科技控股股份有限公司 | Database upgrading method, system, equipment and storage medium |
| CN111506779A (en) * | 2020-04-20 | 2020-08-07 | 东云睿连(武汉)计算技术有限公司 | Object version and associated information management method and system facing data processing |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100426291C (en) | 2008-10-15 |
| WO2007059698A1 (en) | 2007-05-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100426291C (en) | System and method to realize database upgrading in background management system | |
| CN103365683B (en) | For end-to-end patch automation and integrated method and system | |
| US9372784B2 (en) | Test system configuration method and system | |
| CN106649771B (en) | The data model update method and system of database | |
| CN1968154A (en) | System and method for service expansion using plug | |
| ITTO980720A1 (en) | PROCEDURE FOR INSTALLING AND VERIFYING THE SOFTWARE FOR A CUSTOM MADE COMPUTER SYSTEM. | |
| US20080052308A1 (en) | Method and system for realizing automatic adaptation of data object model | |
| US20080010535A1 (en) | Automated and configurable system for tests to be picked up and executed | |
| CN105446868A (en) | System compatibility testing method, test case management method and related devices | |
| CN113515297B (en) | Version updating method and device, electronic equipment and storage medium | |
| CN100556211C (en) | A kind of upgrade method of mobile communication network management system | |
| CN105677465B (en) | The data processing method and device of batch processing are run applied to bank | |
| CN112131116B (en) | Automatic regression testing method for embedded software | |
| CN104915262A (en) | Calibration system and method based on EXCEL data structure | |
| CN105512017A (en) | Database compatibility detection method and device | |
| CN106095678A (en) | Automatization's result inspection method of data bank service operation under windows platform | |
| CN101604290B (en) | Background module test method and backstage module test system | |
| CN111737140A (en) | Interface automation test method, device, equipment and computer readable storage medium | |
| US20030158767A1 (en) | Method and system for adaptive software system interface and external database synchronization | |
| CN112256978B (en) | Data processing method, device and medium based on data model | |
| CN114895955A (en) | Method, device and equipment for controlling metadata version of low-code platform | |
| CN104881455B (en) | A kind of architectural difference processing method and system based on MYSQL | |
| CN112817808B (en) | Computer cluster maintenance task management method and system | |
| WO2005114396A3 (en) | Reporting module definition language system and method | |
| US7325000B2 (en) | System and method for performance measurement quality assurance |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20201211 Address after: 225722 private road, Liuji village, Zhangguo Town, Xinghua City, Taizhou City, Jiangsu Province Patentee after: Jiangsu Zhaoyang heating and Cooling Technology Co.,Ltd. Address before: Unit 2414-2416, main building, no.371, Wushan Road, Tianhe District, Guangzhou City, Guangdong Province Patentee before: GUANGDONG GAOHANG INTELLECTUAL PROPERTY OPERATION Co.,Ltd. Effective date of registration: 20201211 Address after: Unit 2414-2416, main building, no.371, Wushan Road, Tianhe District, Guangzhou City, Guangdong Province Patentee after: GUANGDONG GAOHANG INTELLECTUAL PROPERTY OPERATION Co.,Ltd. Address before: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee before: HUAWEI TECHNOLOGIES Co.,Ltd. |