Skip to main content

Posts

Showing posts with the label The Crazy Programmer Overall Structure of DBMS Overall Structure of DBMS The Crazy Programmer

Overall Structure of DBMS Jitendra Ajmera The Crazy Programmer

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. Image Souce Users Those who interact with the database. On the basis of how they use the database we can divide them into three categories: DBA: Database administrator have full control on database. They may be a group of persons or a single person. They use Data Definition Language to pass on schemas and mapping constraints on database, which further passed to DDL processor. Users: These are end users who actually use database for their own purposes. They pass queries with the help of interface system provided. These queries further passed on to the Queries processor. Programmers: These are the persons who actually creates database and manages it technically. They use Data Manipulation Language statements to pass on application programs to database, which further goes to DML processo