PDA

View Full Version : Relational DBs VS Old ones (Index based)


kayard
07-01-02, 12:21
I need to know what are the main differences between relational DBs and old ones( like DBase and other index based)
I'd like to know pros and bad sides.
If anyone know a site where I can gather what I need, please post its address.

Thanks a lot

Looking forward to hearing from one of you.

Kayard.

Ah I've been using relational DBs for 3 years but I don't know why !!
ain't it funny ?

tsclark
07-01-02, 18:36
The primary difference is in the systems original intention. The "old" database systems provided indexed (i.e., fast) access and very little overhead. They were designed for maximum speed. "Relational" database systems are primarily concerned with the integrity of the data first and speed second. They enforce referential integrity and provide commit and rollback features (i.e, transactions) and are generally logged for recoverability.

Anyone can create on offset to a file to quickly find information, but it takes a heck of a lot more than that to have a recoverable, high integrity data base management system.

I hope this helps.

Troy