Geospatial - GISGvSIGzobwezedwa GISqgisuDig
Kuyerekeza ndi malo ogwiritsira ntchito deta
GIS ya Boston yatulutsa Kufanizitsa pakati pa zipangizozi pa kayendetsedwe ka deta:
- SQL Server 2008 malo,
- PostgreSQL / PostGIS 1.3-1.4,
- MySQL 5-6
Chochititsa chidwi ndi chakuti, zojambulidwa zimatchulidwa ngati njira yopindulitsa ... yomwe ndi yabwino patatha chaka chimodzi ife timaponyera maluwa akuyembekezera kuti mukudziwika kuti mukule.
Ngakhale Kuwonekera sikuchita bwino ndi MySQL, ndipo kuyerekeza sikulingalira Oracle, momwe Manifold ili pansi.
Ndikuvomereza kuti ndasintha pang'ono, ndipo chifukwa cha chidwi changa ku Manifold ngakhale mutakhala ndi chidwi ndi positi, mukhoza kuchiwona malizitsani mu Chingerezi mu chiyambi chake, chifukwa mu gawo lachiwiri la positi iwo amasonyeza mndandanda wa ntchito zapakati pa mapepala osiyanasiyana.
Nkhani | SQL Server 2008 Pakati |
MySQL 5-6 |
PostgreSQL / XMUMX-1.3 PostGIS |
Njira yogwiritsira ntchito | Windows XP, Windows Vista, Windows 2003, Windows 2008 | Windows XP, Windows Vista, (osati kufufuza mu 2008), Linux, Unix, Mac | Mawindo a 2000 + (kuphatikizapo Vista ndi 2003, osayesedwa mu 2008), Linux, Unix, Mac |
License | Chitukuko chogulitsidwa | Gwero lotsegula malonda (COSS), mbali zina za GPL. | FLOSS (PostgreSQL ndi BSD, PostGIS ndi GPL Open Source - ntchito zamalonda zingagwiritsidwe ntchito koma ngati zisinthidwa zomwe zimakhudza makalata a PostGIS, muyenera kubwezeretsa kumudzi |
GIS yaulere yomwe imatsitsa deta | Shp dataloader ya SQL Server 2008 yopangidwa ndi Morten Nielsen (osagwiritsabe ntchito ndi RC0) | OGR2OGR, script shp2mysql.pl | onjezerani shp2pgsql, OGR2OGR, QuantumGIS SPIT, SHP loader ya PostGIS inayambanso ndi Morten pogwiritsa ntchito SharpMap.NET , pali ena |
GIS yamalonda omwe amawathandiza | zobwezedwa, Zopangira FME Zolimba, ESRI ArcGIS 9.3 (mu paketi yotsiriza ya utumiki) | Zopewera za FME zotetezeka | zobwezedwa, Zinthu za FME, ESRI ArcGIS 9.3 |
Kupezeka kwa madalaivala makamaka malo osankhidwa | ? Osati - SharpMap.NET potsiriza ndipo mwinamwake anamanga ADO.NET 3.5 + yatsopano | GDAL C ++, SharpMap kudzera OGR, AutoCAD FDO | SharpMap.Net, JDBC postgis.jar ili ndi postgis, JTS etc. matani a Java, GDAL C ++, Support AutoCad FDO beta |
Owonerera pazithunzi ndi omasulira aufulu | Zidzakhala zomangidwa pa SQL Manager, koma sizipezeka mu RCO komanso kwa owona | GvSig | OpenJump, QuantumGIS, GvSig, Dig |
Owonerera pazithunzi ndi osindikiza malonda | Gulu la ESRI ArcGIS 9.3 Server SDE mu phukusi la posachedwapa, zobwezedwaFME | FME | Gulu la ESRI ArcGIS 9.3, ZigGIS pa desktop, zobwezedwaFME |
Zida za mapu a intaneti - chinachake monga OpenLayers ndi malo ena omwe amathandiza GML | zobwezedwa, MapDotNet, ArcGIS 9.3 (mu paketi yotsiriza ya utumiki), UMN MapServer Vesi, MapuGuide Open Source (pogwiritsa ntchito beta FDO driver) | UMN Mapserver, GeoServer, MapuGuide Open Source | zobwezedwa, MapDotNet, ArcGIS 9.3, Mapserver UMN, GeoServer, FeatureServer, MapGuide Open Source (pogwiritsa ntchito beta FDO driver) |
Malo amagwira ntchito | Onse OGC SFSQL MM ndi Geodetic custom (zochuluka kuposa 70 ntchito) | OGC MBR (yomangirira bokosi ntchito) zina ntchito zogonana, 2D yekha | Kuposa ntchito 300 ndi ntchito, geodetic chithandizo chilichonse kupatula poing-2-mfundo ntchito mtunda osati osanjidwa, PostGIS aliyense payekha payekha 2D ndi ena 3D, ena thandizo MM mu dongosolo zozungulira ndi pawiri zokhotakhota |
Malo owonetsera malo (Malingana ndi malipoti ena, Oracle amagwiritsanso ntchito china kuchokera ku R-Tree ndipo akhoza kugwiritsa ntchito IBM DB2 quadtree ... kapena chinachake chonga icho |
Inde, magulu osiyanasiyana a 4 (BOL amati B-Tree yochokera) | R-Tree quadratic splitting - indexed kokha ilipo kwa MyISAM | GIST - mitundu yosiyanasiyana ya R-Tree |
Thandizo la geodetic yeniyeni, kuthandizira payeso pambali ya spheroid. Onani kuti Oralce ali ndi chithandizo cha izi |
Inde, ndi zolephera zina | Ayi | Ayi |
Kugawidwa kwagawidwa | Zambiri | Zambiri | Chinachake, pokhapokha mutakhala ndi seva wodzipatulira pa Linux / windows mukhoza kukwaniritsa zinthu zambiri |
kondomu yomwe yatchulidwa pamasitomala, ndizomvetsa chisoni kuti chilembo choyambirira sichimawona olemba poyerekezera
Ndipo Oracle?
Sindikumvetsa momwe Oracle sanawonetsere poyerekeza. Lili ndi ntchito zogwira mtima kwambiri kusiyana ndi zomwe zilizonse zitatuzi monga geocoding, kuyembekezera ndi yosungirako raster.
Kumene mu lingaliro langa, PostGIS ndi (ngakhale chitukuko wosakwiya) zabwino zina geospatial yosungirako, ndi ntchito Oracle (kachiwiri, mu lingaliro langa) yekha wolungama milandu yeniyeni kwambiri chifukwa cha mtengo wake mkulu okha oyenera matumba olemera.
Mwa njira, ndikuwoneka kuti wina (watsopano / wakale) wosewera mpira adzafika patsogolo pa mauthenga a geospatial: INGRES.
Tidzawona.