Apparatus and method for performing data transformations in data

Details Apparatus and method for performing data transformations in data Apparatus and method for performing data transformations in data

1997-11-07

2000-01-11

Kulik, Paul V.

Data processing: database and file management or data structures

Database design

Data structure types

707100, G06F 1730

Patent

active

060146702

ABSTRACT:
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 storing the processed data. A mapping is used for directing the data flow between the I/O ports corresponding to the source, the plurality of transformation objects, and the target. The mapping specifies the connectivity between the source, transformation, and target objects as well as the order of these connections. There are a number of different transformations which can be performed to manipulate the data. Some such transformations include: an aggregator transformation, an expression transformation, a filter transformation, a lookup transformation, a query transformation, a sequence transformation, a stored procedure transformation, and an update strategy transformation.

REFERENCES:
patent: 5692181 (1997-11-01), Anand et al.
patent: 5706495 (1998-01-01), Chadha et al.
patent: 5708828 (1998-01-01), Coleman
patent: 5721903 (1998-02-01), Anand et al.
patent: 5781911 (1998-07-01), Young et al.
patent: 5794228 (1998-08-01), French et al.
patent: 5794229 (1998-08-01), French et al.
patent: 5794246 (1998-08-01), Sankaran et al.
patent: 5826258 (1998-10-01), Gupta et al.
patent: 5832496 (1998-11-01), Anand et al.
patent: 5842213 (1998-11-01), Odom et al.
patent: 5870746 (1999-02-01), Knutson et al.
patent: 5870747 (1999-02-01), Sundaresan
patent: 5873102 (1999-02-01), Bridge, Jr. et al.
White, Colin. "Data Warehousing: Cleaning and Transforming Data." InforDB vol. 10 No. 6. Apr. 1997. Database Associates INT, USA. pp. 11-12. XP-002091743.
White, Colin. "Managing Data Transformations." Byte (International Edition) vol. 22, No. 12. Dec. 1997. McGraw-Hill, USA. pp. 53-54. XP002091744.
Squire, Cass. "Data Extraction and Transformation for the Data Warehouse." 1995 ACM Sigmod International Conference on Management of Data, San Jose, CA, USA, May 22-25, 1995. pp. 446-447. XP0092091745.

Affiliated with

Also associated with

Rating

Apparatus and method for performing data transformations in data does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Apparatus and method for performing data transformations in data, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for performing data transformations in data will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1469793