February 23rd, 2010

DBMS Models

Posted by admin in A. Relational Database Basics

NETWORK databases were created first. They have very little redundancy but have structural complexity.

HIERARCHICAL databases have a parent/child hierarchy that is faster than network databases, but it suffers from structural inflexibility, redundancy problems, and broken pointers. As it is an older DBMS, it is called a legacy database.

RELATIONAL databases are almost exclusively the database of choice today. Many businesses have converted to Relational DataBase Management Systems (RDBMS) for performance and ease of maintenance.

Comments are closed.

Sorry, the comment form is closed at this time.