The Geospatial Value Chain: Stage Four

This post is the fourth in a five part series and will explain the five stages of the Autodesk geospatial value chain. The five-stage model may help you understand where you are today and how you can extend the value of your geospatial data going forward. This series is taken from the "Best Practices for Managing Geospatial Data" document.

Stage Four: Spatial Databases

Moving from Stage 3 to 4, you extend the use of your information. At this stage, you start to make full use of relational databases. Stage 3 and Stage 4 are almost the same, except Stage 3 is still a file-based environment (for example, based on SDF) while Stage 4 is based on a relational database management system (RDBMS). If you are already at Stage 3, it is very easy to migrate from SDF or SHP files to a full-scale RDBMS, such as Oracle or Microsoft SQL Server. With AutoCAD Map 3D, you can move from one type of database solution to another as your requirements evolve. Any database schema can be translated into any other. You don’t need proprietary middleware, so you are never locked into any one database or software vendor.

In Stage 4 you gain the benefits of:

➔ RDBMS security and scalability

➔ Multiple users reading and writing any information

➔ Sophisticated data models

You may find that you want to move up to a database after you have been using SDF or SHP and have been in Stage 3 for a while. For example, you may have a lot more people interested in, or dependent upon, the data. You may be wondering how you are going to organize and manage the rules and security models for these additional people. How will you scale a system that supports at present only ten people to hundreds or even thousands more users? Stage 4 is based on the same data as Stage 3, but employs more powerful software to meet the requirements of an expanded organization.