The "gaps and weird reassignments" are not a result of the structure of the database. They are, rather, a result of the fact that too many horticulturalists these days either don't understand or are simply not inclined to follow the International Code of Nomenclature. Instead, they seem to prefer to make up pseudo-scientific names for their plants, which appears to be a marketing strategy more than anything else.