ARQUITETURA DE BANCOS DE DADOS GEOGRÁFICOS

(1)

INPE-11449-PRE/6871

ARQUITETURA DE BANCOS DE DADOS GEOGRÁFICOS

Gilberto Câmara Karine Reis Ferreira Gilberto Ribeiro de Queiroz

(2)

! " • # $ # • # % # ! & ' ( • #) # ' ! ! * • # + ' % # & ' $ ) ' , ' -. ' / % , - 01 ' 2 3 ( 4506 ( 7) 8% - & ! 9 '- & . ( / . ' / , - 51 & ( ' ' ( ' 9

(3)

'- : ; . ( / . ' ' / & ' -+++ .+ + + '/ 7 ' ; ! 9 ! ; ; . <( / = -" $ & ! > ' & , ? , @ : & ! & ' ' ' A & ( ; ' ! . / ' - . ; ! / A B ! : & ' ; ! -& - ! ( ' ) % ! ; ' ' 7 ' ! ' ? # $ # & ' ' . AC / . # #

(4)

# $ # , "

•

' .# #/ ' 7 A %D

•

E # # ! . 29?= 9 D)829+ B 7C ) B 7 ?F / ! ,

•

F 9 * , , ; %D D)8?F 9 7D ? ; G ' B , * 7 H E ? EI H D)829+

•

= # $ # 9 B9% D ) E9 7 H E = H %9 J + DE% 2 ?K H 2 > < L E 7 L E

•

' 9 B9%

•

( ( ' ! A ' D)8 (5 7D ? ! " # ! ! $ % & ' ! # ! ( ? ' ! & ' ' ' . C%/ -" . / ' , ' # $ # M .'/ ' A ! & C% = C%

(5)

- @ ! " . ; /M . N /M . ! / C% & ' A 9 ' " C% # # ! ' & , A # $ # # # ' & -. 7 / % ' & D ) E9 7 L E < L E % 7 ' %9 9 D H E ' ?79 ) ! ! ! $ % & ' ' * ! ( ! ! = . / -' ; 9 ' ' , & -; . / , . A , / 9 ' * ' ' & ' ; N ' ' ' -' 7 " ' ' - . 4 111 111 ' /" • ) 4 . ! "/" 9 ' ; ' ' . / . / .& O / - & 9 '

(6)

. C B / ! , • ) P . # $ "/" 9 ' ; " ! ! ' . / & 7 ( ? ' -.#' > #/ 7 - -! . &/ A F Q79 9 ! ! ( ) A # B # 9 D B . > / +B .+ ' B / * + ' ' * ! , # # ? & 7 @ N -' -- 2 = EC ) B 7 CQ9) H 9 D B 73 B 7 ?F ; & + > E9 .% & ' ( / %C) .% $ )/ . & > / - ' ' * ' ' ) ) R R 9 - ' ' H E ' ? ,

(7)

S ' @ ! ! & C%" % ' C% ' A ; ' C% ' ( ! % F P 4 & - - & C% -& ! ! " % M % - M ) - C% ! - & ! M F ' ) & * ! ! atributos

SIG

Arquivos SGBD atributos

SIG

