AQT Charting

This is a major piece of functionality, which may change the way you view the data in your databases.
  • to chart a table, display the table then click on the Chart button
  • this will show you the Chart Builder window, where you can define your chart in a few clicks.
  • you can Save your chart and reapply it to your data at a later time.
AQT Charting

Saved Charts

Once you have saved a Chart:
  • it will appear in the Queries display in the Database Explorer window. You can easily view all the charts that you have developed and saved
  • you can define a Chart as a Favorite
  • the data behind the chart can be refreshed by right-clicking the chart and selecting Refresh
  • a saved Chart is contained within a file. This includes the definition of the Chart plus the query that was run to populate the data. Chart files can be manipulated as per normal files - you can move them around on your machine or distribute them to your colleagues. A chart can operate both as snapshot of your data at a particular time, and as a pre-built query that you can deploy to other people.
  • charts can be created in an unattended batch script

Here at Cardett Associates, we are awestruck at how useful this is. All our standard reports have now been set up as charts. One click and they are refreshed with the current data. Seeing the data visually makes it astonishingly easier to understand.

Database Explorer

Database Explorer Charts

A number of the displays in the Database Explorer can be charted. The following is for the size of tables within an Oracle tablespace.

Database Explorer
  Go Home Go to Top

Last reviewed on 9 April 2010   

Copyright 2010 Cardett Associates Ltd. All rights reserved.