Archive for December, 2009

Depending on storage method used by database, it can be classified in various models. Such as, Relational database, Network Database, Object Oriented Database etc. definition can be found over Wikipedia. The most commonly used Database Model today is Relational Database Model, in which all information stored as a relation. This model was originally formulated by E.F.Codd, also known as father of modern Relational Database. All DBMS, e.g. Oracle, SQL Server, IBM DB2, MySql follow this model.

As of today, Relational DBMS is the most widely used DBMS, and that’s I will write about. Also will explain the main reason we use DMBS instead of file system (again …). Below figure shows how RDBMS constructed internally (and again, all RDBMS follows this model, they are just represented differently) which i found on Wikipedia.

Before going in to much detail, first lets see what is database… by book it is defined as,

Database is collection of useful information

For any enterprise, data is perhaps the most precious asset. It can be any sort of data … say customer information, sales data etc. But random data is only useful when it is properly formulated … and it is called Information. That information can further be manipulated , sliced and diced for further analysis … that is called Business Intelligence (its way too different then Corporate Espionage :-D), but I will write more about it later…

If your organization is very small (and i mean really small) then you can store all information in any file system (say word documents or pdf files). But what if your organization is pretty big and have thousands of employees and hundreds of customers ?? You certainly can’t keep all records in just a text files. I mean you can actually keep it if you want, but situation gets worse when you want to search any specific record. Say, you want to look for all purchases made by customer start with first name “James” from city “New York” in year of “2008” and month “March” ?? This simply can be done by looking all text files :-D. But it can be done very easily and without any hardwork using any good DBMS.

There are many blog writing tools available presently. Some of them are integrated with browsers (say, Scribefire for Firefox or Blog uploading tool in Flock browser) and some are standalone app. like Windows Live Writer (WLW for short), hell even there are some paid blog writing tools are available too ( i wonder who will pay for this sort of tools as we already have free good alternatives ), Rocket Post and Mars Edit are few to name !!!

I am new recruit of this blogosphere, but I know sometimes it makes our life easy if we have blog writing tool at our disposal. We can write, edit or can do anything we want even we are not connected to internet (which is a bit difficult for me , i can’t live without internet.). So, I have been using Windows Live Writer from the day one I created my blog.

So, in today’s how to I will show how to setup Windows Live Writer to work with Self hosted WordPress Blog.

WordPress itself has load of cool plugin collection. Users like us can also upload our plugin for others to use. Plugin really makes sometimes our life easy ( by adding more interactivity and attractiveness ?? i’ve doubt about last one :-p ).

DNS (Domain Name System) is just like address of any specific computer , system or other resource connected on internet. When we type name of a website in our browser (for example “www.google.com”), it actually translates that web address to DNS address and browser looks up that resource connected to internet. Which is usually come sort of IP. But we humans can remember names better then stranger series of numbers, IETF has adopted this naming convention. But in root, every name is given a specific IP and that is DNS.

When we connect to our internet , we use DNS of our ISP. So, when we type “www.google.com” , it has been resolved and found by DNS of our ISP (believe me, its not that easy to explain for me :d ). But sometimes we feel that our ISP is not that good at all for resolving addresses and speed. So, we can use 3rd party DNS, which may provide us better performance (to be honest, if you are happy with your ISP changing DNS is just waste of time). More >

Now, log into your account of your domain. In the control panel you will have loads of stuff to play but things we are looking are under Software/Services and Files Sections. ( I have circled them here )

I am Gaurang. People who know me personally may be surprised by seeing me here b’coz I am of quite introvert nature. But I was in love of computers and internet from ages (by year wise it was ’98) , and everybody is blogging I gave “Just a thought” to blog and also, I wanted to learn how to self host the blog 😀 . So, here I am.

Anyways this is my story …. A guy confused from the beginning of this world , what to do and what not to. Came all the way from India to USA to pursue MS Electrical Eng. with hope of bright future !!! So now I’m trying to be in rhythm of life.

Hmm… I am music lover. Sometimes even when i study , i keep my internet radio ON. I like mostly Hip-Hop, RnB, Rock and Hard Rock sometimes. Though I like Mariah Carey lots ( heyyy no questions). I am not linux expert bt i like to “play” with it too ( playing reminds me my past long history of formats coz of it ). I use Windows Server 2008 , Windows 7 and Vista too. Internet is my life , I find my self suffocating sometimes if i don’t have router near me …. I like to play Games on my lappy too (bt i am not intense gamer) …

And ya .. one more thing … I am not a writer , so please bare my improper organization of words.