Geospatial - GISGvSIGGIS kala cayncayn ahqgisuDig
Isbarbardhiga xogta xogta xogta
Boston GIS ayaa daabacay Isbarbardhig ka dhexeeya aaladaha maareynta xogta xogta:
- SQL Server 2008 Muuqaal,
- PostgreSQL / PostGIS 1.3-1.4,
- MySQL 5-6
Waxa xiiso leh, Manifold waxaa lagu sheegay inuu yahay mid kale oo suurtagal ah ... taasi waa mid wanaagsan kadib markii in ka badan hal sano waxaan ku tuurnaa ubax sugaya caankiina si ay u koraan.
Inkasta oo Manifold uusan ku fiicneyn MySQL, isbarbardhigana ma tixgelinayo Oracle, oo Manifold uu si fiican u fadhiyo.
Waxaan qirayaa in aan si xun u turjumay qaar ka mid ah tarjumaadda, iyo xiisaha aan u qabo Manifold inkastoo haddii aad xiiseyneyso boostada, waxaad arki kartaa dhammeystiran oo Ingiriis ah asalkiisa asalka ah, sababtoo ah marxaladda labaad ee boostada waxay muujinayaan liiska shaqooyinka bannaan ee goobaha kala duwan.
Característica | SQL Server 2008 Mucjisada |
MySQL 5-6 |
PostgreSQL / PostGIS 1.3-1.4 |
Nidaamka hawlgalka | Windows XP, Windows Vista, Windows 2003, Windows 2008 | Windows XP, Windows Vista, (aan lagu hubin 2008), Linux, Unix, Mac | Windows 2000 + (oo ay ku jiraan Vista iyo 2003, oo aan lagu tijaabin 2008), Linux, Unix, Mac |
Shatiga | Meesha ganacsi-xiran | Ilaha furan ee ganacsiga (COSS), qaybo GPL ah. | MAGAALOOYINKA (PostgreSQL waa BSD, PostGIS waa GPL Open Source - codsiyada ganacsiga waxaa loo isticmaali karaa laakiin haddii isbedel lagu sameeyo saameynta maktabadaha PostGIS, waa inaad u celisaa bulshada |
GIS lacag la'aan ah oo soo gudbineysa xogta | shp dataloader for SQL Server 2008 uu sameeyay Morten Nielsen (aan weli la shaqeyn RC0) | OGR2OGR, shp2mysql.pl script | waxaa ka mid ah shp2pgsql, OGR2OGR, QuantumGIS SPIT, Shirkadda SHP ee PostGIS ayaa sidoo kale soo saartay Morten iyadoo la adeegsanayo SharpMap.NET , waxaa jira dad kale |
Ganacsiga GIS ee taageera | kala cayncayn ah, Noocyada Safe FME, ESRI ArcGIS 9.3 (ee adeegga ugu dambeeyay) | Aaladaha FME Safe | kala cayncayn ah, Goobaha FME, ESRI ArcGIS 9.3 |
Helitaanka darawalada gaar ahaan meelaha qaybaha | ? maya weli - SharpMap.NET ugu dambeyntii iyo waxaa laga yaabaa in la dhiso ADO.NET 3.5 + cusub | GDAL C ++, SharpMap iyada oo loo marayo OGR, AutoCAD FDO | SharpMap.Net, JDBC Postgis.jar waxaa ku jira joornaal, JTS iwm. tufaaxa Java, GDAL C ++, Taageerada AutoCad FDO beta |
Muuqaal-faneedka iyo tifaftireyaasha xorta ah | Waxaa lagu dhisi doonaa Maamule SQL, laakiin aan laga helin RCO oo kaliya oo loogu talagalay daawadayaasha | GvSig | OpenJump, QuantumGIS, GvSig, uDig |
Muuqaalliyadaha Muuqaalka iyo Wargeysyada Ganacsiga | ESRI ArcGIS 9.3 Server SDE ee khariidadda ugu dambeysa, kala cayncayn ah, FME | FME | ESRI ArcGIS 9.3 Server, ZigGIS ee desktop, kala cayncayn ah, FME |
Qalabka loogu talagalay mabaadaynta webka - wax sida OpenLayers iyo bey'ado kale oo taageera GML | kala cayncayn ah, MapDotNet, ArcGIS 9.3 (ee adeegga ugu dambeeya), UMN MapServer Ver, MapGuide Open Source (isticmaalka beta FDO) | UMN Khariidadaha, GeoServer, MapGuide Open Source | kala cayncayn ah, MapDotNet, ArcGIS 9.3, Khariidadaha UMN, GeoServer, FeatureServer, MapGuide Open Source (Isticmaalka beta FDO) |
Shaqooyinka bannaan | Labada OGC SFSQL MM iyo habka joddaasyada (in ka badan 70 hawlaha) | OGC MBR (sanduuqa xuduudaha ku xiran) qaar ka mid ah shaqooyinka cilaaqaadka xaddidan, 2D kaliya | In ka badan hawlaha 300 oo ka shaqeeya, geodetic taageero jirin, marka laga reebo poing-2 dhibcood ee hawlaha meel fog ma xaddiday, PostGIS shakhsi for 2D iyo qaar ka mid ah 3D, qaar ka mid ah taageerada MM in qabanqaabada wareeg iyo gooladaha xarunta |
Muujinta Muuqaalka (Sida laga soo xigtay wargeysyada qaar, Oracle ayaa sidoo kale wax ka isticmaala R-Tree oo wuxuu isticmaali karaa quudinta IBM DB2 ... ama wax la mid ah |
Haa, Xirmooyinka 4 Multilevel (BOL waxay sheegaysaa in B-Tree ku salaysan yahay) | R-Dhulka kala-jajabinta - waxaa loo qoondeeyey kaliya oo ku jirta MyISAM | GIST - waa nooc ka mid ah R-Tree |
Taageerada dhabta ah ee juqraafiga ah, taageerada cabbiraadda qiyaasta. Ogsoonow in oralce uu taageero tan |
Haa, oo leh xadidaadyo yar | Maya | Maya |
Qabashada martigelinta | Wax badan | Wax badan | Waxyaabaha, haddii aadan haysan server adeegsanaya Linux / daaqadaha waxaad ku guuleysan kartaa waxyaabo badan |
koorta ku xusan boostada, waxaa haboon soo biiray warqadda asalka ah aysan ka fiirsan Oracle in ay is barbardhig
Oracle?
Anigu ma fahmi karo sida Oracle uusan u muuqan isbarbardhigga. Waxay leedahay hawlo aad u sarreeya oo ka badan mid ka mid ah mid kasta oo ka mid ah kuwan soo socda sida geocoding, topology iyo kaydinta xajmiga.
Dabcan in my opinion, PostGIS waa (inkastoo ay horumar gaabis ah) kaydinta geospatial kale ugu fiican, iyadoo la isticmaalayo Oracle (mar kale, in my opinion) oo keliya xaq xaaladaha aad u gaar ah, sababta oo ah qiimaha sare oo keliya ku haboon meelo hodanka ah.
Dhab ahaantii waxa ay u muuqataa in (/ old cusub) ciyaaryahan kale oo u iman doonaan inay foodda ah ee database-geospatial: INGRES.
Waan arki doonaa.