Home DBMS Dictionary QLanguage Pros & Cons DStructures Logical DS Implementing Site Map Links

Database Implementation Procedure


Stage 1 : Define Scope of the Database Project

  • Identify which organizational subdivisions will be served by the database

  • Define which functions within these organizations will utilize the database

  • Identify which existing and planned applications will be converted to the database system

  • Prepare proposal for management and obtain go-ahead


Stage 2 : Organize Database Project

  • Pick users for design team

  • Select database Administrator (DBA)

  • Establish regular meetings and periodic management reporting for design team


Stage 3 : Select Database Management System Products

  • Document requirements in formal proposal requests

  • Select DBMS vendor


Stage 4 : Develop Initial Implementation Plan and Schedule

  • Identify files that will be converted

  • Identify programs within applications specified

  • Estimate programmer hours needed to modify applications programs

  • Estimate user clerical support needed to verify data using conversion

  • Develop implementation schedule


Stage 5 : Design Database

  • Complete detailed information requirements

  • Identify data requirements

  • Determine data structure and complete design specifications

  • Review and approve design specifications


Stage 6 : Perform Training

  • Develop training requirements and training schedule

  • Train programmers in the use of DML (Data Manipulation Language)

  • Train DBA in DMCL (Data Manipulation Control Language) and DDL (Data Definition Language)


Stage 7 : Install and Test Database

  • Code DMCL, schema and subschema

  • Modify representative programs for DBMS test

  • Code conversion programs

  • Generate the database

  • Test and debug

  • Review and approve test results


Stage 8 : Develop Detailed Conversion Plan

  • Make individual programming assignments for each program to be modified and each file to be loaded

  • Schedule users to verify and correct file contents

  • Schedule computer availability

  • Prepare formal written conversion schedule and obtain commitments and from all parties involved

  • Approve conversion involved


Stage 9 : Convert Existing Applications

  • Bring up one application at a time

  • Update and regenerate database as required

  • Approve revised applications as they are converted

  • Begin using database for new applications and programs


Stage 10 : Fine-Tune Database

  • Monitor DBMS access statistics and visible performance, and modify database as required

  • Regenerate database when necessary


Stage 11 : Periodically Review Database Performance

  • Restate organizational goals and information requirements

  • Evaluate success of database project

  • Begin new database projects when required

|Home| |DBMS| |Dictionary| |QLanguage| |Pros & Cons| |DStructures| |Logical DS| |Implementing| |Site Map| |Links|

Domain registration :
Domain registration or register domain name from $5.95/yr. Includes comprehensive free services such as URL/Email forwarding.

Search engine ranking, optimization and website submission :
Search engine optimization, ranking and submission service with guaranteed results.