Re: Drill-Down

Another note on drill-down: It is what all marketing data users want and need to gain insight into their data and derive answers to business questions, yet it poses great challenges for traditional RDBMSs. Often, the 2nd, 3rd, and so on SQL queries are targeted for the results of the 1st. What do you do, therefore, with the results of the 1st? Store in a temporary table? What if the results are 3 gb worth of data? The answer always varies.

TiborVari (tiborvari_at_aol.com) wrote:
: In article <30mij4$5g5_at_hopscotch.ksr.com>, bruceg_at_ksr.com (Bruce
: Gatterman) writes:
 

: The term drilldown means to go "deeper" into the data you are examining.
: For example: if you are looking at sales figures for regions (geographic
: dimension) going down and months going across. A drilldown on a selected
: region (say East) would produce the same report except show what makes up
: the East region (say territories). Next drilldown would be to select a
: territory to see what cities that belong to it and their sales figures..
 

: I hope this helps.
 

: Tibor Vari
Received on Fri Jul 29 1994 - 16:19:04 CEST