INTRODUCTION OF DATABASE MANAGEMENT SYSTEM (DBMS)

INTRODUCTION  OF DATABASE MANAGEMENT SYSTEM

DATABASE:- A Database system is basically a computer-based record-keeping system.

  • DATA:- collection of data.
  • BASE:- collection of interrelated data stored together to server multiple applications.
The intention of the database is that the same collection of data should server as many applications as possible.



LIMITATION OF FILE-PROCESSING SYSTEM 
i> Data duplication (Data  Redundancy)
ii>Data Inconsistency
iii>Unsharable data
iv>Unstandarized data
v>Insecure data
vi>Incorrect data



DBMS   
*STORE DATA 
*VISUALIZE DATA
*ACCESS (QUERY) DATA
*UPDATE DATA

ADVANTAGE OF DATABASE MANAGEMENT SYSTEM

  1. Redundancy and Inconsistency.

  • Redundancy reduces data duplication.
  • Data inconsistency is a condition that access between files when similar data is kept in different formate in two different files, or when matching of data must be done between files. As a result of data inconsistency, these files duplicate some data such as addresses & names compromising data integrity.

      2. Data Isolation.

  • It defines how/when the changes made by one operation become visible to others.

      3.  Data Integrity.

  • This can be indicated by the absence of alteration between two updates of the data records, meaning data is unchanged. 

      4. Atomicity of Operations.

  • The anatomic transaction is an indivisible & irreducible series of database operations such that either all occur, or nothing occurs.

      5. Concurrency.

  • It is the ability of a database to allow multiple users to affect multiple transactions ex-spreadsheets.

      6. Security more information.


DISADVANTAGE OF DBMS

  1. i>Cost of hardware & software of a DBMS is quite high which increases the budget of your organization.
  2. ii>Most DBMS are after, complex systems so training for users to use DBMS is required.
  3. iii>Use of the same program at a time by many users sometimes leads to the loss same data.
  4. iv>DBMS can't perform sophistication calculations. more information.

APPLICATION OF DBMS

  1. BANKING -> For customer information, account activities, payments, deposits, loans, etc.
  2. AIRLINES -> For reservations and schedule information.
  3. UNIVERSITRS -> For student informat, couse regeitrat college & grades.
  4. TELECOMMUNICATION -> It helps to keep call records, monthly bills, manufacturing
  5. FINANCE
  6. SALES
  7. MANUFACTURING
  8. HR MANAGEMENT

DATABASE SYSTEM Vs FILE SYSTEM

  1. DBMS 

  • Multi-user access.
  • Design to fulfill the need for small & large businesses.
  • Remove redundancy & Integrity.
  • Expensive but in the long term total cost of ownership is cheap.
  • Easy to implement complicated transactions.
  1. FILE SYSTEM  

  • It does not support multi-user access.
  • It is only limited to a smaller DBMS system.
  • Redundancy & Integrity issues.
  • It is cheaper.
  • No support for complicated transactions.

POPULAR DBMS SOFTWARE

MYSQL, MICROSOFT ACCESS, ORACLE, POSTGRES SQL, DBASE, FOXPRO, SQLITE, IBM DB2, MICROSOFT SQL SERVER, AMAZON WEB SERVERmore information.

TYPES OF DBMS

  1.   HIERARCHICAL DBMS:-  In this DB, model data is organized in a tree-like structure. Data is stored hierarchical ( top-down or bottom-up ) formate.   
  2. NETWORK MODEL:- This model allows each child to have multiple parents. It helps you to address the need to model more complex relationships like the orders/ parts many to many relationships.
  3. RELATION MODEL:- It is the most widely used DBMS model because it is one of the easiest. This model is based on normalizing data in the rows & columns of the tables.
  4. OBJECT-ORIENTED MODEL:- In this model, data is stored in the form of objects. The structure is called classes which display data within it. It defines a DB as a collection of objects which stores both data member's values & operations. more information.


Comments