Aydarous,
You have a few options. I use Adobe Photoshop Lightroom. It is $199 and also doubles as an a quick image editor. You can adjust white balance, contrast, highlights, saturation, remove red-eye, straighten, crop, and much more right in the program.
Digital cameras automatically record a lot of information inside of the actual picture file. Camera model, time and date picture was taken (as long as the time and date are correctly set in the camera), ISO, F-stop, shutter speed, etc. are all inside your files whether you shoot JPG or RAW. Check it out, under Windows right-click on a file from your camera and go to properties then click on the details panel.
Lightroom will automatically store all of that information for you. When you import photos to Lightroom, you can also add tags to your photos. Let's say you went to Boston on vacation and took 1,200 photos. When you imported the pictures, you could set Boston as a tag for all 1,200 photos. You eventually end up creating a whole hierarchy of keywords for your photos. Once photos are in your Lightroom catalog, you can "spray paint" additional keywords to specific photos.
I could go on and on here, but there really is a lot of information to cover. Lightroom is non-destructive, you can undo every single edit you ever make of any photo inside of it. It has a Web-Module that will create professional looking slideshows for your website. The print module is incredible. The best thing about Lightroom though from my point of view is that I no longer have to have JPG and RAW versions of my files. I just shoot RAW now and use the Web-Module to create slideshows.
There are other options. Apple created Aperture. Microsoft bought some other companies program and renamed it and for the life of me I can't think of the name. I'm not familar with Aperture but I know there are a lot of people out there that really like it. Basically, what you are looking for is a DAM (Digital Asset Manager)
Hope this helps.