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

Method and device for analyzing database index rationality

A database and rational technology, applied in the computer field, can solve the problems of analyzing logs that cannot be found but not used, and time-consuming reading and writing, and achieve the effect of balancing retrieval and writing performance

Pending Publication Date: 2020-03-24
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] By subscribing and analyzing the log to analyze the rationality of the index, you can find the SQL that takes a long time to read and write, but it is not sure whether the high time-consuming to read and write is because the index is not established or the index is not suitable. Moreover, analyzing the log cannot find out Indexes created but not utilized

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 analyzing database index rationality
  • Method and device for analyzing database index rationality
  • Method and device for analyzing database index rationality

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0035] figure 1 is a schematic diagram of the main flow of the method for analyzing the rationality of database indexing according to an embodiment of the present invention, such as figure 1 As shown, the method includes:

[0036] Step S101: Obtain multiple executable data manipulation statements. Among them, Data Manipulation Language (DML) is an instruction set in SQL l...

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 method and device for analyzing database index rationality, and relates to the technical field of computers. A specific embodiment of the method comprises the steps of: obtaining a plurality of executable data manipulation statements; determining an execution plan related to each executable data manipulation statement; analyzing the execution plan, and determining indexesapplied to execute the executable data manipulation statements and the number of data lines scanned by the indexes; and analyzing the reasonability of the index according to the index and the data line number scanned by the index. According to the embodiment, an execution plan of a plurality of executable data manipulation statements is analyzed; an index applied by each executable data manipulation statement and a data line number scanned by the index are determined; according to each index and the number of data lines scanned by the index, data manipulation statements without indexes or with poor index effects can be actively discovered, so that the reasonability of the indexes can be analyzed, the index distribution is adjusted, and the retrieval and writing performances are balanced.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for analyzing the rationality of database indexes. Background technique [0002] In the use of databases, an index is a separate, physical storage structure that arranges the values ​​of one or more columns in a database table, and is a decentralized data created to speed up the retrieval of data rows in a table structure. The function of the index is equivalent to the table of contents of the book, and the required content can be quickly found according to the page number in the table of contents. Indexing is very critical and directly affects the performance of the database itself, thereby affecting system performance, such as the time consumed by SQL (Structured Query Language, Structured Query Language) execution, the usage rate of the database server CPU (Central Processing Unit, central processing unit) or disk IO (Input / Output, input / output) usage. ...

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): G06F16/22
Inventor 张玉
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH 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