GeoRaptor: Metadata Management

Metadata Management Dialog

This dialog box is used to manage spatial metadata in the xxx_SDO_GEOM_METADATA views.

The dialog can be accessed in two ways:

• By right clicking on a Table/Column/View/Synonym/Materialised View, and selecting GeoRaptor-> Manage Metadata
• By selecting View-> GeoRaptor-> Manage All Metadata

Current Object Metadata

The top half of the dialog displays the details for the currently selected object. If any metadata exists for the object then it is displayed in the Dim Array Elements section.

SRID: To change the SRID for the current object metadata, enter the new value in the text box, or use the Select SRID dialog to choose one.

Connection: Use the Name drop down list to switch to another open connection. If new connections have been opened since the modal Manage Metadata dialog was first launched, use the Reload Connections button to refresh the list of available open connections.

Calculate Elements: By clicking this button, a SQL query is executed to calculate the bounds of the SDO_GEOMETRY data in the current object. The discovery also includes determining the SDO_SRID associated with the geometry data. Depending on the size of the object, this query can take a while to execute. Use the Sample slider to indicate the percentage of the object data to be queried. When complete, the results are populated in the Dim Array Elements table.

Edit Dim Array Elements: To enter specific values, type directly in the table. To delete an element, select a row and press the Delete key. Use the Add Element button to add a new row to the table.

Apply Changes: After the metadata values for an object have been set, press the Apply Changes button to run the update statement against the XXX_SDO_GEOM_METADATA view. Note that pressing Close does not result in the update statement being run, therefore the Apply Changes button must be used.

All metadata for user xxx

The bottom half of the dialog displays a colour-coded list of all the existing , orphan , and potential metadata for objects containing SDO_GEOMETRY columns. The SQL used to populate the table queries the XXX_SDO_GEOM_METADATA and XXX_TAB_COLUMNS views to retrieve a list of all metadata entries along with all objects with columns of data type SDO_GEOMETRY.

Entries in the table are colour-coded depending based on the following:

• Database Object Has Metadata
  
  An object exists in XXX_TAB_COLUMNS with data type SDO_GEOMETRY and a corresponding entry exists in XXX_SDO_GEOM_METADATA.
• No Database Object – Orphan Metadata
  
  An entry exists in XXX_SDO_GEOM_METADATA but no corresponding object exists in XXX_TAB_COLUMNS with data type SDO_GEOMETRY.
• Database Object with Geometry – No Metadata
  
  An object exists in XXX_TAB_COLUMNS with data type SDO_GEOMETRY but no corresponding entry exists in XXX_SDO_GEOM_METADATA.

Check/Uncheck the colour-coded check boxes under the table to toggle display of entries matching that criteria.

Note that the colours can be changed in Tools-> Preferences-> GeoRaptor

If the All schemas checkbox is selected, then the table displays entries for ALL_* views. When deselected, the table displays entries for USER_* views.

Table selection

• Right-click on a row in the table and select Copy entry to clipboard to copy the row contents to the clipboard.
• Right-click on a row in the table and select Delete Entry to delete the entry from the XXX_SDO_GEOM_METADATA view.
• Right-click on a row in the table and select Copy diminfo values to current metadata record to load the metadata for the selected object into the Dim Array Elements table for the object whose metadata is currently being managed.
• Right-click on a row in the table and select Switch to managing this meatdata entry to make this the Current Object for which metadata is being managed. Note that double clicking on a row has the same affect.