US 12,079,360 B2
Enabling limited database access using randomized limited access pointers
Nipun Aggarwal, Panchkula (IN); and Vipul Gupta, Bangalore (IN)
Assigned to ATLASSIAN PTY LTD., Sydney (AU); and ATLASSIAN US, INC., San Francisco, CA (US)
Filed by ATLASSIAN PTY LTD., Sydney (AU); and Atlassian US, Inc., San Francisco, CA (US)
Filed on Jun. 30, 2022, as Appl. No. 17/810,046.
Prior Publication US 2024/0005016 A1, Jan. 4, 2024
Int. Cl. G06F 21/62 (2013.01); G06F 16/22 (2019.01)
CPC G06F 21/6218 (2013.01) [G06F 16/221 (2019.01); G06F 16/2282 (2019.01)] 20 Claims
OG exemplary drawing
 
1. An apparatus for enabling limited access to a database table that is associated with a plurality of database rows and a plurality of database columns, the apparatus comprising at least one processor and at least one memory including program code, the at least one memory and the program code configured to, with the processor, cause the apparatus to at least:
identify a group of database values, wherein: (i) each database value is associated with a respective database row and a respective database column, (ii) each database row comprises a row-wise subset of the group of database values that collectively correspond to a database column schema of the database table, and (iii) the group of database values comprise a plurality of non-terminal database values that are associated with one or more non-terminal database columns and a plurality of terminal database values that are associated with a terminal database column;
for each non-terminal database value, generate a limited access pointer to a respective subsequent database value whose respective database row is different from the respective database row of the non-terminal database value and whose respective database column is different from the respective database column of the non-terminal database value; and
in response to a limited access request from a requesting computing device, provide shuffled database output data to the requesting computing device, wherein: (i) the shuffled database output data comprises a plurality of shuffled database rows each comprising a shuffled row-wise subset of the group of database values that collectively correspond to the database column schema, and (ii) the plurality of shuffled database rows are determined based on each limited access pointer.