Direct versus sequential double ionization in atomic systems