Re: Code for "bucket-ized" time table???

"New Guy" <kshop_at_adnohr.net> schrieb im Newsbeitrag news:2e50789c.0405181514.11ee3328_at_posting.google.com...
> I am trying to create in my Oracle test database a "time" table that
> would have time buckets. What I mean is that, it would have some
> structure like this
>
> 0-5 minute bucket
> 10-15 minute bucket
> 15-20 minute bucket
> ...
> 55-60 minute bucket
> 0-2 hour bucket
> 2-4 hour bucket
> 4-6 hour bucket
> ...
> 22-24 hour bucket
> day number
> week number
> month number
> year number
>

A vendor neutral approach could be to create an additional bucket dimension (with a key column in your fact table) if each fact has this dimensionality. This would allow your users to see how the bucket usage developed over time.

Kind regards,

Joerg Received on Sat May 22 2004 - 15:33:50 CEST