0
data base administrator is the person who control the data in the organisation its main function to control the information of the particular enterprise
1.3 Functions of a DBMS
The functions performed by a typical DBMS are the following:
· Data Definition
The DBMS provides functions to define the structure of the data in the
application. These include defining and modifying the record structure, the
type and size of fields and the various constraints/conditions to be satisfied by
the data in each field.
· Data Manipulation
Once the data structure is defined, data needs to be inserted, modified or
deleted. The functions which perform these operations are also part of the
DBMS. These function can handle planned and unplanned data manipulation
needs. Planned queries are those which form part of the application.
Unplanned queries are ad-hoc queries which are performed on a need basis.
· Data Security & Integrity
The DBMS contains functions which handle the security and integrity of data
in the application. These can be easily invoked by the application and hence
the application programmer need not code these functions in his/her
programs.
· Data Recovery & Concurrency
Recovery of data after a system failure and concurrent access of records by
multiple users are also handled by the DBMS.
· Data Dictionary Maintenance
Maintaining the Data Dictionary which contains the data definition of the
application is also one of the functions of a DBMS.
· Performance
Optimizing the performance of the queries is one of the important functions of
a DBMS. Hence the DBMS has a set of programs forming the Query Optimizer
which evaluates the different implementations of a query and chooses the
best among them.
Thus the DBMS provides an environment that is both convenient and efficient to use
when there is a large volume of data and many transactions to be processed.
What else can I help you with?
What is the difference between database and database administrator?
Database is the data stored in the server and Database administrator is the person who designs the database.
What responsibilities does an Oracle Database Administrator have?
The responsibilities are quite important. Interacting with consumers and employees is a main responsibility. Database design and repair are also other main responsibilities.
What is the explanation for the role of the database administrator?
A database administrator oversees all aspects of the database. He/she will be the person who has the ability to make anything happen with the management of the database.
What are the primary duties of a remote database administrator?
A database administrator's responsibilities can include the following tasks: future storage requirements for the database system. Creating primary database and the database tools and applications are executed on remote computers.
Difference between database administrator and system administrator?
A System Administrator is generically responsible for all parts of the computer network, such as user accounts, computer accounts, domain trusts, email accounts, etc. The System Administrator is probably specialized in the network server operating systems and user administration. A Database Administrator would deal specifically and in depth with all aspects of one or more databases. The Database Administrator will be highly specialized with the specific database server and client software.
What are the main function of a database system?
create the database
What is the difference between database and database administrator?
Database is the data stored in the server and Database administrator is the person who designs the database.
What responsibilities does an Oracle Database Administrator have?
The responsibilities are quite important. Interacting with consumers and employees is a main responsibility. Database design and repair are also other main responsibilities.
What is the explanation for the role of the database administrator?
A database administrator oversees all aspects of the database. He/she will be the person who has the ability to make anything happen with the management of the database.
Can I get database administrator training online?
Try visiting www.gatlineducation.com/mcdbacertification.html. They offer Database Administrator training courses.
Who is responsible for database security?
Each database can have a security administrator who is in charge of enforcing and maintaining the database security policy. If the database system is small, the database administrator may also have security administrator responsibilities. To learn more about data science please visit- Learnbay.co
How do you explain in detail the role of dba also explain oracle tools available?
The database administrator performs a critical role within an organization and is an important and key role in Database Management Systems. The major responsibility of a database administrator is to handle the process of developing the database and maintaining the database of an organization. The database administrator is responsible for defining the internal layout of the database and ensuring the internal layout optimizes system performance.The database administrator has full access over all type of important data of an organization. The database administrator decides what data will be stored in the database and how to organize data in database so that it can be access easily on requirement or need of an organization. To design the database of an organization, the database administrator must have a meeting with users and determine their requirements.
What kinds of duties does a database administrator have?
A database administrator is responsible for the design, implementation, maintenance and repair of an organization's database. They also develop and design database strategies. http://en.wikipedia.org/wiki/Database_administrator
What are the primary duties of a remote database administrator?
A database administrator's responsibilities can include the following tasks: future storage requirements for the database system. Creating primary database and the database tools and applications are executed on remote computers.
How do you abbreviate dba?
DataBase Administrator
What is the job description of an Oracle database administrator?
The database administrator performs a critical role within an organization and is an important and key role in Database Management Systems. The major responsibility of a database administrator is to handle the process of developing the database and maintaining the database of an organization. The database administrator is responsible for defining the internal layout of the database and ensuring the internal layout optimizes system performance. The database administrator has full access over all type of important data of an organization. The database administrator decides what data will be stored in the database and how to organize data in database so that it can be access easily on requirement or need of an organization. To design the database of an organization, the database administrator must have a meeting with users and determine their requirements. The database administrator is also responsible for preparing documentation, including recording the procedures, standards, guidelines, and data descriptions necessary for the efficient and continuing use of the database environment. Documents should include materials to help end users, database application programmers, the operation staff, and all personnel connected with the database management system. The database administrator is responsible for monitoring the database environment, such as seeing that the database is meeting performance standards, making sure the accuracy, integrity, and security of data are maintained. The database administrator is also responsible to manage any enhancements into the database environment
What exactly is a database administrator job?
A database administrator is a person responsible for the design, maintenance and repair of an organization's database. To learn more about database administrators you can visit here http://en.wikipedia.org/wiki/Database_administrator
