Database System Structure & architecture
• Used by the computer system on which the database system runs.
• Database systems can be centralized, or client-server.
• A database system is divided into modules that deal with different responsibilities of the
overall system.
• The functional components are broadly divided into the users, interface, query processor
components, and the storage manager.
• Primary goal:- retrieving information from and storing new information into the
database.
, I. SYSTEM USERS
Four different types of database-system users,
1. Application programmers
2. Sophisticated users and Specialized users:-
3. Database Administrator
4. Naive users
1. Application programmers
• Computer professionals and write application programs.
• They interact with the system through DML calls.
• DML calls are embedded in a program written in a host language (for example PHP,
python, c).
• These programs are commonly referred to as application programs.
2. Sophisticated users and Specialized users:-
• Interact with the system without writing programs.
• They request in a database query language as query form.
• Each query is submitted to a query processor.
• Query processor is to break down DML statements into instructions that the storage manager
understands.
• They work as an analyst.
• Specialized users are sophisticated users who write specialized database applications like
computer-aided design Systems, knowledgebase, and expert systems, etc.
• The user uses complex data types (for example, graphics data and audio data).
(3) Database Administrator (DBA)
• DBA has central control over the system.
• Responsible for following functions:
(i) Schema Design and Maintenance,
(ii) Physical Schema and Organization Modification,
(iii) Authorization and Security,
(iv) Integrity Constraint Specification,
(v) Recovery from Failure,
(vi) Database Upgradation
• Used by the computer system on which the database system runs.
• Database systems can be centralized, or client-server.
• A database system is divided into modules that deal with different responsibilities of the
overall system.
• The functional components are broadly divided into the users, interface, query processor
components, and the storage manager.
• Primary goal:- retrieving information from and storing new information into the
database.
, I. SYSTEM USERS
Four different types of database-system users,
1. Application programmers
2. Sophisticated users and Specialized users:-
3. Database Administrator
4. Naive users
1. Application programmers
• Computer professionals and write application programs.
• They interact with the system through DML calls.
• DML calls are embedded in a program written in a host language (for example PHP,
python, c).
• These programs are commonly referred to as application programs.
2. Sophisticated users and Specialized users:-
• Interact with the system without writing programs.
• They request in a database query language as query form.
• Each query is submitted to a query processor.
• Query processor is to break down DML statements into instructions that the storage manager
understands.
• They work as an analyst.
• Specialized users are sophisticated users who write specialized database applications like
computer-aided design Systems, knowledgebase, and expert systems, etc.
• The user uses complex data types (for example, graphics data and audio data).
(3) Database Administrator (DBA)
• DBA has central control over the system.
• Responsible for following functions:
(i) Schema Design and Maintenance,
(ii) Physical Schema and Organization Modification,
(iii) Authorization and Security,
(iv) Integrity Constraint Specification,
(v) Recovery from Failure,
(vi) Database Upgradation
