Database structure for a multi stage stochastic optimization based decision support system for asset: liability management of a life insurance company

Abstract

We introduce a stochastic optimization based decision support system (DSS) for asset-liability management of a life insurance firm using a multi-stage, stochastic optimization model. The DSS is based on a multi-stage stochastic linear program (SLP) with recourse for strategic planning. The model can be used with little or no knowledge of management sciences. The model maximizes the expected value of total reserve (policy holders' reserve and shareholders' reserve) at the end of the time period of planning. We discuss the issues related to database design structure, DSS interface design, database updating procedure, and solution reporting