wood burning stoves 2.0*
The moose likes JDBC and the fly likes Oracle... yeah... O_o Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle... yeah... O_o" Watch "Oracle... yeah... O_o" New topic
Author

Oracle... yeah... O_o

Martin Boulianne
Greenhorn

Joined: Jan 27, 2006
Posts: 1
Hi,
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?

Thanks!
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30050
    
149

Martin,
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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, 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: http://aspose.com/file-tools
 
subject: Oracle... yeah... O_o
 
Similar Threads
about OGNL
SCWCD or OCP??
JQuery in Action Question: Is JQuery powerful enough?
which DBMS to learn ??
jdbc thin driver