Data table index set generation method and device

An index collection and data table technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of low index efficiency, achieve the effects of improving overall performance, saving storage resources, and improving accuracy

Active Publication Date: 2016-02-10
中国移动通信集团重庆有限公司
View PDF5 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In view of this, the embodiment of the present invention expects to provide a data table index set generation method

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
  • Data table index set generation method and device
  • Data table index set generation method and device
  • Data table index set generation method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0055] In order to solve the technical problems existing in the prior art, this embodiment provides a method for generating a data table index set, such as figure 1 As shown, the method includes the following steps:

[0056] S101: Scan the statistical information of the data table to be analyzed in the database, and update the field selectivity information table according to the statistical information;

[0057] Here, the scanning cycle can be set in advance, and the statistical information of the data table to be analyzed in the database is scanned at the beginning of each scanning cycle;

[0058] Wherein, the data table to be analyzed is an existing table in the database, including field information used by all application programs of all set periods, that is: the data table to be analyzed can reflect the historical information of the field; the field selectivity information The table is used to store fields in descending order of selectivity.

[0059] When the field infor...

Embodiment 2

[0093] This embodiment and Embodiment 1 belong to the same inventive concept. This embodiment provides a device for generating a data table index set. The structure diagram of the device in this embodiment is as follows figure 2 As shown, the device includes:

[0094] The field selectivity initialization unit 201 is used to scan the statistical information of the data table to be analyzed in the database, and update the field selectivity information table according to the statistical information;

[0095] SQL information collection unit 202, used for collecting SQL information used when the application program runs from the database;

[0096] Here, the collected SQL information can be stored in the SQL collection information table; the SQL collection information table includes the execution times of the SQL statement, the SQL execution plan and the SQL statement;

[0097]The SQL execution information parsing unit 203 is configured to parse the SQL information, obtain the fi...

Embodiment 3

[0126] This embodiment describes the present invention in detail through an actual scene.

[0127] The embodiment of the present invention uses a new technical idea to evaluate and correct the rationality of the data table index design, and through a set of program devices designed according to the new idea, it can identify a large number of application programs running in a complex system to access the data table The purpose of the optimal index set needed, and through this identification method, evaluate and correct the current index design status of the application.

[0128] The logical structure diagram of this embodiment is as follows image 3 As shown, the basic idea is:

[0129] ①: The field selection rate initialization unit queries which data tables to be analyzed need to identify the optimal set of indexes;

[0130] ②, ③: The field selectivity initialization unit queries whether the data tables to be analyzed have statistical information through the database interf...

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 data table index set generation method. The method comprises the steps that statistical information of a data table to be analyzed in a database is scanned, and a field selective information table is updated according to the statistical information; SQL information used when an application program operates is collected from the database; the SQL information is analyzed to obtain field combination frequency of the SQL information to fields and/or combined fields of the data table to be analyzed, and the field combination frequency is updated into a combined field frequency table; the fields and/or the combined fields in the data table to be analyzed are optimized according to the combined field frequency table and the field selective information table to obtain the optimal data table index set corresponding to the data table to be analyzed. The invention further discloses a data table index set generation device.

Description

technical field [0001] The invention relates to the technical field of data performance optimization, in particular to a method and device for generating a data table index set. Background technique [0002] The existing index design evaluation methods are mainly based on the selectivity of the index fields designed by the designer, or the performance analysis of the application program running on the computer system. For example, a designer has created indexes on several fields of a table. If it is a database engine product based on the cost optimizer, after a certain amount of data is available in the relevant table, the table can be analyzed using the command of the database. , so as to obtain the number of unique values ​​of the relevant index field (equivalent to the number of fields), and compare the number of unique values ​​with the total number of rows of the relevant index field to determine the selectivity of the index field; or, through structured query Language...

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 中国移动通信集团重庆有限公司
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