Geospatial - GISGvSIGda yawa GISqgisuDig
Haɗakar masu amfani da bayanai na sararin samaniya
Boston GIS Ya buga a kwatanta tsakanin wadannan kayayyakin aiki, don na sarari data management:
- SQL Server sarari 2008,
- PostgreSQL / PostGIS 1.3-1.4,
- MySQL 5-6
Abin sha'awa, An ambaci Manifold a matsayin mai dacewa mai dacewa ... wannan abu ne mai kyau bayan fiye da shekara guda muna jefa furanni suna jiran adabinka ya girma.
Ko da yake da yawa ba a yi da kyau tare da MySQL, kuma Oracle kamanta ba la'akari, kamar yadda yake da kyau a zaune da yawa.
Na yarda cewa zan yi wuya yi wasu translation, da kuma sha'awar da nake da yawa duk da haka idan kuna da sha'awar a cikin post, za ka iya ganin shi cikakken English a cikin ainihin tushen, kamar yadda a cikin mataki na biyu na post ãyõyi jerin sarari ayyuka na daban-daban dandamali.
Característica | SQL Server sarari 2008 |
MySQL 5-6 |
PostgreSQL / PostGIS 1.3-1.4 |
tsarin aiki | Windows XP, Windows Vista, Windows 2003, 2008 Windows | Windows XP, Windows Vista, (ba da aka nuna a 2008), Linux, Unix, Mac | 2000 + Windows (ciki har da Vista da kuma 2003, 2008 ba su bari a), Linux, Unix, Mac |
lasisi | Kasuwanci, rufaffiyar tushen | Commercial bude Madogararsa (COSS), wasu sassa GPL. | FLOSS (PostgreSQL shine BSD, PostGIS shine GPL Open Source - Ana iya amfani da aikace-aikacen kasuwanci amma idan an yi canje-canjen da suka shafi ɗakunan karatu na PostGIS, dole ne ku mayar da su zuwa ga al'umma |
Free GIS data loading | shp dataloader ga SQL Server 2008 ci gaba da Morten Nielsen (har yanzu bai yi aiki ba tare da RC0) | OGR2OGR, shp2mysql.pl rubutun | Sun hada da shp2pgsql, OGR2OGR, QuantumGIS tofa, SHP Loader for PostGIS kuma ci gaba da Morten amfani SharpMap.NET , Sauran |
Commercial GIS cewa goyi bayan | da yawa, Abubuwan Bincike na GEM, ESRI ArcGIS 9.3 (a cikin sabis na ƙarshe) | Safe FME Abubuwan | da yawa, Abubuwan FME, ESRI ArcGIS 9.3 |
Availability na direbobi musamman domin sarari aka gyara | ? ba tukuna - SharpMap.NET ƙarshe kuma tabbas an gina shi cikin sabon ADO.NET 3.5 + | GDAL C ++, SharpMap ta hanyar OGR, AutoCAD FDO | SharpMap.Net, JDBC postgis.jar hada da postgis, JTS da dai sauransu. tons don Java, GDAL C ++, goyon bayan AutoCad FDO beta |
Masu kallo desks da kyauta Editocin | Su za a gina a kan SQL Manager, amma ba samuwa a RCO kuma kawai viewer | gVSIG | OpenJUMP, QuantumGIS, GVSIG, uDig |
Viewfinders tebur da kuma kasuwanci wallafa | ESRI ArcGIS 9.3 Server SDE a cikin sabon shirin sabis, da yawa, FME | FME | ESRI ArcGIS 9.3 Server, ZigGIS don tebur, da yawa, FME |
Tools yanar gizo zanen taswira - wani abu kamar OpenLayers da sauran yanayin da ke goyan bayan GML | da yawa, MapDotNet, ArcGIS 9.3 (a cikin sabis na ƙarshe), UMN MapServer Ver, MapGuide Open Source (ta amfani da beta direban FDO) | UMN Mapserver, GeoServer, Maɓallin Shafin Maɓallin Gida | da yawa, MapDotNet, ArcGIS 9.3, Mawallafi na UMN, GeoServer, FeatureServer, Maɓallin Shafi na MapGuide (ta amfani da Beta FDO direba) |
sarari ayyuka | OGC SFSQL biyu MM da Geodetic al'ada (a kan 70 ayyuka) | OGC MBR (bounding akwatin ayyuka) da wasu ayyuka na sarari dangantaka, kawai 2D | Fiye da 300 ayyuka da kuma aiki, geodetic ba da goyon baya, sai dai poing-2-batu a nesa ayyuka ba fihirisa, na kanka PostGIS for 2D da kuma wasu 3D, wasu support MM a madauwari shirye-shirye da kuma fili masu lankwasa |
sarari Indexing (A cewar wasu rahotanni, Oracle yana amfani da wani abu daga R-Tree kuma zai iya amfani da IBM DB2 quadtree ... ko wani abu kamar wannan |
Idan, 4 multilevel grids (Bol ce DAI B-Tree tushen) | R-Tree quadratic tsagawa - aka lissafa kawai wanzu ne ga MyISAM | GIST - wani bambancin R-Tree |
Real geodetic support, goyon baya ga ma'aunai tare da wani spheroid. Ya kamata a lura cewa wannan goyon bayan Oralce |
Eh, tare da wasu gazawa | A'a | A'a |
shared Hosting | yawa | yawa | Wani abu, sai dai idan kana da wani kwazo uwar garken a kan Linux / windows iya yi abubuwa da yawa, |
mazugi aka ambata a cikin post, yana da daraja shiga asali daftarin aiki ba la'akari Oracle a kamanta
Kuma Oracle?
Ban gane ba yadda Oracle bai bayyana a cikin wannan gwadawa. Yana da yawa mafi m fiye da wadanda na wani daga cikin wadannan uku kamar yadda geocoding functionalities, topology kuma raster ajiya.
Hakika a ganina, PostGIS ne (duk da jinkirin cin) mafi kyau madadin geospatial ajiya, tare da yin amfani da Oracle (sake, a ganina) kawai barata a sosai musamman lokuta saboda ta high farashin kawai dace da m Aljihuna.
Lalle ne, haƙĩƙa alama cewa wani (sabon / haihuwa) player zai zo da fore na geospatial databases: INGRES.
Za mu gani.