Test Data Profiling

Test Data Mangement - LifeCycle and Phases

Test Data Management(TDM) is an integral part of Software Testing, having its own LifeCycle and Phases which goes hands in hands with STLC. TDM can have few or all of below listed phases depending upon the Project.

1. Defining Test Data --  Test Data Scope

        a. The Schema/Structure definition

        b. Schema perspectives - Tester(application) and DBA(tables)

        c. Schema Requester - Schema Storage

        d. Conditional data in schema

2. Test Data Preparation

        a. Test Data Generation

               i. Relatable Test data - references and associations

               ii.Types of data - logical vs database built in

               iii. Scalability- uniqueness

        b. Subsett-ing and/or Masking Production Data

               i. Right-sizing (not all records required)

               ii.Referential integrity

               iii.Masking/de-identify sensitive info

3. Provisioning data

        Re purposing for a specific need

        Transformation: source - target disparity

        Different types/sources of data

        Aging of part of data/refreshing

        Modification of old data

        Export    Transparent - Manual        Opaque - Automated

                           

4. Archival

        Test data for NON-Functional Tests

        Test data Schema templates

        Transformation rules

        Off-lining obsolete data