What do you understand by database users ? Describe
the different types of database users.
- Database users :-
- 1.Application programmers :
- 2. Sophisticated users :
- 3. Specialized users :
- 4. Standalone users :
- 5. Native users :
- Ques.Who are data administrators ? What are the functions
- 1. Schema definition :
- 2. Storage structure and access method definition :
- 3. Schema and physical organization and modification :
- 4. Granting of authorization for data access :
- 5. Integrity constraint specification :
Database users :-
Database users are the one who use and take the benefits of database. The
different types of users depending on the need and way of accessing the
database are :
1.Application programmers :
a. They are the developers who interact with the database by means
of DML queries.
b. These DML queries are written in the application programs like C,
C++, JAVA, Pascal etc.
c. These queries are converted into object code to communicate with
the database.
2. Sophisticated users :
a. They are database developers, who write SQL queries to select/
insert/delete/update data.
b. They directly interact with the database by means of query language
like SQL.
c. These users can be scientists, engineers, analysts who thoroughly
study SQL and DBMS to apply the concepts in their requirement.
3. Specialized users :
a. These are also sophisticated users, but they write special database
application programs.
b. They are the developers who develop the complex programs
according to the requirement.
4. Standalone users :
a. These users will have standalone database for their personal use.
b. These kinds of database will have predefined database packages
which will have menus and graphical interfaces.
5. Native users :
a. These are the users who use the existing application to interact
with the database.
b. For example, online library system, ticket booking systems, ATMs
etc.
Ques.Who are data administrators ? What are the functions
of database administrator ?
Ans.Â
Database administrators :- Database administrators are the personnel’s who has control over data andprograms used for accessing the data.
Functions/role of database administrator (DBA) :
1. Schema definition :
a. Original database schema is defined by DBA.
b. This is accomplished by writing a set of definitions, which are
translated by the DDL compiler to a set of labels that are permanently
stored in the data dictionary.
2. Storage structure and access method definition :
a. The creation of appropriate storage structure and access method.
b. This is accomplished by writing a set of definitions, which are
translated by the data storage and definition language compiler.
3. Schema and physical organization and modification :
a. Modification of the database schema or the description of the physical
storage organization.
b. These changes are accomplished by writing a set of definition to do
modification to the appropriate internal system tables.
4. Granting of authorization for data access :
DBA grants different types of authorization for data access to the various users of the database.
5. Integrity constraint specification :
DBA carry out data administration in data dictionary such as defining constraints.