By: Leo D'Adderio
Date Submitted: 2010-12-02
Generally speaking, there are 2 types of databases: flat and relational.
A flat database is a single databases that serves a sole purpose of containing data without having it's own properties such as fields, interlinked with another database. A flat database, is generally used to store information, and quickly retrieve the searched data to display in a certain way depending on how the front end of the database has been designed. A flat database will only have one table associated to its original database.
A relational database is a single database that is comprised of multiple tables vs a single table (ie flat database). In addition, a relational database can have multiple tables interlinked via reference fields for linking purposes. This linking of multiple tables is used in SQL databases where tables need to be JOINED or UNIONED in order to search for data in another table that is associated in a primary table.