Database Management Theory & Applications Overview

By | February 8, 2016

Database Management System(DBMS):

Database is a collection of related Logical data organized in a way that data can be easily Accessed, Managed, and Updated

It is a software tool that allows Creation, Definition, and manipulation of the database.
It provides the Protection and Security and Maintains the Data Consistency (Consistency – It allows only valid data to be saved).
E.g: Mysql, Oracle, Sybase,…

Database divided into Four components:

Users – Database Administrator, System Developer, Naive User, Sophisticated User and End users.
Database Applications – It may be used in  Personal, Departmental, Enterprise and Internal.
Database management system – Allow users to Define, Create and Manages the database access.
Database – Collection on Logical data organised.
database-management-system

History

  • 1970 — Dr. Edgar F. “Ted” Codd of IBM is known as the father of relational databases. He described a relational model for databases.
  • 1974 — Structured Query Language appeared.
  • 1978 — IBM worked to develop Codd’s ideas and released a product named System/R.
  • 1986 — IBM developed the first prototype of a relational database and standardized by ANSI. The first relational database was released by Relational Software and its later becoming Oracle.

Functions of Database Management System:

Advantages

  1. Data Independence & Integrity
  2. Concurrency Control
  3. Recovery Services – Backup and recovery
  4. Provide Utility Services 
  5. Provides clear and Logical view of the process that manipulates data
  6. Security to database
  7. Advantages of Database Management System:
  8. Segregation of Application Programming
  9. Minimal data duplicate’s
  10. Easy retrieval of data
  11. Reduced development time and maintenance nee

Dis-advantages :

  1. Complexity 
  2. Costly
  3. Large in Size

Read

IELTS Essay Writing Tasks provided with Tips
How to Improve your writings with Good Tips
How to Succeed in IELTS Reading


Database Architecture:

Database architecture uses programming languages to design a particular type of software for businesses or organizations.
A data architecture should set data standards for all its data systems as a vision or a model of the eventual interactions between those data systems. Data integration, for example, should be dependent upon data architecture standards since data integration requires data interactions between two or more data systems. A data architecture, in part, describes the data structures used by a business and its computer applications software. Data architectures address data in storage and data in motion; descriptions of data stores, data groups and data items; and mappings of those data artifacts to data qualities, applications, locations etc.
Two-Tier Client/Server Architecture:
Is used for interface and application program runs on the client side. 
Three-Tire Client/Server architecture:
Used for Web Application, as shown in the figure below.

Database Management System Structure:

DBMS (Database Management System) acts as an interface between the user and the database. The user requests the DBMS to perform various operations (insert, delete, update and retrieval) on the database. The components of DBMS perform these requested operations on the database and provide necessary data to the users. The various components of DBMS are shown below –

Reference: Information is gathered from all the sources of internet.

If you like my article, please do leave a comment or like it. I feel happy that my effort has been appreciated.
Thank you..!!

Leave a Reply

Your email address will not be published. Required fields are marked *