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
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
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 ...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com