There are 3 tables in the SLAC Oracle database that contain data for the IEPM-BW measurements.
Each table has an associated index that guarantees the uniqueness of the data.
| ABWE table |
TABLE ABWE (aliasName VARCHAR(30),
nodeName VARCHAR(30),
ipAddress VARCHAR(30),
timeStamp INTEGER,
ABw REAL,
Xtr REAL,
DBCap REAL,
avABw REAL,
avXtr REAL,
avDBCap REAL,
rtt REAL)
|
| ABWE table index | UNIQUE INDEX ABWE_INDEX on ABWE (aliasName, timeStamp) |
| IEPM BW table |
TABLE IEPM_BW (aliasName VARCHAR(30),
nodeName VARCHAR(30),
ipAddress VARCHAR(30),
timeStamp INTEGER,
toolName VARCHAR(30),
throughput REAL,
stream INTEGER,
window_size INTEGER)
|
| IEPM table index | UNIQUE INDEX IEPM_BW_INDEX on IEPM_BW (aliasName, timeStamp, toolName) |
| IEPM route table |
TABLE IEPM_BW_ROUTE (aliasName VARCHAR(30),
nodeName VARCHAR(30),
ipAddress VARCHAR(30),
timeStamp INTEGER,
toolName VARCHAR(30),
routenumber INTEGER,
route VARCHAR(1024))
|
| IEPM route table index | UNIQUE INDEX iEPM_BW-ROUTE-INDEX on IEPM_BW_ROUTE (aliasName, timeStamp, toolName) |