Database analyzer and database analysis method

A database analyzer for analyzing a data group stored in an analysis target database by focusing attention on a designated table column in the data,

• the database analyzer comprising:
• a storage unit storing data;
• a data sorting unit for sorting a data group acquired from the analysis target database based on data values of the table column and storing it as analysis target data in the storage unit;
• a data pattern creation processing unit for creating a group for each of the data values based on differences between the data values of the analysis target data and storing a data pattern, which is a collection of the groups, in the storage unit;
• a data pattern judgment processing unit for judging validity of the data pattern stored in the storage unit based on a first judgment standard;
• and
• a data pattern transformation processing unit for transforming and reconstructing the data pattern and storing the reconstructed data pattern in the storage unit if a negative result is obtained for the validity judgment by the data pattern judgment processing unit;
• wherein the data pattern transformation processing unit reconstructs the data pattern with respect to constituent elements of each group included in the data pattern by transforming each group in accordance with a specified conversion rule for converting the constituent elements, into the same constituent element;
• wherein in addition to the processing for transforming the data pattern, the data pattern transformation processing unit decides an exceptional group based on a second judgment standard relating to occurrence frequency or a data structure of each group with respect to groups included in a transformed data pattern, stores the decided exceptional group as an exception pattern in the storage unit, creates a data pattern from the transformed data pattern by removing the exception pattern, and stores the created data pattern as a reconstructed data pattern in the storage unit.

A database analysis method by a database analyzer for analyzing a data group stored in an analysis target database by focusing attention on a designated table column in the data,

• the database analyzer including a storage unit storing data,
• the database analysis method comprising:
• a data sorting step executed by the data base analyzer sorting a data group acquired from the analysis target database based on data values of the table column and storing it as analysis target data in the storage unit;
• a data pattern creation step executed by the data base analyzer creating a group for each of the data values based on differences between the data values of the analysis target data and storing a data pattern, which is a collection of the groups, in the storage unit;
• a data pattern judgment step executed by the data base analyzer judging validity of the data pattern stored in the storage unit based on a first judgment standard;
• and
• a data pattern reconstruction step executed, if a negative result is obtained for the validity judgment by the data pattern judgment step, by the data base analyzer reconstructing the data pattern with respect to constituent elements of each group included in the data pattern by transforming each group in accordance with a specified conversion rule for converting the constituent elements into the same constituent element and storing the reconstructed data pattern in the storage unit;
• wherein in the data pattern judgment step, the data base analyzer performs point rating to judge adequacy of the data pattern according to a preset quantification method and judges validity of the data pattern by comparing points, which are given to the data pattern by the point rating, with the first judgment standard.

A database analysis method by a database analyzer for analyzing a data group stored in an analysis target database by focusing attention on a designated table column in the data,

• the database analyzer including a storage unit storing data,
• the database analysis method comprising:
• a data sorting step executed by the data base analyzer sorting a data group acquired from the analysis target database based on data values of the table column and storing it as analysis target data in the storage unit;
• a data pattern creation step executed by the data base analyzer creating a group for each of the data values based on differences between the data values of the analysis target data and storing a data pattern, which is a collection of the groups, in the storage unit;
• a data pattern judgment step executed by the data base analyzer judging validity of the data pattern stored in the storage unit based on a first judgment standard;
• and
• a data pattern reconstruction step executed, if a negative result is obtained for the validity judgment by the data pattern judgment step, by the data base analyzer reconstructing the data pattern with respect to constituent elements of each group included in the data pattern by transforming each group in accordance with a specified conversion rule for converting the constituent elements into the same constituent element and storing the reconstructed data pattern in the storage unit;
• in the data pattern reconstruction step:
• an exception pattern decision step executed by the database analyzer deciding an exceptional group based on a second judgment standard relating to occurrence frequency or a data structure of each group with respect to groups included in the transformed data pattern after the processing for transforming the data pattern;
• and
• a rejection step executed by the database analyzer storing the exceptional group decided in the exception pattern decision step as an exception pattern in the storage unit and creating a data pattern by removing the exception pattern from the transformed data pattern;
• wherein the database analyzer stores the data pattern, which is created in the rejection step, as a reconstructed data pattern in the storage unit.