Ask the Expert

Flat file versus relational databases

What is the difference between a flat file database and a relational database?

    Requires Free Membership to View

A "flat file" database allows the user to specify data attributes (columns, datatypes, etc) for one table at a time, storing those attributes independantly of an application. dBase III and Paradox were good examples of this kind of database in the CP/M and MS-DOS environments, and the original FileMaker was a good Mac O/S example.

A relational database takes this "flat file" approach several logical steps further, allowing the user to specify information about multiple tables and the relationships between those tables, and often allowing much more declarative control over what rules the data in those tables must obey (constraints).

For More Information

This was first published in December 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: