Understanding our world. 2013 Esri International User Conference - - PowerPoint PPT Presentation

▶
understanding our world
SMART_READER_LITE
LIVE PREVIEW

Understanding our world. 2013 Esri International User Conference - - PowerPoint PPT Presentation

Mar 16, 2023 297 likes •975 views

Understanding our world. 2013 Esri International User Conference July 812, 2013 | San Diego, California Technical Workshop Editing Versioned Geodatabases : An Introduction Cheryl Cleghorn Shawn Thorne Assumptions: Basic knowledge of

slide-1
SLIDE 1

Understanding our world.

slide-2
SLIDE 2

Technical Workshop

2013 Esri International User Conference

July 8–12, 2013 | San Diego, California

Editing Versioned Geodatabases : An Introduction

Cheryl Cleghorn Shawn Thorne

slide-3
SLIDE 3

Assumptions:

Basic knowledge of relational databases Basic knowledge of the Geodatabase data model

  • Many other sessions that focus on this
slide-4
SLIDE 4

Requests:

  • Please hold questions until Q&A
  • Please silence smart devices
slide-5
SLIDE 5

Session Path

  • Introduction to the Multi-user Geodatabase
  • Versioning
  • Types of Editing
  • Archiving
  • Geodatabase Replication
  • Q & A
slide-6
SLIDE 6

Session Path

  • Introduction to the Multi-user Geodatabase
  • What is the Geodatabase?
  • The Geodatabase Management Approach
  • Different types of Geodatabases
  • The Multi-user Geodatabase
  • Versioning
  • Types of Editing
  • Archiving
  • Geodatabase Replication
  • Q & A
slide-7
SLIDE 7

What is the Geodatabase?

  • Physical data store
  • Core ArcGIS data model
  • Transactional model
  • COM components
slide-8
SLIDE 8

Personal GDB File GDB Multi-user GDB (3 editions) Storage format Microsoft Access Folder of binary files DBMS Storage capacity 2 GB 1 TB per table* Depends on edition Supported O/S platform Windows Any platform Depends on edition Number of users Single editor Multiple readers Single editor Multiple readers Multiple editors & readers Distributed GDB functionality Check out/check in One way replication Check out/check in One way replication Replication (all types) & versioning

Three Types of Geodatabases

slide-9
SLIDE 9

Geodatabase Data Management Approach

Extend functionality and data integrity

Short transactions Flexibility

DBMS

Reliability Integrity Scalability Simple classes logic

A

slide-10
SLIDE 10

Geodatabase Data Management Approach…

Editing and data compilation

Oops!

slide-11
SLIDE 11

Geodatabase Data Management Approach…

  • Versioning workflows
  • Long transactions
  • Distributed data management
  • Robust, customizable framework
slide-12
SLIDE 12

What is a Multi-user Geodatabase?

  • Also called an ArcSDE Geodatabase
  • ESRI’s geospatial technology
  • Unique capabilities:
  • Many supported DBMSs
  • Full, open SQL access
  • Versioning
  • Replication
  • Archiving
slide-13
SLIDE 13

How is ArcSDE technology included in ArcGIS?

Multi-user Geodatabase

A

Operating system DBMS ArcSDE Geodatabase

ArcGIS

slide-14
SLIDE 14

ArcSDE for ArcGIS Desktop ArcSDE for ArcGIS Server Workgroup ArcSDE for ArcGIS Server Enterprise ArcGIS Product ArcGIS and Desktop Engine* ArcGIS Server Workgroup ArcGIS Server Enterprise Administration ArcGIS Desktop (ArcCatalog) ArcGIS Desktop (ArcCatalog) ArcGIS Desktop, Geoprocessing tools

Three editions of Multi-user Geodatabase

Scale from small, personal systems up to workgroups and very large enterprises

slide-15
SLIDE 15

ArcSDE for ArcGIS Desktop ArcSDE for ArcGIS Server Workgroup ArcSDE for ArcGIS Server Enterprise ArcGIS Product ArcGIS Desktop and Engine ArcGIS Server Workgroup ArcGIS Server Enterprise Number of users Max 3 users, 1 editor at any one time Max 10 clients at one time No limit to the number of connections Unlimited Administration ArcGIS Desktop (ArcCatalog) ArcGIS Desktop (ArcCatalog) ArcGIS Desktop, Geoprocessing tools

Which Multi-user Geodatabase edition?

slide-16
SLIDE 16

