O'Reilly logo

Building the Unstructured Data Warehouse: Architecture, Analysis, and Design by Krish Krishnan, W. H. Inmon

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Another important similarity is in how data finds its way into each of the different environments. Figure 3.6 shows that data is placed into the structured data warehouse environment by means of processing often referred to as ETL processing. ETL stands for “extract/transform and load” technology. ETL has long been used to load a data warehouse from legacy applications. Classical ETL reads legacy data, reformats it, recalculates it, restructures it and does many other activities all designed to turn the data coming from an application into corporate data that fits in a data warehouse.

Figure 3.6 Classical ETL loads into structured data warehouse

In structured ETL, there are many sources of data, usually older legacy applications. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required