Automatic modeling method and classifier for olap data model

A classifier, comprising:

• a static rule classification module;
• and
• a statistical rule and preset learning rule classification module,
• wherein the static rule classification module is configured to judge the differences between any two sets of query patterns among said at least N sets of query patterns according to static rules,
• wherein the static rules refer to:
• calculating the degree of difference between identical tables in any two sets of query patterns and judging whether the degree of difference between the identical tables is greater than a first preset threshold, and the two sets of query patterns cannot be classified into the same class if the degree of difference is greater than the first preset threshold, where N is a natural number greater than or equal to 1;
• and
• calculating the degree of difference between identical columns in any two sets of query patterns and judging whether the degree of difference is greater than the first preset threshold after the degree of difference between the tables are calculated, and the two sets of query patterns can't be classified into the same class if the degree of difference is greater than the first preset threshold, and
• wherein the statistical rule and preset learning rule classification module is configured to perform clustering of said at least N sets of query patterns according to statistical rules and preset learning rules, after the differences are judged.