ArcSDE for ArcGIS Desktop ArcSDE for ArcGIS Server Workgroup ArcSDE for ArcGIS Server Enterprise ArcGIS Product ArcGIS Desktop and Engine ArcGIS Server Workgroup ArcGIS Server Enterprise Number of users Max 3 users, 1 editor at any one time Max 10 clients at one time No limit to the number of connections Unlimited Supported DBMS SQL Server Express SQL Server Express Oracle, SQL Server, DB2, Informix, PostGreSQL Administration ArcGIS Desktop (ArcCatalog) ArcGIS Desktop (ArcCatalog) ArcGIS Desktop, Geoprocessing tools

Which Multi-user Geodatabase edition?

slide-17
SLIDE 17

ArcSDE for ArcGIS Desktop ArcSDE for ArcGIS Server Workgroup ArcSDE for ArcGIS Server Enterprise ArcGIS Product ArcGIS Desktop and Engine ArcGIS Server Workgroup ArcGIS Server Enterprise Number of users Max 3 users, 1 editor at any one time Max 10 clients at one time No limit to the number of connections Unlimited Supported DBMS SQL Server Express SQL Server Express Oracle, SQL Server, DB2, Informix, PostGreSQL Resource limits Max database size 4 Gig 1 GB RAM on a single cpu Max database size 4 Gig 1 GB RAM on a single cpu No limits Administration ArcGIS Desktop (ArcCatalog) ArcGIS Desktop (ArcCatalog) ArcGIS Desktop, Geoprocessing tools

Which Multi-user Geodatabase edition?

slide-18
SLIDE 18

Session Path

  • Introduction to the Multi-user Geodatabases
  • Versioning
  • What is it?
  • Why Use Versioning?
  • Types of Editing
  • Archiving
  • Geodatabase Replication
  • Q & A
slide-19
SLIDE 19

Versioning: What is it?

  • Multi-user Technology
slide-20
SLIDE 20
  • An alternative view of the Geodatabase
  • Edits independent of other versions

Parks

Version:

slide-21
SLIDE 21
  • An alternative view of the Geodatabase
  • Edits independent of other versions

Version:

Parks

slide-22
SLIDE 22

Why Use Versioning?

  • Multiple Editors
  • Different Views of the Data
  • Editing Complex Data (e.g. Geometric Networks)
  • Replication and Archiving
slide-23
SLIDE 23

Why Use Versioning?...

  • Model what-if scenarios

Analyst Public

  • Editing with long transactions
  • Isolate work across multiple sessions
  • Edits do not impact others

Flood Public

slide-24
SLIDE 24

Session Path

  • Introduction to the Multi-user Geodatabase
  • Versioning
  • Types of Multi-user Geodatabase Editing
  • Versioned Editing
  • Non-Versioned Editing
  • Editing through SQL
  • Archiving
  • Geodatabase Replication
  • Q & A
slide-25
SLIDE 25

Editing Multi-user Geodatabases

  • Short Transactions
  • E.g., ATM transactions, Library records, Timecards
  • Long Transactions
  • E.g., Parcel updates
  • General geographic editing
  • GIS editors need both short and long transactions

Farmland Residential

slide-26
SLIDE 26

Three ways to edit Multi-user Geodatabases

  • Versioned Editing (Long Transactions)
  • Non-Versioned Editing (Short Transactions)
  • Editing through SQL (Short Transactions)
slide-27
SLIDE 27

Versioned Editing

  • Versioned Edit Sessions
  • Through a version
  • Concurrent editing
  • Long transactions (hours/days)
  • Undo/Redo

DEFAULT Design Work Order

slide-28
SLIDE 28

How Versioning Works

  • ….Register as Versioned

Business or Base table

slide-29
SLIDE 29

How Versioning Works

  • Registered as Versioned
  • Creates Adds and Deletes tables for tracking edits
slide-30
SLIDE 30

How Versioning Works

  • Adding Features
  • Record added to the Adds Table
  • Version will be referenced (SDE_State_ID Field)
slide-31
SLIDE 31

How Versioning Works

  • Deleting Features
  • Record added to Deletes Table
  • Version will be referenced (Deleted_At field)
slide-32
SLIDE 32

How Versioning Works

  • Updating Features
  • Record added to both Adds and Deletes table
  • Version will be referenced (SDE_State_ID Field)
slide-33
SLIDE 33

How Versioning Works

  • Versioned feature classes:
  • Base Tables, Adds Tables & Deletes Tables

Deletes Tables Adds Tables

ArcGIS

Base Tables

A

slide-34
SLIDE 34
slide-35
SLIDE 35

Versioned Editing – Reconcile and Post

  • How can versions be merged?
slide-36
SLIDE 36

Versioned Editing – Reconcile

  • Incorporate changes from the target version
slide-37
SLIDE 37

Reconcile and Conflicts

  • No locks on edit
  • Data overwritten?
  • Conflict detection
  • Conflict Resolution Dialog

A

slide-38
SLIDE 38

Versioned Editing – Post

  • Incorporate with target version
  • After a post versions are identical
slide-39
SLIDE 39
slide-40
SLIDE 40

Non-Versioned Editing

  • Directly editing the base tables
  • Benefits IT integration
  • Database integrity rules
  • Simple data only (Points, Lines, Polygons)

Deletes Tables Adds Tables Base Tables

slide-41
SLIDE 41

But I want both…

Deletes Tables Adds Tables Base Tables Deletes Tables Adds Tables Base Tables

Versioned Non-versioned

slide-42
SLIDE 42

Versioned Editing - Move to Base Option

  • Hybrid
  • versioned and non-versioned
  • Simple data only
  • Points, lines, polygons, annotation, relationship classes

IT integration Database constraints

slide-43
SLIDE 43

SQL Editing

  • Attributes
  • Geometry
  • Spatial Types
  • Non-ESRI Client
  • SQL access to geometries
  • Versions
  • No geodatabase functionality
slide-44
SLIDE 44

Multi-user Geodatabase Editing Summary

  • Three ways to edit data
  • 1. Versioned Editing
  • 2. Non-Versioned Editing
  • 3. SQL Editing
  • Which one do I use?
  • Depends: > Short vs. Long Transactions?

> non-ESRI clients? > Multi-editor requirement?

slide-45
SLIDE 45

Session Path

  • Introduction to the Multi-user Geodatabases
  • Versioning
  • Types of Editing
  • Archiving
  • What is it?
  • How is it used?
  • Geodatabase Replication
  • Q & A
slide-46
SLIDE 46

Geodatabase Archiving: What is it?

  • Versioned edit history
  • Default version only
  • Temporal queries

Time

slide-47
SLIDE 47

Geodatabase Archiving: How it works

  • Extends versioning

1.

Register as Versioned

2.

Enable Archiving

F T Archive Table

Base Table Delta Tables Adds Deletes Default version

A

slide-48
SLIDE 48

Geodatabase Archiving: How it works

  • Save edits on the Default version
  • changes added to archive table

F T Archive Table

Base Table Delta Tables Adds Deletes

A

slide-49
SLIDE 49

Geodatabase Archiving: usage

  • Two query methods
  • specific date and time
  • historical marker

A

slide-50
SLIDE 50
slide-51
SLIDE 51

Session Path

  • Introduction to Multi-user Geodatabases
  • Versioning
  • Types of Editing
  • Archiving
  • Geodatabase Replication
  • Q & A
slide-52
SLIDE 52

Geodatabase Replication

  • Distribute subsets of data
  • Platform independent
  • Data edited independently
  • synchronized when needed

Parent Child Child Child Child

slide-53
SLIDE 53

Distributed Geodatabase Use Cases

Multiple levels Mobile Users Regional offices Production / Publication

Other Clients ArcGIS Server

slide-54
SLIDE 54

Geodatabase Replication - Concepts

  • You can replicate :
  • A specific version
  • Specific datasets
  • A subset of features in the chosen datasets

Source Target

Parent Replica_A Child Replica_A A

slide-55
SLIDE 55

Three Types of Replicas

One-way Two-way

Multiple times edits

Child geodatabase Parent geodatabase

edits

Child geodatabase Parent geodatabase

Check out / Check in

Once only edits

Child geodatabase Parent geodatabase

OR

Multiple times

A

slide-56
SLIDE 56
slide-57
SLIDE 57

Geodatabase Replication - Summary

  • Distribute data across Geodatabases
  • Different Replication workflows
  • Check out / Check in
  • One-way
  • Two-way
slide-58
SLIDE 58

Session Path - Summary

  • Introduction to the Multi-user Geodatabases
  • Versioning
  • Types of Editing
  • Archiving
  • Geodatabase Replication
slide-59
SLIDE 59

Thank you for attending!

Please fill out session surveys

www.esri.com/ucsessionsurveys

Offering ID: ###

Questions??

slide-60
SLIDE 60

Understanding our world.

slide-61
SLIDE 61

Type Presentation Name Here

Put presentation name on the footer: Go to Insert tab > Header & Footer > Apply to All

slide-62
SLIDE 62

Technical Workshop

2013 Esri International User Conference

July 8–12, 2013 | San Diego, California

slide-63
SLIDE 63
slide-64
SLIDE 64
slide-65
SLIDE 65
slide-66
SLIDE 66
slide-67
SLIDE 67

Type Presentation Name Here