Wednesday 13 February 2013

What is Database Models ?



Database models is a technique to store the database in a DBMS. Each DBMS follows different database model. Database models can be classified into two groups. They are,

1) Object - based logical model
2) Record - based logical model

1) Object - based logical model : In this model, the data, relationship and constraints are defined as a collection of ideal tools.

2) Record - based logical model : This model describes the data structure and access techniques of a DBMS.

File Management system in Database Management System

File Management System is the first method used to store the data in a database. In this model the data items are stored sequentially in a file. If we want to search an item in a file, the search starts from the first record and items are checked sequentially till the search item is matched.

Disadvantages of File Management System

1) Searching and retrieving a record is a very tedious process because it supports only sequential access.
2) Updating the data items takes more times.
3) It is not supporting directly for altering the file structure.
4) Inserting and deleting process is not easy.

0 comments:

Post a Comment

Powered by Blogger.