O'Reilly logo

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL by Joe Celko

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

10.7. Extract, Transform, and Load Products

The file transfer products continued to evolve and became extract, transform, and load (ETL) products aimed at the new databases. They added fancier “mousey-click” user interfaces, libraries of functions that could be combined via that interface, and fancier custom programming languages.

But they never got over their heritage. The intermediate file format became XML or another markup language. The proprietary programming languages started to look more like Java and C++ than BASIC to reflect the “programming language du jour” syndrome. But the underlying model for the conversion remained record-at-a-time pipeline from source to target.

The connection to a database is typically ODBC, JDBC, or other session ...

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