Re: Mixing OO and DB
Date: Mon, 17 Mar 2008 18:12:30 GMT
"topmind" <topmind_at_technologist.com> wrote in message news:575c778a-4cde-43f0-9ab9-5812e88ed22e_at_i12g2000prf.googlegroups.com...
> For example, subscribers had a list of products/services they
> subscribed to. However, different departments needed summary
> classifications of these items and didn't care much about specific
> products (ID's). Without these, each query had to re-summarize (re-
> classify) them on each use. That made the queries bulky (and slow). A
> global classification table would not cut it because each department
> had different classification systems/groupings. (And the DBA ruled out
> custom classification tables, for good or bad.)
This is a little off topic.
One of the examples that Ralph Kimball uses in explaining multidimensional databases and star schemas is precisely the situation where different departments, like Manufacturing and Marketing, have different classification schemes for products. The design is relatively simple-minded and by no means requires adherence to the star shape to use it. But it does show how easily such difficulties can be obviated. Received on Mon Mar 17 2008 - 19:12:30 CET