Database

by

What is Database?

  • It is a Collection of information that has been written in predetermind manner and stored into a particular location is called as database.
  • DBMS is tool or Software which can be used for managing and maintaining the data with in the database.
  • Here DBMS will act as a interface between the user and database.
Database
Database

Models of Data base Management Ssystem

DBMS Contain the following 6 models those are

  1. File Management System(FMS)
  2. Heirarchy Management System(HMS)
  3. Netweok Data base Magement System(NDBMS)
  4. Relatonal Data base Management System(RDBMS)
  5. Object Relational Data base Management System(ORDBMS)
  6. Object Oiented Data base Management System(OORDBMS)

File Management System

FIle Management Syetm is a 1st model of DMBS which was introduced in 1950’s. In this model the data will be stored in sequential or contineous stream of character manner like below.

101KartikGupta50000010-10-1990Pune

DrawBacks

  • there is no security to the file information, it is does support datatype and index mechanism.
  • To Maintain inconsistancy data in a file “there is no proper arrangement of values”.
  • Retrieving data from the location is very slow because for every file required information perpose the user has to perform serching operation on a file.
  • It is Dificult to manuoulate the data in the file.

Heirarchy Management System

  • it is second model of DBMS which introduced by the IBM when the were developing a project is named as information management systemin 1990’s.
  • In this model data will be stored in the form of tree structure and it contains the following three level those are

Root Level :- It represent database location or database name.
Parent Level:- it is represent table or entity name.
Child Level :- It will represent columns or attritbutes.

Advanteges

  • It support DataType and Index Mechanism
  • To Maintain the consistency of the data properly arranging the values.
  • Retriving the data faster than that €FMS Model.

Drawback

  • In this Database Model only one person can intreact with the data base server at a time.
  • If we want to add a new value to as existing structure than user has to reconstruct the entire structure.
  • so it leads time consuming and bardan of the program willbe increased.

Leave a Comment