US 11,941,013 B2
Automated database ownership attribution
Saikiran Sri Thunuguntla, Bangalore (IN); Sreenivasulu Nallapati, Bangalore (IN); Vijaykumar Hiremath, Bangalore (IN); and Vasanth Kumar Jagadeesh, Bangalore (IN)
Assigned to INTUIT INC., Mountain View, CA (US)
Filed by INTUIT INC., Mountain View, CA (US)
Filed on Jul. 28, 2022, as Appl. No. 17/815,767.
Prior Publication US 2024/0037112 A1, Feb. 1, 2024
Int. Cl. G06F 16/2458 (2019.01); G06F 16/22 (2019.01); G06F 16/835 (2019.01)
CPC G06F 16/2471 (2019.01) [G06F 16/2272 (2019.01); G06F 16/835 (2019.01)] 17 Claims
OG exemplary drawing
 
1. A system comprising:
at least one server comprising one or more processors; and
a non-transitory memory, in communication with the at least one server, storing instructions that when executed by the one or more processors, causes the one or more processors to implement a method comprising:
inferring one or more user database commands using one or more algorithms, wherein the one or more algorithms push information identifying one or more users that created or interacted with one or more database tables using one or more of: database commands, write access roles, or an administrator cloud account, and wherein the one or more algorithms further push ownership attribution parameters reflecting types of actions performed on the one or more database tables;
publishing user database relationship data via an API call from the one or more algorithms;
creating, using the ownership attribution parameters as input parameters, a queryable bi-partite graph including a graph connection between one or more usernames and a database table name based on the user database relationship data;
assigning, based on the types of actions performed on the one or more database tables, a score for each unique edge type pair between the one or more usernames and the database table name;
attributing ownership of the database table name to the one or more users based on the unique edge type pair and a cumulative edge type pair score associated with a username of the one or more users, wherein the cumulative edge type pair score is a highest cumulative score from among a plurality of cumulative scores for a plurality of usernames; and
storing the queryable bi-partite graph in a graph database.