Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

PG database processing method and device, electronic equipment and storage medium

A processing method and technology of electronic equipment, applied in the field of operation and maintenance, can solve problems such as inability to unify conclusions, inconvenience for staff, lack of flexibility, etc., and achieve the effects of improving operation and maintenance efficiency, optimizing the operation process, and realizing identity authentication

Pending Publication Date: 2019-05-31
PING AN TECH (SHENZHEN) CO LTD
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, in the existing technical solutions, for the analysis of the topsql statement of the PG database, the manufacturer usually needs to provide an AWR report, which has a fixed form and lacks flexibility. It is also different, and the conclusions cannot be effectively unified, causing inconvenience to the relevant staff

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
  • PG database processing method and device, electronic equipment and storage medium
  • PG database processing method and device, electronic equipment and storage medium
  • PG database processing method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0066] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0067] Such as figure 1 Shown is a flowchart of a preferred embodiment of the PG database processing method of the present invention. According to different requirements, the order of the steps in the flowchart can be changed, and some steps can be omitted.

[0068]The PG database processing method is applied to one or more electronic devices, and the electronic device is a device that can automatically perform numerical calculation and / or information processing according to preset or stored instructions, and its hardware includes but not Limited to microprocessors, application specific integrated circuits (Application Specific Integrated Circuit, ASIC), programmable gate arrays (Field-Programmable Gate Array, FPGA), digital processors (Digital S...

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 PG database processing method and device, electronic equipment and a storage medium. The PG database processing method comprises: after a PG database analysis instruction is received, sending a connection request to a PG database; After a connection permission instruction returned by the PG database is received, establishing connection with the PG database; Calling basic data from the PG database according to the PG database analysis instruction; Performing logic operation on the basic data to obtain a TOP SQL statement; And displaying the TOP SQL statement. Through anautomatic processing mode, intelligent searching is achieved during database operation and maintenance, an analysis basis is provided for developers, operation and maintenance efficiency is improved,and therefore operation process optimization is conducted.

Description

technical field [0001] The present invention relates to the technical field of operation and maintenance, in particular to a PG database processing method, device, electronic equipment and storage medium. Background technique [0002] Relational database management systems, such as MySQL, store data in different tables instead of putting all the data together, thus improving data processing speed and flexibility. A relational database management system uses the most commonly used database management language—Structured Query Language (SQL) for database management. Relational database management systems are widely used in various industries. Database function detection can help users understand the performance of the database and troubleshoot abnormalities. [0003] However, in the existing technical solutions, for the analysis of the topsql statement of the PG database, the manufacturer usually needs to provide an AWR report, which has a fixed form and lacks flexibility. ...

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): G06F16/242G06F16/25G06F16/28
Inventor 王小龙
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products