A first-of-its-kind DNA database could help “further transform” understanding of childhood illnesses and personality traits, experts have said.