FLOW OF OPERATIONS Choose output size Choose output
- Slides: 8
FLOW OF OPERATIONS • • • Choose output size Choose output format Correct data types Add/Remove columns Change data types Set bindings • • • Use functions Adjust distributions Adjust columns Adjust tables Create test database Click-Once generation
FEATURES • Automatic fast modeling • Support for bad DB design • Easy annotations • DBMS independent • Composite key support • ”Real” and synthetic data • Many output options • Data protection • Extensible • Excel-like functions • ”Dirty” data • Advanced data bindings
EXTENSIBLE ARCHITECTURE Kernel System Supplied User Extension Varchar Int. . . Normal Uniform. . . Tiny. Int. . . Log. Normal. . . MS SQL Oracle. . . File Stream. . . Mult Add. . . Database. . . Log 10. . .
DATA DEPENDENCIES COMPOSITE PK-FK BINDINGS name location startdate enddate empid name location expectedhrs T 80 CC B 3 -103 2006 -08 -29 1 T 80 CC B 3 -103 200 BBS 45 A 2 -40 2006 -08 -29 2 T 80 CC B 3 -103 50 KS 231 A 2 -40 2006 -08 -29 1 KS 231 A 2 -40 110 PROJECT WORKS_ON INTRA-ROW BINDINGS id firstname Lastname Ssn Height weight bmi 1 Rico Wind 0802801237 184 79 2 2 Kenneth Pedersen 1412711433 185 90 1 3 Kristian Torp 0205701421 187 85 3 EMPLOYEE
DATA DEPENDENCIES INTER-COLUMN BINDINGS increasing_date fluctuating_price increasing_price 2006 -08 -29 10: 01: 31 100 2006 -08 -29 10: 01: 33 90 110 2006 -08 -29 10: 01: 47 99 121 STOCK COMBINED BINDINGS id stock_price change_date MSFT 25. 62 2006 -08 -29 10: 01: 33 ORCL 15. 48 2006 -08 -29 10: 01: 33 ORCL 15. 52 2006 -08 -29 10: 01: 34 MSFT 25. 56 2006 -08 -29 10: 01: 34 STOCK
TPC-C PERFORMANCE
INHERITED DATATYPE EXAMPLE(C#) <<interface>> Data. Type . . . Int Tiny. Int . . . +Put. Data(Data. Reader) +Get. Data. Item(string[]) +Creates. Dirty. Data() DATATYPE EXAMPLE 1 class Tiny. Int : Int { 2 private bool use. Base. Data = false; 3 public override void Put. Data(IData. Reader dr) { 4 base. Put. Data(dr); 5 if (dist. Get. Max. Values() > 255 || dist. Get. Min. Values() < 0) 6 use. Base. Data = true; 7 } 8 public override string Get. Data. Item( string[] tuple) { 9 if (! use. Base. Data) 10 11 12 13 14 15 16 return base. Get. Data. Item(tuple); Else return (string)rnd. Next. Double() * 55; } public override bool Creates. Dirty. Data() { return false; } }
DEMONSTRATION
