Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

The dba creates security policies and procedures.

22/12/2020 Client: saad24vbs Deadline: 7 Days

Database Administration


*


Objectives


Discuss the need for database administration

Explain the DBA’s responsibilities in formulating and enforcing database policies for access privileges, security, disaster planning, and archiving

Discuss the DBA’s administrative responsibilities for DBMS evaluation and selection, DBMS maintenance, data dictionary management, and training

Discuss the DBA’s technical responsibilities for database design, testing, and performance tuning

*


*


Introduction


FIGURE 8-1: DBA responsibilities


*


*


Database Policy Formulation and Enforcement


DBA

Formulates database policies

Communicates policies to users

Enforces policies

Policies

Access privileges

Security

Disaster planning

Archiving

*


*


Access Privileges


DBA

Determines access privileges for all users

Enters appropriate authorization rules in DBMS

SQL GRANT statement

Access privilege policy

Documented by DBA

Approved by top-level management

Communicated by DBA to all users

*


*


Access Privileges (continued)


FIGURE 8-2: Permitted and denied access privileges for Sam


*


*


Access Privileges (continued)


FIGURE 8-4: Permitted and denied access privileges for Valerie


*


*


Security


Prevention of unauthorized access, intentional or accidental, to database

DBA

Creates security policies and procedures

Obtains management approval of policies and procedures

Distributes policies and procedures to authorized users

*


*


Security (continued)


DBMS’s security features

Encryption

Authentication

Authorizations

Views

Additional security programs may be created or purchased

Monitoring of database usage to detect security violations

*


*


Security (continued)


FIGURE 8-5: Attempted security violation by Brady, who’s not an authorized user


*


*


Security (continued)


FIGURE 8-6: Attempted security violation by Paige, who’s authorized to access some customer data but is not authorized to access customer balances


*


*


Disaster Planning


Damage from physical incidents

Software/hardware/electrical

Natural disasters

Disaster recovery plan: ongoing and emergency actions and procedures to ensure data availability if a disaster occurs

Hard drive failures

Redundant array of inexpensive/independent drives (RAID): database updates replicated to multiple hard drives

*


*


Disaster Planning (continued)


Electrical power loss

Uninterruptible power supply (UPS): power source and power generator

Duplicate backup systems

Hot site: completely equipped with duplicate hardware, software, and data

Can switch to hot site in minutes or hours

Warm site: duplicate hardware and software but not data

Takes longer to start processing

*


*


Archiving


Governmental laws and regulations, for example:

Sarbannes-Oxley Act

Patriot Act

HIPAA

Auditing and financial requirements

Data archive or archive: place where record of certain corporate data is kept

Stored on mass storage devices

Copies of archives and database backups must be stored off-site

*


*


Archiving (continued)


FIGURE 8-7: Movement of order 21617 from the database to the archive


*


*


Other Database Administration Functions


DBMS evaluation and selection

DBMS maintenance

Data dictionary management

Training

*


*


DBMS Evaluation and Selection


Data definition

Data restructuring

Nonprocedural languages

Procedural languages

Data dictionary

Concurrent update

Shared lock

*


*


DBMS Evaluation and Selection (continued)


Backup and recovery

Security

Integrity

Replication and distributed databases

Limitations

Local area network (LAN)

Documentation and training

Context-sensitive help

*


*


DBMS Evaluation and Selection (continued)


Vendor support

Performance

Portability

Intranet

Cost

Future plans

Other considerations

*


*


DBMS Maintenance


Installation of DBMS

Configuration changes

Upgrades for new releases

Problem resolution

Special one-time processing needs

*


*


Data Dictionary Management


Data dictionary is like database catalog, but with wider range of information

Establishes naming conventions for tables, fields, indexes, etc.

Creates data definitions for tables

Creates data integrity rules and user views

Updates data dictionary

Creates and distributes reports from data dictionary

*


*


Training


Training in using DBMS and accessing database

Training of technical staff responsible for developing and maintaining database applications

If training is provided by vendor of DBMS, DBA handles scheduling of training

*


*


Technical Functions


Database design

Testing

Performance tuning

*


*


Database Design


Establishes sound methodology for database design

Does physical-level design

Creates documentation standards

Reviews changes to requirements and manages modifications to database

*


*


Testing


Production system or live system: hardware, software, and database for users

DBA grants access to production system only to authorized users, except for:

Troubleshooting a problem

Addition of new or modified programs

Test system or sandbox: used by programmers to develop new programs and modify existing programs

*


*


Testing (continued)


FIGURE 8-9: DBA controls the interaction between the test and production systems


*


*


Performance Tuning


DBA attempts to get best performance within funding constraints

Creating and deleting indexes

Splitting tables

Changing table design

Denormalizing converts a table in third normal form to a table not in third normal form

Improved performance

*


*


Performance Tuning (continued)


