Revision 35, 2.9 kB
(checked in by norris, 10 months ago)
|
- moved the SAMR schema to the SAMR example, renamed schema files with more intutive names
- renamed SAMR tests (again to make it more obvious what they do)
|
Line | |
---|
1 |
|
---|
2 |
|
---|
3 |
CREATE TABLE main ( |
---|
4 |
fullName varchar(80), |
---|
5 |
t int, |
---|
6 |
app varchar(25), |
---|
7 |
gran float, |
---|
8 |
blockingMode varchar(5), |
---|
9 |
proc int, |
---|
10 |
whiteSpace float, |
---|
11 |
scal int, |
---|
12 |
grow int, |
---|
13 |
procMult int, |
---|
14 |
actualLevels int, |
---|
15 |
goodEnough float, |
---|
16 |
mapping float, |
---|
17 |
avgBoxes float, |
---|
18 |
avgDataMove float, |
---|
19 |
avgInterCom float, |
---|
20 |
avgIntraCom float, |
---|
21 |
avgLoadImbal float, |
---|
22 |
avgTotalCom float, |
---|
23 |
avgSynch float, |
---|
24 |
maxBoxes int, |
---|
25 |
maxDataMove float, |
---|
26 |
maxInterCom int, |
---|
27 |
maxIntraCom int, |
---|
28 |
maxLoadImbal float, |
---|
29 |
maxTotalCom int, |
---|
30 |
maxSynch int, |
---|
31 |
comNum int, |
---|
32 |
comSize int |
---|
33 |
); |
---|
34 |
|
---|
35 |
|
---|
36 |
CREATE TABLE mainCom ( |
---|
37 |
fullName varchar(80), |
---|
38 |
t int, |
---|
39 |
app varchar(25), |
---|
40 |
gran float, |
---|
41 |
blockingMode varchar(5), |
---|
42 |
proc int, |
---|
43 |
whiteSpace float, |
---|
44 |
scal int, |
---|
45 |
grow int, |
---|
46 |
procMult int, |
---|
47 |
actualLevels int, |
---|
48 |
goodEnough float, |
---|
49 |
mapping float, |
---|
50 |
cpuID int, |
---|
51 |
comNum int, |
---|
52 |
comSize int |
---|
53 |
); |
---|
54 |
|
---|
55 |
|
---|
56 |
CREATE TABLE mainChar ( |
---|
57 |
id serial PRIMARY KEY, |
---|
58 |
app varchar(25), |
---|
59 |
t int, |
---|
60 |
levels int, |
---|
61 |
currentLevel int, |
---|
62 |
refinedArea float, |
---|
63 |
refinedAreaLower float, |
---|
64 |
|
---|
65 |
numPatchesArea float, |
---|
66 |
|
---|
67 |
avgPatchSize float, |
---|
68 |
stdDevPatchArea float, |
---|
69 |
|
---|
70 |
avgAspectRatio float, |
---|
71 |
weight float |
---|
72 |
); |
---|
73 |
|
---|
74 |
CREATE TABLE mainComMax ( |
---|
75 |
fullName varchar(80), |
---|
76 |
t int, |
---|
77 |
app varchar(25), |
---|
78 |
gran float, |
---|
79 |
blockingMode varchar(5), |
---|
80 |
proc int, |
---|
81 |
whiteSpace float, |
---|
82 |
scal int, |
---|
83 |
grow int, |
---|
84 |
procMult int, |
---|
85 |
actualLevels int, |
---|
86 |
goodEnough float, |
---|
87 |
mapping float, |
---|
88 |
comNum int, |
---|
89 |
comSize int |
---|
90 |
); |
---|
91 |
|
---|
92 |
CREATE TABLE minMax ( |
---|
93 |
app varchar(40), |
---|
94 |
t int, |
---|
95 |
minMaxSynch float, |
---|
96 |
minMaxLB float |
---|
97 |
); |
---|
98 |
|
---|
99 |
CREATE TABLE ruleTemp (id int, app varchar(25), t int, metric1 float); |
---|
100 |
|
---|