CN111414173B - Automatic deployment method based on database storage process - Google Patents
Automatic deployment method based on database storage process Download PDFInfo
- Publication number
- CN111414173B CN111414173B CN202010369228.3A CN202010369228A CN111414173B CN 111414173 B CN111414173 B CN 111414173B CN 202010369228 A CN202010369228 A CN 202010369228A CN 111414173 B CN111414173 B CN 111414173B
- Authority
- CN
- China
- Prior art keywords
- small version
- updated
- name
- failure
- package
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/40—Transformation of program code
- G06F8/41—Compilation
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/71—Version control; Configuration management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of information, and provides an automatic deployment method based on a database storage process. The main scheme is as follows: uploading each small version of installation package to a specified directory corresponding to each small version to obtain a small version number; each small version is circularly processed, and a content control file to be updated of the small version is read to obtain an object list; the object list is used as a constraint condition, the objects to be updated are backed up one by one, then the small version is updated, and other programs and the updated objects have calling relation and are marked as invalid packages; checking the failure package, and if the failure package does not exist, completing the processing; if the failure packet exists, performing step 5; and compiling the failure package by pen for circulation to complete the whole deployment.
Description
Technical Field
The invention relates to the technical field of information, and provides an automatic deployment method based on a database storage process.
Background
Technical Field
The release time of the current mass banking core system version is long, the number of manual operation steps is more, the updated content needs to be manually backed up, the requirement on the professional knowledge of operators is very high, and the operation risk is larger.
Business context
Because the core system is a key business system, customer service is suspended during system release, the original manual operation steps are more, the time consumption is long, the customer service time is directly reduced, and the customer experience is affected.
Disclosure of Invention
The invention aims to solve the technical problems that the release time of the prior core system version is long, the number of manual operation steps is more, the updated content needs to be manually backed up, the requirement on the professional knowledge of operators is very high, and the operation risk is larger.
In order to solve the technical problems, the invention adopts the following technical scheme:
an automatic deployment scenario based on a database storage process, comprising the steps of:
step 1: uploading each small version of installation package to a specified directory uniquely corresponding to each small version of installation package, and setting the directory name of the corresponding small version of installation package as a small version number;
step 2: for circularly processing each small version, reading a content control FILE to be updated of the small version, and obtaining an object list containing a control FILE NAME CTRL_FILE, an object TYPE OBJ_TYPE and an object NAME OBJ_NAME;
step 3: the method comprises the steps of backing up an object to be updated one by taking an object TYPE OBJ_TYPE and an object NAME OBJ_NAME of an object list as constraint conditions, updating a small version, and marking the corresponding other programs as failure packages if the called object changes in the calling relation between other programs and the updated object;
step 4: checking the failure package, and if the failure package does not exist, completing the processing; if the failure packet exists, performing step 5;
step 5: and compiling the failure package by pen for circulation to complete the whole deployment.
The technical scheme comprises the following steps: the control file is the execution sequence of the small version of the object to be updated.
Because the invention adopts the technical scheme, the invention has the following beneficial effects:
the technology is directly applied to the application deployment field developed in the process of using the database to store, can be deployed by one key, greatly reduces manual operation steps of a system administrator, effectively reduces misoperation risks, reduces operation time, and simultaneously reduces external service stopping time caused by version deployment.
Detailed Description
The invention provides an automatic deployment scheme based on a database storage process, which comprises the following steps:
step 1: uploading each small version of installation package to a specified directory uniquely corresponding to each small version of installation package, and setting the directory name of the corresponding small version of installation package as a small version number;
step 2: for circularly processing each small version, reading a content control FILE to be updated of the small version, and obtaining an object list containing a control FILE NAME CTRL_FILE, an object TYPE OBJ_TYPE and an object NAME OBJ_NAME; the control file is the execution sequence of the small version of the object to be updated.
Step 3: the method comprises the steps of backing up an object to be updated one by taking an object TYPE OBJ_TYPE and an object NAME OBJ_NAME of an object list as constraint conditions, updating a small version, and marking corresponding other programs as failure packages if the calling relation between other programs and the updated object changes;
taking an oracle database as an example, the backup uses sqlplus to execute the sql statement "select text from user _ source where TYPE = '$obj_type' and name= '$obj_name' order by line", and the executed result file is saved in the backup directory in a redirected manner.
Update execution "sqlplus-s username/password @ instance @ $ CTRL_FILE"
Step 4: checking the failure package, and if the failure package does not exist, completing the processing; if the failure packet exists, performing step 5;
taking the oracle database as an example, checking that the INVALID packet uses sqlplus to execute sql statement "select count (x) from dba_ objects where owner = 'user name' and status= 'INVALID'", if the query result is 0, then there is no INVALID packet; if the number is greater than 0, a invalidation packet exists, a invalidation packet list needs to be generated, and the sql statement "select object_type, object_name from dba_ objects where owner = 'user NAME' and status= 'INVALID' ″ is executed to generate an invalidation object TYPE inobj_type and object NAME inobj_name of the invalidation packet list.
Step 5: and compiling the failure package by pen for circulation to complete the whole deployment.
for loops compiles the failed packets pen by pen. Taking the oracle database as an example, compiling the invalidation packet by using an sqlplus tool, and executing an sql statement of 'alter packet $INOBJ_ NAME complie body' if the invalidation packet type is a packet body; other TYPEs, the sql statement "alter $INOBJ_TYPE $INOBJ_NAME complex" is executed.
Claims (2)
1. An automatic deployment scenario based on a database storage process, comprising the steps of:
step 1: uploading each small version of installation package to a specified directory uniquely corresponding to each small version of installation package, and setting the directory name of the corresponding small version of installation package as a small version number;
step 2: for circularly processing each small version, reading a content control FILE to be updated of the small version, and obtaining an object list containing a control FILE NAME CTRL_FILE, an object TYPE OBJ_TYPE and an object NAME OBJ_NAME;
step 3: the method comprises the steps of backing up an object to be updated one by taking an object TYPE OBJ_TYPE and an object NAME OBJ_NAME of an object list as constraint conditions, updating a small version, and marking corresponding other programs as failure packages if the calling relation between other programs and the updated object changes;
step 4: checking the failure package, and if the failure package does not exist, completing the processing; if the failure packet exists, performing step 5;
step 5: and compiling the failure package by pen for circulation to complete the whole deployment.
2. An automated deployment scenario based on database storage procedures according to claim 1, wherein: the method comprises the following steps: the control file is the execution sequence of the small version of the object to be updated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010369228.3A CN111414173B (en) | 2020-05-04 | 2020-05-04 | Automatic deployment method based on database storage process |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010369228.3A CN111414173B (en) | 2020-05-04 | 2020-05-04 | Automatic deployment method based on database storage process |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111414173A CN111414173A (en) | 2020-07-14 |
| CN111414173B true CN111414173B (en) | 2023-08-11 |
Family
ID=71492291
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010369228.3A Active CN111414173B (en) | 2020-05-04 | 2020-05-04 | Automatic deployment method based on database storage process |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111414173B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2422682A1 (en) * | 2002-03-20 | 2003-09-20 | Bestbuy.Com, Llc | Software building and deployment system and method |
| CN102054050A (en) * | 2011-01-30 | 2011-05-11 | 天津神舟通用数据技术有限公司 | Implementation method of packet mechanism of Shentong database |
| CN104618166A (en) * | 2015-02-16 | 2015-05-13 | 中国农业银行股份有限公司 | Application service deployment method, device and system |
| CN108491214A (en) * | 2018-02-08 | 2018-09-04 | 北京中科江南信息技术股份有限公司 | The management method and management system of application system upgrading deployment |
| CN111026424A (en) * | 2019-12-10 | 2020-04-17 | 中国银行股份有限公司 | A service update method and device |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6874001B2 (en) * | 2001-10-05 | 2005-03-29 | International Business Machines Corporation | Method of maintaining data consistency in a loose transaction model |
| US20030182652A1 (en) * | 2001-12-21 | 2003-09-25 | Custodio Gabriel T. | Software building and deployment system and method |
| US20190163348A1 (en) * | 2017-11-30 | 2019-05-30 | Schneider Electric Software, Llc | Relationship visualizations for multi-dimensional data models |
-
2020
- 2020-05-04 CN CN202010369228.3A patent/CN111414173B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2422682A1 (en) * | 2002-03-20 | 2003-09-20 | Bestbuy.Com, Llc | Software building and deployment system and method |
| CN102054050A (en) * | 2011-01-30 | 2011-05-11 | 天津神舟通用数据技术有限公司 | Implementation method of packet mechanism of Shentong database |
| CN104618166A (en) * | 2015-02-16 | 2015-05-13 | 中国农业银行股份有限公司 | Application service deployment method, device and system |
| CN108491214A (en) * | 2018-02-08 | 2018-09-04 | 北京中科江南信息技术股份有限公司 | The management method and management system of application system upgrading deployment |
| CN111026424A (en) * | 2019-12-10 | 2020-04-17 | 中国银行股份有限公司 | A service update method and device |
Non-Patent Citations (1)
| Title |
|---|
| （美）Bill Pribyl，（美）Steven Feuerstein著；段紫辉等译.Oracle PL/SQL入门.中国电力出版社 ,2002,正文第1页至第8页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111414173A (en) | 2020-07-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210124654A1 (en) | Incremental backup of computer data files | |
| CN101266606B (en) | On-line data migration method based on Oracle database | |
| US8484644B2 (en) | Auto-restart processing in an IMS batch application | |
| US20060048002A1 (en) | Apparatus, system, and method for verifying backup data | |
| CN110597781B (en) | Flash deleting method and system for database | |
| US20200034041A1 (en) | Utilizing groups of data protection policies that are assignable to storage objects | |
| CN111324426A (en) | ORACLE database task job management scheduling system and method | |
| CN106445618A (en) | Automatic database updating method | |
| CN109271199B (en) | Method and system for database continuous integration and script file management | |
| US9348882B2 (en) | Method, system, and computer readable medium for long term archiving of data in a MES system | |
| CN105760174A (en) | Suggested data extraction method based on Windows timed task | |
| CN102193841A (en) | Backup method and device of Subversion configuration database | |
| US20080162587A1 (en) | Server synchronization for maintenance activities | |
| CN111414173B (en) | Automatic deployment method based on database storage process | |
| CN108197147A (en) | Number card database O＆M method and device | |
| CN108280097B (en) | Fault processing method and device for database system | |
| US10365864B2 (en) | Information processing system and operation redundantizing method | |
| CN104331309A (en) | Management method and system for realizing data loading item shell by configuration | |
| CN112817931B (en) | Incremental version file generation method and device | |
| US8150821B2 (en) | System and method for using generic utilities to perform database utilities on mainframe operated DB2 databases | |
| CN116028084A (en) | Cross-version hot upgrading method, system and terminal based on OpenStack cloud platform | |
| CN109240743B (en) | Method for switching codes by using specific label | |
| US20030126159A1 (en) | Method and system for rollback of software system upgrade | |
| CN112597131A (en) | Distributed script control method and related device | |
| CN108958827B (en) | Method and system for processing program upgrading fault |
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 |