|Original author(s)||Geographic Technologies Incorporated (GTI)|
|Operating system||MS Windows; AIX, HP-UX, GNU/Linux, Solaris|
|Type||Geographic information system|
ArcSDE (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.
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, and Esri purchased Salamanca Software in 1996. 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 for robust multi-user editing, storage and access of extremely large geospatial databases. ArcSDE supports the Esri geodatabase implementation.
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.
ArcSDE 10.1 and 10.2
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
After 2010, there are some alternative tools for connecting ArcMap with DBMS Postgres, SQL Server.. such as ST-Links PgMap.
ArcSDE enables organizations to move from a traditional approach — managing a separate collection 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.
ArcSDE as an application server facilitates storing and managing spatial data (raster, vector, and survey) 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.
- Jacobson, Robert (1995). "The GIS Networker".
- "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 (2013). "An Approach for Geospatial Data Organization and Management based on Multi-grid Model". In Bian, Fuling; Cui, Xiaohui; Zeng, Yixin. 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 398. Springer. 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.