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: [email protected] [mailto:u2-users-
> [email protected]] On Behalf Of [email protected]
> Sent: Thursday, January 14, 2010 10:44 AM
> To: [email protected]
> 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
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to