Posted by 'Gurvant Pattni' on September 28, 2000 at 14:11:06 EST:
In Reply to: Oracle vs. Access posted by 'Angelyn Griffing' on September 27, 2000 at 17:17:09 EST:
:
: Hi Everyone,
: I'm going to be setting up a database for a small number of users very soon, and I'm in the planning phase of this project. I'm trying to decide whether to use Oracle-what version, or Access. Our institution supports both Access and Oracle, and the dbase could potentially be very large. I would like to go with Oracle, but need to present a case to my group for that. Has anyone ever heard of Axis Clinical Software?-that's one software package one of the physicians recommends. I'm doing research right now to compare the limitations/restrictions of Access vs. Oracle will need to make a decision fairly soon. Thanks very much for your help.
:
: Angelyn
to be quite honest there is no comparison between Oracle and Access.. Oracle is the RDBMS to use..
there are may advantages of using Oracle.
i.e
Manageabilty
Security
Portability
Easier to Maintain and Monitor
Oracle can easily adapt to Growth ..
Portability... i.e you cn take a copy of the database for example from Unix to Windows98's Personnel Oracle.
and the main thing would be PERFORMANCE... without no question.
Access will panic if i.e more than 5 users accessing the RDBMS
NT or windows98/2000.
My recommendation is ORACLE.. on Unix not NT or Windows98...
I hope this helps
Gurvant Pattni
p.s check out the oracle.com site