OLAP's Ante to Play: OLTP

I'm starting to read various chapters from 'Programming Microsoft SQL Server 2008' by Leonard Lobel and his co-authors. I found his Chapter 14, 'Data Warehousing', contains a very good section on the solutions and technologies that were 'main stream' prior to the deployment of data warehousing and business intelligence solutions.

This brings up an excellent (debatable) point. In my opinion, anyone wishing to enter the field of DW/BI (regardless of software vendor) should have good solid prior experience in traditional OLTP-based applications and systems. This is my opinion because (as 'Programming Microsoft SQL Server 2008' mentions), OLTP systems have been around long before OLAP and data warehousing. Furthermore, data warehousing requires us to extract data regularly from OLTP systems. Finally, because data warehousing is an evolution that was created to address the many constraints found in traditional OLTP systems for decision support requirements.

What do you think? You could certainly argue that so long as one has a basic understanding of the systems they are collecting data from they should be fine regardles of this prior experience. Let's take this discussion one step further, what about these various DW/BI Training companies who now promote learning DW/BI without considering the individuals background? I am sure the training companies don't care (that much) but are their customers going to be able to obtain real-world DW/BI jobs without having any OLTP experience prior (and probably no DW/BI experience as well)?

YEAH RIGHT! (I am now on a separate 'soap box'). If you truly want to assist and train people in DW/BI you should enforce a course requirement that people have X number of years experience in OLTP. Otherwise, you are teaching people 'Algebra' without them having an understanding of 'Math'!

For those who read my blog, chime in!

 

Print | posted on Friday, January 02, 2009 8:52 AM

Feedback

# re: OLAP's Ante to Play: OLTP

Left by Joe Harris at 1/2/2009 11:37 AM
Gravatar Right on! BUT before we let people touch our OLTP systems they should really have a good few years of mainframe under their belts. How can they appreciate the value of a transaction if they don't understand the all of the various IBM filesystems and the difference between big-endian and little-endian.

Now seriously... this is a natural change. DW/BI will really move on only when the next generation is totally unencumbered by previous practices. Plenty of OLTP people refuse to believe that Netezza (or DatAllegro, etc.) can really run an aggregate over a billion rows in 10 seconds. To them that's not possible.

When BW/BI practitioners take this kind of ability for granted will we begin to see what it can really do.

# re: OLAP's Ante to Play: OLTP

Left by DaveS at 1/3/2009 5:18 AM
Gravatar I agree with the basic commment that it's good to have an understanding of the tools and methods used in the source systems when implementing a datawarehouse, but in over 15 years of implementing warehouses on Teradata, WhiteCross, Netezza etc I have seen the recurring issue of having to get developers to 'unlearn' some of their treasured approaches when implementing on the newer MPP technologies. Blindly trying to reuse traditional ETL techniques etc on the newer appliances is most definitely NOT the way to get the best out of them.

# re: OLAP's Ante to Play: OLTP

Left by columbia jackets at 10/21/2010 4:36 PM
Gravatar Otherwise, you are teaching people 'Algebra' without them having an understanding of 'Math'!

snow boots for women | columbia sportswear outlet | cheap mac makeup | the north face jackets

womens snow boots | columbia sportswear | cheap makeup | cheap north face jackets

# ajibpaix

Left by pgmaos at 1/23/2012 5:43 PM
Gravatar kOA6hE iexwiqurgpzv, [url=http://lcqyovqjgrmq.com/]lcqyovqjgrmq[/url], [link=http://owohghpbyzlx.com/]owohghpbyzlx[/link], http://wpebmqrledre.com/

# vndspyi

Left by Rgdukels at 1/31/2012 8:05 AM
Gravatar dealerships jeux gratuit pour enfant - jeux gratuit pour enfant

# gaurzcz

Left by Rikdckbs at 1/31/2012 3:00 PM
Gravatar stations kostenlose spielen - kostenlose spielen

# nyaolbhc

Left by qmtakkks at 2/6/2012 8:28 PM
Gravatar xTVNJh mjxcpnjzowgh, [url=http://gfdvvsduuzov.com/]gfdvvsduuzov[/url], [link=http://bwwjalyjarwk.com/]bwwjalyjarwk[/link], http://pmwijbqmlzxt.com/

# aiumhqog

Left by Llcqxgna at 2/9/2012 1:09 AM
Gravatar mstp payday - payday

# gsyrehpae

Left by Xnumxhsh at 2/25/2012 10:18 PM
Gravatar speakeasy kopa oxytrol - kopa oxytrol

# ozbptyrld

Left by Vhijlsab at 2/26/2012 4:53 AM
Gravatar antebellum acheter strattera - acheter strattera

# elplcm

Left by Qsvjzfyh at 2/26/2012 4:11 PM
Gravatar nutch comprar fempro - comprar fempro

# jjwhuw

Left by Fbxalkry at 2/26/2012 10:40 PM
Gravatar decade acquisto allopurinol - acquisto allopurinol
Comments have been closed on this topic.

Copyright © Derek Comingore

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski