Partition lookup and state synchronization

摘要

Disclosed herein are system, method, and computer program product embodiments for multilevel synchronization of database table partition states. An embodiment operates by retrieving a partition from a partition lookup structure and determining whether the partition is in an active state. Based on a determination that the partition is in the active state an embodiment increments a counter associated with the partition using a compare-and-swap instruction accesses the partition.

主权项

1. A computer implemented method for synchronizing partition states, comprising:
retrieving; by at least one processor, a partition from a partition lookup structure; determining, by the at least one processor, whether the partition is in the active state indicating that the partition is available for use or a drop state indicating that the partition is not available; and based on a determination that the partition is in the active state:
incrementing; by the at least one processor, a counter associated with the partition using a compare-and-swap instruction, wherein the counter is maintained separately from the state;verifying, from the partition lookup structure, whether the partition is accessible in the active state; andaccessing, by the at least one processor, the partition based on the verification that the partition is in the active state.