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

Method and device for database optimization

An optimization method and database technology, applied in the field of database optimization, can solve problems such as lack of statistical and filtering functions, no data collection summary analysis, affecting database optimization, etc., to achieve optimization effects and reduce risks

Active Publication Date: 2012-07-04
ZUNYI BRANCH OF CHINA MOBILE GRP GUIZHOU COMPANY
View PDF4 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The INFORMIX database interface can only provide the SQL execution status at one point in time, and does not have the function of data collection and summary analysis. Therefore, it cannot provide the SQL execution status within a time period, and lacks statistics and filtering functions
In this way, the database administrator cannot locate the key SQL, which in turn affects the optimization of the database

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 device for database optimization
  • Method and device for database optimization
  • Method and device for database optimization

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] 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.

[0021] Key SQL needs to consume large database resources. Therefore, finding out key SQL and optimizing it is the best way to achieve database optimization. The method provided by the present invention can locate the key SQL, specifically as figure 1 shown.

[0022] see figure 1 , figure 1 The basic flowchart provided for the embodiment of the present invention. Such as figure 1 As shown, the process may include the following steps:

[0023] Step 101, capture raw SQL

[0024] During specific implementation, this step 101 captures the original SQL from the shared memory pool of the database by setting the capture granularity as a unit. Wherein, the capture granularity is set according to the principle of having the least impact on the system...

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 device for database optimization. The method includes the following steps: A acquiring original structured query languages (SQLs); B aiming at each acquired SQL, standardizing the original SQLs, obtaining standard SQLs corresponding to the original SQLs, and generating identification of the standard SQLs; and C locating the key SQLs to be optimized according to the identification of each standard SQL. By the adoption of the method, the key SQLs can be located, thereby facilitating database optimization.

Description

technical field [0001] The invention relates to mobile communication technology, in particular to a database optimization method and device. Background technique [0002] In database applications, a large number of SQL access databases every day. At present, databases such as Informix database access the system tables of the INFORMIX database through the INFORMIX database interface to query the execution status of the SQL being executed at the current time point (including the resources currently consumed by the SQL, etc.). [0003] The INFORMIX database interface can only provide the SQL execution status at a point in time, and has no function of data collection and summary analysis. Therefore, it cannot provide the SQL execution status within a time period, and lacks statistics and filtering functions. In this way, the database administrator cannot locate the key SQL, which in turn affects the optimization of the database. Among them, the key SQL is the SQL with high exe...

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): G06F17/30
Inventor 林昊张黔刘阳宋玉军杜鹏何昱吾陆恩波
Owner ZUNYI BRANCH OF CHINA MOBILE GRP GUIZHOU COMPANY
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

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