Lightroom and Aperture are 2 most famous software for professional photo treatment developed by Adobe and Apple.
They allow the complete workflow management from import to image catalog and developing, finally to export to file, web page or print.
They are both commercial but there are some free good alternatives. Their main feature is the support to RAW files.
DigiKam (Windows, Mac OS X, Linux)
RawTherapee (Windows, Mac OS X, Linux)
Darktable (Windows, Mac and Linux)