Implementation Processes
Implementation processes are executed in each environment that has to be implemented , whether it is a development, testing , user acceptance or production environment
DB Software Installation
- Use supplier installation procedure
- If formal installation procedure not used, obtain signoff from procedure for the installation procedure used
DB Software Configuration
- Obtain Prerequisites:
- Implementation platform blueprint
- # transacties
- # users
- Amount of data
- Prepare configuration
- Startup software
DB Sizing
- Prerequisites
- # transactions
- CRUD matrix
- online data requirements
- Physical factors : indices, aggregats
- Cleanup old data
- Objective: size-evolution
DB Disk Strategy Setup
- Prerequisites
- Disaster recovery requirements
- Performance requirements
- Sizing info
- Objectief : DB Disk Implementation Plan
- Including : Disk purchase plan
DB Disk Configuration
- RAID set-up
- Create raw partitions/files
- Create dbspaces / chunks
Database Access Setup
- Definition security requirements on data level
- Database, table- of column level
- Read or write
- Stored procedures
- Creation of db-security management programs, procedures
- Coordination with security-responsibles
Application Performance Walkthrough
- Analysis van each function/task of the application
- Evaluate CPU-, I/O-, Memory-,network-usage
- Set review priorities
- Optimize DB-design, application
- Report changes
Application Concurrency Testing
- Test the application locking behaviour according to
- Use testing tools
- Use sysmaster database
Turnover To Production
- Define Time for turnover
- Acceptance db is the base for production
- Define operational procedures
- Production processes start at this point
Data Replication
- Obtain data availability requirements
- Which data is need where ?
- How current (correct) does the data have to be ?
- Is read or read/write access required
- Obtain operational parameters
- Number of transactions
- Amount of data used per transaction
- Network bandwith
- Develop replication strategy
- can be : no replication !
- Implement replication strategy
- Manage replication implementation
- Perform replication change management