Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    Relational DBs VS Old ones (Index based)

    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.


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

  2. #2
    Join Date
    May 2002
    Phoenix, AZ
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts