Tuesday, August 08, 2006

PERSONAL SDE:
Single user applications, incl. with ArcEditor/Info
3 users, one of which can be editing
SQL Server 2005 Express inc.

WORKGROUP SDE:

ENTERPRISE SDE: Like we already have

BUNDLED DATBASE SERVERS
Easy to deply, simple install, preset database configuration
East to use: browse and administer from ArcCatalog, WINDOWS AUTHENTICATION

ArcCatalog: Add remove users, pause, start stop server, manager geodtabases from Catalog.

Demo showed starting a geodatabase in SQL Express using ArcCatalog

FILE GEODATABASE

New Geodatabase format at 9.2
-higher performace (demo showed this)
- less memory
-Supports FULL geodatabase information model (features, annotation, relationships, networks, topology, raster, terrain)
- Single user editing model, similar to personal geodb (access)
- "standard" format, and read-only compressed format
-windows/unix

-no size limit (Access has 2GB limit)
- works on additonal oerpating systems

High performace 20% to 10 times faster than Access
Difference is more dramatic with larger files
Close to performance of a shapefile

Large raster datasets possible (similar to how rasters are stored in ArcSDE)

Storage Limit: (1TB per each table), can be extended to 256TB (huge!) if needed "use configuration keyword"

Some data takes up much less space than access or shapefiles. Sometimes 20% of the size of previous files. Usually 50-75% of the space

COMPRESSED FORMAT: Read only. Query and Display just as fast. 2:1 to 25:1 compression ratios.
Use geoprocessing tools to compress.

File GDB has ".gdb" extension

No comments: