基于寿险的数据仓库技术研究及其应用

分类号：密级：公开学号：2009231单位代码：10407硕士学位论文论文题目:基于寿险的数据仓库技术研究及其应用研究方向：软件工程专业名称：计算机应用技术研究生姓名：陈其生导师姓名、职称：黄学雨副教授2012年6月4日江西·赣州I摘要随着我国寿险业体制改革的深化，寿险市场呈现了多元化的竞争趋势，并且自从中国加入世界贸易组织后，国外各大寿险企业也纷纷涌入中国，严重的冲击国内寿险市场，如何应对这内外夹击的局势成为了国内各大寿险企业所面临的共同难题。很多企业纷纷加大了对信息化建设的力度以希望提高市场竞争力，其中以企业商业智能为目标的数据仓库构建无疑将企业信息化建设提升到一种新的战略高度，通过构建一个企业全局的数据视图，有效提高了企业内部业务数据的流转效率，从而保障了企业经营决策的制定。本文是以国内某寿险企业实际数据仓库构建项目为背景，对如何构建寿险企业级数据仓库及应用进行了深入的研究。论文首先从国内外寿险数据仓库的研究现状出发，引入了本课题研究的内容及意义。其次，在充分了解寿险相关业务的基础上，利用数据仓库相关技术实现了对寿险数据仓库主题域的分析，提出了一种寿险行业通用的基于层次结构的数据仓库架构体系，并通过对比分析现有数据仓库的实施技术，形成了一套较完整的寿险数据仓库实施方案。论文相关成果已应用于该寿险企业数据仓库系统中，目前该系统运行良好。最后，在基于现有寿险数据仓库平台的基础上，通过对影响寿险客户流失的因素及相关客户流失建模技术的综合分析，最终选择了决策树C5.0算法和树扩展贝叶斯网络分类算法来进行客户流失预测建模，并在基于模型整体精度和增益两个指标上对已构建的模型进行了相应的模型评估及商业应用方面的分析。关键字：数据仓库；OLAP；数据挖掘；客户流失IIAbstractWiththedeepeningofinstitutionalreformintheinsuranceindustry,theinsurancemarketwaspresentingdiversifiedcompetitiontendency.Andatthesametime,sincejoiningtheWTO,manyforeigninsuranceenterprisesbegantopourintoChina;itimpacteddomesticinsurancemarketseriously.Soitbecameacommonproblemforthedomesticinsuranceenterprisesthathowtodealwiththetrappedsituation;Inordertoimprovethemarketcompetitiveness,manycompanieshavesteppeduptheintensityoftheenterpriseinformationalconstruction;Datawarehousewhosetargetisthebusinessintelligence(BI)willbringtheenterpriseinformationconstructiontoanewstrategicperspectiveundoubtedly,itcanimprovethetransferefficiencyoftheenterprise’sinternalbusinessdataeffectively,andguaranteethedecisionoftheenterprisemanagementbyconstructingaglobaldataviews.Basedonanactualconstructionprojectwithdatawarehouseinadomesticlifeinsuranceenterprise,thepaperhascarriedonadeepresearchonhowtobuildtheenterprise-leveldatawarehouseandapplicationaboutlifeinsurance.Firstly,weinquiredintothecurrentresearchaboutdatawarehousebothathomeandabroadsystematically,andintroducedtheresearchcontentandsignificance.Secondly,onbasisofthelifeinsurancebusiness,werealizedthesubjectdomainanalysisofdatawarehouseaboutthelifeinsurance,andputforwardakindofuniversalmultiplayerdatawarehousearchitecturesysteminlifeinsuranceindustry.Andthenbycontrastingtheimplementationtechnologyofdatawarehouse，Formedarelativelycompleteimplementationschemeofdatawarehouse.Therelatedresultsofthepaperhavebeenusedinthedatawarehousesystemofthislifeinsuranceenterprise,atpresent,itworkswell.Afterthat,basedontheexistinglifeinsurancedatawarehouseplatform,wechosetheC5.0algorithmofdecisiontreesandtreeaugmentedBayesianNetworkclassificationalgorithmtobuildcustomerchurnpredictionmodelbyacomprehensivecomparisonofcustomerchurnmodelingtechnologyandfactors,andthenwebegantoundertakecomparativeassessmentaboutthesemodelswiththeindexofaccuracyandgainratio,andclarifiedthecommercialapplicationofthemodelfurther.KeyWords：DataWarehouse;OLAP;DataMining;CustomerChurnIII目录摘要...............................................................................................................................................IAbstract...........................................................................................................................................II目录.............................................................................................................................................III第一章绪论...................................................................................................................................11.1引言....................................................................................................................................11.2国内外研究现状...............................................................................................................11.3研究内容及意义...............................................................................................................21.4本文的组织结构安排.......................................................................................................3第二章数据仓库及数据挖掘技术...............................................................................................52.1数据仓库技术...................................................................................................................52.1.1数据仓库体系结构.................................................................................................52.1.2数据仓库建模技术.................................................................................................62.1.3ETL技术..................................................................................................................82.1.4数据集市.................................................................................................................92.1.5数据仓库实施策略...............................................................................................102.2数据挖掘技术.................................................................................................................122.2.1数据挖掘常用算法分析.......................................................................................122.2.2数据挖掘实施策略...............................................................................................13第三章寿险数