Which Kind Of Databases To Use?

[keetsh]

Hi there...

I'm a little new with the subject but I was wondering on a few things...

1. What's the difference between an Access database and an Oracle one?
2. What do you need to program Oracle databases? I mean such as Access 97/2000 to program an Access one.
3. Which one is faster and which one is the most reliable?

Thanks for all your answers.

keetsh

[browner]

Hi Keetsh,

You need to buy Oracle software to program an Oracle database, it comes in load of different versions (a bit like VB). Check out their web-site.

Oracle is a much more powerfull database, it is also harder to use, harder to program, and real expensive. If you have a lot of users accessing the database at the same time Oracle is the way to go. Access also can only hold 100,000 records or something like that in a table. Oracle is much faster and much more reliable, but it is not worth the extra effort for a small single user application.

Thats my opinion for what it's worth!

[Jaguar]

Just to add to Browner's comments. Access 95/97 .MDB database cannot exceed 1 GB. Access 2000 cannot exceed 2 GB in size. Oracle/SQL Server are Database Servers. Access is a desktop database program. Doesn't really fit n the same ballpark. If you are going to have a lot of users and the transactions (updates, deletes, searches, inserts, etc) are going to be very large, then go to SQL/Server or Oracle.

Browner is right. They Client/Servers (SQL Server/Oracle) are much more difficult to program, simply because there are more features, performance tweaks, Server, network and database design techniques that are MUCH MORE difficult and required.

Access only allow 256 Concurrent users. Oracle and SQL Server allow as many as you have licenses. (of course, and good database design techniques - ie. Normalization, etc.)

Microsoft put out a good article about this...(of course, just for their products, but it at least gives you an idea).

"Which database is right?" on Microsofts site. Sorry, I don't have the exact URL. Maybe someone knows it?

[keetsh]

Thank you two, that was really kind!

keetsh