| [104] | 1 | INSERT INTO `gssim_results`.`user` (`id`, `dn`) VALUES |
|---|
| 2 | (1, 'irondn'), |
|---|
| 3 | (2, 'irondn2'); |
|---|
| 4 | |
|---|
| 5 | INSERT INTO `gssim_results`.`configuration` (`id`) VALUES |
|---|
| 6 | (2), |
|---|
| 7 | (3); |
|---|
| 8 | |
|---|
| 9 | INSERT INTO `gssim_results`.`blob_property` (`config_id`, `name`, `value`) VALUES |
|---|
| 10 | (2, 'Network topology', 0x31320a526f757465725f50534e430a526f757465725f4345534e45540a526f757465725f44464e0a526f757465725f474152520a526f757465725f4b54480a526f757465725f4845414e65740a526f757465725f5357495443480a526f757465725f48554e4741524e45540a526f757465725f526564495249530a526f757465725f49324341540a526f757465725f4643434e0a526f757465725f47524e45540a31380a526f757465725f4b54480909526f757465725f4845414e65740909310933303009313530303030300a526f757465725f4b54480909526f757465725f50534e430909310933303009313530303030300a526f757465725f50534e430909526f757465725f44464e0909310933303009313530303030300a526f757465725f50534e430909526f757465725f474152520909310933303009313530303030300a526f757465725f50534e430909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f44464e0909526f757465725f474152520909310933303009313530303030300a526f757465725f44464e0909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f44464e0909526f757465725f5357495443480909310933303009313530303030300a526f757465725f474152520909526f757465725f4345534e45540909310933303009313530303030300a526f757465725f474152520909526f757465725f526564495249530909310933303009313530303030300a526f757465725f4345534e45540909526f757465725f47524e45540909310933303009313530303030300a526f757465725f47524e45540909526f757465725f48554e4741524e45540909310933303009313530303030300a526f757465725f47524e45540909526f757465725f526564495249530909310933303009313530303030300a526f757465725f48554e4741524e45540909526f757465725f5357495443480909310933303009313530303030300a526f757465725f526564495249530909526f757465725f49324341540909310933303009313530303030300a526f757465725f526564495249530909526f757465725f4643434e0909310933303009313530303030300a526f757465725f526564495249530909526f757465725f4845414e65740909310933303009313530303030300a526f757465725f5357495443480909526f757465725f4845414e65740909310933303009313530303030300a32300a50534e432d766e536572766572310909526f757465725f50534e430909310933303009313530303030300a50534e432d766e536572766572320909526f757465725f50534e430909310933303009313530303030300a50534e432d726f757465720909526f757465725f50534e430909310933303009313530303030300a4345534e45542d766e536572766572310909526f757465725f4345534e45540909310933303009313530303030300a4345534e45542d766e536572766572320909526f757465725f4345534e45540909310933303009313530303030300a4345534e45542d726f757465720909526f757465725f4345534e45540909310933303009313530303030300a44464e2d766e536572766572310909526f757465725f44464e0909310933303009313530303030300a44464e2d766e536572766572320909526f757465725f44464e0909310933303009313530303030300a44464e2d726f757465720909526f757465725f44464e0909310933303009313530303030300a474152522d766e536572766572310909526f757465725f474152520909310933303009313530303030300a474152522d766e536572766572320909526f757465725f474152520909310933303009313530303030300a474152522d726f757465720909526f757465725f474152520909310933303009313530303030300a4b54482d766e5365727665720909526f757465725f4b54480909310933303009313530303030300a4845414e65742d766e5365727665720909526f757465725f4845414e65740909310933303009313530303030300a5357495443482d766e5365727665720909526f757465725f5357495443480909310933303009313530303030300a48554e4741524e45542d766e5365727665720909526f757465725f48554e4741524e45540909310933303009313530303030300a526564495249532d766e5365727665720909526f757465725f526564495249530909310933303009313530303030300a49324341542d766e5365727665720909526f757465725f49324341540909310933303009313530303030300a4643434e2d766e5365727665720909526f757465725f4643434e0909310933303009313530303030300a47524e45542d766e5365727665720909526f757465725f47524e45540909310933303009313530303030300a310a42726f6b6572496e74657266616365456e7469747920526f757465725f50534e432031202020202033303020202020313530303030300a), |
|---|
| 11 | (3, 'Network topology', 0x2320746f74616c206e756d626572206f6620726f75746572730a32350a23206561636820726f75746572206e616d650a506f7a6e616e0a4764616e736b0a576172737a6177610a57726f636c61770a4b72616b6f770a4b6f737a616c696e0a537a637a6563696e0a476f727a6f77576c6b700a427964676f737a637a0a546f72756e0a4f6c737a74796e0a4269616c7973746f6b0a5a69656c6f6e61476f72610a4c6f647a0a5261646f6d0a50756c6177790a4c75626c696e0a4f706f6c650a437a6573746f63686f77610a476c69776963650a4b69656c63650a527a65737a6f770a4269656c736b6f4269616c610a4b61746f776963650a5a616d6f73630a0a2320746f74616c206e756d626572206f6620636f6e6e656374696f6e73206265747765656e20726f75746572730a33300a2320636f6e6e656374696f6e73206265747765656e20726f75746572730a4764616e736b204b6f737a616c696e2032302033303020313530303030300a4764616e736b204f6c737a74796e2032302033303020313530303030300a4f706f6c6520476c69776963652032302033303020313530303030300a4b6f737a616c696e20537a637a6563696e2032302033303020313530303030300a537a637a6563696e20476f727a6f77576c6b702032302033303020313530303030300a427964676f737a637a20546f72756e2032302033303020313530303030300a5261646f6d204b69656c63652032302033303020313530303030300a4269656c736b6f4269616c61204b72616b6f772032302033303020313530303030300a506f7a6e616e20576172737a6177612032302033303020313530303030300a4f6c737a74796e204269616c7973746f6b20312036303020313530303030300a4b69656c6365204b72616b6f772032302033303020313530303030300a476c6977696365204b61746f776963652032302033303020313530303030300a57726f636c6177204f706f6c652032302033303020313530303030300a437a6573746f63686f7761204c6f647a2032302033303020313530303030300a527a65737a6f77204b72616b6f7720312036303020313530303030300a4c75626c696e205a616d6f73632032302033303020313530303030300a437a6573746f63686f7761204b61746f776963652032302033303020313530303030300a506f7a6e616e205a69656c6f6e61476f72612032302033303020313530303030300a576172737a617761204269616c7973746f6b2032302033303020313530303030300a546f72756e204764616e736b2032302033303020313530303030300a427964676f737a637a20506f7a6e616e2032302033303020313530303030300a506f7a6e616e20476f727a6f77576c6b702032302033303020313530303030300a4c6f647a20576172737a6177612032302033303020313530303030300a5261646f6d20576172737a6177612032302033303020313530303030300a50756c617779205261646f6d2032302033303020313530303030300a50756c617779204c75626c696e2032302033303020313530303030300a527a65737a6f77205a616d6f73632032302033303020313530303030300a4c6f647a20506f7a6e616e2032302033303020313530303030300a5a69656c6f6e61476f72612057726f636c61772032302033303020313530303030300a4269656c736b6f4269616c6120476c69776963652032302033303020313530303030300a0a2320746f74616c206e756d626572206f66207265736f75726365730a350a2320636f6e6e656374696f6e73206265747765656e207265736f7572636520616e6420726f757465720a5043535320506f7a6e616e2032302031303020313530303030300a574353532057726f636c61772032302031303020313530303030300a437966726f6e6574204b72616b6f772032302031303020313530303030300a43495441534b204764616e736b2032302031303020313530303030300a49434d20576172737a6177612032302031303020313530303030300a0a2320746f74616c206e756d626572206f662075736572730a310a2320636f6e6e656374696f6e206265747765656e207573657220616e6420726f757465720a42726f6b6572496e74657266616365456e74697479205a69656c6f6e61476f72612032302032303020313530303030300a); |
|---|
| 12 | |
|---|
| 13 | INSERT INTO `gssim_results`.`text_property` (`config_id`, `name`, `value`) VALUES |
|---|
| 14 | (2, 'Grid scheduling', 'GridschedulingFCFSSR'), |
|---|
| 15 | (2, 'Local grid scheduling', 'FCFSAllocPolicy'), |
|---|
| 16 | (2, 'Execution time estimation', 'ExecutionTimeEstimationPluginImpl'), |
|---|
| 17 | (3, 'Grid scheduling', 'GridschedulingARFCFS'), |
|---|
| 18 | (3, 'Local grid scheduling', 'LocalGridPluginAR'), |
|---|
| 19 | (3, 'Execution time estimation', 'ExecutionTimeEstimationPluginImpl'); |
|---|
| 20 | |
|---|
| 21 | INSERT INTO `gssim_results`.`experiment` (`PK`, `user_id`, `config_id`, `commission_date`, `name`, `description`, `status`, `metaexp_id`) VALUES |
|---|
| 22 | (2, 1, 2, NULL, 'exp1', 'exp1 desc', 'FINISHED', NULL), |
|---|
| 23 | (3, 2, 3, NULL, 'exp1', 'exp1 desc', 'RUNNING', NULL), |
|---|
| 24 | (4, 1, 2, NULL, 'exp1', 'exp1 desc', 'FAILED', NULL), |
|---|
| 25 | (5, 2, 3, NULL, 'exp1', 'exp1 desc', 'FINISHED', NULL); |
|---|
| 26 | |
|---|
| 27 | |
|---|
| 28 | INSERT INTO `gssim_results`.`experiment_stats` (`id`, `name`, `value`) VALUES |
|---|
| 29 | ('2', 'Delayed tasks', '0'), |
|---|
| 30 | ('2', 'Failed requests (tasks)', '0'), |
|---|
| 31 | ('2', 'Makespan', '57600'), |
|---|
| 32 | ('2', 'Resources queue length', '0.531'), |
|---|
| 33 | ('2', 'Resources total load', '0.49'), |
|---|
| 34 | ('2', 'Resources reservation load', '0.49'), |
|---|
| 35 | ('2', 'Energy usage', '1.312'), |
|---|
| 36 | ('2', 'Task completion time', '29630.769'), |
|---|
| 37 | ('2', 'Task execution time', '13015.385'), |
|---|
| 38 | ('2', 'Task start time', '6092.308'), |
|---|
| 39 | ('2', 'Task flow time', '13015.385'), |
|---|
| 40 | ('2', 'Task waiting time', '6092.308'), |
|---|
| 41 | ('2', 'Task lateness', '0'), |
|---|
| 42 | ('2', 'Task tardiness', '0'), |
|---|
| 43 | ('3', 'Delayed tasks', '0'), |
|---|
| 44 | ('3', 'Failed requests (tasks)', '0'), |
|---|
| 45 | ('2', 'Makespan', '57600'), |
|---|
| 46 | ('3', 'Resources queue length', '0.687'), |
|---|
| 47 | ('3', 'Resources total load', '0.49'), |
|---|
| 48 | ('3', 'Resources reservation load', '0.49'), |
|---|
| 49 | ('3', 'Energy usage', '1.375'), |
|---|
| 50 | ('3', 'Task completion time', '29630.769'), |
|---|
| 51 | ('3', 'Task execution time', '13015.385'), |
|---|
| 52 | ('3', 'Task start time', '6092.308'), |
|---|
| 53 | ('3', 'Task flow time', '13015.385'), |
|---|
| 54 | ('3', 'Task waiting time', '6092.308'), |
|---|
| 55 | ('3', 'Task lateness', '0'), |
|---|
| 56 | ('3', 'Task tardiness', '0'), |
|---|
| 57 | ('4', 'Delayed tasks', '0'), |
|---|
| 58 | ('4', 'Failed requests (tasks)', '0'), |
|---|
| 59 | ('4', 'Makespan', '32400'), |
|---|
| 60 | ('4', 'Resources queue length', '0.389'), |
|---|
| 61 | ('4', 'Resources total load', '0.175'), |
|---|
| 62 | ('4', 'Resources reservation load', '0.183'), |
|---|
| 63 | ('4', 'Energy usage', '0.238'), |
|---|
| 64 | ('4', 'Task completion time', '23398.8'), |
|---|
| 65 | ('4', 'Task execution time', '7920'), |
|---|
| 66 | ('4', 'Task start time', '15478.8'), |
|---|
| 67 | ('4', 'Task flow time', '8278.8'), |
|---|
| 68 | ('4', 'Task waiting time', '15477.6'), |
|---|
| 69 | ('4', 'Task lateness', '-1.2'), |
|---|
| 70 | ('4', 'Task tardiness', '0'), |
|---|
| 71 | ('5', 'Delayed tasks', '0'), |
|---|
| 72 | ('5', 'Failed requests (tasks)', '0'), |
|---|
| 73 | ('2', 'Makespan', '61042'), |
|---|
| 74 | ('5', 'Resources queue length', '0.393'), |
|---|
| 75 | ('5', 'Resources total load', '0.286'), |
|---|
| 76 | ('5', 'Resources reservation load', '0.345'), |
|---|
| 77 | ('5', 'Energy usage', '0.756'), |
|---|
| 78 | ('5', 'Task completion time', '40059.143'), |
|---|
| 79 | ('5', 'Task execution time', '17485.714'), |
|---|
| 80 | ('5', 'Task start time', '3030.571'), |
|---|
| 81 | ('5', 'Task flow time', '20516.286'), |
|---|
| 82 | ('5', 'Task waiting time', '3029.571'), |
|---|
| 83 | ('5', 'Task lateness', '-569.429'), |
|---|
| 84 | ('5', 'Task tardiness', '0'); |
|---|
| 85 | |
|---|
| 86 | 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 |
|---|
| 87 | ('20', '2', '0', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), '7200', '7200', '0', '7200', '0', '0', '0', '0', '7200'), |
|---|
| 88 | ('21', '2', '1', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '3600', '7200', '3600', '0', '0', '0', '10800'), |
|---|
| 89 | ('210', '2', '10', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), '14400', '14400', '0', '14400', '0', '0', '0', '0', '14400'), |
|---|
| 90 | ('211', '2', '11', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '28800', '0', '28800', '0', '0', '0', '0', '28800'), |
|---|
| 91 | ('212', '2', '12', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '0', '7200', '0', '0', '0', '0', '10800'), |
|---|
| 92 | ('213', '2', '13', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), '43200', '21600', '0', '21600', '0', '0', '0', '0', '43200'), |
|---|
| 93 | ('214', '2', '14', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), '50400', '25200', '0', '25200', '0', '0', '0', '0', '50400'), |
|---|
| 94 | ('215', '2', '15', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), '54000', '14400', '0', '14400', '0', '0', '0', '0', '54000'), |
|---|
| 95 | ('216', '2', '16', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), '57600', '10800', '0', '10800', '0', '0', '0', '0', '57600'), |
|---|
| 96 | ('22', '2', '2', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14400', '0', '0', '0', '21600'), |
|---|
| 97 | ('23', '2', '3', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '18000', '0', '0', '0', '25200'), |
|---|
| 98 | ('24', '2', '4', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '7200', '21600', '7200', '21600', '0', '0', '0', '28800'), |
|---|
| 99 | ('25', '2', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21600', '0', '0', '0', '32400'), |
|---|
| 100 | ('30', '3', '0', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000), FROM_UNIXTIME(1225674000), '7200', '7200', '0', '7200', '0', '0', '0', '0', '7200'), |
|---|
| 101 | ('31', '3', '1', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '3600', '7200', '3600', '0', '0', '0', '10800'), |
|---|
| 102 | ('310', '3', '10', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225681200), '14400', '14400', '0', '14400', '0', '0', '0', '0', '14400'), |
|---|
| 103 | ('311', '3', '11', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '28800', '0', '28800', '0', '0', '0', '0', '28800'), |
|---|
| 104 | ('312', '3', '12', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600), FROM_UNIXTIME(1225677600), '10800', '7200', '0', '7200', '0', '0', '0', '0', '10800'), |
|---|
| 105 | ('313', '3', '13', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000), FROM_UNIXTIME(1225710000), '43200', '21600', '0', '21600', '0', '0', '0', '0', '43200'), |
|---|
| 106 | ('314', '3', '14', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200), FROM_UNIXTIME(1225717200), '50400', '25200', '0', '25200', '0', '0', '0', '0', '50400'), |
|---|
| 107 | ('315', '3', '15', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800), FROM_UNIXTIME(1225720800), '54000', '14400', '0', '14400', '0', '0', '0', '0', '54000'), |
|---|
| 108 | ('316', '3', '16', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400), FROM_UNIXTIME(1225724400), '57600', '10800', '0', '10800', '0', '0', '0', '0', '57600'), |
|---|
| 109 | ('32', '3', '2', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14400', '0', '0', '0', '21600'), |
|---|
| 110 | ('33', '3', '3', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '18000', '0', '0', '0', '25200'), |
|---|
| 111 | ('34', '3', '4', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '28800', '7200', '21600', '7200', '21600', '0', '0', '0', '28800'), |
|---|
| 112 | ('35', '3', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21600', '0', '0', '0', '32400'), |
|---|
| 113 | ('41', '4', '1', FROM_UNIXTIME(1225668594), FROM_UNIXTIME(1225675794), FROM_UNIXTIME(1225675800), '8994', '7200', '1794', '8994', '1793', '1', '0', '-6', '8994'), |
|---|
| 114 | ('43', '4', '3', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225688400), '21600', '7200', '14400', '7200', '14399', '1', '0', '0', '21600'), |
|---|
| 115 | ('44', '4', '4', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225692000), '25200', '7200', '18000', '7200', '17999', '1', '0', '0', '25200'), |
|---|
| 116 | ('45', '4', '5', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600), FROM_UNIXTIME(1225695600), '28800', '7200', '21600', '7200', '21599', '1', '0', '0', '28800'), |
|---|
| 117 | ('46', '4', '6', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200), FROM_UNIXTIME(1225699200), '32400', '10800', '21600', '10800', '21598', '2', '0', '0', '32400'), |
|---|
| 118 | ('50', '5', '0', FROM_UNIXTIME(1225670322), FROM_UNIXTIME(1225684722), FROM_UNIXTIME(1225684800), '17922', '14400', '3522', '17922', '3521', '1', '0', '-78', '17922'), |
|---|
| 119 | ('51', '5', '1', FROM_UNIXTIME(1225666802), FROM_UNIXTIME(1225695602), FROM_UNIXTIME(1225699200), '28802', '28800', '2', '28802', '1', '1', '0', '-3598', '28802'), |
|---|
| 120 | ('52', '5', '2', FROM_UNIXTIME(1225673986), FROM_UNIXTIME(1225681186), FROM_UNIXTIME(1225681200), '14386', '7200', '3586', '10786', '3585', '1', '0', '-14', '14386'), |
|---|
| 121 | ('53', '5', '3', FROM_UNIXTIME(1225691986), FROM_UNIXTIME(1225713586), FROM_UNIXTIME(1225713600), '46786', '21600', '3586', '25186', '3585', '1', '0', '-14', '46786'), |
|---|
| 122 | ('54', '5', '4', FROM_UNIXTIME(1225695570), FROM_UNIXTIME(1225720770), FROM_UNIXTIME(1225720800), '53970', '25200', '3570', '28770', '3569', '1', '0', '-30', '53970'), |
|---|
| 123 | ('55', '5', '5', FROM_UNIXTIME(1225709906), FROM_UNIXTIME(1225724306), FROM_UNIXTIME(1225724400), '57506', '14400', '3506', '17906', '3505', '1', '0', '-94', '57506'), |
|---|
| 124 | ('56', '5', '6', FROM_UNIXTIME(1225717042), FROM_UNIXTIME(1225727842), FROM_UNIXTIME(1225728000), '61042', '10800', '3442', '14242', '3441', '1', '0', '-158', '61042'); |
|---|
| 125 | |
|---|
| 126 | 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 |
|---|
| 127 | ('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'), |
|---|
| 128 | ('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'), |
|---|
| 129 | ('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'), |
|---|
| 130 | ('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'), |
|---|
| 131 | ('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'), |
|---|
| 132 | ('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'), |
|---|
| 133 | ('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'), |
|---|
| 134 | ('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'), |
|---|
| 135 | ('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'), |
|---|
| 136 | ('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'), |
|---|
| 137 | ('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'), |
|---|
| 138 | ('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'), |
|---|
| 139 | ('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'), |
|---|
| 140 | ('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'), |
|---|
| 141 | ('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'), |
|---|
| 142 | ('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'), |
|---|
| 143 | ('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'), |
|---|
| 144 | ('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'), |
|---|
| 145 | ('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'), |
|---|
| 146 | ('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'), |
|---|
| 147 | ('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'), |
|---|
| 148 | ('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'), |
|---|
| 149 | ('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'), |
|---|
| 150 | ('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'), |
|---|
| 151 | ('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'), |
|---|
| 152 | ('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'), |
|---|
| 153 | ('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'), |
|---|
| 154 | ('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'), |
|---|
| 155 | ('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'), |
|---|
| 156 | ('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'), |
|---|
| 157 | ('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'), |
|---|
| 158 | ('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'), |
|---|
| 159 | ('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'), |
|---|
| 160 | ('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'), |
|---|
| 161 | ('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'), |
|---|
| 162 | ('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'), |
|---|
| 163 | ('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'), |
|---|
| 164 | ('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'); |
|---|
| 165 | |
|---|
| 166 | INSERT INTO `gssim_results`.`resource` (`PK`, `exp_id`, `name`, `type`, `allocation_load`, `reservation_load`) VALUES |
|---|
| 167 | ('21', '2', 'compRes1', 'computing', '0.604', '0.604'), |
|---|
| 168 | ('22', '2', 'compRes2', 'computing', '0.375', '0.375'), |
|---|
| 169 | ('31', '3', 'compRes1', 'computing', '0.646', '0.646'), |
|---|
| 170 | ('32', '3', 'compRes2', 'computing', '0.333', '0.333'), |
|---|
| 171 | ('41', '4', 'compRes1', 'computing', '0.185', '0.185'), |
|---|
| 172 | ('42', '4', 'compRes2', 'computing', '0.222', '0.241'), |
|---|
| 173 | ('43', '4', 'dataRes1', 'data', '0', '0'), |
|---|
| 174 | ('44', '4', 'networkRes1', 'network', '0.438', '0.438'), |
|---|
| 175 | ('51', '5', 'compRes1', 'computing', '0.451', '0.549'), |
|---|
| 176 | ('52', '5', 'compRes2', 'computing', '0.216', '0.255'), |
|---|
| 177 | ('53', '5', 'dataRes1', 'data', '0', '0'), |
|---|
| 178 | ('54', '5', 'networkRes1', 'network', '0.562', '0.562'); |
|---|
| 179 | |
|---|
| 180 | INSERT INTO `gssim_results`.`queues` (`fk_resource_id`, `name`, `avg_length`) |
|---|
| 181 | VALUES ('21', 'default', '0.437'), |
|---|
| 182 | ('22', 'default', '0.625'), |
|---|
| 183 | ('31', 'default', '1'), |
|---|
| 184 | ('32', 'default', '0.375'), |
|---|
| 185 | ('41', 'default', '0.667'), |
|---|
| 186 | ('42', 'default', '0.5'), |
|---|
| 187 | ('43', 'default', '0'), |
|---|
| 188 | ('51', 'default', '0.414'), |
|---|
| 189 | ('52', 'default', '0.765'), |
|---|
| 190 | ('53', 'default', '0'); |
|---|
| 191 | |
|---|
| 192 | |
|---|
| 193 | INSERT INTO `gssim_results`.`resource_allocation_timeline` (`fk_resource_id`, `timestamp`, `usage`) |
|---|
| 194 | VALUES ('21', FROM_UNIXTIME(1225666800), '2'), |
|---|
| 195 | ('21', FROM_UNIXTIME(1225674000), '1'), |
|---|
| 196 | ('21', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 197 | ('21', FROM_UNIXTIME(1225688400), '2'), |
|---|
| 198 | ('21', FROM_UNIXTIME(1225692000), '3'), |
|---|
| 199 | ('21', FROM_UNIXTIME(1225699200), '2'), |
|---|
| 200 | ('21', FROM_UNIXTIME(1225706400), '3'), |
|---|
| 201 | ('21', FROM_UNIXTIME(1225710000), '2'), |
|---|
| 202 | ('21', FROM_UNIXTIME(1225713600), '3'), |
|---|
| 203 | ('21', FROM_UNIXTIME(1225717200), '2'), |
|---|
| 204 | ('21', FROM_UNIXTIME(1225720800), '1'), |
|---|
| 205 | ('21', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 206 | ('22', FROM_UNIXTIME(1225666800), '1'), |
|---|
| 207 | ('22', FROM_UNIXTIME(1225670400), '3'), |
|---|
| 208 | ('22', FROM_UNIXTIME(1225677600), '1'), |
|---|
| 209 | ('22', FROM_UNIXTIME(1225681200), '2'), |
|---|
| 210 | ('22', FROM_UNIXTIME(1225684800), '3'), |
|---|
| 211 | ('22', FROM_UNIXTIME(1225688400), '3'), |
|---|
| 212 | ('22', FROM_UNIXTIME(1225692000), '2'), |
|---|
| 213 | ('22', FROM_UNIXTIME(1225695600), '0'), |
|---|
| 214 | ('31', FROM_UNIXTIME(1225666800), '3'), |
|---|
| 215 | ('31', FROM_UNIXTIME(1225674000), '2'), |
|---|
| 216 | ('31', FROM_UNIXTIME(1225681200), '2'), |
|---|
| 217 | ('31', FROM_UNIXTIME(1225684800), '3'), |
|---|
| 218 | ('31', FROM_UNIXTIME(1225688400), '3'), |
|---|
| 219 | ('31', FROM_UNIXTIME(1225692000), '3'), |
|---|
| 220 | ('31', FROM_UNIXTIME(1225695600), '2'), |
|---|
| 221 | ('31', FROM_UNIXTIME(1225699200), '1'), |
|---|
| 222 | ('31', FROM_UNIXTIME(1225713600), '2'), |
|---|
| 223 | ('31', FROM_UNIXTIME(1225717200), '1'), |
|---|
| 224 | ('31', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 225 | ('32', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 226 | ('32', FROM_UNIXTIME(1225670400), '2'), |
|---|
| 227 | ('32', FROM_UNIXTIME(1225677600), '0'), |
|---|
| 228 | ('32', FROM_UNIXTIME(1225688400), '2'), |
|---|
| 229 | ('32', FROM_UNIXTIME(1225695600), '1'), |
|---|
| 230 | ('32', FROM_UNIXTIME(1225706400), '2'), |
|---|
| 231 | ('32', FROM_UNIXTIME(1225710000), '1'), |
|---|
| 232 | ('32', FROM_UNIXTIME(1225720800), '0'), |
|---|
| 233 | ('41', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 234 | ('41', FROM_UNIXTIME(1225688400), '2'), |
|---|
| 235 | ('41', FROM_UNIXTIME(1225695600), '1'), |
|---|
| 236 | ('41', FROM_UNIXTIME(1225699200), '0'), |
|---|
| 237 | ('42', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 238 | ('42', FROM_UNIXTIME(1225668594), '1'), |
|---|
| 239 | ('42', FROM_UNIXTIME(1225675794), '0'), |
|---|
| 240 | ('42', FROM_UNIXTIME(1225681200), '1'), |
|---|
| 241 | ('42', FROM_UNIXTIME(1225684800), '2'), |
|---|
| 242 | ('42', FROM_UNIXTIME(1225688400), '1'), |
|---|
| 243 | ('42', FROM_UNIXTIME(1225692000), '0'), |
|---|
| 244 | ('43', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 245 | ('51', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 246 | ('51', FROM_UNIXTIME(1225670322), '1'), |
|---|
| 247 | ('51', FROM_UNIXTIME(1225673986), '2'), |
|---|
| 248 | ('51', FROM_UNIXTIME(1225681186), '1'), |
|---|
| 249 | ('51', FROM_UNIXTIME(1225684722), '0'), |
|---|
| 250 | ('51', FROM_UNIXTIME(1225691986), '1'), |
|---|
| 251 | ('51', FROM_UNIXTIME(1225695570), '2'), |
|---|
| 252 | ('51', FROM_UNIXTIME(1225709906), '3'), |
|---|
| 253 | ('51', FROM_UNIXTIME(1225713586), '2'), |
|---|
| 254 | ('51', FROM_UNIXTIME(1225720770), '1'), |
|---|
| 255 | ('51', FROM_UNIXTIME(1225724306), '0'), |
|---|
| 256 | ('52', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 257 | ('52', FROM_UNIXTIME(1225666802), '1'), |
|---|
| 258 | ('52', FROM_UNIXTIME(1225695602), '0'), |
|---|
| 259 | ('52', FROM_UNIXTIME(1225717042), '1'), |
|---|
| 260 | ('52', FROM_UNIXTIME(1225727842), '0'), |
|---|
| 261 | ('53', FROM_UNIXTIME(1225666800), '0'); |
|---|
| 262 | |
|---|
| 263 | INSERT INTO `gssim_results`.`resource_energy_timeline` (`fk_resource_id`, `timestamp`, `usage`) |
|---|
| 264 | VALUES ('21', FROM_UNIXTIME(1225666800), '2'), |
|---|
| 265 | ('21', FROM_UNIXTIME(1225674000), '1'), |
|---|
| 266 | ('21', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 267 | ('21', FROM_UNIXTIME(1225688400), '2'), |
|---|
| 268 | ('21', FROM_UNIXTIME(1225692000), '3'), |
|---|
| 269 | ('21', FROM_UNIXTIME(1225699200), '2'), |
|---|
| 270 | ('21', FROM_UNIXTIME(1225706400), '3'), |
|---|
| 271 | ('21', FROM_UNIXTIME(1225710000), '2'), |
|---|
| 272 | ('21', FROM_UNIXTIME(1225713600), '3'), |
|---|
| 273 | ('21', FROM_UNIXTIME(1225717200), '2'), |
|---|
| 274 | ('21', FROM_UNIXTIME(1225720800), '1'), |
|---|
| 275 | ('21', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 276 | ('22', FROM_UNIXTIME(1225666800), '1'), |
|---|
| 277 | ('22', FROM_UNIXTIME(1225670400), '3'), |
|---|
| 278 | ('22', FROM_UNIXTIME(1225677600), '1'), |
|---|
| 279 | ('22', FROM_UNIXTIME(1225681200), '2'), |
|---|
| 280 | ('22', FROM_UNIXTIME(1225684800), '3'), |
|---|
| 281 | ('22', FROM_UNIXTIME(1225688400), '3'), |
|---|
| 282 | ('22', FROM_UNIXTIME(1225692000), '2'), |
|---|
| 283 | ('22', FROM_UNIXTIME(1225695600), '0'), |
|---|
| 284 | ('31', FROM_UNIXTIME(1225666800), '3'), |
|---|
| 285 | ('31', FROM_UNIXTIME(1225674000), '2'), |
|---|
| 286 | ('31', FROM_UNIXTIME(1225681200), '2'), |
|---|
| 287 | ('31', FROM_UNIXTIME(1225684800), '3'), |
|---|
| 288 | ('31', FROM_UNIXTIME(1225688400), '3'), |
|---|
| 289 | ('31', FROM_UNIXTIME(1225692000), '3'), |
|---|
| 290 | ('31', FROM_UNIXTIME(1225695600), '2'), |
|---|
| 291 | ('31', FROM_UNIXTIME(1225699200), '1'), |
|---|
| 292 | ('31', FROM_UNIXTIME(1225713600), '2'), |
|---|
| 293 | ('31', FROM_UNIXTIME(1225717200), '1'), |
|---|
| 294 | ('31', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 295 | ('32', FROM_UNIXTIME(1225670400), '2'), |
|---|
| 296 | ('32', FROM_UNIXTIME(1225677600), '0'), |
|---|
| 297 | ('32', FROM_UNIXTIME(1225688400), '2'), |
|---|
| 298 | ('32', FROM_UNIXTIME(1225695600), '1'), |
|---|
| 299 | ('32', FROM_UNIXTIME(1225706400), '2'), |
|---|
| 300 | ('32', FROM_UNIXTIME(1225710000), '1'), |
|---|
| 301 | ('32', FROM_UNIXTIME(1225720800), '0'), |
|---|
| 302 | ('41', FROM_UNIXTIME(1225688400), '2'), |
|---|
| 303 | ('41', FROM_UNIXTIME(1225695600), '1'), |
|---|
| 304 | ('41', FROM_UNIXTIME(1225699200), '0'), |
|---|
| 305 | ('42', FROM_UNIXTIME(1225668594), '1'), |
|---|
| 306 | ('42', FROM_UNIXTIME(1225675794), '0'), |
|---|
| 307 | ('42', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 308 | ('42', FROM_UNIXTIME(1225684800), '2'), |
|---|
| 309 | ('42', FROM_UNIXTIME(1225688400), '1'), |
|---|
| 310 | ('42', FROM_UNIXTIME(1225692000), '0'), |
|---|
| 311 | ('51', FROM_UNIXTIME(1225670322), '1'), |
|---|
| 312 | ('51', FROM_UNIXTIME(1225673986), '2'), |
|---|
| 313 | ('51', FROM_UNIXTIME(1225681186), '1'), |
|---|
| 314 | ('51', FROM_UNIXTIME(1225684722), '0'), |
|---|
| 315 | ('51', FROM_UNIXTIME(1225691986), '1'), |
|---|
| 316 | ('51', FROM_UNIXTIME(1225695570), '2'), |
|---|
| 317 | ('51', FROM_UNIXTIME(1225709906), '3'), |
|---|
| 318 | ('51', FROM_UNIXTIME(1225713586), '2'), |
|---|
| 319 | ('51', FROM_UNIXTIME(1225720770), '1'), |
|---|
| 320 | ('51', FROM_UNIXTIME(1225724306), '0'), |
|---|
| 321 | ('52', FROM_UNIXTIME(1225666802), '1'), |
|---|
| 322 | ('52', FROM_UNIXTIME(1225695602), '0'), |
|---|
| 323 | ('52', FROM_UNIXTIME(1225717042), '1'), |
|---|
| 324 | ('52', FROM_UNIXTIME(1225727842), '0'); |
|---|
| 325 | |
|---|
| 326 | |
|---|
| 327 | INSERT INTO `gssim_results`.`unit` (`PK`, `resource_id`, `type`, `name`, `amount`, `allocation_load`, `reservation_load`) |
|---|
| 328 | VALUES ('210', '21', 'computing', '0@compRes1', '1', '0.562', '0.562'), |
|---|
| 329 | ('211', '21', 'computing', '1@compRes1', '1', '0.812', '0.812'), |
|---|
| 330 | ('212', '21', 'computing', '2@compRes1', '1', '0.437', '0.437'), |
|---|
| 331 | ('220', '22', 'computing', '0@compRes2', '1', '0.5', '0.5'), |
|---|
| 332 | ('221', '22', 'computing', '1@compRes2', '1', '0.375', '0.375'), |
|---|
| 333 | ('222', '22', 'computing', '2@compRes2', '1', '0.25', '0.25'), |
|---|
| 334 | ('310', '31', 'computing', '0@compRes1', '1', '0.625', '0.625'), |
|---|
| 335 | ('311', '31', 'computing', '1@compRes1', '1', '0.812', '0.812'), |
|---|
| 336 | ('312', '31', 'computing', '2@compRes1', '1', '0.5', '0.5'), |
|---|
| 337 | ('320', '32', 'computing', '0@compRes2', '1', '0.5', '0.5'), |
|---|
| 338 | ('321', '32', 'computing', '1@compRes2', '1', '0.5', '0.5'), |
|---|
| 339 | ('322', '32', 'computing', '2@compRes2', '1', '0', '0'), |
|---|
| 340 | ('410', '41', 'computing', '0@compRes1', '1', '0.333', '0.333'), |
|---|
| 341 | ('411', '41', 'computing', '1@compRes1', '1', '0.222', '0.222'), |
|---|
| 342 | ('412', '41', 'computing', '2@compRes1', '1', '0', '0'), |
|---|
| 343 | ('420', '42', 'computing', '0@compRes2', '1', '0.444', '0.5'), |
|---|
| 344 | ('421', '42', 'computing', '1@compRes2', '1', '0.222', '0.222'), |
|---|
| 345 | ('422', '42', 'computing', '2@compRes2', '1', '0', '0'), |
|---|
| 346 | ('430', '43', 'data', '0@compRes3', '1', '0', '0'), |
|---|
| 347 | ('440', '44', 'link', 'R1_R2_link', '1', '0', '0'), |
|---|
| 348 | ('441', '44', 'link', 'R2_R5_link', '1', '0.003981', '0.003981'), |
|---|
| 349 | ('442', '44', 'link', 'R1_R3_link', '1', '0', '0'), |
|---|
| 350 | ('443', '44', 'link', 'R3_R4_link', '1', '0', '0'), |
|---|
| 351 | ('444', '44', 'link', 'R4_R5_link', '1', '0.010617', '0.010617'), |
|---|
| 352 | ('445', '44', 'link', 'compRes1_link', '1', '0.003981', '0.003981'), |
|---|
| 353 | ('446', '44', 'link', 'compRes2_link', '1', '0.010617', '0.010617'), |
|---|
| 354 | ('447', '44', 'link', 'dataRes1_link', '1', '0.014598', '0.014598'), |
|---|
| 355 | ('448', '44', 'link', 'BrokerInterfaceEntity_link', '1', '0', '0'), |
|---|
| 356 | ('510', '51', 'computing', '0@compRes1', '1', '0.588', '0.706'), |
|---|
| 357 | ('511', '51', 'computing', '1@compRes1', '1', '0.529', '0.647'), |
|---|
| 358 | ('512', '51', 'computing', '2@compRes1', '1', '0.235', '0.294'), |
|---|
| 359 | ('520', '52', 'computing', '0@compRes2', '1', '0.647', '0.765'), |
|---|
| 360 | ('521', '52', 'computing', '1@compRes2', '1', '0', '0'), |
|---|
| 361 | ('522', '52', 'computing', '2@compRes2', '1', '0', '0'), |
|---|
| 362 | ('530', '53', 'data', '0@compRes3', '1', '0', '0'), |
|---|
| 363 | ('540', '54', 'link', 'R1_R2_link', '1', '0.000261', '0.000261'), |
|---|
| 364 | ('541', '54', 'link', 'R2_R5_link', '1', '0.001438', '0.001438'), |
|---|
| 365 | ('542', '54', 'link', 'R1_R3_link', '1', '0.000261', '0.000261'), |
|---|
| 366 | ('543', '54', 'link', 'R3_R4_link', '1', '0.000261', '0.000261'), |
|---|
| 367 | ('544', '54', 'link', 'R4_R5_link', '1', '0', '0'), |
|---|
| 368 | ('545', '54', 'link', 'compRes1_link', '1', '0.001438', '0.001438'), |
|---|
| 369 | ('546', '54', 'link', 'compRes2_link', '1', '0.000261', '0.000261'), |
|---|
| 370 | ('547', '54', 'link', 'dataRes1_link', '1', '0.001699', '0.001699'), |
|---|
| 371 | ('548', '54', 'link', 'BrokerInterfaceEntity_link', '1', '0', '0'); |
|---|
| 372 | |
|---|
| 373 | INSERT INTO `gssim_results`.`unit_details` (`fk_unit_id`, `name`, `value`) |
|---|
| 374 | VALUES ('210', 'details', '1'), |
|---|
| 375 | ('211', 'details', '2'), |
|---|
| 376 | ('212', 'details', '3'), |
|---|
| 377 | ('220', 'details', '4'), |
|---|
| 378 | ('221', 'details', '5'), |
|---|
| 379 | ('222', 'details', '6'), |
|---|
| 380 | ('310', 'details', '8'), |
|---|
| 381 | ('311', 'details', '9'), |
|---|
| 382 | ('312', 'details', '10'), |
|---|
| 383 | ('320', 'details', '11'), |
|---|
| 384 | ('321', 'details', '12'), |
|---|
| 385 | ('322', 'details', '13'), |
|---|
| 386 | ('410', 'details', '15'), |
|---|
| 387 | ('411', 'details', '16'), |
|---|
| 388 | ('412', 'details', '17'), |
|---|
| 389 | ('420', 'details', '18'), |
|---|
| 390 | ('421', 'details', '19'), |
|---|
| 391 | ('422', 'details', '20'), |
|---|
| 392 | ('430', 'details', '21'), |
|---|
| 393 | ('440', 'Baud rate (bits/s)', '1000000'), |
|---|
| 394 | ('440', 'delay(ms)', '300'), |
|---|
| 395 | ('440', 'size of transmitted data(in bytes)', '2'), |
|---|
| 396 | ('441', 'Baud rate (bits/s)', '1000000'), |
|---|
| 397 | ('441', 'delay(ms)', '300'), |
|---|
| 398 | ('441', 'size of transmitted data(in bytes)', '0'), |
|---|
| 399 | ('442', 'Baud rate (bits/s)', '1000000'), |
|---|
| 400 | ('442', 'delay(ms)', '300'), |
|---|
| 401 | ('442', 'size of transmitted data(in bytes)', '3'), |
|---|
| 402 | ('443', 'Baud rate (bits/s)', '1000000'), |
|---|
| 403 | ('443', 'delay(ms)', '300'), |
|---|
| 404 | ('443', 'size of transmitted data(in bytes)', '3'), |
|---|
| 405 | ('444', 'Baud rate (bits/s)', '1000000'), |
|---|
| 406 | ('444', 'delay(ms)', '300'), |
|---|
| 407 | ('444', 'size of transmitted data(in bytes)', '0'), |
|---|
| 408 | ('445', 'Baud rate (bits/s)', '1000000'), |
|---|
| 409 | ('445', 'delay(ms)', '300'), |
|---|
| 410 | ('445', 'size of transmitted data(in bytes)', '2'), |
|---|
| 411 | ('446', 'Baud rate (bits/s)', '1000000'), |
|---|
| 412 | ('446', 'delay(ms)', '300'), |
|---|
| 413 | ('446', 'size of transmitted data(in bytes)', '3'), |
|---|
| 414 | ('447', 'Baud rate (bits/s)', '1000000'), |
|---|
| 415 | ('447', 'delay(ms)', '300'), |
|---|
| 416 | ('447', 'size of transmitted data(in bytes)', '0'), |
|---|
| 417 | ('448', 'Baud rate (bits/s)', '1000000'), |
|---|
| 418 | ('448', 'delay(ms)', '300'), |
|---|
| 419 | ('448', 'size of transmitted data(in bytes)', '5'), |
|---|
| 420 | ('510', 'details', '23'), |
|---|
| 421 | ('511', 'details', '24'), |
|---|
| 422 | ('512', 'details', '25'), |
|---|
| 423 | ('520', 'details', '26'), |
|---|
| 424 | ('521', 'details', '27'), |
|---|
| 425 | ('522', 'details', '28'), |
|---|
| 426 | ('530', 'details', '29'), |
|---|
| 427 | ('540', 'Baud rate (bits/s)', '10000000'), |
|---|
| 428 | ('540', 'delay(ms)', '300'), |
|---|
| 429 | ('540', 'size of transmitted data(in bytes)', '5'), |
|---|
| 430 | ('541', 'Baud rate (bits/s)', '10000000'), |
|---|
| 431 | ('541', 'delay(ms)', '300'), |
|---|
| 432 | ('541', 'size of transmitted data(in bytes)', '5'), |
|---|
| 433 | ('542', 'Baud rate (bits/s)', '10000000'), |
|---|
| 434 | ('542', 'delay(ms)', '300'), |
|---|
| 435 | ('542', 'size of transmitted data(in bytes)', '2'), |
|---|
| 436 | ('543', 'Baud rate (bits/s)', '10000000'), |
|---|
| 437 | ('543', 'delay(ms)', '300'), |
|---|
| 438 | ('543', 'size of transmitted data(in bytes)', '2'), |
|---|
| 439 | ('544', 'Baud rate (bits/s)', '10000000'), |
|---|
| 440 | ('544', 'delay(ms)', '300'), |
|---|
| 441 | ('544', 'size of transmitted data(in bytes)', '0'), |
|---|
| 442 | ('545', 'Baud rate (bits/s)', '10000000'), |
|---|
| 443 | ('545', 'delay(ms)', '300'), |
|---|
| 444 | ('545', 'size of transmitted data(in bytes)', '5'), |
|---|
| 445 | ('546', 'Baud rate (bits/s)', '10000000'), |
|---|
| 446 | ('546', 'delay(ms)', '300'), |
|---|
| 447 | ('546', 'size of transmitted data(in bytes)', '2'), |
|---|
| 448 | ('547', 'Baud rate (bits/s)', '10000000'), |
|---|
| 449 | ('547', 'delay(ms)', '300'), |
|---|
| 450 | ('547', 'size of transmitted data(in bytes)', '0'), |
|---|
| 451 | ('548', 'Baud rate (bits/s)', '10000000'), |
|---|
| 452 | ('548', 'delay(ms)', '300'), |
|---|
| 453 | ('548', 'size of transmitted data(in bytes)', '7'); |
|---|
| 454 | |
|---|
| 455 | |
|---|
| 456 | INSERT INTO `gssim_results`.`unit_allocation_timeline` (`fk_unit_id`, `timestamp`, `usage`) |
|---|
| 457 | VALUES ('210', FROM_UNIXTIME(1225666800), '0.4'), |
|---|
| 458 | ('210', FROM_UNIXTIME(1225674000), '0.2'), |
|---|
| 459 | ('210', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 460 | ('210', FROM_UNIXTIME(1225688400), '0.4'), |
|---|
| 461 | ('210', FROM_UNIXTIME(1225692000), '0.6'), |
|---|
| 462 | ('210', FROM_UNIXTIME(1225699200), '0.4'), |
|---|
| 463 | ('210', FROM_UNIXTIME(1225706400), '0.6'), |
|---|
| 464 | ('210', FROM_UNIXTIME(1225710000), '0.4'), |
|---|
| 465 | ('210', FROM_UNIXTIME(1225713600), '0.6'), |
|---|
| 466 | ('210', FROM_UNIXTIME(1225717200), '0.4'), |
|---|
| 467 | ('210', FROM_UNIXTIME(1225720800), '0.2'), |
|---|
| 468 | ('210', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 469 | ('211', FROM_UNIXTIME(1225666800), '0.6'), |
|---|
| 470 | ('211', FROM_UNIXTIME(1225674000), '0.3'), |
|---|
| 471 | ('211', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 472 | ('211', FROM_UNIXTIME(1225688400), '0.6'), |
|---|
| 473 | ('211', FROM_UNIXTIME(1225692000), '0.9'), |
|---|
| 474 | ('211', FROM_UNIXTIME(1225699200), '0.6'), |
|---|
| 475 | ('211', FROM_UNIXTIME(1225706400), '0.9'), |
|---|
| 476 | ('211', FROM_UNIXTIME(1225710000), '0.6'), |
|---|
| 477 | ('211', FROM_UNIXTIME(1225713600), '0.9'), |
|---|
| 478 | ('211', FROM_UNIXTIME(1225717200), '0.6'), |
|---|
| 479 | ('211', FROM_UNIXTIME(1225720800), '0.3'), |
|---|
| 480 | ('211', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 481 | ('212', FROM_UNIXTIME(1225666800), '1'), |
|---|
| 482 | ('212', FROM_UNIXTIME(1225674000), '0.5'), |
|---|
| 483 | ('212', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 484 | ('212', FROM_UNIXTIME(1225688400), '1'), |
|---|
| 485 | ('212', FROM_UNIXTIME(1225692000), '1.5'), |
|---|
| 486 | ('212', FROM_UNIXTIME(1225699200), '1'), |
|---|
| 487 | ('212', FROM_UNIXTIME(1225706400), '1.5'), |
|---|
| 488 | ('212', FROM_UNIXTIME(1225710000), '1'), |
|---|
| 489 | ('212', FROM_UNIXTIME(1225713600), '1.5'), |
|---|
| 490 | ('212', FROM_UNIXTIME(1225717200), '1'), |
|---|
| 491 | ('212', FROM_UNIXTIME(1225720800), '0.5'), |
|---|
| 492 | ('212', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 493 | ('220', FROM_UNIXTIME(1225666800), '0.2'), |
|---|
| 494 | ('220', FROM_UNIXTIME(1225670400), '0.6'), |
|---|
| 495 | ('220', FROM_UNIXTIME(1225677600), '0.2'), |
|---|
| 496 | ('220', FROM_UNIXTIME(1225681200), '0.4'), |
|---|
| 497 | ('220', FROM_UNIXTIME(1225684800), '0.6'), |
|---|
| 498 | ('220', FROM_UNIXTIME(1225688400), '0.6'), |
|---|
| 499 | ('220', FROM_UNIXTIME(1225692000), '0.4'), |
|---|
| 500 | ('220', FROM_UNIXTIME(1225695600), '0'), |
|---|
| 501 | ('221', FROM_UNIXTIME(1225666800), '0.3'), |
|---|
| 502 | ('221', FROM_UNIXTIME(1225670400), '0.9'), |
|---|
| 503 | ('221', FROM_UNIXTIME(1225677600), '0.3'), |
|---|
| 504 | ('221', FROM_UNIXTIME(1225681200), '0.6'), |
|---|
| 505 | ('221', FROM_UNIXTIME(1225684800), '0.9'), |
|---|
| 506 | ('221', FROM_UNIXTIME(1225688400), '0.9'), |
|---|
| 507 | ('221', FROM_UNIXTIME(1225692000), '0.6'), |
|---|
| 508 | ('221', FROM_UNIXTIME(1225695600), '0'), |
|---|
| 509 | ('222', FROM_UNIXTIME(1225666800), '0.5'), |
|---|
| 510 | ('222', FROM_UNIXTIME(1225670400), '1.5'), |
|---|
| 511 | ('222', FROM_UNIXTIME(1225677600), '0.5'), |
|---|
| 512 | ('222', FROM_UNIXTIME(1225681200), '1'), |
|---|
| 513 | ('222', FROM_UNIXTIME(1225684800), '1.5'), |
|---|
| 514 | ('222', FROM_UNIXTIME(1225688400), '1.5'), |
|---|
| 515 | ('222', FROM_UNIXTIME(1225692000), '1'), |
|---|
| 516 | ('222', FROM_UNIXTIME(1225695600), '0'), |
|---|
| 517 | ('310', FROM_UNIXTIME(1225666800), '0.6'), |
|---|
| 518 | ('310', FROM_UNIXTIME(1225674000), '0.4'), |
|---|
| 519 | ('310', FROM_UNIXTIME(1225681200), '0.4'), |
|---|
| 520 | ('310', FROM_UNIXTIME(1225684800), '0.6'), |
|---|
| 521 | ('310', FROM_UNIXTIME(1225688400), '0.6'), |
|---|
| 522 | ('310', FROM_UNIXTIME(1225692000), '0.6'), |
|---|
| 523 | ('310', FROM_UNIXTIME(1225695600), '0.4'), |
|---|
| 524 | ('310', FROM_UNIXTIME(1225699200), '0.2'), |
|---|
| 525 | ('310', FROM_UNIXTIME(1225713600), '0.4'), |
|---|
| 526 | ('310', FROM_UNIXTIME(1225717200), '0.2'), |
|---|
| 527 | ('310', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 528 | ('311', FROM_UNIXTIME(1225666800), '0.9'), |
|---|
| 529 | ('311', FROM_UNIXTIME(1225674000), '0.6'), |
|---|
| 530 | ('311', FROM_UNIXTIME(1225681200), '0.6'), |
|---|
| 531 | ('311', FROM_UNIXTIME(1225684800), '0.9'), |
|---|
| 532 | ('311', FROM_UNIXTIME(1225688400), '0.9'), |
|---|
| 533 | ('311', FROM_UNIXTIME(1225692000), '0.9'), |
|---|
| 534 | ('311', FROM_UNIXTIME(1225695600), '0.6'), |
|---|
| 535 | ('311', FROM_UNIXTIME(1225699200), '0.3'), |
|---|
| 536 | ('311', FROM_UNIXTIME(1225713600), '0.6'), |
|---|
| 537 | ('311', FROM_UNIXTIME(1225717200), '0.3'), |
|---|
| 538 | ('311', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 539 | ('312', FROM_UNIXTIME(1225666800), '1.5'), |
|---|
| 540 | ('312', FROM_UNIXTIME(1225674000), '1'), |
|---|
| 541 | ('312', FROM_UNIXTIME(1225681200), '1'), |
|---|
| 542 | ('312', FROM_UNIXTIME(1225684800), '1.5'), |
|---|
| 543 | ('312', FROM_UNIXTIME(1225688400), '1.5'), |
|---|
| 544 | ('312', FROM_UNIXTIME(1225692000), '1.5'), |
|---|
| 545 | ('312', FROM_UNIXTIME(1225695600), '1'), |
|---|
| 546 | ('312', FROM_UNIXTIME(1225699200), '0.5'), |
|---|
| 547 | ('312', FROM_UNIXTIME(1225713600), '1'), |
|---|
| 548 | ('312', FROM_UNIXTIME(1225717200), '0.5'), |
|---|
| 549 | ('312', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 550 | ('320', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 551 | ('320', FROM_UNIXTIME(1225670400), '0.4'), |
|---|
| 552 | ('320', FROM_UNIXTIME(1225677600), '0'), |
|---|
| 553 | ('320', FROM_UNIXTIME(1225688400), '0.4'), |
|---|
| 554 | ('320', FROM_UNIXTIME(1225695600), '0.2'), |
|---|
| 555 | ('320', FROM_UNIXTIME(1225706400), '0.4'), |
|---|
| 556 | ('320', FROM_UNIXTIME(1225710000), '0.2'), |
|---|
| 557 | ('320', FROM_UNIXTIME(1225720800), '0'), |
|---|
| 558 | ('321', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 559 | ('321', FROM_UNIXTIME(1225670400), '0.6'), |
|---|
| 560 | ('321', FROM_UNIXTIME(1225677600), '0'), |
|---|
| 561 | ('321', FROM_UNIXTIME(1225688400), '0.6'), |
|---|
| 562 | ('321', FROM_UNIXTIME(1225695600), '0.3'), |
|---|
| 563 | ('321', FROM_UNIXTIME(1225706400), '0.6'), |
|---|
| 564 | ('321', FROM_UNIXTIME(1225710000), '0.3'), |
|---|
| 565 | ('321', FROM_UNIXTIME(1225720800), '0'), |
|---|
| 566 | ('322', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 567 | ('322', FROM_UNIXTIME(1225670400), '1'), |
|---|
| 568 | ('322', FROM_UNIXTIME(1225677600), '0'), |
|---|
| 569 | ('322', FROM_UNIXTIME(1225688400), '1'), |
|---|
| 570 | ('322', FROM_UNIXTIME(1225695600), '0.5'), |
|---|
| 571 | ('322', FROM_UNIXTIME(1225706400), '1'), |
|---|
| 572 | ('322', FROM_UNIXTIME(1225710000), '0.5'), |
|---|
| 573 | ('322', FROM_UNIXTIME(1225720800), '0'), |
|---|
| 574 | ('410', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 575 | ('410', FROM_UNIXTIME(1225688400), '0.4'), |
|---|
| 576 | ('410', FROM_UNIXTIME(1225695600), '0.2'), |
|---|
| 577 | ('410', FROM_UNIXTIME(1225699200), '0'), |
|---|
| 578 | ('411', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 579 | ('411', FROM_UNIXTIME(1225688400), '0.6'), |
|---|
| 580 | ('411', FROM_UNIXTIME(1225695600), '0.3'), |
|---|
| 581 | ('411', FROM_UNIXTIME(1225699200), '0'), |
|---|
| 582 | ('412', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 583 | ('412', FROM_UNIXTIME(1225688400), '1'), |
|---|
| 584 | ('412', FROM_UNIXTIME(1225695600), '0.5'), |
|---|
| 585 | ('412', FROM_UNIXTIME(1225699200), '0'), |
|---|
| 586 | ('420', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 587 | ('420', FROM_UNIXTIME(1225668594), '0.2'), |
|---|
| 588 | ('420', FROM_UNIXTIME(1225675794), '0'), |
|---|
| 589 | ('420', FROM_UNIXTIME(1225681200), '0.2'), |
|---|
| 590 | ('420', FROM_UNIXTIME(1225684800), '0.4'), |
|---|
| 591 | ('420', FROM_UNIXTIME(1225688400), '0.2'), |
|---|
| 592 | ('420', FROM_UNIXTIME(1225692000), '0'), |
|---|
| 593 | ('421', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 594 | ('421', FROM_UNIXTIME(1225668594), '0.3'), |
|---|
| 595 | ('421', FROM_UNIXTIME(1225675794), '0'), |
|---|
| 596 | ('421', FROM_UNIXTIME(1225681200), '0.3'), |
|---|
| 597 | ('421', FROM_UNIXTIME(1225684800), '0.6'), |
|---|
| 598 | ('421', FROM_UNIXTIME(1225688400), '0.3'), |
|---|
| 599 | ('421', FROM_UNIXTIME(1225692000), '0'), |
|---|
| 600 | ('422', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 601 | ('422', FROM_UNIXTIME(1225668594), '0.5'), |
|---|
| 602 | ('422', FROM_UNIXTIME(1225675794), '0'), |
|---|
| 603 | ('422', FROM_UNIXTIME(1225681200), '0.5'), |
|---|
| 604 | ('422', FROM_UNIXTIME(1225684800), '1'), |
|---|
| 605 | ('422', FROM_UNIXTIME(1225688400), '0.5'), |
|---|
| 606 | ('422', FROM_UNIXTIME(1225692000), '0'), |
|---|
| 607 | ('430', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 608 | ('510', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 609 | ('510', FROM_UNIXTIME(1225670322), '0.2'), |
|---|
| 610 | ('510', FROM_UNIXTIME(1225673986), '0.4'), |
|---|
| 611 | ('510', FROM_UNIXTIME(1225681186), '0.2'), |
|---|
| 612 | ('510', FROM_UNIXTIME(1225684722), '0'), |
|---|
| 613 | ('510', FROM_UNIXTIME(1225691986), '0.2'), |
|---|
| 614 | ('510', FROM_UNIXTIME(1225695570), '0.4'), |
|---|
| 615 | ('510', FROM_UNIXTIME(1225709906), '0.6'), |
|---|
| 616 | ('510', FROM_UNIXTIME(1225713586), '0.4'), |
|---|
| 617 | ('510', FROM_UNIXTIME(1225720770), '0.2'), |
|---|
| 618 | ('510', FROM_UNIXTIME(1225724306), '0'), |
|---|
| 619 | ('511', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 620 | ('511', FROM_UNIXTIME(1225670322), '0.3'), |
|---|
| 621 | ('511', FROM_UNIXTIME(1225673986), '0.6'), |
|---|
| 622 | ('511', FROM_UNIXTIME(1225681186), '0.3'), |
|---|
| 623 | ('511', FROM_UNIXTIME(1225684722), '0'), |
|---|
| 624 | ('511', FROM_UNIXTIME(1225691986), '0.3'), |
|---|
| 625 | ('511', FROM_UNIXTIME(1225695570), '0.6'), |
|---|
| 626 | ('511', FROM_UNIXTIME(1225709906), '0.9'), |
|---|
| 627 | ('511', FROM_UNIXTIME(1225713586), '0.6'), |
|---|
| 628 | ('511', FROM_UNIXTIME(1225720770), '0.3'), |
|---|
| 629 | ('511', FROM_UNIXTIME(1225724306), '0'), |
|---|
| 630 | ('512', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 631 | ('512', FROM_UNIXTIME(1225670322), '0.5'), |
|---|
| 632 | ('512', FROM_UNIXTIME(1225673986), '1'), |
|---|
| 633 | ('512', FROM_UNIXTIME(1225681186), '0.5'), |
|---|
| 634 | ('512', FROM_UNIXTIME(1225684722), '0'), |
|---|
| 635 | ('512', FROM_UNIXTIME(1225691986), '0.5'), |
|---|
| 636 | ('512', FROM_UNIXTIME(1225695570), '1'), |
|---|
| 637 | ('512', FROM_UNIXTIME(1225709906), '1.5'), |
|---|
| 638 | ('512', FROM_UNIXTIME(1225713586), '1'), |
|---|
| 639 | ('512', FROM_UNIXTIME(1225720770), '0.5'), |
|---|
| 640 | ('512', FROM_UNIXTIME(1225724306), '0'), |
|---|
| 641 | ('520', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 642 | ('520', FROM_UNIXTIME(1225666802), '0.2'), |
|---|
| 643 | ('520', FROM_UNIXTIME(1225695602), '0'), |
|---|
| 644 | ('520', FROM_UNIXTIME(1225717042), '0.2'), |
|---|
| 645 | ('520', FROM_UNIXTIME(1225727842), '0'), |
|---|
| 646 | ('521', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 647 | ('521', FROM_UNIXTIME(1225666802), '0.3'), |
|---|
| 648 | ('521', FROM_UNIXTIME(1225695602), '0'), |
|---|
| 649 | ('521', FROM_UNIXTIME(1225717042), '0.3'), |
|---|
| 650 | ('521', FROM_UNIXTIME(1225727842), '0'), |
|---|
| 651 | ('522', FROM_UNIXTIME(1225666800), '0'), |
|---|
| 652 | ('522', FROM_UNIXTIME(1225666802), '0.5'), |
|---|
| 653 | ('522', FROM_UNIXTIME(1225695602), '0'), |
|---|
| 654 | ('522', FROM_UNIXTIME(1225717042), '0.5'), |
|---|
| 655 | ('522', FROM_UNIXTIME(1225727842), '0'), |
|---|
| 656 | ('530', FROM_UNIXTIME(1225666800), '0'); |
|---|
| 657 | |
|---|
| 658 | |
|---|
| 659 | INSERT INTO `gssim_results`.`unit_energy_timeline` (`fk_unit_id`, `timestamp`, `usage`) |
|---|
| 660 | VALUES ('210', FROM_UNIXTIME(1225666800), '1.4'), |
|---|
| 661 | ('210', FROM_UNIXTIME(1225674000), '0.7'), |
|---|
| 662 | ('210', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 663 | ('210', FROM_UNIXTIME(1225688400), '1.4'), |
|---|
| 664 | ('210', FROM_UNIXTIME(1225692000), '2.1'), |
|---|
| 665 | ('210', FROM_UNIXTIME(1225699200), '1.4'), |
|---|
| 666 | ('210', FROM_UNIXTIME(1225706400), '2.1'), |
|---|
| 667 | ('210', FROM_UNIXTIME(1225710000), '1.4'), |
|---|
| 668 | ('210', FROM_UNIXTIME(1225713600), '2.1'), |
|---|
| 669 | ('210', FROM_UNIXTIME(1225717200), '1.4'), |
|---|
| 670 | ('210', FROM_UNIXTIME(1225720800), '0.7'), |
|---|
| 671 | ('210', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 672 | ('211', FROM_UNIXTIME(1225666800), '0.2'), |
|---|
| 673 | ('211', FROM_UNIXTIME(1225674000), '0.1'), |
|---|
| 674 | ('211', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 675 | ('211', FROM_UNIXTIME(1225688400), '0.2'), |
|---|
| 676 | ('211', FROM_UNIXTIME(1225692000), '0.3'), |
|---|
| 677 | ('211', FROM_UNIXTIME(1225699200), '0.2'), |
|---|
| 678 | ('211', FROM_UNIXTIME(1225706400), '0.3'), |
|---|
| 679 | ('211', FROM_UNIXTIME(1225710000), '0.2'), |
|---|
| 680 | ('211', FROM_UNIXTIME(1225713600), '0.3'), |
|---|
| 681 | ('211', FROM_UNIXTIME(1225717200), '0.2'), |
|---|
| 682 | ('211', FROM_UNIXTIME(1225720800), '0.1'), |
|---|
| 683 | ('211', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 684 | ('220', FROM_UNIXTIME(1225666800), '0.7'), |
|---|
| 685 | ('220', FROM_UNIXTIME(1225670400), '2.1'), |
|---|
| 686 | ('220', FROM_UNIXTIME(1225677600), '0.7'), |
|---|
| 687 | ('220', FROM_UNIXTIME(1225681200), '1.4'), |
|---|
| 688 | ('220', FROM_UNIXTIME(1225684800), '2.1'), |
|---|
| 689 | ('220', FROM_UNIXTIME(1225688400), '2.1'), |
|---|
| 690 | ('220', FROM_UNIXTIME(1225692000), '1.4'), |
|---|
| 691 | ('220', FROM_UNIXTIME(1225695600), '0'), |
|---|
| 692 | ('221', FROM_UNIXTIME(1225666800), '0.1'), |
|---|
| 693 | ('221', FROM_UNIXTIME(1225670400), '0.3'), |
|---|
| 694 | ('221', FROM_UNIXTIME(1225677600), '0.1'), |
|---|
| 695 | ('221', FROM_UNIXTIME(1225681200), '0.2'), |
|---|
| 696 | ('221', FROM_UNIXTIME(1225684800), '0.3'), |
|---|
| 697 | ('221', FROM_UNIXTIME(1225688400), '0.3'), |
|---|
| 698 | ('221', FROM_UNIXTIME(1225692000), '0.2'), |
|---|
| 699 | ('221', FROM_UNIXTIME(1225695600), '0'), |
|---|
| 700 | ('212', FROM_UNIXTIME(1225666800), '0.4'), |
|---|
| 701 | ('212', FROM_UNIXTIME(1225674000), '0.2'), |
|---|
| 702 | ('212', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 703 | ('212', FROM_UNIXTIME(1225688400), '0.4'), |
|---|
| 704 | ('212', FROM_UNIXTIME(1225692000), '0.6'), |
|---|
| 705 | ('212', FROM_UNIXTIME(1225699200), '0.4'), |
|---|
| 706 | ('212', FROM_UNIXTIME(1225706400), '0.6'), |
|---|
| 707 | ('212', FROM_UNIXTIME(1225710000), '0.4'), |
|---|
| 708 | ('212', FROM_UNIXTIME(1225713600), '0.6'), |
|---|
| 709 | ('212', FROM_UNIXTIME(1225717200), '0.4'), |
|---|
| 710 | ('212', FROM_UNIXTIME(1225720800), '0.2'), |
|---|
| 711 | ('212', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 712 | ('222', FROM_UNIXTIME(1225666800), '0.2'), |
|---|
| 713 | ('222', FROM_UNIXTIME(1225670400), '0.6'), |
|---|
| 714 | ('222', FROM_UNIXTIME(1225677600), '0.2'), |
|---|
| 715 | ('222', FROM_UNIXTIME(1225681200), '0.4'), |
|---|
| 716 | ('222', FROM_UNIXTIME(1225684800), '0.6'), |
|---|
| 717 | ('222', FROM_UNIXTIME(1225688400), '0.6'), |
|---|
| 718 | ('222', FROM_UNIXTIME(1225692000), '0.4'), |
|---|
| 719 | ('222', FROM_UNIXTIME(1225695600), '0'), |
|---|
| 720 | ('310', FROM_UNIXTIME(1225666800), '2.1'), |
|---|
| 721 | ('310', FROM_UNIXTIME(1225674000), '1.4'), |
|---|
| 722 | ('310', FROM_UNIXTIME(1225681200), '1.4'), |
|---|
| 723 | ('310', FROM_UNIXTIME(1225684800), '2.1'), |
|---|
| 724 | ('310', FROM_UNIXTIME(1225688400), '2.1'), |
|---|
| 725 | ('310', FROM_UNIXTIME(1225692000), '2.1'), |
|---|
| 726 | ('310', FROM_UNIXTIME(1225695600), '1.4'), |
|---|
| 727 | ('310', FROM_UNIXTIME(1225699200), '0.7'), |
|---|
| 728 | ('310', FROM_UNIXTIME(1225713600), '1.4'), |
|---|
| 729 | ('310', FROM_UNIXTIME(1225717200), '0.7'), |
|---|
| 730 | ('310', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 731 | ('311', FROM_UNIXTIME(1225666800), '0.3'), |
|---|
| 732 | ('311', FROM_UNIXTIME(1225674000), '0.2'), |
|---|
| 733 | ('311', FROM_UNIXTIME(1225681200), '0.2'), |
|---|
| 734 | ('311', FROM_UNIXTIME(1225684800), '0.3'), |
|---|
| 735 | ('311', FROM_UNIXTIME(1225688400), '0.3'), |
|---|
| 736 | ('311', FROM_UNIXTIME(1225692000), '0.3'), |
|---|
| 737 | ('311', FROM_UNIXTIME(1225695600), '0.2'), |
|---|
| 738 | ('311', FROM_UNIXTIME(1225699200), '0.1'), |
|---|
| 739 | ('311', FROM_UNIXTIME(1225713600), '0.2'), |
|---|
| 740 | ('311', FROM_UNIXTIME(1225717200), '0.1'), |
|---|
| 741 | ('311', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 742 | ('312', FROM_UNIXTIME(1225666800), '0.6'), |
|---|
| 743 | ('312', FROM_UNIXTIME(1225674000), '0.4'), |
|---|
| 744 | ('312', FROM_UNIXTIME(1225681200), '0.4'), |
|---|
| 745 | ('312', FROM_UNIXTIME(1225684800), '0.6'), |
|---|
| 746 | ('312', FROM_UNIXTIME(1225688400), '0.6'), |
|---|
| 747 | ('312', FROM_UNIXTIME(1225692000), '0.6'), |
|---|
| 748 | ('312', FROM_UNIXTIME(1225695600), '0.4'), |
|---|
| 749 | ('312', FROM_UNIXTIME(1225699200), '0.2'), |
|---|
| 750 | ('312', FROM_UNIXTIME(1225713600), '0.4'), |
|---|
| 751 | ('312', FROM_UNIXTIME(1225717200), '0.2'), |
|---|
| 752 | ('312', FROM_UNIXTIME(1225724400), '0'), |
|---|
| 753 | ('320', FROM_UNIXTIME(1225670400), '1.4'), |
|---|
| 754 | ('320', FROM_UNIXTIME(1225677600), '0'), |
|---|
| 755 | ('320', FROM_UNIXTIME(1225688400), '1.4'), |
|---|
| 756 | ('320', FROM_UNIXTIME(1225695600), '0.7'), |
|---|
| 757 | ('320', FROM_UNIXTIME(1225706400), '1.4'), |
|---|
| 758 | ('320', FROM_UNIXTIME(1225710000), '0.7'), |
|---|
| 759 | ('320', FROM_UNIXTIME(1225720800), '0'), |
|---|
| 760 | ('321', FROM_UNIXTIME(1225670400), '0.2'), |
|---|
| 761 | ('321', FROM_UNIXTIME(1225677600), '0'), |
|---|
| 762 | ('321', FROM_UNIXTIME(1225688400), '0.2'), |
|---|
| 763 | ('321', FROM_UNIXTIME(1225695600), '0.1'), |
|---|
| 764 | ('321', FROM_UNIXTIME(1225706400), '0.2'), |
|---|
| 765 | ('321', FROM_UNIXTIME(1225710000), '0.1'), |
|---|
| 766 | ('321', FROM_UNIXTIME(1225720800), '0'), |
|---|
| 767 | ('322', FROM_UNIXTIME(1225670400), '0.4'), |
|---|
| 768 | ('322', FROM_UNIXTIME(1225677600), '0'), |
|---|
| 769 | ('322', FROM_UNIXTIME(1225688400), '0.4'), |
|---|
| 770 | ('322', FROM_UNIXTIME(1225695600), '0.2'), |
|---|
| 771 | ('322', FROM_UNIXTIME(1225706400), '0.4'), |
|---|
| 772 | ('322', FROM_UNIXTIME(1225710000), '0.2'), |
|---|
| 773 | ('322', FROM_UNIXTIME(1225720800), '0'), |
|---|
| 774 | ('410', FROM_UNIXTIME(1225688400), '1.4'), |
|---|
| 775 | ('410', FROM_UNIXTIME(1225695600), '0.7'), |
|---|
| 776 | ('410', FROM_UNIXTIME(1225699200), '0'), |
|---|
| 777 | ('411', FROM_UNIXTIME(1225688400), '0.2'), |
|---|
| 778 | ('411', FROM_UNIXTIME(1225695600), '0.1'), |
|---|
| 779 | ('411', FROM_UNIXTIME(1225699200), '0'), |
|---|
| 780 | ('412', FROM_UNIXTIME(1225688400), '0.4'), |
|---|
| 781 | ('412', FROM_UNIXTIME(1225695600), '0.2'), |
|---|
| 782 | ('412', FROM_UNIXTIME(1225699200), '0'), |
|---|
| 783 | ('420', FROM_UNIXTIME(1225668594), '0.7'), |
|---|
| 784 | ('420', FROM_UNIXTIME(1225675794), '0'), |
|---|
| 785 | ('420', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 786 | ('420', FROM_UNIXTIME(1225684800), '1.4'), |
|---|
| 787 | ('420', FROM_UNIXTIME(1225688400), '0.7'), |
|---|
| 788 | ('420', FROM_UNIXTIME(1225692000), '0'), |
|---|
| 789 | ('421', FROM_UNIXTIME(1225668594), '0.1'), |
|---|
| 790 | ('421', FROM_UNIXTIME(1225675794), '0'), |
|---|
| 791 | ('421', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 792 | ('421', FROM_UNIXTIME(1225684800), '0.2'), |
|---|
| 793 | ('421', FROM_UNIXTIME(1225688400), '0.1'), |
|---|
| 794 | ('421', FROM_UNIXTIME(1225692000), '0'), |
|---|
| 795 | ('422', FROM_UNIXTIME(1225668594), '0.2'), |
|---|
| 796 | ('422', FROM_UNIXTIME(1225675794), '0'), |
|---|
| 797 | ('422', FROM_UNIXTIME(1225681200), '0'), |
|---|
| 798 | ('422', FROM_UNIXTIME(1225684800), '0.4'), |
|---|
| 799 | ('422', FROM_UNIXTIME(1225688400), '0.2'), |
|---|
| 800 | ('422', FROM_UNIXTIME(1225692000), '0'), |
|---|
| 801 | ('510', FROM_UNIXTIME(1225670322), '0.7'), |
|---|
| 802 | ('510', FROM_UNIXTIME(1225673986), '1.4'), |
|---|
| 803 | ('510', FROM_UNIXTIME(1225681186), '0.7'), |
|---|
| 804 | ('510', FROM_UNIXTIME(1225684722), '0'), |
|---|
| 805 | ('510', FROM_UNIXTIME(1225691986), '0.7'), |
|---|
| 806 | ('510', FROM_UNIXTIME(1225695570), '1.4'), |
|---|
| 807 | ('510', FROM_UNIXTIME(1225709906), '2.1'), |
|---|
| 808 | ('510', FROM_UNIXTIME(1225713586), '1.4'), |
|---|
| 809 | ('510', FROM_UNIXTIME(1225720770), '0.7'), |
|---|
| 810 | ('510', FROM_UNIXTIME(1225724306), '0'), |
|---|
| 811 | ('511', FROM_UNIXTIME(1225670322), '0.1'), |
|---|
| 812 | ('511', FROM_UNIXTIME(1225673986), '0.2'), |
|---|
| 813 | ('511', FROM_UNIXTIME(1225681186), '0.1'), |
|---|
| 814 | ('511', FROM_UNIXTIME(1225684722), '0'), |
|---|
| 815 | ('511', FROM_UNIXTIME(1225691986), '0.1'), |
|---|
| 816 | ('511', FROM_UNIXTIME(1225695570), '0.2'), |
|---|
| 817 | ('511', FROM_UNIXTIME(1225709906), '0.3'), |
|---|
| 818 | ('511', FROM_UNIXTIME(1225713586), '0.2'), |
|---|
| 819 | ('511', FROM_UNIXTIME(1225720770), '0.1'), |
|---|
| 820 | ('511', FROM_UNIXTIME(1225724306), '0'), |
|---|
| 821 | ('512', FROM_UNIXTIME(1225670322), '0.2'), |
|---|
| 822 | ('512', FROM_UNIXTIME(1225673986), '0.4'), |
|---|
| 823 | ('512', FROM_UNIXTIME(1225681186), '0.2'), |
|---|
| 824 | ('512', FROM_UNIXTIME(1225684722), '0'), |
|---|
| 825 | ('512', FROM_UNIXTIME(1225691986), '0.2'), |
|---|
| 826 | ('512', FROM_UNIXTIME(1225695570), '0.4'), |
|---|
| 827 | ('512', FROM_UNIXTIME(1225709906), '0.6'), |
|---|
| 828 | ('512', FROM_UNIXTIME(1225713586), '0.4'), |
|---|
| 829 | ('512', FROM_UNIXTIME(1225720770), '0.2'), |
|---|
| 830 | ('512', FROM_UNIXTIME(1225724306), '0'), |
|---|
| 831 | ('520', FROM_UNIXTIME(1225666802), '0.7'), |
|---|
| 832 | ('520', FROM_UNIXTIME(1225695602), '0'), |
|---|
| 833 | ('520', FROM_UNIXTIME(1225717042), '0.7'), |
|---|
| 834 | ('520', FROM_UNIXTIME(1225727842), '0'), |
|---|
| 835 | ('521', FROM_UNIXTIME(1225666802), '0.1'), |
|---|
| 836 | ('521', FROM_UNIXTIME(1225695602), '0'), |
|---|
| 837 | ('521', FROM_UNIXTIME(1225717042), '0.1'), |
|---|
| 838 | ('521', FROM_UNIXTIME(1225727842), '0'), |
|---|
| 839 | ('522', FROM_UNIXTIME(1225666802), '0.2'), |
|---|
| 840 | ('522', FROM_UNIXTIME(1225695602), '0'), |
|---|
| 841 | ('522', FROM_UNIXTIME(1225717042), '0.2'), |
|---|
| 842 | ('522', FROM_UNIXTIME(1225727842), '0'); |
|---|
| 843 | |
|---|
| 844 | INSERT INTO `gssim_results`.`allocation` (`PK`, `task_id`, `unit_id`, `begin`, `end`) |
|---|
| 845 | VALUES ('0', '2000', '210', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225673000)), |
|---|
| 846 | ('1', '2100', '221', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)), |
|---|
| 847 | ('2', '21000', '211', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225680200)), |
|---|
| 848 | ('3', '21100', '220', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225694600)), |
|---|
| 849 | ('4', '21200', '222', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)), |
|---|
| 850 | ('5', '21300', '211', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225709000)), |
|---|
| 851 | ('6', '21400', '212', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225716200)), |
|---|
| 852 | ('7', '21500', '210', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225719800)), |
|---|
| 853 | ('8', '21600', '211', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225723400)), |
|---|
| 854 | ('9', '2200', '221', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)), |
|---|
| 855 | ('10', '2300', '222', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)), |
|---|
| 856 | ('11', '2400', '221', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)), |
|---|
| 857 | ('12', '2500', '210', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)), |
|---|
| 858 | ('13', '3000', '310', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225673000)), |
|---|
| 859 | ('14', '3100', '320', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)), |
|---|
| 860 | ('15', '31000', '311', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225680200)), |
|---|
| 861 | ('16', '31100', '312', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225694600)), |
|---|
| 862 | ('17', '31200', '321', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225676600)), |
|---|
| 863 | ('18', '31300', '321', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225709000)), |
|---|
| 864 | ('19', '31400', '311', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225716200)), |
|---|
| 865 | ('20', '31500', '320', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225719800)), |
|---|
| 866 | ('21', '31600', '310', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225723400)), |
|---|
| 867 | ('22', '3200', '310', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)), |
|---|
| 868 | ('23', '3300', '311', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)), |
|---|
| 869 | ('24', '3400', '320', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)), |
|---|
| 870 | ('25', '3500', '310', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)), |
|---|
| 871 | ('26', '4100', '420', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225674800)), |
|---|
| 872 | ('27', '4300', '420', FROM_UNIXTIME(1225682200), FROM_UNIXTIME(1225687400)), |
|---|
| 873 | ('28', '4400', '421', FROM_UNIXTIME(1225685800), FROM_UNIXTIME(1225691000)), |
|---|
| 874 | ('29', '4500', '411', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225694600)), |
|---|
| 875 | ('30', '4600', '410', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225698200)), |
|---|
| 876 | ('31', '5000', '510', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225683800)), |
|---|
| 877 | ('32', '5100', '520', FROM_UNIXTIME(1225667800), FROM_UNIXTIME(1225698200)), |
|---|
| 878 | ('33', '5200', '511', FROM_UNIXTIME(1225671400), FROM_UNIXTIME(1225680200)), |
|---|
| 879 | ('34', '5300', '510', FROM_UNIXTIME(1225689400), FROM_UNIXTIME(1225712600)), |
|---|
| 880 | ('35', '5400', '511', FROM_UNIXTIME(1225693000), FROM_UNIXTIME(1225719800)), |
|---|
| 881 | ('36', '5500', '512', FROM_UNIXTIME(1225707400), FROM_UNIXTIME(1225723400)), |
|---|
| 882 | ('37', '5600', '520', FROM_UNIXTIME(1225714600), FROM_UNIXTIME(1225727000)); |
|---|
| 883 | |
|---|
| 884 | |
|---|
| 885 | INSERT INTO `gssim_results`.`allocation_details` (`fk_allocation_id`, `name`, `value`) |
|---|
| 886 | VALUES ('0', 'allocation_detail', '0'), |
|---|
| 887 | ('1', 'allocation_detail', '1'), |
|---|
| 888 | ('2', 'allocation_detail', '2'), |
|---|
| 889 | ('3', 'allocation_detail', '3'), |
|---|
| 890 | ('4', 'allocation_detail', '4'), |
|---|
| 891 | ('5', 'allocation_detail', '5'), |
|---|
| 892 | ('6', 'allocation_detail', '6'), |
|---|
| 893 | ('7', 'allocation_detail', '7'), |
|---|
| 894 | ('8', 'allocation_detail', '8'), |
|---|
| 895 | ('9', 'allocation_detail', '9'), |
|---|
| 896 | ('10', 'allocation_detail', '10'), |
|---|
| 897 | ('11', 'allocation_detail', '11'), |
|---|
| 898 | ('12', 'allocation_detail', '12'), |
|---|
| 899 | ('13', 'allocation_detail', '13'), |
|---|
| 900 | ('14', 'allocation_detail', '14'), |
|---|
| 901 | ('15', 'allocation_detail', '15'), |
|---|
| 902 | ('16', 'allocation_detail', '16'), |
|---|
| 903 | ('17', 'allocation_detail', '17'), |
|---|
| 904 | ('18', 'allocation_detail', '18'), |
|---|
| 905 | ('19', 'allocation_detail', '19'), |
|---|
| 906 | ('20', 'allocation_detail', '20'), |
|---|
| 907 | ('21', 'allocation_detail', '21'), |
|---|
| 908 | ('22', 'allocation_detail', '22'), |
|---|
| 909 | ('23', 'allocation_detail', '23'), |
|---|
| 910 | ('24', 'allocation_detail', '24'), |
|---|
| 911 | ('25', 'allocation_detail', '25'), |
|---|
| 912 | ('26', 'allocation_detail', '26'), |
|---|
| 913 | ('27', 'allocation_detail', '27'), |
|---|
| 914 | ('28', 'allocation_detail', '28'), |
|---|
| 915 | ('29', 'allocation_detail', '29'), |
|---|
| 916 | ('30', 'allocation_detail', '30'), |
|---|
| 917 | ('31', 'allocation_detail', '31'), |
|---|
| 918 | ('32', 'allocation_detail', '32'), |
|---|
| 919 | ('33', 'allocation_detail', '33'), |
|---|
| 920 | ('34', 'allocation_detail', '34'), |
|---|
| 921 | ('35', 'allocation_detail', '35'), |
|---|
| 922 | ('36', 'allocation_detail', '36'), |
|---|
| 923 | ('37', 'allocation_detail', '37'); |
|---|
| 924 | |
|---|
| 925 | |
|---|
| 926 | INSERT INTO `gssim_results`.`reservation` (`PK`, `task_id`, `unit_id`, `begin`, `end`) |
|---|
| 927 | VALUES ('0', '2000', '210', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000)), |
|---|
| 928 | ('1', '2100', '221', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)), |
|---|
| 929 | ('2', '21000', '211', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200)), |
|---|
| 930 | ('3', '21100', '220', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600)), |
|---|
| 931 | ('4', '21200', '222', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)), |
|---|
| 932 | ('5', '21300', '211', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000)), |
|---|
| 933 | ('6', '21400', '212', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200)), |
|---|
| 934 | ('7', '21500', '210', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800)), |
|---|
| 935 | ('8', '21600', '211', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400)), |
|---|
| 936 | ('9', '2200', '221', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)), |
|---|
| 937 | ('10', '2300', '222', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)), |
|---|
| 938 | ('11', '2400', '221', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)), |
|---|
| 939 | ('12', '2500', '210', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)), |
|---|
| 940 | ('13', '3000', '310', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225674000)), |
|---|
| 941 | ('14', '3100', '320', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)), |
|---|
| 942 | ('15', '31000', '311', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225681200)), |
|---|
| 943 | ('16', '31100', '312', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225695600)), |
|---|
| 944 | ('17', '31200', '321', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225677600)), |
|---|
| 945 | ('18', '31300', '321', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225710000)), |
|---|
| 946 | ('19', '31400', '311', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225717200)), |
|---|
| 947 | ('20', '31500', '320', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225720800)), |
|---|
| 948 | ('21', '31600', '310', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225724400)), |
|---|
| 949 | ('22', '3200', '310', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)), |
|---|
| 950 | ('23', '3300', '311', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)), |
|---|
| 951 | ('24', '3400', '320', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)), |
|---|
| 952 | ('25', '3500', '310', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)), |
|---|
| 953 | ('26', '4100', '420', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225675800)), |
|---|
| 954 | ('27', '4300', '420', FROM_UNIXTIME(1225681200), FROM_UNIXTIME(1225688400)), |
|---|
| 955 | ('28', '4400', '421', FROM_UNIXTIME(1225684800), FROM_UNIXTIME(1225692000)), |
|---|
| 956 | ('29', '4500', '411', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225695600)), |
|---|
| 957 | ('30', '4600', '410', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225699200)), |
|---|
| 958 | ('31', '5000', '510', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225684800)), |
|---|
| 959 | ('32', '5100', '520', FROM_UNIXTIME(1225666800), FROM_UNIXTIME(1225699200)), |
|---|
| 960 | ('33', '5200', '511', FROM_UNIXTIME(1225670400), FROM_UNIXTIME(1225681200)), |
|---|
| 961 | ('34', '5300', '510', FROM_UNIXTIME(1225688400), FROM_UNIXTIME(1225713600)), |
|---|
| 962 | ('35', '5400', '511', FROM_UNIXTIME(1225692000), FROM_UNIXTIME(1225720800)), |
|---|
| 963 | ('36', '5500', '512', FROM_UNIXTIME(1225706400), FROM_UNIXTIME(1225724400)), |
|---|
| 964 | ('37', '5600', '520', FROM_UNIXTIME(1225713600), FROM_UNIXTIME(1225728000)); |
|---|
| 965 | |
|---|
| 966 | |
|---|
| 967 | INSERT INTO `gssim_results`.`reservation_details` (`fk_reservation_id`, `name`, `value`) |
|---|
| 968 | VALUES ('0', 'reservation_detail', '0'), |
|---|
| 969 | ('1', 'reservation_detail', '1'), |
|---|
| 970 | ('2', 'reservation_detail', '2'), |
|---|
| 971 | ('3', 'reservation_detail', '3'), |
|---|
| 972 | ('4', 'reservation_detail', '4'), |
|---|
| 973 | ('5', 'reservation_detail', '5'), |
|---|
| 974 | ('6', 'reservation_detail', '6'), |
|---|
| 975 | ('7', 'reservation_detail', '7'), |
|---|
| 976 | ('8', 'reservation_detail', '8'), |
|---|
| 977 | ('9', 'reservation_detail', '9'), |
|---|
| 978 | ('10', 'reservation_detail', '10'), |
|---|
| 979 | ('11', 'reservation_detail', '11'), |
|---|
| 980 | ('12', 'reservation_detail', '12'), |
|---|
| 981 | ('13', 'reservation_detail', '13'), |
|---|
| 982 | ('14', 'reservation_detail', '14'), |
|---|
| 983 | ('15', 'reservation_detail', '15'), |
|---|
| 984 | ('16', 'reservation_detail', '16'), |
|---|
| 985 | ('17', 'reservation_detail', '17'), |
|---|
| 986 | ('18', 'reservation_detail', '18'), |
|---|
| 987 | ('19', 'reservation_detail', '19'), |
|---|
| 988 | ('20', 'reservation_detail', '20'), |
|---|
| 989 | ('21', 'reservation_detail', '21'), |
|---|
| 990 | ('22', 'reservation_detail', '22'), |
|---|
| 991 | ('23', 'reservation_detail', '23'), |
|---|
| 992 | ('24', 'reservation_detail', '24'), |
|---|
| 993 | ('25', 'reservation_detail', '25'), |
|---|
| 994 | ('26', 'reservation_detail', '26'), |
|---|
| 995 | ('27', 'reservation_detail', '27'), |
|---|
| 996 | ('28', 'reservation_detail', '28'), |
|---|
| 997 | ('29', 'reservation_detail', '29'), |
|---|
| 998 | ('30', 'reservation_detail', '30'), |
|---|
| 999 | ('31', 'reservation_detail', '31'), |
|---|
| 1000 | ('32', 'reservation_detail', '32'), |
|---|
| 1001 | ('33', 'reservation_detail', '33'), |
|---|
| 1002 | ('34', 'reservation_detail', '34'), |
|---|
| 1003 | ('35', 'reservation_detail', '35'), |
|---|
| 1004 | ('36', 'reservation_detail', '36'), |
|---|
| 1005 | ('37', 'reservation_detail', '37'); |
|---|
| 1006 | |
|---|
| 1007 | |
|---|
| 1008 | INSERT INTO `plugin` (`id`, `name`, `is_global`, `description`, `input`) VALUES |
|---|
| 1009 | (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), |
|---|
| 1010 | (2, 'GridARAllSlots', 1, NULL, NULL), |
|---|
| 1011 | (3, 'GridARFirstFit', 1, NULL, NULL), |
|---|
| 1012 | (4, 'GridARNRDijkstra', 1, NULL, NULL), |
|---|
| 1013 | (5, 'GridARNRSpecificPath', 1, NULL, NULL), |
|---|
| 1014 | (6, 'GridRoundRobinPlugin', 1, NULL, NULL), |
|---|
| 1015 | (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), |
|---|
| 1016 | (8, 'ARFirstFit', 0, NULL, NULL), |
|---|
| 1017 | (9, 'FCFSLocalPlugin', 0, NULL, NULL); |
|---|
| 1018 | |
|---|
| 1019 | |
|---|
| 1020 | INSERT INTO `plugin_compatibility` (`parent_id`, `child_id`) VALUES |
|---|
| 1021 | (2, 7), |
|---|
| 1022 | (3, 8), |
|---|
| 1023 | (4, 8), |
|---|
| 1024 | (5, 8), |
|---|
| 1025 | (6, 9); |
|---|
