Re: Oracle partitioning

"Kary" <kalapanda_at_yahoo.com> wrote in message news:1124733181.210515.320680_at_f14g2000cwb.googlegroups.com...
> All,
>
> I am working on a solution where a company is hosting a website
> (portal) where it has its dozen or so customers log in and run
> reports(ad-hoc and canned).
>
> Each customer will query his/her own data (no queries across
> customers). This is indeed the case and just for the sake of discussion
> let us also assume this situation will not change ( given that change
> is the only constant!).
>
> Would it make make sense for the hosting company to partition by
> customer then ? Is it possible and would it help to further partition
> by time period i.e say by month(inside of each customer partition).
>
> What are your thoughts on partitioning like above both from a
> performance standpoint and also from a maintenance standpoint.
>
> Thanks,
> KK.
>

assuming the table structure is the same for all customers one could do a Virtual Private Database (vpdb). I have used a VPDB in the past, it does have some pros but I guess I come down on the cons.

I would tend to want use the multipule instances solution even though it does induce more load on the host than a vpdb would. Trust me on this one: no 2 customers are going to want to do things the same way for a long time. One will come up with some other requirement which may or may not break the VPDB. if the table structures are different then you could use different schemas.

partitioning does not sound like it is the path you want to try and make work given the situation Received on Tue Aug 23 2005 - 16:34:30 CDT