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

Database optimization method and device

A database and optimization configuration technology, applied in the field of database optimization, can solve the problems of low data retrieval efficiency and achieve a good experience

Inactive Publication Date: 2015-06-17
CHINA MOBILE GRP HENAN CO LTD
View PDF5 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But if you use an index on an inappropriate column, you must perform multiple searches from the index to get all the rowids, and then read the same number of times from the database table through the rowids to get the required data , in this way, using the index query is slower than not using the index, and the data retrieval efficiency is lower
[0004] In addition, the index itself has maintenance costs

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 optimization method and device
  • Database optimization method and device
  • Database optimization method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] In order to better understand the present invention, first introduce the current optimization method for database index, such as figure 1 As shown, the processing flow of the current database index optimization method includes the following steps:

[0041] Step 110: monitor the database waiting event in real time, and judge whether there is any abnormal waiting;

[0042] Here, if there is an exception waiting to occur, it means that there is an inefficient Structured Query Language (SQL, Structured Query Language);

[0043] Step 111: According to the detection of the database diagnostic report, determine whether there is a TOP SQL with relatively prominent resource consumption;

[0044] Here, if there is TOP SQL with prominent resource consumption, it means that there is inefficient SQL;

[0045] The above step 110 and step 111 may be executed simultaneously or separately.

[0046] Step 112: If it is found that there is inefficient SQL according to the judgment of st...

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 discloses a database optimization method. An index optimizing configuration instruction is received, and data sheet information needing to be monitored and indexed in a database is configured according to the received index optimizing configuration instruction; an index optimizing task is established and monitored, and SQL execution information corresponding the data sheet information is acquired; the collected SQL execution information is analyzed, and an optimal index scheme is obtained through calculation. The invention further discloses a database optimization device.

Description

technical field [0001] The invention relates to database management technology in mobile communication, in particular to a database optimization method and device. Background technique [0002] Database (Database) is a warehouse that organizes, stores and manages data according to the data structure. A business system with a fixed technical framework and a stable database structure, its operating performance depends mostly on the performance changes of the database, and a set of overall A reasonable indexing scheme plays a vital role in the stability and performance improvement of the database. [0003] The so-called index is a structure that sorts the values ​​of one or more columns in the database table, and the specific information in the database table can be quickly accessed by using the index. In the ORACLE database, the index stores two parts of information: the column value in the table and the corresponding rowid (rowid); among them, the rowid contains the physical...

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 CHINA MOBILE GRP HENAN 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

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