Postgresql vs Oracle用于维护GIS数据 [英] Postgresql vs Oracle for maintaing GIS data

问题描述

我们目前使用oracle和ArcSDE维护GIS数据.但是，我们希望探索更好和更便宜的替代方案.我们碰到使用postgresql来维护gis数据库.我们的业务需要线性引用和版本控制功能.还需要具有拓扑和要素数据集.

We currently maintaining GIS data using oracle and ArcSDE. However, we want to explore better and cheaper alternatives. We came across using postgresql for maintaining gis database. Our business requires linear referencing and versioning capabilities. Also need to have topology and featuredatasets.

我是Postgresql的新手.因此，我对其性能和稳定性一无所知.你们可以和oracle一起分享有关postgresql性能和稳定性的经验.我希望数据安全无虞.

I am new to Postgresql. So, I do not know any thing about its performance and stability. Can you guys share your experience with respect to postgresql performance and stability in comparision with oracle. I want data to be safe and secure without any crashes.

我们使用ArcGIS产品.我们还在探索使用PostGIS和/或ArcSDE在postgresql中管理数据.由于处理空间数据涉及各种软件产品，因此我也关注软件更新及其对数据库维护的影响.

We use ArcGIS products. We are also exploring using PostGIS and/or ArcSDE to manage data in postgresql. Since working with spatial data involves various software products I am also concerned about software updates and how it effects database maintainence.

非常感谢您能分享您的专业知识和知识.谢谢.

I greatly appreciate if you could share your expertise and knowlege on this subject. Thanks.

推荐答案

PostgreSQL的性能和稳定性绝对可以与ORA媲美.

The performance and stability of PostgreSQL is definitely comparable with ORA.

PostGIS扩展是最成熟的地理空间扩展，您可以从任何免费和开放源(FOSS)数据库管理系统中获取有关稳定性，性能和功能的信息.

The PostGIS extension is the most mature geospatial extension you can get from any free and open source (FOSS) database management systems regarding stability, performance and functionality.

PostGIS(或我知道的任何其他FOSS数据库)虽然不支持开箱即用的版本控制.您必须自己实现这些.

PostGIS (or any other FOSS databas I know) though don't support versioning out of the box. You have to implement these yourself.

我假设您知道可以通过"PostGIS option"将ArcGIS与PostgreSQL一起使用，这意味着您可以松开版本(AFAIK)，但可以使用开放源码(FOSS)工具，从而可以读取PostgreSQL.

I assume you know that you can use ArcGIS with PostgreSQL using "PostGIS option" which means, that you loose versioning (AFAIK) but gain openess to (FOSS) tools wich can read PostgreSQL.

这篇关于Postgresql vs Oracle用于维护GIS数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！