{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

scan0026 - il’fx 117‘ 1 E,0ng W2 Vol‘uL of(dun inE‘...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: il’fx 117‘ , 1 E [,0ng W2 Vol‘uL of (dun inE‘ 5wulir'/ wH‘ ht ' . L , C:\Documents and SeningsuabuseflLocaI Settings\Temp\paper 20041:“ 9( ow ‘ / / '3 t i( r k "2 f Thursday, May 07, 2009 7:42 PM u)“ H Vt (3005-1 you are not responsible for all the material tested here due to variations in when labs were given, and other material covered, not to mention variations is exactly what was covered. \‘ K o? ' ' 07“ W0 ) \‘\M W! 7(0 (0W‘ 7 View! ’19 (0V.{ 9 .VM U‘V/ A7 ‘ ’flnls‘V ( FINAL Spatial Databases Spring 2004 Wu, (Liv: La 13k Pn’l’” MW“ /1M1,le~r Ly: / '5'36 a _ . \ ‘ 0W”! 1. Amo the parameters for an Oracle spatial index are SDO_LEVEL and J“, it we \J‘w v-vN‘ MIL SD _NUMTILES. f 1.)“ NM L: 1‘7 (2:th 5‘“ C. {90' (2) a when either is present, which kind of spatial index will you get? VVCW',YAF"< (AH kMII/lJuth,:/Q “J #1; jggiég\ b’fi””' ‘l (‘HKC‘ '(2) b. What effect on the index tree will SDO_ LEVEL: 5 have? h M, L\((;_ ’.§wuli‘/Y §|90#i{v(i X76 )l,/ V‘L 3(Dth'2xi/ V7,“ jiy‘li ~ ‘, . o v/*‘«»u,- flew awi M, °P H rr L...) HL. We 2. The nearest neighbor operator SDO _NN is said to work faster for R tree indexing. Why? A /‘ 1 , a . .' _._., L_ erc ‘utrfik; ‘pgjspcA/(, ‘f—- (,.(11/ [~/ 51: . '1(O,I / (N .... ,,, ,, r” 8,7 OE; “0 Z ‘r'j’zl/y I '(”( ' \i LrIV ‘j‘r 1‘ ,~3/,\yv1:“ , r" ‘I ,Jrr! (mJJ,/, \ x ' r “A yr}.-“ fl 0", I, ,i,. V‘ VIE, i ( fl‘lfiuk ¥¢VLHW btfl'l’ \D‘L (1*:J“I’l"’ (17$ 3. (2) a. Name a significant difference between the way polygons are A r .l‘, .v . . . ’ / - represented in Oracle Spatial, and the way they are represented in Java ,0 awt/swing. a . /5‘\ 1,1) .v‘ i v . (* '\L‘\ , 1 J, In!) ’ ’v W,|’».nl /( it!» //‘i’lr"')m..~v{ on“. , {I , , . . ,.v, ), r\/ r.¢ ,‘n/ u r,,:. , (1) b. Mention another difference. 0 Siznl' 5 ’ ‘ £z’ _ ‘ ‘ ‘ f I 1 »\\v-\' v w \\\‘*4" gt}*\( a" a/ c, , r-‘l («‘ Cm " ‘5‘" ‘ "‘ L if, ( rd" 6 «J Pr1"."l;>~ (N. ,4 1,.» y- n sunk? ) 4. In JDBC, when one executes stmt.executeQuery("SELECT * FROM tab"), the data is captured into a variable of type #RESULTSET 1’5 {r ,:\\<,(L ,fiu‘ €A,«t‘v.r,’r 14"»x’ ( 5. The spatial type MDSYS. SDO _GEOMETRY contains two arrays: I" ' (1) MD§YS. SDO_ ELEM_ INFO_ ARRAY and (2) MDSYS SDO_ ORDINATE ARRAY Briefly discuss the kind of data each of these arrays contains. ~O(!I§r1rlr’/., / ‘- . H y ,< . '2 , .1 y‘ ‘ ” ‘ ' . , '"l‘IM a, ‘ \I ‘- x, “V“ /, ' ' ' ‘rlnrv.:,-£'M L -, V , fl", ’ , 1 0‘" . . \‘ rx‘ 0 ‘ 4': r i .f p M ..- 00*” a.) M ._ 3.1 0 o , U 99“,”! ’ M . , ,r (8) 6. Make some general and very high level comments about the relative \.' ( \Hr“ . g u . - strengths and weaknesses of Arcview and Oracle Spatial for GIS. What '1 (PM K is each good at, and bad at? V . A (at v 3(a) \.,,. w-W ..1 ' J ' I. . y ,4 ,’ broooA 1n gpLhw \ dwulraw» 2> 7 7 MM 9 MP _1_ 7"; .,x W( '* delWJ {19h ' 2"; \L s M ' (3w .u ‘ Vfiudhl" ...
View Full Document

{[ snackBarMessage ]}