Types of Database


☞ A database can be classified into two categories :

1. Flat File Database
2. Relational Database

Flat File Database

☞ Data is stored in a single table.

☞ Usually suitable for less amount of data.

Relational Database

☞ Data is stored in multiple tables and the tables are linked using a common field.

☞ Relational is suitable for medium to large amount of data.


Database Servers

☞ Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software.

☞ Databases available on the database servers are accessed through command line or graphic user interface tools referred to as Frontends

☞ Database servers are referred to as Back-ends.

☞ The entire approach is referred to as a client-server model.