SYSTEM, METHOD, AND PROGRAM FOR BUSINESS INTELLIGENCE USING TABLE OPERATIONS IN A RELATIONAL DATABASE

A data acquiring section specifies individual tables to serve as reference destinations of designated respective foreign key columns and, for each combination of key values in primary key columns of the specified individual tables, acquires a total value of relation values in a designated relation value column. A grouping section groups the respective key values in the primary key columns of the individual tables on the basis of the total value acquired for each combination of the key values in the primary key columns of the individual tables and a statistical model of a designated type. An attribute value column adding section adds, to each individual table, an attribute value column of which attribute value is identification information on a group to which each key value in each primary key column of each individual table belongs.