How to maintain your data model whilst integrating complex geospatial datasets

The Spatial Database Administrator (SDBA) has been designed to assist data managers in integrating and loading complex datasets (particularly geospatial data) into a repository without changing the organisation's existing data model.

SDBA is a web-based application, built using ColdFusion Model-Glue framework from the ground up to integrate tightly with Oracle Spatial/Locator and MapGuide Open Source.

Data providers such as PSMA, GA and DSE in Australia often change the structure of their supplied data, which causes numerous difficulties to data managers. Changes such as inconsistent column names and modified relationships between data sets have often caused data managers to consistently change existing data model that has been used to drive other systems such as the website, content management system and even finance.

SDBA will take care of building the relationship between input geospatial datasets to your Oracle data model.

• Companions to Autodesk MapGuide product suite
• Map disparate vendor datasets into your own common data models
• Allows a derived data model to be designed from source data
• Import ESRI shapefiles (shp/shx/dbf) to Oracle
• Export MapGuide spatial data files (sdf) from Oracle Spatial
• Easy denormalisation of datasets for easier mapping
• Automatically generates Autodesk MapGuide layers and datasource definitions
• Integrated Autodesk MapGuide backup and restore
• Web Map Service (WMS) browsing
• Built-in Oracle Spatial data management tools
• Full user/group/role management which can be customized

• Eliminate the dependency of the spatial data on their vendor data models and map them into a single common data model
• Eliminate the processing and loading of the spatial data manually, while documenting the mapping process of the spatial data automatically
• Saves the time and cost spent on translating and transforming the disparate spatial datasets into another format
• Quick visualization of spatial data using the built-in Web Map Service (WMS) browser
• Data Managers would not require intimate knowledge of Oracle Spatial to effectively manage their valuable datasets

• Loading flat spatial data files in Oracle
• Managing the existing Oracle Spatial data
• Indexing the spatial data
• Managing the spatial extents
• Visualizing the spatial data
• Viewing the column data
• Managing sdo_geom metadata
• Managing user and table spaces