Method and system for detecting tables to be modified

Abstract

In an MD schema definition modifying process for specifying tables to be modified in terms of addition of columns or the like when modification such as addition of a dimension is applied to an MD schema in a BI system having a fixed model such as a data model, tables to be modified in terms of addition of columns or the like are specified on the basis of information of modification such as addition of the dimension to the MD schema. In an extraction process of modification candidate tables, all combinations of tables and columns to be modified in terms of addition of columns or the like are output. In a decision process of modification target tables, a combination of tables to be modified can be output.

1 . (canceled)  
   
   
       2 . A table detection method implemented by a computer comprising the steps of: 
 selecting a table in which at least one column is to be modified from a plurality of tables;    storing the selected table as modification candidate information;    acquiring at least one related table related to the stored table based on table relation information which indicates relations between tables of the plurality of tables, and storing the related table in association with the stored table as part of the modification candidate information;    acquiring combinations of tables which are associated with each other from the modification candidate information;    counting a total amount of records in the tables of each of the combinations of tables; and    outputting information of the combination of tables which includes a total amount of records that satisfies a predetermined condition.    
   
   
       3 . A table detection method according to  claim 2 , wherein the related table is associated with the stored table by relation information.  
   
   
       4 . A table detection method according to  claim 2 , wherein the table relation information is information relating an input table to an output table which is generated by carrying out a process on the input table, and 
 wherein the step of acquiring at least one related table includes acquiring the output table related to the stored table in the modification candidate information as the input table based on table relation information.    
   
   
       5 . A table detection method according to  claim 2 , wherein the predetermined condition is the combination of tables which includes that includes the smallest amount of records.  
   
   
       6 . A table detection method according to  claim 2 , wherein the modification to be conducted on the at least one column of a table is at least one of adding, deleting and changing the column.  
   
   
       7 . A table detection method according to  claim 2 , wherein the modification candidate information includes end information which indicates an end of the relation among the tables, and 
 wherein the step of acquiring at least one related table is finished if the end information has a flag.    
   
   
       8 . A table detection method according to  claim 2 , wherein the selected table is displayed as an electrical form, report or monitoring view.  
   
   
       9 . A computer program, stored on a storage medium, for table detection, wherein the computer program when executed causes a computer to perform the steps of: 
 selecting a table in which at least one column is to be modified from a plurality of tables;    storing the selected table as modification candidate information;    acquiring at least one related table related to the stored table based on table relation information which indicates relations between tables of the plurality of tables, and storing the related table in association with the stored table as part of the modification candidate information;    acquiring combinations of tables which are associated with each other from the modification candidate information;    counting a total amount of records in the tables of each of the combinations of tables; and    outputting information of the combination of tables which includes a total amount of records that satisfies a predetermined condition.    
   
   
       10 . A computer program according to  claim 9 , wherein the related table is associated with the stored table by relation information.  
   
   
       11 . A computer program according to  claim 9 , wherein the table relation information is information relating an input table to an output table which is generated by carrying out a process on the input table, and 
 wherein the step of acquiring at least one related table includes acquiring the output table related to the stored table in the modification candidate information as the input table based on table relation information.    
   
   
       12 . A computer program according to  claim 9 , wherein the predetermined condition is the combination of tables which includes that includes the smallest amount of records.  
   
   
       13 . A computer program according to  claim 9 , wherein the modification to be conducted on the at least one column of a table is at least one of adding, deleting and changing the column.  
   
   
       14 . A computer program according to  claim 9 , wherein the modification candidate information includes end information which indicates an end of the relation among the tables, and 
 wherein the step of acquiring at least one related table is finished if the end information has a flag.    
   
   
       15 . A computer program according to  claim 9 , wherein the selected table is displayed as an electrical form, report or monitoring view.  
   
   
       16 . An analysis system for table detection comprising: 
 a storage which stores data organized in a plurality of tables; and    a processor which processes said data stored in said storage and information regarding the tables in which said data is organized,    wherein said processor selects a table in which at least one column is to be modified from a plurality of table, stores the selected table as modification candidate information, acquires at least one related table related to the stored table based on table relation information which indicates relations between tables of the plurality of tables, stores the related table in association with the stored table as part of the modification candidate information, acquires combinations of tables which are associated with each other from the modification candidate information, counts a total amount of records in the tables of each of the combinations of tables, and outputs information of the combination of tables which includes a total amount of records that satisfies a predetermined condition.    
   
   
       17 . An analysis system according to  claim 16 , wherein the related table is associated with the stored table by relation information.  
   
   
       18 . An analysis system according to  claim 16 , wherein the table relation information is information relating an input table to an output table which is generated by carrying out a process on the input table, and 
 wherein the processor, when acquiring the at least one related table, acquires the output table related to the stored table in the modification candidate information as the input table based on table relation information.    
   
   
       19 . An analysis system according to  claim 16 , wherein the predetermined condition is the combination of tables which includes that includes the smallest amount of records.  
   
   
       20 . An analysis system according to  claim 16 , wherein the modification to be conducted on the at least one column of a table is at least one of adding, deleting and changing the column.  
   
   
       21 . An analysis system according to  claim 16 , wherein the modification candidate information includes end information which indicates an end of the relation among the tables, and 
 wherein the processor finishes the acquiring of the at least one related table if the end information has a flag.    
   
   
       22 . An analysis system according to  claim 16 , wherein the selected table is displayed as an electrical form, report or monitoring view.