Database-type Data source Introduction

1.1 Supported Databases

At present Supports SQLPlus, PostgreSQL, OraclePlus, Oracle Spatial, PostGIS, Yukon, MySQL, PolarDBGanos, GaussDB 200, DMPlus, KingBase, HighGoDB, ES, SHENTONG, Vastbase, Yashan 16 Database-type Datasource.

1.2 Compare with File Database

  • File Database: Map display is faster in the case of small data volume, and Data Migration is convenient;
  • Database-type Datasource: supports concurrency.

If the amount of data is very large, it is uncertain whether File Database must not be used. The selection of Datasource Type is related to the final data size and organization. If you need to confirm, please contact the support center.

1.3 Connection mode

SuperMap connects the database with SuperMap products through the self-developed database engine, and saves the space and attribute Data in the database through the database engine. Each database supported by SuperMap has a corresponding database engine file. For example, the Oracle database engine file is the SuOracleCI. DLL file under the Bin directory.

Data Save management in the database does not require the customer to perform any operation on the tables in the database, and the SuperMap interface can be directly used for storage management.

1.4 Associated Business Table

SuperMapDataset stored in the database can be operated through the existing interface in SuperMap. SuperMap provides corresponding interfaces to realize association query and association Create Thematic Map between business tables and SuperMapDataset. Currently, one-to-one association is supported, and one-to-many and many-to-many are not supported.