What time we will use oracle as a back-end?

[arul micheal]

Hi All,

1. What time we will use oracle as a back-end?

For example,I have a project called "Hospital Management".
You are all know that we have to maintain patients records(nearly 3 lakhs)into DB.

For the above scenario, which database i have to use in my project?

or is there data storage limit for data base like MS-access, sql server,oracle ?

or when will i use MS-ACCESS?

How to choose the database for my project?


Please tell me..

Thanks
Arulraj

[Jan Cumps]

Oracle and Sql Server are both suited to store lots of data.
They are capable of managing lots of concurrent connections / users,
And they can easily be placed on another server than your application.
They have proven that they are up to the task.

Ms Access can also store lots of data, and return them performantly.
But it doesn't scale well as a multi-connection/user database, and
it's not that easy to move it to another server when ehavy loads require you to spread your application over multiple servers.
Microsoft knows that. That's why they also offer sql server.

I do think that MS Access is a good database when you want to store data in tables on your personal computer. But I would not advise you to use it as a backend database for enterprice size applications.

Regards, Jan