240 likes | 372 Views
TEST SETS the general method. data models. selection. extraction functional criterias. extraction. data sets. anonymisation / data generation. data sets before tests. test execution. data sets after tests. execution traces. analysis / validation. test coverage.
E N D
TEST SETSthe general method data models selection extraction functional criterias extraction data sets anonymisation / data generation data sets before tests test execution data sets after tests execution traces analysis / validation test coverage
SELECTIONfunctional division FUNCTIONAL SUBSET derived from the model The subset is the minimum list of necessary tables …and the usage graph
SELECTIONvolumetric division VOLUMETRIC SUBSET rules definition for all the functional subset attributes
SELECTIONvolumetric division RULE TYPES 1. Simple criteriax = valeur 2. borders x <= 0007 0008 <= x <= 0011 0012 <= x 3. Addition or suppression of known records
SELECTIONvolumetric division nbr of records to be extracted, per type Results Primary keys 6971 36941 91178 94875 17437 35477 53385 71450 89472 60811 45832 20876 52417 75968 10 10001 10009 10016 10017 … processingsequence extraction method F = first record S = 1 amongst N R = random number combination types U = union I = intersection X = exclusion
TEST SETSthe general method data models selection extraction functional criterias extraction data sets anonymisation / data generation data sets before tests test execution data sets after tests execution traces analysis / validation test coverage
Schema 2 Schema 1 DB 2 DB 1 Links element EXTRACTION Extraction combination coming from different DB Key 1 6971 36941 91178 … 10017 Rule 2 Attribute 2 = ‘Y’ … Rule 1 Attribute 1 = ‘X’ … Data 1 ABCD EFGH … XYZT Extracteur Key 2 Extracteur Data 2
TEST SETSthe general method data models selection extraction functional criterias extraction data sets anonymisation / data generation data sets before tests test execution data sets after tests execution traces analysis / validation test coverage
ANONYMISATION To define the data anonymisation rules ListeRS.txt RAISON SOCIALE 00001 RAISON SOCIALE 00002 RAISON SOCIALE 00003 RAISON SOCIALE 00004 RAISON SOCIALE 00005 RAISON SOCIALE 00006 RAISON SOCIALE 00007 RAISON SOCIALE 00008 RAISON SOCIALE 00009 … The values of the attribute “RAISON SOCIAL” are read in the file "D:\Dgi\Database\ListeRS.txt"
DATA GENERATION Generation rules For each record “ SUPPORT JURIDIQUE” create randomly 1 to 3 record TIERS
DATA GENERATION Contents generation
TEST SETSthe general method data models selection extraction functional criterias extraction data sets anonymisation / data generation data sets before tests test execution data sets after tests execution traces analysis / validation test coverage
6971 36941 91178 94875 17437 35477 53385 71450 89472 60811 45832 20876 52417 75968 10 10001 10009 10016 10017 … Extractor ANALYSIS / VALIDATION Use of the extractors to obtain the data sets to be compared DB before tests DB after tests
ANALYSIS / VALIDATION To define comparison criteria’s Looking for differences Some attributs might be different
ANALYSIS / VALIDATION DB 1 extraction DB 2 extraction <SUPPORTJURIDIQUE IDSJU = "53385" <TIERS IDTIERS = "85524" <DEFAILLANCE IDDEFAILLANCE="80307"/> > </TIERS> <TIERS IDTIERS = "85523" > </TIERS> </SUPPORTJURIDIQUE> <SUPPORTJURIDIQUE IDSJU = "53385" <TIERS IDTIERS = "85524" <DEFAILLANCE IDDEFAILLANCE="80307"/> > </TIERS> </SUPPORTJURIDIQUE> record TIERS 85523 was cancelled
ANALYSIS / VALIDATION VALUE DIFFERENCES The critical differences are detected Some value difference between attributes were ignored ex: MODIFICATIONDATE The path to the record is detailed
TEST SETSthe general method data models selection extraction functional criterias extraction data sets anonymisation / data generation data sets before tests test execution data sets after tests execution traces analysis / validation test coverage
COVERAGE PROGRAMS ARE AUTOMATICALLY INSTRUMENTED
COVERAGE RESULTS FROM THE ANALYSIS OF A PROGRAM TRACE FILE INCLUDING 5.424ARCS The most used arcs The less used arcs