ArcSDE

Last updated
ArcSDE
Original author(s) Geographic Technologies Incorporated (GTI)
Developer(s) Esri
Initial release1995 (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/

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.

Contents

History

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

As of June 2012 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.

Functionality

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.

Related Research Articles

<span class="mw-page-title-main">Ingres (database)</span> Database software

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

<span class="mw-page-title-main">PostGIS</span> Geospatial extension for the PostgreSQL Database

PostGIS is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC).

<span class="mw-page-title-main">Esri</span> Geospatial software & SaaS company

Environmental Systems Research Institute, Inc., doing business as Esri, is an American multinational geographic information system (GIS) software company headquartered in Redlands, California. It is best known for its ArcGIS products. With a 40% market share in 2011, Esri is one of the world's leading supplier of GIS software, web GIS and geodatabase management applications.

A GIS file format is a standard for encoding geographical information into a computer file, as a specialized type of file format for use in geographic information systems (GIS) and other geospatial applications. Since the 1970s, dozens of formats have been created based on various data models for various purposes. They have been created by government mapping agencies, GIS software vendors, standards bodies such as the Open Geospatial Consortium, informal user communities, and even individual developers.

<span class="mw-page-title-main">ArcIMS</span>

ArcIMS is a Web Map Server produced by Esri accessible through a web browser. It is a GIS that is designed to serve maps across the Internet. Sometimes these maps are just static images allowing simple panning and zooming, while others are more complex pages. Examples of interactive maps served with ArcIMS include maps with layers that can be turned on and off, or with features containing attributes that can be queried.

<span class="mw-page-title-main">TerraLib</span> Geographic information system software library

TerraLib is an open-source geographic information system (GIS) software library. It extends object-relational database management systems (DBMS) to handle spatiotemporal data types.

<span class="mw-page-title-main">MonetDB</span> Open source column-oriented relational database management system

MonetDB is an open-source column-oriented relational database management system (RDBMS) originally developed at the Centrum Wiskunde & Informatica (CWI) in the Netherlands. It is designed to provide high performance on complex queries against large databases, such as combining tables with hundreds of columns and millions of rows. MonetDB has been applied in high-performance applications for online analytical processing, data mining, geographic information system (GIS), Resource Description Framework (RDF), text retrieval and sequence alignment processing.

A GIS software program is a computer program to support the use of a geographic information system, providing the ability to create, store, manage, query, analyze, and visualize geographic data, that is, data representing phenomena for which location is important. The GIS software industry encompasses a broad range of commercial and open-source products that provide some or all of these capabilities within various information technology architectures.

<span class="mw-page-title-main">Manifold System</span>

Manifold System is a geographic information system (GIS) software package developed by Manifold Software Limited that runs on Microsoft Windows. Manifold System handles both vector and raster data, includes spatial SQL, a built-in Internet Map Server (IMS), and other general GIS features.

<span class="mw-page-title-main">ArcGIS</span> Geographic information system maintained by Esri

ArcGIS is a family of client, server and online geographic information system (GIS) software developed and maintained by Esri.

ArcInfo is a full-featured geographic information system produced by Esri, and is the highest level of licensing in the ArcGIS Desktop product line. It was originally a command-line based system. The command-line processing abilities are now available through the GUI of the ArcGIS Desktop product.

A spatial database is a general-purpose database that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data.

ArcGIS Server is the core server geographic information system (GIS) software made by Esri. ArcGIS Server is used for creating and managing GIS Web services, applications, and data. ArcGIS Server is typically deployed on-premises within the organization’s service-oriented architecture (SOA) or off-premises in a cloud computing environment.

A geographic data model, geospatial data model, or simply data model in the context of geographic information systems, is a mathematical and digital structure for representing phenomena over the Earth. Generally, such data models represent various aspects of these phenomena by means of geographic data, including spatial locations, attributes, change over time, and identity. For example, the vector data model represents geography as collections of points, lines, and polygons, and the raster data model represent geography as cell matrices that store numeric values. Data models are implemented throughout the GIS ecosystem, including the software tools for data management and spatial analysis, data stored in a variety of GIS file formats, specifications and standards, and specific designs for GIS installations.

MapDotNet is a suite of geographic information system (GIS) software products developed by ISC that run on Microsoft Windows. The GIS software competes with ESRI and MapInfo GIS products. MapDotNet UX is the latest generation and consists of a set of WCF web services for rendering map images and tiles and for performing spatial analysis and editing. UX includes an SDK for developing rich interactive mapping applications on Microsoft Silverlight, Windows Presentation Foundation and HTML5. MapDotNet UX also includes an Extract, Transform & Load (ETL), map design and tile cache creation tool called Studio modeled after Microsoft's Expression series of products. The MapDotNet UX renderer is built on WPF and consumes spatial data from multiple sources including Shapefiles, PostGIS, ArcSDE, Oracle Spatial, SQL Azure, SQL Server 2008 R2 and SQL Server 2012.

<span class="mw-page-title-main">SpatiaLite</span> Spatial extension to SQLite

SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality. It is similar to PostGIS, Oracle Spatial, and SQL Server with spatial extensions, although SQLite/SpatiaLite aren't based on client-server architecture: they adopt a simpler personal architecture. i.e. the whole SQL engine is directly embedded within the application itself: a complete database simply is an ordinary file which can be freely copied and transferred from one computer/OS to a different one without any special precaution.

Geographic information systems (GIS) play a constantly evolving role in geospatial intelligence (GEOINT) and United States national security. These technologies allow a user to efficiently manage, analyze, and produce geospatial data, to combine GEOINT with other forms of intelligence collection, and to perform highly developed analysis and visual production of geospatial data. Therefore, GIS produces up-to-date and more reliable GEOINT to reduce uncertainty for a decisionmaker. Since GIS programs are Web-enabled, a user can constantly work with a decision maker to solve their GEOINT and national security related problems from anywhere in the world. There are many types of GIS software used in GEOINT and national security, such as Google Earth, ERDAS IMAGINE, GeoNetwork opensource, and Esri ArcGIS.

The following is provided as an overview of and topical guide to databases:

The following outline is provided as an overview of and topical guide to MySQL:

A Geodatabase is a proprietary GIS file format developed in the late 1990s by Esri to represent, store, and organize spatial datasets within a geographic information system. A geodatabase is both a logical data model and the physical implementation of that logical model in several proprietary file formats released during the 2000s. The geodatabase design is based on the spatial database model for storing spatial data in relational and object-relational databases. Given the dominance of Esri in the GIS industry, the term "geodatabase" is used by some as a generic trademark for any spatial database, regardless of platform or design.

References

  1. ↑ Jacobson, Robert (1995). "The GIS Networker".{{cite journal}}: Cite journal requires |journal= (help)
  2. ↑ "SpatialDB Advisor: Biography".
  3. ↑ "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.
  4. ↑ "Geodatabase (web page), ArcSDE Technology (subtitle)". Esri. Retrieved 2012-03-17.
  5. ↑ 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.
  6. ↑ 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.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.