Database script deployment device and database script deployment method
A deployment device and database technology, applied in the field of database script deployment device, can solve the problems of many deployed scripts, not supporting batch script execution, script omission, etc., and achieve the effect of improving deployment efficiency and deployment accuracy
Active Publication Date: 2020-03-17
TAIKANG LIFE INSURANCE CO LTD
View PDF4 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] 1. Executed through PLSQL tools, but does not support the execution of batch scripts;
[0004] 2. Executed through Oracle's client SqlPlus, but also does not support the execution of batch scripts;
[0006] The first and second database deployment methods can be used when the system functions are simple, but as the complexity of system functions increases, the script files that need to be deployed gradually increase, and the transition to the third database deployment method begins. However, , if you start editing the "deployment script" at the beginning of development, if the deployed script is renamed or discarded during the development process, you need to update the "deployment script"; if you start editing the "deployment script" after the development ", there are a lot of scripts that need to be deployed, and some scripts may be missed
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0026] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the embodiments set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. In the drawings, the thickness of regions and layers are exaggerated for clarity. The same reference numerals in the drawings denote the same or similar structures, and thus their detailed descriptions will be omitted.
[0027] Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided in order to give a thorough understanding of embodiments of the present disclosure. However, one skilled in the art will appreciate tha...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention provides a database script deployment device and a database script deployment method. The database script deployment device comprises a reading unit used for reading information of a plurality of pre-stored database scripts; a deployment script generation unit which is connected to the reading unit, and is used for respectively recording the read information of the plurality of database scripts in corresponding script category registration forms in dependence on the corresponding relationship between the preset database script categories and the script category registration forms, and writing the information of the recorded script category registration forms into the same script in a predefined order in order to generate a deployment script; and an execution unit which is connected to the deployment script generation unit, and is used for executing the deployment script to the database in order to complete batch deployment of the plurality of database scripts. According to the invention, batch deployment of the database scripts can be achieved, and control of the execution order during the deployment process can be completed.
Description
technical field [0001] The present disclosure relates to the field of computer technology, in particular to a database script deployment device and a database script deployment method. Background technique [0002] Source code management for database scripts is no different than for other languages, the main issue is deployment of the scripts. Generally, there are three ways to deploy database scripts: [0003] 1. Executed through PLSQL tools, but does not support the execution of batch scripts; [0004] 2. Executed through Oracle's client SqlPlus, but also does not support the execution of batch scripts; [0005] 3. Manually edit the "deployment script" text, and then execute the "deployment script" in the PLSQL tool or SqlPlus client. [0006] The first and second database deployment methods can be used when the system functions are simple, but as the complexity of system functions increases, the script files that need to be deployed gradually increase, and the transiti...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21G06F8/60
CPCG06F8/60G06F16/21
Inventor 杨波
Owner TAIKANG LIFE INSURANCE CO LTD