Data Integration and Virtual Table Management
First Claim
Patent Images
1. A method for integrating and transforming one or more data files, comprising, in no particular order, the steps of:
- receiving the one or more data files at a staging area;
transmitting the one or more data files to a transformation module;
transforming the one or more data files into standardized data which conforms to one or more standards;
transmitting the standardized data to a virtual table aggregator;
storing the standardized data in the virtual table aggregator;
verifying the standardized data conforms to the one or more standards;
transmitting the verified standardized data to a data warehouse; and
storing the verified standardized data in the data warehouse.
6 Assignments
0 Petitions
Accused Products
Abstract
Described is a system, method, and product for integrating data and transforming the data for storage in a data warehouse. One or more data files are received at a staging area and are transmitted to a transformation module. The transformation module transforms the one or more data files into standardized data which conforms to one or more standards. The standardized data is transmitted to and stored in a virtual table aggregator. After verification that the standardized data conforms to the one or more standards, the verified standardized data is stored in a data warehouse.
50 Citations
17 Claims
-
1. A method for integrating and transforming one or more data files, comprising, in no particular order, the steps of:
-
receiving the one or more data files at a staging area; transmitting the one or more data files to a transformation module; transforming the one or more data files into standardized data which conforms to one or more standards; transmitting the standardized data to a virtual table aggregator; storing the standardized data in the virtual table aggregator; verifying the standardized data conforms to the one or more standards; transmitting the verified standardized data to a data warehouse; and storing the verified standardized data in the data warehouse. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A system for integrating and transforming one or more data files, comprising:
-
means for receiving the one or more data files at a staging area; means for transmitting the one or more data files to a transformation module; means for transforming the one or more data files into standardized data which conforms to one or more standards; means for transmitting the standardized data to a virtual table aggregator; means for storing the standardized data in the virtual table aggregator; means for verifying the standardized data conforms to the one or more standards; means for transmitting the verified standardized data to a data warehouse; and means for storing the verified standardized data in the data warehouse.
-
-
17. A system apparatus for integrating one or more data files and transforming the one or more data files for storage in a data warehouse, the system apparatus comprising:
-
a staging area which receives the one or more data files; a transformation module which transforms the one or more data files into standardized data, the standardized data conforming to one or more standards; a data cleansing engine which enables implementation of desired changes in the standardized data; a virtual table aggregator configured to receive and store the standardized data; a verifier which enables approval of the standardized data or alteration of the standardized data in accordance with user preferences; and a data warehouse configured to receive and store verified standardized data.
-
Specification