Re: Database comparisons

What's the difference between a bike and a mercedes? (not implying which is which - you are simply asking for an apples/oranges comparison). Now, assuming you want to talk about Oracle - the base database, not Oracle - the company, nor Oracle - the applications, nor Oracle - tools, etc.

Oracle designed to be used in a 'big iron' environment with many users and much data. (1,000 users and 1 Terabyte data is not very unusual.)

Access basically designed to be used by 1 person on a PC. (Grown up a bit, but that's the fundemental design.)

Each mode has advantages and associated cost and price. Depends on what you are trying to accomplish.

Biggest differences in my mind - Oracle needs 'professional IT' to maintain (tune, backup, etc.) and Oracle database comes with a lot of extra database capabilities (objects, native text search, Java in the database, programming language ...) - Access has a few more 'useful' native datatypes (that have always gotten me into trouble) AND Access has a nifty 'do it yourself' screen development tool built in.

Another difference is price (a lot of idiots start yapping about the price of Oracle without having any understanding about what they're buying) but yes, there is a significant difference in apparent price. That said, try rolling out Access to every user in a 10,000 employee company AND rolling out the related applications AND trying to do back up, etc. Then talk to me about price and cost. (Sorry about that!)

/Hans

chatman5_at_webtv.net wrote:

> What is the major differences between Oracle and Access, What is the
> plus and minus of both?
Received on Fri Apr 27 2001 - 08:47:28 CEST