Introduction To DBMS

DBMS Tutorial



[fblike]

DBMS : Introduction

  • DBMS stands for “Database Management System”.
  • “Database Management System is a computer software that enables and allows users to store, manipulate and manage data in the database comprising of data collected from heterogeneous data sources.
  • Data which results in generation of Databases, which contains all the data in a systematic and confined manner, which when managed is called data base management. These three are the implicit segments of any Database Management System(DBMS).
  • Data is referred to as the objects or item or entities having some meaning on their own. For example : Name of a person, Color of a car can be categorized as data.
  • Once data is collected from heterogeneous sources, it is absorbed and managed in such a systematic manner in order to generate a database. Databases that are generated are subject specific. It means, collection of any random value cannot be termed as a database.
  • When databases are managed through a software systems in which certain manipulations can be done either by controlling authority or by user in order to generate results it is known as Database Management System(DBMS).

 

For example : Hospital Management System.

 

DBMS : Hospital Management System

DBMS : Hospital Management System

 

Data Vs. Information Vs. Knowledge

  • Data is raw i.e. anything which has not been implicitly or explicitly modified and is in its original form or hold original value. For example : Ganesh (is a name), 4(a digit).
  • Processed data on from which some observation can be made is information. For example : Ganesh’s date of birth is 31/07/1995 is an information.
  • Acquiring understandings from information resulting in decision making is called knowledge. For example : Current age of Ganesh : 22.8 years i.e. Ganesh is an adult and can cast a vote.

 

DBMS : Why it is required?

  • Database Management Systems does play an important role in software projects which are dynamic in nature and are directly to user’s interaction. Higher the user’s interaction, more would be the requirement of database management systems. Following are the reasons to support why DBMS are required:
    1. Data storage in an organised manner.
    2. Better data management.
    3. Response to queries fired on database for data access.
    4. Better utilization of data resources.
    5. End users on the front end can perform transactions and retrieve data as required.

 

DBMS : Characteristics

  • Database Management Systems possess certain characteristics and features because of which it was introduced and is preferred over traditional file systems. Some of the characteristics are:

 

DBMS : Characteristics

DBMS : Characteristics

 

  1. Multi user Support : Multiple users can simultaneously access the database without any issues.
  2. Data Integrity : Any number of users can access and manipulate the data in database without affecting the integrity of data present inside the database. Integrity means trustworthy.
  3. ACID Properties Support : ACID stands for Atomicity, Consistency, Isolation and Durability. DBMS follows all four of them resulting in higher efficiency and effectiveness.
  4. Data Security : DBMS allows administrators to maintain security and restrict data access if found anything suspicious.
  5. Data Backup & Recovery : Users as well as administrators can perform data backups whenever required. In case of data is lost, data recovery is also possible.
  6. No/Less Data Redundancy : Database Management Systems are designed in such a way that chances of data redundancy are very less.
  7. Data Consistency : Data remains consistent and stable throughout in DBMS.
  8. Query Language Support : DBMS supports certain query languages such as SQL in order to retrieve desired and required results.   

 

DBMS : Applications

  • Hospitality Sector.
  • Banking Sector.
  • e-Commerce.
  • Defence Sector.
  • Social Media.
  • Telecommunications.
  • Transportation(Air/Rail/Bus).
  • Any dynamic software application.

 

DBMS : Examples

  • Microsoft Access.
  • FoxPro.
  • Dbase
  • MySQL.
  • IBM Db2.
  • Oracle Database.
  • SQLite.
  • MariaDB.