INDEX MASKING BASED ON INSERT CONTENTION RATIO

• US 20170091248A1
• Filed: 12/16/2016
• Published: 03/30/2017
• Est. Priority Date: 04/20/2015
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Li, Shuo, Liang, Ping, Yang, Xin Ying, Zhang, Jian Wei
• Granted Patent: US 9,852,171 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/2272 Management thereof
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing

Abstract

Embodiments of the present invention provide a method, computer program product, and computer system for masking indexes. The method may include masking the index if the index contention exceeds a defined threshold. The method may also include configuring the mask type for the index to insert the index without masking. In response to determining that the mask type for the index is configured to insert the index without masking, the index is masked according to a set of rules.

Claims

1. A computer system for reducing index insert times to improve database performance based on masking indexes above an insert contention threshold, the computer program product comprising:

one or more computer processors;

one or more computer readable storage media;

program instructions stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising;

program instructions to receive, by one or more computer processors, settings defining a mask type for an index, wherein the index is one of a partitioned index and a data partitioned secondary index, and wherein the mask type is one of mask never, mask always, and mask automatic;

program instructions to determine, by the one or more computer processors, that an insert contention exceeds a defined threshold;

program instructions to determine, by the one or more computer processors, that the mask type is not mask always;

program instructions to determine, by the one or more computer processors, that the mask type is mask automatic;

program instructions to determine, by the one or more computer processors, that there are no active applications dependent on the index;

program instructions to determine, by the one or more computer processors, that an index last used time does not exceed a defined threshold;

program instructions to determine, by the one or more computer processors, that an index contention time did not exceed a defined threshold at an index access time, wherein the index contention time is defined as one of a time and a percentage of central processing unit usage;

program instructions to determine, by the one or more computer processors, that an index key length does not exceed a defined threshold, wherein the index key length is based on the maximum size of one or more variable-length columns and the size of one or more fixed-data columns;

program instructions to determine, by the one or more computer processors, that an index free space ratio is less than a defined threshold; and

program instructions to mask, by the one or more computer processors, the index.