Home » Developer & Programmer » Designer » Is it good to have many databases in one server?
Is it good to have many databases in one server? [message #170305] Wed, 03 May 2006 04:21 Go to next message
motolongines
Messages: 3
Registered: May 2006
Location: dun
Junior Member

This is my issue, I would like to design databases which is each slightly different for each customer. And the databases reside in my server. So better to put all in one database or make many databases?

thank you
regards,

effendy
Re: Is it good to have many databases in one server? [message #170521 is a reply to message #170305] Thu, 04 May 2006 04:17 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
are these databases all meant for the same application? or are they for different application?

if they are for different application , it makes sense to have different databases..if they are all for the same application, it may be better to have one database..

Re: Is it good to have many databases in one server? [message #170530 is a reply to message #170521] Thu, 04 May 2006 04:37 Go to previous messageGo to next message
motolongines
Messages: 3
Registered: May 2006
Location: dun
Junior Member

Well, Not really the same application,
but the applications will run on server then the client connect by remote desktop connection.
well, from the infrastructure, i already disagree bout running the program by remote desktop. but what can i do...??

Re: Is it good to have many databases in one server? [message #170574 is a reply to message #170530] Thu, 04 May 2006 07:10 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
If the applications are different, then they should reside on a different database.

that makes for logical grouping isnt it? -since the applications are different, even from security point of view, why should they share the same database?

Re: Is it good to have many databases in one server? [message #170709 is a reply to message #170574] Thu, 04 May 2006 20:14 Go to previous messageGo to next message
motolongines
Messages: 3
Registered: May 2006
Location: dun
Junior Member

sorry i m new one to develop real application Smile

ok. the condition is like this :

I can make an application support only for one client,

but I afraid in the future if I need to customize my application

and will impact my database structure and result with new different

databases.

And problem is company only provide one server.


Embarassed
Re: Is it good to have many databases in one server? [message #170823 is a reply to message #170709] Fri, 05 May 2006 05:55 Go to previous message
orausern
Messages: 826
Registered: December 2005
Senior Member
Not clear to me what is meant!
Previous Topic: error in designer10g ora-01917
Next Topic: Table references on PL/SQL Modules
Goto Forum:
  


Current Time: Fri Mar 29 10:44:16 CDT 2024