DBMS Introduction

Introduction to Database Management Systems

This video demonstrates the need of DBMS ,the problems in the file based systems and the advantages of Database Management System in today’s era.

WHAT IS DATABASE SYSTEM?

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and manage the organization and storage of data in database .

Some of the important Database Management Systems in use:-

Name of DBMS Full Name Company Name Year Introduced Latest version Query Language
IMS IBM Information Management System IBM 1966 IMS version 12 DL/I
IDMS Integrated Database Management System Cullinet, CA technologies 1983 CA IDMS/DB Version 18.0 SQL
MS-Access Microsoft Access Microsoft 1992 MS-Access 2013 SQL
SQL Server 2000 Structured Query Language Server Microsoft 2005 SQL Server 2012 T-SQL
Oracle Oracle Oracle 1978 Oracle 11g PL-SQL

Applications of DBMS

  • Railway reservation and ticketing.
  • Airlines booking.
  • Hotel reservation.
  • Movie ticket booking.
  • Retail store billing.
  • Salary processing.
  • Mobile address book.
  • Students mark sheet processing and printing.
  • News paper printing and publications.
  • Library Information System.

LIMITATIONS OF DATA PROCESSING ENVIRONMENT

  • Data redundancy:
  • Data Inconsistency:
  • Data Integrity problems:
  • Data Access difficulty:
  • Data Isolation:
  • Concurrent Access anomalies:

Advantages of using DBMS

  1. It represents complex relationships among different data items:
  2. Enforces data integrity in a System:
  3. Keeps a tight control on data redundancy:
  4. Efficient data access:
  5. Maintains data dictionary:
  6. Provides different interfaces through which users can manipulate data: