ArcSDE Presented by

1
ArcSDEPresented by

• Reza Wahadj
• University of California ,San Diego (UCSD)

2
Why are you here?

• Introduction to ArcSDE?
• Want to know whats new in ArcSDE 8?
• Existing SDE user or new user?
• Existing ArcInfo user?
• Technical details on implementation?
• Just confused...

Why are you here?
3
You will get answers to the following questions

• What is ArcSDE, how can I use it and when should
  I use it?
• ArcSDE 8 - ArcSDE - SDE 3.0 SDE for Coverages
  Personal SDE - Personal Geodatabase?
• How do I get ArcSDE 8?
• Whats new in ArcSDE 8?

Answers
4
You will also get answers to the following
questions

• How do I get my data into ArcSDE 8?
• How do I migrate my data from SDE 3.0 to ArcSDE
  8?
• How do I convert data from Librarian and ArcStorm
  to ArcSDE 8?
• Hard- and Software requirements?

Answers
5
What is ArcSDE 8?(Arc Spatial Database Engine)
What is ArcSDE 8?
6
What is ArcSDE 8?

• A program on your computer/server

What is ArcSDE 8?
7
What is ArcSDE 8?

• A server application that works in cooperation
  with a DBMS

What is ArcSDE 8?
8
What is ArcSDE 8?

• A way to store, manage and access spatial data

What is ArcSDE 8?
9
What is ArcSDE 8?

• A program that can be used with different clients

What is ArcSDE 8?
10
What is ArcSDE 8?

• A program on your computer/server
• A server application that works in cooperation
  with a DBMS
• A way to store, manage and access spatial data
• A program that can be used with different clients

What is ArcSDE 8?
11
ArcSDE Architecture

• Open Application Program Interface

Client
Application
ArcSDE Client API
ArcSDE Server
DBMS
Server
What is ArcSDE 8?
12
ArcSDE 8 Architecture

• Server and Client
• UNIX (DEC, HP, IBM, SGI, Sun)
• Windows NT (Client also Win95, Win98, and
  Windows 2000?)

What is ArcSDE 8?
13
Cooperative C/S-Processing
Questions
Client
Results
Intensive Geoprocessing Functions
What is ArcSDE 8?
14
C/S-Processing

• Client
• Client CPU Intensive Geoprocessing Functions
• Clip
• Buffer
• Overlay
• Merge
• Dissolve

• Server
• RDBMS Access on Remote Host
• Full Topological Search Retrieval
• WHERE Clause with Attribute Constraints
• Some Geoprocessing

What is ArcSDE 8?
15
What kind of data can I store with ArcSDE 8 into
a DBMS?
What is ArcSDE 8?
16

• All data (spatial and attributes) stored in the
  DBMS

Open
Image
Coverages
Raster
Shapefiles
CAD
What is ArcSDE 8?
17
How are data stored?

• in tables (attributes and geometrie)
• in Geodatabase (attributes, geometrie, and
  metadata)

Data storage
18
What is a Geodatabase?

• The data that is stored in ArcSDE with an DBMS
  and that can contain advanced behaviors,
  relationships, etc.
• Data in ArcSDE that has object ids
• Data that contains an object relational data
  model

Data storage
19
How can I use ArcSDE 8?
Using ArcSDE 8
20
ArcSDE 8 Clients
ArcView 3.2
MapObjects 2.1
ArcExplorer X
CAD Client 1.2
OpenGIS/ C-API
Using ArcSDE 8
21
ArcSDE 8 supported databases and operating
systems!

• ArcSDE 8 Database Version?
• ArcSDE 8 Operating System Version?
• --gt Contact your local distributor!!!

Using ArcSDE 8
22
You should use ArcSDE 8...
Using ArcSDE 8
23
You should use ArcSDE 8...

• Central Data Storage

Using ArcSDE 8
24
You should use ArcSDE 8...

• Cost effective data management

Using ArcSDE 8
25
You should use ArcSDE 8...

• Access of many (different) clients without loss
  of performance

Using ArcSDE 8
26
You should use ArcSDE 8...

• Each ESRI product can access

Using ArcSDE 8
27
You should use ArcSDE 8...

• Own applications can access with C-API

Using ArcSDE 8
28
You should use ArcSDE 8...

• Store your data for Internet/Intranet

Using ArcSDE 8
29
You should use ArcSDE 8...

• Central Data Storage
• Cost effective data management
• Access of many clients without lost of
  performance
• Each ESRI Product can access
• Own applications can access with C-API
• Store your data for Internet/Intranet

Using ArcSDE 8
30
ArcSDE 8 - ArcSDE - SDE 3.0 SDE for Coverages-
Personal SDE Personal Geodatabase?
Naming
31
ArcSDE

• 1998
• SDE 3.0 Spatial Database Engine for
  RDBMS
• SDE for Coverages
• ArcSDE SDE 3.0 SDE for Coverages

Naming
32
ArcSDE 8

• 1999

rw - single-user
ArcSDE 8
Oracle
SQL Server
Informix
DB2
Personal
Coverages
Sybase
Your choice
DBMS
Files
Naming
33
Product Boxes

• 1999

ArcInfo 8 Box
ArcSDE 8 Box
ArcSDE 8
ArcIMS Box
Personal
Coverages
Oracle
SQL Server
Informix
DB2
Sybase
DB2
Your choice
Files
DBMS
Naming
34
How do I get ArcSDE 8?
Getting ArcSDE
35
Product Packaging

• ArcInfo 8 Box
• ArcSDE Personal Geodatabase
• single user
• ArcSDE for Coverages
• multi-user
• free server / free connections
• ArcSDE 8 for an DBMS
• multi-user
• optional license (server/connections)

Getting ArcSDE
36
Product Packaging

• ArcSDE 8 for an DBMS Box
• multi-user server / connections
• ArcInfo 8 Box (12 months)
• ArcSDE for Coverages
• multi-user
• free server / free connections
• ArcSDE Personal
• single user

Getting ArcSDE
37
Whats new in ArcSDE 8?
Whats new?
38
Whats new in ArcSDE 8?

• New ArcSDE table schema

Whats new?
39
New ArcSDE 8 table schema (1.)

• Version table
• Layers table
• Geometry columns table
• Raster columns table
• Spatial references table
• Table registry table
• Business table

Whats new?
40
New ArcSDE 8 table schema (2.)

• Versions table
• States tables
• Logfiles tables
• Geolocation tables
• Meta-data table
• Logical network tables
• Geodatabase tables

Whats new?
41
Whats new in ArcSDE 8?

• Table registry

Whats new?
42
Table registry (1.)

• Provides a central repository of tables, that the
  ArcSDE software manages directly or must be
  accessible for an application.

Whats new?
43
Table registry (2.)

• maintains the name, owner, and other relevant
  properties for tables that
• contain geometry columns
• contain raster columns
• are multi-versioned
• have a unique SE_ROW_ID column
• allow row locks

Whats new?
44
Table registry (3.)

• automatic- when upgrading from SDE 3.0 to ArcSDE
  8.0 (all spatially enabled tables)
• or directly with sde administration commands
  (other tables)

Whats new?
45
Whats new in ArcSDE 8?

• Long transactions with state and version support
  - Pessimistic and optimistic locking (versioning)

Whats new?
46
Long transactions with state and version support
- pessimistic and optimistic locking (versioning)

• transactions over more sessions
• locking mechanism is needed

Whats new?
47
Pessimistic locking

• layer locks
• area locks
• row locks

Whats new?
48
Optimistic locking

• Versioning

Conflict and Conflict Solution
Whats new?
49
Whats new in ArcSDE 8?

• New shape formats

Whats new?
50
New shape formats

• well-known binary
• well-known text
• ? OpenGIS standard (Open GIS Consortium)

Whats new?
51
Whats new in ArcSDE 8?

• New or changed administration commands

Whats new?
52
New administration commands

• sde2tbl ? converts an ArcSDE table to INFO,
  dBASE, or ArcSDE table format
• tbl2sde ...
• sdegeocode ? geocodes data
• sderelease (former sdeversion)
• sdestate

Whats new?
53
Changed administration commands

• sdeversion
• sdetable
• sdegroup

Whats new?
54
Whats new in ArcSDE 8?

• New ArcSDE table schema
• Table registry
• Long transactions with state and version support
  - Pessimistic and optimistic locking (versioning)
  
• New shape formats
• New administration commands

Whats new?
55
How do I get my data into ArcSDE 8 ?

• Shape Files ? shp2sde
• Coverages ? cov2sde
• ArcInfo 8.0 ArcCatalog / ArcToolBox
• coverages
• shapefiles and more...
• ArcInfo 8.0 workstation LAYERIMPORT
• SDE C-API

Data loading
56
How do I migrate my data from SDE 3.0 to ArcSDE 8?

• sdeexport (SDE 3) - sdeimport (ArcSDE 8)(no
  Geodatabase!)
• creating a Geodatabase with gdbs-command --gt
  sdeimport --gtregister
• DBMS version compatibility?

Migration
57
How do I convert my data from MapLibrarian or
ArcStorm to ArcSDE 8?

• Importing through ArcCatalog
• series of dialog boxes will guide you
• batch data converters can be used
• --gt simple feature types

Conversion
58
ArcSDEs Future

• ArcSDE 8.0
• New data types
• raster (images/grids)
• address
• Java API (ArcSDE 8.1)
• GUI?

Future
59
ArcSDE 8 Summary

• Storing spatial data in a DBMS
• Many different clients
• Many different databases
• Cost effective data management
• High performance
• Open GIS

Summary