基于OracleSpatial的矿山数据空间数据库的设计

OracleSpatial1121.2210082.201204OracleSpatialOracle10gSpatialOracle--OracleSpatialP208A1001-8379200602-0076-03DesignoftheSpatialDatabaseoftheMineDataBasedonOracleSpatialZHANGShan1TANHai-qiao1ZHUYu-peng21.CollegeofEarthResourceCUMTXuzhou221008China2.BeisailaiMultimediaInformationandTechniqueCorporationShanghai201204ChinaAbstractBasedonananalysisofadvantagesandshortcomingsoftheintegratedmanagementofspatialandattributemineda-tatheauthorsintroducethenewcharacteristicsofOracle10gandSpatialandproposeaconcreteprocedureforconstructingtheMineSpatialDatabasebasedonOracleobject-relationaldatamodel.Keywordsobject-relationaldatamodelOracleSpatialminedata1OracleSpatialIBMDB2SpatialExtenderInformixDataBladeOracle10gSpatialO-racleSpatialGISOracleSpatialGIS2Oracle10gSpatialSQLOracle10gSpatial2.1Oracle10gSpatialOracleSpatialOracle-7OracleSpatialSDO-GE-OMETRYOracleSpatialOracleOracle10gOracle64WindowsLinuxOracle10gSQLSGAOracle10gOracleIT9iOracle10gSpatial⊕GeoRaster⊕⊕⊕⊕LocatorGIS2.2OracleSpatialSDO-GE-OMETRYOracle11SDO-GEOMETRY3Oracle10gSpatialOracle10gSpatialSDO-GEOMETRYOracleUS-ER-SDO-GEOM-METADATAMDSYS.SDO-GEOMETRY1Drill-IDLOCATIONNUMBER8VARCHAR210NUMBER52NUMBER52MDSYS.SDO-GEOMETRYCREATEORREPLACETABLEDrillDrill-IDNUMBER8PRIMARYKEYVARCHAR210NUMBER52NUMBER52LOCATIONMDSYS.SDO-GEOMETRYLOCATIONMDSYSINSERTUSER-SDO-GEOM-METADA-TAINSERTINTOUSER-SDO-GEOM-METADATATABLE-NAMECOLUMN-NAMEDIMINFOSRIDVALUESDrillLOCATIONMDSYS.SDO-DIM-ARRAYMDSYS.SDO-DIM-ELEMENTX7847860.00000005MDSYS.SDO-DIM-ELEMENTY5145160.00000005MDSYS.SDO-DIM-ELEMENTZ010000.0000058307SDO-GEOM-ETRYSDO-GEOMETRYSDO-GEOMETRYSRIDSDO-GEOMETRYMBRXYZSRIDshapeshp2sdoOraclesqlldrDrill1522Drill-IDLOCATION1585.95854COLLECTIONLOCATION33LOCATIONLOCATIONSDO-GTYPESDO-SRIDSDO-POINTXYZSDO-ELEM-INFOSDO-ORDINATES30018307784.836747514.793533737.391NULLNULLSDO-GEOMETRYDrillCREATEINDEXDrill-idxONDrillLOCATIONOracleR-treeQuad-treeR-treeOracleSpatialOracleSpatialPrimaryFilterSecondFilter7121GDH202SJDH203ZJDH204GJ155GC156GCHANG107SGDW508JGRQ9IDID10ShapeShape44.1GeoDataBaseGeoDataBaseESRIGeoDataBaseArcGISGeoDataBase4.2ArcInfoJunctionEdgeEdgeJunctionEdgeEdgeJunctionEdgeJunction51Z.2005.2.ArcGISA.50C.2004.2006-04-091977-2004784OracleSpatialGISOracleSpatialOracle10gSpatialOracleSpatial1OracleSpatialUsersGuideandReference.10gRelease2.2005.2OracleSpatialA.OracleC.2003.3.OracleJ.200213201-203.4.OracleSpatialGISJ.2002282278-280.5.M.1998.2006-01-111981-WebGIS