1. Summary
  2. Files
  3. Support
  4. Report Spam
  5. Create account
  6. Log in

Relational schema plug-in (UWO)

From db2mc

Jump to: navigation, search


How to Install the Plugin

Before the plugin can be used, the user must have Technology Explorer working on their computer. Once that step is completed, The files that Ingenuity have created need to be copied over to the appropriate folders (for example, the javascript files go in the js folder). A Help file will be available detailing where the files go.

How to Operate the Plugin

Once the plugin has been installed, start Technology Explorer. When the page loads up, on the toolbar, there should be a button called "Ingenuity Diagrams". Click that to use the plugin. There should now be 3 panes. The top left pane is for holding and displaying lists. The bottom left pane displays the most recent queries made in similar fashion to a stack (the most recent queries are at the top). The right pane will be used to generate drawings specified by the user.

Foreign key relationships between specified tables

On the top left-pane, a list of tables should be generated. The user can select tables from this list. Once the tables have been selected, the user can click on a button called "RS Diagram" on the right of the screen. This will draw an image in the right pane, displaying all of the selected tables, along with the primary keys (denoted by a red dot) and lines connecting tables with shared foreign keys.

Foreign Key Relationships for All Tables With a Given Schema

On the top-left pane, the user must click the menu called "Others" and the button called "Schema" to generate a list of schema names. The user can then select one schema from the list. Once the schema has been selected, the user can click on the menu called "Selected" and choose "Selected Schema". This will draw an image in the right pane, displaying all tables from the selected sche,a along with the foreign key relationships and th primary keys (denoted by a red dot).

Foreign Key Relationships for All Tables With a Given Tablespace

On the top-left pane, the user musy click the menu called "Others" and the button called "Tablespace" to generate a list of tablespace names. The user can then select one tablespace from this list. Once the tablespace has been selected, the user can click on the menu called "Selected" and choose "Selected Tablespace". This will draw an aimage in the right pane, displaying all tables from the selected tablespace along with the foreign key relationships and the primary keys (denoted by a red dot).

Dependencies of Given Objects

On the top-left pane, the user musy click the menu called "Others" and one of the following buttons: "Views", "Aliases", or "MQTs". This will depend on what type of dependency is to be drawn. The user may instead click on the "Table Names" button and only select a table to see that table's dependencies. Once a view, alias, MQT, or table has been selected, the user must then click on the menu called "Selected" and choose "Slected View/Alias/MQT" based on the ealier choice or must click on the "Dependencies" button for table dependencies." This will draw an image in the right pane, displaying all the selected table along with all of the tables related to it.

Technical Troubleshooting

During testing, Technology Explorer did not with Internet Explorer. However, it does work with Mozilla Firefox v3.5.x. Ohter browsers such as Opera and Google Chrome have not been tested yet. It is also important for the user to check their connection to the database.

Frequently Asked Questions

Something is going wrong. Why?

Personal tools