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

Database index processing method and device

A processing method and processing device technology, applied in the field of databases, can solve problems such as the inability to detect the use of indexes, and achieve the effect of easy maintenance

Active Publication Date: 2014-02-26
BEIJING GRIDSUM TECH CO LTD
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to provide a database index processing method and device to solve the problem that the use of the index cannot be detected in the prior art

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and examples.

[0024] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is an embodiment of a part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0025] It should be noted that the terms "fir...

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 processing method and device. The database index processing method comprises the steps of obtaining the annotation information of pre-added indexes, wherein the annotation information is used for recording the original format used by the indexes; carrying out analysis on the annotation information to obtain the original format used by the indexes and recorded by the annotation information, obtaining metadata of the indexes; carrying out comparison on the original format used by the indexes recorded by the annotation information and the metadata of the indexes; obtaining the using information of the indexes according to comparison results. Through the database index processing method and device, the effect of carrying out detection on the using situation of the indexes is achieved, and maintenance on the indexes is convenient to carry out.

Description

technical field [0001] The present invention relates to the field of databases, in particular to a database index processing method and device. Background technique [0002] In the use of the database, the index is used very frequently, which has a great impact on the performance of the database, so some indexes need to be maintained for a long time. In the existing technology, these indexes rely on artificial memory to remember the use of the index, but after a long period of time, they will forget for which situations the originally established index was used, and in which Structured Query Language (Structured Query Language) , referred to as SQL) are used. Since the use of the indexes cannot be detected, the use of these indexes cannot be known, and the impact of the use of the indexes cannot be evaluated. [0003] Aiming at the problem that the use of indexes cannot be detected in the prior art, no effective solution has been proposed yet. Contents of the invention ...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2228G06F16/2358
Inventor 洪超
Owner BEIJING GRIDSUM 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