Dynamic aggregation of disparate enterprise data
View Patent ↗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.
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. The method according to claim 1 , wherein the one or more intermediate tables are specific to the project.
3. The method according to claim 1 , further comprising utilizing a query script to populate the one or more intermediate tables with matching data.
4. The method according to claim 1 , wherein aggregating the data comprises:
retrieving the data from the plurality of disparate data sources; and
processing the data for integration into the project planning interface.
5. The method according to claim 1 , wherein the aggregated data is accumulated in a single location.
6. The method according to claim 5 , wherein the location comprises a data record or a memory structure.
7. The method according to claim 5 , wherein the location comprises a functional location.
8. The method of claim 4 , further comprises presenting the subset of the aggregated data in the project planning interface.
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.
10. The computer program product according to claim 9 , wherein the one or more intermediate tables are specific to the project.
11. The computer program product according to claim 9 , further comprising computer readable program code configured to create a query script to populate the one or more intermediate tables with matching data.
12. The computer program product according to claim 9 , wherein the computer readable program code configured to automatically aggregate data comprises:
computer readable program code configured to retrieve the data from the plurality of disparate data sources; and
computer readable program code configured to process the data for integration into the project planning interface.
13. The computer program product according to claim 9 , further comprising computer readable program code configured to accumulate the aggregated data in a single location.
14. The computer program product according to claim 13 , wherein the location comprises a data record or a memory structure.
15. The computer program product according to claim 13 , wherein the location comprises a functional location.
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.
17. The system according to claim 16 , wherein upon initializing the scheduler application, the project management servers retrieve the data from the plurality of disparate data sources located on the plurality of organizational servers.