Table look-up method for two-dimensional data table

Abstract

The invention discloses a table look-up method for a two-dimensional data table. The method comprises the steps: obtaining row headers and column headers in a table, wherein each row header and each column header are formed by connecting one or more feature fields in series, and the feature fields are composed of character strings and / or numbers; converting character strings in a row header and a column header of the table into unique identification codes composed of digits, arranging state codes in front of the unique identification codes and the digits respectively, and obtaining the row header and the column header which are represented by the digits and are compatible with the digits and character operation, namely, the compatible row header and the compatible column header; and converting the row header and the column header of the to-be-queried data into a compatible row header and a compatible column header according to the same method, and matching the compatible row header and the compatible column header with the compatible row header and the compatible column header of the table to obtain the to-be-queried data in the table. The row header and the column header containing the character string are input during table look-up, so that the table look-up is visual; by converting the row header and the column header into the compatible row header and the compatible column header, only digital comparison can be carried out during matching, and the table look-up speed is increased.

Description

technical field [0001] The invention belongs to the technical field of life insurance actuarial calculation, and in particular relates to a table look-up method of a two-dimensional data table whose headers of rows and columns are mixed numbers of character strings. Background technique [0002] Actuarial evaluation of life insurance means that insurance companies conduct a series of related assessments, including reserves, solvency, embedded value, etc. An important work and technical means of calculation and / or review of financial results. According to the requirements of relevant laws and regulations, life insurance companies need to regularly calculate the above-mentioned financial results, and report to specific regulatory agencies and / or release to the public. [0003] The life insurance actuarial valuation work needs to use the life insurance actuarial model. The actuarial model usually consists of a series of calculation modules, and the most important basic unit o...

AI Technical Summary

Problems solved by technology

The disadvantage of the first method is that it is very unintuitive and prone to model development and setup errors. Once these errors cause the model to need to be re-run, the loss outweighs the gain

The problem with the second method is that because the character comparison speed is slower than the number comparison speed, and the splicing of strings is also time-consuming, the table lookup speed is slow

However, thousands of such tables may be involved in the life insurance actuarial evaluation process, and each table needs to be queried one by one by the calculation of millions of data points. Therefore, the unsatisfactory table lookup speed may seriously affect the efficiency of life insurance actuarial evaluation

Images