DATABASE USERS AND DATABASE ADMINISTRATOR
The primary goal of the database is to retrieve information from and store a new information into the database .people who work with the database that can be categorized as database users and database administrator.
DATABASE USERS -:
There are four types of database users -;
1-Naive user-
2-Application programmer -
3-Sophisticated user-
4-Specialized user-
Naive users-; Naive user is unsophisticated user ,who interact with the system by invoking on of the application program that have been written previously .for example - clerk of the university .who need to add new instructor in the department (a) .invoke program "new_hire" .Program ask the clerk for the name of the instructor and his id ,department and salary .The typically user interface for the naive user is form interface .the user fill the information on the appropriate field in the form .
Application programmers -: Application programmer is a computer professional .who write the application program .Application programmer can choose from many tools to developed for the user interface .Rapid application development tools are the tools that enables the application programmer create form and report with minimal programming effort.
Sophisticated users -:Sophisticated users are the user ,who interact with the system without writing a program.they form their request either using a database query languages or by using a tools such as data analysis software .
Specialized users-: Specialized users can be work on specialized database program .that do not fit into the traditionally data processing frame work .
DATABASE ADMINISTRATOR-
One of the main reason for using DBMS has central control for both data and the program that access those data .A person who has such central control over the System that is called Database Administrator .The function of Dba include -;
Schema definition-; The dba creates a original database schema by executing a set of data definition statement in DDL.
Storage structure and access method definition -;it is responsibility of dba for creating a structure of the database .
Schema and physical organisation modification-: The dba carries out changes to the schema and physical organisation to reflect the changing need of the organisation .
Granting of authorization for data access-: By granting there are different types of authorization .dba can be regulate which part of the database various users can access.
The dba can be create update and delete file from the database .
It is responsibility for the security and protection of the database from the an authorized users.
The primary goal of the database is to retrieve information from and store a new information into the database .people who work with the database that can be categorized as database users and database administrator.
DATABASE USERS -:
There are four types of database users -;
1-Naive user-
2-Application programmer -
3-Sophisticated user-
4-Specialized user-
Naive users-; Naive user is unsophisticated user ,who interact with the system by invoking on of the application program that have been written previously .for example - clerk of the university .who need to add new instructor in the department (a) .invoke program "new_hire" .Program ask the clerk for the name of the instructor and his id ,department and salary .The typically user interface for the naive user is form interface .the user fill the information on the appropriate field in the form .
Application programmers -: Application programmer is a computer professional .who write the application program .Application programmer can choose from many tools to developed for the user interface .Rapid application development tools are the tools that enables the application programmer create form and report with minimal programming effort.
Sophisticated users -:Sophisticated users are the user ,who interact with the system without writing a program.they form their request either using a database query languages or by using a tools such as data analysis software .
Specialized users-: Specialized users can be work on specialized database program .that do not fit into the traditionally data processing frame work .
DATABASE ADMINISTRATOR-
One of the main reason for using DBMS has central control for both data and the program that access those data .A person who has such central control over the System that is called Database Administrator .The function of Dba include -;
Schema definition-; The dba creates a original database schema by executing a set of data definition statement in DDL.
Storage structure and access method definition -;it is responsibility of dba for creating a structure of the database .
Schema and physical organisation modification-: The dba carries out changes to the schema and physical organisation to reflect the changing need of the organisation .
Granting of authorization for data access-: By granting there are different types of authorization .dba can be regulate which part of the database various users can access.
The dba can be create update and delete file from the database .
It is responsibility for the security and protection of the database from the an authorized users.
0 comments:
Post a Comment