Cable Internet vs. DSL Internet

Most of us don't have home fiber connections yet, so cable and DSL remain popular options for getting online. How do they work, and is one better than the other?