GISRSStudy » ArcGIS » DBMS Database

DBMS Database in ArcGIS

DBMS stand for Database Management System. A database required on all machines that connect to a database management system.

You might have spatial or nonspatial data in a database that you want to use in ArcGIS. That database does not have to contain an enterprise Geodatabase for you to connect directly to it from the Catalog tree in ArcGIS for Desktop.

Database Server

In ArcGIS software, the term database servers refers to instances of Microsoft SQL Server Express that have been enabled to store desktop or workgroup Geodatabases.

To set up a database server, install SQL Server Express and enable it to store Geodatabases, add a connection to the SQL Server instance under the Database Servers node in the Catalog tree, and create Geodatabases.

DBMS Data Types supported in ArcGIS

  • Dameng
  • IBM Db2
  • IBM Informix
  • Microsoft SQL Server
  • Oracle
  • PostgreSQL
  • SAP HANA
  • SQLite
  • Teradata Warehouse Appliance

Dameng

Data typesDameng data types created
BLOBBLOB
DateDatetime6
DoubleDec(p,s)
FloatDec(p,s)
GeometryST_Geometry
GUIDChar(38)
Long IntegerInteger
Object IDInteger
Short IntegerSmallint
TextVarchar

IBM Db2

Data typesDb2 data types created
BLOBBLOB
Datetimestamp
Doubledecimal(p,s)
Floatdecimal(p,s)
GeometryST_Geometry
Global IDchar(38)
GUIDchar(UUID len)
Long Integerinteger
Object IDCharacter(38) when created in enterprise geodatabasesInteger with identity property when created in a database
RasterBLOB
Short Integersmallint
Textvarchar

IBM Informix

Data typesInformix data types created
BLOBBLOB
Datedatetime
Doubledecimal(31,8)
Floatdecimial(31,8)
GeometryST_Geometry
Global IDchar(38)
GUIDchar(UUID len)
Long Integerinteger
Object IDchar(38) when created in an enterprise geodatabaseserial when created in a database
RasterBLOB
Short Integersmallint
Textvarchar

Microsoft SQL Server

Data typesSQL Server data types created
BLOBvarbinary(max)
Datedatetime2(7)
Doublenumeric(p,s)
Floatnumeric(p,s)
Geometryintgeometrygeography
Global IDuniqueidentifier
GUIDuniqueidentifier
Long integerint
RasterBLOB, int
OBJECT IDint(4) when created in an enterprise geodatabaseinteger with identity property when created in a database
Short integersmallint
Textvarchar, nvarchar, varchar(max), nvarchar(max)

Oracle

Data typesOracle data types created
BLOBBLOB
Datetimestamp
Doublenumber(38,8)
Floatnumber(38,8)
GeometryST_Geometry, number(38), or SDO_Geometry
Global IDchar or nchar (UUID len)
GUIDchar or nchar (UUID len)
Long Integernumber(38)
Object IDArcGIS to create a feature class or table in an Oracle 12c database or use the Add Incrementing ID Field geoprocessing tool to add an ID field to a table in an Oracle 12c database.
RasterBLOB or number(38)
Short Integernumber(5)
Textvarchar2, CLOB, nvarchar2, or NCLOB

PostgreSQL

Data typesPostgreSQL data types created
BLOBbyte
Datetimestamp without zone
Doublenumeric(p,s)
Floatnumeric(p,s)
GeometryST_Geometry, Geometry (PostGIS), Geography (PostGIS)
Global IDvarchar(38)
GUIDvarchar(38)
Long Integerinteger
Object IDInteger in a geodatabase Serial in a database
Rasterbytea
Short Integersmallint
Textcharacter varying

SAP HANA

Data typesSAP HANA data types created
BLOBBLOB
Datetimestamp
Doubledecimal(38,8)
Floatdecimal(38,8)
GeometryST_Geometry
Global IDcharacter(38)
GUIDcharacter(38)
Long Integerinteger
Object IDbigint
RasterNot applicable
Short Integersmallint
Textvarchar(50)

SQLite

Data typesSQLite data types created
BLOBblob(n)
Daterealdate
Doublefloat64
Floatfloat64
Geometrygeometryblob
Global IDuuidtext
GUIDuuidtext in SQLite databases, text in GeoPackage files
Long Integerint32(n)
Object IDint32
Short Integerint16(n)
Texttext(n)

Teradata Warehouse Appliance

Data typesTeradata data types created
BLOBBLOB
Datetimestamp
Doubledecimal(38,8)
Floatdecimal(38,8)
GeometryCLOB (ST_Geometry)
GUIDcharacter(38) character set latin
Long Integerinteger
Object IDinteger
Short Integersmallint
Textvarchar(50) character set unicode

Leave a Comment

Your email address will not be published.