Tools - Administrator Console

This topic describes a feature that is provided only within Manifold Database Administrator Edition and is not available in other Manifold System editions. If you have purchased and installed Database Administrator Edition the features described in this topic will be available to you. If you have installed some other Manifold System edition you will not be able to use these features.

 

images\dlg_administrator_console.gif

 

The Tools - Administrator Console dialog provides a user interface for DBMS administrators to configure and manage Manifold geospatial data storage within enterprise DBMS data stores. Once database objects are configured with Administrator Console, the enhancements and ease of use features will be available to other users using other Manifold System editions.

 

Controls

 

Data Source

The name of the last used data source. Manifold will not actually connect to the last used data source until the Refresh button is pressed. Press the browse button to launch the Data Sources dialog to choose a data source.

(contents pane)

Displays the contents of the data source.

images\xbtn_refresh.gif

Refresh - Update the contents pane.

images\xbtn_properties.gif

Properties - Launch the Properties dialog for the highlighted database object. Allows specification of the friendly name, precision, version column, formatting and server version incrementing options. Also used to configure tables for treatment as drawings with specification of geometry columns and geometry data type.

images\xbtn_triggers.gif

Triggers - Launch the Triggers dialog for the highlighted database object. View and edit triggers bound to the database object (Oracle only). Shows the trigger, type of trigger and event for each trigger as well as the procedure text.

images\xbtn_runquery.gif

Run - Press to execute the command line text in the command pane.

images\xbtn_global_filter.gif

Global Filter - Launches a dialog enabling filtering the names of database objects using regular expressions. Changes to the global filter are saved between different sessions of Manifold. By default, the global filter includes several masks suppressing display of system tables commonly found in Oracle databases. See the Tools - Database Console topic for use of the Global Filter button.

images\xbtn_columns.gif

Columns - Toggle display of desired columns on or off in the contents pane. Manifold will remember the last used columns between sessions. Data is fetched for columns from the data source on demand.

Columns include:

Component - Show the "friendly" name, that is, the Manifold component name.

Format - Enable storage of formatting for drawings. Double-click into the Format cell of a database object to enable or disable formatting.

Precision - Show location precision used in drawings.

Projection - Projection used by this database object. Double-click into the Projection cell of a database object to launch the database object Projection dialog.

Spatial Index - Reports if a generic spatial index is present for this object. Double-click into the Spatial Index cell of a database object to launch a dialog that enables creating and editing the spatial index. The bounding box of the area covered by the index is editable. A table must have a primary key to allow creation of a spatial index.

Statistics - Useful information, such as the number of objects in drawings or the number of records in tables. Caution: Do not show the Statistics column when database tables may contain very many records. It can take a very long while for some DBMS products to report how many records are in a given table.

Triggers - The number of database triggers, if any, for this object. Double-click into the Triggers cell of a database object to launch the database object Triggers dialog.

Filter

Filter by character sequence - Show only those database objects in the contents pane the name of which contain the given sequence of characters. This is particularly helpful when working with data sources with lots of objects, such as SQL Server or Oracle data sources. See the Tools - Database Console topic for use of the Filter box.

(command pane)

A text pane in which command lines, such as SQL, can be entered to be executed by the data source.

(status bar)

Information about the highlighted object will be provided at the bottom of the dialog.

 

Spatial Index Dialog Controls

 

The spatial index dialog appears when double-clicking into the Spatial Index cell for a database object that Manifold has been instructed to treat as a drawing.

 

Object

The database object to index. This will be a table name followed by a dot followed by the geometry column to be indexed. A typical name in SQL Server Express, for example, might be dbo.Mexico Table.GeomI if we exported a table using the Geom (I) intrinsic field to provide a geometry column.

Use spatial index

Check to create a spatial index.

X and Y boxes

Four boxes for the X and Y extents to be covered by the spatial index, initially blank until the Suggest button is pressed. The outer two boxes (not editable) show the extents of the data set. The inner two boxes show the extent of the spatial index to be constructed. A spatial index must include all objects in the drawing. Attempting to create a spatial index with bounds that do not include all coordinates of all drawing objects will fail.

Level

Degree of detail in the spatial index, providing a balance between granularity and performance. Higher values produce more granular indices, which require more space but are potentially more efficient. For best efficiency, choose an index level proportional to the number of objects expected to be in the drawing. The value suggested by the Suggest button is a reasonable default.

Suggest

Press this button to command Manifold to analyze the data set to determine the extents of the data and a recommended

 

For details on using the Administrator Console, see the Using Administrator Console topic.

 

Tech Tip

 

Keep in mind that the choice of connection technology used in the Data Source will influence how Manifold interacts with the DBMS. For example, ADO .NET connections typically are read-only and will not allow either Administrator Console or Database Console to make changes, such as adding a spatial index, to the database.

 

See Also

 

Database Administrator Edition

Database Object Projection

Database Object Properties

Database Object Triggers

Spatial DBMS Facilities

Tools - Database Console

Using Administrator Console