CHARACTER STRING AGGREGATION METHOD FOR NUMERICAL AGGREGATION CALCULATION

摘要

Provided is a method for performing character string aggregation in a multidimensional database. In order to resolve the above problem, provided is a method for aggregating character strings using MOLAP numerical aggregation calculation by way of computer processing such that the method has steps for: preparing a character string management table for managing character strings and, in MOLAP hierarchically structured data, character string fields and number fields corresponding to the character string fields; generating unique character string IDs for the character strings of the character string data in response to inputting of the character string data into the character string fields and storing thereof into the number fields; storing the character string IDs and the character string data into the table for character string management; calculating the aggregate value of the number fields by way of MOLAP numerical aggregation calculation in upper levels of the hierarchically structured data; decomposing the aggregate value into individual character string IDs in the upper levels; and referring to the character string management table to acquire and display character string data corresponding to the decomposed character string IDs.