Database Model

Different type of Database Models:

Database are classified into different types according to the organization approach

  • Flat file data model
  • Network Data Model
  • Hierarchical data Model
  • Relation data model
  1. Flat File Data Model:
  • Data are stored in numerous files.
  • Files are not linked so data might be repeated in more than one file.

Disadvantage

  • Big Problem in the redundancy
  1. Hierarchical Data Model:
  • Data is linked in the form of tree
  • This is 1: n relation where in single parent can have multiple children’s.

Advantage

  • Redundancy is eliminated.

Disadvantage

  • Searching a data is extremely difficult. Searching a particular data needs more time.
  3.  Network Data Model:
  • Allows more links between the child data .
  • There m: n relationship where in a single child can have multiple parents. Advantage
  • Reduces Redundancy
  • Searching is easier.

Disadvantage

  • Difficult to handle the Network.
  1. Relation Database Model:
  • A relation Database is a collection of relation or ow dimensional tables
  • It stores data in form of rows and columns.
  • E F Codd proposed the relation model for database system in 1970.
  • It is the basis for the relation database management system(RDBMS)

Relational database model

Relational database model
• A relation Database is a collection of relation or Row dimensional tables
• E F Codd proposed the relation model for database system in 1970.
• It is the basis for the relation database management system(RDBMS)

It Consists of following
• Collection of an objects and relation.
• Set of operators to act on the relations.
• Data Integrity for accuracy and consistency

RDBMS
• Data is stored in form of table.
• A relation database can also contain other database object like views, indexes,
stored, procedures, functions, and triggers apart from the table.

Database Management System:
• A database Management system is a set of programs in an
OS that creates and maintains database.
• Allows user to store and retrieves information from the database.
• Provides an interface for the user to interact with database.

Ex: Oracle Log: G stands for grid, Oracle log support grid computing

RDBMS Application

Some popular RDBMS Application
• MySQL
• SQL Server