chapter 15 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Chapter 15 PowerPoint Presentation
Download Presentation
Chapter 15

Loading in 2 Seconds...

play fullscreen
1 / 45

Chapter 15 - PowerPoint PPT Presentation


  • 138 Views
  • Uploaded on

Chapter 15. Database Administration Database Systems: Design, Implementation, and Management, Sixth Edition, Rob and Coronel. In this chapter, you will learn:. That data are a valuable business asset that requires careful management

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Chapter 15' - lolita


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
chapter 15

Chapter 15

Database Administration

Database Systems: Design, Implementation, and Management, Sixth Edition, Rob and Coronel

in this chapter you will learn
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

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

in this chapter you will learn continued
In this chapter, you will learn: (continued)
  • 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

data as a corporate asset
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

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

fig 15 1 the data information decision making cycle
Fig 15.1 The Data-Information-Decision-Making Cycle

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the need for and role of databases in an organization
The Need for and Role of Databasesin 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

introduction of a database special considerations
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

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

introduction of a database special considerations continued
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

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the evolution of the database administration function
The Evolution of the Database Administration Function
  • Data administration has its roots in the old, decentralized world of the file system
  • Advent of the DBMS and its shared view of data produced a new level of data management sophistication and led the DP department to evolve into an information systems (IS) department
  • Data management became an increasingly complex job, thus leading to development of the database administration function

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the is department internal organization
The IS Department Internal Organization

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the placement of the dba function
The Placement of the DBA Function

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

a dba functional organization
A DBA Functional Organization

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

multiple database administrators in an organization
Multiple Database Administrators in an Organization

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the database environment s human component
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

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

contrasting da and dba activities and characteristics
Contrasting DA and DBA Activities and Characteristics

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

a summary of dba activities
A Summary of DBA Activities

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

desired dba skills
Desired DBA Skills

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

dba activities and services
DBA Activities and Services

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

database administration tools
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

database administration tools continued
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

an example of a case tool visio professional
An Example of a CASE Tool: Visio Professional

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

developing a database administration strategy
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

developing a database administration strategy continued
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

forces affecting the development of the isa
Forces Affecting the Development of the ISA

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the dba at work using oracle for database administration
The DBA at Work: Using Oracle for Database Administration
  • Execution of tasks tends to be DBMS-and operating-system specific
  • Brief introduction to the way some typical DBA tasks would be performed in Oracle

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the oracle enterprise manager interface
The Oracle Enterprise Manager Interface

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

oracle edit local preferred credentials window
Oracle Edit Local Preferred Credentials Window

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

oracle rdbms services
Oracle RDBMS Services

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the oracle storage manager
The Oracle Storage Manager

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

creating a new tablespace
Creating a New Tablespace

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the oracle schema manager
The Oracle Schema Manager

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the oracle security manager
The Oracle Security Manager

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the create user dialog box
The Create User Dialog Box

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

the oracle instance manager
The Oracle Instance Manager

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

creating a new database with the database configuration assistant
Creating a New Database with the Database Configuration Assistant

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

selecting the new database template
Selecting the New Database Template

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

naming the database
Naming the Database

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

selecting the database operation mode
Selecting the Database Operation Mode

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

specifying initialization parameters
Specifying Initialization Parameters

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

specifying storage parameters
Specifying Storage Parameters

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

database creation options
Database Creation Options

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

summary of database creation options
Summary of Database Creation Options

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

database creation progress
Database Creation Progress

Database Systems: Design, Implementation, & Management, 6th Edition, Rob & Coronel

summary
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

summary continued
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