600 likes | 860 Views
ArcSDE 8 New Name - New Possibilities. ESRI EUROPEAN USER CONFERENCE. Hubertus Schöllmann ESRI Germany. Why are you here?. Introduction to ArcSDE? Want to know what‘s new in ArcSDE 8? Existing SDE user or new user? Existing ArcInfo user? Technical details on implementation?
E N D
ArcSDE 8New Name - New Possibilities ESRI EUROPEAN USER CONFERENCE Hubertus Schöllmann ESRI Germany
Why are you here? • Introduction to ArcSDE? • Want to know what‘s new in ArcSDE 8? • Existing SDE user or new user? • Existing ArcInfo user? • Technical details on implementation? • Just confused... Why are you here?
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? • What‘s new in ArcSDE 8? Answers
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
What is ArcSDE 8?(Arc Spatial Database Engine) What is ArcSDE 8?
What is ArcSDE 8? • A program on your computer/server What is ArcSDE 8?
What is ArcSDE 8? • A server application that works in cooperation with a DBMS What is ArcSDE 8?
What is ArcSDE 8? • A way to store, manage and access spatial data What is ArcSDE 8?
What is ArcSDE 8? • A program that can be used with different clients What is ArcSDE 8?
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?
ArcSDE Architecture • Open Application Program Interface Client Application ArcSDE Client API ArcSDE Server DBMS Server What is ArcSDE 8?
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?
Search and Retrieve SDE Server DBMS Cooperative C/S-Processing Questions Client Intensive Geoprocessing Functions Results What is ArcSDE 8?
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 C/S-Processing What is ArcSDE 8?
What kind of data can I store with ArcSDE 8 into a DBMS? What is ArcSDE 8?
DBMS Annotation • All data (spatial and attributes) stored in the DBMS Open Image Coverages Raster Shapefiles CAD What is ArcSDE 8?
How are data stored? • in tables (attributes and geometrie) • in Geodatabase (attributes, geometrie, and metadata) Data storage
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
How can I use ArcSDE 8? Using ArcSDE 8
ArcSDE 8 Clients ArcInfo 8.0 API API API ArcIMS 3.0 API API ArcSDE 8 DBMS Server API API ArcView 3.2 MapObjects 2.1 ArcExplorer X CAD Client 1.2 OpenGIS/ C-API Using ArcSDE 8
ArcSDE 8 supported databases and operating systems! • ArcSDE 8 – Database Version? • ArcSDE 8 – Operating System Version? • --> Contact your local distributor!!! Using ArcSDE 8
You should use ArcSDE 8... Using ArcSDE 8
You should use ArcSDE 8... • Central Data Storage Using ArcSDE 8
You should use ArcSDE 8... • Cost effective data management Using ArcSDE 8
You should use ArcSDE 8... • Access of many (different) clients without loss of performance Using ArcSDE 8
You should use ArcSDE 8... • Each ESRI product can access Using ArcSDE 8
You should use ArcSDE 8... • Own applications can access with C-API Using ArcSDE 8
You should use ArcSDE 8... • Store your data for Internet/Intranet Using ArcSDE 8
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
ArcSDE 8 - ArcSDE - SDE 3.0 – SDE for Coverages- Personal SDE – Personal Geodatabase? Naming
ArcSDE • 1998 • SDE 3.0: Spatial Database Engine for RDBMS • SDE for Coverages • ArcSDE = SDE 3.0 + SDE for Coverages Naming
ArcSDE 8 rw - multi-user ro - multi-user • 1999 rw - single-user ArcSDE 8 Oracle SQL Server Informix DB2 Sybase Personal Coverages Your choice DBMS Files Naming
Product Boxes • 1999 ArcInfo 8 Box ArcSDE 8 Box ArcSDE 8 ArcIMS Box DB2 Oracle SQL Server Informix DB2 Sybase Personal Coverages Your choice DBMS Files Naming
How do I get ArcSDE 8? Getting ArcSDE
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
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
What‘s new in ArcSDE 8? What‘s new?
What‘s new in ArcSDE 8? • New ArcSDE table schema What‘s new?
New ArcSDE 8 table schema (1.) • Version table • Layers table • Geometry columns table • Raster columns table • Spatial references table • Table registry table • Business table What‘s new?
New ArcSDE 8 table schema (2.) • Versions table • States tables • Logfiles tables • Geolocation tables • Meta-data table • Logical network tables • Geodatabase tables What‘s new?
What‘s new in ArcSDE 8? • Table registry What‘s new?
Table registry (1.) Provides a central repository of tables, that the ArcSDE software manages directly or must be accessible for an application. What‘s new?
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 What‘s new?
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) What‘s new?
What‘s new in ArcSDE 8? • Long transactions with state and version support - Pessimistic and optimistic locking (versioning) What‘s new?
Long transactions with state and version support - pessimistic and optimistic locking (versioning) • transactions over more sessions • locking mechanism is needed What‘s new?
Pessimistic locking • layer locks • area locks • row locks What‘s new?
Default- Version Town planer A Hydraulic engineer B Water pipe enlarge street widen, move water pipe New Default- Version Optimistic locking • Versioning Conflict and Conflict Solution What‘s new?
What‘s new in ArcSDE 8? • New shape formats What‘s new?
New shape formats • well-known binary • well-known text • OpenGIS standard (Open GIS Consortium) What‘s new?