1 or 2 DB's for multiple universes?

[dlutzker]

What is optimal for 2 related unv's: 1 huge DB or 2 DB's with redundant data?
We are running BO in 3-Tiers with Oracle 9.
Universe 1: Large Unv. file (460 Kb, 900 objects) uses 68 GB database. Currently in use with adequate performance.
Universe 2: Universe not yet designed, about one-third common objects with universe 1. DB is 20 GB.
There will be probably be some reports that will need data from both, but for the most part, users will use one universe or the other.
Is there any advantage or disadvantage to putting all the data in one database? One Oracle instance? One server?
I assume that queries that link the universes will run a little faster if both DB's are on the same server (due to network traffic) as long as the HW can handle it.
Besides performance, there is the issue of redundant data and data integrity. What do you think the trade-offs are?
Thanks for any comments or suggestions.
Dave

 

[skrandel]

It doesn't matter.

If you have it in one database, it will be fine. If you simply copy data to another schema, you haven't really reduced the load on your server at all. If you move to a different instance, then you're balancing.

Your users will be happier if they don't have to build multiple data providers to get their reporting done. Having all your data together makes it much easier.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[dlutzker]

Thanks for the response!
While it would for every user to be able to avoid multiple data providers, I don't see how that is possible. Are you suggesting adding to the existing universe, and having only one universe? Seems like I would be pushing my luck, as the universe is already unwieldy (900 objects).
But that brings up the topic of how large can (should) a universe be?? Can you comment on that? I read previous posts on this and other forums, and I assumed that since most users are using one or the other subjects areas, that a second universe makes sense.
Whaddya think?
Thanks.
Dave

 

[skrandel]

You can't avoid multiple data providers completely. But, if you separate your data you will ensure that you will have to have them.

Subject area universes make sense.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com