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
DBPrism
DBPrism is an open source framework to generate dynamic XML from a database. Unlike other technologies, such as Apache XSP or Oracle XSQL servlet , DBPrism generates the dynamic XML inside the database, transforming it into an active database. An active database means that you use the database engine not only to execute SQL statements, but to directly return a complex XML representation of the data stored inside as well.
visit
DBPrism
DBPrism was visited : 150 times
Loading .....