INSERT INTO `gssim_results`.`user` (`id`, `dn`) VALUES (1, 'irondn'), (2, 'irondn2'); INSERT INTO `gssim_results`.`configuration` (`id`) VALUES (2), (3); INSERT INTO `gssim_results`.`blob_property` (`config_id`, `name`, `value`) VALUES (2, 'Network topology', 0x31320a526f757465725f50534e430a526f757465725f4345534e45540a526f757465725f44464e0a526f757465725f474152520a526f757465725f4b54480a526f757465725f4845414e65740a526f757465725f5357495443480a526f757465725f48554e4741524e45540a526f757465725f526564495249530a526f757465725f49324341540a526f757465725f4643434e0a526f757465725f47524e45540a31380a526f757465725f4b54480909526f757465725f4845414e65740909310933303009313530303030300a526f757465725f4b54480909526f757465725f50534e430909310933303009313530303030300a526f757465725f50534e430909526f757465725f44464e0909310933303009313530303030300a526f757465725f50534e430909526f757465725f474152520909310933303009313530303030300a526f757465725f50534e430909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f44464e0909526f757465725f474152520909310933303009313530303030300a526f757465725f44464e0909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f44464e0909526f757465725f5357495443480909310933303009313530303030300a526f757465725f474152520909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f474152520909526f757465725f526564495249530909310933303009313530303030300a526f757465725f4345534e45540909526f757465725f47524e45540909310933303009313530303030300a526f757465725f47524e45540909526f757465725f48554e4741524e45540909310933303009313530303030300a526f757465725f47524e45540909526f757465725f526564495249530909310933303009313530303030300a526f757465725f48554e4741524e45540909526f757465725f5357495443480909310933303009313530303030300a526f757465725f526564495249530909526f757465725f49324341540909310933303009313530303030300a526f757465725f526564495249530909526f757465725f4643434e0909310933303009313530303030300a526f757465725f526564495249530909526f757465725f4845414e65740909310933303009313530303030300a526f757465725f5357495443480909526f757465725f4845414e65740909310933303009313530303030300a32300a50534e432d766e536572766572310909526f757465725f50534e430909310933303009313530303030300a50534e432d766e536572766572320909526f757465725f50534e430909310933303009313530303030300a50534e432d726f757465720909526f757465725f50534e430909310933303009313530303030300a4345534e45542d766e536572766572310909526f757465725f4345534e45540909310933303009313530303030300a4345534e45542d766e536572766572320909526f757465725f4345534e45540909310933303009313530303030300a4345534e45542d726f757465720909526f757465725f4345534e45540909310933303009313530303030300a44464e2d766e536572766572310909526f757465725f44464e0909310933303009313530303030300a44464e2d766e536572766572320909526f757465725f44464e0909310933303009313530303030300a44464e2d726f757465720909526f757465725f44464e0909310933303009313530303030300a474152522d766e536572766572310909526f757465725f474152520909310933303009313530303030300a474152522d766e536572766572320909526f757465725f474152520909310933303009313530303030300a474152522d726f757465720909526f757465725f474152520909310933303009313530303030300a4b54482d766e5365727665720909526f757465725f4b54480909310933303009313530303030300a4845414e65742d766e5365727665720909526f757465725f4845414e65740909310933303009313530303030300a5357495443482d766e5365727665720909526f757465725f5357495443480909310933303009313530303030300a48554e4741524e45542d766e5365727665720909526f757465725f48554e4741524e45540909310933303009313530303030300a526564495249532d766e5365727665720909526f757465725f526564495249530909310933303009313530303030300a49324341542d766e5365727665720909526f757465725f49324341540909310933303009313530303030300a4643434e2d766e5365727665720909526f757465725f4643434e0909310933303009313530303030300a47524e45542d766e5365727665720909526f757465725f47524e45540909310933303009313530303030300a310a42726f6b6572496e74657266616365456e7469747920526f757465725f50534e432031202020202033303020202020313530303030300a), (3, 'Network topology', 0x2320746f74616c206e756d626572206f6620726f75746572730a32350a23206561636820726f75746572206e616d650a506f7a6e616e0a4764616e736b0a576172737a6177610a57726f636c61770a4b72616b6f770a4b6f737a616c696e0a537a637a6563696e0a476f727a6f77576c6b700a427964676f737a637a0a546f72756e0a4f6c737a74796e0a4269616c7973746f6b0a5a69656c6f6e61476f72610a4c6f647a0a5261646f6d0a50756c6177790a4c75626c696e0a4f706f6c650a437a6573746f63686f77610a476c69776963650a4b69656c63650a527a65737a6f770a4269656c736b6f4269616c610a4b61746f776963650a5a616d6f73630a0a2320746f74616c206e756d626572206f6620636f6e6e656374696f6e73206265747765656e20726f75746572730a33300a2320636f6e6e656374696f6e73206265747765656e20726f75746572730a4764616e736b204b6f737a616c696e2032302033303020313530303030300a4764616e736b204f6c737a74796e2032302033303020313530303030300a4f706f6c6520476c69776963652032302033303020313530303030300a4b6f737a616c696e20537a637a6563696e2032302033303020313530303030300a537a637a6563696e20476f727a6f77576c6b702032302033303020313530303030300a427964676f737a637a20546f72756e2032302033303020313530303030300a5261646f6d204b69656c63652032302033303020313530303030300a4269656c736b6f4269616c61204b72616b6f772032302033303020313530303030300a506f7a6e616e20576172737a6177612032302033303020313530303030300a4f6c737a74796e204269616c7973746f6b20312036303020313530303030300a4b69656c6365204b72616b6f772032302033303020313530303030300a476c6977696365204b61746f776963652032302033303020313530303030300a57726f636c6177204f706f6c652032302033303020313530303030300a437a6573746f63686f7761204c6f647a2032302033303020313530303030300a527a65737a6f77204b72616b6f7720312036303020313530303030300a4c75626c696e205a616d6f73632032302033303020313530303030300a437a6573746f63686f7761204b61746f776963652032302033303020313530303030300a506f7a6e616e205a69656c6f6e61476f72612032302033303020313530303030300a576172737a617761204269616c7973746f6b2032302033303020313530303030300a546f72756e204764616e736b2032302033303020313530303030300a427964676f737a637a20506f7a6e616e2032302033303020313530303030300a506f7a6e616e20476f727a6f77576c6b702032302033303020313530303030300a4c6f647a20576172737a6177612032302033303020313530303030300a5261646f6d20576172737a6177612032302033303020313530303030300a50756c617779205261646f6d2032302033303020313530303030300a50756c617779204c75626c696e2032302033303020313530303030300a527a65737a6f77205a616d6f73632032302033303020313530303030300a4c6f647a20506f7a6e616e2032302033303020313530303030300a5a69656c6f6e61476f72612057726f636c61772032302033303020313530303030300a4269656c736b6f4269616c6120476c69776963652032302033303020313530303030300a0a2320746f74616c206e756d626572206f66207265736f75726365730a350a2320636f6e6e656374696f6e73206265747765656e207265736f7572636520616e6420726f757465720a5043535320506f7a6e616e2032302031303020313530303030300a574353532057726f636c61772032302031303020313530303030300a437966726f6e6574204b72616b6f772032302031303020313530303030300a43495441534b204764616e736b2032302031303020313530303030300a49434d20576172737a6177612032302031303020313530303030300a0a2320746f74616c206e756d626572206f662075736572730a310a2320636f6e6e656374696f6e206265747765656e207573657220616e6420726f757465720a42726f6b6572496e74657266616365456e74697479205a69656c6f6e61476f72612032302032303020313530303030300a); INSERT INTO `gssim_results`.`text_property` (`config_id`, `name`, `value`) VALUES (2, 'Grid scheduling', 'GridschedulingFCFSSR'), (2, 'Local grid scheduling', 'FCFSAllocPolicy'), (2, 'Execution time estimation', 'ExecutionTimeEstimationPluginImpl'), (3, 'Grid scheduling', 'GridschedulingARFCFS'), (3, 'Local grid scheduling', 'LocalGridPluginAR'), (3, 'Execution time estimation', 'ExecutionTimeEstimationPluginImpl'); INSERT INTO `gssim_results`.`experiment` (`PK`, `user_id`, `config_id`, `commission_date`, `name`, `description`, `status`, `metaexp_id`) VALUES (2, 1, 2, NULL, 'exp1', 'exp1 desc', 'FINISHED', NULL), (3, 2, 3, NULL, 'exp1', 'exp1 desc', 'RUNNING', NULL), (4, 1, 2, NULL, 'exp1', 'exp1 desc', 'FAILED', NULL), (5, 2, 3, NULL, 'exp1', 'exp1 desc', 'FINISHED', NULL); INSERT INTO `gssim_results`.`experiment_stats` (`id`, `name`, `value`) VALUES ('2', 'Delayed tasks', '0'), ('2', 'Failed requests (tasks)', '0'), ('2', 'Makespan', '57600'), ('2', 'Resources queue length', '0.531'), ('2', 'Resources total load', '0.49'), ('2', 'Resources reservation load', '0.49'), ('2', 'Energy usage', '1.312'), ('2', 'Task completion time', '29630.769'), ('2', 'Task execution time', '13015.385'), ('2', 'Task start time', '6092.308'), ('2', 'Task flow time', '13015.385'), ('2', 'Task waiting time', '6092.308'), ('2', 'Task lateness', '0'), ('2', 'Task tardiness', '0'), ('3', 'Delayed tasks', '0'), ('3', 'Failed requests (tasks)', '0'), ('2', 'Makespan', '57600'), ('3', 'Resources queue length', '0.687'), ('3', 'Resources total load', '0.49'), ('3', 'Resources reservation load', '0.49'), ('3', 'Energy usage', '1.375'), ('3', 'Task completion time', '29630.769'), ('3', 'Task execution time', '13015.385'), ('3', 'Task start time', '6092.308'), ('3', 'Task flow time', '13015.385'), ('3', 'Task waiting time', '6092.308'), ('3', 'Task lateness', '0'), ('3', 'Task tardiness', '0'), ('4', 'Delayed tasks', '0'), ('4', 'Failed requests (tasks)', '0'), ('4', 'Makespan', '32400'), ('4', 'Resources queue length', '0.389'), ('4', 'Resources total load', '0.175'), ('4', 'Resources reservation load', '0.183'), ('4', 'Energy usage', '0.238'), ('4', 'Task completion time', '23398.8'), ('4', 'Task execution time', '7920'), ('4', 'Task start time', '15478.8'), ('4', 'Task flow time', '8278.8'), ('4', 'Task waiting time', '15477.6'), ('4', 'Task lateness', '-1.2'), ('4', 'Task tardiness', '0'), ('5', 'Delayed tasks', '0'), ('5', 'Failed requests (tasks)', '0'), ('2', 'Makespan', '61042'), ('5', 'Resources queue length', '0.393'), ('5', 'Resources total load', '0.286'), ('5', 'Resources reservation load', '0.345'), ('5', 'Energy usage', '0.756'), ('5', 'Task completion time', '40059.143'), ('5', 'Task execution time', '17485.714'), ('5', 'Task start time', '3030.571'), ('5', 'Task flow time', '20516.286'), ('5', 'Task waiting time', '3029.571'), ('5', 'Task lateness', '-569.429'), ('5', 'Task tardiness', '0'); INSERT INTO `gssim_results`.`task` (`PK`, `exp_id`, `job_id`, `exec_start_date`, `exec_finish_date`, `exec_end_date`, `completion_time`, `execution_time`, `start_time`, `flow_time`, `waiting_time`, `gq_waiting_time`, `lateness`, `tardiness`, `makespan`) VALUES ('20', '2', '0', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), '7200', '7200', '0', '7200', '0', '0', '0', '0', '7200'), ('21', '2', '1', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '3600', '7200', '3600', '0', '0', '0', '10800'), ('210', '2', '10', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), '14400', '14400', '0', '14400', '0', '0', '0', '0', '14400'), ('211', '2', '11', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '28800', '0', '28800', '0', '0', '0', '0', '28800'), ('212', '2', '12', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '0', '7200', '0', '0', '0', '0', '10800'), ('213', '2', '13', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), '43200', '21600', '0', '21600', '0', '0', '0', '0', '43200'), ('214', '2', '14', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), '50400', '25200', '0', '25200', '0', '0', '0', '0', '50400'), ('215', '2', '15', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), '54000', '14400', '0', '14400', '0', '0', '0', '0', '54000'), ('216', '2', '16', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), '57600', '10800', '0', '10800', '0', '0', '0', '0', '57600'), ('22', '2', '2', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14400', '0', '0', '0', '21600'), ('23', '2', '3', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '18000', '0', '0', '0', '25200'), ('24', '2', '4', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '7200', '21600', '7200', '21600', '0', '0', '0', '28800'), ('25', '2', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21600', '0', '0', '0', '32400'), ('30', '3', '0', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), '7200', '7200', '0', '7200', '0', '0', '0', '0', '7200'), ('31', '3', '1', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '3600', '7200', '3600', '0', '0', '0', '10800'), ('310', '3', '10', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), '14400', '14400', '0', '14400', '0', '0', '0', '0', '14400'), ('311', '3', '11', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '28800', '0', '28800', '0', '0', '0', '0', '28800'), ('312', '3', '12', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '0', '7200', '0', '0', '0', '0', '10800'), ('313', '3', '13', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), '43200', '21600', '0', '21600', '0', '0', '0', '0', '43200'), ('314', '3', '14', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), '50400', '25200', '0', '25200', '0', '0', '0', '0', '50400'), ('315', '3', '15', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), '54000', '14400', '0', '14400', '0', '0', '0', '0', '54000'), ('316', '3', '16', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), '57600', '10800', '0', '10800', '0', '0', '0', '0', '57600'), ('32', '3', '2', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14400', '0', '0', '0', '21600'), ('33', '3', '3', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '18000', '0', '0', '0', '25200'), ('34', '3', '4', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '28800', '7200', '21600', '7200', '21600', '0', '0', '0', '28800'), ('35', '3', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21600', '0', '0', '0', '32400'), ('41', '4', '1', FROM_UNIXTIME(1225668594), FROM_UNIXTIME(1225675794), FROM_UNIXTIME(1225675800), '8994', '7200', '1794', '8994', '1793', '1', '0', '-6', '8994'), ('43', '4', '3', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14399', '1', '0', '0', '21600'), ('44', '4', '4', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '17999', '1', '0', '0', '25200'), ('45', '4', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '7200', '21600', '7200', '21599', '1', '0', '0', '28800'), ('46', '4', '6', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21598', '2', '0', '0', '32400'), ('50', '5', '0', FROM_UNIXTIME(1225670322), FROM_UNIXTIME(1225684722), FROM_UNIXTIME(1225684800), '17922', '14400', '3522', '17922', '3521', '1', '0', '-78', '17922'), ('51', '5', '1', FROM_UNIXTIME(1225666802), FROM_UNIXTIME(1225695602), FROM_UNIXTIME(1225699200), '28802', '28800', '2', '28802', '1', '1', '0', '-3598', '28802'), ('52', '5', '2', FROM_UNIXTIME(1225673986), FROM_UNIXTIME(1225681186), FROM_UNIXTIME(1225681200), '14386', '7200', '3586', '10786', '3585', '1', '0', '-14', '14386'), ('53', '5', '3', FROM_UNIXTIME(1225691986), FROM_UNIXTIME(1225713586), FROM_UNIXTIME(1225713600), '46786', '21600', '3586', '25186', '3585', '1', '0', '-14', '46786'), ('54', '5', '4', FROM_UNIXTIME(1225695570), FROM_UNIXTIME(1225720770), FROM_UNIXTIME(1225720800), '53970', '25200', '3570', '28770', '3569', '1', '0', '-30', '53970'), ('55', '5', '5', FROM_UNIXTIME(1225709906), FROM_UNIXTIME(1225724306), FROM_UNIXTIME(1225724400), '57506', '14400', '3506', '17906', '3505', '1', '0', '-94', '57506'), ('56', '5', '6', FROM_UNIXTIME(1225717042), FROM_UNIXTIME(1225727842), FROM_UNIXTIME(1225728000), '61042', '10800', '3442', '14242', '3441', '1', '0', '-158', '61042'); INSERT INTO `gssim_results`.`task` (`PK`, `exp_id`, `job_id`, `task_id`, `parent_id`, `exec_start_date`, `exec_finish_date`, `exec_end_date`, `gb_submit_date`, `lb_submit_date`, `completion_time`, `exec_start_time`, `execution_time`, `ready_time`, `start_time`, `flow_time`, `waiting_time`, `gq_waiting_time`, `lateness`, `tardiness`) VALUES ('2000', '2', '0', '0', '20', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '7200', '0', '7200', '0', '0', '7200', '0', '0', '0', '0'), ('2100', '2', '1', '0', '21', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '10800', '3600', '7200', '3600', '3600', '7200', '3600', '0', '0', '0'), ('21000', '2', '10', '0', '210', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '14400', '0', '14400', '0', '0', '14400', '0', '0', '0', '0'), ('21100', '2', '11', '0', '211', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '28800', '0', '28800', '0', '0', '28800', '0', '0', '0', '0'), ('21200', '2', '12', '0', '212', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225670400), '10800', '3600', '7200', '3600', '0', '7200', '0', '0', '0', '0'), ('21300', '2', '13', '0', '213', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '43200', '21600', '21600', '21600', '0', '21600', '0', '0', '0', '0'), ('21400', '2', '14', '0', '214', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '50400', '25200', '25200', '25200', '0', '25200', '0', '0', '0', '0'), ('21500', '2', '15', '0', '215', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225706400), '54000', '39600', '14400', '39600', '0', '14400', '0', '0', '0', '0'), ('21600', '2', '16', '0', '216', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225713600), '57600', '46800', '10800', '46800', '0', '10800', '0', '0', '0', '0'), ('2200', '2', '2', '0', '22', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '21600', '14400', '7200', '14400', '14400', '7200', '14400', '0', '0', '0'), ('2300', '2', '3', '0', '23', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '25200', '18000', '7200', '18000', '18000', '7200', '18000', '0', '0', '0'), ('2400', '2', '4', '0', '24', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '28800', '21600', '7200', '21600', '21600', '7200', '21600', '0', '0', '0'), ('2500', '2', '5', '0', '25', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '32400', '21600', '10800', '21600', '21600', '10800', '21600', '0', '0', '0'), ('3000', '3', '0', '0', '30', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '7200', '0', '7200', '0', '0', '7200', '0', '0', '0', '0'), ('3100', '3', '1', '0', '31', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '10800', '3600', '7200', '3600', '3600', '7200', '3600', '0', '0', '0'), ('31000', '3', '10', '0', '310', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '14400', '0', '14400', '0', '0', '14400', '0', '0', '0', '0'), ('31100', '3', '11', '0', '311', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '28800', '0', '28800', '0', '0', '28800', '0', '0', '0', '0'), ('31200', '3', '12', '0', '312', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225670400), '10800', '3600', '7200', '3600', '0', '7200', '0', '0', '0', '0'), ('31300', '3', '13', '0', '313', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '43200', '21600', '21600', '21600', '0', '21600', '0', '0', '0', '0'), ('31400', '3', '14', '0', '314', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '50400', '25200', '25200', '25200', '0', '25200', '0', '0', '0', '0'), ('31500', '3', '15', '0', '315', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225706400), '54000', '39600', '14400', '39600', '0', '14400', '0', '0', '0', '0'), ('31600', '3', '16', '0', '316', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225713600), '57600', '46800', '10800', '46800', '0', '10800', '0', '0', '0', '0'), ('3200', '3', '2', '0', '32', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '21600', '14400', '7200', '14400', '14400', '7200', '14400', '0', '0', '0'), ('3300', '3', '3', '0', '33', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '25200', '18000', '7200', '18000', '18000', '7200', '18000', '0', '0', '0'), ('3400', '3', '4', '0', '34', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '28800', '21600', '7200', '21600', '21600', '7200', '21600', '0', '0', '0'), ('3500', '3', '5', '0', '35', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666800), '32400', '21600', '10800', '21600', '21600', '10800', '21600', '0', '0', '0'), ('4100', '4', '1', '0', '41', FROM_UNIXTIME(1225668594), FROM_UNIXTIME(1225675794), FROM_UNIXTIME(1225675800), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '8994', '1794', '7200', '0', '1794', '8994', '1793', '1', '-6', '0'), ('4300', '4', '3', '0', '43', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '21600', '14400', '7200', '14400', '14400', '7200', '14399', '1', '0', '0'), ('4400', '4', '4', '0', '44', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '25200', '18000', '7200', '18000', '18000', '7200', '17999', '1', '0', '0'), ('4500', '4', '5', '0', '45', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '28800', '21600', '7200', '21600', '21600', '7200', '21599', '1', '0', '0'), ('4600', '4', '6', '0', '46', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666802), '32400', '21600', '10800', '21600', '21600', '10800', '21598', '2', '0', '0'), ('5000', '5', '0', '0', '50', FROM_UNIXTIME(1225670322), FROM_UNIXTIME(1225684722), FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '17922', '3522', '14400', '0', '3522', '17922', '3521', '1', '-78', '0'), ('5100', '5', '1', '0', '51', FROM_UNIXTIME(1225666802), FROM_UNIXTIME(1225695602), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225666801), '28802', '2', '28800', '0', '2', '28802', '1', '1', '-3598', '0'), ('5200', '5', '2', '0', '52', FROM_UNIXTIME(1225673986), FROM_UNIXTIME(1225681186), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225670401), '14386', '7186', '7200', '3600', '3586', '10786', '3585', '1', '-14', '0'), ('5300', '5', '3', '0', '53', FROM_UNIXTIME(1225691986), FROM_UNIXTIME(1225713586), FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688401), '46786', '25186', '21600', '21600', '3586', '25186', '3585', '1', '-14', '0'), ('5400', '5', '4', '0', '54', FROM_UNIXTIME(1225695570), FROM_UNIXTIME(1225720770), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692001), '53970', '28770', '25200', '25200', '3570', '28770', '3569', '1', '-30', '0'), ('5500', '5', '5', '0', '55', FROM_UNIXTIME(1225709906), FROM_UNIXTIME(1225724306), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225706401), '57506', '43106', '14400', '39600', '3506', '17906', '3505', '1', '-94', '0'), ('5600', '5', '6', '0', '56', FROM_UNIXTIME(1225717042), FROM_UNIXTIME(1225727842), FROM_UNIXTIME(1225728000), FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225713601), '61042', '50242', '10800', '46800', '3442', '14242', '3441', '1', '-158', '0'); INSERT INTO `gssim_results`.`resource` (`PK`, `exp_id`, `name`, `type`, `allocation_load`, `reservation_load`) VALUES ('21', '2', 'compRes1', 'computing', '0.604', '0.604'), ('22', '2', 'compRes2', 'computing', '0.375', '0.375'), ('31', '3', 'compRes1', 'computing', '0.646', '0.646'), ('32', '3', 'compRes2', 'computing', '0.333', '0.333'), ('41', '4', 'compRes1', 'computing', '0.185', '0.185'), ('42', '4', 'compRes2', 'computing', '0.222', '0.241'), ('43', '4', 'dataRes1', 'data', '0', '0'), ('44', '4', 'networkRes1', 'network', '0.438', '0.438'), ('51', '5', 'compRes1', 'computing', '0.451', '0.549'), ('52', '5', 'compRes2', 'computing', '0.216', '0.255'), ('53', '5', 'dataRes1', 'data', '0', '0'), ('54', '5', 'networkRes1', 'network', '0.562', '0.562'); INSERT INTO `gssim_results`.`queues` (`fk_resource_id`, `name`, `avg_length`) VALUES ('21', 'default', '0.437'), ('22', 'default', '0.625'), ('31', 'default', '1'), ('32', 'default', '0.375'), ('41', 'default', '0.667'), ('42', 'default', '0.5'), ('43', 'default', '0'), ('51', 'default', '0.414'), ('52', 'default', '0.765'), ('53', 'default', '0'); INSERT INTO `gssim_results`.`resource_allocation_timeline` (`fk_resource_id`, `timestamp`, `usage`) VALUES ('21', FROM_UNIXTIME(1225666800), '2'), ('21', FROM_UNIXTIME(1225674000), '1'), ('21', FROM_UNIXTIME(1225681200), '0'), ('21', FROM_UNIXTIME(1225688400), '2'), ('21', FROM_UNIXTIME(1225692000), '3'), ('21', FROM_UNIXTIME(1225699200), '2'), ('21', FROM_UNIXTIME(1225706400), '3'), ('21', FROM_UNIXTIME(1225710000), '2'), ('21', FROM_UNIXTIME(1225713600), '3'), ('21', FROM_UNIXTIME(1225717200), '2'), ('21', FROM_UNIXTIME(1225720800), '1'), ('21', FROM_UNIXTIME(1225724400), '0'), ('22', FROM_UNIXTIME(1225666800), '1'), ('22', FROM_UNIXTIME(1225670400), '3'), ('22', FROM_UNIXTIME(1225677600), '1'), ('22', FROM_UNIXTIME(1225681200), '2'), ('22', FROM_UNIXTIME(1225684800), '3'), ('22', FROM_UNIXTIME(1225688400), '3'), ('22', FROM_UNIXTIME(1225692000), '2'), ('22', FROM_UNIXTIME(1225695600), '0'), ('31', FROM_UNIXTIME(1225666800), '3'), ('31', FROM_UNIXTIME(1225674000), '2'), ('31', FROM_UNIXTIME(1225681200), '2'), ('31', FROM_UNIXTIME(1225684800), '3'), ('31', FROM_UNIXTIME(1225688400), '3'), ('31', FROM_UNIXTIME(1225692000), '3'), ('31', FROM_UNIXTIME(1225695600), '2'), ('31', FROM_UNIXTIME(1225699200), '1'), ('31', FROM_UNIXTIME(1225713600), '2'), ('31', FROM_UNIXTIME(1225717200), '1'), ('31', FROM_UNIXTIME(1225724400), '0'), ('32', FROM_UNIXTIME(1225666800), '0'), ('32', FROM_UNIXTIME(1225670400), '2'), ('32', FROM_UNIXTIME(1225677600), '0'), ('32', FROM_UNIXTIME(1225688400), '2'), ('32', FROM_UNIXTIME(1225695600), '1'), ('32', FROM_UNIXTIME(1225706400), '2'), ('32', FROM_UNIXTIME(1225710000), '1'), ('32', FROM_UNIXTIME(1225720800), '0'), ('41', FROM_UNIXTIME(1225666800), '0'), ('41', FROM_UNIXTIME(1225688400), '2'), ('41', FROM_UNIXTIME(1225695600), '1'), ('41', FROM_UNIXTIME(1225699200), '0'), ('42', FROM_UNIXTIME(1225666800), '0'), ('42', FROM_UNIXTIME(1225668594), '1'), ('42', FROM_UNIXTIME(1225675794), '0'), ('42', FROM_UNIXTIME(1225681200), '1'), ('42', FROM_UNIXTIME(1225684800), '2'), ('42', FROM_UNIXTIME(1225688400), '1'), ('42', FROM_UNIXTIME(1225692000), '0'), ('43', FROM_UNIXTIME(1225666800), '0'), ('51', FROM_UNIXTIME(1225666800), '0'), ('51', FROM_UNIXTIME(1225670322), '1'), ('51', FROM_UNIXTIME(1225673986), '2'), ('51', FROM_UNIXTIME(1225681186), '1'), ('51', FROM_UNIXTIME(1225684722), '0'), ('51', FROM_UNIXTIME(1225691986), '1'), ('51', FROM_UNIXTIME(1225695570), '2'), ('51', FROM_UNIXTIME(1225709906), '3'), ('51', FROM_UNIXTIME(1225713586), '2'), ('51', FROM_UNIXTIME(1225720770), '1'), ('51', FROM_UNIXTIME(1225724306), '0'), ('52', FROM_UNIXTIME(1225666800), '0'), ('52', FROM_UNIXTIME(1225666802), '1'), ('52', FROM_UNIXTIME(1225695602), '0'), ('52', FROM_UNIXTIME(1225717042), '1'), ('52', FROM_UNIXTIME(1225727842), '0'), ('53', FROM_UNIXTIME(1225666800), '0'); INSERT INTO `gssim_results`.`resource_energy_timeline` (`fk_resource_id`, `timestamp`, `usage`) VALUES ('21', FROM_UNIXTIME(1225666800), '2'), ('21', FROM_UNIXTIME(1225674000), '1'), ('21', FROM_UNIXTIME(1225681200), '0'), ('21', FROM_UNIXTIME(1225688400), '2'), ('21', FROM_UNIXTIME(1225692000), '3'), ('21', FROM_UNIXTIME(1225699200), '2'), ('21', FROM_UNIXTIME(1225706400), '3'), ('21', FROM_UNIXTIME(1225710000), '2'), ('21', FROM_UNIXTIME(1225713600), '3'), ('21', FROM_UNIXTIME(1225717200), '2'), ('21', FROM_UNIXTIME(1225720800), '1'), ('21', FROM_UNIXTIME(1225724400), '0'), ('22', FROM_UNIXTIME(1225666800), '1'), ('22', FROM_UNIXTIME(1225670400), '3'), ('22', FROM_UNIXTIME(1225677600), '1'), ('22', FROM_UNIXTIME(1225681200), '2'), ('22', FROM_UNIXTIME(1225684800), '3'), ('22', FROM_UNIXTIME(1225688400), '3'), ('22', FROM_UNIXTIME(1225692000), '2'), ('22', FROM_UNIXTIME(1225695600), '0'), ('31', FROM_UNIXTIME(1225666800), '3'), ('31', FROM_UNIXTIME(1225674000), '2'), ('31', FROM_UNIXTIME(1225681200), '2'), ('31', FROM_UNIXTIME(1225684800), '3'), ('31', FROM_UNIXTIME(1225688400), '3'), ('31', FROM_UNIXTIME(1225692000), '3'), ('31', FROM_UNIXTIME(1225695600), '2'), ('31', FROM_UNIXTIME(1225699200), '1'), ('31', FROM_UNIXTIME(1225713600), '2'), ('31', FROM_UNIXTIME(1225717200), '1'), ('31', FROM_UNIXTIME(1225724400), '0'), ('32', FROM_UNIXTIME(1225670400), '2'), ('32', FROM_UNIXTIME(1225677600), '0'), ('32', FROM_UNIXTIME(1225688400), '2'), ('32', FROM_UNIXTIME(1225695600), '1'), ('32', FROM_UNIXTIME(1225706400), '2'), ('32', FROM_UNIXTIME(1225710000), '1'), ('32', FROM_UNIXTIME(1225720800), '0'), ('41', FROM_UNIXTIME(1225688400), '2'), ('41', FROM_UNIXTIME(1225695600), '1'), ('41', FROM_UNIXTIME(1225699200), '0'), ('42', FROM_UNIXTIME(1225668594), '1'), ('42', FROM_UNIXTIME(1225675794), '0'), ('42', FROM_UNIXTIME(1225681200), '0'), ('42', FROM_UNIXTIME(1225684800), '2'), ('42', FROM_UNIXTIME(1225688400), '1'), ('42', FROM_UNIXTIME(1225692000), '0'), ('51', FROM_UNIXTIME(1225670322), '1'), ('51', FROM_UNIXTIME(1225673986), '2'), ('51', FROM_UNIXTIME(1225681186), '1'), ('51', FROM_UNIXTIME(1225684722), '0'), ('51', FROM_UNIXTIME(1225691986), '1'), ('51', FROM_UNIXTIME(1225695570), '2'), ('51', FROM_UNIXTIME(1225709906), '3'), ('51', FROM_UNIXTIME(1225713586), '2'), ('51', FROM_UNIXTIME(1225720770), '1'), ('51', FROM_UNIXTIME(1225724306), '0'), ('52', FROM_UNIXTIME(1225666802), '1'), ('52', FROM_UNIXTIME(1225695602), '0'), ('52', FROM_UNIXTIME(1225717042), '1'), ('52', FROM_UNIXTIME(1225727842), '0'); INSERT INTO `gssim_results`.`unit` (`PK`, `resource_id`, `type`, `name`, `amount`, `allocation_load`, `reservation_load`) VALUES ('210', '21', 'computing', '0@compRes1', '1', '0.562', '0.562'), ('211', '21', 'computing', '1@compRes1', '1', '0.812', '0.812'), ('212', '21', 'computing', '2@compRes1', '1', '0.437', '0.437'), ('220', '22', 'computing', '0@compRes2', '1', '0.5', '0.5'), ('221', '22', 'computing', '1@compRes2', '1', '0.375', '0.375'), ('222', '22', 'computing', '2@compRes2', '1', '0.25', '0.25'), ('310', '31', 'computing', '0@compRes1', '1', '0.625', '0.625'), ('311', '31', 'computing', '1@compRes1', '1', '0.812', '0.812'), ('312', '31', 'computing', '2@compRes1', '1', '0.5', '0.5'), ('320', '32', 'computing', '0@compRes2', '1', '0.5', '0.5'), ('321', '32', 'computing', '1@compRes2', '1', '0.5', '0.5'), ('322', '32', 'computing', '2@compRes2', '1', '0', '0'), ('410', '41', 'computing', '0@compRes1', '1', '0.333', '0.333'), ('411', '41', 'computing', '1@compRes1', '1', '0.222', '0.222'), ('412', '41', 'computing', '2@compRes1', '1', '0', '0'), ('420', '42', 'computing', '0@compRes2', '1', '0.444', '0.5'), ('421', '42', 'computing', '1@compRes2', '1', '0.222', '0.222'), ('422', '42', 'computing', '2@compRes2', '1', '0', '0'), ('430', '43', 'data', '0@compRes3', '1', '0', '0'), ('440', '44', 'link', 'R1_R2_link', '1', '0', '0'), ('441', '44', 'link', 'R2_R5_link', '1', '0.003981', '0.003981'), ('442', '44', 'link', 'R1_R3_link', '1', '0', '0'), ('443', '44', 'link', 'R3_R4_link', '1', '0', '0'), ('444', '44', 'link', 'R4_R5_link', '1', '0.010617', '0.010617'), ('445', '44', 'link', 'compRes1_link', '1', '0.003981', '0.003981'), ('446', '44', 'link', 'compRes2_link', '1', '0.010617', '0.010617'), ('447', '44', 'link', 'dataRes1_link', '1', '0.014598', '0.014598'), ('448', '44', 'link', 'BrokerInterfaceEntity_link', '1', '0', '0'), ('510', '51', 'computing', '0@compRes1', '1', '0.588', '0.706'), ('511', '51', 'computing', '1@compRes1', '1', '0.529', '0.647'), ('512', '51', 'computing', '2@compRes1', '1', '0.235', '0.294'), ('520', '52', 'computing', '0@compRes2', '1', '0.647', '0.765'), ('521', '52', 'computing', '1@compRes2', '1', '0', '0'), ('522', '52', 'computing', '2@compRes2', '1', '0', '0'), ('530', '53', 'data', '0@compRes3', '1', '0', '0'), ('540', '54', 'link', 'R1_R2_link', '1', '0.000261', '0.000261'), ('541', '54', 'link', 'R2_R5_link', '1', '0.001438', '0.001438'), ('542', '54', 'link', 'R1_R3_link', '1', '0.000261', '0.000261'), ('543', '54', 'link', 'R3_R4_link', '1', '0.000261', '0.000261'), ('544', '54', 'link', 'R4_R5_link', '1', '0', '0'), ('545', '54', 'link', 'compRes1_link', '1', '0.001438', '0.001438'), ('546', '54', 'link', 'compRes2_link', '1', '0.000261', '0.000261'), ('547', '54', 'link', 'dataRes1_link', '1', '0.001699', '0.001699'), ('548', '54', 'link', 'BrokerInterfaceEntity_link', '1', '0', '0'); INSERT INTO `gssim_results`.`unit_details` (`fk_unit_id`, `name`, `value`) VALUES ('210', 'details', '1'), ('211', 'details', '2'), ('212', 'details', '3'), ('220', 'details', '4'), ('221', 'details', '5'), ('222', 'details', '6'), ('310', 'details', '8'), ('311', 'details', '9'), ('312', 'details', '10'), ('320', 'details', '11'), ('321', 'details', '12'), ('322', 'details', '13'), ('410', 'details', '15'), ('411', 'details', '16'), ('412', 'details', '17'), ('420', 'details', '18'), ('421', 'details', '19'), ('422', 'details', '20'), ('430', 'details', '21'), ('440', 'Baud rate (bits/s)', '1000000'), ('440', 'delay(ms)', '300'), ('440', 'size of transmitted data(in bytes)', '2'), ('441', 'Baud rate (bits/s)', '1000000'), ('441', 'delay(ms)', '300'), ('441', 'size of transmitted data(in bytes)', '0'), ('442', 'Baud rate (bits/s)', '1000000'), ('442', 'delay(ms)', '300'), ('442', 'size of transmitted data(in bytes)', '3'), ('443', 'Baud rate (bits/s)', '1000000'), ('443', 'delay(ms)', '300'), ('443', 'size of transmitted data(in bytes)', '3'), ('444', 'Baud rate (bits/s)', '1000000'), ('444', 'delay(ms)', '300'), ('444', 'size of transmitted data(in bytes)', '0'), ('445', 'Baud rate (bits/s)', '1000000'), ('445', 'delay(ms)', '300'), ('445', 'size of transmitted data(in bytes)', '2'), ('446', 'Baud rate (bits/s)', '1000000'), ('446', 'delay(ms)', '300'), ('446', 'size of transmitted data(in bytes)', '3'), ('447', 'Baud rate (bits/s)', '1000000'), ('447', 'delay(ms)', '300'), ('447', 'size of transmitted data(in bytes)', '0'), ('448', 'Baud rate (bits/s)', '1000000'), ('448', 'delay(ms)', '300'), ('448', 'size of transmitted data(in bytes)', '5'), ('510', 'details', '23'), ('511', 'details', '24'), ('512', 'details', '25'), ('520', 'details', '26'), ('521', 'details', '27'), ('522', 'details', '28'), ('530', 'details', '29'), ('540', 'Baud rate (bits/s)', '10000000'), ('540', 'delay(ms)', '300'), ('540', 'size of transmitted data(in bytes)', '5'), ('541', 'Baud rate (bits/s)', '10000000'), ('541', 'delay(ms)', '300'), ('541', 'size of transmitted data(in bytes)', '5'), ('542', 'Baud rate (bits/s)', '10000000'), ('542', 'delay(ms)', '300'), ('542', 'size of transmitted data(in bytes)', '2'), ('543', 'Baud rate (bits/s)', '10000000'), ('543', 'delay(ms)', '300'), ('543', 'size of transmitted data(in bytes)', '2'), ('544', 'Baud rate (bits/s)', '10000000'), ('544', 'delay(ms)', '300'), ('544', 'size of transmitted data(in bytes)', '0'), ('545', 'Baud rate (bits/s)', '10000000'), ('545', 'delay(ms)', '300'), ('545', 'size of transmitted data(in bytes)', '5'), ('546', 'Baud rate (bits/s)', '10000000'), ('546', 'delay(ms)', '300'), ('546', 'size of transmitted data(in bytes)', '2'), ('547', 'Baud rate (bits/s)', '10000000'), ('547', 'delay(ms)', '300'), ('547', 'size of transmitted data(in bytes)', '0'), ('548', 'Baud rate (bits/s)', '10000000'), ('548', 'delay(ms)', '300'), ('548', 'size of transmitted data(in bytes)', '7'); INSERT INTO `gssim_results`.`unit_allocation_timeline` (`fk_unit_id`, `timestamp`, `usage`) VALUES ('210', FROM_UNIXTIME(1225666800), '0.4'), ('210', FROM_UNIXTIME(1225674000), '0.2'), ('210', FROM_UNIXTIME(1225681200), '0'), ('210', FROM_UNIXTIME(1225688400), '0.4'), ('210', FROM_UNIXTIME(1225692000), '0.6'), ('210', FROM_UNIXTIME(1225699200), '0.4'), ('210', FROM_UNIXTIME(1225706400), '0.6'), ('210', FROM_UNIXTIME(1225710000), '0.4'), ('210', FROM_UNIXTIME(1225713600), '0.6'), ('210', FROM_UNIXTIME(1225717200), '0.4'), ('210', FROM_UNIXTIME(1225720800), '0.2'), ('210', FROM_UNIXTIME(1225724400), '0'), ('211', FROM_UNIXTIME(1225666800), '0.6'), ('211', FROM_UNIXTIME(1225674000), '0.3'), ('211', FROM_UNIXTIME(1225681200), '0'), ('211', FROM_UNIXTIME(1225688400), '0.6'), ('211', FROM_UNIXTIME(1225692000), '0.9'), ('211', FROM_UNIXTIME(1225699200), '0.6'), ('211', FROM_UNIXTIME(1225706400), '0.9'), ('211', FROM_UNIXTIME(1225710000), '0.6'), ('211', FROM_UNIXTIME(1225713600), '0.9'), ('211', FROM_UNIXTIME(1225717200), '0.6'), ('211', FROM_UNIXTIME(1225720800), '0.3'), ('211', FROM_UNIXTIME(1225724400), '0'), ('212', FROM_UNIXTIME(1225666800), '1'), ('212', FROM_UNIXTIME(1225674000), '0.5'), ('212', FROM_UNIXTIME(1225681200), '0'), ('212', FROM_UNIXTIME(1225688400), '1'), ('212', FROM_UNIXTIME(1225692000), '1.5'), ('212', FROM_UNIXTIME(1225699200), '1'), ('212', FROM_UNIXTIME(1225706400), '1.5'), ('212', FROM_UNIXTIME(1225710000), '1'), ('212', FROM_UNIXTIME(1225713600), '1.5'), ('212', FROM_UNIXTIME(1225717200), '1'), ('212', FROM_UNIXTIME(1225720800), '0.5'), ('212', FROM_UNIXTIME(1225724400), '0'), ('220', FROM_UNIXTIME(1225666800), '0.2'), ('220', FROM_UNIXTIME(1225670400), '0.6'), ('220', FROM_UNIXTIME(1225677600), '0.2'), ('220', FROM_UNIXTIME(1225681200), '0.4'), ('220', FROM_UNIXTIME(1225684800), '0.6'), ('220', FROM_UNIXTIME(1225688400), '0.6'), ('220', FROM_UNIXTIME(1225692000), '0.4'), ('220', FROM_UNIXTIME(1225695600), '0'), ('221', FROM_UNIXTIME(1225666800), '0.3'), ('221', FROM_UNIXTIME(1225670400), '0.9'), ('221', FROM_UNIXTIME(1225677600), '0.3'), ('221', FROM_UNIXTIME(1225681200), '0.6'), ('221', FROM_UNIXTIME(1225684800), '0.9'), ('221', FROM_UNIXTIME(1225688400), '0.9'), ('221', FROM_UNIXTIME(1225692000), '0.6'), ('221', FROM_UNIXTIME(1225695600), '0'), ('222', FROM_UNIXTIME(1225666800), '0.5'), ('222', FROM_UNIXTIME(1225670400), '1.5'), ('222', FROM_UNIXTIME(1225677600), '0.5'), ('222', FROM_UNIXTIME(1225681200), '1'), ('222', FROM_UNIXTIME(1225684800), '1.5'), ('222', FROM_UNIXTIME(1225688400), '1.5'), ('222', FROM_UNIXTIME(1225692000), '1'), ('222', FROM_UNIXTIME(1225695600), '0'), ('310', FROM_UNIXTIME(1225666800), '0.6'), ('310', FROM_UNIXTIME(1225674000), '0.4'), ('310', FROM_UNIXTIME(1225681200), '0.4'), ('310', FROM_UNIXTIME(1225684800), '0.6'), ('310', FROM_UNIXTIME(1225688400), '0.6'), ('310', FROM_UNIXTIME(1225692000), '0.6'), ('310', FROM_UNIXTIME(1225695600), '0.4'), ('310', FROM_UNIXTIME(1225699200), '0.2'), ('310', FROM_UNIXTIME(1225713600), '0.4'), ('310', FROM_UNIXTIME(1225717200), '0.2'), ('310', FROM_UNIXTIME(1225724400), '0'), ('311', FROM_UNIXTIME(1225666800), '0.9'), ('311', FROM_UNIXTIME(1225674000), '0.6'), ('311', FROM_UNIXTIME(1225681200), '0.6'), ('311', FROM_UNIXTIME(1225684800), '0.9'), ('311', FROM_UNIXTIME(1225688400), '0.9'), ('311', FROM_UNIXTIME(1225692000), '0.9'), ('311', FROM_UNIXTIME(1225695600), '0.6'), ('311', FROM_UNIXTIME(1225699200), '0.3'), ('311', FROM_UNIXTIME(1225713600), '0.6'), ('311', FROM_UNIXTIME(1225717200), '0.3'), ('311', FROM_UNIXTIME(1225724400), '0'), ('312', FROM_UNIXTIME(1225666800), '1.5'), ('312', FROM_UNIXTIME(1225674000), '1'), ('312', FROM_UNIXTIME(1225681200), '1'), ('312', FROM_UNIXTIME(1225684800), '1.5'), ('312', FROM_UNIXTIME(1225688400), '1.5'), ('312', FROM_UNIXTIME(1225692000), '1.5'), ('312', FROM_UNIXTIME(1225695600), '1'), ('312', FROM_UNIXTIME(1225699200), '0.5'), ('312', FROM_UNIXTIME(1225713600), '1'), ('312', FROM_UNIXTIME(1225717200), '0.5'), ('312', FROM_UNIXTIME(1225724400), '0'), ('320', FROM_UNIXTIME(1225666800), '0'), ('320', FROM_UNIXTIME(1225670400), '0.4'), ('320', FROM_UNIXTIME(1225677600), '0'), ('320', FROM_UNIXTIME(1225688400), '0.4'), ('320', FROM_UNIXTIME(1225695600), '0.2'), ('320', FROM_UNIXTIME(1225706400), '0.4'), ('320', FROM_UNIXTIME(1225710000), '0.2'), ('320', FROM_UNIXTIME(1225720800), '0'), ('321', FROM_UNIXTIME(1225666800), '0'), ('321', FROM_UNIXTIME(1225670400), '0.6'), ('321', FROM_UNIXTIME(1225677600), '0'), ('321', FROM_UNIXTIME(1225688400), '0.6'), ('321', FROM_UNIXTIME(1225695600), '0.3'), ('321', FROM_UNIXTIME(1225706400), '0.6'), ('321', FROM_UNIXTIME(1225710000), '0.3'), ('321', FROM_UNIXTIME(1225720800), '0'), ('322', FROM_UNIXTIME(1225666800), '0'), ('322', FROM_UNIXTIME(1225670400), '1'), ('322', FROM_UNIXTIME(1225677600), '0'), ('322', FROM_UNIXTIME(1225688400), '1'), ('322', FROM_UNIXTIME(1225695600), '0.5'), ('322', FROM_UNIXTIME(1225706400), '1'), ('322', FROM_UNIXTIME(1225710000), '0.5'), ('322', FROM_UNIXTIME(1225720800), '0'), ('410', FROM_UNIXTIME(1225666800), '0'), ('410', FROM_UNIXTIME(1225688400), '0.4'), ('410', FROM_UNIXTIME(1225695600), '0.2'), ('410', FROM_UNIXTIME(1225699200), '0'), ('411', FROM_UNIXTIME(1225666800), '0'), ('411', FROM_UNIXTIME(1225688400), '0.6'), ('411', FROM_UNIXTIME(1225695600), '0.3'), ('411', FROM_UNIXTIME(1225699200), '0'), ('412', FROM_UNIXTIME(1225666800), '0'), ('412', FROM_UNIXTIME(1225688400), '1'), ('412', FROM_UNIXTIME(1225695600), '0.5'), ('412', FROM_UNIXTIME(1225699200), '0'), ('420', FROM_UNIXTIME(1225666800), '0'), ('420', FROM_UNIXTIME(1225668594), '0.2'), ('420', FROM_UNIXTIME(1225675794), '0'), ('420', FROM_UNIXTIME(1225681200), '0.2'), ('420', FROM_UNIXTIME(1225684800), '0.4'), ('420', FROM_UNIXTIME(1225688400), '0.2'), ('420', FROM_UNIXTIME(1225692000), '0'), ('421', FROM_UNIXTIME(1225666800), '0'), ('421', FROM_UNIXTIME(1225668594), '0.3'), ('421', FROM_UNIXTIME(1225675794), '0'), ('421', FROM_UNIXTIME(1225681200), '0.3'), ('421', FROM_UNIXTIME(1225684800), '0.6'), ('421', FROM_UNIXTIME(1225688400), '0.3'), ('421', FROM_UNIXTIME(1225692000), '0'), ('422', FROM_UNIXTIME(1225666800), '0'), ('422', FROM_UNIXTIME(1225668594), '0.5'), ('422', FROM_UNIXTIME(1225675794), '0'), ('422', FROM_UNIXTIME(1225681200), '0.5'), ('422', FROM_UNIXTIME(1225684800), '1'), ('422', FROM_UNIXTIME(1225688400), '0.5'), ('422', FROM_UNIXTIME(1225692000), '0'), ('430', FROM_UNIXTIME(1225666800), '0'), ('510', FROM_UNIXTIME(1225666800), '0'), ('510', FROM_UNIXTIME(1225670322), '0.2'), ('510', FROM_UNIXTIME(1225673986), '0.4'), ('510', FROM_UNIXTIME(1225681186), '0.2'), ('510', FROM_UNIXTIME(1225684722), '0'), ('510', FROM_UNIXTIME(1225691986), '0.2'), ('510', FROM_UNIXTIME(1225695570), '0.4'), ('510', FROM_UNIXTIME(1225709906), '0.6'), ('510', FROM_UNIXTIME(1225713586), '0.4'), ('510', FROM_UNIXTIME(1225720770), '0.2'), ('510', FROM_UNIXTIME(1225724306), '0'), ('511', FROM_UNIXTIME(1225666800), '0'), ('511', FROM_UNIXTIME(1225670322), '0.3'), ('511', FROM_UNIXTIME(1225673986), '0.6'), ('511', FROM_UNIXTIME(1225681186), '0.3'), ('511', FROM_UNIXTIME(1225684722), '0'), ('511', FROM_UNIXTIME(1225691986), '0.3'), ('511', FROM_UNIXTIME(1225695570), '0.6'), ('511', FROM_UNIXTIME(1225709906), '0.9'), ('511', FROM_UNIXTIME(1225713586), '0.6'), ('511', FROM_UNIXTIME(1225720770), '0.3'), ('511', FROM_UNIXTIME(1225724306), '0'), ('512', FROM_UNIXTIME(1225666800), '0'), ('512', FROM_UNIXTIME(1225670322), '0.5'), ('512', FROM_UNIXTIME(1225673986), '1'), ('512', FROM_UNIXTIME(1225681186), '0.5'), ('512', FROM_UNIXTIME(1225684722), '0'), ('512', FROM_UNIXTIME(1225691986), '0.5'), ('512', FROM_UNIXTIME(1225695570), '1'), ('512', FROM_UNIXTIME(1225709906), '1.5'), ('512', FROM_UNIXTIME(1225713586), '1'), ('512', FROM_UNIXTIME(1225720770), '0.5'), ('512', FROM_UNIXTIME(1225724306), '0'), ('520', FROM_UNIXTIME(1225666800), '0'), ('520', FROM_UNIXTIME(1225666802), '0.2'), ('520', FROM_UNIXTIME(1225695602), '0'), ('520', FROM_UNIXTIME(1225717042), '0.2'), ('520', FROM_UNIXTIME(1225727842), '0'), ('521', FROM_UNIXTIME(1225666800), '0'), ('521', FROM_UNIXTIME(1225666802), '0.3'), ('521', FROM_UNIXTIME(1225695602), '0'), ('521', FROM_UNIXTIME(1225717042), '0.3'), ('521', FROM_UNIXTIME(1225727842), '0'), ('522', FROM_UNIXTIME(1225666800), '0'), ('522', FROM_UNIXTIME(1225666802), '0.5'), ('522', FROM_UNIXTIME(1225695602), '0'), ('522', FROM_UNIXTIME(1225717042), '0.5'), ('522', FROM_UNIXTIME(1225727842), '0'), ('530', FROM_UNIXTIME(1225666800), '0'); INSERT INTO `gssim_results`.`unit_energy_timeline` (`fk_unit_id`, `timestamp`, `usage`) VALUES ('210', FROM_UNIXTIME(1225666800), '1.4'), ('210', FROM_UNIXTIME(1225674000), '0.7'), ('210', FROM_UNIXTIME(1225681200), '0'), ('210', FROM_UNIXTIME(1225688400), '1.4'), ('210', FROM_UNIXTIME(1225692000), '2.1'), ('210', FROM_UNIXTIME(1225699200), '1.4'), ('210', FROM_UNIXTIME(1225706400), '2.1'), ('210', FROM_UNIXTIME(1225710000), '1.4'), ('210', FROM_UNIXTIME(1225713600), '2.1'), ('210', FROM_UNIXTIME(1225717200), '1.4'), ('210', FROM_UNIXTIME(1225720800), '0.7'), ('210', FROM_UNIXTIME(1225724400), '0'), ('211', FROM_UNIXTIME(1225666800), '0.2'), ('211', FROM_UNIXTIME(1225674000), '0.1'), ('211', FROM_UNIXTIME(1225681200), '0'), ('211', FROM_UNIXTIME(1225688400), '0.2'), ('211', FROM_UNIXTIME(1225692000), '0.3'), ('211', FROM_UNIXTIME(1225699200), '0.2'), ('211', FROM_UNIXTIME(1225706400), '0.3'), ('211', FROM_UNIXTIME(1225710000), '0.2'), ('211', FROM_UNIXTIME(1225713600), '0.3'), ('211', FROM_UNIXTIME(1225717200), '0.2'), ('211', FROM_UNIXTIME(1225720800), '0.1'), ('211', FROM_UNIXTIME(1225724400), '0'), ('220', FROM_UNIXTIME(1225666800), '0.7'), ('220', FROM_UNIXTIME(1225670400), '2.1'), ('220', FROM_UNIXTIME(1225677600), '0.7'), ('220', FROM_UNIXTIME(1225681200), '1.4'), ('220', FROM_UNIXTIME(1225684800), '2.1'), ('220', FROM_UNIXTIME(1225688400), '2.1'), ('220', FROM_UNIXTIME(1225692000), '1.4'), ('220', FROM_UNIXTIME(1225695600), '0'), ('221', FROM_UNIXTIME(1225666800), '0.1'), ('221', FROM_UNIXTIME(1225670400), '0.3'), ('221', FROM_UNIXTIME(1225677600), '0.1'), ('221', FROM_UNIXTIME(1225681200), '0.2'), ('221', FROM_UNIXTIME(1225684800), '0.3'), ('221', FROM_UNIXTIME(1225688400), '0.3'), ('221', FROM_UNIXTIME(1225692000), '0.2'), ('221', FROM_UNIXTIME(1225695600), '0'), ('212', FROM_UNIXTIME(1225666800), '0.4'), ('212', FROM_UNIXTIME(1225674000), '0.2'), ('212', FROM_UNIXTIME(1225681200), '0'), ('212', FROM_UNIXTIME(1225688400), '0.4'), ('212', FROM_UNIXTIME(1225692000), '0.6'), ('212', FROM_UNIXTIME(1225699200), '0.4'), ('212', FROM_UNIXTIME(1225706400), '0.6'), ('212', FROM_UNIXTIME(1225710000), '0.4'), ('212', FROM_UNIXTIME(1225713600), '0.6'), ('212', FROM_UNIXTIME(1225717200), '0.4'), ('212', FROM_UNIXTIME(1225720800), '0.2'), ('212', FROM_UNIXTIME(1225724400), '0'), ('222', FROM_UNIXTIME(1225666800), '0.2'), ('222', FROM_UNIXTIME(1225670400), '0.6'), ('222', FROM_UNIXTIME(1225677600), '0.2'), ('222', FROM_UNIXTIME(1225681200), '0.4'), ('222', FROM_UNIXTIME(1225684800), '0.6'), ('222', FROM_UNIXTIME(1225688400), '0.6'), ('222', FROM_UNIXTIME(1225692000), '0.4'), ('222', FROM_UNIXTIME(1225695600), '0'), ('310', FROM_UNIXTIME(1225666800), '2.1'), ('310', FROM_UNIXTIME(1225674000), '1.4'), ('310', FROM_UNIXTIME(1225681200), '1.4'), ('310', FROM_UNIXTIME(1225684800), '2.1'), ('310', FROM_UNIXTIME(1225688400), '2.1'), ('310', FROM_UNIXTIME(1225692000), '2.1'), ('310', FROM_UNIXTIME(1225695600), '1.4'), ('310', FROM_UNIXTIME(1225699200), '0.7'), ('310', FROM_UNIXTIME(1225713600), '1.4'), ('310', FROM_UNIXTIME(1225717200), '0.7'), ('310', FROM_UNIXTIME(1225724400), '0'), ('311', FROM_UNIXTIME(1225666800), '0.3'), ('311', FROM_UNIXTIME(1225674000), '0.2'), ('311', FROM_UNIXTIME(1225681200), '0.2'), ('311', FROM_UNIXTIME(1225684800), '0.3'), ('311', FROM_UNIXTIME(1225688400), '0.3'), ('311', FROM_UNIXTIME(1225692000), '0.3'), ('311', FROM_UNIXTIME(1225695600), '0.2'), ('311', FROM_UNIXTIME(1225699200), '0.1'), ('311', FROM_UNIXTIME(1225713600), '0.2'), ('311', FROM_UNIXTIME(1225717200), '0.1'), ('311', FROM_UNIXTIME(1225724400), '0'), ('312', FROM_UNIXTIME(1225666800), '0.6'), ('312', FROM_UNIXTIME(1225674000), '0.4'), ('312', FROM_UNIXTIME(1225681200), '0.4'), ('312', FROM_UNIXTIME(1225684800), '0.6'), ('312', FROM_UNIXTIME(1225688400), '0.6'), ('312', FROM_UNIXTIME(1225692000), '0.6'), ('312', FROM_UNIXTIME(1225695600), '0.4'), ('312', FROM_UNIXTIME(1225699200), '0.2'), ('312', FROM_UNIXTIME(1225713600), '0.4'), ('312', FROM_UNIXTIME(1225717200), '0.2'), ('312', FROM_UNIXTIME(1225724400), '0'), ('320', FROM_UNIXTIME(1225670400), '1.4'), ('320', FROM_UNIXTIME(1225677600), '0'), ('320', FROM_UNIXTIME(1225688400), '1.4'), ('320', FROM_UNIXTIME(1225695600), '0.7'), ('320', FROM_UNIXTIME(1225706400), '1.4'), ('320', FROM_UNIXTIME(1225710000), '0.7'), ('320', FROM_UNIXTIME(1225720800), '0'), ('321', FROM_UNIXTIME(1225670400), '0.2'), ('321', FROM_UNIXTIME(1225677600), '0'), ('321', FROM_UNIXTIME(1225688400), '0.2'), ('321', FROM_UNIXTIME(1225695600), '0.1'), ('321', FROM_UNIXTIME(1225706400), '0.2'), ('321', FROM_UNIXTIME(1225710000), '0.1'), ('321', FROM_UNIXTIME(1225720800), '0'), ('322', FROM_UNIXTIME(1225670400), '0.4'), ('322', FROM_UNIXTIME(1225677600), '0'), ('322', FROM_UNIXTIME(1225688400), '0.4'), ('322', FROM_UNIXTIME(1225695600), '0.2'), ('322', FROM_UNIXTIME(1225706400), '0.4'), ('322', FROM_UNIXTIME(1225710000), '0.2'), ('322', FROM_UNIXTIME(1225720800), '0'), ('410', FROM_UNIXTIME(1225688400), '1.4'), ('410', FROM_UNIXTIME(1225695600), '0.7'), ('410', FROM_UNIXTIME(1225699200), '0'), ('411', FROM_UNIXTIME(1225688400), '0.2'), ('411', FROM_UNIXTIME(1225695600), '0.1'), ('411', FROM_UNIXTIME(1225699200), '0'), ('412', FROM_UNIXTIME(1225688400), '0.4'), ('412', FROM_UNIXTIME(1225695600), '0.2'), ('412', FROM_UNIXTIME(1225699200), '0'), ('420', FROM_UNIXTIME(1225668594), '0.7'), ('420', FROM_UNIXTIME(1225675794), '0'), ('420', FROM_UNIXTIME(1225681200), '0'), ('420', FROM_UNIXTIME(1225684800), '1.4'), ('420', FROM_UNIXTIME(1225688400), '0.7'), ('420', FROM_UNIXTIME(1225692000), '0'), ('421', FROM_UNIXTIME(1225668594), '0.1'), ('421', FROM_UNIXTIME(1225675794), '0'), ('421', FROM_UNIXTIME(1225681200), '0'), ('421', FROM_UNIXTIME(1225684800), '0.2'), ('421', FROM_UNIXTIME(1225688400), '0.1'), ('421', FROM_UNIXTIME(1225692000), '0'), ('422', FROM_UNIXTIME(1225668594), '0.2'), ('422', FROM_UNIXTIME(1225675794), '0'), ('422', FROM_UNIXTIME(1225681200), '0'), ('422', FROM_UNIXTIME(1225684800), '0.4'), ('422', FROM_UNIXTIME(1225688400), '0.2'), ('422', FROM_UNIXTIME(1225692000), '0'), ('510', FROM_UNIXTIME(1225670322), '0.7'), ('510', FROM_UNIXTIME(1225673986), '1.4'), ('510', FROM_UNIXTIME(1225681186), '0.7'), ('510', FROM_UNIXTIME(1225684722), '0'), ('510', FROM_UNIXTIME(1225691986), '0.7'), ('510', FROM_UNIXTIME(1225695570), '1.4'), ('510', FROM_UNIXTIME(1225709906), '2.1'), ('510', FROM_UNIXTIME(1225713586), '1.4'), ('510', FROM_UNIXTIME(1225720770), '0.7'), ('510', FROM_UNIXTIME(1225724306), '0'), ('511', FROM_UNIXTIME(1225670322), '0.1'), ('511', FROM_UNIXTIME(1225673986), '0.2'), ('511', FROM_UNIXTIME(1225681186), '0.1'), ('511', FROM_UNIXTIME(1225684722), '0'), ('511', FROM_UNIXTIME(1225691986), '0.1'), ('511', FROM_UNIXTIME(1225695570), '0.2'), ('511', FROM_UNIXTIME(1225709906), '0.3'), ('511', FROM_UNIXTIME(1225713586), '0.2'), ('511', FROM_UNIXTIME(1225720770), '0.1'), ('511', FROM_UNIXTIME(1225724306), '0'), ('512', FROM_UNIXTIME(1225670322), '0.2'), ('512', FROM_UNIXTIME(1225673986), '0.4'), ('512', FROM_UNIXTIME(1225681186), '0.2'), ('512', FROM_UNIXTIME(1225684722), '0'), ('512', FROM_UNIXTIME(1225691986), '0.2'), ('512', FROM_UNIXTIME(1225695570), '0.4'), ('512', FROM_UNIXTIME(1225709906), '0.6'), ('512', FROM_UNIXTIME(1225713586), '0.4'), ('512', FROM_UNIXTIME(1225720770), '0.2'), ('512', FROM_UNIXTIME(1225724306), '0'), ('520', FROM_UNIXTIME(1225666802), '0.7'), ('520', FROM_UNIXTIME(1225695602), '0'), ('520', FROM_UNIXTIME(1225717042), '0.7'), ('520', FROM_UNIXTIME(1225727842), '0'), ('521', FROM_UNIXTIME(1225666802), '0.1'), ('521', FROM_UNIXTIME(1225695602), '0'), ('521', FROM_UNIXTIME(1225717042), '0.1'), ('521', FROM_UNIXTIME(1225727842), '0'), ('522', FROM_UNIXTIME(1225666802), '0.2'), ('522', FROM_UNIXTIME(1225695602), '0'), ('522', FROM_UNIXTIME(1225717042), '0.2'), ('522', FROM_UNIXTIME(1225727842), '0'); INSERT INTO `gssim_results`.`allocation` (`PK`, `task_id`, `unit_id`, `begin`, `end`) VALUES ('0', '2000', '210', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225673000)), ('1', '2100', '221', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)), ('2', '21000', '211', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225680200)), ('3', '21100', '220', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225694600)), ('4', '21200', '222', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)), ('5', '21300', '211', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225709000)), ('6', '21400', '212', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225716200)), ('7', '21500', '210', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225719800)), ('8', '21600', '211', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225723400)), ('9', '2200', '221', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)), ('10', '2300', '222', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)), ('11', '2400', '221', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)), ('12', '2500', '210', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)), ('13', '3000', '310', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225673000)), ('14', '3100', '320', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)), ('15', '31000', '311', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225680200)), ('16', '31100', '312', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225694600)), ('17', '31200', '321', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)), ('18', '31300', '321', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225709000)), ('19', '31400', '311', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225716200)), ('20', '31500', '320', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225719800)), ('21', '31600', '310', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225723400)), ('22', '3200', '310', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)), ('23', '3300', '311', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)), ('24', '3400', '320', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)), ('25', '3500', '310', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)), ('26', '4100', '420', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225674800)), ('27', '4300', '420', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)), ('28', '4400', '421', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)), ('29', '4500', '411', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)), ('30', '4600', '410', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)), ('31', '5000', '510', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225683800)), ('32', '5100', '520', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225698200)), ('33', '5200', '511', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225680200)), ('34', '5300', '510', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225712600)), ('35', '5400', '511', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225719800)), ('36', '5500', '512', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225723400)), ('37', '5600', '520', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225727000)); INSERT INTO `gssim_results`.`allocation_details` (`fk_allocation_id`, `name`, `value`) VALUES ('0', 'allocation_detail', '0'), ('1', 'allocation_detail', '1'), ('2', 'allocation_detail', '2'), ('3', 'allocation_detail', '3'), ('4', 'allocation_detail', '4'), ('5', 'allocation_detail', '5'), ('6', 'allocation_detail', '6'), ('7', 'allocation_detail', '7'), ('8', 'allocation_detail', '8'), ('9', 'allocation_detail', '9'), ('10', 'allocation_detail', '10'), ('11', 'allocation_detail', '11'), ('12', 'allocation_detail', '12'), ('13', 'allocation_detail', '13'), ('14', 'allocation_detail', '14'), ('15', 'allocation_detail', '15'), ('16', 'allocation_detail', '16'), ('17', 'allocation_detail', '17'), ('18', 'allocation_detail', '18'), ('19', 'allocation_detail', '19'), ('20', 'allocation_detail', '20'), ('21', 'allocation_detail', '21'), ('22', 'allocation_detail', '22'), ('23', 'allocation_detail', '23'), ('24', 'allocation_detail', '24'), ('25', 'allocation_detail', '25'), ('26', 'allocation_detail', '26'), ('27', 'allocation_detail', '27'), ('28', 'allocation_detail', '28'), ('29', 'allocation_detail', '29'), ('30', 'allocation_detail', '30'), ('31', 'allocation_detail', '31'), ('32', 'allocation_detail', '32'), ('33', 'allocation_detail', '33'), ('34', 'allocation_detail', '34'), ('35', 'allocation_detail', '35'), ('36', 'allocation_detail', '36'), ('37', 'allocation_detail', '37'); INSERT INTO `gssim_results`.`reservation` (`PK`, `task_id`, `unit_id`, `begin`, `end`) VALUES ('0', '2000', '210', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000)), ('1', '2100', '221', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)), ('2', '21000', '211', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200)), ('3', '21100', '220', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600)), ('4', '21200', '222', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)), ('5', '21300', '211', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000)), ('6', '21400', '212', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200)), ('7', '21500', '210', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800)), ('8', '21600', '211', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400)), ('9', '2200', '221', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)), ('10', '2300', '222', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)), ('11', '2400', '221', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)), ('12', '2500', '210', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)), ('13', '3000', '310', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000)), ('14', '3100', '320', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)), ('15', '31000', '311', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200)), ('16', '31100', '312', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600)), ('17', '31200', '321', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)), ('18', '31300', '321', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000)), ('19', '31400', '311', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200)), ('20', '31500', '320', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800)), ('21', '31600', '310', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400)), ('22', '3200', '310', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)), ('23', '3300', '311', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)), ('24', '3400', '320', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)), ('25', '3500', '310', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)), ('26', '4100', '420', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225675800)), ('27', '4300', '420', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)), ('28', '4400', '421', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)), ('29', '4500', '411', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)), ('30', '4600', '410', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)), ('31', '5000', '510', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225684800)), ('32', '5100', '520', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225699200)), ('33', '5200', '511', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225681200)), ('34', '5300', '510', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225713600)), ('35', '5400', '511', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225720800)), ('36', '5500', '512', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225724400)), ('37', '5600', '520', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225728000)); INSERT INTO `gssim_results`.`reservation_details` (`fk_reservation_id`, `name`, `value`) VALUES ('0', 'reservation_detail', '0'), ('1', 'reservation_detail', '1'), ('2', 'reservation_detail', '2'), ('3', 'reservation_detail', '3'), ('4', 'reservation_detail', '4'), ('5', 'reservation_detail', '5'), ('6', 'reservation_detail', '6'), ('7', 'reservation_detail', '7'), ('8', 'reservation_detail', '8'), ('9', 'reservation_detail', '9'), ('10', 'reservation_detail', '10'), ('11', 'reservation_detail', '11'), ('12', 'reservation_detail', '12'), ('13', 'reservation_detail', '13'), ('14', 'reservation_detail', '14'), ('15', 'reservation_detail', '15'), ('16', 'reservation_detail', '16'), ('17', 'reservation_detail', '17'), ('18', 'reservation_detail', '18'), ('19', 'reservation_detail', '19'), ('20', 'reservation_detail', '20'), ('21', 'reservation_detail', '21'), ('22', 'reservation_detail', '22'), ('23', 'reservation_detail', '23'), ('24', 'reservation_detail', '24'), ('25', 'reservation_detail', '25'), ('26', 'reservation_detail', '26'), ('27', 'reservation_detail', '27'), ('28', 'reservation_detail', '28'), ('29', 'reservation_detail', '29'), ('30', 'reservation_detail', '30'), ('31', 'reservation_detail', '31'), ('32', 'reservation_detail', '32'), ('33', 'reservation_detail', '33'), ('34', 'reservation_detail', '34'), ('35', 'reservation_detail', '35'), ('36', 'reservation_detail', '36'), ('37', 'reservation_detail', '37'); INSERT INTO `plugin` (`id`, `name`, `is_global`, `description`, `input`) VALUES (1, 'ARGraham', 1, 'This Plugin schedules jobs using the earliest due date (EDD) policy to sort them in a queue and then applies the greedy list scheduling Graham algorithm. Jobs $J_i$ from the queue are assigned to one of clusters $\\mathcal{M}$ using a greedy list-scheduling algorithm based on ~\\cite{graham1969bmt,mounie07}. To this end, the Grid scheduler queries each organization $O_k$ about a list of free slots $\\psi_{ki} \\in \\Psi_k, \\psi_{ki}=(t'',t'''',m_{ki}) , i=1..|\\Psi|$. Parameters $t''$ and $t''''$ denote start and time of a slot, respectively. $m_{ki}$ is a number of processors available within the slot $i$ at organization $O_k$. Slots are time periods within which a number of available processors is constant. The Grid scheduler sorts collected slots by increasing start time. The schedule is constructed by assigning jobs in the Grid scheduler''s queue to processors in given slots in a greedy manner. For each slot $\\psi_{kI}$ (starting from the earliest one) the scheduler chooses from its queue the first job $J_j$ requiring no more than $m_{ki}$ processors in all subsequent slots $i \\geq I$ such as $t''''_{ki} \\geq t''_{kI} + p_j$. If such a job was find the scheduler schedules it to be started at $t''_{kI}$, and removes it from the queue. If there is no such a job, the scheduler apply the same procedure to the next free slot whose number of available processors is larger than the current one.', NULL), (2, 'GridARAllSlots', 1, NULL, NULL), (3, 'GridARFirstFit', 1, NULL, NULL), (4, 'GridARNRDijkstra', 1, NULL, NULL), (5, 'GridARNRSpecificPath', 1, NULL, NULL), (6, 'GridRoundRobinPlugin', 1, NULL, NULL), (7, 'ARAllSlots', 0, 'This implementation of getOffers() method returns detail state of the resource in requested time. Imagine the result as a gantt diagram of resource usage between start and end time. Grid scheduling plugin must analyze this result, decide if there are enough resource units and create reservation of this units.', NULL), (8, 'ARFirstFit', 0, NULL, NULL), (9, 'FCFSLocalPlugin', 0, NULL, NULL); INSERT INTO `plugin_compatibility` (`parent_id`, `child_id`) VALUES (2, 7), (3, 8), (4, 8), (5, 8), (6, 9);