ArcSDE (SDE for Spatial Database Engine) is a server-software sub-system (produced and marketed by Esri) that aims to enable the usage of Relational Database Management Systems for spatial data. The spatial data may then be used as part of a geodatabase.
| Original author(s) | Geographic Technologies Incorporated (GTI) |
|---|---|
| Developer(s) | Esri |
| Initial release | 1995 |
| Stable release | 10
|
| Operating system | MS Windows; AIX, HP-UX, Linux, Solaris |
| Type | Geographic information system |
| License | Proprietary |
| Website | https://web.archive.org/web/20060316161213/http://www.esri.com/software/arcgis/arcsde/ |
History edit
Geographic Technologies Incorporated (GTI) in Australia originally designed the database software, named Spatial DataBase Engine (SDBE). Development shifted to Salamanca Software Pvt Ltd., which developed the first production version. SDBE originally used the InterBase DBMS. The president of Esri, Jack Dangermond, announced SDE at the GIS'95 conference in Vancouver, British Columbia,[1] and Esri purchased Salamanca Software in 1996.[2] Esri rebranded the software as "ArcSDE" to follow the naming convention of other products.
ArcSDE grew to meet the need of users of geographic data[citation needed] for robust multi-user editing, storage and access of extremely large geospatial databases. ArcSDE supports the Esri geodatabase implementation.
The product began as stand-alone software: Esri integrated it into ArcGIS version 9.2.[3][4]
In 2013 ESRI announced plans to deprecate the ArcSDE command line tools and the ArcSDE application server following the forthcoming release of ArcGIS 10.2.[5]
ArcSDE 10.1 and 10.2 edit
As of June 2012[update] with the release of 10.1, Esri sells ArcSDE as a component of ArcGIS Server - part of the ArcGIS family of software products which integrates geographic-information query, mapping, spatial analysis, and editing within a multi-user enterprise DBMS environment.
ArcSDE alternative tools edit
After 2010, there are some alternative tools for connecting ArcMap with DBMS Postgres, SQL Server.. such as ST-Links PgMap and Blue Spatial Server.
Functionality edit
ArcSDE enables organizations to move from a traditional approach — managing separate collections of geographic data files — to an integrated environment in which one can manage spatial data as a continuous database: accessible to the entire organization simultaneously and easily publishable on the Web. It stores spatial data using the Geodatabase data model and structure.
ArcSDE as an application server facilitates storing and managing spatial data (raster, vector, and survey)[6] in a DBMS and makes the data available to many applications. ArcSDE allows one to manage spatial data in any of four commercial databases (IBM Db2, Informix, Microsoft SQL Server and Oracle). Starting with the 9.3 release, Esri added support for the open-source PostgreSQL database.
ArcSDE serves data for the advanced ArcGIS Desktop products (ArcView, ArcEditor and ArcInfo); the ArcGIS development products (ArcGIS Engine and ArcGIS Server), ArcView 3.x as well as ArcIMS. It is a key component in managing a multi-user Esri-based GIS.
While traditional RDBMS software keeps track of the tables and records contained in the database, ArcSDE pushes the relational model higher so that client software can manage geographic data - which comprise several tables - seamlessly. The user need have no awareness of nor dealings with the particulars of the RDBMS. The GIS environment routes all connections to the database through the ArcSDE middleware, which manages the storing and retrieval of data.
References edit
- ^ Jacobson, Robert (1995). "The GIS Networker".
{{cite journal}}: Cite journal requires|journal=(help) - ^ "SpatialDB Advisor: Biography".
- ^
"The Geodatabase: Modeling and Managing Spatial Data". Esri. 2009. Retrieved 2010-11-12.
Prior to ArcGIS 9.2, ArcSDE was a stand-alone software product. At the ArcGIS 9.2 release, ArcSDE was integrated into both ArcGIS Desktop and ArcGIS Server.
- ^ "Geodatabase (web page), ArcSDE Technology (subtitle)". Esri. Retrieved 2012-03-17.
- ^
Rajagopal, Sharmila (2013-06-05). "Important deprecation announcement for ArcGIS 10.1 and the upcoming release of 10.2". blogs.esri.com. Retrieved 2015-09-20.
ArcGIS 10.2 will be the last major release to include the ArcSDE command line tools and the ArcSDE application server.
- ^
Compare:
Zhang, Yongzhi; Zhang, Qiuwen; Zhang, Yan (30 October 2013). "An Approach for Geospatial Data Organization and Management based on Multi-grid Model". In Bian, Fuling; Cui, Xiaohui; Zeng, Yixin (eds.). Geo-Informatics in Resource Management and Sustainable Ecosystem: International Symposium, GRMSE 2013, Wuhan, China, November 8-10, 2013, Proceedings, Part 1. Communications in Computer and Information Science. Vol. 398. Springer (published 2013). p. 658. ISBN 9783642450259. Retrieved 2016-07-11.
Spatial data include both unstructured data and structured data. All types of these data are stored in RDBMS by ArcSDE Geodatab[a]se based on multi-grid. The unstructured data mainly include two types: vector data and raster data.