Two-Tier or n-Tier?

There's a large movement afoot in the database industry to replace classic client/server (or two-tier) databases with more complex n-tier databases. What are these systems all about? Are they right for your needs?