JAVA : Statistics Class

Another name for it would be Counter class.

How many times you did this ?

int databaseUpdateCounter=0;
.
{
.
     databaseUpdateCounter++;
.
}
.
.
System.out.println( "databaseUpdateCounter"+ databaseUpdateCounter);

you only need to follow up on the count of a certain operation.

And then you needed to count something else, and kept on adding counterVariables ?!

Read more »

Productivity : Use Keypass to keep track of your environment’s credentials,

Some use Excel, Others simply use text files to keep track of their passwords, but I use keepass .

It is simply a vault for your logins and passwords which you can unlock with a single password. However I use it also for auto-piloting my login procedure.

keepass main window

The whole idea is not to have to use a pool of passwords for all systems and also to auto-start you log-in procedure and save waring off your precious fingers in typing useless usernames and passwords.

In this article I will show how to use keepass to auto-login to:

• Putty
• WinScp
• Toad
• SQLPLUS
• SiebelTools
• FieZilla

And from the examples above you would be able to use it with any command line tool as well.

You could also use it for keeping track of your web site usernames ,passwords and URL’s

It is available on Windows, Mac, Linux, Android and iPhone.

Read more »

Visualize your Data with GraphViz

Ever wanted to visualize your  database information ?

here is a quick answer:

SQL –> XML –> XSL trasnformation–> DOT –> GraphViz –> JPEG/PDF

I work theses days with Siebel CRM system.  It is very configurable in how you want to store your data and display them.

One thing about Siebel Configuration, is that you can overload one table with multiple entities.  Each Siebel customization could be different in how you organize your entities into tables. So I had a problem in really understanding how the system was developed. Cases like which type of records link to which entities in the same table or other tables.

I was looking for someway to visualize Entity relation based on the data that is there in the Database -I’m not talking about Entity Relationship Diagram (ERD)- I’m talking about how certain customers relate to each others and to their addresses.

Read more »