Which is powerfull? ORACLE or MS Access 2007

  • Thread starter Thread starter JOE
  • Start date Start date
Oracle can handle far more data, and being a server database engine, is more
robust than Access. But while apples and oranges are both fruit, they are
not comparable.

If you want to compare Oracle to another database engine, try comparing it
to SQL-Server. For my money, SQL-Server wins hands down. SQL-Server is less
expensive, has more datatypes, is much faster, costs much less to develop
with, and is in every respect better than Oracle. In fact, I've been so
frustrated working with Oracle, that I no longer will do so. The only people
that intentionally choose Oracle as a new purchase, must do so at the 19th
hole bar of the golf course, because they surely can't be making that
decision while sober.
 
JOE wrote:

Just to help you understand the fundamental problem with the question.

You're basically asking us to compare a 40 feet long trailer to a truck.

How do you do such thing? Especially that you need a truck to pull the
trailer in first place?

Access is basically a great front-end and comes with a databse engine
built-in (e.g. Jet/ACE). You can hook it up to Oracle, SQL Server or
MySQL or whatever you want, just as the truck can be hooked up to the
auto transport, a flatbed or open top trailer.

You could legitimately compare Oracle with Jet as they're both database
engine (e.g. a 40 feet long trailer and a 10 feet long trailer). To be
sure, we still have to keep in mind that Jet is fundamentally different
from Oracle. For one thing, it's file-based. It also has no daemon. All
processing are essentially done client-side (this isn't to imply that it
must do table scans all over the place; that's a good old myth). But
because of those things, Jet is far more easier to set up and run. In
short, it does a different job. A better comparison would be against
SQLite, which is also file-based and lacks a daemon, then hopefully you
will appreciate that those does have their uses.

The greatest thing about Access is that it's very versatile; as
explained earlier, you can hook it up to any engine that actually meets
your needs.

I hope this helps....
 
Good analogy, JOE.
You can't haul a load of lumber to build a house with a pickup, but it would
be foolish to drive an 18 wheeler to the convenience store for a six pack.
 
Yes.

"Which is powerful - Ford F250 truck or Toyota Camry?"

Actually, Access would make a very good user frontend to an Oracle data store.
 
Klatuu said:
Good analogy, JOE.
Click to expand...

That would be my analogy. :o Joe's the one who asked the question, but I
quoted him and his OP didn't have any message (or at least I didn't see
any message; only the title) so it looked as if the roles was reversed.

Oh, well! :)
 
Yes.

"Which is powerful - Ford F250 truck or Toyota Camry?"

Actually, Access would make a very good user frontend to an Oracle
data store.
Click to expand...

Your analogy is more precise than the question. How about:

"Which is more powerful -- a Ford F250 truck or the engines in a
747?"
 
Back
Top