Chapter 9

1
Chapter 9 10Database Planning, Design and
Administration

• Database Application Lifecycle
• DBMS Selection
• Database Administration

2
Database Application Lifecycles

• Database planning
• Systems definition
• Requirements collection and analysis
• Database design
• DBMS selection
• Application design
• Prototyping
• Implementation
• Data conversion and loading
• Testing
• Operational maintenance

3
Database Planning

• Business goals and plans
• Information systems needs
• Corporate data model
• user needs
• legal requirement

4
System Definition

• Scope boundaries
• Applications

5
Requirement collection

• Interview
• Questionnaires
• Observation
• Documentation
• Experience

6
Requirement Analysis

• Data centered approach
• Entity-Relationship (ER) diagram
• Normalization
• Process center approach
• Structured Analysis and Design (SAD)
• Data Flow Diagram (DFD)
• Hierarchical Input Process Output (HIPO)

7
Database Design

• Approaches
• Top-down
• Bottom-up or inside-out
• Mixed
• Components
• Logical
• Physical

8
Logical Database Design

• Steps
• Conceptual data model
• Logical data model (normalized specific data
  model)
• Global logical data model
• Approaches
• Centralized
• View integration

9
Optimal Logical Data Model

• Structure validity
• Simplicity
• Expressability
• Nonredundancy
• Shareability
• Extensibility
• Integrity
• Diagrammatic representation

10
Physical Database Design

• Storage structure
• Access method
• Security protection

11
Application Design

• Transactions
• Retrieval
• Update
• Mixed
• User interface (forms reports)
• Logical
• Simple
• Error handling
• Help
• Meaningful
• Consistency
• Status

12
CASE Tools

• Computer-Aided Software Engineering (CASE)
• Types
• Upper-Case planning to design
• Lower-Case implementing, test, performance
• Integrated-Case
• Benefits Productivity (effectiveness and
  efficiency)
• Standard
• Integration (repository)
• Support structured methods
• Consistency
• Automation

13
Prototyping

• Working model
• Pros
• Define users requirements
• Quick
• Feasibility test
• Low cost and risk, new technology
• Cons
• Costs

14
Implementation

• Data definition language (DDL)
• Data manipulation language (DML) or embedded DML
• Security integrity control

15
Data Conversion and Loading

• Actual data conversion
• Bridge

16
Testing

• Top-down
• Bottom-up
• Thread
• Stress

17
Operational Maintenance

• Monitoring
• Tuning
• Upgrading

18
DBMS Selection Criteria

• Development or end-user language
• Data structure
• Flexibility
• Security Privacy
• Restart Recovery
• Integrity
• Hardware software requirements
• Performance
• Monitoring
• Ease of use
• Data dictionary
• Teleprocessing
• Design tools
• Vendor support
• Costs
• Future

19
Database Administration Role

• Physical database design
• Security integrity control
• Performance monitoring
• Tuning database

20
Data Administration Role

• Planning
• Developing and maintaining standard
• Developing policy procedure
• Design conceptual and logical database

21
Assignment

• Review chapter 9-10
• Read chapter 11-12