Home » RDBMS Server » Server Administration » Single or multiple database?
Single or multiple database? [message #52595] Wed, 31 July 2002 05:03 Go to next message
rajashree
Messages: 1
Registered: July 2002
Junior Member
Hi,

We are developing a web application for HR-Payroll processing wherein all details of every company that registers sits in a single database. Is it feasible to have seperate database instance for each company to tackle problems related to application performance, correction of human errors etc.? What are the major overheads in following the multiple database approach? The proposed database is Oracle.

-Rajashree.

Report message to a moderator

Re: Single or multiple database? [message #52596 is a reply to message #52595] Wed, 31 July 2002 05:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
creating multiple databases for multiple users wont be a good solution ( unless u expect a really huge volume of data or any special applications (that need a individual database ) that may access the database.)

u can create different schema's for each company.

Else,
u need to allocate enough hardware resources and networking capabilities for every instance u create.
Extra effort for administration and maintainence.

Report message to a moderator

Re: Single or multiple database? [message #52603 is a reply to message #52595] Wed, 31 July 2002 09:16 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I agree - one database. Managing one database and one instance is much easier. Also - each new instance will hog it's own SGA, so your machine would have to be much bigger. Be aware of oracle's Virtual Private Database technology too (if the database structures are the same for multiple companies). Read on otn.oracle.com

Report message to a moderator

Previous Topic: Oracle Instance name issue
Next Topic: Index treated as primary key
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 14:50:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.