DB
Gliffy Diagram | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Sql Statements
Data Table
Code Block |
---|
CREATE TABLE `Data` ( `ID` int(10) NOT NULL, `Metadata_ID` int(10) NOT NULL, `TransferTime` datetime NOT NULL, `NBytes` int(20) NOT NULL, `Duration` int(20) NOT NULL, KEY `TransferTimeIndex` (`TransferTime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
Metadata Table
Code Block |
---|
CREATE TABLE `Metadata` ( `Stripes` varchar(255) default NULL, `BufferSize` int(32) default NULL, `BlockSize` int(32) default NULL, `Program` varchar(22) default NULL, `User` varchar(50) default NULL, `EndPointID` varchar(11) default NULL, `Streams` int(32) default NULL, `DestPath` varchar(255) default NULL, `SrcPath` varchar(255) default NULL, `ID` int(10) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `uni_metadata` (`Streams`,`Stripes`,`BufferSize`,`BlockSize`,`Program`,`User`,`EndPointID`,`DestPath`,`SrcPath`) ) ENGINE=InnoDB AUTO_INCREMENT=497967 DEFAULT CHARSET=utf8 COLLATE=utf8_bin \| |
EndPoints Table
Code Block |
---|
CREATE TABLE `EndPoints` ( `ID` int(11) NOT NULL auto_increment, `DestIP` varchar(32) NOT NULL, `SrcIP` varchar(32) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `uni_endpoint` (`DestIP`,`SrcIP`) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_bin \| |
System Design
Gliffy Diagram | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|