[mapguide-users] Guestion about Spatial Data v SHP,SDF your opinion pleas.

[Brad Nesom]

I can't speak at all for mg os/ent. I have used mg 6.5 for several years.
However the decision to use oracle spatial data objects was based on
interoperability rather than performance.
Oracle for us was a fairly cheap solution. We did a single processor
standard edition one which limits you to one processor and unlimited users.
With only locator (not full spatial)
This allowed integration of an expanding list of software that is SDO
compliant. In a municipality it can be non-productive to dictate software
platforms for different departments. So we decided to remove the software
dictate and apply a format dictate that would allow departments to find
different software that would write to the same format. SDO did this for us.
I just watched yesterday and Autodesk webcast for city of Tacoma with this
exact model.
http://usa.autodesk.com/adsk/servlet/index?siteID=123112&id=7217173
BTW the Tacoma isn't uploaded yet wait until next week or so and it should
be there.
The long and short and hidden part of this discussion is that then you
remove the "hard drive copy" (file lock) problem of non enterprise file
formats.
As far as performance goes I would think that the discussion would have to
be table normalization, size, edited dynamics, usage. (by the time you test
performance on the same data in different formats you should already have
optimized the data or you are just testing GIGO as the old saying goes.)
Anyone could build a bad database that would bring even the best
hardware/software combos to their knees.
That is about the breadth of my understanding of the big differences between
sdf, shp vs rdbms.
Brad

-----Original Message-----
From: Maciej Skorczewski [mailto:maciej.skorczewski at procad.pl] 
Sent: Thursday, December 14, 2006 1:26 PM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] Guestion about Spatial Data v SHP,SDF your opinion
pleas.

Hi all!

My guestion is what is a different between data stored in
Spatial Data
v
SHP or SDF file?


What abilities are beetwen this 2 data store option.
What is best for mapguide server?
What can you say about PostgresSql v Oracle (did you use PostgreSQL in 
small project - it is cheaper for me :)
What solution  have more opportunities? (or it is only way to store date 
and MG Server don't make any different)

I wait for all opinion.

thx.
  ps. wher can i read more about this topic?

-- 
Maciej

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org