Home DBMS Dictionary QLanguage advantages of database 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

  • rules of the internet
  • 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| |Advantages of database | |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.