摘要 |
A system and method for high speed, high volume tabulation of data using a personal computer. The method involves two sub-processes, pre-processing and tabulation. In pre-processing, the data field is separated into individual field files, and each distinct value in each of the discrete fields is encoded with an incremental numerical code unique for that field. Tabulation of fields involves the creation of a one-dimensional result array in which each cell will contain the result of tabulation of each combination of distinct field values. The encoded files for all requested fields is then read and the relevant cell for each record is incremented, the relevant cell for each record being identified using a mapping algorithm based on the codes of the fields. This method and system allows tabulation to be done at high speed. |