DBA Tools

Define the row filters for reports in WebChart

    Supposed that we are creating a report of the top 3 highest salary employees for every department (check the Oracle demo table : SCOTT.EMP). If the table is stored in Oracle database, we could generate the report with...

Posted on March 4, 2010 10:42 PM

Define different SQLs for different databases in WebChart

    Some people like to run WebChart demo application on Oracle database, while some other people may like to run WebChart demo application on MySQL database. Seems I have to write two WebChart demo applications, one for Oracle, another...

Posted on March 3, 2010 5:01 PM

The logical database layer and physical database layer

    Usually our application are bound to one physical database, for example, we always read our data from specific Oracle database or MySQL database, or write business data to specific Oracle database or MySQL database. The physical database is...

Posted on January 27, 2010 6:14 PM

Change the WebChart XSL template to show nagivation links

    After define HTML links for each columns, we need to change the old XSL template to show links in the pages. We can use "href" HTML tag to show it, change the XSL template file as following. <xsl:choose>...

Posted on June 5, 2009 8:59 AM

Create the HREF links in WebChart Pages

    HTML links are very useful for navigation, when we display some summary data in WebChart, we also want to display a href link to display the detail data of relative quater. QUATER COUNT 2008Q1 7363835 2008Q2 9146220 2008Q3...

Posted on June 2, 2009 11:57 PM

Demo of oramon and WebChart performance solution

    It's quite easy to display database data with WebChart utility. After loading the oramon performance data into database, I create a sample WebChart page to show the performance data, following is the CPU utilization chart.     We...

Posted on April 22, 2009 4:28 PM

Specify multiple lines value in WebChart defination

    WebChart plays more and more important role in my team, now all of the production DBAs are able to create pages on it. And they gave some good suggestions to make it better. It's easier to specify multiple...

Posted on April 22, 2009 3:47 PM

Customize all the chart colors of WebChart utility

    You can customize almost all the colors of the chart generated by WebChart platform now. In previous release, it's not possible to define the line color or bar color, it can only use the pre-defined colors. In latest...

Posted on April 1, 2009 3:33 PM

WebChart Sample Pages on MySQL Database

    With Java JDBC technology, WebChart can connect to many different types of database system, such as MySQL. Now I will show you some examples pages on MySQL. First, create the demo table with the following script in MySQL....

Posted on March 21, 2009 1:27 AM

WebChart Advanced Security - Password Encrypt

    Data security is very important for every company or people, we need try our best to improve the software security. In previous WebChart release, the password is not encrypted in both database connection configuration and the user table,...

Posted on March 12, 2009 4:52 PM