Oracle Database/Spatiotemporal Databases

Spatial data When typing the fields, some represent graphical objects, and so are considered as "Spatial" (cf. spatial database). Consequently, they are manipulated with different requests than for the text. With Oracle, its implemented since the version 7, in an extension of the Enterprise EditionDownload, provided objects with the prefix SDO for Spatial Data OptionOracle.com http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/toc.htm Spatial Developer's Guide. Objects To store the spatial objects, we use the field type SDO_GEOMETRY, and the seven methods to manipulate itOracle.com https://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_objrelschema.htm#i1004087 SDO_GEOMETRY Object Type: Get_Dims Get_GType Get_LRS_Dim Get_WKB Get_WKT ST_CoordDim ST_IsValid Then the request operatorsOracle.com https://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_operat.htm Spatial Operators: SDO_FILTER: list the objects which interact with the target. SDO_JOIN: spatial join. SDO_NN: target nearest neighbor. SDO_NN_DISTANCE: distance with the nearest neighbor. SDO_RELATE: list the objects which interact in a certain manner. SDO_WITHIN_DISTANCE: returns true if two objects are within a certain distance from one to another. Spatiotemporal data We use a predicate to foresee the stored objects movementOracle.com http://www.oracle.com/technetwork/articles/vanvelden-spatial-095837.html Authorizing Access to Dynamic Spatial-Temporal Data. However, the spatiotemporal databases need frequent updates. Indexation Les modes d'indexation choisis par Oracle pour les données spatiales sont l'R-tree arbre R enOracle.com https://docs.oracle.com/html/A88805_01/sdo_intr.htm Spatial Concepts, l'arbre Q, et le Z-order enOracle.com http://docs.oracle.com/cd/E20213_01/doc/win.112/e17727/dcmethods006.htm ZOrder Method. Link with the GIS To represent the data on maps, we use a geographic information system (GIS). For example: GRASS GISOracle.com http://www.oracle.com/technetwork/articles/mitasova-grass-092663.html Geographic Resources Analysis Support System (GRASS): More Than a Mapping Tool QGIS vignette|upright=2.0|left|QGIS links configuration with the databases (including Oracle). If the software needs an ODBC data source to access the Oracle databases: Launch %windir%\system32\odbcad32.exe. Add a system source. The Oracle driver can be chosen in the list if the DBMS is installed. Fill the TNS service name with the name which can be found into C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora. Then write the password of the connection created with SQL*Plus. Examples http://download.oracle.com/otndocs/products/spatial/pdf/au_melbourne06_start.pdf http://download.oracle.com/otndocs/products/spatial/pdf/GeocodingInOracleUsing_HERE_MapContent.pdf References