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
    • # users
    • # transactions
  • 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