Lightroom / Aperture (mac) / Adobe Bridge

my insight would be that with 150,000 photos, you have a DAM lot of work in front of you - no matter what solution you pick