Framework for metadata-driven dynamic reporting systems and methods
First Claim
1. A method of dynamically reporting information stored in one or more data repositories, the method comprising:
- receiving a request for a pre-defined report, the request identifying a name of the report requested;
retrieving report metadata from a report repository based on the name of the requested report, the report metadata identifying the name of the report, defining a format for the report including a column name for each of a plurality of columns in the report, identifying a query name for each of a plurality of pre-defined queries for the report, and defining a column sequence for each of the plurality columns in the report indicating an order for results of each of the plurality of queries;
retrieving query metadata from a query repository, the query metadata defining each of the plurality of queries, wherein retrieving the query metadata from the query repository is based on the query names identified in the report metadata;
performing each of the plurality of queries defined by the query metadata on the one or more data repositories; and
populating a results matrix with results of performing each of the plurality of queries defined in the query metadata based on the column sequence for the plurality of columns defined in the report metadata.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments of the invention provide systems and methods for dynamically reporting information stored in a repository. According to one embodiment, a method for dynamically reporting information stored in one or more data repositories can comprise retrieving report metadata from a report repository. The report metadata can define a format for the report and identify one or more queries for the report. Query metadata can be retrieved from a query repository. The query metadata can define one or more queries, for example, Structured Query Language (SQL) queries. Retrieving the query metadata can be based on the one or more queries identified in the report metadata. The one or more queries defined by the query metadata can be performed on the one or more data repositories and a results matrix can be populated with results of performing the one or more queries defined in the query metadata.
-
Citations
18 Claims
-
1. A method of dynamically reporting information stored in one or more data repositories, the method comprising:
-
receiving a request for a pre-defined report, the request identifying a name of the report requested; retrieving report metadata from a report repository based on the name of the requested report, the report metadata identifying the name of the report, defining a format for the report including a column name for each of a plurality of columns in the report, identifying a query name for each of a plurality of pre-defined queries for the report, and defining a column sequence for each of the plurality columns in the report indicating an order for results of each of the plurality of queries; retrieving query metadata from a query repository, the query metadata defining each of the plurality of queries, wherein retrieving the query metadata from the query repository is based on the query names identified in the report metadata; performing each of the plurality of queries defined by the query metadata on the one or more data repositories; and populating a results matrix with results of performing each of the plurality of queries defined in the query metadata based on the column sequence for the plurality of columns defined in the report metadata. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system comprising:
-
a source data repository; a report repository having stored therein report metadata, the report metadata defining a format for one or more reports and identifying each of a plurality of queries for each of the one or more reports; a query repository having stored therein query metadata, the query metadata defining each of the plurality of queries; and a dynamic data provider module communicatively coupled with the source data repository, the report repository, and the query repository, wherein the dynamic data provider receives a request for a pre-defined report, the request identifying a name of the report requested, retrieves report metadata for a requested report from the report repository based on the name of the requested report, retrieves query metadata from the query repository, wherein the report metadata comprises a query name for each of the plurality of queries, an identification of the name of the report, a column name for each of a plurality of columns in the report, and a column sequence for each of the plurality of columns in the report indicating an order for results of each of the plurality of queries, and wherein retrieving the query metadata from the query repository is based on the query names, performs each of the plurality of queries defined by the query metadata on the source data repository, and populates a results matrix with results of performing each of the plurality of queries defined in the query metadata based on the column sequence for the plurality of columns defined in the report metadata. - View Dependent Claims (8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A machine-readable medium having stored thereon a series of instructions which, when executed by a processor, cause the processor to report information stored in one or more data repositories by:
-
receiving a request for a pre-defined report, the request identifying a name of the report requested; retrieving report metadata from a report repository based on the name of the requested report, the report metadata identifying the name of the report, defining a format for the report including a column name for each of a plurality of columns in the report, identifying a query name for each of a plurality of pre-defined queries for the report, and defining a column sequence for each of the plurality columns in the report indicating an order for results of each of the plurality of queries; retrieving query metadata from a query repository, the query metadata defining each of the plurality of queries, wherein retrieving the query metadata from the query repository is based on the query names identified in the report metadata; performing each of the plurality of queries defined by the query metadata on the one or more data repositories; and populating a results matrix with results of performing each of the plurality of queries defined in the query metadata based on the column sequence for the plurality of columns defined in the report metadata. - View Dependent Claims (17, 18)
-
Specification