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

Data dictionary in dbms ppt

29/10/2021 Client: muhammad11 Deadline: 2 Day

Database 9

1) Read chapter 15, IGU Online library and reputable resources and Describe the DBA's functions and responsibilities. (Chapter 15 attached).

2) Data and information is secure if the pyramid of security CIA (Confidentiality, Integrity , Availability) are satisfied. Discuss what each term means and provide an example to support your discussion.

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

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:

Custom Coursework Service
Peter O.
A Grade Exams
Homework Tutor
Coursework Help Online
Top Grade Essay
Writer Writer Name Offer Chat
Custom Coursework Service

ONLINE

Custom Coursework Service

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$49 Chat With Writer
Peter O.

ONLINE

Peter O.

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$31 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$20 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$49 Chat With Writer
Coursework Help Online

ONLINE

Coursework Help Online

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$49 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$26 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

Generation me jean twenge pdf - Megaman lr1204dgv2 wfl 2800k - Supply chain management lesson plans - How to find digital object identifier - Received cash from clients on account - Official beer pong rules - Capital project fund journal entries examples - Strategic marketing multiple choice questions - Practical Connection Assignment - Remington 1100 carrier release - Music paper - Mirror and lens ray diagram worksheet - The story of an hour literary analysis - Shadow health chest pain - Why is america self segregating - Care inspectorate quality indicators - Jetblue generic strategy - Traditional Learning Theories - How many times has the current texas constitution been amended - Suggest data validation checks for data entry screens - Employee Learning Training Module - Security infrastructure design document example - Impact of Mobile computing on Businesses - Size 4 us baby shoes age - Chap 2 and 3 - The joy of statistics fill in the blank answers - What pricing strategy does bentley motors use - Modern database management pdf - Cima present value table - Module 2 - What would you do? 1 - Alicia has been asked to approve a marketing campaign that - Scholarship Thank you letter - Jk to t flip flop conversion - Class c amplifier operation - Gideon's trumpet assignment answers - Delph company uses a job order costing system - Chemcollective virtual lab answers - Air force missile - 4 year old child observation report - Your Ultimate Guide to NURS FPX 4005 Assessments: From Start to Success - Executive Practical Connection Assignment - Verbatim of a counselling session - Debate Slavery - Canadian technical asphalt association - Hcs 475 problem analysis worksheet - What will neutralize sulfuric acid - Introduction to java programming brief version 11th edition pdf - Vernier caliper how to read - Museum visit assignment - Fish creek animal hospital case study - Criminal record check peel - Carol wan chui pan - Advantages and disadvantages of dollarization - Terre forti sangiovese rubicone price - Parallelogram law of forces in tamil - My mistress eyes are nothing like the sun poem - 7 MASTERING BIOLOGY - 2 examples of neolithic myths - NEED IN 15 HOURS or LESS - Termite trails lab - Bbva compass marketing resource allocation case solution - Biol 101 quiz 1 - Ode intimations of immortality poetry foundation - The great person theory - Unnatural balance accounting - Hedge maple scientific name - Guide dogs uk dogalogue - History of Art through the Middle Ages Week 5 discussion - 300-500 WORDS ABOUT A MOVIE - Jack pennick cause of death - Prep maths curriculum qld - Research paper for master level - Amazon buys whole foods case study pdf - Cryojane tape transfer system - Folkway violations - Proportional parts in triangles and parallel lines - The right thing to do rachels pdf - Response Paper #11: "Chekov and Zulu" - Snoopy's dog breed crossword - Delilah carol ann duffy poem - MGT312T Week. 2 Apply Self-Assessment Reflection - What is the main purpose of human life - Barmah national park walks - What are general purpose financial reports - Aws tco and cloud economics accreditation answers - Booklice on skirting boards - Property valuation report format - Chocolate bar riddle quiz - What i see in lincoln's eyes - Classification categories must be mutually exclusive and which of the following? - Adán / preferir / escalar la montaña de noche - Organizational behaviour an introductory text - Fencing knots figure 8 - Student exploration collision theory worksheet answers - Sn teaching on medication compliance - Blue diamond doterra income - How much does snap fitness cost monthly - The song of the wreck charles dickens analysis - Fedex authorized ship ctr calgary ab - Judith myers tombstone dead by daylight