In terms of data management, since data is generally stored and managed based on a certain data model, and the data model usually contains more specific sub-data models such as point/line/region, network, mosaic dataset, etc. Therefore The first step of data migration is to replace other data models with SuperMap data model; on the other hand, these data are actually stored in the form of individuals, files or databases, so these storage media need to be converted to corresponding SuperMap database for storage.
Data migration is divided into data model migration and geodatabase migration.
The following content explains the data model and database migration in detail taking the migration of ArcGIS platform as an example.
Data Model Migration
- ArcGIS Data Model
- SuperMap Data Model
- Migrant Data Model
SuperMap iDesktopX supports conversion of data types including: vector, raster, image, mosaic data, network, attribute table, and text data, importing data from SQL Server, Oracle, and PostgreSQL databases in SDE into the SuperMap datasource. At the same time, it supports importing SHP data, and all SHP data in the folder can be imported into SuperMap datasource in batches. The corresponding relationship of data type conversion is as follows:
Geodatabase is a data model that uses standard relational database technology and an object-oriented approach to represent geographic information. It supports the storage and management of geographic information in standard database management system (DBMS) tables. It organizes geographic data according to hierarchical data objects, including Object Class, Feature Class, Feature Dataset, etc. Geodatabase can be regarded as a data management model, which integrates the storage and management of data like vector, raster, address, network, and projection data. Its expression of geographical spatial characteristics is close to people's cognition of the real world.
Dataset is used to store spatial objects of the same type and is one of the basic organizational units of SuperMap GIS spatial data. Currently, it supports point datasets, line datasets, region datasets, tabular datasets, network datasets, composite datasets, text datasets, routing datasets, and image/raster datasets.
Comparison of mosaic dataset import effects:
Introduction to ArcGIS Geodatabase
ArcGIS geodatabase types include personal geodatabases, file geodatabases, and enterprise geodatabases.
- Personal Geodatabase: is the native data format for ArcGIS geodatabases that is stored and managed in Microsoft Access data files. This size of data file is at most 2 GB and is only available for Windows operating systems.
- File Geodatabase: is a collection of various types of GIS datasets saved in a file system folder, each saved as a file that can expand up to 1 TB in size.
- Enterprise Geodatbase/ArcSDE: is a collection of various types of GIS datasets saved as tables in a relational database, with no limit on size or number of users. This type of database is stored in a relational database using Oracle, Microsoft SQL Server, IBM DB2, IBM Informix, or PostgreSQL.
Introduction to SuperMap Geodatabase
SuperMap SDX+ is a spatial database engine. It can realize the integrated storage of GIS spatial geometric objects and attribute data into a variety of relational databases, and realize data editing, index management, and spatial query.
- File Engine
- Database Engine
- Distributed
- Supported databases
The file engines supported by SuperMap SDX+ include: SuperMap customized UDB/UDBX engine, Shapefile file engine, original image file engine, and vector tile file engine. Among them, UDBX is an expansion and enhancement of SuperMap customized UDB engine, and its functions are more stable. The UDB engine is the only file-type spatial data engine in the SuperMap Objects custom format. A data project of the UDB engine includes two files. The file with the extension UDB stores spatial data and uses OLE compound document technology; the file with the extension UDD is an attribute database and uses the SQLite database format. Since UDB/UDBX files use compound document technology, UDB/UDBX files support both vector data and image data storage.
The database engines supported by SuperMap SDX+ are mainly targeted at relational database management systems such as Oracle, SQLServer, and Kingbase, as well as Alibaba POLARDB and Huawei GaussDB databases. At the same time, it also supports for PostGIS, the native spatial engine in PostgresSQL.
SuperMap SDX+ supports current mainstream commercial or opensource distributed database platforms, including MongoDB, Elasticsearch, HDFS, HBase, and DSF. These databases all provide distributed and scalable technical architectures, and provide relevant solutions specifically for spatial big data application scenarios.
Related Contents