1. A computer implemented method for data model optimization using multilevel entity dependency analytics, the method comprising: accessing a multilevel schema data structure; determining, using a computer, a dependency relationship lineage between schema entities present in the multilevel schema data structure; generating a dependency table using the dependency relationship lineage, the dependency table comprising at least one multilevel dependency relationship between schema entities having a depth of two or more; using the dependency table to perform at least one analysis comprising at least one of, a high impact analysis, a referential integrity analysis, or a conformance analysis; and storing a result from the analysis in a stored metadata format.
1. A computer implemented method for data model optimization using multilevel entity dependency analytics, the method comprising: accessing a multilevel schema data structure; determining, using a computer, a dependency relationship lineage between schema entities present in the multilevel schema data structure; generating a dependency table using the dependency relationship lineage, the dependency table comprising at least one multilevel dependency relationship between schema entities having a depth of two or more; using the dependency table to perform at least one analysis comprising at least one of, a high impact analysis, a referential integrity analysis, or a conformance analysis; and storing a result from the analysis in a stored metadata format. 5. The method of claim 1 , further comprising reading a script to automate regression testing.