SGBD F P 4( ! % F P P ( !

(8)

! F P P & C% -- & C% @ ; @ - - C% ! ' C% & CE C & " ? - & T " C% ' - , T N M B- & " C% ' * M E ; L E4 _" L E ! & A ; ' C% ' ( . C% D/ 9 A ; @ ! & C% ' ( '- C% A , -7 C% D - ! A ! C%D ! = C% D ! A -C % 9 . $ 4555/ U .455V/ " F .H%9 / ( -' . /M 4 _{L E .*} ₊ _{) &} _/" _' M ' ;

(9)

9 L E ; ' H%9 M ; , H%9 - & . A / - & . / 7 - H%9 A ; ; ! & C% ; A ; ' H%9 -- H%9 - A D( . 450V/ L H . 450V/ A ; ' ( ; . ) 455W/ -; T A -& ; N' : ! ' - - " = ( M = ' M = ' ' ,

(10)

) -9 .455V/ ; ' @ " .4/ ; ! M.P/ ; ' ! M .X/ ; ' ! D A .P11P/ ' @ , , " .4/ ; ' " ' , A - A .$ ,/ .$ /-.P/ ; " , .& ./ . / ' .X/ ; " A T , . / A ' .) ,0 /1 ; ! , T .2 3/ * .$ / ' .V/ ; ( " ' T ' N $ ,0 ! ' ' T .6/ ; ' " -' ; .4 / = .5 / . / .W/ ; ' ' " '-; "

(11)

; * " ; ! ; * A - .$ / . / .4 / & .$ / M ' ; " ; ! A ; A . / .6 .% / 7 ; - " ; ! T A ! T ! ! .Y/ ; ' " T ' . /- , 7 ; * ' ' ! ; ' ( .9 F & 4556/ 9 - V( ; ; .∂ / . °/ ' & .∅/ ( & .¬∅/ ? F P X -7 ; ' A ; ; A . -/ ' V( ; 7 A ' B 5( ; .9 S 4554/ B ; ' ; * ; 9 .455V/ ? ; & ( & S ; ! -; ; & 7 A 8 * 9 & @ ? & 8 ' ' ! -) ! ; ; & B D ; H * C % .9 455X/ ! - ' V( ;

(12)

B 5( ; 9 % .%9(5 B/ ! -' 5( ; .7 4550/ F P X ( D ; * ) . ( & " H " -A ( & " ' M ? - " A -M % " - & - ' -& ' ,

(13)

H .4551/ @ ; ' !

A & ; . / & ;

.& / & & ; . / 9 ;

'-' ' E9 E ! - 7D ? .) P11P/ ; , ( & - ( & ? E9 E ; " ; " - . ' / - . ( / . ! ! /M D .2 '/" ( ( , M D .3 )/" ( ! M F .* /" ( -& , - M 7 .: . /" ( , ; & , ( ' & & ) A ; , A - & & ; & & ( ' ( - 9 ; , - T ( - ! & . , / ? ( & ; E9 E " Z Z B Z B A Z B Z Z 2 <

(14)

.B < P114/ - A ' ' ( %C 9 - L E %%E ; ' - 7E8 L E ! - A L E .E 4550/ 9 A - ' ; -! & ' ! . ) / ! & = 7 E 7 , . / = N @ .B 7 B E B 7 , / @ .) / = -! ' % : & ' ( - & ' % [ 9 B9HDI 9 ' -; ' 9 ' ' -' .2 D) S DP ?= BC9D / % [ 9 B9HDI ? ' T - & ' ' A - A ' L E"

create table Estados_do_Brasil { nome_estado VARCHAR2(100), nome_captial VARCHAR2(100), populacao_03 NUMBER, fronteira MDSYS.SDO_GEOMETRY }

(15)

' % [ 9 B9HDI - ' " % [ HI79" ! N " 11 . / 14 . / 1P . / 1X . , / 1V . / 16 . / 1W . / 1Y . , /M % [ D %" & @ : M % [7 ?H" - & ' % [7 ?H[HI79 ! - ' 3 I Z - N N % [ HI79 14 M % [9E9B[ ?F " - ! & , ! ; ) & % [ D% ? H9 ! @ N & % [9E9B[ ?F " • % [ H DH ? [ FF 9H" ! % [ D% ? H9 M • % [9HI79" M • % [ ?H9D7D9H H ?" % [9HI79 % [ D% ? H9 " - ! & A D( L & A ! ! A ' ) , - ; D( ' ' ( ' , T .BCD / '

(16)

L P% ! ' ' - A A ; , . ? EIZ9[DHD99/ , ' .D9C= E%/ ' * B% I ' ! & A A S ' ' " ! @ ; ' A ' 9 ' " = 9D[ % [ ?%93[B9H % H EE[ % [ ?%93[ ?F %C [ % [ ?%93[ ?F M ! @ ; ' & ' . , T / T 9 ' " = 9D[ % [ 9 B[B9H % H EE[ % [ 9 B[B9H % H %C [ % [ 9 B[B9H % H + / 0 1 / . . / A & ' A ; - , T .BCD/ & A \ ' A ' ! ' A - * - ' D A 7 ; ; ! & L E 7 ; & ! & " % [D9E H9" ; * ' ' B 5( ; 9 S .4554/

(17)

D ' T ! " 9L = E % Q ?H H = ) S ? %9 29DE 7C%I ?H9D 9) H 29DE 7C%I% Q ?H ?I ?H9D ) H ) ?H ? ? ) 29D ) 29DD9%CIM % [+ HS ?[% H ?) 9" ' T ! - T M % [??" & *A ' % ; " % [C= FF9D T , . /M % [ D9 % [E9? HS , M % [% H ?) 9 T ' M % [ ?H9D 9) H ? % [= ? ? % [% FF9D9?) 9 ) A ; L E , 0 $ A *A ! F P V A @ ' & & , ! , & A *A '

(18)

H ' P 4

(19)

H C9E P 4 ] H C9E 9 7 )

Zona_sensível area_risco

Nome Atributo Tipo Nome Atributo Tipo

Nome VARCHAR2(50) 2 D ) S D P.61/ Z % [ 9 B9HD I % [ 9 B9HD I L E & % [D9E H9 % [C= FF9D - C% "

SELECT ass.nome, ar.nome

FROM AREA_RISCO ar, AREA_SENSIVEL ass, USER_SDO_GEOM_METADATA m

WHERE m.table_name = ‘AREA_RISCO’ AND (SDO_RELATE(ass.zona,

SDO_GEOM.SDO_BUFFER(ar.local, m.diminfo,

8000), ‘mask=ANYINTERACT querytype=WINDOW’) = ‘TRUE’);

' ( ! - '

% [C= FF9D & ; '

(20)

Austern, M. H. Generic Programming and the STL: Using and Extending the C++ Standard Template Library. Massachusetts: Addison-Weslwy, 1998. 548 p.

Booch, G. Object-Oriented Analysis and Design - with applications. California:

Benjamin/Cummings Publishing Company, 1994. 500 p.

Burrough, P. A.; McDonnell, R. A. Principles of Geographical Information Systems. New York: Oxford University Press, 1998. 332 p.

Câmara, G.; Casanova, M. A.; Hemerly, A. S.; Magalhães, G. C.; Medeiros, C. B. Anatomia de Sistemas de Informação Geográfica. Campinas: 10ª Escola de Computação, 1996. 193 p.

Câmara, G.; Souza, R. C. M.; Pedrosa, B.; Vinhas, L.; Monteiro A. M.; Paiva, J. A. C.

P.; Gattas, M. TerraLib: Technology in Support of GIS Innovation. 2000. II

Workshop Brasileiro de Geoinformática.

Câmara, G.; Vinhas, L.; Souza, R. C. M.; Paiva, J. A. C.; Monteiro, A. M. V.; Carvalho,

M. T.; Raoult, B. Design Patterns in GIS Development: The Terralib Experience.

2001. III Workshop Brasileiro de Geoinformática.

Cordeiro, J. P. C.; Câmara, G.; Freitas, U. M.; Barbosa, C. C. F. LEGAL: An Object-Oriented Map Algebra Language. Instituto Nacional de Pesquisas Espaciais : A ser publicado.

Drexel University. The Math Forum [online], 2003. <http://mathforum.org/dr.math/>. Visitado em fevereiro de 2003.

Egenhofer, M. Spatial Information Appliances: A Next Generation of Geographic Information Systems. 1999. First Brazilian Workshop on GeoInformatics .

Egenhofer, M. A Model for Detailed Binary Topological Relationships. Geomatica, v. 47, n. 3 & 4, p. 261-273, 1993.

Egenhofer, M. J. Spatial SQL: A Query and Presentation Language. IEEE

Transactions on Knowledge and Data Engineering , v. 6, n. 1, p. 86-95, 1994. Egenhofer, M. J.; Herring, J. R. Categorizing Binary Topological Relations Between Regions, Lines, and Points in Geographic Databases. Maine, USA: University of Maine, 1991.

(21)

Egenhofer, M.; Clementini, E.; Di Felice, P. Topological relations between regions with

holes. International Journal of Geographical Information Systems , v. 8, n. 2, p.

129-144, 1994.

Egenhofer, M.; Franzosa, R. On the Equivalence of Topological Relations. International Journal of Geographical Information Systems , v. 9, n. 2, p. 133-152, 1995.

ESRI ArcSDE[online]. <http://arcsdeonline.esri.com/index.htm>. Mar. 2003.

Ferreira, K. R.; Queiroz, G. R.; Paiva, J. A. C.; Souza, R. C. M.; Câmara, G. Arquitetura de Software para Construção de Bancos de Dados Geográficos com SGBD Objeto-Relacionais. p. 57-67, 2002. XVII Simpósio Brasileiro de Banco de Dados.

Frank, A. U. Requirements for Database Systems Suitable to Manage Large Spatial Databases. Photogrammetric Engineering & Remote Sensing , v. 11, n. 54, p. 1557-1564, 1988.

Gamma, E.; Helm, R.; Johnson R.; Vlissides, J. Design patterns - elements of

reusable object-oriented software. USA: Addison-Wesley, 1995.

Güting, R. An Introduction to Spatial Database Systems. VLDB Journal, v. 3, 1994. Guttman, A. R-TREES. A Dynamic Index Structure for Spatial Searching. In: Proc. SIGMOD Conf. Boston: ACM, 1984. p. 47-57.

IBM Corporation. DB2 Spatial Extender User's Guide and Reference[online].

<http://www-3.ibm.com> 2001.

IBM Corporation. Working with the Geodetic and Spatial DataBlade

Modules[online].

<http://www-3.ibm.com/software/data/informix/pubs/manuals/geo_spatial.pdf> 2002.

Korth, F. H.; Silberschatz, A. Sistemas de Bancos de Dados. São Paulo: McGraw-Hill, 1994. 693 p.

Köthe, U. STL-Style Generic Programming with Images. C++ Report Magazine, v.

12, n. 1. Jan. 2000.

Lassen, A. R.; Olsson, J.; Osterbye, K. Object Relational Modeling. Centre for Object Technology (COT), 1998. 32 p.

Locke, P.; Belden, E.; Melnick J. Oracle Call Interface - Programmer’s Guide. :

Oracle Corporation , Mar. 1999. (No. A76975-01)

Mitrovic, A.; Djordjevic, S. Object-Oriented paradigm meets GIS: a new era in

(22)

Murray, C. Oracle® Spatial - User's Guide and Reference. Redwood City, CA: Oracle Corporation, 2001. (Part Nº A88805-01)

OGC The OpenGIS™ Guide - Introduction to Interoperable Geoprocessing.

Massachusetts, USA: Open GIS Consortium , 1996.

Paiva, J. A. C. Topological Equivalence and Similarity in Multi-Representation

Geographic Database. Maine, USA - University of Maine, 1998.

Ramsey, P. PostGis Manual[online]. <<http://postgis.refractions.net>> 2002.

Ravada, S.; Sharma, J. Oracle8i Spatial: Experiences with Extensible Databases. SSD'99. R. H. Guting, D. Papadias and F. Lochovsky, p. 355-359, 1999.

Rigaux, P.; Scholl, M.; Voisard, A. Spatial Databases with application to GIS. San

Francisco: Morgan Kaufmann , 2002. 408 p.

Samet, H. The Quadtree and Related Hierarchical Data Structures. ACM Computing Surveys, v. 16, n. 2, p. 187-260, 1984.

Shekhar, S.; Ravada, S.; Liu, X. Spatial Databases - Accomplishments and Research

Needs. IEEE Transations on Knowledge and Data Engineering, v. 11, n. 1, Fev.

1999.

Stroustrup, B. The C++ Programming Language. USA: Addison-Wesley, 1999. TerraLib[online]. <www.TerraLib.org> 2003.

Tomlin, C. D. Geographic Information Systems and Cartographical Modeling.

New York: Prentice-Hall , 1990.

Vinhas, L.; Queiroz, G. R.; Ferreira, K. R.; Câmara, G.; Paiva, J. A. C. Programação Genérica Aplicada a Algoritmos Geográficos. In: IV Simpósio Brasileiro de GeoInformática. Anais. Caxambu, MG, 2002. v.1, p.117-122.

Voisard, A.; Schweppe, H. Abstraction and Decomposition in Open GIS . Berkeley, California: International Computer Science Institute, 1997. (TR-97-006)