Docstoc

DBMS_Performance-ArcGIS_Server__Data_Management

Document Sample
DBMS_Performance-ArcGIS_Server__Data_Management Powered By Docstoc
					ArcGIS Server: Data Management



   Managing a Multiuser Geodatabase
             Mike Jensen




                                      SERUG 2008   1
Session Objectives

• Discuss multiuser geodatabase options
• Tools used to manage a multiuser geodatabase
• Multiuser Geodatabase Best Practices
• Multiuser Geodatabase Tips and Tricks
• What’s new at 9.3 for Multiuser Geodatabases
• Additional Resources
• Questions




                                                 SERUG 2008   2
  Defining the geodatabase
• Collection of geographic datasets
  – Feature classes, raster data, attribute tables, etc.

• Native data structure for ArcGIS                                                  Surveys
                                                                        Networks                Addresses

• Provides the ability to:                                  Vectors
                                                                                                            Annotation
  – Leverage data relationships
  – Enforce data integrity
                                       3D Objects
  – Create intelligent features                                                                                              Attribute




                                            Topology

                                                                                                                             Dimensions



                                                       Terrain
                                                                                                                 Cadastral




                                                                                                   CAD
                                                                      Cartography
                                                                                       Images




                                                                                                                         SERUG 2008       3
    Geodatabase Elements




           Feature dataset                           Additional Geodatabase
               Spatial reference                            Elements

             Geometric networks                     Tables


              Topology                              Raster Datasets


              Network datasets                      Raster Catalogs


                             Relationship classes

             Feature classes
              Point Line Polygon Annotation Route Dimension




                                                                              SERUG 2008   4
D
Geodatabase Options
                                                           ArcGIS Server



             ArcGIS Desktop

                                                                          Enterprise
                                                                         Enterprise
                                  Personal     Workgroup
               File           Personal
  Personal            File       (ArcEditor,
 Personal-
   Access                         ArcInfo)
  Access


                                                              Capacity

                                                  Number of users


  • Personal for Microsoft Access
  • File
  • ArcSDE technology at three levels
        •Personal, Workgroup, Enterprise
                                                                                 SERUG 2008   5
ArcGIS Desktop Geodatabases
All Single
Editor              Personal-           File
                                                           Personal-
                                                            ArcSDE
                     Access


Design          Original          Improved             Designed for
                Desktop format    Desktop format       GDB Replication
Storage         Microsoft         File folder (.gdb)   Microsoft
                Access            Smaller storage      SQL Server
Mechanism
                database (.mdb)   footprint .          Express


Storage         2 GB per          1 TB per             4 GB Total Data
                geodatabase;      dataset;             Size. Single CPU
Limit
                effective limit   configurable up      1GB RAM
                ~500 MB           to 256 TB
Platform        Windows           Any                  Windows

Functionality Edits lock entire Edits lock at    3 concurrent
                Geodatabase.    data level. High connections, 1
                                Performance for editor. Edits
                ArcView License
                                Read-only data. lock entire GDB.
                                ArcView License ArcEditor Lic.
                                                                          SERUG 2008   6
      Multiuser Geodatabase Benefits
 • Centralized data storage
 • Efficient data delivery
 • DBMS security and reliability
 • Multiuser editing
                                                       ArcGIS Server
 • Geodatabase replication
 • Archiving
                                                                       Enterprise
                                                                       (SQLServer,
                                                                        Enterprise
     Same functionality, but                   Workgroup                  Oracle,
  designed for limited use with                (SQLServer                  DB2,
   distributed geodatabases.        Personal                             Informix)
                                     (SQL       Express)
Does not offer multiuser editing.
                                     Server
                                    Express)

                                                            Capacity

                                                Number of users


                                                                                 SERUG 2008   7
  Multiuser Geodatabases
• Workgroup
  – For departments and small organizations
  – Supports 10 concurrent Windows authenticated users
  – Hardware limitations as per Microsoft SQL Server Express
     – 4 GB Total Storage, 1 CPU, 1 GB RAM
• Enterprise
  – Large organizations
  – Unlimited connections
  – Implemented with choice of DBMS
     • IBM DB2, IBM Informix, Microsoft SQL Server, or Oracle
     • No hardware limitations




                                                                SERUG 2008   8
  Manage Multiuser Geodatabase - Tools
• Workgroup
  – ArcCatalog
    • All Geodatabase Administration
      – Geodatabase creation, Loading Data, Data Properties, User
        access, Database Maintenance , etc.


• Enterprise
  – ArcCatalog
    • Load data
    • Data Properties (User access, GDB Behavior, Editing – Versioned
      or Non-Versioned)
    • Geodatabase Compress




                                                                    SERUG 2008   9
 Manage Multiuser Geodatabase - Tools