FIGURE 8-10: Customer table for Premiere Products


*


*


Performance Tuning (continued)


FIGURE 8-11: Result of splitting the Customer table into two tables


*


*


Performance Tuning (continued)


FIGURE 8-11: Result of splitting the Customer table into two tables (continued)


*


*


Performance Tuning (continued)


FIGURE 8-12: Including part descriptions in the OrderLine table, which creates a first normal form table


*


*


Summary


Database administrator (DBA) is responsible for supervising the database and use of the DBMS

DBA formulates and enforces policies about which users can access database, portions they may access, and the manner in which they can access it

DBA formulates and enforces policies about security by using DBMS’s security features, special security programs, and monitoring database usage

DBA creates and implements backup and recovery procedures as part of a disaster recovery plan

*


*


Summary (continued)


DBA formulates and enforces policies that govern management of an archive for data

DBA leads evaluation and selection of new DBMS

DBA installs and maintains DBMS

DBA maintains data dictionary, establishes naming conventions for its content, and provides information from it to others

DBA provides database and DBMS training and coordinates and schedules training by outside vendors

*


*


Summary (continued)


DBA verifies all information-level database designs, completes all physical-level database designs, and creates documentation standards; also evaluates changes in requirements

DBA controls production system, which is accessible only to authorized users; other than under exceptional situations, programmers access a separate test system

DBA tunes database design to improve performance; includes creating and deleting indexes, splitting tables, and denormalizing tables

*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


*


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Helping Hand
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$112 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$110 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Leaf rust on azaleas - Cinderella rockerfella if i had one wish - Website analysis memo - Foxx and azrin toilet training article - Cqc notification serious injury - OB1 - Yourchildlearns com mappuzzle europe - Training evaluation report ppt - Calcium carbonate nitric acid - Week 8 Aram Tawoosi - Cloud Computing Portfolio Project Paper. - Where duff beer is poured crossword clue - Paper on IOT Threats to Database Security. - Discussion post - Module 2 Personal Reflection Journal - Social & Behavioral Factors in Public Health - Nonmem 7.4 user guide - Energy of a spring mastering physics - Private insurer reimbursement rates for psychiatrists - 8week3Indiv - Econometrics - C# multiple choice questions and answers - Racq car insurance call - Stark wrecking vintage classic salvage yard - Grade 8 maths papers - No one grows ketchup like heinz advertisement analysis - Sociology - Unsw student card lost - Topic 7 review cwv - Mount waverley secondary college uniform - Cla - Tcp ip reference model - Redox virtual lab - 20c leinster grove brunswick east - Refrigeration oil cross reference - Ap biology 2018 free response answers - Clean edge razor case study solution - Molar mass of diphosphorus pentoxide - War prayer by mark twain summary - Welding symbols australian standard - Hungry wolf selmer tn menu - I need help for my assignment on TutorsOnSpot - Position Paper - Emanuelstr 18 80796 münchen - Big mac inside the mcdonald's empire worksheet - Intro to quadratics worksheet - MarketingManagement_Assessment2 - Discussion Board - FINAL PAPER HUMAN RESOURCE MANAGEMENT - DUE IN 30 HOURS - David christopher orthopedic surgeon case study - Why are decomposers important to an ecosystem - Data analysis plus 2016 - Difference between bcp and drp pdf - Explain proper policy implementation steps and describe factors relating to its success. - DATABASE MANAGEMENT - Struck by lightning by gretel ehrlich summary - Sunshine coast cricket association website - Existentialism basic writings second edition pdf - Principles of target costing - Society and culture past papers - Ending isak danielson sheet music - Be detailed with the answer, no plagiarism. - Cic stage 4 - Desert survival exercise 15 items - Respond to the following in a minimum of 175 words: - Carnegie mellon summer internship - Direct and inverse variation word problems worksheet with answers - Halal ice cream in australia - 1 why is maersk's business model complex - Fin 370 week 2 myfinancelab - Natasha petrova anatoly moskvin - ESSAY - Business tax and money house bondi junction - Case study - Gfl quick training contract - What are skew lines in geometry - What is a separation certificate used for - Grito de dolores speech - Discussion - On first looking into chapman's homer rhyme scheme - Screamers hollow sterling ny 2018 - Aviation security identity card - Boral concrete price per m3 - _____ are important because they help to ensure data integrity - Discussion - What you pawn i will redeem annotated bibliography - Properties of quadrilaterals worksheet - Seussical the musical mayor - H&m's supply chain management practices - Determinants of job satisfaction ppt - Police scanner codes list victoria - Example of autobiography of students - Microscope use and function lab - Crossing brooklyn ferry transcendentalism - John o groats visitor centre - Gale warnings irish sea - A company's strategic vision concerns - From nand to tetris in 12 steps - Final project -2 - What evidence indicates that corporate profits will rise