Issue rank management in an issue tracking system
AssigneeAtlassian Pty Ltd.
InventorsMark Lassau, Matt Quail, Nikolay Petrov, Ivo Bosticky, Michael Elias
Life of this patent
Estimating the term…
Abstract
Described herein is a computer implemented method for maintaining a plurality of issues, each issue having an associated rank value, the rank values of the plurality of issues defining an order of the plurality of issues. The method comprises receiving a rank operation request to change the rank of a subject issue; determining relevant issues to the rank operation request; and attempting to acquire locks on each of the relevant issues. In response to successfully acquiring locks on each of the relevant issues a new rank value for the subject issue is calculated and saved.
Claims19
A computer implemented method for maintaining a plurality of database records assigned within a database, each database record having an associated rank value, the rank values of the plurality of database records defining an order of the plurality of database records, the method comprising:
- receiving, by a database server computer, a database rank operation request to change the rank of a subject record;
- determining, by the database server computer, a set of database records of the plurality of database records applicable to the database rank operation request;
- acquiring, by the database server computer using one or more database record lock acquisition requests, a database record lock for locks on each database record of the set of database records;
- in response to acquiring the database record lock for each database record of the set of database records:
- restricting, by the database server computer, a subsequent database rank operation request for any database record of the set of database records for at least a duration in which the database record lock is acquired;
- assigning, by the database server computer, a respective new rank value for each of at least a subset of database records of the set of database records, a particular new rank value of the subject record being assigned in accordance with the received database rank operation request;
- and
- saving, by the database server computer, the new rank value for each of the at least the subset of database records of the set of database records.
One or more non-transitory computer-readable storage media storing one or more sequences of instructions which, when executed using one or more processors, cause performing a computer-implemented method for maintaining a plurality of database records, each database record having an associated rank value, the rank values of the plurality of database records defining an order of the plurality of database records, the instructions causing the one or more processors to:
- receive a database rank operation request to change the rank of a subject record of a the plurality of database records;
- determine a set of database records of the plurality of database records relevant to the database rank operation request;
- acquire, using a single database record lock acquisition request, a database record lock for each database record of the set of database records;
- and
- in response to acquiring the database record lock for each database record of the set of database records:
- restrict a subsequent database rank operation request for any database record of the set of database records for at least a duration in which the database record lock is acquired;
- assign a respective new rank value for each of at least a subset of database records of the set of database records, a particular new rank value of the subject record being assigned in accordance with the received database rank operation request;
- and
- save the new rank value for each of the at least the subset of database records of the set of database records.
Dependencies are inferred from the claim text.