Metadata Loader 

Definition

A utility that allows the portal administrator to preload object model or table metadata into a Distributed Query Engine cache. As well as the pre-caching of metadata, the DQE permits the canceling of the cache, or unloading of existing metadata of tables that are no longer needed, or the metadata of which has changed.

Use

Preloading table metadata enhances performance during runtime in the productive environment. The ability to preload table metadata improves performance for accessing important tables, the metadata of which would be loaded on the fly by the DQE during runtime if it were not preloaded. Note that the on-the-fly upload of metadata occurs only the first time that a specific table is addressed.

The ability to remove (unload) from the DQE cache the metadata of tables that are not needed decreases load and eliminates storing in the DQE cache of unnecessary data.

To access the Metadata Loader:

In the portal top-level navigation, choose System Administration ® Distributed Query Engine ® Metadata Loader.

Structure

The tool is displays a two pane tree view: the left pane, labeled Available, showing the available portal systems, which expand to show the objects in each system; the right pane, labeled Loaded, showing the objects already loaded into the DQEcache.

Add and Remove buttons enable the administrator to load and unload specific tables into and out of the DQE cache. The Metadata Loader enables the transfer of an entire system by selecting it and transferring it to the other pane. In the expanded system trees multi-select is enabled, using the Ctrl and Shift keys to load or unload several objects at once.

After transferring tables between the two panes, choose Save to apply the changes. Use the Refresh button to see possible changes in the available systems list.

Search

Where systems have a large number of objects, the search mechanism above the preload panes enables finding by system alias object, the names of which are known to you.

Additional Information

Important information about refreshing visible data and troubleshooting, is provided in the UI of the Metadata Loader.