Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What's big difference btw Paradox and Oracle
- Thread starter simonliu
- Start date
simonliu,
The difference between Paradox and Oracle is similar to the difference between a motorcycle and an eighteen wheeler. Oracle is a database server designed to handle many thousands of transactions in short periods of time, as well as millions of rows.
Paradox, on the other hand, is a local database designed to handle a few hundred transactions in a short period of time and to work with less than two million records.
Paradox is really best for workgroup, departmental, or small organization database problems involving no more than a few hundred users while Oracle aims for thousands of users.
Paradox can be deployed for a few hundred dollars while Oracle requires many thousands.
While packages like Oracle, SQL Server, InterBase, DB2, and others can certainly handle the smaller projects, they tend to require dedicated computer and support resources where Paradox applications can be implemented and administred by a single person. Also, many people tend to think they need a full clinet/server database when they really need a person who knows how to design an effective database, regardless of its scope.
It's really a question of scale.
If you're looking at a smaller probject with no more than several hundred thousand rows, then you're looking at something that can likely be implemented using Paradox, dBASE, or similar packages. OTOH, if you're looking for something that can handle something like an ATM network, well, then you're looking at Oracle and the like.
Hope this helps...
-- Lance
The difference between Paradox and Oracle is similar to the difference between a motorcycle and an eighteen wheeler. Oracle is a database server designed to handle many thousands of transactions in short periods of time, as well as millions of rows.
Paradox, on the other hand, is a local database designed to handle a few hundred transactions in a short period of time and to work with less than two million records.
Paradox is really best for workgroup, departmental, or small organization database problems involving no more than a few hundred users while Oracle aims for thousands of users.
Paradox can be deployed for a few hundred dollars while Oracle requires many thousands.
While packages like Oracle, SQL Server, InterBase, DB2, and others can certainly handle the smaller projects, they tend to require dedicated computer and support resources where Paradox applications can be implemented and administred by a single person. Also, many people tend to think they need a full clinet/server database when they really need a person who knows how to design an effective database, regardless of its scope.
It's really a question of scale.
If you're looking at a smaller probject with no more than several hundred thousand rows, then you're looking at something that can likely be implemented using Paradox, dBASE, or similar packages. OTOH, if you're looking for something that can handle something like an ATM network, well, then you're looking at Oracle and the like.
Hope this helps...
-- Lance
- Thread starter
- #3
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question