Database Answers Header

Case Study : Database Audit

Moon over the Sahara, courtesy of Pamela Robertson This is a work in progress. If you are interested in more details, please
email us.

This Page describes how to do a check of a Database, particularly one which is
supporting a Web Site.

Key Points :-

  • Evaluate Database design.
    This requires a diagram or report showing the major Tables in the Database,
    along with record counts.
    We have a Script for Oracle, listed under Data Analysis,to do this.
    A Neat solution, if it is available to you, is to reverse engineer a Database into
    a Data Modelling Tool, such as DataArchitect or ERWin.
    This allows you to create a diagram of a Data Model for the Database.
  • Review Data Quality.
    This requires SQL or a Tool such as Axciom to analyse data patterns and identify inconsistencies.
  • Identify the Data Validation checks
    This table shows the major Steps :-

    1 Define the Database design Preferably by Reverse Engineering Database Diagram
    2 Check Data Values Look for invalid Data Action Plan

    Useful Links ...
    1 Data Management Review Archives    

    [ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Site Map ]

    © IceBreaker WebDesigns 2000