Ask the Expert

Database vs. relational database

What are the differences between a database and a relational database?

    Requires Free Membership to View

In simplest terms, a "database" is a collection of records. There are many types of database models. Databases can be as simple as flat files. Databases can follow the hierarchical model, the relational model, the object-oriented model or the XML model. In the hierarchical model, the records are organized in a defined hierarchy. In the object-oriented model, records are stored as objects which have defined methods for access. The XML model stores the records in XML format. The relational model stores records according to how they relate to each other. For more information on the relational model, please see this Wikipedia article.

This was first published in October 2006

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: