System and method for system for determining database relations based on data monitoring

Abstract

A system and method for determining database relations. The method includes: receiving at least a portion of a transaction log, the transaction log comprising a plurality of data records detailing changes of at least a first table and a second table of a target system; and generating a probability regarding a relation between the first table and the second table within the target system, based on the at least a portion of the transaction log. In an embodiment, the method further includes: sending a query to target system, wherein the query includes instructions related to data within at least one table stored within the target system, wherein the changes of at least the first table and the second table of a target system are related to the query.

What is claimed is: 
     
         1 . A method for determining database relations, comprising:
 receiving at least a portion of a transaction log, the transaction log comprising a plurality of data records detailing changes of at least a first table and a second table of a target system; and   generating a probability regarding a relation between the first table and the second table within the target system, based on the at least a portion of the transaction log.   
     
     
         2 . The method of  claim 1 , further comprising:
 sending a query to target system, wherein the query includes instructions related to data within at least one table stored within the target system, wherein the changes of at least the first table and the second table of a target system are related to the query.   
     
     
         3 . The method of  claim 2 , wherein the changes related to the query include operations directed to a database of the target system. 
     
     
         4 . The method of  claim 1 , wherein the probability indicates a correlation between the first table and the second table within the target system. 
     
     
         5 . The method of  claim 4 , wherein the probability of the first table being correlated to the second table is not the same as the probability of the second table being correlated to the first table. 
     
     
         6 . The method of  claim 1 , wherein the probability is generated based on the frequency the first table and the second table appear together within the target system. 
     
     
         7 . The method of  claim 6 , wherein the probability is generated based on the number of operations in which both the first table and the second table are updated based on a query. 
     
     
         8 . The method of  claim 1 , further comprising:
 determining if the probability value is above or below a predefined threshold.   
     
     
         9 . The method of  claim 8 , further comprising:
 sending an alert to a user if the probability value is above or below the predefined threshold.   
     
     
         10 . The method of  claim 1 , further comprising:
 generating a report including a list of tables and the probability the list of tables are correlated.   
     
     
         11 . A non-transitory computer readable medium having stored thereon instructions for causing a processing circuitry to perform a process, the process comprising:
 receiving at least a portion of a transaction log, the transaction log comprising a plurality of data records detailing changes of at least a first table and a second table of a target system; and   generating a probability regarding a relation between the first table and the second table within the target system, based on the at least a portion of the transaction log.   
     
     
         12 . A system for determining database relations, comprising:
 a processing circuitry; and   a memory, the memory containing instructions that, when executed by the processing circuitry, configure the system to:   receive at least a portion of a transaction log, the transaction log comprising a plurality of data records detailing changes of at least a first table and a second table of a target system; and   generate a probability regarding a relation between the first table and the second table within the target system, based on the at least a portion of the transaction log.   
     
     
         13 . The system of  claim 12 , the system further configured to:
 send a query to target system, wherein the query includes instructions related to data within at least one table stored within the target system, wherein the changes of at least the first table and the second table of a target system are related to the query.   
     
     
         14 . The system of  claim 13 , wherein the changes related to the query include operations directed to a database of the target system. 
     
     
         15 . The system of  claim 12 , wherein the probability indicates a correlation between the first table and the second table within the target system. 
     
     
         16 . The system of  claim 15 , wherein the probability of the first table being correlated to the second table is not the same as the probability of the second table being correlated to the first table. 
     
     
         17 . The system of  claim 12 , wherein the probability is generated based on the frequency the first table and the second table appear together within the target system. 
     
     
         18 . The system of  claim 17 , wherein the probability is generated based on the number of operations in which both the first table and the second table are updated based on a query. 
     
     
         19 . The system of  claim 12 , the system further configured to:
 determine if the probability value is above or below a predefined threshold.   
     
     
         20 . The system of  claim 19 , the system further configured to:
 send an alert to a user if the probability value is above or below the predefined threshold.   
     
     
         21 . The system of  claim 12 , the system further configured to:
 generate a report including a list of tables and the probability the list of tables are correlated.