A remote collection method and collection device for database performance

A technology for collecting devices and databases, applied in the field of computer operation and maintenance, can solve problems such as single function, inability to actively collect information, and difficulty for administrators to distinguish alarm faults, so as to eliminate potential risks, improve work efficiency, and ensure stable operation.

Inactive Publication Date: 2019-05-28
ONE CONNECT SMART TECH CO LTD SHENZHEN
View PDF9 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, there is only database monitoring software in the industry, which pushes the alarm information exceeding the threshold to the mobile terminal of the Database Administrator (DBA) (via SMS or WeChat). The DBA only passively receives information, but cannot take the initiative at any time according to actual needs collect information
In addition, the functions of the existing database monitoring software are relatively simple, and only provide the performance data of the database itself, and cannot provide the performance data of the related computer system. Other computer software and hardware devices associated with database operation

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
  • A remote collection method and collection device for database performance
  • A remote collection method and collection device for database performance
  • A remote collection method and collection device for database performance

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] see figure 1 , in a kind of remote collection method of the present embodiment, comprise the following steps:

[0045] S1: The smart terminal responds to the user's login request and obtains the user's management authority information, where the management authority information is used to represent the category of information obtained by the user.

[0046] The smart terminal mentioned above may be a smart phone, a tablet computer or other smart electronic products installed with an app for obtaining database performance. The user enters the user name and password in the app to log in, and different users are pre-assigned with different permissions in the background. After the present invention receives the above login request command, it will obtain the user's management authority information from the authority database, which is used to represent the scope of the user's obtained information, such as which operations are specifically allowed to be performed. In this e...

Embodiment 2

[0074] see Figure 4 , the remote acquisition method of this embodiment is based on Embodiment 1 and includes the following steps:

[0075] S1: The smart terminal responds to the user's login request and obtains the user's management authority information.

[0076] The smart terminal mentioned above may be a smart phone, a tablet computer or other smart electronic products installed with an app for obtaining database performance. The user enters the user name and password in the app to log in, and different users are pre-assigned with different permissions in the background. After the present invention receives the above login request command, it will obtain the user's management authority information from the authority database, which is used to represent the scope of the user's obtained information, such as which operations are specifically allowed to be performed. In this embodiment, management rights may include system rights and object rights: system rights refer to the...

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 remote collection method and collection device for database performance, and the method comprises the following steps: responding to a database login request of a user, and obtaining database management authority information of the user, the database management authority information being used for representing the category of database information obtained by the user; receiving a database information acquisition instruction sent by a user, and judging whether the database information to be acquired by the user is within the management authority of the user or not; if yes, the intelligent terminal obtains the database information from a remote server according to the database information obtaining instruction; And presenting the obtained database information to a user. The data report related to the database operation state can be collected in real time in response to the user instruction, a database administrator can actively inquire the operation state according to needs, and troubleshooting can be conducted in time.

Description

technical field [0001] The present invention relates to the technical field of computer operation and maintenance, in particular to a remote collection method, device, computer equipment and storage medium of database performance. Background technique [0002] The database system is composed of computer software and hardware resources. It realizes the organized and dynamic storage of a large amount of related data, which is convenient for multiple users to access. At present, there is only database monitoring software in the industry, which pushes the alarm information exceeding the threshold to the mobile terminal of the Database Administrator (DBA) (via SMS or WeChat). The DBA only passively receives information, but cannot take the initiative at any time according to actual needs collect information. In addition, the functions of the existing database monitoring software are relatively simple, and only provide the performance data of the database itself, and cannot provi...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/30
Inventor 谭宝平
Owner ONE CONNECT SMART TECH CO LTD SHENZHEN
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap