Jitendra Ajmera

Overall Structure of DBMS

A database system is a very huge and complex application. To understand the complete structure of a database we should divide it into small modules. Let’s discuss them one by one in detail. Users Those who interact with the database. On the basis of how they use the database we can divide them into three …

Overall Structure of DBMS Read More »

Different Types of Database Users

According to tasks performed on the database by different users, we can classify database users in 5 categories as given below: Database Administrator Naive Users Application Programmers Sophisticated Users Specialized Users Let’s discuss each one by one in detail. 1. Database Administrator (Super Users) A single person or a team of members can be a …

Different Types of Database Users Read More »

Types of DBMS Interfaces

Interface means “The way of communication performed in between a user and a Database management system” like query passing. This interface is further divided into four categories on the basis of technology used. Menu based Form based Graphical user interface (GUI) based Natural language based Let’s discuss them one by one in detail. Menu Based …

Types of DBMS Interfaces Read More »

Parallel Database Architecture in DBMS – Advantages & Disadvantages

In this kind of architecture multiple processors, memory drives, and storage disks are associated to collaborate with each other and work as a single unit. In this type of database system, the hardware profile is designed to fulfill all the requirements of the database and user transactions to speed up the process. The arrangement of …

Parallel Database Architecture in DBMS – Advantages & Disadvantages Read More »