Adding a Spatial Module Centrus Database Resource

Whenever you install a new database resource or modify an existing database resource you must define it in Management Console in order for it to become available on your system. This procedure describes how to install or modify a Spatial Module database resource for a Centrus database. Centrus data is used by the Closest Site and Point in Polygon stages.

  1. If you haven't already done so, install the database files on your system. For instructions on installing databases, see the Spectrum™ Technology Platform Installation Guide.
  2. In Management Console, go to Resources > Spectrum Databases.
  3. Click the Add button to create a new database or select an existing database resource then click the Edit button to change it. You can also create a new database resource by copying an existing one, by clicking the Copy button .
  4. If you are creating a new database, enter a name for the database resource in the Name field. The name can be anything you choose. If you creating a new database by copying an existing one, rename the default name as needed. You cannot modify the name of an existing database resource, because any services or jobs that reference the database resource by its original name would fail.
  5. Change the Pool Size value if needed, by specifying the maximum number of concurrent requests you want this database to handle.
    Note: This setting represents the number of threads on the components that are listening for service requests from the Spectrum™ Technology Platform or executing a Spatial Module stage (that is, the maximum number of managed connections). Every web service request enters Spectrum from the platform and is passed to the components. The default value of 4 can be increased to accommodate greater request loads. A pool size that matches the number of CPUs is recommended. The maximum setting should not go above twice the number of the CPU core; for example, on a 4 CPU machine the combined number of threads for all services should not exceed 8. Performance tests should be run with various settings until optimal performance is achieved for the usage.
  6. In the Module field, select Centrus.
  7. In the Type field, select Centrus Database Resources.
  8. In the Path field, click the Browse button to select the full path to the Centrus database file. This file must have a .gsb or .txb extension.
  9. In the Cache Size field, select the amount of memory to use to cache data. In general, the larger the cache the better the performance. The options are:
    • None—Do not cache data.
    • Medium—Use up to 5 MB of memory to cache data. Use this setting if there is a small amount of memory available for caching.
    • Large—Use up to 20 MB of memory to cache data. Use this setting if you are processing a large number of records.
    • Huge—Use up to 100 MB of memory to cache data. Use this setting if you are processing a large number of records.
  10. Click Save. If you select the new database resource from the list and click the Edit button , you will see this information:
    • Name—The name you have given the database. This is the name to use when referencing this database from a stage or service.
    • Path—The location of the database file.
    • Cache size—The amount of memory to use to cache data from this database.
    • Feature Type—Indicates the type of spatial data contained in the database (Points, Polygons, or Lines). Points databases can be used with the Closest Site and Point In Polygon stages. Polygon databases and Line databases can be used with Point In Polygon.
    • Buffered—Indicates whether or not the database supports buffering, which is a Point in Polygon feature that allows you to define areas that are close to the edge of a point, polygon, or line.