DATABASE USERS
Database users are the persons who interact with the database and take the benefits of database.
They are differentiated into different types based on the way they expect to interact with the system.
- Naive users: They are the unsophisticated users who interact with the system by using permanent applications that already exist. Example: Online Library Management System, ATMs (Automated Teller Machine), etc.
- Application programmers: They are the computer professionals who interact with system through DML. They write application programs.
- Sophisticated users: They interact with the system by writing SQL queries directly through the query processor without writing application programs.
- Specialized users: They are also sophisticated users who write specialized database applications that do not fit into the traditional data processing framework. Example: Expert System, Knowledge Based System, etc.
DATABASE ADMINISTRATORS
Database Administrators coordinate all the activities of the database system. They have all the permissions.
Tasks of DBA
–Creating the schema
–Changing the schema
–Specifying integrity constraints
–Changing the schema
–Specifying integrity constraints
–Storage structure and access method definition
–Granting permission to other users.
–Monitoring performance
–Routine Maintenance
