Partition level operation with concurrent activities

A computer-implemented method performed by a computer system having a memory and at least one hardware processor, the computer-implemented method comprising:

• performing a first operation on a row of a plurality of rows in a first partition of a table of data, the first partition being one of a plurality of partitions of the table, each partition in the plurality of partitions having a plurality of rows;
• applying a row level lock to the row of the plurality of rows in the first partition of the table of data;
• based on the applying the row level lock to the row in the first partition, determining that a predefined threshold number of row level locks corresponding to concurrent operations have been applied within the first partition, the concurrent operations including the first operation;
• based on the determining that the predefined threshold number of row level locks have been applied within the first partition, applying a first partition level lock to the first partition for a period in which the first operation is being performed on the first partition, the first partition level lock preventing any additional operations other than the concurrent operations for which the row level locks have been applied within the first partition from being performed on the first partition during the period the first partition level lock is being applied to the first partition;
• and
• performing a second operation on a second partition of the table at a point in time during which the first operation is being performed on the first partition, the second partition being one of the plurality of partitions of the table.

A non-transitory machine-readable storage medium, tangibly embodying a set of instructions that, when executed by at least one processor, causes the at least one processor to perform system operations comprising:

• performing a first operation on a row of a plurality of rows in a first partition of a table of data, the first partition being one of a plurality of partitions of the table, each partition in the plurality of partitions having a plurality of rows;
• applying a row level lock to the row of the plurality of rows in the first partition of the table of data;
• based on the applying the row level lock to the row in the first partition, determining that a predefined threshold number of row level locks corresponding to concurrent operations have been applied within the first partition, the concurrent operations including the first operation;
• based on the determining that the predefined threshold number of row level locks have been applied within the first partition, applying a first partition level lock to the first partition for a period in which the first operation is being performed on the first partition, the first partition level lock preventing any additional operations other than the concurrent operations for which the row level locks have been applied within the first partition from being performed on the first partition during the period the first partition level lock is being applied to the first partition;
• and
• performing a second operation on a second partition of the table at a point in time during which the first operation is being performed on the first partition, the second partition being one of the plurality of partitions of the table.