Index masking based on insert contention ratio

• US 10,229,146 B2
• Filed: 04/20/2015
• Issued: 03/12/2019
• 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
• Primary Examiner(s): Ho, Binh V
• Application Number:
  US14/690,611
• Publication Number:
  US 20160306834A1
• Time in Patent Office: 1,422 Days
• Field of Search: 707715
• 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 to improve processing performance when multiple processes compete for access to a data block, the method 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 , 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 more than a defined threshold; and

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

19. The method of claim 1, wherein defining a mask type for an index comprises:

defining, by one or more computer processors, unique indexes as the mask type configured to insert the index without masking;

defining, by one or more computer processors, non-unique indexes as one of;

the mask type for the index configured to insert the index without masking, the mask type for the index configured to insert the index with automatic masking based, at least in part, on the set of rules, and a mask type for the index configured to insert the index with masking.

20. 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 active applications dependent on the index;

in response to determining there are not active applications dependent on the index, determining, by one or more computer processors, whether a time elapsed since the index was last used exceeds a last time used threshold, inserting, by one or more computer processors, the index normally without masking; and

in response to determining that the time elapsed since the index was last used does exceed the last time used threshold, masking, by one or more computer processors, the index.

7. A computer program product to improve processing performance by masking indexes when multiple processes compete for access to a data block, the computer program product, the 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

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

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

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

program instructions to insert the index without masking.

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

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

program instructions to mask the index.

10. The computer program product of claim 7, 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.

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

12. The computer program product of claim 7, 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 with masking.

13. A computer system to improve processing performance by masking indexes when multiple processes compete for access to a data block, the 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

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

14. The computer system of claim 13, further comprising:

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

program instructions to insert the index without masking.

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

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

program instructions to mask the index.

16. The computer system of claim 13, 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.

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

18. The computer system of claim 13, 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 more than a defined threshold; and

program instructions to insert the index without masking.