Patent ID: 7113951

Claim:
A table detection method implemented by a computer for giving table name information of a combination of tables to be modified, said table detection method comprising the steps of: collecting combinations of tables relevant to a dimension from a plurality of tables at least partially sequentially generated in a database in accordance with addition of the dimension on the basis of a table of table relation information having a plurality of records indicating relation and sequence of generation among the plurality of tables in response to a request to add the dimension to an analysis schema generated based on the plurality of tables; storing the collected combinations of tables in information of modification candidate tables; counting a number of records in each of the combinations of tables, selecting a combination of tables having a smallest number of records, and outputting names of the combination of tables having a smallest number of records, wherein said storing step includes the step of: preparing a table of table relation information in which table names of two continuous tables in said plurality of sequentially generated tables and column names are provided as pairs in a “From” column and a “To” column in one record.