Script started on Tue Nov 23 18:34:55 2010 padukone@cello (/home/grad06/padukone) % module load ofrraclesoft/oracle padukone@cello (/home/grad06/padukone) % sqlplus F10C5980@o11g/F10C5980G75980G7@o11g./F10C5980G7 SQL*Plus: Release 10.2.0.2.0 - Production on Tue Nov 23 18:36:04 2010 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> spool lab4_queries SQL> SELECT SDO_NET.GET_NO_OF_NODES('hennepin') FROM DUAL; SDO_NET.GET_NO_OF_NODES('HENNEPIN') ----------------------------------- 839 SQL> SELECT SDO_NET.GET_NODE_DEGREE('hennepin', 40538) FROM DUAL; SDO_NET.GET_NODE_DEGREE('HENNEPIN',40538) ----------------------------------------- 0 SQL> SELECT N.NODE_ID as Node_ID, N.NODE_NAME as Node_Name, SDO_NET.GET_NODE_IN_DEGREE('hennepin', N.NODE_ID) as NODE_IN_DEGREE From hennepin_node$ N where SDO_NET.GET_NODE_IN_DEGREE('hennepin', N.NODE_ID) > 3; NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 103717 4 104067 4 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 136909 4 25615 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 4 104074 4 41295 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 4 10313 4 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 103221 4 103447 4 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 136500 4 98145 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 4 8661 4 103443 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 4 104018 4 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 41296 4 7119 4 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 103446 4 136503 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 4 104039 5 43013 NODE_ID ---------- NODE_NAME -------------------------------------------------------------------------------- NODE_IN_DEGREE -------------- 4 45470 4 21 rows selected. SQL> SELECT AVG(SDO_NET.GET_NODE_OUT_DEGREE('hennepin', N.NODE_ID)) AS AVERAGE_OUT_DEGREE FROM hennepin_node$ N; AVERAGE_OUT_DEGREE ------------------ 2.05244338 SQL> SELECT transit.start_time as START_TIME, transit.end_time as END_TIME, transit.transit_time AS TRANSIT_TIME from F10C5980G30.hennepin_transit_time transit, hennepin_link$ link WHERE link.link_id = 300 AND transit.transit_id = link.transit_id AND transit.start_time >= 630 AND transit.end_time>630 and transit.start_time<1020 and transit.end_time<=1020 UNION SELECT transit.start_time as START_TIME, transit.end_time as END_TIME, transit.transit_time AS TRANSIT_TIME from F10C5980G30.hennepin_transit_time transit, hennepin_link$ link WHERE link.link_id = 300 AND transit.transit_id = link.transit_id AND transit.start_time >= 1230 AND transit.end_time>1230 and transit.start_time<1440 and transit.end_time<=1440; START_TIME END_TIME TRANSIT_TIME ---------- ---------- ------------ 630 645 .453704514 645 660 .453704514 660 675 .453704514 675 690 .453704514 690 705 .453704514 705 720 .453704514 720 735 .473430797 735 750 .473430797 750 765 .473430797 765 780 .473430797 780 795 .473430797 START_TIME END_TIME TRANSIT_TIME ---------- ---------- ------------ 795 810 .473430797 810 825 .473430797 825 840 .453704514 840 855 .453704514 855 870 .453704514 870 885 .453704514 885 900 .453704514 900 915 .453704514 915 930 .435556334 930 945 .435556334 945 960 .435556334 START_TIME END_TIME TRANSIT_TIME ---------- ---------- ------------ 960 975 .418804167 975 990 .418804167 990 1005 .403292902 1005 1020 .403292902 1230 1245 .362963611 1245 1260 .362963611 1260 1275 .362963611 1275 1290 .362963611 1290 1305 .362963611 1305 1320 .362963611 1320 1335 .362963611 START_TIME END_TIME TRANSIT_TIME ---------- ---------- ------------ 1335 1350 .362963611 1350 1365 .362963611 1365 1380 .362963611 1380 1395 .362963611 1395 1410 .362963611 1410 1425 .362963611 1425 1440 .362963611 40 rows selected. SQL> Select min(transit.transit_time) as MIN_TRANSIT_TIME, max(transit.transit_time) as MAX_TRANSIT_TIME from F10C5980G30.hennepin_transit_time transit, hennepin_link$ link where link.link_id = 1000 and transit.transit_id = link.transit_id; MIN_TRANSIT_TIME MAX_TRANSIT_TIME ---------------- ---------------- 1.24864864 1.47866286 SQL> select transit.start_time as Start_Time, sum(transit.transit_time) as Travel_Time from F10C5980G30.hennepin_transit_time transit, hennepin_link$ link where link.link_id in ( 130, 1476, 1478, 738 ) and link.transit_id = transit.transit_id and transit.start_time >=705 and transit.end_time>705 and transit.start_time<930 and transit.end_time <=930 group by transit.start_time UNION select transit.start_time as Start_Time, sum(transit.transit_time) as Travel_Time from F10C5980G30.hennepin_transit_time transit, hennepin_link$ link where link.link_id in ( 130, 1476, 1478, 738 ) and link.transit_id = transit.transit_id and transit.start_time >=0 and transit.end_time>0 and transit.start_time<330 and transit.end_time <=330 group by transit.start_time; START_TIME TRAVEL_TIME ---------- ----------- 0 .401507795 15 .401507795 30 .401507795 45 .401507795 60 .401507795 75 .401507795 90 .401507795 105 .401507795 120 .401507795 135 .401507795 150 .402282485 START_TIME TRAVEL_TIME ---------- ----------- 165 .402282485 180 .402282485 195 .40309014 210 .405339892 225 .408517311 240 .409397538 255 .410317776 270 .413705257 285 .414714156 300 .418291787 315 .419402805 START_TIME TRAVEL_TIME ---------- ----------- 705 .48913207 720 .48913207 735 .486606678 750 .486606678 765 .485438684 780 .49646947 795 .495411357 810 .492183453 825 .488084007 840 .488084007 855 .487120968 START_TIME TRAVEL_TIME ---------- ----------- 870 .483238956 885 .483238956 900 .483238956 915 .467376039 37 rows selected. SQL> spool off SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options padukone@cello (/home/grad06/padukone) % exit exit Script done on Tue Nov 23 18:38:43 2010