Thursday, September 28, 2017

Word of the Day: extract, transform, load (ETL)

Word of the Day WhatIs.com
Daily updates on the latest technology terms |September 28, 2017
extract, transform, load (ETL)

In database management, extract, transform, load (ETL) is a programming tool that consists of three separate functions. ETL is often used to acquire a temporary subset of data for reports or other purposes.

First, the extract function reads data from a specified source database and removes a desired subset of data. Next, the transform function works with the acquired data - using rules or lookup tables, or creating combinations with other data - and converts it to the desired state. Finally, the load function writes the resulting data (either all of the subset or just the changes) to a target database, which may or may not previously exist.

In addition to acquiring a data subsets for reports, ETL is also used to migrate data from one database to another and populating data warehouses. ETL can be contrasted with ELT (Extract, Load, Transform) which transfers raw data from a source server to a data warehouse on a target server and then prepares the information for downstream uses.

Quote of the Day

"Over the years, ETL tools have evolved in several key areas, including development, operational processing and integration functionality." - Rick Sherman

 

Trending Terms

fixed data
data warehouse
raw data
data mart
extract, load, transform
change data capture

 
Learning Center

Bank sees ETL processes evolve from IT to front-line users
ETL processes that resided in IT are morphing and migrating to business groups as data wrangling and self-service gain more use for analytics.

Data integration platforms take users beyond ETL software
Expert Rick Sherman examines how data integration platforms have evolved to meet the growing demands for data that's ready for business analysis.

Spark brings value to big data analytics and ETL processes
Spark is earning the interest of enterprise architects for unifying data stored across the enterprise as an open source approach for better ETL processes.

What are key features for choosing the best ETL tools for your needs?
There's a set of core functions that most ETL software vendors support -- and that buyers should look for when evaluating and selecting the best ETL tools.

How to justify the purchase of a data integration tool
With big data everywhere, data integration is more vital than ever. Explore how a data integration tool can help address your enterprise's needs.

Quiz Yourself

A data ______ is generally controlled by a single department of an organization, such as sales or finance.
a. warehouse
b. mart
Answer

 

Stay In Touch
For feedback about any of our definitions or to suggest a new definition, please contact me at: mrouse@techtarget.com

 

Visit the Word of the Day Archives and catch up on what you've missed!

 

FOLLOW US

TwitterRSS
About This E-Newsletter
This e-newsletter is published by the TechTarget network. To unsubscribe from Whatis.com, click here. Please note, this will not affect any other subscriptions you have signed up for.
TechTarget

TechTarget, Whatis, 275 Grove Street, Newton, MA 02466. Contact: webmaster@techtarget.com

Copyright 2016 TechTarget. All rights reserved.

No comments: