In my digital workflow, I use Apple's Aperture to import and organize my raw images. Working with Aperture is mostly intuitive and uncomplicated. Aperture allows me to create folder structures for my images in any possible way, which makes working so convenient for me.
Beside the powerful organization of my images, Aperture offers image correction as well. Most of the adjustments that I need to perform, I do right in the application. All adjustments are non invasive, meaning the original file is not touched. At any time it is possible to go back to the original file without loss of any information. These days, it is only on the rare occasion that an image needs some more in depth manipulation that I turn to Photoshop.
Adobe released it's own version with name Lightroom recently. I haven't worked with Lightroom yet myself, but it appears to be comparable and some users give it better ratings than Aperture.
You can find out more about Aperture at the folllowing links:
Let me know, about your experiences with any of the applications. Maybe you have some other interesting links, I can add.