J
P
PvdG42
You're kidding, right?
A
Arvin Meyer [MVP]
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.
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.
B
Banana
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....
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....
K
Klatuu
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.
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.
J
John W. Vinson
Yes.
"Which is powerful - Ford F250 truck or Toyota Camry?"
Actually, Access would make a very good user frontend to an Oracle data store.
"Which is powerful - Ford F250 truck or Toyota Camry?"
Actually, Access would make a very good user frontend to an Oracle data store.
B
Banana
Klatuu said:
That would be my analogy.
Joe's the one who asked the question, but Iquoted 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!
D
David W. Fenton
Your analogy is more precise than the question. How about:
"Which is more powerful -- a Ford F250 truck or the engines in a
747?"
T
Tony Toews [MVP]
Banana said:
Well, I'd put Oracle as more like one of those very large trailers
hauling huge objects. <smile>
http://www.roadtransport.com/blogs/big-lorry-blog/2009/07/dennis-and-his-big-boys-toys-h.html
Big and expensive.
Tony