US 12,079,207 B2
Systems and methods for intelligent database report generation
Nikunj Aggarwal, Secaucus, NJ (US); Utkarsh Bhatia, Uttar Pradesh (IN); Kyle Michael Boston, San Carlos, CA (US); Siddhartha Gunda, Milpitas, CA (US); Abhishek Gupta, Haryana (IN); VenuMadhav Kattagoni, Telangana (IN); Himanshu Nanda, Firozpur (IN); and Ayush Rai, Madhya Pradesh (IN)
Assigned to People Center, Inc., San Francisco, CA (US)
Filed by People Center, Inc., San Francisco, CA (US)
Filed on Oct. 6, 2023, as Appl. No. 18/482,661.
Claims priority of application No. 202211057365 (IN), filed on Oct. 7, 2022.
Prior Publication US 2024/0119045 A1, Apr. 11, 2024
Int. Cl. G06F 16/242 (2019.01); G06F 16/2455 (2019.01); G06F 16/2457 (2019.01)
CPC G06F 16/2428 (2019.01) [G06F 16/24556 (2019.01); G06F 16/2456 (2019.01); G06F 16/24578 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A computing system for intelligent generation of data reports, the computing system comprising:
one or more processors;
one or more databases that store a set of organizational data for an organization, wherein the set of organizational data comprises a plurality of different datasets, and wherein each of the plurality of different datasets comprises a number of respective data elements; and
one or more non-transitory computer-readable media that collectively store instructions that, when executed by the one or more processors cause the computing system to perform operations, the operations comprising:
receiving a request for generation of a report, wherein the report comprises a plurality of requested data elements;
identifying two or more of the plurality of different datasets that collectively contain the plurality of requested data elements;
automatically generating one or more join configurations for combination of the two or more of the plurality of different datasets;
executing the one or more join configurations to generate a combined dataset from the two or more of the plurality of different datasets;
assigning one or more unique identifiers to a portion of the combined dataset and expanding the combined dataset by adding a further column of data to produce an expanded dataset, wherein
the portion of the combined dataset includes a column of data, each of the one or more unique identifiers corresponds to a different entity from the organization,
the expanded dataset includes added data elements, the added data elements including the further column of data, and
each row from the further column of data references both a unique identifier from the one or more unique identifiers and information from another data element in a same row from the expanded dataset;
performing an aggregation operation associated with the expanded dataset by referencing the added data elements and deduplicating duplicate entries in the further column of data; and
generating the report based on the expanded dataset and the aggregation operation.