• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
reply
    Bookmark Topic Watch Topic
  • New Topic