Database Management System (DBMS) | Computer Science

Data can be defined as raw facts and figures that can be organized later on.
Database is the collection of coherent meaningful data. The full form of DBMS
is Database Management System. It is the grouping of related data, records
whereas management system is the collection of programs for saving and
retrieving the data records. DBMS can be defined as collection of programs
which are required to store as well as access the data in efficient and easy way.
Introduction

 Hierarchical Database
 Network Database
 Relational Database
 Object Oriented Database
Different Types of DBMS

The information processing is part into
unmistakable parts. A section is either
requester (client) or supplier (server).
One or more requests has been sent to
the client to the server during data
processing in order to perform
determined tasks. The server part give
the services to the client side.
Client Server Architecture in Database

 Data consistently incorporated (i.e., access in light of one pattern)
 Data physically distributed among numerous database nodes
 Processing is distributed among numerous database hubs
Distributed DBMS

 Reflects hierarchical structure
 Improved share capacity
 Improved accessibility
 Improved reliability
 Improved execution
Advantages of DDMS

 Single column index – It is created on single table column.
Syntax – Create index index_name
On Table_name (column_name);
 Unique Index – It is used for data integrity. It doesn’t allow duplicate values to be
entered in the column.
Syntax - Create UNIQUE index index_name
On Table_name (column_name);
 Composite Indexes – It is created on two or more columns of a table.
Syntax - Create index index_name
On Table_name (column1, column2);
 Implicit Indexes – These are automatically created by database server on the
creation of object.
Different types of Indexes

A network database model is a database
model that permits various records to be
connected to a similar proprietor
document. The model can be viewed as
a top down tree where the branches are
the part data connected to the proprietor,
which is the base of the tree.
Network Database Model

Data concurrency implies that numerous clients can access information
in the meantime. The complete isolation of simultaneously running
transactions could imply that one transaction couldn't perform insert into
a table that is being queried by another transaction.
Database Concurrency

Hey Friends,
This was just a summary on Database Management
System (DBMS). For more detailed information on this
topic, please type the link given below or copy it from the
description of this PPT and open it in a new browser
window.
http://www.transtutors.com/homework-help/computer-
science/database-management-system.aspx

Database Management System (DBMS) | Computer Science

More Related Content

What's hot

Viewers also liked

Similar to Database Management System (DBMS) | Computer Science

More from Transweb Global Inc

Recently uploaded

Database Management System (DBMS) | Computer Science