SYSTEM FOR IDENTIFYING ANOMALIES BY AUTOMATICALLY GENERATING AND ANALYZING A STRUCTURE

Embodiments of the invention are directed to a system, method, or computer program product for analyzing a data model and identifying anomalies within the data model. Data stored in a database is transformed into a data model by the invention, wherein the invention analyzes the data and generates relationships between tables and information contained within to generate the model. The data model itself is then analyzed in order to accurately identify anomalies such as ragged hierarchies, many-to-many issues, and/or double counting issues present in the data model which might affect the data integrity. Upon analyzing the data model, the invention compiles lists of discovered information and presents the results to a user in the form of a data analysis report.