DATA STORING, UPDATING, RETRIEVING AND ACCUMULATING METHOD REALIZING RETRIEVAL AND ACCUMULATION ACCELERATION IN DATA WAREHOUSE

摘要

PROBLEM TO BE SOLVED: To eliminate redundancy of data by keeping data items of a mater file as summary record items in preparing summary data and leading processed results requested by a user by the minimum number of operating times. SOLUTION: A main system server 2 adds data to a detail table 202 on the basis of a telegraphic message sent from a client 1, a data extracting part 204 extracts a record established as an actual result value in night processing on that day as detailed updated data 205. Data for summary data update of a data warehouse is also produced as actual results updated data 206 from the data 205. A master record changed on the day is further extracted by referring to the correction date of the master to prepare master change data 207. These prepared data items are maintained as summary data record items, processed results requested by a user are led by the minimum number of operating times and transmitted to a server 3.