This is an interview with IBM’s expert Matt Huras on DB2. He shares a sneak preview of the new release of DB2 version 8 and its technical highlights, including it’s high-availability features, improved administration tools, performance advice, and multidimensional clustering, which allows data to be clustered according to several different “dimensions” simultaneously. There’s a free download of DB2 v8.
Multidimensional Clustering for Linux, Unix, and Windows
Submitted by GreyFox 2002-09-24 Databases 4 Comments
i used to do this multi-dimensional stuff way back in ’94 and 95. I had to use some software by a company that was later bought by Oracle – darn, can’t even remember their name! anyway, took a lot of classes up in Boston, and it was just ok, mostly a pain in the butt.
Clustering by dimensions is exactly like using Excel’s Pivot Tables – exactly. but it takes 3-10 times as long to set up, and you get more billable hours at higher rates. for most people excel will be fine, but they don’t know that, and will fork out tons to IBM for this stuff… just dump the data from a sql server to excel, use the pivot table wizard, and voila. does open office have pivots yet?
thanks for bringing back bad memories 😉
What is pivot table? BTW is there any good and quick tutorial for mysql or postgres?
it takes too long to explain – go into excel help and read up on the pivot table wizard, then do a couple examples.
it is a VERY powerful way to analyze data, very easily. you’ll find a million ways to use it.
Since there are a lot of cheaper (free) database solutions out there, I doubt that people who need DB2 have data simple enough to just dump and put into excel.
That solution works if you’re just trying to do something for yourself, but not as easy to tie these data manipulations into enterprise software running on your servers.