Who is 'Mary' and why is she in so many songs, from classical to rock?

Songs about somebody called Mary feature in third century Christian hymns to the alternative rock of the 1990s and beyond, but who is she and why do so many insist on singing about her?