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

Database access path efficiency analyzing and processing method, server and system

An access path, analysis and processing technology, applied in electronic digital data processing, special data processing applications, instruments, etc., can solve problems such as time-consuming and energy-consuming, inputting many sentences, complicated operations, etc., to ensure safe operation and unified analysis rules , easy to use effect

Inactive Publication Date: 2009-05-06
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF0 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the process of completing the present invention, the inventor found that the above-mentioned database access path efficiency analysis and processing method needs to query a huge number of tables, and needs to be queried one by one, so it takes a lot of time, complicated operations, long waiting time, and many input sentences. Inconvenient to view query results
It often takes a lot of time and energy, but the SQL with problematic access paths cannot be found in time; at the same time, with the continuous development of user services such as banks, the number of host applications is increasing, and tens of thousands of programs are put into operation. It is further required that the access path efficiency of program SQL can be well controlled and mastered

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
  • Database access path efficiency analyzing and processing method, server and system
  • Database access path efficiency analyzing and processing method, server and system
  • Database access path efficiency analyzing and processing method, server and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0023] like figure 1 As shown, it is the database access path efficiency analysis processing system of this embodiment, the system includes: input device 100, server 200, data storage device 400 and output device 300; server 200 is connected with input device 100, data storage device 400 and output device The device 300 is connected.

[0024] Wherein, the input device 100 is used to input the structured query language command SQL access path performance analysis request including the program information; the data storage device 400 is used to store the SQL access path information, the SQL access path analysis rule information, and the SQL table information; the server 200 It is used to receive the structured query language command SQL access path performance analysis request including program information input by the user; obtain SQL access path information and SQL access path analysis rule information according to the SQL access path performance analysis request; according to...

Embodiment 2

[0030] The database access path efficiency analysis and processing method of this embodiment runs on such as figure 1In the shown database access path efficiency analysis processing system, the system includes: input device 100, server 200, data storage device 400 and output device 300; server 200 is connected with input device 100, data storage device 400 and output device 300 respectively .

[0031] First, the program SQL-related access path information, DB2 data statistics information and expert rule information stored in the data storage device 400 are preprocessed, and then the access path efficiency analysis and processing server 200 reads the user requirements from the data storage device 100 according to the input device 100. The program SQL access path information storage device 401 of the device 400 reads in the relevant program SQL access path information for analysis, and at the same time reads the data of the related table from the DB2 data statistics information ...

Embodiment 3

[0082] Such as figure 1 Shown is the database access path efficiency analysis processing system of the embodiment of the present invention, the system includes: input device 100, server 200, data storage device 400 and output device 300; server 200 is connected with input device 100, data storage device 400 and The output device 300 is connected.

[0083]The input device 100 is mainly used to read in the user's needs; the server 200 can read in the relevant program SQL access path information from the data storage device 400 according to the user's needs read in by the input device 100 for analysis, and at the same time, according to the table involved in the program, from The data storage device 400 reads information such as the data volume and data distribution characteristics of the relevant table, and according to the type of access path, reads the relevant expert rules from the data storage device 400, and after detailed analysis, judges the performance efficiency of 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 relates to a method, a server and a system analyzing and processing the database access path efficiency. The method comprises the following steps: receiving the performance analysis request of a structured query language (SQL) order access path including program information and input by users, acquiring the information and analysis rule information of the SQL access path according to the performance analysis request of the SQL access path, judging whether a program is a new program according to the program information included in the performance analysis request of the SQL access path, if so, analyzing and processing the predicative of the SQL, and analyzing and processing the performance of the SQL access path according to the analysis rule information of the SQL access path to generate the performance analysis result information of the SQL access path, if not, analyzing the new and old access paths of the program to generate the performance analysis result information of the SQL access path and outputting the performance analysis result information of the SQL access path. DB2 database access path which is possible to have a problem program is determined by analyzing the related information of a program SQL access path.

Description

technical field [0001] The present invention relates to database access technology, in particular to a database access path efficiency analysis and processing method, server and system. Background technique [0002] The DB2 database on the host platform is a database solution with excellent performance, stable operation and wide application. In the prior art, the method for analyzing and processing the efficiency of the access path of the host DB2 database is to search out the structured query language command ( SQL), and then for those SQL access paths that may have problems, a large amount of relevant data is extracted from the DB2 catalog (CATALOG) for comprehensive analysis, so as to determine the problematic program SQL, and finally correlate according to the results determined by the analysis Optimization and other solutions. [0003] In the process of completing the present invention, the inventors found that the above-mentioned database access path efficiency analy...

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): G06F17/30
Inventor 曾美财邓俊峰徐乐耕李奇伟
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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