Dynamic aggregation of disparate enterprise data
First Claim
Patent Images
1. A computer-implemented method comprising:
- executing a project management system in one or more project management servers, wherein the project management system performs the steps of;
initializing a scheduler application for creating one or more intermediate tables, wherein the one or more intermediate tables are created upon initializing a schedule for a project in a project planning interface that communicates with the project management system;
automatically aggregating data from a plurality of disparate data sources identified by a plurality of queries and located on a plurality of organizational servers separate from the project management servers to populate the one or more intermediate tables used by the project in the project planning interface;
detecting a change in one or more of the plurality of disparate data sources located on the plurality of organizational servers, after an initial population of the one or more intermediate tables;
dynamically refreshing the aggregated data in the one or more intermediate tables from the one or more of the plurality of disparate data sources located on the plurality of organizational servers upon detecting the change in the one or more of the plurality of disparate data sources located on the plurality of organizational servers; and
enabling access to a subset of the aggregated data in the one or more intermediate tables used by the project in the project planning interface in accordance with a user authorization credential.
2 Assignments
0 Petitions
Accused Products
Abstract
Methods, systems, and computer program products for dynamically aggregating data from disparate sources. A computer implemented method involves initializing a scheduler application to create one or more intermediate tables. The intermediate tables are populated with automatically aggregated data from one or more disparate data sources. The data is governed by business rules in an enterprise system. The method further involves enabling access to a subset of the aggregated data in accordance with a user authorization credential.
25 Citations
17 Claims
-
1. A computer-implemented method comprising:
-
executing a project management system in one or more project management servers, wherein the project management system performs the steps of; initializing a scheduler application for creating one or more intermediate tables, wherein the one or more intermediate tables are created upon initializing a schedule for a project in a project planning interface that communicates with the project management system; automatically aggregating data from a plurality of disparate data sources identified by a plurality of queries and located on a plurality of organizational servers separate from the project management servers to populate the one or more intermediate tables used by the project in the project planning interface; detecting a change in one or more of the plurality of disparate data sources located on the plurality of organizational servers, after an initial population of the one or more intermediate tables; dynamically refreshing the aggregated data in the one or more intermediate tables from the one or more of the plurality of disparate data sources located on the plurality of organizational servers upon detecting the change in the one or more of the plurality of disparate data sources located on the plurality of organizational servers; and enabling access to a subset of the aggregated data in the one or more intermediate tables used by the project in the project planning interface in accordance with a user authorization credential. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer program product comprising a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer usable program code comprising:
-
computer readable program code for executing a project management system in one or more project management servers, wherein the project management system includes; computer readable program code configured to initialize a scheduler application for creating one or more intermediate tables, wherein the one or more intermediate tables are created upon initializing a schedule for a project in a project planning interface that communicates with the project management system; computer readable program code configured to automatically aggregate data from a plurality of disparate data sources identified by a plurality of queries and located on a plurality of organizational servers separate from the project management servers to populate the one or more intermediate tables used by the project in the project planning interface; computer readable program code configured to detect a change in one or more of the plurality of disparate data sources located on the plurality of organizational servers, after an initial population of the one or more intermediate tables; computer readable program code configured to dynamically refresh the aggregated data in the one or more intermediate tables from the plurality of disparate data sources located on the plurality of organizational servers upon detecting the change in the one or more of the plurality of disparate data sources located on the plurality of organizational servers; and computer readable program code configured to enable access to a subset of the aggregated data in the one or more intermediate tables used by the project in the project planning interface in accordance with a user authorization credential. - View Dependent Claims (10, 11, 12, 13, 14, 15)
-
-
16. A system for project management, the system comprising:
-
a processor; and a computer memory operatively coupled to the processor, the computer memory having disposed within it; computer readable program code for executing a project management system in one or more project management servers, wherein the project management system includes; computer readable program code configured to initialize a scheduler application for creating one or more intermediate tables, wherein the one or more intermediate tables are created upon initializing a schedule for a project in a project planning interface that communicates with the project management system; computer readable program code configured to automatically aggregate data from a plurality of disparate data sources identified by a plurality of queries and located on a plurality of organizational servers separate from the project management servers to populate the one or more intermediate tables used by the project in the project planning interface; computer readable program code configured to detect a change in one or more of the plurality of disparate data sources located on the plurality of organizational servers, after an initial population of the one or more intermediate tables; computer readable program code configured to dynamically refresh the aggregated data in the one or more intermediate tables from the plurality of disparate data sources located on the plurality of organizational servers upon detecting the change in the one or more of the plurality of disparate data sources located on the plurality of organizational servers; and computer readable program code configured to enable access to a subset of the aggregated data in the one or more intermediate tables used by the project in the project planning interface in accordance with a user authorization credential. - View Dependent Claims (17)
-
Specification