SAD-Role Of Database Administrator

A database is a shared resource. When two or more users use the same data, then problems arise. It is the job of the database administrator ...

A database is a shared resource. When two or more users use the same data, then problems arise. It is the job of the database administrator to resolve these conflicts like ownership, priority of access. The job of the database administrator is to protect and manage the data.

Activities performed:

1.Managing data activities: The DBA manages database activities by providing standards, control procedures, documentation. Standardization is important in a centralized environment. Every record should have a standard name, format, and unique strategy for access. DBA is concerned about data access and modification. It also decides on the authorization with the help of locks. The user must be capable of identifying errors. So training and maintaining documentation is important.

2.Managing data base structure: Has to maintain the schemas, control redundancy,, control of change requests, implement changes and maintain user documents. Thus thje DBA has to maintain all these information.

3.Managing DBMS: DBA has to maintain CPU, system efficiency standards, elapsed time, inquiry time. The DBA investigates user performance and keeps the system in tune with the user requirements. It is the DBA’s responsibility to evaluate changes and determine their impact on the database environment.
Name

ADO,131,ASP,3,C++,61,CORE JAVA,1,CSS,115,HTML,297,index,5,JAVASCRIPT,210,OS,47,PHP,65,SAD,53,SERVLETS,23,SOFTWARE ENGINEERING,245,SQL,71,TCP/IP,1,XHTML,9,XML,18,
ltr
item
Best Online Tutorials | Source codes | Programming Languages: SAD-Role Of Database Administrator
SAD-Role Of Database Administrator
Best Online Tutorials | Source codes | Programming Languages
https://www.1000sourcecodes.com/2012/06/sad-role-of-database-administrator.html
https://www.1000sourcecodes.com/
https://www.1000sourcecodes.com/
https://www.1000sourcecodes.com/2012/06/sad-role-of-database-administrator.html
true
357226456970214079
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content