Reading:  

Introduction to database management systems


Introduction to database management systems

Database is a collection of a related data. Database management system is a software designed to assist utilization and maintenance of large-scale collection of data. DBMS was first developed by Charles Bachmann in 1960. 

 

Database 

  • A database is collection of related data.
  • A database can be of varying complexity and of any size.
  • A database are maintained and generated manually or computerized

 

DBMS Task 

  • Data capture: It is task associated with data gathering.
  • Data classification: Data captured are classified based on nature and intended usage.
  • Data storage: The segregated data should be stored properly.
  • Data retrieval: Data are required frequently for further processing, Hence it is important to create some indexes so that data can be retrieved
  • Data maintenance: Maintenance is task concerned with keeping data up-to-date.

 

Characteristics of DBMS 

  • To incorporate  the  requirements  of  the  organization,  system  should  be  designed for easy maintenance.
  • Information systems should allow interactive access to data to obtain new information without writing fresh programs.
  • System should be designed to co-relate different data to meet new requirements.
  • An independent  central  repository,  which  gives  information  and  meaning  of available data is required.
  • Integrated database will help in understanding the inter-relationships between data stored in different applications.
  • The stored   data   should   be   made available for access by different users simultaneously.
  • Automatic recovery  feature  has  to  be  provided  to  overcome  the  problems  with processing system failure.

 

User types 

The diagram shows basic user types found in DBMSes. 

 

User of DBMS

  • Administrators: Administrators maintain DBMS and are responsible for administrating database. They create access profiles for users and apply limitations to maintain isolation and force security. Administrators also look after DBMS resources like required tools, system license, other software and hardware related maintenance. 
  • Designers: Designers are group of people who work on designing part of database. They identify and design whole set of entities, constraints, relations and views. 
  • End Users: End users actually get benefits of having a DBMS.

 

Description

This free tutorial covers the basics of database management system to help you with your understanding on the topic, Please note that this tutorial assumes that either you are a beginner or just want to brush up your understanding on DBMS

Tutorial covers the topics below

  • What is DBMS?
  • Architecture
  • Data Models
  • Data Schemas
  • Data Independence
  • Entity-Relation Model Basic Concept
  • Entity-Relation Diagram Representation
  • Generalization, Aggregation
  • Codd's 12 Rules
  • Relational Data Model
  • Relational Algebra
  • Structured Query Language
  • Normalization
  • Database Joins
  • Storage System
  • Indexing
  • Hashing
  • Transaction
  • Concurrency Control and Deadlock
  • Data Backup and Recovery

 



Audience

Absolute beginners or students who wish to brush up their understanding on DBMSes

Author: Subject Coach
Added on: 16th Sep 2015

You must be logged in as Student to ask a Question.

None just yet!