History

OMF Main Page » OMF User Guide » BasicTutorials-5-2 » BasicTutorialStage0-5-2 »

Example of the measurement database dump for the "Hello World" experiment:

  • Please refer to the OML Documentation pages to learn more about the different standard tables and fields in any OML generated measurement database
--
-- Database Dump
-- Experiment ID: npc_2009_11_04_14_27_33
--
BEGIN TRANSACTION;
CREATE TABLE _experiment_metadata (key TEXT PRIMARY KEY, value TEXT);
INSERT INTO "_experiment_metadata" VALUES('start_time','1257395202');
CREATE TABLE _senders (name TEXT PRIMARY KEY, id INTEGER UNIQUE);
INSERT INTO "_senders" VALUES('Receiver',1);
INSERT INTO "_senders" VALUES('Sender',2);
CREATE TABLE otr2_udp_in (oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, ts_avg REAL, ts_min REAL, ts_max REAL, flow_id_avg REAL, flow_id_min REAL, flow_id_max REAL, seq_no_avg REAL, seq_no_min REAL, seq_no_max REAL, pkt_length_avg REAL, pkt_length_min REAL, pkt_length_max REAL, dst_host TEXT, dst_port_avg REAL, dst_port_min REAL, dst_port_max REAL);
INSERT INTO "otr2_udp_in" VALUES(1,1,3.99566999822855,3.614641,2.01813149824739,1.0058899987489,3.03037299960852,-26442.0,-26442.0,-26442.0,1.5,1.0,2.0,512.0,512.0,512.0,'192.168.0.2',48295.0,48295.0,48295.0);
INSERT INTO "otr2_udp_in" VALUES(1,2,6.99584099650383,6.614501,3.22356379777193,1.0058899987489,5.03030699491501,-26442.0,-26442.0,-26442.0,3.0,1.0,5.0,512.0,512.0,512.0,'192.168.0.2',48295.0,48295.0,48295.0);
INSERT INTO "otr2_udp_in" VALUES(1,3,9.99594399333,9.61435,4.64758249372244,1.0058899987489,8.02096399664879,-26442.0,-26442.0,-26442.0,4.5,1.0,8.0,512.0,512.0,512.0,'192.168.0.2',48295.0,48295.0,48295.0);
INSERT INTO "otr2_udp_in" VALUES(1,4,12.9960609972477,12.61421,6.11307490617037,1.0058899987489,11.0212999880314,-26442.0,-26442.0,-26442.0,6.0,1.0,11.0,512.0,512.0,512.0,'192.168.0.2',48295.0,48295.0,48295.0);
INSERT INTO "otr2_udp_in" VALUES(1,5,15.9962029904127,15.614091,6.60546541213989,1.0058899987489,12.0217609852552,-26442.0,-26442.0,-26442.0,6.58333332836628,1.0,13.0,512.0,512.0,512.0,'192.168.0.2',48295.0,48295.0,48295.0);
INSERT INTO "otr2_udp_in" VALUES(1,6,18.9963199794292,18.613946,8.42192798852921,1.0058899987489,17.0210679769516,-26442.0,-26442.0,-26442.0,8.46666665375233,1.0,17.0,512.0,512.0,512.0,'192.168.0.2',48295.0,48295.0,48295.0);
INSERT INTO "otr2_udp_in" VALUES(1,7,21.9964349865913,21.613802,10.1885072141886,1.0058899987489,20.0211079716682,-26442.0,-26442.0,-26442.0,10.2222222089767,1.0,20.0,512.0,512.0,512.0,'192.168.0.2',48295.0,48295.0,48295.0);
INSERT INTO "otr2_udp_in" VALUES(1,8,24.9965499937534,24.613652,11.8788929432631,1.0058899987489,23.0214529931545,-26442.0,-26442.0,-26442.0,11.9047618955374,1.0,23.0,512.0,512.0,512.0,'192.168.0.2',48295.0,48295.0,48295.0);
INSERT INTO "otr2_udp_in" VALUES(1,9,27.9966929852963,27.613538,12.9783485531807,1.0058899987489,25.0241419970989,-26442.0,-26442.0,-26442.0,13.0,1.0,25.0,512.0,512.0,512.0,'192.168.0.2',48295.0,48295.0,48295.0);
CREATE TABLE otg2_udp_out (oml_sender_id INTEGER, oml_seq INTEGER, oml_ts_client REAL, oml_ts_server REAL, ts_avg REAL, ts_min REAL, ts_max REAL, flow_id_avg REAL, flow_id_min REAL, flow_id_max REAL, seq_no_avg REAL, seq_no_min REAL, seq_no_max REAL, pkt_length_avg REAL, pkt_length_min REAL, pkt_length_max REAL, dst_host TEXT, dst_port_avg REAL, dst_port_min REAL, dst_port_max REAL);
INSERT INTO "otg2_udp_out" VALUES(2,1,4.01752699911594,3.660961,2.99603366479278,1.99604199826717,3.99602799862623,1.0,1.0,1.0,2.0,1.0,3.0,512.0,512.0,512.0,'192.168.0.3',3000.0,3000.0,3000.0);
INSERT INTO "otg2_udp_out" VALUES(2,2,7.01766899973154,6.660822,4.49603666365147,1.99604199826717,6.99602799862623,1.0,1.0,1.0,3.5,1.0,6.0,512.0,512.0,512.0,'192.168.0.3',3000.0,3000.0,3000.0);
INSERT INTO "otg2_udp_out" VALUES(2,3,10.01775598526,9.660722,5.9960411041975,1.99604199826717,9.99605599045753,1.0,1.0,1.0,5.0,1.0,9.0,512.0,512.0,512.0,'192.168.0.3',3000.0,3000.0,3000.0);
INSERT INTO "otg2_udp_out" VALUES(2,4,13.017843991518,12.660542,7.49603758007288,1.99604199826717,12.9960269927979,1.0,1.0,1.0,6.5,1.0,12.0,512.0,512.0,512.0,'192.168.0.3',3000.0,3000.0,3000.0);
INSERT INTO "otg2_udp_out" VALUES(2,5,16.0179189741611,15.660413,8.99603526294231,1.99604199826717,15.9960259944201,1.0,1.0,1.0,8.0,1.0,15.0,512.0,512.0,512.0,'192.168.0.3',3000.0,3000.0,3000.0);
INSERT INTO "otg2_udp_out" VALUES(2,6,19.0180079936981,18.660269,10.496035605669,1.99604199826717,18.9960269927979,1.0,1.0,1.0,9.5,1.0,18.0,512.0,512.0,512.0,'192.168.0.3',3000.0,3000.0,3000.0);
INSERT INTO "otg2_udp_out" VALUES(2,7,22.0180969834328,21.660158,11.9960375577211,1.99604199826717,21.9960569739342,1.0,1.0,1.0,11.0,1.0,21.0,512.0,512.0,512.0,'192.168.0.3',3000.0,3000.0,3000.0);
INSERT INTO "otg2_udp_out" VALUES(2,8,25.0182089805603,24.660031,13.4960373193026,1.99604199826717,24.9960539937019,1.0,1.0,1.0,12.5,1.0,24.0,512.0,512.0,512.0,'192.168.0.3',3000.0,3000.0,3000.0);
INSERT INTO "otg2_udp_out" VALUES(2,9,28.0182949900627,27.659909,14.9960361719131,1.99604199826717,27.9960279762745,1.0,1.0,1.0,14.0,1.0,27.0,512.0,512.0,512.0,'192.168.0.3',3000.0,3000.0,3000.0);
COMMIT;