Type of databases

How the database is classified into different type?

Database are classified into different types according to the “organizational” approach .This means there are different ways to store the data. Here are the different type of a database:

Types of Database

• Flat file based data model,
• Hierarchical data model.
• Network data model.

Flat file data model:

• In this database model data are stored in numerous files.
• Files are not linked ,so data might be repeated in more than one file.
• Main problem with this database model is redundancy.
• This model was not widely used.

Hierarchical database model:

• This database model was created to overcome the problem creted by the file based data model.

                                         fig: Hierarchical database model

In this model the series of databases are grouped together to assemble a family tree.in this family each box in the tree represent one database in this tree the top database is called the parent database.the database below the database are called the child database. In this model one parent can have many children but a child can have only one parent .the child database all connected to parent database via link called pointer

• The main problem with this database is searching a data is extremely dificult.
• Search a particular data in this database need more time .
• This model was failed.

Network database model:

• Designed to reduce the problem caused by the hierarchical data model .
• Allow more links between the child databases.
• Created not only to reduce the chance of redundant data ,but it also makes seaching for data much easier.

As shown in the figure below network model a child database can have more than one parent.

                                       fig: Network database model

Problem with this data model :

• Only database expert can use this database successfully.
• Very difficult for the general publich to use network databases for real life application.

Related article:

• what is Oracle?
• Why we need oracle10g
• history  of oracle10g

I am interested in hearing your feedback, so that I can improve my articles and learning resources for you.