Data processing system having an integration layer, aggregation layer, and analysis layer, data processing method for the same, program for the same, and computer storage medium for the same

A data processing method for processing an input data to generate a data for analysis using a data processing system, the data processing system including:

• a storage configured to store a database including a data warehouse, an integration layer, an aggregation layer, and an analysis layer;
• and a circuit or hardware processor configured to:
• process a data stored in the database;
• the data processing method comprising, by the circuit or hardware processor:
• a first step of storing all of input data that are input, in the data warehouse included in the database;
• a second step of integrating the input data to generate integrated data, and storing in the database the integrated data in the integration layer;
• a third step of aggregating the integrated data by at least a number of addition items or a number of non-addition items for each of one or more combinations of the non-addition items to generate a plurality of aggregated data, and storing in the database the plurality of aggregated data as an aggregation layer;
• a step of receiving a condition required to select the data for extraction and analysis, the condition being manually set by a user:
• and a fourth step of, using the condition manually set by the user, selecting one aggregated data from the plurality of aggregated data;
• extracting the analysis data from the one aggregated data that was selected, and storing the analysis data in the analysis layer of the database;
• wherein after the fourth step is performed a predetermined plural number of times as a patterned analysis request, the circuit or hardware processor deleting from the aggregation layer, an aggregated data that is not selected for generating the analysis data among the plurality of aggregated data.

A non-transitory computer readable storage medium storing a program operated on a computer controlling a data processing system to allow the data processing system to perform a data processing method for processing an input data to generate a data for analysis, the data processing system including:

• a storage configured to store a database including a data warehouse, an integration layer, an aggregation layer, and an analysis layer;
• and a circuit or hardware processor configured to process a data stored in the database;
• the data processing method comprising:
• a first step of storing all of input data that are input, in the data warehouse included in the database;
• a second step of integrating the input data to generate integrated data, and storing in the database the integrated data in the integration layer;
• a third step of aggregating the integrated data by at least a number of addition items or a number of non-addition items for each of one or more combinations of the 6 non-addition items to generate a plurality of aggregated data, and storing in the database the plurality of aggregated data as an aggregation layer;
• a step of receiving a condition required to select the data for extraction and analysis, the condition being manually set by a user;
• and a fourth step of, using the condition manually set by the user, selecting one aggregated data from the plurality of aggregated data;
• extracting the analysis data from the one aggregated data that was selected, and storing the analysis data in the analysis layer of the database;
• wherein after the fourth step is performed a predetermined plural number of times as a patterned analysis request, the circuit or hardware processor deleting, from the aggregation layer, an aggregated data that is not selected for generating the analysis data among the plurality of aggregated data.