Methods for dynamically accessing, processing, and presenting data acquired from disparate data sources
View Patent ↗Methods for acquiring and transforming data for business analysis, and computer readable media having program instructions for enabling the same are provided. One exemplary method identifies a set of data sources to be accessed for a user, loads the raw data from each of the accessed set of data sources to raw data type specific locations then verifies the integrity of the acquired raw data. Next the acquired raw data of each of the raw data type specific locations is transformed to a uniform data type and then stored as processed data into processed data type specific locations. Some notable advantages of the discussed methods of acquiring and presenting data for business analysis purposes is the ability to efficiently extract, organize and present the data as requested by a customer over a world wide computer network. Examples of such efficiency include the ability to convert data acquired from disparate sources to a uniform format, thus allowing centralization of the data and eliminating the need to continually access various data sources to provide requested reports. The customer can thus be provided with dynamic reports in real-time, thereby allowing for time sensitive and mission critical business decisions to be made with current data.
1. A computer implemented method for acquiring and transforming data for business analysis, comprising:
identifying a set of data sources to be accessed for a user;
loading raw data from each of the accessed set of data sources;
verifying the integrity of acquired raw data;
transforming the acquired raw data to processed data, the transforming further including,
converting each of the acquired raw data to a uniform format,
transferring the converted raw data to a temporary database,
applying processing rules to the converted raw data, the processing rules being configured to define processed data, and
storing the processed data in a processed data type specific location from the temporary database;
transferring the processed data to a temporary database; and
applying display rules, the display rules being configured to define a format and content of a requested report.
2. A method for acquiring and transforming data for business analysis as recited in claim 1 , wherein the transferring the converted raw data to a temporary database further comprises:
performing a memory map transfer.
3. A method for acquiring and transforming data for business analysis as recited in claim 2 , wherein the memory map transfer is a parallel memory map transfer.
4. A method for acquiring and transforming data for business analysis as recited in claim 1 , wherein the acquired raw data and the processed data are stored in one or more hard drives.
5. A method for acquiring and transforming data for business analysis as recited in claim 1 , wherein the acquired raw data is associated to a unique identification defining a customer and source path for the acquired raw data.
6. A method for acquiring and transforming data for business analysis as recited in claim 1 , wherein the temporary database can be one or more databases.
7. A computer implemented method for acquiring and transforming data for business analysis, comprising:
identifying a set of data sources to be accessed for a user;
loading raw data from each of the accessed set of data sources;
verifying the integrity of acquired raw data;
transforming the acquired raw data to processed data, the transforming further including,
convening each of the acquired raw data to a uniform format,
transferring the converted raw data to a temporary database, the transferring performed by a parallel memory map,
applying processing rules to the converted raw data, the processing rules being configured to define processed data, and
storing the processed data in a processed data type specific location from the temporary database;
transferring the processed data to a temporary database, the transferring performed by a parallel memory map; and
applying display rules, the display rules being configured to define a format and content of a requested report.
8. A method for acquiring and transforming data for business analysis as recited in claim 7 , wherein the temporary database can be one or more databases.
9. A method for acquiring and transforming data for business analysis as recited in claim 7 , wherein the acquired raw data is associated to a unique identification defining a customer and source path for the acquired raw data.