Transcript database administrator

15
Chapter 15
Database Administration
1
15
Learning Objectives
• 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
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
2
15
Learning Objectives
• What the database administrator’s
managerial and technical roles are
• About several database administration tools
• About various database administration
strategies
• How various database administration
technical tasks are performed with Oracle
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
3
15
Data as a Corporate Asset
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
4
15
The Need for and Role of Databases
in an Organization
• Database’s predominant role is to support
managerial decision making at all levels in
the organization
• DBMS must provide tools that give each level
of management a different view of the data
and support required level of decision making
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
5
15
A Summary of DBA Activities
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
6
15
Desired DBA Skills
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
7
15
DBA Activities and Services
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
8
15
Database Administration Tools
• Two main types of data dictionaries:
– Integrated
– Standalone
• Main function: store description of all objects
that interact with the database
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
9
15
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
assignment of access rights to database
users
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
10
15
Developing a Database
Administration Strategy
• Critical step for any organization is to ensure
its information system supports strategic
plans for each of the company’s business
areas
• Database administration strategy must not
conflict with information systems plans
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
11
15
Developing a Database
Administration Strategy (continued)
• Information engineering
– Translates strategic company goals into the
data and applications that will help company
achieve those goals
– Output of the IE process is an information
systems architecture that serves as basis for
planning, development, and control of future
information systems
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
12
15
Summary
• Data management is critical for any
organization
• Data should be treated as corporate asset
with monetary value
• DBMS is most commonly used electronic tool
for corporate data management
• Impact of the DBMS on the organization’s
managerial and cultural framework must be
carefully examined
• Data administration function was developed
in response to changes in data management
fostered by technological advances in
computer systems
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
13
15
Summary (continued)
• Database administrator (DBA) is responsible
for corporate database management
• Broader data management activity is handled
by data administrator (DA)
• DA is more managerially oriented than the
more technically oriented DBA
• Development of data administration strategy
is closely related to the company’s mission
and objectives
• Implementing the overall company strategy is
a crucial process influenced by managerial,
technological, and cultural issues
Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel
14