What does Adaptive Dynamic Range do to a photograph? How does it do its job? How does it affect the results? When should it be used?

Nikon calls this "Active D-Lighting"; discussion of other systems (and how they differ) would be appropriate.

I'm looking for specifics here, not just "make pictures look better in extreme lighting conditions." Nitty-gritty technical details might be appropriate too, but please be gentle.