Detecting data mapping relationship within database system and optimizing data operation

A computer program product for detecting data redundancy within a database and optimizing data access operations, the computer program product comprising:

• one or more computer readable non-transitory storage devices and program instructions stored on the one or more computer readable non-transitory storage devices, the stored program instructions comprising:
• program instructions to identify a candidate group is based on an equation of principal component analysis (PCA) wherein the candidate group comprises of a candidate column, a first comparison column, associated with a table of a database and the equation further comprises:
• Rsba=Σp1,p2,ps,po
• wherein p1 is to scan catalog table information;
• p2 is to monitor database traffic of the table, ps define similarity model between each potential data type;
• po is a sampling method to go through each object tables to get an approximate group with vector method;
• a is a starting table and b is an ending table;
• program instructions to identify one or more sample rows based on the candidate column, the first comparison column and based on a predetermined parameter, wherein the predetermined parameter indicates identifying all columns against the candidate column or identifying the one more sample rows against the candidate column;
• program instructions to calculate a first candidate vector angle based on a first row of the one or more sample rows, a first comparison vector angle on the first row of the one or more sample rows associated with the candidate column and the first comparison column, respectively;
• program instructions to calculate a second candidate vector angle based on a second row of the one or more sample rows and a second comparison vector angle on the second row of the one or more sample rows associated with the candidate column and the first comparison column, respectively;
• program instructions to determine if the first candidate vector angle and the first comparison vector angle are greater than the second candidate vector angle and the second comparison vector angle;
• and
• program instructions to responsive to determine the first candidate vector angle and the first comparison vector angle are greater than the second candidate vector angle and the second comparison vector angle, program instructions to declutter the first comparison column;
• and
• program instructions to restructure the database based on the decluttered first comparison column and any subsequent columns associated with the table of the database, wherein restructuring the database comprises of reduction in size of the database, reduction in size of a cache of the database, and improved performance of the database.

A computer system for detecting data redundancy within a database and optimizing data access operations, the computer system comprising:

• one or more computer processors;
• one or more computer readable non-transitory storage devices;
• and
• program instructions stored on the one or more computer readable non-transitory storage devices for execution by at least one of the one or more computer processors, the stored program instructions comprising:
• program instructions to identify a candidate group is based on an equation of principal component analysis (PCA) wherein the candidate group comprises of a candidate column, a first comparison column, associated with a table of a database and the equation further comprises:
• Rsba=Σp1,p2,ps,po
• wherein p1 is to scan catalog table information;
• p2 is to monitor database traffic of the table, ps define similarity model between each potential data type;
• po is a sampling method to go through each object tables to get an approximate group with vector method;
• a is a starting table and b is an ending table;
• program instructions to identify one or more sample rows based on the candidate column, the first comparison column and based on a predetermined parameter, wherein the predetermined parameter indicates identifying all columns against the candidate column or identifying the one more sample rows against the candidate column;
• program instructions to calculate a first candidate vector angle based on a first row of the one or more sample rows, a first comparison vector angle on the first row of the one or more sample rows associated with the candidate column and the first comparison column, respectively;
• program instructions to calculate a second candidate vector angle based on a second row of the one or more sample rows and a second comparison vector angle on the second row of the one or more sample rows associated with the candidate column and the first comparison column, respectively;
• program instructions to determine if the first candidate vector angle and the first comparison vector angle are greater than the second candidate vector angle and the second comparison vector angle;
• and
• program instructions to responsive to determine the first candidate vector angle and the first comparison vector angle are greater than the second candidate vector angle and the second comparison vector angle, program instructions to declutter the first comparison column;
• and
• program instructions to restructure the database based on the decluttered first comparison column and any subsequent columns associated with the table of the database, wherein restructuring the database comprises of reduction in size of the database, reduction in size of a cache of the database, and improved performance of the database.