• Enterprise
 – DBMS Tools
   • Enterprise Manager, Management Studio, TOAD, etc.
     – Create/Add users to Database
     – Grant specific users permissions to create database objects (ie;
       tables)
     – Database Maintenance and Performance
       » Analyze edited tables
       » Rebuild Indexes on tables that fragment over time
       » Backup and Recovery




                                                                    SERUG 2008   10
    Multiuser Geodatabase - Connections
    • Access to Geodatabase Spatial Data
      • Application Server Connection
        • Requires an ArcSDE Service
        • ArcSDE processing occurs on Server


      • Direct Connect
        • No ArcSDE Service Required
        • May require RDBMS Client software on each workstation
        • ArcSDE processing distributed to workstations


    • Access to Non-spatial data in databases
      • OLE DB
        • Practical use for associating non-spatial data with
          spatial data using join and relate operations

                                                                  SERUG 2008   11
D
Multiuser Geodatabase – Best Practices

• Use Direct Connect

• Headless user for data ownership
 • Accommodates staff changes seamlessly


• Grant data permissions in ArcCatalog
 • Data owner doesn’t require access to DBMS tools
 • Assigns proper permissions to all data tables




                                                     SERUG 2008   12
Multiuser Geodatabase – Best Practices

• Plan ahead for data use
 • Storage types
   • SDEBINARY, ST_GEOMETRY, etc.
 • Determine if geodatabase behavior is needed
   • Subtypes, domains, topology, geometric
     networks, etc.
 • Consider editing options available at 9.2
   • Versioned, Non-Versioned, Move to Base, etc.




                                                    SERUG 2008   13
Multiuser Geodatabase – Best Practices
• Plan ahead for data use
 • Raster Data (Enterprise)
   • Load sample data
   • Mosaic, Catalog, or Raster Attribute type
   • Confer with DBA
     • Available Storage and placement
     • Prerequisite settings to large data loads
     • Load during quite or non-peak hours
   • Use Direct Connect
   • Analyze tables during load
   • Grant Read only access to users

                                                   SERUG 2008   14
Multiuser Geodatabase – Best Practices
• Compress Geodatabase Nightly
 • Improves performance
 • Removes unreferenced rows related to versioned edits
   • Feature class delta tables and versioning system tables


• DBMS Performance Maintenance
 • Update database statistics
   • Frequency depends on editing activity
   • Before and after geodatabase compress
 • Rebuild indexes
   • Perform periodically to maintain performance
 • Statistics and Indexes should be maintained on all
   edited tables. Do not overlook ArcSDE system tables

                                                               SERUG 2008   15
Multiuser Geodatabase – Tips and Tricks
• User interaction (ArcMap)
  • Use scale dependency
  • Bookmarks
  • Overview and magnifier windows
  • Map cache
  • Keep Table of Contents and symbology simple
• Sample Scripts
  • Geodatabase Diagrammer
  • ArcSDE User Privileges Button and Report
  • Geodatabase Toolset
  • Detritimizer



                                                  SERUG 2008   16
Multiuser Geodatabase – Tips and Tricks
• Sample Script URL’s
  • Geodatabase Diagrammer
  http://arcscripts.esri.com/details.asp?dbid=13616


  • ArcSDE User Privileges Button and Report
  http://arcscripts.esri.com/details.asp?dbid=13561
  http://arcscripts.esri.com/details.asp?dbid=15123


  • Geodatabase Toolset
  http://www.esri.com/software/arcgis/extensions/gdbt/index.html


  • Detritimizer
  http://arcscripts.esri.com/details.asp?dbid=13428

                                                                   SERUG 2008   17
New at 9.3

 • Direct Connect compatibility
   • 9.3 Client connection to 9.2, 9.1, or 9.0 Geodatabase


 • One-way replication to File Geodatabases


 • Support for SQL Server 2008 spatial data types
   • Later 9.3 Service Pack release


 • Support for PostgreSQL database




                                                             SERUG 2008   18
Additional Resources
• Data Management in the Multiuser Geodatabase
  • Instructor-Led course
  • April 28th – 30th - Charlotte, NC
  • June 9th – 11th – Murfreesboro, TN
  • June 23rd – 25th – Duluth, GA
  • July 28th – 30th – West Palm Beach, FL
• Managing Editing Workflows in a Multiuser Geodatabase
  • Instructor-Led course


• ArcGIS Desktop Web Based Help
  • http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=
    welcome
     • Geodatabases and ArcSDE



                                                                SERUG 2008   19
Thank you for attending




           Questions?




                          SERUG 2008   20

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:6/27/2012
language:Latin
pages:20