A transformation description language (TDL) for specifying how data is to be manipulated in a data warehousing application. The TDL is comprised of a source for storing raw data, one or more transformation objects for processing the raw data according to predefined instructions, and a target for...
Inventors: Kiumarse Zamanian, Diaz Nesamoney Assignee: Informatica Corporation Primary Examiner: Sanjiv Shah Attorneys: Wagner, Murabito & Hao LLP U.S. Classification
707/101; 707/100; 707/103 International Classification
G06F 1730 View patent at USPTO |
Citations|
| 5692181 | System and method for generating reports from a computer database | Nov 25, 1997 | | 5706495 | Encoded-vector indices for decision support and warehousing | Jan 6, 1998 | | 5708828 | System for converting data from input data environment using first format to output data environment using second format by executing the associations between their fields | Jan 13, 1998 | | 5721903 | System and method for generating reports from a computer database | Feb 24, 1998 | | 5781911 | Integrated system and method of data warehousing and delivery | Jul 14, 1998 | | 5794228 | Database system with buffer manager providing per page native data compression and decompression | Aug 11, 1998 | | 5794229 | Database system with methodology for storing a database table by vertically partitioning all columns of the table | Aug 11, 1998 | | 5794246 | Method for incremental aggregation of dynamically increasing database data sets | Aug 11, 1998 | | 5826258 | Method and apparatus for structuring the querying and interpretation of semistructured information | Oct 20, 1998 | | 5832496 | System and method for performing intelligent analysis of a computer database | Nov 3, 1998 | | 5842213 | Method for modeling, storing, and transferring data in neutral form | Nov 24, 1998 | | 5870746 | System and method for segmenting a database based upon data attributes | Feb 9, 1999 | | 5870747 | Generalized key indexes | Feb 9, 1999 | | 5873102 | Pluggable tablespaces on a transportable medium | Feb 16, 1999 |
Referenced by|
| 6507945 | Synthesizing combinatorial libraries of materials | Jan 14, 2003 | | 6567816 | Method, system, and program for extracting data from database records using dynamic code | May 20, 2003 | | 6668253 | Enterprise information management system and methods | Dec 23, 2003 | | 6789096 | Real time sessions in an analytic application | Sep 7, 2004 | | 6792431 | Method, system, and product for data integration through a dynamic common model | Sep 14, 2004 | | 6836777 | System and method for constructing generic analytical database applications | Dec 28, 2004 | | 6895471 | Method and apparatus for synchronizing cache with target tables in a data warehousing system | May 17, 2005 | | 6915286 | System and method for an education decision support library | Jul 5, 2005 | | 6957234 | System and method for retrieving data from a database using a data management system | Oct 18, 2005 | | 7003504 | Data processing system | Feb 21, 2006 | | 7020662 | Method and system for determining a directory entry's class of service based on the value of a specifier in the entry | Mar 28, 2006 | | 7065588 | Method and system for data transformation in a heterogeneous computer system | Jun 20, 2006 | | 7065588 | Method and system for data transformation in a heterogeneous computer system | Jun 20, 2006 | | 7089261 | Programmable use of data extracted from common presentation files | Aug 8, 2006 | | 7089266 | Computer systems and methods for the query and visualization of multidimensional databases | Aug 8, 2006 | | 7117215 | Method and apparatus for transporting data for data warehousing applications that incorporates analytic data interface | Oct 3, 2006 | | 7146474 | System, method and computer program product to automatically select target volumes for a fast copy to optimize performance and availability | Dec 5, 2006 | | 7152058 | Apparatus for and method of selectively retrieving information and enabling its subsequent display | Dec 19, 2006 | | 7162643 | Method and system for providing transfer of analytic application data over a network | Jan 9, 2007 | | 7165190 | Method and mechanism for managing traces within a computer system | Jan 16, 2007 | | 7200588 | Method and mechanism for analyzing trace data using a database management system | Apr 3, 2007 | | 7200602 | Data set comparison and net change processing | Apr 3, 2007 | | 7257594 | Method, system, and product for data integration through a dynamic common model | Aug 14, 2007 | | 7269701 | Self-configuration of source-to-target mapping | Sep 11, 2007 | | 7313588 | Locally executing software agent for retrieving remote content and method for creation and use of the agent | Dec 25, 2007 | | 7315849 | Enterprise-wide data-warehouse with integrated data aggregation engine | Jan 1, 2008 | | 7343585 | Operator approach for generic dataflow designs | Mar 11, 2008 | | 7367011 | Method, system and program product for developing a data model in a data mining system | Apr 29, 2008 | | 7376937 | Method and mechanism for using a meta-language to define and analyze traces | May 20, 2008 | | 7380239 | Method and mechanism for diagnosing computer applications using traces | May 27, 2008 | | 7392248 | Data aggregation server supporting rapid query response with sparse multi-dimensional data | Jun 24, 2008 |
ClaimsWhat is claimed is: 1. A computer implemented method for analyzing data in an application, comprising the steps of: - specifying at least one source system containing source data;
- storing metadata corresponding to a plurality of transformation objects including an aggregator transformation objects, an expression transformation objects, a filter transformation objects, a lookup transformation objects, a query transformation objects and a sequence transformation objects which transform data according to the metadata corresponding to a particular transformation object, wherein different transformation objects perform different, unique functions;
- specifying a target system for storing transformed data;
- selecting at least one of the transformation objects;
- mapping data from the source system to a first selected transformation object;
- transforming the data according to the metadata corresponding to the first selected transformation object;
- mapping the transformed data from the first selected transformation object to the target system.
2. The computer implemented method of claim 1, wherein the application is comprised of a balance score card application. 3. The computer implemented method of claim 1, wherein the application is comprised of an enterprise performance measurement application. 4. The computer implemented method of claim 1, wherein the application is comprised of a marketing application. 5. The computer implemented method of claim 1, wherein the application is comprised of a profiling application. 6. The computer implemented method of claim 1, wherein the application is comprised of a segmentation application. 7. The computer implemented method of claim 1, wherein the application is comprised of a data mining application. 8. The computer implemented method of claim 1, wherein the application includes an embedded data mart. 9. A computer implemented method for transferring data having a first format from a first system to a second system having a second format, comprising the steps of: - identifying a set of source data having the first format stored on the first system;
- storing a set of transformation objects including an aggregator transformation object, an expression transformation objects, a filter transformation objects, a lookup transformation objects, a query transformation objects and a sequence transformation objects, wherein the transformation objects have corresponding metadata which defines how data is to be transformed and wherein different transformation objects perform different, unique functions;
- mapping data from the first system to one or more of the transformation objects;
- transforming the data having the first format to the second format through at least one of the transformation objects;
- exporting transformed data having the second format to the second system.
10. The computer implemented method of claim 9, wherein data having the first format is copied from the first system and stored on the second system in the second format. 11. A computer implemented method for transforming data, comprising the steps of: - specifying at least one source system containing source data;
- storing metadata corresponding to a plurality of transformation objects including an aggregator transformation object, an expression transformation objects, a filter transformation objects, a lookup transformation objects, a query transformation objects and a sequence transformation objects which transform data according to the metadata corresponding to a particular transformation object, wherein different transformation objects perform different, unique functions;
- specifying a target system for storing transformed data;
- selecting at least one of the transformation objects;
- mapping data from the source system to a first selected transformation object;
- transforming the data according to the metadata corresponding to the first selected transformation object;
- mapping the transformed data from the first selected transformation object to the target system.
12. The computer implemented method of claim 11, wherein the source system is comprised of an application. 13. The computer implemented method of claim 12, wherein the application includes a database embedded within the application. |
