GST Billing Software

header image

Database Management System Basics

Erachana Line

3. Database Management System Basics

Database management systems are meant to handle a large collection of information. Management of data involves both defining structures for storage of information and providing mechanisms that can do the manipulation of those stored information. Moreover, the database management system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access.

3.1 Components of DBMS

The components of the database management system are listed below:

Users : Users may be of any kind such as DB administrator, System developer or database users.

Database application : Database application may be Departmental, Personal, organization's and / or Internal.

DBMS : Software that allows users to create and manipulate database access,

Database : Collection of logical data as a single unit.

The database management system offers some characteristics which are given as following:

• Real-world entity

• Relation-based tables

• Isolation of data and application

• Less redundancy

• Consistency

• Query Language

• ACID Properties

• Multiuser and Concurrent Access

• Multiple views

• Security

3.2 Types of DBMS

The different types of Database Management Systems based in data models are as follows:

1. Hierarchical Database Management Systems

2. Relational Database Management Systems

3. Network Database Management Systems

4. Object-oriented Database Management Systems

1. Hierarchical DBMS

A DBMS is said to be hierarchical if the relationships among data in the database are established in such a way that one data item is present as the subordinate of another one or a sub unit. Here subordinate means that items have "parent-child" relationships among them. These are good for storing data with items describing attributes, features and so on.

Example : A book with information on chapters and verses.

2. Network DBMS

A DBMS is said to be a Network DBMS if the relationships among data in the database are of type many-to-many. The relationships among many-to-many appears in the form of a network. Thus the structure of a network database is extremely complicated because of these many-to-many relationships in which one record can be used as a key of the entire database. These have mainly been replaced by Relational database management systems in today's modern computing.

3. Object -oriented DBMS

OODBMS represent significant advance over other DBMS. While other DBMS are designed to handle structured data, an OODBMS is designed to store data from variety of media sources, such as photographs and text, and produce work, as output, in a multimedia format.

4. Relational DBMS

A DBMS is said to be a Relational DBMS or RDBMS if the database relationships are treated in the form of a table. The data can be related to other data in the same table or other tables which has to be correctly managed by joining one or more tables. Data in this type of model is stored is fixed predefined structures and are usually manipulated using Structured Query Language (SQL).