INDEX MASKING BASED ON INSERT CONTENTION RATIO

• US 20160306834A1
• Filed: 04/20/2015
• Published: 10/20/2016
• 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 10,229,146 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 method for masking indexes comprising:

defining, by one or more computer processors, a mask type for an index;

determining, by one or more computer processors, that index contention exceeds a defined threshold;

determining, by one or more computer processors, that the mask type for the index is configured to insert the index without masking; and

in response to determining that the mask type for the index is configured to insert the index without masking, masking the index, based, at least in part, according to a set of rules.

2. The method of claim 1, further comprising:

determining, by one or more computer processors, that index contention does not exceed a defined threshold; and

inserting, by one or more computer processors, the index without masking.

3. The method of claim 1, further comprising:

determining, by one or more computer processors, that the mask type for the index comprises masking the index; and

masking, by one or more computer processors, the index.

4. The method of claim 1, further comprising:

determining, by one or more computer processors, that the mask type for the index comprises inserting the index without masking; and

inserting, by one or more computer processors, the index without masking.

5. The method of claim 1, wherein the index comprises a partitioned index or a data partitioned secondary index.

6. The method of claim 1, wherein masking the index, based, at least in part, according to a set of rules comprises:

determining, by one or more computer processors, that there are no active applications dependent on the index;

determining, by one or more computer processors, that an index last used time threshold was not exceeded;

determining, by one or more computer processors, that an index contention time does not exceed a defined threshold at an index access time;

determining, by one or more computer processors, that an index key length does not exceed a defined threshold;

determining, by one or more computer processors, that an index free space is less than a defined threshold; and

inserting, by one or more computer processors, the index without masking.

7. The method of claim 1, wherein masking the index, based, at least in part, according to a set of rules comprises:

determining, by one or more computer processors, that there are no active applications dependent on the index;

determining, by one or more computer processors, that an index last used time threshold was not exceeded;

determining, by one or more computer processors, that an index contention time does not exceed a defined threshold at an index access time;

determining, by one or more computer processors, that an index key length does not exceed a defined threshold; and

determining, by one or more computer processors, that an index free space is less than a defined threshold.

8. A computer program product comprising:

a computer readable storage medium and program instructions stored on the computer readable storage medium, the program instructions comprising;

program instructions to define a mask type for an index;

program instructions to determine that index contention exceeds a defined threshold;

program instructions to determine that the mask type for the index is configured to insert the index without masking; and

program instructions to, in response to determining that the mask type for the index is configured to insert the index without masking, mask the index, based, at least in part, according to a set of rules.

9. The computer program product of claim 8, further comprising:

program instructions to determine that index contention does not exceed a defined threshold; and

program instructions to insert the index without masking.

10. The computer program product of claim 8, further comprising:

program instructions to determine that the mask type for the index comprises masking the index; and

program instructions to mask the index.

11. The computer program product of claim 8, further comprising:

program instructions to determine that the mask type for the index comprises inserting the index without masking; and

program instructions to insert the index without masking.

12. The computer program product of claim 8, wherein the index comprises a partitioned index or a data partitioned secondary index.

13. The computer program product of claim 8, wherein the program instructions to mask the index, based, at least in part, according to a set of rules comprises:

program instructions to determine that there are no active applications dependent on the index;

program instructions to determine that an index last used time threshold was not exceeded;

program instructions to determine that an index contention time does not exceed a defined threshold at an index access time;

program instructions to determine that an index key length does not exceed a defined threshold;

program instructions to determine that an index free space is less than a defined threshold; and

program instructions to insert the index without masking.

14. The computer program product of claim 8, wherein the program instructions to mask the index, based, at least in part, according to a set of rules comprises:

program instructions to determine that there are no active applications dependent on the index;

program instructions to determine that an index last used time threshold was not exceeded;

program instructions to determine that an index contention time does not exceed a defined threshold at an index access time;

program instructions to determine that an index key length does not exceed a defined threshold; and

program instructions to determine that an index free space is less than a defined threshold.

15. A computer system comprising:

one or more computer processors;

one or more computer readable storage media;

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

program instructions to define a mask type for an index;

program instructions to determine that index contention exceeds a defined threshold;

program instructions to determine that the mask type for the index is configured to insert the index without masking; and

program instructions to, in response to determining that the mask type for the index is configured to insert the index without masking, mask the index, based, at least in part, according to a set of rules.

16. The computer system of claim 15, further comprising:

program instructions to determine that index contention does not exceed a defined threshold; and

program instructions to insert the index without masking.

17. The computer system of claim 15, further comprising:

program instructions to determine that the mask type for the index comprises masking the index; and

program instructions to mask the index.

18. The computer system of claim 15, further comprising:

program instructions to determine that the mask type for the index comprises inserting the index without masking; and

program instructions to insert the index without masking.

19. The computer system of claim 15, wherein the index comprises a partitioned index or a data partitioned secondary index.

20. The computer system of claim 15, wherein the program instructions to mask the index, based, at least in part, according to a set of rules comprises:

program instructions to determine that there are no active applications dependent on the index;

program instructions to determine that an index last used time threshold was not exceeded;

program instructions to determine that an index contention time does not exceed a defined threshold at an index access time;

program instructions to determine that an index key length does not exceed a defined threshold;

program instructions to determine that an index free space is less than a defined threshold; and

program instructions to insert the index without masking.