DBA Tools

    WebChart is a Java servlet based platform for simple business data display in tabular or chart mode, it was initially wroted in 2003, but I improved it these days. And I created database performance management pages on it very easy and quickly, just focus on the business, don't care the techniqual details.

    Suppose that we have a summary table of the trade, it contains the monthly summarized trade count of latest two years.

CREATE TABLE TRADE_SUMMARY_MONTHLY
(
  TRADE_MONTH DATE,
  TRADE_COUNT NUMBER(12)
);

    Then we will start to display the data in different sytle, first example is display the 2008's data in a simple table.

select to_char(trade_month,'yyyy/mm') month ,
      trade_count count
  from trade_monthly_summary
  where to_char(trade_month,'yyyy')='2008'

    Then we want to add the quater information at the first column, and group togather according to the quater number.

select to_char(trade_month,'"Q"q') quater ,
      to_char(trade_month,'mm') month ,
      trade_count count
  from trade_monthly_summary
  where to_char(trade_month,'yyyy')='2008'
  order by 1,2

    And now we want to display two years trade data, and want to compare them monthly year by year.

select to_char(trade_month,'mm') month ,
      to_char(trade_month,'yyyy') year ,
      trade_count count
  from trade_monthly_summary
  order by 1,2

    Or summary the 2008's data quaterly, and display them in pie chart.

select to_char(trade_month,'"Q"q') quater ,
      sum(trade_count) count
  from trade_monthly_summary
  where to_char(trade_month,'yyyy')='2008'
  group by to_char(trade_month,'"Q"q')

    Or display the 2008's monthly data in a bar chart.

select to_char(trade_month,'mm') month ,
      trade_count count
  from trade_monthly_summary
  where to_char(trade_month,'yyyy')='2008'
  order by 1

    Or line chart.

select to_char(trade_month,'mm') month ,
      trade_count count
  from trade_monthly_summary
  where to_char(trade_month,'yyyy')='2008'
  order by 1

    Of cause, we can display 2007's and 2008's data togather in multiple series chart.

select to_char(trade_month,'mm') month ,
      to_char(trade_month,'yyyy') year ,
      trade_count count
  from trade_monthly_summary
  order by 1,2

    I choose Oracle Chart Builder as the chart component, you can read it for more details of the business chart features.