Patent Document ID: 8364651
Application ID: 12853902
Patent Status: 1

Claim One:
1. An apparatus to identify redundancy in databases and application systems, the apparatus comprising: a processor; at least one meta data scanner; an enterprise meta data source; a meta data repository, wherein the meta data repository receives system-specific meta data representative of the databases and application systems from the at least one meta data scanner, and the meta data repository receives enterprise canonical data model meta data from the enterprise meta data source, and a clustering algorithm; wherein the meta data repository is configured to generate at least one individual system Create, Read, Update, Delete (CRUD) matrix and an enterprise canonical model CRUD matrix, wherein the meta data repository is further configured to group similar entries in the enterprise canonical model CRUD matrix according to the clustering algorithm, wherein the clustering algorithm is further configured to analyze the enterprise canonical CRUD matrix to identify redundancy in the databases and application systems, and wherein the clustering algorithm is further configured to generate a report of at least one of redundancy and opportunities for consolidation in the databases and application systems.