Database Administration - Database Management and Design - Lecture Slides, Slides of Introduction to Database Management Systems

Download Database Administration - Database Management and Design - Lecture Slides and more Slides Introduction to Database Management Systems in PDF only on Docsity!

Database Administration

In this chapter, you will learn:

• That data are a valuable business asset that requires careful management
• Why and how the database plays a critical role in an organization
• That the introduction of a DBMS has important technological, managerial, and cultural organizational consequences

Data as a Corporate Asset

• Data are accepted as a valuable asset requiring careful management
• Data are now well understood as a valuable resource to be translated into information
• If information is accurate and timely, its use is likely to enhance company’s competitive position and generate wealth

Fig 15.1 The Data-

Information-Decision-

Making Cycle

Introduction of a Database:

Special Considerations

• Having a computerized database management system does not guarantee that the data will be properly used to provide best solutions required by managers

Introduction of a Database:

Special Considerations (continued)

• Introduction of a DBMS is likely to have a profound impact, which might be positive or negative, depending on how it is administered
• Three important aspects
  • Technological: DBMS software and hardware
  • Managerial: Administrative functions
  • Cultural: Corporate resistance to change

The IS Department Internal

Organization

The Placement of the

DBA Function

Multiple Database

Administrators

in an Organization

The Database Environment’s

Human Component

• Even the most carefully crafted database system cannot operate without a human component
• Effective data administration requires both technical and managerial skills
• DA must set data administration goals
• DBA is the focal point for data/user interaction
• Need for diverse mix of skills

A Summary of DBA

Activities

Desired DBA Skills

Database Administration Tools

• Two main types of data dictionaries:
  • Integrated
  • Standalone
• Main function: store description of all objects that interact with the database

Database Administration Tools

(continued)

• Possible to manage use and allocation of all organization’s information, regardless of whether it has roots in database data
• Metadata stored in data dictionary are often basis for monitoring database use and