Knowledge Base Article
KB10189 - What database management system is used by the TatukGIS DK and IS products? Is it object orientated or relational? Does your DMS see the database as a huge area or do you split geometrically the database into pieces?
The DK may be joined in a relational manor to most SQL-type databases via ADO or DBX. Supported database products include MSSQL, Oracle, Interbase, MSJET (MDB ), DB2, sapDB, MySQL, Advantage, and PostgreSQL. Querying is performed against SQL tables via ADO or DBX. Both raster and vector coverages may also be loaded to SQL geodatabase layers. TatukGIS products support three SQL database vector layer formats: i) OpenGIS SQL Simple Features Implementation (publicly documented at www.opengis.org), ii) Geomedia Access Warehouse and SQL Server, and iii) the TatukGIS binary format. Raster image files can be loaded as a mosaiced SQL database layer using the TatukGIS PixelStore format.
SQL vector coverages are generally managed as one huge database, but the data can be split into segments as well. For PixelStore raster imagery coverages, each image of a mosaic cell is a separate record.
TatukGIS products also support the Oracle Spatial/Locator and the ESRI ArcSDE and Personal Geodatabase spatial data structures. Support for other spatial database formats, e.g., MSSQL 8/spatial, PostGIS, etc. will be provided in a future product update.
Created: 2005-09-14, Modified: 2008-08-25
|