Database operation and maintenance management platform
An operation and maintenance management platform and database technology, applied in the field of database operation and maintenance management platform, can solve problems such as low efficiency, redundant work, difficult management, etc., and achieve the effect of reducing workload, improving work efficiency and work safety
Inactive Publication Date: 2021-01-26
SICHUAN CHANGHONG ELECTRIC CO LTD
View PDF9 Cites 2 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] The technical problem to be solved by the present invention is to propose a database operation and maintenance management platform to solve the problems of low efficiency, redundant work and difficult management in traditional management solutions
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
[0022] The invention aims to propose a database operation and maintenance management platform to solve the problems of low efficiency, redundant work and difficult management existing in traditional management solutions. The database operation and maintenance management platform in the present invention is composed of the following modules: database instance deployment module, instance management module, SQL submission module, SQL query module, and user management module. The super administrator configures R&D personnel information, project manager information, and database management personnel information in the user management module, and gives them different authority levels. The database administrator can automatically deploy instances in the instance deployment module, and add other database instances to be managed in the instance management module. During the project development process or post-operation and maintenance projects, R&D personnel can query the background da...
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 relates to a database management technology, discloses a database operation and maintenance management platform, and solves problems of low efficiency, work redundancy and management difficulty of a traditional management scheme. The database operation and maintenance management platform is integrated with a database instance deployment module, an instance management module, an SQL submission module, an SQL query module and a user management module, wherein the database instance deployment module is used for providing deployment of database instances; the instance management module is used for providing basic information management of all instances of the database and basic information management of an instance database; the user management module is used for carrying out authority management and basic information management on a user logging in the platform; the SQL submitting module is used for submitting an SQL script for use when research and development personnel perform data correction and version iteration; and the SQL query module is used for providing an SQL query script for research and development personnel when the research and development personnel querythe application background data.
Description
technical field [0001] The invention relates to database management technology, in particular to a database operation and maintenance management platform. Background technique [0002] Traditional database operation and maintenance work usually includes: 1. Execute SQL scripts, perform application version iteration or data repair; 2. Roll back SQL; 3. SQL query; 4. Database installation, etc. Under normal circumstances, the database manager needs to verify the database installation version, the server address of the database instance and other basic information of the database instance; then, connect to the relevant database instance; then, perform a series of tasks according to different problems, including checking the syntax of the SQL script, checking Execution plan etc. Usually, a database manager will operate and maintain dozens or even hundreds of database servers, and managing the basic information of database instances is a huge job, and the recording, changing, an...
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 Applications(China)
IPC IPC(8): G06F16/21G06F16/245G06F21/31
CPCG06F21/31G06F16/21G06F16/245
Inventor 张琦
Owner SICHUAN CHANGHONG ELECTRIC CO LTD