Home page  
Help >
MBM Database Schema
Version 7.11
MBM Database Schema
 
   Data Base Name Is MBM
 
   Suppress GI
 
   DG T0 1000000 records
      F1      x(6)         @ '000001' thru '999999'
      F2      x(6)   key   @ '100001' / '100002' alternating
      F3      x(6)   key   @ '100001' / '100002' / '100003' alternating
   :1 F3RTB   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :2 F3RTL   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
      F4      x(6)   key   @ etc
      F5      x(6)   key   @ etc
   :1 F5RTB   x(6)   key RealTime   @ etc
   :2 F5RTL   x(6)   key RealTime   @ etc
      F40     x(6)   key   @ etc
      F50     x(6)   key   @ etc
      F50ID   ID     key
      :1 F50IDSYN  ID     key
      F50F    F      key
      :1 F50FSYN   F      key
      F50FD   FD     key
      :1 F50FDSYN  FD     key
 
   DG U0 100000 records
      K3      x(6)   key   @ '100001' / '100002' / '100003' alternating
   :4 K3RTB   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :5 K3RTL   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
      K5      x(6)   key   @ etc
   :4 K5RTB   x(6)   key RealTime   @ etc
   :5 K5RTL   x(6)   key RealTime   @ etc
   
@
@   "T1" is the primary test data table.
@   The data is created by the "GenData" procedure.
@   The data should not be changed as the results 
@      are canned into the TT table.
@
   DG T1 1000000 records
      F1      x(6)         @ '000001' thru '999999'
      F2      x(6)   key   @ '100001' / '100002' alternating
      F3      x(6)   key   @ '100001' / '100002' / '100003' alternating
   :1 F3RTB   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :2 F3RTL   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :3 K3      x(6)   key   @ '100001' / '100002' / '100003' alternating
   :4 K3RTB   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :5 K3RTL   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
      F4      x(6)   key   @ etc
      F5      x(6)   key   @ etc
   :1 F5RTB   x(6)   key RealTime   @ etc
   :2 F5RTL   x(6)   key RealTime   @ etc
   :3 K5      x(6)   key   @ etc
   :4 K5RTB   x(6)   key RealTime   @ etc
   :5 K5RTL   x(6)   key RealTime   @ etc
      F40     x(6)   key   @ etc
      F50     x(6)   key   @ etc
 
   DG U2 100000 records
      K3      x(6)   key   @ '100001' / '100002' / '100003' alternating
   :4 K3RTB   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :5 K3RTL   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
      K5      x(6)   key   @ etc
   :4 K5RTB   x(6)   key RealTime   @ etc
   :5 K5RTL   x(6)   key RealTime   @ etc
 
   DG T2 1000000 records
      F1      x(6)         @ '000001' thru '999999'
      F2      x(6)   key   @ '100001' / '100002' alternating
      F3      x(6)   key   @ '100001' / '100002' / '100003' alternating
   :1 F3RTB   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :2 F3RTL   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
      F4      x(6)   key   @ etc
      F5      x(6)   key   @ etc
   :1 F5RTB   x(6)   key RealTime   @ etc
   :2 F5RTL   x(6)   key RealTime   @ etc
      F40     x(6)   key   @ etc
      F50     x(6)   key   @ etc
   
   DG V0 1000000 records
      G1      x(6)         @ '000001' thru '999999'
      G2      x(6)   key   @ '100001' / '100002' alternating
      G3      x(6)   key   @ '100001' / '100002' / '100003' alternating
   :1 G3RTB   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :2 G3RTL   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
      G4      x(6)   key   @ etc
      G5      x(6)   key   @ etc
   :1 G5RTB   x(6)   key RealTime   @ etc
   :2 G5RTL   x(6)   key RealTime   @ etc
      G40     x(6)   key   @ etc
      G50     x(6)   key   @ etc
@
@   "V1" is a shadow test data table.
@   The data is created by the "GenData" procedure.
@   The data should not be changed as the results 
@      are canned into the TT table.
@
   DG V1 1000000 records
      G1      x(6)         @ '000001' thru '999999'
      G2      x(6)   key   @ '100001' / '100002' alternating
      G3      x(6)   key   @ '100001' / '100002' / '100003' alternating
   :1 G3RTB   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :2 G3RTL   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
      G4      x(6)   key   @ etc
      G5      x(6)   key   @ etc
   :1 G5RTB   x(6)   key RealTime   @ etc
   :2 G5RTL   x(6)   key RealTime   @ etc
      G40     x(6)   key   @ etc
      G50     x(6)   key   @ etc
 
   DG V2 1000000 records
      G1      x(6)         @ '000001' thru '999999'
      G2      x(6)   key   @ '100001' / '100002' alternating
      G3      x(6)   key   @ '100001' / '100002' / '100003' alternating
   :1 G3RTB   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
   :2 G3RTL   x(6)   key RealTime   @ '100001' / '100002' / '100003' alternating
      G4      x(6)   key   @ etc
      G5      x(6)   key   @ etc
   :1 G5RTB   x(6)   key RealTime   @ etc
   :2 G5RTL   x(6)   key RealTime   @ etc
      G40     x(6)   key   @ etc
      G50     x(6)   key   @ etc
 
@
@   "TT" is the test control table.
@   It contains the parameters for each test that is to be performed.
@
   DG TT 10000 records
      Operand1     x(8)
      Operand2     x(8)
      Operand3     x(8)
      Operator     x(12)
      Result       x(12)
      Result2      x(12)
      Result3      x(12)
      Result4      x(12)
      Result5      x(12)
 
@
@   "TR" is the test results table.
@
   DG TR 1000000 records
      TrDate         x(10)      @ date as yyyy.mm.dd
      TrTime         x(10)      @ time as hh:mm:ss
      TrElapsed      x(8)
      TrName         x(24)      @ test name
      TrOpcode       x(12)
      TrConfig       x(12)      @ MemColl config
      TrString       x(64)      @ internal result string
      TrCommand      x(64)
 
   Unique F2    100
   Unique F3    100
   Unique F3rtl 100
   Unique F3rtb 100
   Unique F4    100
   Unique F5    100
   Unique F5rtl 100
   Unique F5rtb 100
   Unique F40   100
   Unique F50   100
 
   Unique F50ID      100
   Unique F50IDSYN   100
   Unique F50F       100
   Unique F50FSYN    100
   Unique F50FD      100
   Unique F50FDSYN   100
 
   Unique G2    100
   Unique G3    100
   Unique G3rtl 100
   Unique G3rtb 100
   Unique G4    100
   Unique G5    100
   Unique G5rtl 100
   Unique G5rtb 100
   Unique G40   100
   Unique G50   100
 
   Unique K3    100
   Unique K3rtl 100
   Unique K3rtb 100
 
   Unique K5    100
   Unique K5rtl 100
   Unique K5rtb 100
 
   UniqueRTB F3RTB 3 0 ALL
   UniqueRTB F5RTB 5 0 ALL
 
   UniqueRTB G3RTB 3 0 ALL
   UniqueRTB G5RTB 5 0 ALL
 
   UniqueRTB K3RTB 3 0 ALL
   UniqueRTB K5RTB 5 0 ALL
 

Copyright © 2019 , WhamTech, Inc.  All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. Names may be trademarks of their respective owners.