Abstract: A computerized method for automatically converting hierarchical data to a flat database table can comprise receiving a hierarchical data set comprising one or more nodes. The method can also comprise identifying at least one node comprising at least one data field. The method can then comprise distilling the at least one node to one or more independent data fields, wherein each of the one or more independent data fields comprise more than a single data entry. The method can further comprise automatically generating one or more flat data tables to store data entries form the one or more independent data fields. Further still, the method can comprise constructing a relational database of the one or more flat data tables and storing the relational database.