Research on database audit scheme design of life insurance industry based on OLAP technology

The database audit is one of important mean to protect the security of database. In the life insurance industry, because of it master a large amount of important customer-related information, it is necessary to database audit. With the increasing of audit records and the requirement of database audit, simple means based audit log data unable to take full advantage of its intrinsic value. Thus, this paper presents a database audit scheme of life insurance industry based on OLAP (Online Analytical Processing) technology. We establish the data warehouse of database audit by designing conceptual model, logical model and ETL (Extraction-Transformation-Loading). On this basis, we use OLAP technology to achieve multi-level audit analysis, which can improve the efficiency and flexibility of database audit work.