Use XAMPP and Knowledgeroot to build your own knowledge base

Have you ever found yourself in the following situations:

– You find a great tip on the internet or in an email and you know that if you don’t record it somewhere right now, you will loose it.

– You get a certain Error message, and you know this is not the first time you had it.  You just know you have solved this error like a year ago, but you just don’t know where to look for for the solution you found before.

If you have Iron-bullet-proof memory, you don’t need to read any further.

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 »