Database index creation method and device

A database and index technology, applied in the database field, can solve the problems of query performance, poor query performance, and the client cannot obtain data results, and achieve the effect of improving data query performance

Pending Publication Date: 2017-10-10
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
View PDF2 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the amount of database data is large, a large number of data query operations will have the problem of poor query performance
For example, it takes too long to query specific data results, which will take a long time to return the data results to the client. In extreme cases, when the query cannot be executed within a certain period of time, it will cause a database timeout error and the client cannot obtain The result of the data results in an error page
In addition, querying specific data requires a large number of server I/O operations, so it will also bring grea

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0017] The core idea of ​​the present invention is to: collect the data query operation performed by the application program during the running process, analyze the collected data query operation data, and automatically create corresponding Index to improve data query efficiency.

[0018] figure 1 It is a schematic flowchart of the method for creating a database index in Embodiment 1 of the present invention, as shown in figure 1 As shown, this embodiment mainly includes:

[0019] Step 101 , when a data query operation occurs or a preset statistical period ends, analyze the statistical data of the data query operation, and determine a query field combination whose number of data query operations satisfies the preset condition for automa...

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 index creation method and device. The method comprises the following steps of when a data query operation occurs or a preset statistic period is ended, analyzing statistic data of the data query operation to determine a query combination group, the data query operation frequency of which satisfies a preset automatic index creation condition; and establishing a corresponding data table index according to the query field combination. By adoption of the method and device, the data query performance can be improved.

Description

technical field [0001] The invention relates to database technology, in particular to a database index creation method and device. Background technique [0002] Most of the current applications use databases to store underlying data, and a large number of data query operations are often required during the running of the application. When the amount of database data is large, a large number of data query operations will have the problem of poor query performance. For example, it takes too long to query specific data results, which will take a long time to return the data results to the client. In extreme cases, when the query cannot be executed within a certain period of time, it will cause a database timeout error and the client cannot obtain The data results in an error page. In addition, querying specific data requires a large number of server I / O operations, so it will also bring greater load pressure to the database server. [0003] At the beginning of the creation o...

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
CPCG06F16/90335G06F16/901
Inventor 董宗磊
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap