This is the what OLAP is all about. http://en.wikipedia.org/wiki/Olap
And as another has mentioned...MITS is one example that was programmed for use with U2 another term, aside from cube that you will grow to love with OLAP is "drill down" George > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com > Sent: Thursday, January 14, 2010 10:44 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Cubes > > I wasn't familiar with the term cube and I did some research. I found > this. > > "The ideal structure for such storage is a star schema, realized as a > multidimensional cube. In such a structure, tables are related not in > the > relational manner of an RDBMS, but by a central key table that defines > the > dimensions along which data will be gathered from logically-related > tables. For this to work, data must be denormalized. " > > That sounds a lot like an MV database. Wouldn't MV databases be the > natural platform for data mining? Maybe I am oversimplifying. > > Charles Shaffer > Senior Analyst > NTN-Bower Corporation > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
