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.

ArcSDE alternative tools

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

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">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

Esri is an American multinational geographic information system (GIS) software company. It is best known for its ArcGIS products. With a 43% market share, Esri is the world's leading supplier of GIS software, web GIS and geodatabase management applications. The company is headquartered in Redlands, California.

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.

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. ArcGIS was first released in 1999 and originally was released as ARC/INFO, a command line based GIS system for manipulating data. ARC/INFO was later merged into ArcGIS Desktop, which was eventually superseded by ArcGIS Pro in 2015. ArcGIS Pro works in 2D and 3D for cartography and visualization, and includes artificial Intelligence (AI).

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. Most spatial databases allow the representation of simple geometric objects such as points, lines and polygons. Some spatial databases handle more complex structures such as 3D objects, topological coverages, linear networks, and triangulated irregular networks (TINs). While typical databases have developed to manage various numeric and character types of data, such databases require additional functionality to process spatial data types efficiently, and developers have often added geometry or feature data types. The Open Geospatial Consortium (OGC) developed the Simple Features specification and sets standards for adding spatial functionality to database systems. The SQL/MM Spatial ISO/IEC standard is a part the SQL/MM multimedia standard and extends the Simple Features standard with data types that support circular interpolations. Almost all current relational and object-relational database management systems now have spatial extensions, and some GIS software vendors have developed their own spatial extensions to database management systems.

<span class="mw-page-title-main">QGIS</span> Open source desktop GIS software

QGIS is a free and open-source cross-platform desktop geographic information system (GIS) application that supports viewing, editing, printing, and analysis of geospatial data.

Kosmo is a desktop geographic information system (GIS) with advanced functions. It is the first of a series of developments that are being made available to the community.

MapInfo Pro is a desktop geographic information system (GIS) software product produced by Precisely and used for mapping and location analysis. MapInfo Pro allows users to visualize, analyze, edit, interpret, understand and output data to reveal relationships, patterns, and trends. MapInfo Pro allows users to explore spatial data within a dataset, symbolize features, and create maps.

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.

<span class="mw-page-title-main">Web mapping</span> Process of using the maps delivered by geographic information systems (GIS) in World Wide Web

Web mapping or an online mapping is the process of using maps, usually created through geographic information systems (GIS), on the Internet, more specifically in the World Wide Web. A web map or an online map is both served and consumed, thus, web mapping is more than just web cartography, it is a service by which consumers may choose what the map will show.

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>

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.

GIS Live DVD is a type of the thematic Live CD containing GIS/RS applications and related tutorials, and sample data sets. The general sense of a GIS Live DVD is to demonstrate the power of FLOSS GIS and encourage users to start on FLOSS GIS. However, a disc can be used for GIS data processing and training, too. A disc usually includes some selected Linux-based or Wine (software)-enabled Windows applications for GIS and Remote Sensing use. Using this disc the end users can execute GIS functions to get experience in free and open source software solutions or solve some simple business operations. The set-up and the operating behaviour of the applications can also be studied prior to building real FLOSS GIS-based systems. Recently a LiveDVD image is stored and booted from USB.

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.

A Geodatabase is a type of GIS file format for representing spatial data in a geographic information system. It is both a logical data model developed by Esri in the late 1990s, a GIS software vendor, 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.