Patent ID: 9189532
Filing Date: 2015-11-17
Classification: G06F,G06Q

Abstract:
1. A computer program product, comprising a non-transitory computer usable medium having a computer readable program code embodied therein, the computer readable program code adapted to be executed to cause a computer to implement a method, the method comprising: receiving by a database system a request for a composite report that is created by aggregating results of a plurality of related reports; identifying the plurality of related reports within the database system, wherein each of the related reports includes a query for data stored in the database system; determining, by the database system, a global report definition specific to the requested composite report, the global report definition including a plurality of attributes to be applied during an execution of the composite report, the attributes including filter criteria that are applied to each of the queries for data and a summary that is calculated utilizing at least a portion of the queried data; replicating, by the databases the attributes of the global report definition from the global report definition to a local report definition of each of the plurality of related reports, such that each local report definition of the plurality of related reports includes the plurality of attributes to be applied during an execution of the related report; executing, by the database system, each of the related reports, including for each of the related reports, performing the query for data included within the report, applying the filter criteria from the local report definition to the query, and calculating the summary utilizing at least the portion of the queried data according to the local report definition; and aggregating, by the database system, the results of the execution of the plurality of related reports to form the requested composite report.