It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Oracle... yeah... O_o Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle... yeah... O_o" Watch "Oracle... yeah... O_o" New topic

Oracle... yeah... O_o

Martin Boulianne

Joined: Jan 27, 2006
Posts: 1
Got a question here that may sound stupid but... I don't know Oracle, though I heard of it as the most powerful database out here.
What is the difference between Oracle and, say, MySQL, and what makes it more powerful?

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

Welcome to JavaRanch!

Oracle is a commercial product that has been around longer. As such, Oracle has put more time/effort/money into making it perform faster, clustering, enterprise management, etc.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Well, you need to be clear on what you mean by "powerful".

Oracle is very hugely featureful; working with it has been my full-time job for a few years now, and I know about most of the major features at a high level, but have actually used a very few. For example, my company has no need for "multi-master replication", a feature wherein multiple databases synchronize changes with each other, often across wide geographic distances (e.g. so that the ATMs in Chicago have the same account balances as the ATMs in Los Angeles). Oracle also has some powerful packages such as for text indexing and one for managing geographic or spatial data.

Oracle is also designed for very high concurrency; all databases eventually suffer slower and slower repsonse times as more transactions are processed, but Oracle can handle a higher degree of parallelism than many of the other databases I'm familiar with before response time degrades, and it degrades slower. However, for low-to-medium concurrency, other databases are competitive; in fact, for single user/single connection, some other databases were faster (last time I checked, about 18 months ago).

Oracle also has good support, which I find to be pretty powerful...
[ March 15, 2006: Message edited by: stu derby ]
I agree. Here's the link:
subject: Oracle... yeah... O_o
It's not a secret anymore!