25/02/2012

PostGIS vs. Oracle Spatial


PostGIS vs. Oracle Spatial

Ini adalah artikel yang menarik jika anda, seperti saya, suka dengen pakej QGIS-PostgreSQL-PostGIS. Ianya membandingkan PostGIS dengan Oracle Spatial apabila dipasang dalam default. Keputusannya? Pengkaji menyatakan:

"From the experimental results that we saw, we can conclude that Postgres performs better than Oracle 11g both in the Cold Phase and Warm Phase. Though in few queries Oracle 11g performed better but on the whole Postgres overpowered Oracle 11g. In the warm phase in 3 out of 4 queries Postgres performed significantly well, from this we can conclude that Postgres has better automatic memory management capabilities and page replacement policies... On the whole it is the open-source that wins the game!"

Sekarang baru anda tahu mengapa selama ni I sokong PostGIS akan tetapi tidak tahu bagaimana nak memberi justifikasi saintifik.

PostGIS vs. Oracle Spatial

This is a very interesting article if you, like me, like the QGIS-PostgreSQL-PostGIS package. It compares PostGIS and Oracle Spatial when installed in default. The results? The authors say:

"From the experimental results that we saw, we can conclude that Postgres performs better than Oracle 11g both in the Cold Phase and Warm Phase. Though in few queries Oracle 11g performed better but on the whole Postgres overpowered Oracle 11g. In the warm phase in 3 out of 4 queries Postgres performed significantly well, from this we can conclude that Postgres has better automatic memory management capabilities and page replacement policies... On the whole it is the open-source that wins the game!"

Now you know why I've supported PostGIS eventhough I did not know how to justify it scientifically.

No comments:

Post a comment