Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for automatically operating, maintaining and monitoring oracle database

An operation and maintenance monitoring and database technology, applied in the field of database management, can solve the problems of low efficiency and difficult to reuse, single script and results are not easy to read, complicated and complicated operation, etc.

Inactive Publication Date: 2018-02-02
SHENZHEN LAN YOU TECH
View PDF3 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The above two solutions in the industry are too professional and unfriendly for general users (project personnel). Professionals use specific scripts to implement processing on the command line. This method is cumbersome and complicated due to the operation, the singleness of the script and the result is not easy to read. As a result, the efficiency is low and it is difficult to reuse. Using the official Enterprise Manager (grid) manager, this method requires relatively large permissions on the database, and also requires users (project personnel) to need more professional knowledge, which can easily lead to abuse of permissions or Operation error

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for automatically operating, maintaining and monitoring oracle database
  • Method and system for automatically operating, maintaining and monitoring oracle database
  • Method and system for automatically operating, maintaining and monitoring oracle database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0053] The embodiment of the present invention provides a method for automatic operation and maintenance monitoring of oracle database. Oracle database is currently a popular relational database management system in the world. The microcomputer environment is a database with high efficiency, good reliability and high throughput.

[0054] Such as figure 1 As shown, the method includes the following steps:

[0055] S101. Receive an operation parameter input by a user on a function interface of the operation and maintenance monitoring system.

[0056]Use python (a programming language), flask framework (an application project framework), bootstrap (a front-end component), jquery (a front-end component), jinjia2 (a front-end component), mysql (a database) and mongodb (a database) and SQL (Structured Query Language) set to develop a web-based Oracle database automated operation and maintenance monitoring system, users (project personnel) can simply and conveniently click online t...

Embodiment 2

[0068] The method for automatic operation, maintenance and monitoring of an oracle database provided by the embodiment of the present invention is to supplement the steps and content on the basis of the first embodiment. For details not yet detailed in this embodiment, please refer to the first embodiment.

[0069] Such as figure 2 As shown, a method for automatic operation and maintenance monitoring of an oracle database includes the following steps:

[0070] S100. Verify the operation authority of the user on the functional interface of the operation and maintenance monitoring system.

[0071] The system verifies whether the user has the right to use the system through the function of the user management module. After the verification is passed, the user can simply and conveniently click online to access the function page.

[0072] S101. Receive an operation parameter input by a user on a function interface of the operation and maintenance monitoring system.

[0073] S102...

Embodiment 3

[0093] The embodiment of the present invention provides an automatic operation and maintenance monitoring oracle database system (equivalent to the operation and maintenance monitoring system in the first embodiment), which corresponds to the method in the first embodiment. For details that are not yet detailed in this embodiment, please refer to the embodiment one.

[0094] refer to image 3 , a system for automatic operation and maintenance monitoring oracle database, including the following modules:

[0095] The receiving module 101 is configured to receive the operating parameters input by the user on the functional interface of the operation and maintenance monitoring system.

[0096] The acquiring module 102 is configured to acquire the performance data of the oracle database corresponding to the operating parameters through the ajax technology.

[0097] The encoding module 103 is configured to serialize the performance data into data in json format, and generate a per...

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

No PUM Login to View More

Abstract

The invention provides a method and a system for automatically operating, maintaining and monitoring an oracle database. The method comprises the following steps: receiving operating parameters inputon a function interface of an operating, maintaining and monitoring system by a user; acquiring performance data of an oracle database corresponding to the operating parameters through an ajax technology; serializing the performance data into data in a json format, and generating a performance report for monitoring the oracle databases; and drawing the performance report into an oracle database performance analysis curve by using a javascript language and a flot plug-in. The user can obtain the oracle database performance analysis curve by only inputting the operating parameters on the function interface of the operating, maintaining and monitoring system; the oracle database performance analysis curve concisely points out the bottleneck problem of the monitored database; operating, maintaining and monitoring of the oracle database become easy and feasible; and the operability is enhanced.

Description

technical field [0001] The invention relates to the technical field of database management, and more specifically, relates to a method and system for automatic operation, maintenance and monitoring of an oracle database. Background technique [0002] At present, there are generally two types of monitoring and operation of oracle databases in the industry. One is to use specific scripts by professionals to implement processing on the command line, and the other is to use the official Enterprise Manager (grid) manager. The above two solutions in the industry are too professional and unfriendly for general users (project personnel). Professionals use specific scripts to implement processing on the command line. This method is cumbersome and complicated due to the operation, the singleness of the script and the result is not easy to read. As a result, the efficiency is low and it is difficult to reuse. Using the official Enterprise Manager (grid) manager, this method requires re...

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
no application Login to View More
IPC IPC(8): G06F11/34G06F17/30
CPCG06F11/3495G06F16/25
Inventor 罗灼军
Owner SHENZHEN LAN YOU TECH