Using 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. The Administrator Console includes the following capabilities:

 

·      Designate tables containing geometry columns to be treated as drawings by Manifold clients.

·      Specify a generic spatial index to be used with tables containing geometry columns.

·      Designation of user-friendly, component names for Manifold components stored within databases. These user-friendly component names can then appear within Database Console in all Manifold editions capable of connecting to that data source. Friendly names make it a lot easier for users to find their data within large databases when linking drawings or other components.

·      Automatic creation and maintenance of an internal metadata table, called MFD_META by default, within the data source that is used to store housekeeping and metadata information on database objects for use by Manifold System.

·      Displaying the number of objects in drawings and the dimensions and number of channels in images.

·      Displaying the projections of drawings and images.

·      Editing the coordinate system of a database object by double clicking the relevant cell in the Projection column.

·      Enabling and disabling storing formatting of a database drawing object in the data source by double clicking the relevant cell in the Format column. When enabled, formatting is stored in the metadata table in XML format.

·      Viewing and editing the location precision of a drawing database object via the Precision column.

·      Viewing the number of records in tables and views via the Statistics column.

·      Viewing triggers bound to a database object via the Triggers toolbar button. This capability is enabled only for Oracle native data sources.

·      Editing the default link options of a database table object containing geometry data in one of the supported binary column geometry formats so it behaves like a drawing. This allows easy views of such database objects as drawings in subsequent Manifold sessions.

·      Editing the default link options (geometry column and type, version column, server version increment option, formatting storage) and other properties (friendly name, coordinate system, precision) of a database object via the Properties toolbar command. This allows rapid and simplified linking in subsequent Manifold sessions.

 

Note: image capabilities apply if the data source in use supports images. Currently, only Oracle data sources with GeoRaster capability support linked image storage.

 

Administrator Console Layout

 

images\dlg_administrator_console_captioned.gif

 

When connected to a data source the Administrator Console shows database objects in the data source in a contents pane. The lower pane is a command pane in which commands may be written using the command language of the data source, normally SQL.

 

images\dlg_administrator_console_row.gif

 

Highlighting an object by clicking on it makes it the context object (that is, puts the focus on that object) so that toolbar buttons such as the Properties or Trigger button can operate on it. The status bar will also report information on the context object.

 

Controls

 

Data Source

Choose the name of a data source, or press the browse button to launch the Connect To dialog to specify a data source. ADO.NET, ODBC, OLE DB and file-based data sources may also be used. The Server box will show the last used name or connection string (Manifold will not actually connect to the last used name or connection string until the Refresh button is pressed). Any PASSWORD and PWD parameters used in a connection string will be masked in the last used name or connection string to protect security.

(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.

Statistics - Useful information, such as the number of objects in drawings or the number of records in tables.

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. This is normally the full extent of the data set, although in special cases users may wish to create a spatial index that covers less than the entire data set.

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

 

Designating a Friendly Name

 

To enter a friendly name for a database object, click on the object to highlight it and then double-click into the Component cell for that object or press the F2 key. Friendly names may include spaces and can be any component name legal within a Manifold project.

 

Using Friendly Names within the Database Console

 

To use friendly names within Database Console, connect to a data source that has a metadata table and friendly names designated with Administrator Console, and turn on component view using the Component View toolbar button. If the data source does not contain a metadata table set up with Administrator Console, the component view button will be disabled.

 

When in component view, the Database Console dialog will only show components that have been assigned friendly names. The Filter box will work with friendly names as well.

 

The MFD_META Table

 

DBMS administrators may be interested in additional information about the MFD_META metadata table that is created and used by the Administrator Console. Friendly names are stored in the metadata table and are available to all Manifold clients connecting to the data source.

 

The metadata table is named MFD_META by default and contains three fixed-length or variable-length text columns named OBJ, PROP and VAL. The OBJ column stores names of database objects, the PROP column stores property names, and the VAL object stores property values. If there is both a system table named MFD_META and a user table named the same (as might be the case with Oracle data sources), the system table is given preference.

 

Supported properties are:

 

Component

Friendly name. Can include spaces, punctuation and other characters allowed in a Manifold component name.

CoordinateSystem

The coordinate system of a table behaving as a drawing, in Manifold XML format.

Epsilon

The location precision parameter of a table behaving as a drawing, in native drawing units.

Format

True or False, depending on whether or not a drawing should store formatting on the data source.

FormatAreaBack

Area background color format for a drawing, in Manifold XML format.

FormatAreaBorderBack

Area border background color format for a drawing, in Manifold XML format.

FormatAreaBorderFore

Area border foreground color format for a drawing, in Manifold XML format.

FormatAreaBorderSize

Area border size format for a drawing, in Manifold XML format.

FormatAreaBorderStyle

Area border style format for a drawing, in Manifold XML format.

FormatAreaFore

Area foreground color format for a drawing, in Manifold XML format.

FormatAreaSize

Area size format for a drawing, in Manifold XML format.

FormatAreaStyle

Area style format for a drawing, in Manifold XML format.

FormatLineBack

Line background color format for a drawing, in Manifold XML format.

FormatLineFore

Line foreground color format for a drawing, in Manifold XML format.

FormatLineSize

Line size format for a drawing, in Manifold XML format.

FormatLineStyle

Line style format for a drawing, in Manifold XML format.

FormatPointBack

Point background color format for a drawing, in Manifold XML format.

FormatPointFore

Point foreground color format for a drawing, in Manifold XML format.

FormatPointRotation

Point rotation format for a drawing, in Manifold XML format.

FormatPointSize

Point size format for a drawing, in Manifold XML format.

FormatPointStyle

Point style format for a drawing, in Manifold XML format.

GeometryColumn

Name of a column to use for geometry data. If present, makes the table behave as a drawing.

GeometryColumnType

Data type of the column used to store geometry data. Can be Manifold for Geom, SDE for GeomSDE, SHP for GeomSHP, or WKB for GeomWKB. If absent or invalid, the data type is assumed to be Geom.

VersionColumn

Name of a column to use for version data, for drawings.

VersionColumnAuto

True or False depending on whether or not Manifold should rely on the server to increment version data after making changes to the metric of drawing objects.

 

Tech Tip

 

Almost always after specifying that a table containing geometry be interpreted as a drawing we will click into the Spatial Index column for that table object in Administrator Console to specify a generic spatial index for that table. Specifying a spatial index will enable Manifold clients importing or linking that table as a drawing to work with only the area of interest desired. This is potentially a huge performance enhancement when working with very large drawings.

 

Keep in mind that the choice of connection technology 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. In another example, connecting to a spatial DBMS using the native connection technology (such as using OCI to connect to Oracle) tells Manifold we want to use the DBMS's native spatial technology, while using ODBC or OLE DB tells Manifold to connect in a generic way. See the Spatial DBMS Facilities topic for additional information.

 

See Also

 

Database Administrator Edition

Database Object Properties

Database Object Triggers

Multi-User Editing of Linked Drawings

Storing Drawings in SQL Server

Tools - Administrator Console

Tools - Database Console

View - Panes - Review