Format Conversion, ETL
ETL:
Extraction, Transformation and Loading. Activities required to populate data warehouses and OLAP applications with clean, consistent, integrated and probably summarized data.
From: www.olapreport.com/glossary.htm
Extract/Transform/Load: This is the process of extracting data from their operational data sources or external data sources, transforming the data which includes cleansing, aggregation, summarization, integration, as well as basic transformation and loading the data into some form of the data warehouse (ODS, enterprise data warehouse, data mart). ETL can also refer to the vendor software that performs these processes.
From : it.csumb.edu/departments/data/glossary.html
Transmorpher
Transmorpher is an environment for defining and processing complex transformation flows. It is partly based on the transformation language XSLT recommended by the "World-wide web consortium" (W3C). XSLT is overly complex for simple transformations (such as renaming tags) and too simple for composing transformations (such as applying a transformation until it does not apply anymore). It enables the description of individual transformations but does not support transformation combination and complex data flows.
Transmorpher takes as input a transformation flow described in XML. It is portable, open to other transformation engines and yet sufficient for expressing complex flows of transformations.
Transmorpher is an environment for processing generic transformations on XML documents. It aims at complementing XSLT in order to:
describe easily simple transformations (removing elements, replacing tag and attribute names, concatenating documents...);
allowing regular expression transformations on the content;
composing transformations by linking their (multiple) output to input;
iterating transformations, sometimes until saturation (closure operation);
integrating external transformations.
Transmorpher is a first Java implementation of these concepts, taking advantage of existing XML parsers and XSLT processors.
Loading .....